connection not establishedd in php

Question

4.00/5 (1 vote)

See more:

I am using the following code but there's some connection error and nothing seems to be working:

PHP

<?php

session_start();
$SESSION[Telephone_No]=[$Telephone_No];
$con=mysql_connect("localhost","root","mysql11");
mysql_connect("pvclub",$con);
$result=mysql_query("Select Telephone_No, Password from register where Telephone_No=\"$Telephone_No\"");
$temp=mysql_fetch_array($result);

if (mysql_num_rows($result)==0)
{
echo "Invalid Entry";
include("homepage.html");
}
else
{
if($temp['Password']==$Password)
{
session_start();
$SESSION['Telephone_No']=$Name;
include("login.php");
}
else
{
echo "Wrong Password";
include("homepage.html");
}
} 
?>

Posted 20-Jul-12 1:54am

Smrng

Add a Solution

Comments

Uday P.Singh 20-Jul-12 9:40am

what is the error message?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shaunak De · Answer 1 · 2012-07-20T03:27:00

There are many things that can go wrong while establishing a connection. Passwords may not match, the server may be down etc.

First make sure the mysql server is up and configured properly. Also that you are using the correct port. [3306 is the default port for Mysql 5] Make sure that your firewall is not blocking that port.

Consider using the "or die()" construct to print the error message. The "die" part will be executed if the connection fails. It will help to debug as to why the connection is failing.

PHP

mysql_connect("localhost", "admin", "1admin") or die(mysql_error());

Some links you may like to read:
Tutorial
Die manual