解析link_mysql的php版

2015-01-24信息快讯网

本篇文章是对link_mysql的php版的实现进行了详细的分析介绍,需要的朋友参考下

<?php
$str_sql_read="select count(*) as num from userinfo";
$str_sql_del="delete from userinfo where id =1";
$res =link_mysql("read",$str_sql_read);
$res_del =link_mysql("delete",$str_sql_del);
echo $res_del."<br/>";
while($row = mysql_fetch_assoc($res))
{
 echo "<font style='font-size:25px;color:red;'>".$row['num']."</font><br/>";
}

?>

<?php function link_mysql($opt,$str_sql) { $con = mysql_connect("localhost","root","root") or die ('Not connected : ' . mysql_error()); mysql_set_charset("gbk",$con); //if you donot know how to use this function,find it defination; mysql_select_db("website",$con); switch($opt){ case "read": $res =mysql_query($str_sql); break; case "update": case "delete": case "insert": $res =mysql_query($str_sql); break; } mysql_close(); return $res; } ?>

©2014-2024 dbsqp.com