Posted By

acosonic on 08/27/09

Tagged

mysql
php

Versions (?)

Last Edited at 08/27/09 02:08am

Statistics

Viewed 992 times

Favorited by 0 user(s)

Related snippets

Mysql query in PHP with proper error detection

/ Published in: PHP

Dumps whole query so developer can see where is error. However it's potential security issue, exposing SQL commands to attacker. (Recommended to use only during development, replace message code with some custom error text)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

$sql="select something from something_else";
$res_id=mysql_query($sql);
if (!$res_id) {
	$message  = 'Invalid query: ' . mysql_error() . "\n";
        $message .= 'Whole query: ' . $sql;
        die($message);
}