SQL Querying Problem
Posted: Mon Apr 04, 2005 12:59 pm
Ok, I'm trying to make a simple signup form so "members" can enter in their info and it will be stored in a database. Here is the page where you enter the info:
And here is the SQL processing page/receipt page:
It's getting errors when it trys to connect and execute the query. I don't get it. I've tried 3 different ways and it doesn't like it. Any ideas? Thanks!

PHENOM | If you are going to post code of any kind, please review Posting Code in the Forums first
Code: Select all
<?php
///START FORM
print ("<FORM ACTION=\"sql-process.php\" METHOD=POST>\n");
print ("Enter your SQL Host, Username, and Password <BR>\n");
print ("<INPUT TYPE=TEXT NAME=\"hostname\" VALUE=\"localhost\"><BR>\n");
print ("<INPUT TYPE=TEXT NAME=\"sql_username\" VALUE=\"sql_username here\"><BR>\n");
print ("<INPUT TYPE=PASSWORD NAME=\"sql_password\"><BR><BR>\n");
print ("Enter your Information below to Sign Up<BR>\n");
///ENTER INFORMATION
///IF NEEDED, DATE COTE BELOW
///$todaysdate = date("yyyy-m-d");
////print ("<INPUT TYPE=HIDDEN NAME=\"Date\" VALUE=\"$todaysdate\">\n");
///USER ID 4 CHARS - FIX THIS FOR AUTO INCREMENTS
print ("<INPUT TYPE=HIDDEN NAME=\"UserID\" VALUE=\"0002\">\n");
print ("Choose a Username (20 Chars. Max)<BR>\n");
print ("<INPUT TYPE=TEXT NAME=\"UserName\"><BR><BR><\n");
print ("Choose a Password (20 Chars. Max)<BR>\n");
print ("<INPUT TYPE=TEXT NAME=\"Password\"><BR><BR><\n");
print ("First Name<BR>\n");
print ("<INPUT TYPE=TEXT NAME=\"FirstName\"><BR><BR><\n");
print ("Last Name<BR>\n");
print ("<INPUT TYPE=TEXT NAME=\"LastName\"><BR><BR><\n");
print ("E-mail address<BR>\n");
print ("<INPUT TYPE=TEXT NAME=\"Email\"><BR><BR><\n");
print ("City<BR>\n");
print ("<INPUT TYPE=TEXT NAME=\"City\"><BR><BR><\n");
///STATE - MAKE A DROP DOWN
print ("Enter your State (2 letters)<BR>\n");
print ("<INPUT TYPE=TEXT NAME=\"State\"><BR><BR><\n");
print ("Phone Number<BR>\n");
print ("<INPUT TYPE=TEXT NAME=\"Phone\"><BR><BR><\n");
///OP SYS - MAKE DROP DOWN
print ("Operating System<BR>\n");
print ("<INPUT TYPE=TEXT NAME=\"OpSys\"><BR><BR><\n");
///SUBMIT
print ("<INPUT TYPE=SUBMIT NAME=\"Submit\" VALUE=\"Connect\">\n");
///END FORM
print ("</FORM><BR>\n");
?>And here is the SQL processing page/receipt page:
Code: Select all
<?php
$host = "$hostname";
$user = "$sql_username";
$pass = "$sql_password";
$DBName = "members";
$TableName = "Members";
$link = mysql_connect ($host, $user, $pass);
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully<BR><BR>';
///BE CAREFUL WITH QUOTES
$todaysdate = date("yyyy-m-d");
$query = "INSERT INTO $TableName (UserID, UserName, CreateDate, Password, FirstName, LastName,
Email, City, State, Phone, OpSys) VALUES '('$UserID', '$UserName', '$todaysdate', '$Password', '$FirstName', '$LastName',
'$Email', '$City', '$State', '$Phone', '$OpSys')'"
///mysql_query($query);
///$thequery = "mysql_query($query)";
if (mysql_db_query ('$DBName', '$query', '$link')) {
echo ("Success! You've joined!<BR>\n");
} else {
echo ("Error! Go back and...fix something!<BR>\n");
}
echo ("Your Query Was:<BR>$query\n");
///KILLS SQL CONNECTION
mysql_close($link);
?>PHENOM | If you are going to post code of any kind, please review Posting Code in the Forums first