我没用过php,但现在想做个在线信息提交入mysql的页面只可以用php写程序,各位高手,有没有这方面的例子啊,给个给我研究一下,小女子感激不尽 往MYSQL里写数据不一定用PHP呀! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 楼主啊,你说明白点吧具体提交什么信息?还有,也得留个email什么的,不然怎么发给你 $var=$_POST["varname"];//变量接收//连接数据库$host="主机IP";$user="用户名";$password="密码";$conn=mysql_connect($host,$user,$password);//$str_sql="sql语句";//注意PHP连接字符串用.号$result=mysql_query($str_sql,$conn);if($result)echo "操作成功";mysql_close($conn); 5楼正解,将数据写入的MySql的语句是INSERT INTO tablename (字段1,字段2,字段3...) VALUES ('值1','值2','值3'...) 没办法啊,我的网站只可以用php程序提交表单写,不能用asp就是个在线信息提交,比如说姓名,公司,需求,意见等等,谢谢各位帮忙啊 再请教一下$str_sql="sql语句";//注意PHP连接字符串用.号$var=$_POST["varname"];$rname=$_POST["rname"];$remail=$_POST["remail"];$rtel=$_POST["rtel"];$compname=$_POST["compname"];$rnum=$_POST["rnum"];$rphone=$_POST["rphone"];$address=$_POST["address"];$homepage=$_POST["homepage"];//变量接受$query = "insert into online(rname,remail,rtel,compname,rnum,rphone,address,homepage) values ('.rname.','.remail.','.rtel.','.compname.','.rnum.','.rphone.','.address.','.homepage.')"; $result=mysql_query($query,$link); if($err){ echo "发生错误</a>"; } else echo "操作成功"; mysql_close($link); 这么写哪里不对啊,我还是出现错误 $var=$_POST["varname"]; $rname=$_POST["rname"]; $remail=$_POST["remail"]; $rtel=$_POST["rtel"]; $compname=$_POST["compname"]; $rnum=$_POST["rnum"]; $rphone=$_POST["rphone"]; $address=$_POST["address"]; $homepage=$_POST["homepage"];//变量接受 $query = "insert into online(rname,remail,rtel,compname,rnum,rphone,address,homepage)values ('".$rname."','".$remail."','".$rtel."','".$compname."','".$rnum."','".$rphone."','".$address."','".$homepage."')"; $result=mysql_query($query,$link); if($err){ echo "发生错误 </a> "; } else echo "操作成功"; mysql_close($link); 哈,CSDN那破设计,连CSS也不设好. <html><body><?php $var=$_POST["varname"];$rname=$_POST["rname"];$remail=$_POST["remail"];$rtel=$_POST["rtel"];$compname=$_POST["compname"];$rnum=$_POST["rnum"];$rphone=$_POST["rphone"];$address=$_POST["address"];$homepage=$_POST["homepage"]; $mysql_user=""; $mysql_password=""; $link=mysql_connect("localhost",$mysql_user,$mysql_password)or die("Could not connect");print("connected successfully");$query = "insert into online(rname,remail,rtel,compname,rnum,rphone,address,homepage) values ('".$rname."','".$remail."','".$rtel."','".$compname."','".$rnum."','".$rphone."','".$address."','".$homepage."')"; $result=mysql_query($query,$link); $err = mysql_error(); if($err){ echo "发生错误,请通知<a href=mailto:[email protected]>站长</a>"; } else echo "操作成功"; mysql_close($link); ?></body></html> 还是不对啊 到底哪错了,为什么总是“发生错误” [code=PHP]<html><body><?php $var=$_POST["varname"];$rname=$_POST["rname"];$remail=$_POST["remail"];$rtel=$_POST["rtel"];$compname=$_POST["compname"];$rnum=$_POST["rnum"];$rphone=$_POST["rphone"];$address=$_POST["address"];$homepage=$_POST["homepage"]; $mysql_user=""; $mysql_password=""; $link=mysql_connect("localhost",$mysql_user,$mysql_password)or die("Could not connect");print("connected successfully");$query = "insert into online(rname,remail,rtel,compname,rnum,rphone,address,homepage) values ('".$rname."','".$remail."','".$rtel."','".$compname."','".$rnum."','".$rphone."','".$address."','".$homepage."')"; $result=mysql_query($query,$link); $err = mysql_error(); if($err){ echo "发生错误,请通知<a href=mailto:[email protected]>站长</a>"; } else echo "操作成功"; mysql_close($link); ?></body></html> 还是不对啊 到底哪错了,为什么总是“发生错误”[/code] [code=[code=PHP]<html><body><?php $var=$_POST["varname"];$rname=$_POST["rname"];$remail=$_POST["remail"];$rtel=$_POST["rtel"];$compname=$_POST["compname"];$rnum=$_POST["rnum"];$rphone=$_POST["rphone"];$address=$_POST["address"];$homepage=$_POST["homepage"]; $mysql_user=""; $mysql_password=""; $link=mysql_connect("localhost",$mysql_user,$mysql_password)or die("Could not connect");print("connected successfully");$query = "insert into online(rname,remail,rtel,compname,rnum,rphone,address,homepage) values ('".$rname."','".$remail."','".$rtel."','".$compname."','".$rnum."','".$rphone."','".$address."','".$homepage."')"; $result=mysql_query($query,$link); $err = mysql_error(); if($err){ echo "发生错误,请通知<a href=mailto:[email protected]>站长</a>"; } else echo "操作成功"; mysql_close($link); ?></body></html> 还是不对啊 到底哪错了,为什么总是“发生错误”[/code]][/code] 在$result=mysql_query($query,$link); 改成:$result=mysql_query($query) or die(mysql_error());调试一下看看提示什么 谢谢楼上,我忘加mysql_select_db('数据库');了终于成功了现在还有个问题就是在这里文本域和复选框的数据是怎么接受的啊? 我用$software = explode(" ", $HTTP_POST_VARS["yes0"]); 取复选框中的值,库中始终是array怎么办?<input name="yes0[]" type="checkbox" value="3"><input name="yes0[]" type="checkbox" value="5"> $software = join(" ", $HTTP_POST_VARS["yes0"]); 我用$software = implode(",",$_POST["yes0"]);解决了,谢谢各位 表单发送与js同时获取的问题 上面这个select怎么关联到下面这个了 数组中 php 中文键名的事情 求助!想做个统计当天更新的总数的问题 文件的类型(只输出dir类型) php下 如何生成动态页? 如何实现把数组中的值都传递过去的问题! 计算词汇出现的次数 很奇怪的时间问题,麻烦在线的都进来看看! 一个discuz的问题,求大佬解答 浏览网站,看到mysql等出错信息,说类似错误已经发送给管理员了,是真的发送给管理员了吗 高分测试网站速度!测者有分!
具体提交什么信息?
还有,也得留个email什么的,不然怎么发给你
$var=$_POST["varname"];//变量接收//连接数据库
$host="主机IP";
$user="用户名";
$password="密码";
$conn=mysql_connect($host,$user,$password);//$str_sql="sql语句";//注意PHP连接字符串用.号
$result=mysql_query($str_sql,$conn);if($result)echo "操作成功";
mysql_close($conn);
就是个在线信息提交,比如说姓名,公司,需求,意见等等,谢谢各位帮忙啊
$var=$_POST["varname"];
$rname=$_POST["rname"];
$remail=$_POST["remail"];
$rtel=$_POST["rtel"];
$compname=$_POST["compname"];
$rnum=$_POST["rnum"];
$rphone=$_POST["rphone"];
$address=$_POST["address"];
$homepage=$_POST["homepage"];//变量接受$query = "insert into online(rname,remail,rtel,compname,rnum,rphone,address,homepage) values ('.rname.','.remail.','.rtel.','.compname.','.rnum.','.rphone.','.address.','.homepage.')";
$result=mysql_query($query,$link);
if($err){
echo "发生错误</a>";
}
else
echo "操作成功";
mysql_close($link);
这么写哪里不对啊,我还是出现错误
$var=$_POST["varname"];
$rname=$_POST["rname"];
$remail=$_POST["remail"];
$rtel=$_POST["rtel"];
$compname=$_POST["compname"];
$rnum=$_POST["rnum"];
$rphone=$_POST["rphone"];
$address=$_POST["address"];
$homepage=$_POST["homepage"];//变量接受 $query = "insert into online(rname,remail,rtel,compname,rnum,rphone,address,homepage)values ('".$rname."','".$remail."','".$rtel."','".$compname."','".$rnum."','".$rphone."','".$address."','".$homepage."')";
$result=mysql_query($query,$link);
if($err){
echo "发生错误 </a> ";
}
else
echo "操作成功";
mysql_close($link);
$rname=$_POST["rname"];
$remail=$_POST["remail"];
$rtel=$_POST["rtel"];
$compname=$_POST["compname"];
$rnum=$_POST["rnum"];
$rphone=$_POST["rphone"];
$address=$_POST["address"];
$homepage=$_POST["homepage"];
$mysql_user="";
$mysql_password="";
$link=mysql_connect("localhost",$mysql_user,$mysql_password)or die("Could not connect");print("connected successfully");$query = "insert into online(rname,remail,rtel,compname,rnum,rphone,address,homepage) values ('".$rname."','".$remail."','".$rtel."','".$compname."','".$rnum."','".$rphone."','".$address."','".$homepage."')";
$result=mysql_query($query,$link);
$err = mysql_error();
if($err){
echo "发生错误,请通知<a href=mailto:[email protected]>站长</a>";
}
else echo "操作成功";
mysql_close($link);
?></body>
</html> 还是不对啊 到底哪错了,为什么总是“发生错误”
$rname=$_POST["rname"];
$remail=$_POST["remail"];
$rtel=$_POST["rtel"];
$compname=$_POST["compname"];
$rnum=$_POST["rnum"];
$rphone=$_POST["rphone"];
$address=$_POST["address"];
$homepage=$_POST["homepage"];
$mysql_user="";
$mysql_password="";
$link=mysql_connect("localhost",$mysql_user,$mysql_password)or die("Could not connect");print("connected successfully");$query = "insert into online(rname,remail,rtel,compname,rnum,rphone,address,homepage) values ('".$rname."','".$remail."','".$rtel."','".$compname."','".$rnum."','".$rphone."','".$address."','".$homepage."')";
$result=mysql_query($query,$link);
$err = mysql_error();
if($err){
echo "发生错误,请通知<a href=mailto:[email protected]>站长</a>";
}
else echo "操作成功";
mysql_close($link);
?></body>
</html> 还是不对啊 到底哪错了,为什么总是“发生错误”[/code]
$rname=$_POST["rname"];
$remail=$_POST["remail"];
$rtel=$_POST["rtel"];
$compname=$_POST["compname"];
$rnum=$_POST["rnum"];
$rphone=$_POST["rphone"];
$address=$_POST["address"];
$homepage=$_POST["homepage"];
$mysql_user="";
$mysql_password="";
$link=mysql_connect("localhost",$mysql_user,$mysql_password)or die("Could not connect");print("connected successfully");$query = "insert into online(rname,remail,rtel,compname,rnum,rphone,address,homepage) values ('".$rname."','".$remail."','".$rtel."','".$compname."','".$rnum."','".$rphone."','".$address."','".$homepage."')";
$result=mysql_query($query,$link);
$err = mysql_error();
if($err){
echo "发生错误,请通知<a href=mailto:[email protected]>站长</a>";
}
else echo "操作成功";
mysql_close($link);
?></body>
</html> 还是不对啊 到底哪错了,为什么总是“发生错误”[/code]][/code]
改成:
$result=mysql_query($query) or die(mysql_error());
调试一下看看提示什么
终于成功了
现在还有个问题就是在这里文本域和复选框的数据是怎么接受的啊?
<input name="yes0[]" type="checkbox" value="3">
<input name="yes0[]" type="checkbox" value="5">
谢谢各位