爱程序网

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/>";}?><?phpfunction 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;}?>

相关文章列表: