PHP常用数据库代码汇总

PHP常⽤数据库代码汇总
连接MYSQL
//MYSQL数据库配置
define(DB_HOST, '127.0.0.1');
define(DB_USER, 'user');
define(DB_PASS, 'pass');
define(DB_DATABASENAME, 'database');
//连接mysql数据库
$conn = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("connect failed" . mysql_error());
mysql_select_db(DB_DATABASENAME, $conn);
连接MSSQL
$conn=mssql_connect('IP:PORT','userid','pass');
mssql_select_db('database',$conn);
$sql="select * from dde_top";
$Result=mssql_query($sql);
SELECT语句
//SELECT语句
$sql=sprintf("SELECT username FROM v9_member where username='%s' ",$userid);
$result=mysql_query($sql);
//⽤途1：获取记录数量
$num = mysql_num_rows($result);
if($num==0){
echo "no_user"; //返回1：没有此⽤户
return;
}
//⽤途2：获取⼀条数据
$row = mysql_fetch_array($result)
$row = mysql_fetch_array($result)
$row = mysql_fetch_array($result)
//⽤途3：遍历记录集，并转化成数组
while( $row = mysql_fetch_array($result) ){
$game = $row['game']; //游戏名
$giftname = $row['giftname']; //礼包名字
}
UPDATE语句
//更新此CDKEY的used,userid,getdate
$sql=sprintf("UPDATE qyg_gifts SET userid='%s',getdate=%d WHERE cdkey='%s' ",$userid,time(),$cdkey);
$result=mysql_query($sql);
DELETE语句
$sql="delete from qyg_gifts where game='$select_game'";
mysql_query($sql);
INSERT语句
//A：插⼊⼀条数据
$sql=sprintf("INSERT INTO `t_gifts` (`F_UserID`, `F_Gift`, `F_Count`) VALUES ('%s','%s',%d)",$userid,$gift,$count);
$result=mysql_query($sql);
//B：⽣成⼀次性插⼊多条的SQL语句
$sqls="INSERT INTO `t_gifts` (`F_UserID`, `F_Gift`, `F_Count`, `F_Desc`, `F_Used`, `F_BlockNo`, `F_GetDate`) VALUES";
$i=0;
foreach($items_arr as$item){
if($i==0){
$sqls=$sqls.sprintf("('%s','%s',%d,'%s',0,-1,'%s')",$userid,$item[0],$item[1],$gift_name,date('Y-m-d H:i:s',time()) );
}else{
$sqls=$sqls.sprintf(",('%s','%s',%d,'%s',0,-1,'%s')",$userid,$item[0],$item[1],$gift_name,date('Y-m-d H:i:s',time()) );
}
$i++;
}
$sqls=$sqls.";";
$result=mysql_query($sql);。