Advanced Search

Return to Snippet

Revision: 1215
at September 26, 2006 06:21 by gdonald
Updated Code 
if( in_array( 'mysql', $GLOBALS[ 'loaded_extensions' ] ) )
{
  if( $GLOBALS[ 'dbHandle' ] = mysql_connect( $GLOBALS[ 'DB_HOST' ],
                                              $GLOBALS[ 'DB_USER' ],
                                              $GLOBALS[ 'DB_PASS' ] ) )
  {
    mysql_select_db( $GLOBALS[ 'DB_DB' ], $GLOBALS[ 'dbHandle' ] );
  }
  else
  {
    die( 'Cannot select database ' . $GLOBALS[ 'DB_DB' ] . ': ' . mysql_error() );
  }
}
elseif( in_array( 'mysqli', $GLOBALS[ 'loaded_extensions' ] ) )
{
  $GLOBALS[ 'dbHandle' ] = mysqli_connect( $GLOBALS[ 'DB_HOST' ],
                                           $GLOBALS[ 'DB_USER' ],
                                           $GLOBALS[ 'DB_PASS' ],
                                           $GLOBALS[ 'DB_DB' ] );

  if( mysqli_connect_errno() )
  {
    die( 'Cannot connect to database ' . mysqli_connect_error() );
  }
}
else
{
  die( 'MySQL extension is not loaded' );
}

Revision: 1214
at September 26, 2006 06:19 by gdonald
Initial Code 
if( in_array( 'mysql', $GLOBALS[ 'loaded_extensions' ] ) )
{
	if( $GLOBALS[ 'dbHandle' ] = mysql_connect( $GLOBALS[ 'DB_HOST' ],
                                              $GLOBALS[ 'DB_USER' ],
                                              $GLOBALS[ 'DB_PASS' ] ) )
  {
		mysql_select_db( $GLOBALS[ 'DB_DB' ], $GLOBALS[ 'dbHandle' ] );
	}
	else
	{
		die( 'Cannot select database ' . $GLOBALS[ 'DB_DB' ] . ': ' . mysql_error() );
	}
}
elseif( in_array( 'mysqli', $GLOBALS[ 'loaded_extensions' ] ) )
{
	$GLOBALS[ 'dbHandle' ] = mysqli_connect( $GLOBALS[ 'DB_HOST' ],
                                           $GLOBALS[ 'DB_USER' ],
                                           $GLOBALS[ 'DB_PASS' ],
                                           $GLOBALS[ 'DB_DB' ] );

  if( mysqli_connect_errno() )
  {
    die( 'Cannot connect to database ' . mysqli_connect_error() );
  }
}
else
{
  die( 'MySQL extension is not loaded' );
}
Initial URL 









Initial Description














Initial Title





php mysql/mysqli connect









Initial Tags





mysql









Initial Language





PHP