Here is the error:
And here is the code:Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in D:\Html\Users\userweb10977\Html\admin\products\featuredproducts\add.php on line 15
Code: Select all
<?php
if (!isset($connection)) {
exit;
}
$description = '';
$product = '';
$errors = array();
$query = "SELECT * FROM `products` ORDER BY `product_id`, `id` ASC";
$result = mysql_query($query);
$products = array();
$validProducts = array();
while ($data = mysql_fetch_object($result)) {
$products[] = $data;
$validProducts[] = $data->id;
}
if (!empty($_POST)) {
$product = isset($_POST['product']) ? (int)$_POST['product'] : 0;
$description = isset($_POST['description']) ? $_POST['description'] : '';
if (!empty($_POST['product']) && !empty($_POST['description'])) {
if (!in_array($product, $validProducts)) {
$errors[] = 'An invalid product has been chosen.';
} else {
$query = "INSERT INTO `featured_products` SET `description` = '"
. mysql_real_escape_string($description)
. "', `product_id` = "
. (int)$product;
mysql_query($query);
echo 'Featured product successfully added.';
$success = true;
}
} else {
if (empty($description)) {
$errors[] = 'The description is empty.';
}
if (empty($_POST['product'])) {
$errors[] = 'The product was not given.';
}
}
}
if (!isset($success)) {
$errors = buildErrors($errors);
$categories = array();
$subcategories = array();
$productDropdown = '';
foreach ($products as $product) {
if (!isset($subcategories[$product->subcategory_id])) {
$query = "SELECT * FROM `product_subcategories` WHERE `id` = "
. (int)$product->subcategory_id;
$result = mysql_query($query, $connection);
$subcategories[$product->subcategory_id] = mysql_fetch_object($result);
}
if (!isset($categories[$subcategories[$product->subcategory_id]->category_id])) {
$query = "SELECT * FROM `product_categories` WHERE `id` = "
. (int)$subcategories[$product->subcategory_id]->category_id;
$result = mysql_query($query, $connection);
$categories[$subcategories[$product->subcategory_id]->category_id] = mysql_fetch_object($result);
}
$productDropdown .= '<option value="'
. $product->id
. '">'
. $categories[$subcategories[$product->subcategory_id]->category_id]->title
. ' » '
. $subcategories[$product->subcategory_id]->title
. ' » '
. $product->title
. '</option>';
}
echo <<<FORM
<form action="#" method="post">
{$errors}
<h3>Add a new featured product</h3>
<label for="product">Product</label>
<select name="product">
{$productDropdown}
</select>
<label for="description">Description</label>
<textarea name="description">{$description}</textarea>
<button type="submit">Add</button>
</form>
FORM;
}