Menu
Community /Pin to ProfileBookmark
@NogDogMar 30.2005 — #Can't really say much without any code to look at. The only suggestion I can give right now is to do a lot of defensive coding. This means never assuming anything worked without checking to see if it worked. As an example:
@NogDogMar 30.2005 — #I don't like that comma at the end of the list of columns in the query string.
Also, it's always safer to refer to your form input variables by their full array name, as they may not be accessible by just the form item name, depending on your PHP version and configuration. So I'd write the query:
Similarly, I'd write the first if statement as:
php database problem
I am new to web development, and all the languages related to it. I am trying to make a form connect to a database using php. When I run the script, I get the page saying “Thank you! Information entered.” that I set up, but when I look at my database (I use mysql with phpmyadmin), no information has been received. Any help would be appreciated.
Sign in
to post a comment5 Comments(s) ↴
0
@NogDogMar 30.2005 — #Can't really say much without any code to look at. The only suggestion I can give right now is to do a lot of defensive coding. This means never assuming anything worked without checking to see if it worked. As an example:[code=php]
$connection = mysql_connect('localhost', 'user', 'password');
if(!$connection)
{
die("Error connecting to database: " . mysql_error());
}
$db = mysql_select_db('db_name');
if(!$db)
{
die("Error selecting database: " . mysql_error());
}
$query = "INSERT INTO table_name VALUES('one', 'two', 'three')";
$result = mysql_query($query);
if(!$result)
{
die("Error inserting record: " . mysql_error());
}
if(mysql_num_rows() == 0)
{
die("Error: row was not entered into the database.");
}
[/code]0
@NogDogMar 30.2005 — #I don't like that comma at the end of the list of columns in the query string.Also, it's always safer to refer to your form input variables by their full array name, as they may not be accessible by just the form item name, depending on your PHP version and configuration. So I'd write the query:
[code=php]
$sql = "INSERT INTO visitor (name,age,email) VALUES ('{$_POST['name']}', '{$_POST['age']}', '{$_POST['email']}')";
[/code]Similarly, I'd write the first if statement as:
[code=php]
if (isset($_POST['submit'])) {
[/code]