inserting data to mysql with php

mathieu67 · #1 (**permalink**) 04-15-04, 07:25 PM

can anyone tell me why this script is not inserting the data to my mysql table...

post.php

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?
$name=$_POST['name'];
$email=$_POST['email'];
$phone=$_POST['phone'];
$title=$_POST['title'];
$author=$_POST['author'];
$isbn=$_POST['isbn'];
$university=$_POST['university'];
$condition=$_POST['condition'];
$price=$_POST['price'];

$location="localhost";
$username="your_db_username";
$password="your_db_password";
$database="database_name";
$conn = mysql_connect("$location","$username","$password") ;
if (!$conn) die ("Could not connect MySQL");
mysql_select_db($database,$conn) or die ("Could not open database");
$query = "INSERT INTO table_name(name,email,phone,title,author,isbn,univ ersity,condition,price VALUES('','$name','$email','
phone','title','author','isbn','university','condi tion','price',())";

$result=mysql_query($query);
mysql_close();

</body>
</html>
?>

the_mole001 · #2 (**permalink**) 04-15-04, 11:51 PM

hello mathieu67,

I think your errors lie in the INSERT INTO function. Perhaps if u changed ur code to:

$result = mysql_query("INSERT INTO table_name(name, email, phone, title, author, isbn, university, condition, price) VALUES ('','$name','$email','
phone', 'title', 'author', 'isbn', 'university',' condition', 'price')");

if($result){
echo "entered successfully";
} else {
echo "an error has occured";
}

mysql_close();

just looks a little neater and will show if there was an error entereing information.

Peter

x3m · #3 (**permalink**) 04-16-04, 08:42 AM

This can be wrong mysql configuration.
Try to use
$location="DB_SERVER_IP";
or
$location="127.0.0.1";

---
Ecommerce solutions
http://x3mdev.com