PHP mysql_show_error Examples

Example #1

File: index.php Project: kidwm/kidbox

<?php

define('APP_STARTED', 1);
require './core/lib.php';
if (!($connect = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD))) {
    die('Could not connnet database!');
}
if (!mysql_select_db(DB_NAME, $connect)) {
    mysql_show_error();
}
if (!mysql_query('SET NAMES \'utf8\'')) {
    mysql_show_error();
}
if (!mysql_query('SELECT `member_login` FROM `members` WHERE `id` = 1')) {
    header('location: install.php');
}
session_start();
if (isset($_SESSION['member']['time'])) {
    $_SESSION['member']['time'] = time();
}
if (isset($_GET['do'])) {
    $to = isset($_GET['to']) ? $_GET['to'] : 0;
    $at = isset($_GET['at']) ? $_GET['at'] : 0;
    switch ($_GET['do']) {
        case 'view':
            post_view($to);
            break;
        case 'edit':
            post_edit($to);
            break;
        case 'delete':

Example #2

File: lib.php Project: kidwm/kidbox

function inget($select, $table, $other = '')
{
    global $connect;
    $table = DB_PREFIX . $table;
    $sql = "SELECT {$select} FROM {$table} {$other}";
    if (!($result = mysql_query($sql, $connect))) {
        mysql_show_error('資料庫' . $table . '讀取錯誤');
    }
    return $result;
}