<?php
header("Content-type:text/html;charset=utf-8");
class SqlTool{
protected $host;
protected $user;
protected $pass;
protected $db;
protected $conn;
function __construct($host="localhost",$user="root",$pass="",$db=""){
$this->host=$host;
$this->user=$user;
$this->pass=$pass;
$this->db=$db;
$this->conn=mysql_connect($this->host,$this->user,$this->pass);
if(!$this->conn){
echo "数据库连接失败".mysql_error();
}
mysql_select_db($this->db,$this->conn) or die("数据库选择不正确".mysql_error());
}
function exc_dql($sql){
$res=mysql_query($sql);
if($res && mysql_num_rows($res)>0){
return $res;
}else{
echo"语句查询失败";
return false;
}
}
function exc_dml($sql){
$res=mysql_query($sql);
if($res&&mysql_affected_rows($res)>0){
return $res;
}else{
echo"语句操作失败";
return false;
}
}
function close_conn(){
if($this->conn){
return mysql_close($this->conn);
}
}
}
$sqltool=new SqlTool('localhost','root','123456','skdede');
$sql="select * from dede_addonarticle where aid=19647";
$res=$sqltool->exc_dql($sql);
if($res){
while($row=mysql_fetch_assoc($res)){
echo $row['body'];
}
}
?>
header("Content-type:text/html;charset=utf-8");
class SqlTool{
protected $host;
protected $user;
protected $pass;
protected $db;
protected $conn;
function __construct($host="localhost",$user="root",$pass="",$db=""){
$this->host=$host;
$this->user=$user;
$this->pass=$pass;
$this->db=$db;
$this->conn=mysql_connect($this->host,$this->user,$this->pass);
if(!$this->conn){
echo "数据库连接失败".mysql_error();
}
mysql_select_db($this->db,$this->conn) or die("数据库选择不正确".mysql_error());
}
function exc_dql($sql){
$res=mysql_query($sql);
if($res && mysql_num_rows($res)>0){
return $res;
}else{
echo"语句查询失败";
return false;
}
}
function exc_dml($sql){
$res=mysql_query($sql);
if($res&&mysql_affected_rows($res)>0){
return $res;
}else{
echo"语句操作失败";
return false;
}
}
function close_conn(){
if($this->conn){
return mysql_close($this->conn);
}
}
}
$sqltool=new SqlTool('localhost','root','123456','skdede');
$sql="select * from dede_addonarticle where aid=19647";
$res=$sqltool->exc_dql($sql);
if($res){
while($row=mysql_fetch_assoc($res)){
echo $row['body'];
}
}
?>