PHP高手进来看下吧,不能插入数据到数据库, 也没错误提示
来源:百度知道 编辑:UC知道 时间:2024/07/14 02:43:36
<?php
if (isset($_POST['action']) && $_POST['action'] == 'bookinfo')
{
echo $nam."<br>";
if($ema=="") {$ema="unknow@host.type";}
if($qq=="") {$qq="N/A";}
if($pic=="") {$pho="img\\21.jpg";}
$mysql_server_name="127.0.0.1";
$mysql_username="root";
$mysql_password="123456";
$mysql_database="mingpian";
$sql=" INSERT INTO `mingpian`.`addbook` (`name`,favorite`,`address`,`postcode`,`qq`,`mailbox`,`phone`,`word`,`picurl`)
VALUES ('$nam','$fav','$add','$pos','$qq','$ema','$pho','$wor','$pic' ); ";
print_r($sql);
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
print_r ($conn);
echo "<br>";
mys
if (isset($_POST['action']) && $_POST['action'] == 'bookinfo')
{
echo $nam."<br>";
if($ema=="") {$ema="unknow@host.type";}
if($qq=="") {$qq="N/A";}
if($pic=="") {$pho="img\\21.jpg";}
$mysql_server_name="127.0.0.1";
$mysql_username="root";
$mysql_password="123456";
$mysql_database="mingpian";
$sql=" INSERT INTO `mingpian`.`addbook` (`name`,favorite`,`address`,`postcode`,`qq`,`mailbox`,`phone`,`word`,`picurl`)
VALUES ('$nam','$fav','$add','$pos','$qq','$ema','$pho','$wor','$pic' ); ";
print_r($sql);
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
print_r ($conn);
echo "<br>";
mys
$sql=" INSERT INTO `mingpian`.`addbook` (`name`,favorite`,`address`,`postcode`,`qq`,`mailbox`,`phone`,`word`,`picurl`)
VALUES ('$nam','$fav','$add','$pos','$qq','$ema','$pho','$wor','$pic' ); ";
favorite前面少一个引号
你把SQL语句输出,然后到MYSQL去执行下看
if (isset($_POST['action']) && $_POST['action'] == 'bookinfo')
仔细看看这个判断管用不?
//选择资料库 数据库呢?
mysql_select_db($mysql_database,$conn);
你把错误提示打开没有啊?