4. E - Commerce Website Tutorial - PHP MySQL Inventory Management

http://www.developphp.com
In this 4th video we will create the Inventory management page in the Admin area. List all inventory and make a form and parser for adding new inventory items. The E - Commerce Web Site we will be assembling is one in which all of the inventory is in a MySQL database and we offer a custom PHP cart for a unique shopping experience. It is a site that handles sales, customers, and inventory.

Category:

Education

Tags:

• PHP
• Tutorial
• Dreamweaver
• Commerce
• Shop
• ecommerce
• Web
• Site
• internet
• online
• marketing
• Admin
• Inventory
• Manage
• Store
• CMS
• Learn
• How
• to
• Sell
• Online
• Shopping
• Cart
• PayPal
• Build
• MySQL
• CSS
• HTML
• CS3
• CS4
• CS5
• website
• template
• developphp
• flashbuilding
• adam
• khoury

[SawdyArts]

I have now checked all my code with urs and its all the same, I even took your coding files and uploaded them to my server to see if it worked, and it didn't.

It has worked earlier, but it seems like after I added a product image everything went bad.

But it seems like it would be a mySQL issue... can anyone please answer or direct me to a place where I can find out whats going wrong?

[SawdyArts]

@SawdyArts

Check that.... it still does what it did to begin with where it sends me out in the root/index.php, but every time I clear my cookies it works to get in, but as soon as I add a product it sends me back out again.

I even printed out my code and try to follow Adam's text and see if mine has a fault, but can't find any. I just want to move on, so can anyone please help me...?

[SawdyArts]

I guess I solved it... had to clear my cookies... anyway to not get this issue in the future?

[SawdyArts]

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

if ($existCount == 0) { // evaluate the count header("location: ../index.php"); exit();

}

?>

[SawdyArts]

<?php

session_start();

if(!isset($_SESSION["manager"]­)) { header("location: admin_login.php"); exit();

}

$managerID = preg_replace('#[^0-9]#i','',$_­SESSION["id"]);

$manager = preg_replace('#[^A-Za-z0-9]#i'­,'',$_SESSION["manager"]);

$password = preg_replace('#[^A-Za-z0-9]#i'­,'',$_SESSION["password"]);

include "../storescripts/connect_to_my­sql.php";

$sql = mysql_query("SELECT * FROM admin WHERE id='$managerID' AND username='$manager' AND password='$password' LIMIT 1");

[SawdyArts]

Thank you for a so far great tut!!

I got a bit of a issue, I was able to log in and had everything set-up so I could add files etc.

But all the sudden when I was moving around on the page it kicked me back out to the main index.php. even though I add the "storeadmin" folder to the address it still sends me back to root/index.php

Does anyone know where I added something that would send me out or if it's just the server going bananas?

[BlackRacen]

@blthlt ever heard of pause video ?

[crazytuts0]

What did you mean by "In Jesus Juice?"

Just curious, I thought that was a bit offensive but maybe it wasn't so what did you mean by that?

Thanks for your tutorials btw!

[blthlt]

How are you doing the copy/paste type thing. Do you have a macro type thing or what.

[yaveson]

Hello there, first of all thank you for this amazing series. I was wondering if anyone could help me out. I'm having problems with the code I keep getting this error when I try to add an item to the inventory

Unknown column 'product_name' in 'field list'

I'm sure it's going to be something really obvious, but I'm totally new and I've been trying for a few hours already. Thank you in advanced.