Advanced Search

Return to Snippet

Revision: 17207
at August 27, 2009 02:08 by acosonic
Initial Code 
$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);
}
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
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)

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Mysql query in PHP with proper error detection

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, php

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
PHP