使用PHP连接MySQL并插入$Variables


Connecting to MySQL using PHP and Inserting $Variables

此代码将不起作用-它说我在带有**..的行上出现了意外的T_STRING错误。。这真的很烦我……这可能是一些基本的东西,但我有点笨,所以任何帮助都会很棒!

<?php
$dbhost = 'localhost';
$dbname = 'main';
$dbuser = 'root';
$dbpass = '';
$tbl_name="business";
$country = $_POST['country'];
$name = $_POST['name'];
$business_name= $_POST['business_name'];
$address1= $_POST['address1'];
$address2= $_POST['address2'];
$city= $_POST['city'];
$county= $_POST['county'];
$zip= $_POST['zip'];
$phone = $_POST['phone'];
$web_address = $_POST['web_address'];
$email= $_POST['email'];
$password=$_POST['password'];
$open= $_POST['open'];
$closed= $_POST['closed'];
$description=$_POST['description']
**mysql_connect("$dbhost", "$dbuser", "$dbpass") or die (mysql_error());**
mysql_select_db("$dbname") or die (mysql_error());

$sql_insert = "INSERT INTO $tbl_name VALUES                      ('','$country','$name','$business_name','$address1','$address2','$city','$county','$zip','$    phone','$web_address','$email','$password','$open','$closed','$description');";
$result=mysql_query($sql_insert);
$rows = mysql_num_rows($result);
if($result){
echo "Successful";
echo "<BR>";
}
else {
echo "ERROR";
}
mysql_close();
?>

错误是缺少分号来关闭此行:

$description=$_POST['description']

您需要在$description=$_POST['description'] 之后添加;

这是因为前一行代码中缺少分号:

$description=$_POST['description']

PHP错误消息倾向于给出解析器注意到问题的行号,而不是问题发生的位置。

此处缺少分号。。。

$closed= $_POST['closed'];
$description=$_POST['description']; <------
**mysql_connect("$dbhost", "$dbuser", "$dbpass") or die (mysql_error());**
mysql_select_db("$dbname") or die (mysql_error());