Class to Connect to the database and run a query.

[TheNemesis]

Very basic database connect & run query class etc.

<?php

class Database {
    
    var $conn;
    var $select;
    
    function connect() {
        $this->conn = mysql_connect("localhost","root","") or die("Can't connect. " .mysql_error());
        $this->select = mysql_select_db ("ddl") or die("Can't select" .mysql_error());
        }
        
    function close_db(){
        if(isset($this->conn)){
           mysql_close($this->conn);
            unset($this->conn);
        }
    }
    
   public function query($sql){
        $this->query = mysql_query($sql);
   }
}

?>

Connect via external page:

$database = new Database;
$database->connect(); 

Connect and run query:

$database = new Database;
$database->connect();
$database->query("SELECT * FROM mytable"); 

Connect run query and close db:

$database = new Database;
$database->connect();
$database->query("SELECT * FROM mytable");
$database->close_db();