Very basic database connect & run query class etc.
Connect via external page:
Connect and run query:
Connect run query and close db:
PHP Code:
<?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:
PHP Code:
$database = new Database;
$database->connect();
PHP Code:
$database = new Database;
$database->connect();
$database->query("SELECT * FROM mytable");
PHP Code:
$database = new Database;
$database->connect();
$database->query("SELECT * FROM mytable");
$database->close_db();