\n";
exit;
}
function init ()
{
$user = $this->USER;
$pass = $this->PASS;
$server = $this->SERVER;
$dbase = $this->DBASE;
$conn = mysql_connect($server,$user,$pass);
if(!$conn) {
$this->error("Connection attempt failed");
}
if(!mysql_select_db($dbase,$conn)) {
$this->error("Dbase Select failed");
}
$this->CONN = $conn;
return true;
}
// *****************************************************************
// MySQL Specific methods
// *****************************************************************
function select ($sql="", $column="")
{
if(empty($sql)) { return false; }
if(!eregi("^select",$sql))
{
echo "Wrong function silly!
\n";
return false;
}
if(empty($this->CONN)) { return false; }
$conn = $this->CONN;
$results = mysql_query($sql,$conn);
if( (!$results) or (empty($results)) ) {
mysql_free_result($results);
return false;
}
$count = 0;
$data = array();
while ( $row = mysql_fetch_array($results))
{
$data[$count] = $row;
$count++;
}
mysql_free_result($results);
return $data;
}
function insert ($sql="")
{
if(empty($sql)) { return false; }
if(!eregi("^insert",$sql))
{
echo "Wrong function silly!
\n";
return false;
}
if(empty($this->CONN)) { return false; }
$conn = $this->CONN;
$results = mysql_query($sql,$conn);
if(!$results) { return false; }
$results = mysql_insert_id();
return $results;
}
}
?>
init();
$array = $mysql->select('SELECT name FROM testing');
echo "results
";
$var = $array[0];
echo $var;
?>