将数据插入 mysql 数据库,从 2.6 版到 5.1 版不再有效



我最近从phpmyadmin 2.6升级到5.1,也安装了wamp...我知道很久了。我有一个包含简单变量的网络表单,它们不再插入到我的数据库中

<form method="POST" action="record.php">
 td style="width: 472px">
    <input type=text name=travel size=40 style="color: black;background-color:#FFFF66; width: 270px;"></td>
    </tr>

并插入 php

:::
<?
$travel=$_POST['travel'];
$db="xacall";
$link = mysql_connect("localhost", "sql", "sql");
//$link = mysql_connect("localhost",$_POST['username'],$_POST['password']);
if (! $link)
die("Couldn't connect to MySQL");
mysql_select_db($db , $link) or die("Select Error: ".mysql_error());
$result=mysql_query("INSERT INTO ircb (travel) VALUES ('$travel')")or die("Insert Error: ".mysql_error());
//write to file
$fp = fopen("IR_Call_Entries.txt", "a"); 
fwrite($fp, $_POST['travel'] . "n" . 
close($fp);
?>

我提交,没有收到错误消息。但是什么都没有被写出来,也没有写出来......开机自检错误。我应该使用 GET ???啊,困惑,谢谢我也回显了变量,什么也没显示

将表单用作:

<form method="post" action="record.php">
<td style="width: 472px">
<input type="text" name="travel" size="40" style="color: black;background-color:#FFFF66; width: 270px;"></td>
</tr>

并且还使用以下方法调试后变量: print_r($_POST)

    <?php #Please use full open tag.
    $travel=$_POST['travel'];
    $db='xacall';
    $link = mysql_connect('localhost', 'sql', 'sql') or die("Couldn't connect to MySQL");
    mysql_select_db($db , $link) or die('Select Error: '.mysql_error());
    $result=mysql_query("INSERT INTO ircb (travel) VALUES ('$travel')")or die('Insert Error: '.mysql_error());

   print_r($_POST);
   #write to file
   $fp = fopen('IR_Call_Entries.txt', 'a'); 
   fwrite($fp, $_POST['travel'] . 'n' ; #you had a concat sign here? 
   close($fp);
   ?>

我也尽可能多地使用单引号。

最新更新