简单的操作类
/**
*+-------------------------------
*| @todo mysql 操作类
*+-------------------------------
**/
class MYSQL{
protected $conn;
protected $stmt;
public function __construct($serverName,$userName,$password,$database,$port='3306',$charset="utf8")
{
$server = $serverName.':'.$port;
$this->conn = mysql_connect($server,$userName,$password,true) or die('connect MySQL DB error!');
mysql_select_db($database,$this->conn) or die('select db error!');
mysql_query("set names ".$charset,$this->conn);
}
/**
*+-------------------------------
*| @param $type select,insert,delete,updata
*+-------------------------------
*
**/
public function query($sqlQuery,$type)
{
$this->stmt = mysql_query($sqlQuery);
if($this->stmt)
{
switch ($type) {
case 'select':
$data = array();
while ($row = mysql_fetch_array($this->stmt,MYSQL_ASSOC)) {
$data[] = $row;
}
return $data;
break;
case 'insert':
return mysql_insert_id();
break;
case 'update':
return mysql_affected_rows();
break;
case 'delete':
return mysql_affected_rows();
break;
default:
return "Please,enter '\$type'";
break;
}
}
}
function __destruct(){
@mysql_free_result($this->stmt);
mysql_close($this->conn);
}
}
调用方法
require_once('mysql.class.php');
$njhl = new MYSQL("192.168.1.222","root","test","nj100hl");
$hshdb = new MYSQL("192.168.1.222","root","test","hsh_database");
if(time() >= mktime(12,0,0))
{
$begin = mktime(0,0,0);
$end = mktime(11,59,59);
}
else
{
$begin = mktime(12,0,0,date("m"),date("d")-1,date("Y"));
$end = mktime(23,59,59,date("m"),date("d")-1,date("Y"));
}
$begin = mktime(0,0,0,1,1,2013);
$end = mktime(0,0,0,12,31,2014);
$orderQuery = "select sum(goods.goods_nums) as `goods_nums`,goods.goods_id as `goods_id`
from iwebshop_order_goods as goods left join iwebshop_order as `order` on `order`.id = goods.order_id
where `status` = '5' and unix_timestamp(`order`.completion_time)
between '".$begin."' and '".$end ."' group by goods.goods_id";
$orderResult = $njhl->query($orderQuery,'select');
var_dump($orderResult);
首先
select sum(goods.goods_nums) as `goods_nums`,goods.goods_id as `goods_id`
from iwebshop_order_goods as goods left join iwebshop_order as `order` on `order`.id = goods.order_id
where `status` = '5' and unix_timestamp(`order`.completion_time)
between '1356969600' and '1419955200' group by goods.goods_id
这个语句是可以查询到值得。
不知道为什么var_dump($orderResult) 确是NULL, 可能是实例化同一个类有问题!
不知道这个类该怎么写?