mysql > 基本操作

 

*链接数据库

$db_host = 'localhost';

$db_user = 'root';

$db_pass = '';

$db_name = 'xxx';

$myconn=mysql_connect("$db_host","$db_user","$db_pass"); //连接服务器

mysql_select_db("$db_name",$myconn); //选择操作库

 

* 插入

$sql="INSERT INTO  `score` (

`id` ,

`phone` ,

`score`

)

VALUES (

NULL,  '".$phone."',  '".$score."'

);";

 

mysql_query($sql);

* 查询

$sql="SELECT * FROM  `score` ORDER BY `score` DESC LIMIT 0 , 30"; //先执行SQL语句显示所有记录

$result=mysql_query($sql); //使用mysql_query()发送SQL请求

while($row=mysql_fetch_array($result)) //遍历SQL语句执行结果把值赋给数组

{

echo $row['score'];

}

 

// 如果只查一条数据建议使用mysql_fetch_row

$sql="SELECT `score` FROM  `list`  LIMIT 0 , 1"; 

$result=mysql_query($sql); 

$row=mysql_fetch_row($result); 

echo $row[0];

 

* 删除

DELETE FROM `vpn_account` WHERE `user` = 'abc' AND `pwd` = 'aaa'  LIMIT 1;

 

 

** 获取查询结果条目

1,

$sql = "SELECT  `id` FROM `list` WHERE `phone` = '".$phone."';";

$query = mysql_query($sql);

$num=mysql_num_rows($query);

 

2, 

$sql = "SELECT  COUNT(id) FROM `list` WHERE `phone` = '".$phone."';";

$query = mysql_query($sql);

$num=mysql_fetch_row($query);

echo $num[0];

 

* 更新数据库

$sql = "UPDATE  `list` SET  

`score` =  '101',

`date` =  '2014-09-17' 

WHERE  `id` =60 LIMIT 1 ;";

$query = mysql_query($sql);