简单的操作类

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); } }

调用方法

= 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， 可能是实例化同一个类有问题！
不知道这个类该怎么写？