/** * * @param string $where * @return array 返回数据库查询后的数组: */ function pagination($where, $conn, $tbl_name) { require_once 'class/Config_commodity.php'; require_once 'class/DBpagination.php'; require_once 'class/DBcount.php'; require_once 'class/Info_user.php'; require_once 'class/Config_user.php'; require_once 'Include_picture.php'; //2.向数据库查询符合条件数,以计算显示分页数目 $dbcount = new DBcount($tbl_name, $where); $retval = $dbcount->excute($conn); $row = mysqli_fetch_array($retval, MYSQLI_NUM); $count = 1 + (int) (($row ? $row[0] : 0) / SIZE_EACH_PAGE); //3.计算当前页码; $page = isset($_GET['page']) ? (int) $_GET['page'] : 1; $page = $page > $count ? $count : $page; //4. 查询当前页的数据 $choosed_fields = array(Config_commodity::table_name . '.' . Config_commodity::description, Config_commodity::table_name . '.' . Config_commodity::id, Config_commodity::table_name . '.' . Config_commodity::publisher, Config_commodity::table_name . '.' . Config_commodity::title, Config_commodity::table_name . '.' . Config_commodity::price, Config_commodity::table_name . '.' . Config_commodity::release_date, Config_commodity::table_name . '.' . Config_commodity::praise, Config_commodity::table_name . '.' . Config_commodity::leave_message_time, Config_commodity::table_name . '.' . Config_commodity::id); $DBpagination = new DBpagination($tbl_name, $where, $page, SIZE_EACH_PAGE, $choosed_fields); $reval = $DBpagination->excute($conn); //逐个配置 array 三级关联数组 供界面使用 $array = array(); while (($temp_database_row_array = mysqli_fetch_array($reval, MYSQLI_ASSOC)) != null) { $userinfo = Info_user::get_user_info_by_id($conn, $temp_database_row_array[Config_commodity::publisher]); $array[] = array('imgs' => get_commodity_pic($conn, $temp_database_row_array[Config_commodity::id]), 'description' => $temp_database_row_array[Config_commodity::description], 'title' => $temp_database_row_array[Config_commodity::title], 'price' => $temp_database_row_array[Config_commodity::price], 'url' => 'upload/default.jpg', 'name' => $userinfo[Config_user::log_name], 'time' => get_time($temp_database_row_array[Config_commodity::release_date]), 'star_numbers' => $temp_database_row_array[Config_commodity::praise], 'message_numbers' => $temp_database_row_array[Config_commodity::leave_message_time], 'id' => $temp_database_row_array[Config_commodity::id]); } //5.释放资源 mysqli_free_result($reval); return array('page' => $page, 'array' => $array); }
function show_buy_html($commodity_id, $conn) { require_once 'class/Config_commodity.php'; require_once 'class/DBtraverser.php'; $where = ' where ' . Config_commodity::id . ' = ' . "'" . $commodity_id . "'"; $DBtraverser = new DBtraverser(Config_commodity::table_name, $where); $result = $DBtraverser->excute($conn); $array_commofity_info = mysqli_fetch_array($result, MYSQLI_ASSOC); if ($array_commofity_info) { require_once 'Include_picture.php'; require_once 'class/Info_user.php'; require_once 'class/Config_user.php'; $acceptor_info_array = Info_user::get_user_info_by_id($conn, $_SESSION['CURRENT_LOGIN_ID']); $publisher_info_array = Info_user::get_user_info_by_id($conn, $array_commofity_info[Config_commodity::publisher]); $commodity_array_for_display = array('nickname' => $acceptor_info_array[Config_user::log_name], 'acceptor_phone' => $acceptor_info_array[Config_user::phone_number], 'publisher_name' => $publisher_info_array[Config_user::log_name], 'publisher_phone' => $array_commofity_info[Config_commodity::communication_number], 'title' => $array_commofity_info[Config_commodity::title], 'time' => get_time($array_commofity_info[Config_commodity::release_date]), 'price' => $array_commofity_info[Config_commodity::price], 'description' => $array_commofity_info[Config_commodity::description], 'description_img' => get_one_commodity_pic($conn, $array_commofity_info[Config_commodity::id]), 'img' => 'upload/avatar.png', 'id' => $commodity_id); return $commodity_array_for_display; } }
<?php session_start(); //$_SESSION['CURRENT_LOGIN_ID'] = 1; if (isset($_SESSION['CURRENT_LOGIN_ID'])) { include 'smarty_init.php'; require_once 'class/Info_user.php'; require_once 'class/Config.php'; $conn = Config::connect(); $user_array = Info_user::get_user_info_by_id($conn, $_SESSION['CURRENT_LOGIN_ID']); $my_personal = array('introduction' => $user_array[Config_user::autograph], 'good_buyer' => $user_array[Config_user::payer_credit], 'good_seller' => $user_array[Config_user::seller_credit], 'username' => $user_array[Config_user::legal_name], 'nickname' => $user_array[Config_user::log_name], 'gender' => $user_array[Config_user::sex], 'phone' => $user_array[Config_user::phone_number], 'email' => $user_array[Config_user::email], 'birth' => $user_array[Config_user::birthday], 'good_at' => $user_array[Config_user::strongpoint], 'hobby' => $user_array[Config_user::interestc], 'url_header' => 'upload/avatar.png'); $smarty->assign('my_personal', $my_personal); $smarty->display('My/my-personal.html'); } else { include 'Login.php'; }