PHP Forum

**no1saraefan** · 11-14-2008, 10:57 PM

Ok... i'm just getting started on PHP... and i tried to make my own signup form.. and if anybody could tell me what this error is at the bottom of the form, i'd be greatly appreciative!

**Aaron™** · 11-15-2008, 02:57 AM

Give me your signup.php code and I can help.

**chrishirst** · 11-15-2008, 07:17 AM

You would hardly need the code to tell that the MySQL server the OP tried to connect to doesn't exist.

**Aaron™** · 11-15-2008, 01:16 PM

Well if he is new how would he know what to change, I hardly know anything about PHP when I was new, I got spoon fed for the 1st like 2 months.

**chrishirst** · 11-15-2008, 01:45 PM

Well before even looking at code, it would be advisable to find out whether the OP actually has MySQL available on localhost
because that error usually indicates that it ISN'T!!

**no1saraefan** · 11-15-2008, 04:08 PM

Quote:

Originally Posted by Aaron™

Give me your signup.php code and I can help.

The whole page quote is:
(I did put my login info where it says, except for localhost, which i think is what i need to leave it as...

Code:

<html>
<head>
<title>Sign Up for an Account with White Hill Church!</title>
</head>
<body bgcolor="#3333ff">
<font face="tahoma" color="yellow" size="+1">Welcome to WhiteHillChurch.com!</font><br><br>
<font face="tahoma" color="yellow">Sign up Here:
<br>
<form action="http://www.whitehillchurch.com/php/insert.php" method="post">
First Name: <input type="text" name="first"><br>
Last Name: <input type="text" name="last"><br>
Phone: <input type="text" name="phone"><br>
Mobile: <input type="text" name="mobile"><br>
Fax: <input type="text" name="fax"><br>
E-mail: <input type="text" name="email"><br>
Web: <input type="text" name="web"><br>
<input type="Submit">
</form>
<?
$username="username";
$password="password";
$database="database";

mysql_connect(localhost,$username,$password);
@mysql_select_db($ID) or die( "Unable to select database");
$query="SELECT * FROM contacts";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<b><center>Database Output</center></b><br><br>";

$i=0;
while ($i < $num) {

$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$phone=mysql_result($result,$i,"phone");
$mobile=mysql_result($result,$i,"mobile");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web");

echo "<b>$first $last</b><br>Phone: $phone<br>Mobile: $mobile<br>Fax: $fax<br>E-mail: $email<br>Web: $web<br><hr><br>";

$i++;
}

?>
</body>
</html>

**Aaron™** · 11-15-2008, 04:41 PM

Should be an easy fix, changed the $ID to $database... if it still doesn't work then I am too tired to help you out.

PHP Code:


			
@mysql_select_db($database) or die("");

**gmcalp** · 11-17-2008, 05:49 PM

I know on my host I can't use 'localhost' for the MySQL server name, I have to put in a valid host name (ex: mysql.yourdomain.com), you may be in that same boat.

**CouponGuy** · 12:38 AM

On my host I can use 'localhost'

, but for it to work, you need to add quotes around it. So, change:

Code:

mysql_connect(localhost,$username,$password);

to

Code:

mysql_connect('localhost',$username,$password);

Edit:Er, I guess PHP would still handle it correctly, but I would still pass it as a string, in either single or double quotes, just because it seems to be better practice.

**Aaron™** · 11:22 AM

It was the database he was trying to connect too becuase he has it set to "$ID" instead of "$database" as he has as a variable.

**drakon** · 11-25-2008, 02:26 PM

I assume you are putting valid username and password data into the correct variables?????

**amw_drizz** · 11-26-2008, 10:07 AM

So try this (Culmination form others)

PHP Code:


			


$username="username";

$password="password";

$database="database";

$server = "localhost";



mysql_connect($server,$username,$password);

mysql_select_db($database) or die( "Unable to select database");