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; }