Page 1 of 1

Database class

Posted: Tue Mar 09, 2004 12:30 am
by PrObLeM
I know i should test this but does anyone think this method for a database class will work?

Code: Select all

<?php
function select($what, $db, $where, $where_val)
	{
		$return_array = array();
		$this->connect();
		$result = mysql_query("SELECT $what FROM $db WHERE $where='$where_val'");
		$row = mysql_fetch_object($result);
		$exp_what = explode(", ", $what);
		foreach($exp_what as $var)
		{
			$adding = array_push($return_array, $var=> $row->$var);
			
		}
		return $return_array
		
	}
?>

Posted: Wed Mar 10, 2004 2:11 pm
by Weirdan
Pretty limeted functionality, I'd say. But it likes look it would work. I'd suggest to change this line:

Code: Select all

$result = mysql_query("SELECT $what FROM $db WHERE $where='$where_val'");
to something like:

Code: Select all

$result = mysql_query("SELECT $what FROM $db WHERE $where='$where_val'",$this->connection);
This way you can use your class to connect to different databases and db hosts in one script.