解析link_mysql的php版

181 阅读 0 评论 120 点赞

我是靠谱客的博主鲤鱼花生，最近开发中收集的这篇文章主要介绍解析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;
}
?>