gibigbig Posted December 12, 2007 Share Posted December 12, 2007 ok the expected results are that when i go into index.php, i am supposed to see 2 boxes. whatever i type in both boxes should come up in the database under the fields "username" and "message" but for some reason, only "message" field gets filled when i chack in php my admin. here are my codes, canu tell me what i did wrong? mysql_connect.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <style type="text/css"> <!-- .connected {color:#FFFFFF; font-family:Arial, Helvetica, sans-serif; font-size:10px; background-color:#000000; padding:5px; border:thin #999999; } --> </style> </head> <body> <?php mysql_connect("localhost", "username", "password") or die(mysql_error()); mysql_select_db("database") or die(mysql_error()); echo "<div class='connected'>Connected to MySQL<br />Connected to Database</div>"; ?></body></html> index.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <form action="process.php" method="post"> <p> <input name="username" type="text" /> <p> <textarea name="message" cols="50" rows="10"></textarea><br /><input value="submit message" type="submit" /> </p> </form> </html> process.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body><?php include('mysql_connect.php'); ?> <?php $username = $_POST['username']; $message = $_POST['message']; mysql_query("INSERT INTO Users (username,message) VALUES ('$item','$message')"); echo"message added"; ?> </body> </html> Link to comment https://forums.phpfreaks.com/topic/81282-help-with-php-database/ Share on other sites More sharing options...
mr_mind Posted December 12, 2007 Share Posted December 12, 2007 I compressed all of your files into one to make it easier and i added in error checking. i found that you were inserting $item into the db for username instead of $username but i added in the error checking to show you if anything breaks <html> <head> <title>Inbox</title> </head> <body> <?php if(mysql_connect("localhost", "username", "password")) { if(mysql_select_db("database")) { if(isset($_POST['submit'])) { if(isset($_POST['username']) && isset($_POST['message'])) { $username = mysql_real_escape_string($_POST['username']); $message = mysql_real_escape_string($_POST['message']); if(mysql_query("INSERT INTO Users (username,message) VALUES ('" . $username . "','" . $message . "')")); $noerror = 'Message Sent'; } else { $error = 'Cannot connect to database. Please notify an admin with this error: ' . mysql_error(); } } else { $error = 'You must submit all of the information'; } } else { print '<form action=' . $_SERVER['PHP_SELF'] . ' method=post>'; print '<table>'; print '<tr><td width=100px> User Name: </td><td> <input name=username type=text /> </td></tr>'; print '<tr><td width=100px> Message: </td><td> <textarea name=message cols="50" rows="10"></textarea> </td></tr>'; print '</table>'; print '<input type=submit name=submit value="Send Message" />'; print '</form>'; } } else { $error = 'Cannot connect to database. Please notify an admin with this error: ' . mysql_error(); } } else { $error = 'Cannot connect to database. Please notify an admin with this error: ' . mysql_error(); } ?> </body> </html> Link to comment https://forums.phpfreaks.com/topic/81282-help-with-php-database/#findComment-412516 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.