PHP DataBaseUtil Examples

Example #1

File: DataBaseUtil.class.php Project: AmazingPoint/hot_girl

 public function connect()
 {
     if (!self::$link) {
         self::$link = mysql_connect(self::$host, self::$user, self::$password);
         mysql_set_charset('UTF8');
         if (!self::$link) {
             die('mysql connect error' . mysql_error());
         }
         mysql_selectdb(self::$db, self::$link);
     }
     return self::$link;
 }

Example #2

File: callback.php Project: AmazingPoint/hot_girl

<?php

require_once "./DataBaseUtil.class.php";
require_once "./Response.class.php";
$connect = DataBaseUtil::getInstance()->connect();
/*
* 首页接口 
* http://domain/hotgirl/callback.php?format=xml/json
*/
$page = isset($_REQUEST['page']) ? $_REQUEST['page'] : 1;
$page_number = isset($_REQUEST['page_number']) ? $_REQUEST['page_number'] : 2;
$lim_start = ($page - 1) * $page_number;
$sql = "SELECT * FROM user WHERE is_active=1 LIMIT " . $lim_start . "," . $page_number;
$result = mysql_query($sql, $connect);
if ($result && mysql_num_rows($result) > 0) {
    while ($row = mysql_fetch_assoc($result)) {
        $rows[] = $row;
    }
}
if (!empty($rows)) {
    return Response::api_response(200, 'Success', $rows);
} else {
    return Response::api_response(403, 'No result from database');
}