我有以下代码要插入到我的the服务器的mysql数据库中:
<?php
$connect = mysql_connect("server", "user", "pwd");
$database = "dbname";
@mysql_select_db($database) or die( "Unable to seleact database");
echo 'test1';
if(mysql_connect_errno($connect))
{
echo 'test2';
echo "Failed to connect to MySQL: " . mysql_connect_error();
}
else
{
echo 'test3';
}
$name= isset($_POST['name']) ? $_POST['name'] : '';
$email= isset($_POST['email']) ? $_POST['email'] : '';
echo 'hallo' . $name;
$query = mysql_query($connect, "insert into jagdenwilli(name, email) values ('$name' ,'$email') ");
mysql_close($connect);
?>问题是,在“test1”之后,就没有输出了。同时,对数据库的写入仍然不起作用。有人看到我的错误了吗?
发布于 2014-01-04 21:17:45
The only problem with the previous code is syntax error.
Try these one with connection update :
<?php
$connect = mysql_connect("server", "user", "pwd");
$database = "dbname";
if(! $connect )
{
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_select_db($database);
echo 'test1';
$name= isset($_POST['name']) ? $_POST['name'] : '';
$email= isset($_POST['email']) ? $_POST['email'] : '';
echo 'hallo' . $name;
$query = mysql_query( "INSERT INTO jagdenwilli(name, email)
VALUES ('$name','$email') ");
mysql_close($connect);
?>发布于 2014-01-04 21:07:03
奖金提示:
,您应该始终先看到服务器错误日志。你一定会从那里得到线索的,
试试这个:
<?php
$connect = mysql_connect("server", "user", "pwd");
$database = "dbname";
@mysql_select_db($database) or die( "Unable to seleact database");
echo 'test1';
if(!$connect)
{
echo 'test2';
echo "Failed to connect to MySQL: " .mysql_error();
}
else
{
echo 'test3';
}
$name= isset($_POST['name']) ? $_POST['name'] : '';
$email= isset($_POST['email']) ? $_POST['email'] : '';
echo 'hallo' . $name;
$query = mysql_query($connect, "insert into jagdenwilli(name, email) values ('$name' ,'$email') ");
mysql_close($connect);
?>发布于 2014-01-04 21:04:53
在php中没有函数mysql_connect_errno(),只有一个mysqli_connect_errno用于mysqli
https://stackoverflow.com/questions/20926710
复制相似问题