Advanced Search

php mysql/mysqli query

/ Published in: PHP
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. function sqlQuery( $sql )
  2. {
  3.   if( in_array( 'mysql', $GLOBALS[ 'loaded_extensions' ] ) )
  4.   {
  5.     $query = mysql_query( $sql ) or die(
  6.       "<pre><font color=\"red\"><b>Invalid SQL:</b>\n\n("
  7.       . mysql_errno()
  8.       . ' ) '
  9.       . mysql_error()
  10.       . "\n\n"
  11.       . "<b>Query:</b>\n"
  12.       . eregi_replace( "\t", ' ', $sql )
  13.       . '</font></pre>' );
  14.   }
  15.   elseif( in_array( 'mysqli', $GLOBALS[ 'loaded_extensions' ] ) )
  16.   {
  17.     $query = mysqli_query( $GLOBALS[ 'dbHandle' ], $sql ) or die(
  18.       "<pre><font color=\"red\"><b>Invalid SQL:</b>\n\n("
  19.       . mysqli_errno( $GLOBALS[ 'dbHandle' ] )
  20.       . ' ) '
  21.       . mysqli_error( $GLOBALS[ 'dbHandle' ] )
  22.       . "\n\n"
  23.       . "<b>Query:</b>\n"
  24.       . eregi_replace( "\t", ' ', $sql )
  25.       . '</font></pre>' );
  26.   }
  27.  
  28.   return $query
  29. }

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.