public function load($iUserID) { $connection = new Connection(); $sSQL = "SELECT UserID, FirstName, LastName, Username, Address, Email, Telephone, Password, Admin\n FROM tbuser\n WHERE UserID=" . $iUserID; $resultSet = $connection->query($sSQL); $row = $connection->fetch_array($resultSet); //store data into attributes: $this->iUserID = $row['UserID']; $this->sFirstName = $row['FirstName']; $this->sLastName = $row['LastName']; $this->sUsername = $row['Username']; $this->sAddress = $row['Address']; $this->sEmail = $row['Email']; $this->iTelephone = $row['Telephone']; $this->sPassword = $row['Password']; $this->iAdmin = $row['Admin']; // get all recipe ids of each user: $sSQL = "SELECT RecipeID\n FROM tbrecipe\n WHERE UserID=" . $iUserID; $resultSet = $connection->query($sSQL); while ($row = $connection->fetch_array($resultSet)) { $iRecipeID = $row["RecipeID"]; $oRecipe = new Recipe(); $oRecipe->load($iRecipeID); $this->aRecipes[] = $oRecipe; } $connection->close_connection(); }
public static function get_makes() { //open connection to MySql parent::open_connection(); //initialize arrays $ids = array(); //array for ids $list = array(); //array for objects //query $query = "select mak_id from makes"; //prepare command $command = parent::$connection->prepare($query); //execute command $command->execute(); //link results $command->bind_result($id); //fill ids array while ($command->fetch()) { array_push($ids, $id); } //close command mysqli_stmt_close($command); //close connection parent::close_connection(); //fill object array for ($i = 0; $i < count($ids); $i++) { array_push($list, new Make($ids[$i])); } //return array return $list; }
function __construct() { if (func_num_args() == 0) { $this->id = ''; $this->name = ''; $this->description = ''; $this->dosification = ''; $this->peridiocity = ""; } if (func_num_args() == 1) { $args = func_get_args(); $id = $args[0]; parent::open_connection(); $query = "select schedule_id, schedule_name, schedule_note from Activities_Schedule where schedule_id = ?"; $command = parent::$connection->prepare($query); $command->bind_param('s', $id); $command->execute(); $command->bind_result($this->id, $this->name, $this->description); $found = $command->fetch(); mysqli_stmt_close($command); parent::close_connection(); if (!$found) { throw new RecordNotFoundException(); } } }
public function load($iSubscriberID) { $connection = new Connection(); $sSQL = "SELECT SubscriberID, Email\n FROM tbnewsletter\n WHERE SubscriberID=" . $iSubscriberID; $resultSet = $connection->query($sSQL); $row = $connection->fetch_array($resultSet); //store data into attributes: $this->iSubscriberID = $row['SubscriberID']; $this->sEmail = $row['Email']; $connection->close_connection(); }
public function load($iLikeID) { $connection = new Connection(); $sSQL = "SELECT LikeID, UserID, RecipeID\n\t\t\t FROM tblike\n\t\t\t WHERE LikeID = " . $iLikeID; $resultSet = $connection->query($sSQL); $row = $connection->fetch_array($resultSet); // store into attributes: $this->iLikeID = $row["LikeID"]; $this->iUserID = $row["UserID"]; $this->iRecipeID = $row["RecipeID"]; $connection->close_connection(); }
public static function listAllTypes() { // creates associative array $aRecipeTypes = array(); $connection = new Connection(); $sSQL = "SELECT RecipeTypeID,TypeName\n FROM tbrecipetype\n "; $resultSet = $connection->query($sSQL); while ($row = $connection->fetch_array($resultSet)) { $iRecipeTypeID = $row['RecipeTypeID']; $aRecipeTypes[$iRecipeTypeID] = $row['TypeName']; } $connection->close_connection(); return $aRecipeTypes; }
public static function getAllProducts() { $aAllProducts = array(); $connection = new Connection(); $sSQL = "SELECT ProductID\n FROM tbproduct\n ORDER BY CreatedAt DESC\n "; $resultSet = $connection->query($sSQL); while ($row = $connection->fetch_array($resultSet)) { $iProductID = $row['ProductID']; $oProduct = new Product(); $oProduct->load($iProductID); $aAllProducts[] = $oProduct; } $connection->close_connection(); return $aAllProducts; }
public static function getAllRecipes() { $aAllRecipes = array(); $connection = new Connection(); $sSQL = "SELECT RecipeID\n FROM tbrecipe\n ORDER BY CreatedAt DESC\n "; $resultSet = $connection->query($sSQL); while ($row = $connection->fetch_array($resultSet)) { $iRecipeID = $row['RecipeID']; $oRecipe = new Recipe(); $oRecipe->load($iRecipeID); $aAllRecipes[] = $oRecipe; } $connection->close_connection(); return $aAllRecipes; }
public function load($iProductID) { $connection = new Connection(); $sSQL = "SELECT ProductID, ProductName, Description, Price, Size, Ingredients, StockLevel, ImagePath, CreatedAt\n FROM tbproduct\n WHERE ProductID=" . $iProductID; $resultSet = $connection->query($sSQL); $row = $connection->fetch_array($resultSet); //store into attributes: $this->iProductID = $row["ProductID"]; $this->sProductName = $row["ProductName"]; $this->sDescription = $row["Description"]; $this->fPrice = $row["Price"]; $this->sSize = $row["Size"]; $this->sIngredients = $row["Ingredients"]; $this->iStockLevel = $row["StockLevel"]; $this->sImagePath = $row["ImagePath"]; $this->tCreatedAt = $row["CreatedAt"]; $connection->close_connection(); }
public function load($iID) { // Open $oConnection = new Connection(); // Extract $sSQL = "SELECT ProductID, ProductName, Description, Price, TypeID, PhotoPath\n\t\tFROM tbproduct\n\t\tWHERE ProductID =" . $iID; $oResult = $oConnection->query($sSQL); // fetch $aProduct = $oConnection->fetch_array($oResult); $this->iProductID = $aProduct["ProductID"]; $this->sProductName = $aProduct["ProductName"]; $this->sDescription = $aProduct["Description"]; $this->iCost = $aProduct["Price"]; $this->iTypeID = $aProduct["TypeID"]; $this->sPhotoPath = $aProduct["PhotoPath"]; // close $oConnection->close_connection(); }
public function get_childs() { parent::open_connection(); $ids = array(); $list = array(); $query = "select child_id from Therapies_Therapy_Child where therapy_id = ?"; $command = parent::$connection->prepare($query); $command->bind_param('s', $this->id); $command->execute(); $command->bind_result($id); while ($command->fetch()) { array_push($ids, $id); } mysqli_stmt_close($command); parent::close_connection(); for ($i = 0; $i < count($ids); $i++) { array_push($list, new Child($ids[$i])); } return $list; }
public function load($iOrderID) { $connection = new Connection(); $sSQL = "SELECT OrderID, OrderDate, OrderStatus, RecipientName, DeliveryAddress, BillingAddress, Payment, AccountName, CardNumber, ExpiryDate, Security, UserID\n FROM tborder\n WHERE OrderID=" . $iOrderID; $resultSet = $connection->query($sSQL); $row = $connection->fetch_array($resultSet); //store data in attributes: $this->iOrderID = $row["OrderID"]; $this->tOrderDate = $row["OrderDate"]; $this->sOrderStatus = $row["OrderStatus"]; $this->sRecipientName = $row["RecipientName"]; $this->sDelivery = $row["DeliveryAddress"]; $this->sBilling = $row["BillingAddress"]; $this->sPayment = $row["Payment"]; $this->sAccountName = $row["AccountName"]; $this->iCardNumber = $row["CardNumber"]; $this->sExpiry = $row["ExpiryDate"]; $this->iSecurity = $row["Security"]; $this->iUserID = $row["UserID"]; $connection->close_connection(); }
public function save() { $oConnection = new Connection(); if ($this->bExisting == false) { $sSQL = "INSERT INTO tbcustomer(FirstName, LastName, Address, Telephone, Email, UserName, Password\n\t\t\t\t)\n\t\t\tVALUES (\n\t\t\t\t'" . $oConnection->escape_value($this->sFirstName) . "',\n\t\t\t\t'" . $oConnection->escape_value($this->sLastName) . "',\n\t\t\t\t'" . $oConnection->escape_value($this->sAddress) . "',\n\t\t\t\t'" . $oConnection->escape_value($this->sTelephone) . "',\n\t\t\t\t'" . $oConnection->escape_value($this->sEmail) . "',\n\t\t\t\t'" . $oConnection->escape_value($this->sUserName) . "',\n\t\t\t\t'" . $oConnection->escape_value($this->sPassword) . "'\n\t\t\t\t)"; $bResult = $oConnection->query($sSQL); if ($bResult == true) { $this->iCustomerID = $oConnection->get_insert_id(); $this->bExisting = true; } else { die($sSQL . "failed"); } } else { // updating current customer $sSQL = "UPDATE tbcustomer\n\t\t\tSET FirstName = '" . $oConnection->escape_value($this->sFirstName) . "', \n\t\t\tLastName = '" . $oConnection->escape_value($this->sLastName) . "',\n\t\t\tAddress = '" . $oConnection->escape_value($this->sAddress) . "', \n\t\t\tTelephone = '" . $oConnection->escape_value($this->sTelephone) . "',\n\t\t\tEmail = '" . $oConnection->escape_value($this->sEmail) . "',\n\t\t\tUserName = '******',\n\t\t\tPassword = '******'\n\t\t\tWHERE tbcustomer.CustomerID =" . $oConnection->escape_value($this->iCustomerID); $bResult = $oConnection->query($sSQL); if ($bResult == false) { die($sSQL . "fails"); } } $oConnection->close_connection(); }
function __construct() { //if no arguments received, create empty object if (func_num_args() == 0) { $this->id = ''; $this->name = ''; $this->password = ''; } //if two argument received create object with data if (func_num_args() == 2) { //receive arguments into an array $args = func_get_args(); //get arguments $id = $args[0]; $password = $args[1]; //open connection to MySql parent::open_connection(); //query $query = "select usr_id, usr_name from users\n\t\t\t\t\t\t\t\t\twhere usr_id = ? and usr_password = sha1(?);"; //prepare command $command = parent::$connection->prepare($query); //link parameters $command->bind_param('ss', $id, $password); //execute command $command->execute(); //link results to class attributes $command->bind_result($this->id, $this->name); //fetch data $found = $command->fetch(); //close command mysqli_stmt_close($command); //close connection parent::close_connection(); //if not found throw exception if (!$found) { throw new RecordNotFoundException(); } } }
public function load($iRecipeTypeID) { $connection = new Connection(); $sSQL = "SELECT RecipeTypeID, TypeName, Description, DisplayOrder\n FROM tbrecipetype\n WHERE RecipeTypeID=" . $iRecipeTypeID; $resultSet = $connection->query($sSQL); $row = $connection->fetch_array($resultSet); //store into data attribues: $this->iRecipeTypeID = $row["RecipeTypeID"]; $this->sTypeName = $row["TypeName"]; $this->sDescription = $row["Description"]; $this->iDisplayOrder = $row["DisplayOrder"]; // get all recipe IDs of type: $sSQL = "SELECT RecipeID\n FROM tbrecipe\n WHERE RecipeTypeID=" . $iRecipeTypeID . "\n ORDER BY CreatedAt DESC"; $resultSet = $connection->query($sSQL); while ($row = $connection->fetch_array($resultSet)) { $iRecipeID = $row['RecipeID']; $oRecipe = new Recipe(); $oRecipe->load($iRecipeID); $this->aRecipes[] = $oRecipe; } $connection->close_connection(); }
public function load($iCommentID) { $connection = new Connection(); $sSQL = "SELECT CommentID, Comment, UserID, RecipeID, CreatedAt, OriginalID\n FROM tbcomment\n WHERE CommentID=" . $iCommentID; $resultSet = $connection->query($sSQL); $row = $connection->fetch_array($resultSet); //store data into attributes: $this->iCommentID = $row["CommentID"]; $this->sComment = $row["Comment"]; $this->iUserID = $row["UserID"]; $this->iRecipeID = $row["RecipeID"]; $this->tCreatedAt = $row["CreatedAt"]; $this->iOriginalID = $row["OriginalID"]; $sSQL = "SELECT CommentID \n FROM tbcomment\n WHERE OriginalID=" . $iCommentID; $resultSet = $connection->query($sSQL); while ($row = $connection->fetch_array($resultSet)) { $iCommentID = $row["CommentID"]; $oComment = new Comment(); $oComment->load($iCommentID); $this->aReplies[] = $oComment; } $connection->close_connection(); }
function __construct() { if (func_num_args() == 0) { $this->id = ''; $this->name = ''; } if (func_num_args() == 1) { $args = func_get_args(); $id = $args[0]; parent::open_connection(); $query = "select day_id, day_name from Activities_Days where day_id = ?"; $command = parent::$connection->prepare($query); $command->bind_param('i', $id); $command->execute(); $command->bind_result($this->id, $this->name); $found = $command->fetch(); mysqli_stmt_close($command); parent::close_connection(); if (!$found) { throw new RecordNotFoundException(); } } }
function __construct() { //if no arguments received, create empty object if (func_num_args() == 0) { $this->id = ''; $this->description = ''; } //if one argument received create object with data if (func_num_args() == 1) { //receive arguments into an array $args = func_get_args(); //id $id = $args[0]; //open connection to Mysql parent::open_connection(); //query $query = "select pos_id, pos_description from positions where pos_id = ?"; //prepare command $command = parent::$connection->prepare($query); //link parameters $command->bind_param('s', $id); //execute command $command->execute(); //link results to class attributes $command->bind_result($this->id, $this->description); //fetch data $found = $command->fetch(); //close command mysqli_stmt_close($command); //close connection parent::close_connection(); //if not found throw exception if (!$found) { throw new RecordNotFoundException(); } } }
public function load($iRecipeID) { $connection = new Connection(); $sSQL = "SELECT RecipeID, Title, AuthorNotes, Ingredients, Directions, ImagePath, CreatedAt, UserID, RecipeTypeID\n FROM tbrecipe\n WHERE RecipeID = " . $iRecipeID; $resultSet = $connection->query($sSQL); $row = $connection->fetch_array($resultSet); //store into attributes: $this->iRecipeID = $row["RecipeID"]; $this->sTitle = $row["Title"]; $this->sAuthorNotes = $row["AuthorNotes"]; $this->sIngredients = $row["Ingredients"]; $this->sDirections = $row["Directions"]; $this->sImagePath = $row["ImagePath"]; $this->tCreatedAt = $row["CreatedAt"]; $this->iUserID = $row["UserID"]; $this->iRecipeTypeID = $row["RecipeTypeID"]; // get all likes from recipe: $sSQL = "SELECT LikeID\n FROM tblike\n WHERE RecipeID = " . $iRecipeID; $resultSet = $connection->query($sSQL); while ($row = $connection->fetch_array($resultSet)) { $iLikeID = $row["LikeID"]; $oLike = new Like(); $oLike->load($iLikeID); $this->aLikes[] = $iLikeID; } // get all comments on a recipe: $sSQL = "SELECT CommentID\n FROM tbcomment\n WHERE RecipeID = " . $iRecipeID . " ORDER BY CreatedAt DESC"; $resultSet = $connection->query($sSQL); while ($row = $connection->fetch_array($resultSet)) { $iCommentID = $row["CommentID"]; $oComment = new Comment(); $oComment->load($iCommentID); $this->aComments[] = $oComment; } $connection->close_connection(); }
public function load($iID) { // open $oConnection = new Connection(); // extract $sSQL = "SELECT TypeID, TypeName, Description, DisplayOrder\n\t\tFROM tbproducttype\n\t\tWHERE TypeID=" . $iID; $oResult = $oConnection->query($sSQL); // fetch $aCategory = $oConnection->fetch_array($oResult); $this->iTypeID = $aCategory["TypeID"]; $this->sTypeName = $aCategory["TypeName"]; $this->sDescription = $aCategory["Description"]; $this->iDisplayOrder = $aCategory["DisplayOrder"]; // load products under the category $sSQL = "SELECT ProductID\n\t\tFROM tbproduct\n\t\tWHERE TypeID=" . $iID; $oResult = $oConnection->query($sSQL); while ($aRow = $oConnection->fetch_array($oResult)) { $oProduct = new product(); $oProduct->load($aRow["ProductID"]); $this->aProducts[] = $oProduct; } // close $oConnection->close_connection(); }
function get_car_count($min_year, $max_year, $min_price, $max_price) { //open connection to MySql parent::open_connection(); //query $query = 'select count(*) from cars where car_id_model = ?'; if ($min_year != null) { $query .= ' and car_year >= ' . $min_year; } if ($max_year != null) { $query .= ' and car_year <= ' . $max_year; } if ($min_price != null) { $query .= ' and car_price >= ' . $min_price; } if ($max_price != null) { $query .= ' and car_price <= ' . $max_price; } //prepare command $command = parent::$connection->prepare($query); //parameters $command->bind_param('s', $this->id); //execute command $command->execute(); //link results $command->bind_result($count); //read count $command->fetch(); //close command mysqli_stmt_close($command); //close connection parent::close_connection(); //return count return $count; }
function get_teams() { //open connection to Mysql parent::open_connection(); //initialize array_sum $ids = array(); //array for ids $list = array(); //array for objects //query $query = "select team_id from teams where team_id_div = ?"; //prepare command $command = parent::$connection->prepare($query); //link parameters $command->bind_param('s', $this->id); //execute command $command->execute(); //link results $command->bind_result($id); //fill ids array while ($command->fetch()) { array_push($ids, $id); } //close command mysqli_stmt_close($command); //close connection parent::close_connection(); //fill object array for ($i = 0; $i < count($ids); $i++) { array_push($list, new Team($ids[$i])); } //return array return $list; }
public function get_activities() { parent::open_connection(); $ids = array(); $list = array(); $query = "select schedule_id from Activities_Schedule_Days where schedule_id = ?"; $command = parent::$connection->prepare($query); $command->bind_param('i', $this->id); $command->execute(); $command->bind_result($id); while ($command->fetch()) { array_push($ids, $id); } mysqli_stmt_close($command); parent::close_connection(); for ($i = 0; $i < count($ids); $i++) { array_push($list, new Activity($ids[$i])); } return $list; }
public function get_dosification() { parent::open_connection(); $query = "select dosification from Medicines_Medicine_Child where medicine_id = ?"; $command = parent::$connection->prepare($query); $command->bind_param('s', $this->id); $command->execute(); $command->bind_result($id); $command->fetch(); mysqli_stmt_close($command); parent::close_connection(); return $id; }
public function get_transporter() { parent::open_connection(); $query = "select child_transporter_id from Persons_Child where child_tutor_id = ?"; $command = parent::$connection->prepare($query); $command->bind_param('s', $this->id); $command->execute(); $command->bind_result($id); $command->fetch(); mysqli_stmt_close($command); parent::close_connection(); return $id; }