public function AddToDatabase()
{
$this->DB->Prepare("\n\t\t\tINSERT INTO tblIngredients\n\t\t\t\t(userID, type, title, description, baseIngredientID, createStamp, modifyStamp)\n\t\t\t\tVALUES\n\t\t\t\t(:userID, :type, :title, :description, :baseIngredientID, :createStamp, :modifyStamp)\n\t\t");
$id = $this->DB->Execute(array(":userID" => $this->Session->ID, ":type" => $this->Type, ":title" => $this->Title, ":description" => $this->Description, ":baseIngredientID" => Nullable($this->BaseIngredientID()), ":createStamp" => $this->CreateStamp, ":modifyStamp" => microtime(true)));
if ($id) {
$this->ID = $id;
}
singleLog("Created ingredient #{$id}");
return $id;
}
function ExecuteQuery($query)
{
App::LoadDataClass("MySQLDatabase.php");
$mydb = new MySQLDatabase($this->ConnString);
$mydb->Open();
$result = $mydb->Execute($query);
$this->AffectedRows = $mydb->AffectedRows;
$mydb->Close();
if ($mydb->getError()) {
$this->setError($mydb->getError());
}
return $result;
}
