我在这里发布这个问题之前做了一个研究,我知道它已经被问了几次,但没有一个答案解决了我的问题我正在遵循一个教程,我必须创建2个php页面,第一个连接到sql数据库。
页面名称myfirstphpweb.php编码:
$DBName ='id6_myfirstdb ';
$DBServer='localhost';
$DBUsername='id6_b';
$DBPassword='123456';
$DBConnect= new mysqli($DBServer,$DBUsername,$DBPassword,$DBName);
if($DBConnect->connect_error){
die ("connection failed:". $DBConnect->connect_error);
}
else{ echo "connection Successful! " ;
}
将用户插入数据库的第二页名称: insertusersql.php代码:
include 'myfirstphpweb.php';
$insertusersql="INSERT INTO users (name,password,email,address)
VALUES ('AVALUE','123456','AVALUE@M.com','ALOCATION');";
if($DBConnect ->query($insertusersql)===TRUE){
echo "User added Successfully";
}else{
echo "Some thing is wrong";
}
如果( mysqli_query($DBConnect,$insertusersql)){
但是我得到了错误信息,我把“有些东西是错的”
在mysql phpmyAdmin上,我得到这样的消息:“显示行0- 0.0066 (总共1行,查询耗时0.0066秒。)”
我可以在phpmyAdmin上手动添加用户
我的表有id (int)自动增量主键,name (varchar(70)),password(varchar(70)),email(varchar(70)),address(varchar(200)),registertime(varchar(100)) utf8_unicode_ci
发布于 2018-06-11 05:08:45
include 'myfirstphpweb.php';
$insertusersql="INSERT INTO users (name,password,email,address)
VALUES ('AVALUE','123456','AVALUE@M.com','ALOCATION')";
if($DBConnect->query($insertusersql)===TRUE){
echo "User added Successfully";
}else{
echo "Some thing is wrong";
}
https://stackoverflow.com/questions/50787642
复制相似问题