Series: http://www.developphp.com/video/PHP#eCommerce-Website-Tutorial Source Download: http://www.developphp.com/video/PHP/PayPal-IPN-PHP-Instant-Payment-Notification-Script In this 4th video…
Original source
Series: http://www.developphp.com/video/PHP#eCommerce-Website-Tutorial Source Download: http://www.developphp.com/video/PHP/PayPal-IPN-PHP-Instant-Payment-Notification-Script In this 4th video…
Original source
32 responses to “4. E – Commerce Website Tutorial – PHP MySQL Inventory Management”
Not .data table connection with MySQL sever. please post database come hear. look at for this data .
Ok I figured the last problem out, but now I am having a problem with the data uploading to the database I think it might be my coedeing though can anyone help, also if anyone gets stuck in the last problem let me know
Does anyone have this problem because of the updates?
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, object given
22:57 I really need that tutorial, anyone knows where I can find it as I cant find it on the website neither here on Youtube.
Thanks I will develop a free website for anyone who finds it 🙂
HTML5 syntax can validate your form in the browser also.
Anyone else's "manage Inventory" link not navigating to the "inventory_list.php" page?
Unknown column 'data_added' in 'field list' ? help
Hi, First of all, THANK YOU FOR EVERYTHING!!!
I just hope you are still paying attention to us mortals, I have seen your tutorials again and again while working on a personal project.. and I'm stuck.. I keep getting this mess for some reason:
"
Notice: Undefined index: price in …./inventory_list.php on line 56
Notice: Undefined index: details in …./inventory_list.php on line 59
Warning: Cannot modify header information – headers already sent by (output started at …./inventory_list.php:56) in …./inventory_list.php on line 74 "
this shows above the menu on top of my website right after I submit a new item, at one point I tried to put the original code as you left it… still no luck..
suppose there are 100 items in list ….then how to add search box to search product with name or id in inventory_list .php
how do you change the inventory item to £ instead of $
I'm having a problem, i can upload the image and everything but whenever i try to upload 3 different items it shows the same item 3 times, any suggestions?
Is anyone having or had an issue with the images not uploading to the inventory images folder? It was working for me at first but once I moved all my files to another computer and re created the database and tables. In the the table the id has been assigned but the image does not show on the site. Any help would be greatly appreciated.
where can i see all code ?
THE RIGHT FORM OF THIS :
$product_list="$date_added – $id – $product_name <a href='#'>edit</a> • <a href='#'>delete</a><br/>";
IS THIS:
$product_list="$product_list $date_added – $id – $product_name <a href='#'>edit</a> • <a href='#'>delete</a><br/>";
IF YOU DON'T DO THAT YOU WOULD HAVE ONLY THE LAST PRODUCT IN THE PRODUCTS LIST.
Very good video but I have Two questions . "Which payment gateway is good for web development company and is SSL recommended for E-commerce site ?
Shouldn't you use a for loop?
where can i find the code?
Very good videos, Thanks! I trying to follow along with Sublime text and it's nearly impossible 🙁
Is the source code posted?
I have no idea on how to proceed further from line 8 to 19. Seriously lost to somewhere else…Please help. Thanks.
Some of the functionalities, doesn't work on mine, like I cannot add products to the database, and the products only shows one item. What can you recommend?
does anyone know why images do not upload to the "inventory_images" folder on the server? the database product information inserts just fine to the database!!
Hi Adam, A caption says on this video that the image and product details uploaded ok. However I've found that all the details upload ok except for the image. The image does not upload, even on your untouched code. Is there anything I can do to get it working? Thank you
It's saying my variables are not defined and Unknown column 'product_name' in 'field list' how do I fix this? HELP plz!
these tutorials are great and have all pages working and im so happy with it but I have one small problem, why cant I login to admin inventory area from any other computer?
Can anyone tell me some possible reasons why my inventory will only display the single newest uploaded product??
hi, am getting this error while adding a new product, can anyone assist please:
the error:-Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:xampphtdocsMyOnlineStorestoreadmininventory_list.php on line 62
Unknown column 'product_name' in 'field list'
hi how to change price form $ to GBP??
hello adam, can you help me? what if iwant to view record from multiple table, i try this but the output repeat itself like this.
$sql = mysql_query("SELECT * FROM tbl_product, product_category, product_subcategory ORDER BY date_added DESC");
$productCount = mysql_num_rows($sql); // count the output amount
if ($productCount > 0) {
while($row = mysql_fetch_array($sql)){
$id = $row["product_id"];
$product_name = $row["product_name"];
$product_category = $row["product_category"];
$unit_price = $row["unit_price"];
$quantity = $row["quantity"];
$product_subcategory = $row["product_subcategory"];
$size = $row["size"];
$color = $row["color"];
$date_added = strftime("%b %d, %Y", strtotime($row["date_added"]));
$inventory_list .= "Product ID: $id — product_name: $product_name — product category: $product_category — product subcategory: $product_subcategory — size: $size — color: $color — unit price: $unit_price — quantity: $quantity — <a href='inventory_edit.php?pid=$id'>edit</a> — <a href='inventory_list.php?deleteid=$id'>delete</a><br />";
when i echo it,the output will bhe like this products record view couple of time, how can i fix this? can you please help me.
Product ID: 9 — product_name: black shoes — product category: asd — product subcategory: formal shoe — size: 5 — color: red — unit price: 12.00 — quantity: 32 — edit — delete
Product ID: 9 — product_name: black shoes — product category: asd — product subcategory: asd2 — size: 12332 — color: asdas — unit price: 12.00 — quantity: 32 — edit — delete
Product ID: 10 — product_name: red shoe — product category: asd — product subcategory: formal shoe — size: 5 — color: red — unit price: 343.00 — quantity: 5345 — edit — delete
Product ID: 10 — product_name: red shoe — product category: asd — product subcategory: asd2 — size: 12332 — color: asdas — unit price: 343.00 — quantity: 5345 — edit — delete
Product ID: 9 — product_name: black shoes — product category: men shoe — product subcategory: formal shoe — size: 5 — color: red — unit price: 12.00 — quantity: 32 — edit — delete
Product ID: 9 — product_name: black shoes — product category: men shoe — product subcategory: asd2 — size: 12332 — color: asdas — unit price: 12.00 — quantity: 32 — edit — delete
Product ID: 10 — product_name: red shoe — product category: men shoe — product subcategory: formal shoe — size: 5 — color: red — unit price: 343.00 — quantity: 5345 — edit — delete
Product ID: 10 — product_name: red shoe — product category: men shoe — product subcategory: asd2 — size: 12332 — color: asdas — unit price: 343.00 — quantity: 5345 — edit — delete
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
How do I deal with this ?
Wow! I am working on this video when suddenly 28:16 I notice my date is Dec 23, 2013! As I flipped from your video to my page, I had to do a double take since the dates were almost identical, just 3 years apart. lol
Ey man i just wanne tell you thanks for you tutorial. I am currently busy developing an website for my own company and i didn't know how to get the id for each item. Thanks to you i now know!, thanks!
Everything is working great for me except from the last part.When i add the following code, the links do not appear next to the product name.
$product_list = "$id – $productName <a href='#'>edit</a> <a href='#'>delete</a><br/>";
Embedding html within php can be a real pain!!