segunda-feira, 26 de novembro de 2012

PHP Connect to MySql


<?PHP

define ("DEBUG", true); //to authorize debugging

  function connectSRVBD(){
   
        $host="localhost"; // or IP // Server where database is located
       
        $user="DB_UserName"; //user with rights to connect to database
       
        $pass="DB_Password"; // user password
       
        $schema="DataBase"; // the database name
       
        $port=3306;  //Port by Default ;
       
        $db=mysqli_connect($host, $user, $pass, $schema, $port);
       
        $errorCode=mysqli_connect_errno(); // Mysql - Error Code
        $errorMessage=mysqli_connect_error(); // Mysql - Error Message

        if (DEBUG && $errorCode>0)
            echo "ERROR connectSRVBD : $errorCode : $errorMessage<br>";
                                     
        return $errorCode===0?$db:false;
    }
   
?>