Home » PHP » PHP Examples

PHP code to connect various databases

Connecting with database in PHP: Here, we are going to learn how to connect with the various databases like MySQL, postgres, SQLite, etc?
Submitted by Bhanu Sharma, on September 19, 2019

1) Connecting with MySQL in PHP

<?php
$host = "localhost";
$uname = "username";
$pw = "password";
$db = "newDB";
try {
    $conn = new PDO("mysql:host=$host;dbname=$db", $uname, $pw);
    // set error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "Connected successfully";
}
catch(PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}
?> 

Here, we are using PDO (PHP Data Objects) to create a MySQL connection. We then check if there are any errors. If there are none, we print "connected Successfully" or else, we print "connection failed" followed by the error thrown by PDO.

2) Connecting with postgres in PHP

<?php
$host = "localhost";
$uname = "username";
$pw = "password";
$db = "newDB";
$dbcon = pg_connect("host=$host port=5432 dbname=$db user=$uname password=$pw");
?>

Here, we are using pg_connect() method to connect to a postgres database. We can choose to either define the database details in variables or inline directly.

3) Connecting with SQLite database in PHP

<?php
   class MyDB extends SQLite3 {
      function __construct() {
         $this->open('example.db');
      }
   }   
?>

Here, we are creating a new Class (myDB) which extends to the SQLite3 extension. __construct function is used to create an array that holds the example.db SQLite database.






Comments and Discussions

Ad: Are you a blogger? Join our Blogging forum.





Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates


© https://www.includehelp.com some rights reserved.