简单的操作类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， 可能是实例化同一个类有问题！
不知道这个类该怎么写？
回复内容： 简单的操作类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， 可能是实例化同一个类有问题！
不知道这个类该怎么写？