真惨啊!ASP精通得很,什么程序都能编出来,现在因为特殊原因要会点PHP,先试学了个简单的插入记录操作,死活调试不成功。页面空白也没有什么出错提示,就是写不进数据库!!我的MYSQL数据库已建表如下:
127.0.0.1
库名:test1
表名:user1首页就像ASP的conn方法链接数据库应该怎么写?然后像ASP执行SQL操作的在PHP里又应该怎么写?
例如ASP的插入新记录是这样:
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from user1",conn,1,3
rs.addnew
rs("username")=request.form("username")
rs("password")=request.form("password")
rs.Update
rs.Close
set rs=nothingPHP到底该怎么写啊,我在网上查资料学的是这样写了结果不行:
$conn=mysql_connect ("127.0.0.1", "root", "");
mysql_select_db("test1"); $sql = "INSERT INTO username(username,password) VALUES ('asdfasdfsd111','sdfasdfsadfasdf11')";
mysql_query($sql);
127.0.0.1
库名:test1
表名:user1首页就像ASP的conn方法链接数据库应该怎么写?然后像ASP执行SQL操作的在PHP里又应该怎么写?
例如ASP的插入新记录是这样:
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from user1",conn,1,3
rs.addnew
rs("username")=request.form("username")
rs("password")=request.form("password")
rs.Update
rs.Close
set rs=nothingPHP到底该怎么写啊,我在网上查资料学的是这样写了结果不行:
$conn=mysql_connect ("127.0.0.1", "root", "");
mysql_select_db("test1"); $sql = "INSERT INTO username(username,password) VALUES ('asdfasdfsd111','sdfasdfsadfasdf11')";
mysql_query($sql);
$conn=mysql_connect ("127.0.0.1", "root", "");
mysql_select_db("test1"); $sql = "INSERT INTO user1('username','password') VALUES ('asdfasdfsd111','sdfasdfsadfasdf11')";
mysql_query($sql); 谁来帮检查一下到底正确应该怎样写啊
mysql_select_db("test1"); $sql = "INSERT INTO user1('username','password') VALUES ('asdfasdfsd111','sdfasdfsadfasdf11')";
mysql_query($sql); 代码应该没问题啊,是不是你数据库设置问题啊
id int(11) 否
username varchar(50) gb2312_chinese_ci 是 NULL
password varchar(50) gb2312_chinese_ci 是 NULL