Mysql Database Connection Using PDO?

DB Connection Using PDO $host = "localhost"; $username = "root"; $password = ""; $conn = new PDO("mysql:host=$host;dbname=myDB", $username, $password); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo "Connected successfully";

Advertisements

Mysqli Database Connection Procedural Vs Object-Oriented Way

Procedural Method $host = "localhost"; $username = "root"; $password = ""; $conn = mysqli_connect($host, $username, $password); //connect to server if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Connected successfully"; Object-Oriented Method $host = "localhost"; $username = "root"; $password = ""; $conn = new mysqli($host, $username, $password); //connect to server if ($conn->connect_error) { die("Connection … Continue reading Mysqli Database Connection Procedural Vs Object-Oriented Way