MaggsWeb:7

www.maggsweb.com

MySQL database connection

June 2, 2005 | Comments | MySQL, PHP

This handy little script can be used as a function as required, or in an include. I have used this on virtually every site that uses a a database connection.

?View Code PHP
<?php
$DBHOST = ' ';
$DBNAME = ' ';
$DBUSER = ' ';
$DBPASSWORD = ' ';
 
function dbconnect() {
  global $DBHOST, $DBNAME, $DBUSER, $DBPASSWORD, $DBERROR;
  if (@mysql_pconnect($DBHOST, $DBUSER, $DBPASSWORD)) {
    if (@mysql_select_db($DBNAME)) {
      return true;
    } else {
      echo "ERROR: Cannot select database.";
      exit;
    }
  } else {
    echo "ERROR: Cannot connect to database server.";
    exit;
  }
}
?>
Share this:
  • Print
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • email
  • LinkedIn
  • Twitter

Tagged as: , ,

Write a Comment

Let me know what you think?