/
Include_transaction.php
59 lines (55 loc) · 2.69 KB
/
Include_transaction.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
<?php
function transaction($course_and_reward,$user_id,$page)
{
require_once 'class/Config_transaction.php';
require_once 'class/Config_commodity.php';
require_once 'class/commodity/Commodity_type_Config.php';
require_once 'class/Config.php';
//0.where
if($course_and_reward==Commodity_type_Config::all)
{
$where = ' where '.Config_transaction::table_name.".".
Config_transaction::commodity_buyer_id.'='."'".$user_id."'".
' OR '.Config_transaction::table_name.".".
Config_transaction::commodity_holder_id.'='."'".$user_id."'";
}
else if($course_and_reward==Commodity_type_Config::course)
{
$where = ' where '.Config_transaction::table_name.".".
Config_transaction::commodity_buyer_id.'='."'".$user_id."'";
}
else
{
$where = ' where '.Config_transaction::table_name.".".
Config_transaction::commodity_holder_id.'='."'".$user_id."'";
}
// $where = 'select a.*,b.* from a inner join b on a.id=b.parent_id ';
//1.连接数据库
$conn = Config::connect();//多次使用的数据库连接
//2.向数据库查询符合条件数,以计算显示分页数目
$dbcount = new DBcount(Config_transaction::table_name,$where);
$count = 1+((int)($dbcount->excute($conn)/SIZE_EACH_PAGE));
//3.计算当前页码;
$page = $page<1? 1 : (int)$page;
$page = $page>$count? $count : $page;
//4.分页执行
$query = 'select '.Config_transaction::table_name.".".Config_commodity::commodity_state.','.
Config_commodity::table_name.".".Config_commodity::pic_path.','.
Config_commodity::table_name.".".Config_commodity::course_or_reward.','.
Config_commodity::table_name.".".Config_commodity::description.','.
Config_commodity::table_name.".".Config_commodity::id.','.
Config_commodity::table_name.".".Config_commodity::type.
' from '.Config_transaction::table_name.','.Config_commodity::table_name.' '.
$where.' AND '.Config_commodity::table_name.'.'.Config_commodity::id.'='.
Config_transaction::table_name.'.'.Config_transaction::choosed_id.
' DESC LIMIT '.($page-1)*SIZE_EACH_PAGE.','.SIZE_EACH_PAGE;
$retval = mysqli_query($conn, $query);
$array = array();
while (($temp_database_row_array = mysqli_fetch_array($retval, MYSQLI_ASSOC))!=null) {
//array_push($array, $temp_database_row_array);
//据说以下类似方法效率高一倍
$array[] = $temp_database_row_array;
}
mysqli_close($conn);
mysqli_free_result($retval);
}