Hello! In this post, you will learn to how to write and test the OOP based connection class to mysql database using php. see below..how to do it.. connection.php
|
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 |
<?php /** @author tutorialswebsite *@ copyright 2016 */ class createDBConnection // create a class for make connection { var $host="localhost"; var $username="username"; var $password="password"; var $database="database name"; var $dbconn; function connectToDatabase() //specify the server details for mysql { $conn=mysql_connect($this->host,$this->username,$this->password); if(!$conn)//testing the connection { die("Cannot connect to the database"); }else{ $this->dbconn=$conn; echo "Connection established"; } return $this->dbconn; } function selectDatabase() // selecting the database { //use php inbuild function foer select database mysql_select_db($this->database); if(mysql_error()) // if error occured display the error message { echo "Cannot find the database".$this->database; } echo "Database Selected.."; } function closeConnection() // close the connection { mysql_close($this->dbconn); echo "Connection closed"; } } ?> |
Now you have create the database connection class let’s see…
Expand +