Skip to main content

Simple method to connect database using PHP.

 

 


$servername = "localhost"; $username = "root"; $password = ""; $dbname = "jjmtmain";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} else {
    echo "Connected to database.";
} 


/* In further operations you can use the $conn object for the database connection. 

          For eg.

$q = mysqli_query($conn, "select * from user where email='$userid'");

$r = mysqli_fetch_array($q);

echo $name = $r['name'];

*/

Comments

Popular posts from this blog

PHP INI & ON PAGE ERROR REPORTING

  Enable-Disable on-page error reporting for debugging purpose.   //Turn off error reporting error_reporting(0); //Report runtime errors error_reporting(E_ERROR | E_WARNING | E_PARSE); //Report all errors error_reporting(E_ALL); //Same as error_reporting(E_ALL); ini_set("error_reporting", E_ALL); //Report all errors except E_NOTICE error_reporting(E_ALL & ~E_NOTICE); // Removing memory limit ini_set("memory_limit",-1); //Removing max execution time for php ini_set('max_execution_time', 0);