<code><?php
/**
*+-------------------------------
*| @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);
}
}
</code><code><?php
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);
</code>首先
DM建站系统律师事务所HTML5网站模板, DM企业建站系统。是由php+mysql开发的一套专门用于中小企业网站建设的开源cms。DM系统的理念就是组装，把模板和区块组装起来，产生不同的网站效果。可以用来快速建设一个响应式的企业网站( PC，手机，微信都可以访问)。后台操作简单，维护方便。DM企业建站系统安装步骤：第一步，先用phpmyadmin导入sql文件。 第二步：把文件放到你的本地服务器
0
<code>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
</code>这个语句是可以查询到值得。
不知道为什么var_dump($orderResult) 确是NULL， 可能是实例化同一个类有问题！
不知道这个类该怎么写？
<code><?php
/**
*+-------------------------------
*| @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);
}
}
</code><code><?php
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);
</code>首先
<code>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
</code>这个语句是可以查询到值得。
不知道为什么var_dump($orderResult) 确是NULL， 可能是实例化同一个类有问题！
不知道这个类该怎么写？
PHP怎么学习？PHP怎么入门？PHP在哪学？PHP怎么学才快？不用担心，这里为大家提供了PHP速学教程(入门到精通)，有需要的小伙伴保存下载就能学习啦！
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
466
收藏
