21,893
社区成员




<?php
class db
{
var $conn;
var $db,$user,$pwd,$host;
var $ctype;
var $conectType;
function db($ctype="GB2312" ,$isPc=false)
{
$this->ctype="set names ".$ctype;
$this->db=DB;
$this->pwd=PWD;
$this->user=USER;
$this->host=HOST;
$this->conectType=$isPc;
//pcconect
if(!$this->conectType)
{
$this->conn=mysql_connect($this->host,$this->user,$this->pwd) or die("System initalize faild!");
}
else
{
$this->conn=mysql_pconnect($this->host,$this->user,$this->pwd) or die("System initalize faild!");
}
mysql_select_db($this->db);
mysql_query($this->ctype);
}
function query($sql,$type=1)
{
$result["res"]=mysql_query($sql) or die(mysql_error().$sql);
switch ($type)
{
case 1:
$result["row"]=mysql_num_rows($result["res"]) ;
break;
case 2:
$result["row"]=mysql_affected_rows();
break;
case 3:
$result["row"]=mysql_affected_rows();
$result["insrtID"]=mysql_insert_id();
}
return $result;
}
//执行select操作
function fetch($sql,$type=1)
{
//$this->db($ctype="GB2312" ,$isPc=false)
$res=$this->query($sql);
if($type==1)
{
while ($rs=mysql_fetch_array($res["res"]))
{
$temp["rec"][]=$rs;
}
$temp["row"]=$res["row"];//返回总记录条数
$temp["res"]=$res["res"];
return $temp;
}
else
{
$rs=mysql_fetch_array($res["res"]);
return $rs;
}
}
class MySqlMode {
//连接数据库
function connect() {
$connect = mysql_connect("localhost:3306", "root", "111111");
if (!$connect) {
die("服务器连接失败:" . mysql_error());
}
$conn = mysql_select_db("DBsql", $connect) or die("数据库连接失败!<br/>");
mysql_query("set names utf8");
return $connect;
}
//mysql执行语句
function querySql($sql,$array=2,$fail=false,$succe=false,$suc_href=false){
$result = mysql_query($sql,$this->connect());
if (mysql_affected_rows() > 0){
switch($array){
case 0:
$this->turnInfor($succe,$suc_href);
break;
case 1:
$arry = array();
while($arr = mysql_fetch_array($result,MYSQL_ASSOC)){
array_push($arry,$arr);
}
return $arry;
case 2:
$arr = mysql_fetch_array($result);
return $arr;
default:
return;
}
}else{
$this->turnInfor($fail);
}
mysql_close();
}
//页面跳转提示
function turnInfor($infor=false, $href=false) {
echo "<meta http-equiv='Content-Type' content='text/html; charset=utf-8' />" .
"<script type='text/javascript' language='javascript'>" .
"if('{$infor}' != false)alert('{$infor}');" .
"if('{$href}'){" .
" window.location.href='{$href}';" .
"} else{
history.back();
}" .
"</script>";
exit;
}
}