Hi guys, Ive got the following php script that should connect to my localhost and insert the relevant data however I am responded with an error:
[COLOR=red]"; echo “[/COLOR][[COLOR=red]Back to main page[/COLOR]](file:///F:/Web%202008/Suppleform/Pages/whatwedo.html)[COLOR=red]”; } else { echo “ERROR”; } // close connection mysql_close(); ?>[/COLOR]
[COLOR=#ff0000][/COLOR]
[COLOR=black][/COLOR]
My php script is as follows:
<?php
$host=“localhost”; // Host name
$username=“root”; // Mysql username
$password=“suppleform1”; // Mysql password
$db_name=“test”; // Database name
$tbl_name=“test_mysql”; // Table name
// Connect to server and select database.
mysql_connect("$host", “$username”, “$password”)or die(“cannot connect”);
mysql_select_db("$db_name")or die(“cannot select DB”);
// Get values from form
$name=$_POST[‘name’];
$lastname=$_POST[‘lastname’];
$email=$_POST[‘email’];
// Insert data into mysql
$sql=“INSERT INTO $tbl_name(name, lastname, email)VALUES(’$name’, ‘$lastname’, ‘$email’)”;
$result=mysql_query($sql);
// if successfully insert data into database, displays message “Successful”.
if($result){
echo “Successful”;
echo “<BR>”;
echo “<a href=‘whatwedo.html’>Back to main page</a>”;
}
else {
echo “ERROR”;
}
// close connection
mysql_close();
?>
Anyone have an idea as why I am having this problem? I think I have the code all correct at the moment…?
