发布到mysql w / php时出错 [英] error when posting to mysql w/ php

问题描述

如果有人可以帮助我，我会非常感激。我有点新意，所以不要把我的代码打得太糟糕了！


这是错误：

解析错误：解析错误，第45行/srv/www/htdocs/sendinfo.php中的意外T_VARIABLE


这是代码：

<？php

$ fname = $ _ POST [''fname''];

$ lname = $ _ POST [''lname''];

$ address = $ _ POST [''地址''];

$ address2 = $ _ POST [''address2''];

$ address3 = $ _ POST [''address3''];

$ citye = $ _ POST [''city''];

$ state = $ _ POST [''state''];

$ zip = $ _ POST [''zip''];

$ phone = $ _ POST [''phone''];

$ email = $ _ POST [''电子邮件''];

$ subject ="数据已添加" ;;

$ f*******@YYY.com;

$ ipaddress = $ _SERVER [''REMOTE_ADDR''];


邮件（" XX*@XXX.com" ;, $ subject，"街道地址：$ address\r\\\
City：$ city\r\\\
Zip： $ zip\r\\\
IP：$ ipaddress"，" FROM：$ from\\\\ n"）;

echo"您的IP地址是：$ ipaddress";

？>


<？php

$ username =" XXX";

$ password =" XXXX";

$ database =" XXXX";

$ localhost =" localhost";

$ fname = mysql_escape_string（$ _ POST [''fname'']）;

$ lname = mysql_escape_string（$ _ POST [''lname'']）;

$ address = mysql_escape_string（ $ _POST [''address'']）;

$ address2 = mysql_escape_string（$ _ POST [''address2'']）;

$ address3 = mysql_escape_string（$ _ POST [''address3'']）;

$ city = mysql_escape_string（$ _ POST [''city'']）;

$ state = mysql_escape_string（$ _ POST [' 'state'']）;

$ zip = mysql_escape_string（$ _ PO ST [''zip'']）;

$ phone = mysql_escape_string（$ _ POST [''phone'']）;

$ email = mysql_escape_string（$ _ POST [''email'']）;

$ ipaddress = mysql_escape_string（$ _ SERVER [''REMOTE_ADDR'']

$ conn = mysql_connect（$ localhost，$ username，$ password）或死（无法建立连接）; //这是错误引用的行

mysql_select_db（ $ database，$ conn）或死（无法选择数据库）;

$ query =" INSERT INTO引导VALUES（''$ fname''，''$ lname''， ''$ address''，''$ address2''，''$ address3''，''$ city''，''$'''''''$''，''$ phone''，' '$ email''，$ ipaddress）" ;;

echo $ query;

mysql_query（$ query）或die（" Error：" .mysql_error（） ）;

mysql_close（）;

？>

If someone can help me out with this i would really appreciate it. I''m kind of new so don''t bash my code too bad!!

This is the error:
Parse error: parse error, unexpected T_VARIABLE in /srv/www/htdocs/sendinfo.php on line 45

This is the code:
<?php
$fname=$_POST[''fname''];
$lname=$_POST[''lname''];
$address=$_POST[''address''];
$address2=$_POST[''address2''];
$address3=$_POST[''address3''];
$citye=$_POST[''city''];
$state=$_POST[''state''];
$zip=$_POST[''zip''];
$phone=$_POST[''phone''];
$email=$_POST[''email''];
$subject="Data Added";
$f*******@YYY.com;
$ipaddress = $_SERVER[''REMOTE_ADDR''];

mail("XX*@XXX.com",$subject, "Street Address: $address\r\nCity:$city\r\nZip: $zip\r\nIP: $ipaddress", "FROM: $from\r\n");
echo "Your IP address is: $ipaddress";
?>

<?php
$username="XXX";
$password="XXXX";
$database="XXXX";
$localhost="localhost";
$fname= mysql_escape_string($_POST[''fname'']);
$lname= mysql_escape_string($_POST[''lname'']);
$address= mysql_escape_string($_POST[''address'']);
$address2= mysql_escape_string($_POST[''address2'']);
$address3= mysql_escape_string($_POST[''address3'']);
$city= mysql_escape_string($_POST[''city'']);
$state= mysql_escape_string($_POST[''state'']);
$zip= mysql_escape_string($_POST[''zip'']);
$phone= mysql_escape_string($_POST[''phone'']);
$email= mysql_escape_string($_POST[''email'']);
$ipaddress=mysql_escape_string($_SERVER[''REMOTE_ADDR'']
$conn=mysql_connect($localhost, $username, $password) or die("Unable to setup connection"); //This is the line the error is referencing
mysql_select_db($database,$conn) or die( "Unable to select database");
$query = "INSERT INTO leads VALUES(''$fname'',''$lname'',''$address'',''$address2'',''$ address3'',''$city'',''$state'',''$zip'',''$phone'',''$email '',$ipaddress)";
echo $query;
mysql_query($query) or die("Error: ".mysql_error());
mysql_close();
?>

推荐答案

fname =

_POST [''fname''];

_POST[''fname''];

lname =

这篇关于发布到mysql w / php时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！