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 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 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(); }
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 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 loadByUserRecipe($iUserID, $iRecipeID) { // checks if user has already liked recipe $connection = new Connection(); $sSQL = "SELECT LikeID\n\t\t\t\t FROM tblike\n\t\t\t\t WHERE UserID='" . $connection->escape($iUserID) . "' AND RecipeID='" . $connection->escape($iRecipeID) . "'"; $resultSet = $connection->query($sSQL); $row = $connection->fetch_array($resultSet); if ($row == false) { // user hasn't liked recipe return false; } else { $this->load($row["LikeID"]); return true; } }
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(); }
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 loadByUsername($sUsername) { // checks if username already exists in database $connection = new Connection(); $sSQL = "SELECT UserID\n FROM tbuser\n WHERE Username='******'"; $resultSet = $connection->query($sSQL); $row = $connection->fetch_array($resultSet); if ($row == false) { // if username doesn't exist return false; } else { $this->load($row["UserID"]); // if username exists return true; } }
public function loadByEmail($sEmail) { // checks if email already exists in database $connection = new Connection(); $sSQL = "SELECT SubscriberID\n FROM tbnewsletter\n WHERE Email='" . $connection->escape($sEmail) . "'"; $resultSet = $connection->query($sSQL); $row = $connection->fetch_array($resultSet); if ($row == false) { // if user hasn't subscribed return false; } else { $this->load($row['SubscriberID']); // if user has already subscribed return true; } }
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 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 load($iID) { // open $oConnection = new Connection(); // execute query $sSQL = "SELECT CustomerID, FirstName, LastName, Address, Telephone, Email, Username, Password\n\t\tFROM tbcustomer\n\t\tWHERE CustomerID =" . $oConnection->escape_value($iID); $oResult = $oConnection->query($sSQL); // extract $aCustomer = $oConnection->fetch_array($oResult); $this->iCustomerID = $aCustomer["CustomerID"]; $this->sFirstName = $aCustomer["FirstName"]; $this->sLastName = $aCustomer["LastName"]; $this->sAddress = $aCustomer["Address"]; $this->sTelephone = $aCustomer["Telephone"]; $this->sEmail = $aCustomer["Email"]; $this->sUserName = $aCustomer["Username"]; $this->sPassword = $aCustomer["Password"]; $this->bExisting = true; // close $oConnection->close_connection(); }