PHP 数据库操作问题

Question

建好了数据库名 shop
表名 tb_user
字段名 ID   int
       USERNAME VARCHAR
       USERPASS  VARCHAR
       USEREMAIL  VARCHAR要实现 插入一条数据怎么做
$UserId=1;
$UserName="admin"; 
$UserPass="123";
$UserEmail="[email protected]";$con=mysql_connect("localhost", "root", ""); //我密码为 空
mysql_select_db("shop");
$exec="insert into tb_user values(".$UserId.",".$UserName.",".$UserPass.",".$UserEmail.")";
$result=mysql_query($exec);
$rs=mysql_fetch_object($result);mysql_close();只会怎么写查询的，改为 insert 的 sql 就不行了，请大侠指点哈，还有要补充下 update 和 delete 的sql 程序

Answer 1

$exec="insert into tb_user values('".$UserId."','".$UserName."','".$UserPass."','".$UserEmail."')";
需要加单引号，如果你的userid是自增字段，可以不填。

Answer 2

$exec="insert into tb_user values(".$UserId.",'".$UserName."','".$UserPass."','".$UserEmail."')";试试改成这样。
SQL是基本功，要反复练习

Answer 3

insert into tb_user(字段名呢？) values(....)

Answer 4

$exec="insert into tb_user values(".$UserId.",".$UserName.",".$UserPass.",".$UserEmail.")";-----改成：$exec="insert into tb_user values($UserId,'$UserName','$UserPass','$UserEmail')";
如果ID为自增主键字段,省略不写.
这样子：$exec="insert into tb_user values('$UserName','$UserPass','$UserEmail')";
如果表tb_user还有其它字段,则需指明所要写入的字段:
$exec="insert into tb_user(字段1,.....) values($UserId,'$UserName','$UserPass','$UserEmail')";

Answer 5

以后不会写的sql语句自己在myadmin里先操作一遍！就会有相应的SQL语句出来的！不过自己还是要掌握的啦~

Answer 6

$exec="insert into tb_user values('$UserName','$UserPass','$UserEmail')"

Answer 7

$UserId=1;
$UserName="admin";  
$UserPass="123";
$UserEmail="[email protected]";$con=mysql_connect("localhost", "root", "","shop"); //我密码为 空
$exec="insert into tb_user(ID,USERNAME,USERPASS,USEREMAIL) values($UserId,$UserName,$UserPass,$UserEmail)";
$result=mysql_query($exec);
$rs=mysql_fetch_object($result);mysql_close();

Answer 8

DELETE的：
$UserId=1;
$UserName="admin";  
$UserPass="123";
$UserEmail="[email protected]";$con=mysql_connect("localhost", "root", "","shop"); //我密码为 空
$exec="DELETE FROM  tb_user WHERE ID=$UserId;";
$result=mysql_query($exec);
$rs=mysql_fetch_object($result);mysql_close();

Answer 9

UPDATE的
$UserId=1;
$UserName="admin";  
$UserPass="123";
$UserEmail="[email protected]";$con=mysql_connect("localhost", "root", "","shop"); //我密码为 空
$exec="UPDATE tb_user SET ID=$UserId,USERNAME=$UserName,USERPASS=$UserPass,USEREMAIL=$UserEmail;";
$result=mysql_query($exec);
$rs=mysql_fetch_object($result);mysql_close();