iadmin/connection.php at master · rudy232/iadmin · GitHub

1
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
<?php

class createConnection 				//create a class for make connection
{
    var $host="localhost";
    var $username="root";    			// specify the sever details for mysql
    Var $password="";
    var $database="";

    var $myconn;


    function connectToDatabase() 		// create a function for connect database
    {
        $conn= mysql_connect($this->host,$this->username,$this->password);

        if(!$conn)// testing the connection
        {
            die ("Cannot connect to the database");
        }

        else
        {

            $this->myconn = $conn;

						//            echo "Connection established";

        }

        return $this->myconn;

    }

    function selectDatabase() 			// selecting the database.
    {
        mysql_select_db($this->database);  	//use php inbuild functions for select 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->myconn);

						//        echo "Connection closed";
    }

}

?>