database class - update
Jeg har fået fat i en database class - men mangler en funktion i den. Kan jeg få noget hjælp? Den mangler at kunne opdatereFilen ser sådan ud:
<?php
/**
* Kill the objects when query has been made
*
*
*/
class Database
{
// localhost test env (kommentér når du uploader):
var $dbHost="localhost";
var $dbName="kost";
var $dbUser="ho";
var $dbPass="kost";
// online host env (kommentér når du tester på localhost):
/* var $dbHost="";
var $dbName="";
var $dbUser="";
var $dbPass="";*/
var $dbType;
var $dbResult;
function Database($dbType)
{
$this->dbType = $dbType;
}
function query($sql, $returnType)
{
$conn = $this->priv_openDbCon();
$this->priv_selectDb();
$rs = $this->priv_sqlQuery($sql);
switch($returnType)
{
case "rows":
while($arr = mysql_fetch_row($rs)) $array[] = $arr;
return $array;
break;
case "lmnt":
$data = mysql_fetch_row($rs);
return $data[0];
break;
case "update":
break;
case "insert":
case "replace":
case "delete":
return $result;
break;
}
unset($rs);
mysql_close($conn);
}
function priv_openDbCon()
{
$dbCon = mysql_connect($this->dbHost, $this->dbUser, $this->dbPass);
if(!$dbCon) return "Connection Error: Unable to Connect!\n";
else return $dbCon;
}
function priv_selectDb()
{
mysql_select_db($this->dbName)
or die("Db error: Unable to Select!\n");
}
function priv_sqlQuery($sql)
{
$sqlOutput = mysql_query($sql)
or die("Query error: Unable to Query!");
return $sqlOutput;
unset($sqlOutput);
}
}
?>
