inventory add page

zeusthegreat · October 12, 2011

when i place a product in my db with all its details

and click upload

the item loads to the database and arrives a a http 404 page not found.

but the page does not deliever back to the inventory form but instead goes to a http 404 not found, does this mean i have not linked my inventory page when item uploaded,to arrive back at my inventory page to see that the details are there.

here is the code

<?php

session_start();

if(!isset($_SESSION["manager"])){

header("location: admin_login.php");

exit();

}

// Be sure to check that this manager SESSION value is in fact in the database

$managerID = preg_replace('#[^0-9]#i','', $_SESSION["id"]); //filter everyhting but numbers and letters

$manager = preg_replace('#[^A-Za-z0-9]#i','', $_SESSION["manager"]); //filter everything but numbers and letters

$password = preg_replace('#[^A-Za-z0-9]#i','', $_SESSION["password"]); //filter everything but numbers and letters

//Run mySQL query to be sure that this person is an admin and that their password session varequals the database information

//Connect to the MySQL database

include "../storescripts/connect_to_mysql.php";

$sql= mysql_query("SELECT * FROM admin WHERE id= '$managerID' AND username= '$manager' AND password= '$password' LIMIT 1"); //query the person --make sure person exists in database----

$existCount= mysql_num_rows($sql); //count the row nums

if($existCount == 0){ //evaluate the count

header("location: ../index.php");

exit();

}

?>

<?php

//error reporting

error_reporting(E_ALL);

ini_set('display_errors', '1');

?>

<?php

// Delete Item Question to admin, and Delete product

if (isset($_GET['deleteid'])){

echo 'Do you really want to delete produst with ID of'.$_GET['deleteid'] .'? <a href="inventory_list.php?yesdelete=' .$_GET['deleteid'] .'">Yes</a>/<a href="inventory_list.php">No</a>';

exit();

}

if (isset($_GET['yesdelete'])){

//remove item from system and delete its picture if they choose

//delete from database

$id_to_delete=$_GET['yesdelete'];

$sql=mysql_query("DELETE FROM products WHERE id='$id_to_delete' LIMIT 1")or die (mysql_error());

//unlink the image from server

// Remove The Pic------------------------------------

$pictodelete=("../inventory_images/$id_to_delete.jpg");

if (file_exists($pictodelete)){

unlink($pictodelete);

}

header("location:inventory_list.php");

exit();

}

?>

<?php

//parse the form data and add inventory item to the system

if (isset($_POST['product_name'])) {

$product_name = mysql_real_escape_string($_POST['product_name']);

$price = mysql_real_escape_string($_POST['price']);

$category = mysql_real_escape_string($_POST['category']);

$subcategory = mysql_real_escape_string($_POST['subcategory']);

$details = mysql_real_escape_string($_POST['details']);

//see if that product name is an identical match to another product in the system

$sql = mysql_query("SELECT id FROM products WHERE product_name='$product_name' LIMIT 1");

$productMatch = mysql_num_rows ($sql); //count the output ammount

if ($productMatch > 0){

echo 'Sorry you tried to place a duplicate "Product Name" into the system, <a href="inventory_list.php">click here</a>';

exit();

//Add this product into the database now

}

$sql = mysql_query("INSERT INTO products(product_name, price, details, category, subcategory, date_added) VALUES('$product_name','$price','$details','$category','$subcategory',now())") or die (mysql_error()); //now adds todays date

$pid = mysql_insert_id();

//place image in the folder

$newname = "$pid.jpg";

move_uploaded_file( $_FILES['fileField']['tmp_name'], "../inventory_images/$newname");

header("location: admin_login_list.php");

exit();

}

?>

<?php

//This block grabs the whole list for viewing

$product_list = "";

$sql = mysql_query("SELECT * FROM products");

$productCount = mysql_num_rows($sql);//count the the output ammount

if ($productCount > 0){

while($row = mysql_fetch_array($sql)){

$id = $row["id"];

$price = $row["price"];

$product_name = $row["product_name"];

$date_added = strftime("%b %d, %Y", strtotime($row["date_Added"])); // Notice here how we changed it from _added to _Added

$product_list .= "$id - $product_name - £$price - $date_added <a href='inventory_edit.phppid=$id'>edit</a>••<a href='inventory_list.php?deleteid=$id'> delete</a><br/>";

}

}else{

$product_list = "You have no products listed in your store Yet";

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Inventory list</title>

body {

background-color: #FFF;

}

</style>

</head>

<body>

<?php include_once("../template_header.php"); ?>

<?php include_once("../template_sidebar.php"); ?>

<div align="right"style="margin-right:32px"><a href="inventory_list.php#inventoryForm">+Add New Inventory Item</a></div>

<h2>Inventory List</h2>

<?php echo $product_list; ?>

</div>

<hr />

<div>

↓ Add New Inventory Item Form ↓

</h3>

</div>

<tr>

<td width="20%" align="right">Product Name</td>

</label></td>

</tr>

<tr>

<td align="right">Product Price</td>

$

</label></td>

</tr>

<tr>

<td align="right">Category</td>

<option value=Clothing" > Clothing</option>

</select>

</label></td>

</tr>

<tr>

<td align="right">Subcategory</td>

<option value="Pants">Pants</option>

<option value="Shirts">Shirts</option>

</select></td>

</tr>

<tr>

<td align="right">Product Details</td>

</label></td>

</tr>

<tr>

<td align="right">Product Image</td>

</label></td>

</tr>

<tr>

</label></td>

</tr>

</table>

</form>

<br/>

</div>

<?php include_once("../template_footer.php"); ?>

</div>

</body>

</html>

Edited October 12, 2011 by talos

zeusthegreat · October 12, 2011

I have resolved this guys and tryed to find a delete button but no joy!

Sign In

inventory add page

Recommended Posts

zeusthegreat

zeusthegreat

Join the conversation

Browse

Activity

Store

Support