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

[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]

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

[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]

$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?

[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.

[BlackRacen]

@blthlt ever heard of pause video ?

[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.

[rauel199]

hi, thanks for the tutorials, you-re great man. but i have a problem, i want to upload 4 photos of the product something like ID_1.jpg, ID_2.jpg, can you help me? i`m trying for 4 hours to solve it, but i`m new to codding and it`s really hard..

thank you!

[sleverychops]

these are the best php tutorials on the web...thank you my man

are you any relation to Mickey Rourke??

[fredbillard]

hey guys, i am a godaddy user and im not sure if thats why i keep getting this error but that might be it..

in the inventory_list page while trying to upload an image to an my website and to my folder (inventory_images) i keep getting this error.

Warning: move_uploaded_file(../inventor­y_images/26.jpg) [function.move-uploaded-file]: failed to open stream: Not a directory in /home/content/54/8339354/html/­storeadmin/inventory_list.php on line 72

ive swopped out my code for adams and still nothing

[gaifboy]

cannot get the upload image function to work

[redmatrice]

@gaifboy maybe you should look at the CHMOD, it's a permession option in ftp, don't know which ftp client you got, but try to find out the folder (where do you want to upload imgs), then find option CHMOD (sometimes it's in right click) then choose 777 (Write Read Execute etc..)

[zacharysr]

Your awesome adam!

[TheBoost3d]

Hi, Adam. Just wondering. How can I make this shopping cart work with Joomla! 1.7 ?

[bohterham]

nice tut! can you make your ecommerce website downloadable ? :D

[ZenCartEasyHelp]

Thanks for posting this! If you need help customizing your zen cart store check out our channel for our free Easy Help Zen Cart Video Tutorial library. If you have a specific question or video you would like to see, just leave a comment on our channel.

[pauldetect]

Adam thanks for taking time to do these tutorials.

I have completed course and all works well, but I would like to add say 5 catagories in drop down which when clicked shows their own sub catagories in sub catogory drop down box. I am just learning this stuff so please be patient with me if the following is crap:-

I think I need to set an OPTION VALUE for each sub catagory, if so can anyone explain how?

[gaifboy]

@pauldetect my solution would be to have onEvent() javascript check on the first option bar and when something happens to that bar check the database and update the other one according to the database

[coyotegene86]

Great lucid cogent and well-spoken tutorials. You really know how to speak to a learning audience. I just started PHP and I love this. Thanks so much man.

[misserio]

What if i want to add 2 or 3 other categories with there subcategory ???

Plz some one can write the html code for me this is important

[xkriswithakx]

TO ALL GODADDY USERS THAT ARE HAVING PROBLEMS UPLOADING IMAGES:

You do indeed need to create a new php5.ini file. you need to define the max file size and stuff there.

BUT with godaddy you need to change the permissions for the image directory you are dumping to! by defult they are read only, go into file manager and give write permissions for web apps!

[ShopperPress]

Cool video. That having been said, if you would like to create professional looking stores on the net, see our-channel now!

[pagyutioper]

thank you for this tutorial, you are great! n very smart, good way to get views to your site.....good job man!

[psychojack77]

if you having trouble with the uploading and are using a linux web server (may apply to windows too) remember to change the upload_max_filesize, post_max_size and memory_limit in the php ini file because the default is set to something like 1mb, whenever i have had problems with uploading or have seen someone with uploading problems its usually because of this.

[Spectre887]

Can someone help me, I got an error when I submit my form. The error: 404 (Page Not Found) Error. Pls I really need help on this one. Thanks in advance.

[bendyamin86]

Ok i got this working... but...

THERE'S NO LOG OUT BUTTON!

[psychojack77]

@bendyamin86 if you want a logout button just use

$session_start();

$session_destroy();

just make a link to a php file called logout or whatever then put a link back to whatever page you want it to go to at the bottom and problem solved xD

[bendyamin86]

@psychojack77 Yup, i kinda got that already. But thanks for the concern man. U r awesome!

[davidjunior2000]

i dont know if im just being thick but i cant find the making of the form in tutorial 3 i havewatched it 5 times but im not seeing it ps help

[tomtheallrighty]

@davidjunior2000 I have exactly the same issue, I decided he must mean the fact that he showed how to make A form rather than THIS form.

[WillMaynard77]

Ok I just want to add that if you are using godaddy you need to set the permissions so the file will be uploaded, Found this out the hard way.

[EyesTheSouth]

@WillMaynard77 can you tell me how to do this, this is what I'm currently having trouble with, goDaddy is full of unnecessary shit

[EyesTheSouth]

@WillMaynard77 dont worry i googled it Cheers for the heads up though

[WillMaynard77]

I dont under stand how to get the form to work properly with javascript can anyone help me?

[keeslam123]

how can you put multiple pictures into a product??

[gogira]

i completed this tutorial part several times , because i thought i wasn t writing something right , but after also checking with the complete source code , i m sure it s all good , so i don t understand why , but the uploading image function DOESN T WORK !

it works to add products to the inventory list , but doens t upload any images to /inventory_images folder

ANY IDEEA WHY ??

[bendyamin86]

@gogira i'm having the same problem. it won't upload coz it doesn't detect the folder. i'm stuck here.

[Shiggy0927]

When you log in as the admin, should that be record in PhpMyAdmin admin table?

I am able to log in, but once I try to do anything, I get the "Your login session data is not on record in our database" echo.

Thanks for the tuts!

[keeslam123]

what about adding more pics to a artikel like 10 or something? just copy the form and or something? and how do you give it a name to go with the artikel??

[Foaman]

Anybody got the source code for these videos?

[shakaama]

for the flash validation code, was there a video explaining it? Do i just plug in the variables from my form?

Sorry, I just am coming to late to this and have been resisting learning PHP, until I felt like I had mastered HTML / CSS. PHP doesn't seem so hard, now that I sit down and look at it.

[elvisniperx]

i can't add the images in ../inventory_images

[gogira]

@elvisniperx having the same issue , have you solved it ?

[elvisniperx]

@gogira i have solved it. it's in my form, i forgot to type in multipart/form-data in enctype. there's no problem in adam's codes.

[gogira]

@elvisniperx i thought that the code is right :). sorry but i dind`t understand , what did you forget to type ?

i would appreciate if you could tell me more explicitly , because i have to finish this project - store - web site in 2 days , and i can`t figure out what s causing that error.

thanks.

[gogira]

@elvisniperx i have this in my code :

enctype="multipart/form-data" name="myForm" id="myform" method="post">

were you referring to this ?

[elvisniperx]

@gogira i'm sorry for the late reply. yes i'm referring to that. that is my only problem. i'll message you the code.

[gogira]

@elvisniperx the problem was my web server... i tried it all out using xampp and it s working well

[kollyajax]

Great tut....can you please explain how to modify codes (add codes) to the ones generated by dreamwearver...I adapted most of your steps using dream weaver wizard but the problem is including some check code like the one that checks for duplicated Product name. All though the unique constraint work well for the product name though showing the error along with the column name which I found to be securely unsafe!!!!

[kollyajax]

Adamsss.....

You are awesome!!! Also, i discovered that the image's name got renamed from the default,, it is normal? also how do you control the file size limit?

[kollyajax]

why are you not using the timestamps for the date? Just curious!!!

[kollyajax]

How you do make an image go into the database? Or is it not possible?

[casild2]

Thank you from everyone in Honduras.

[TeenAviator]

Great series Adam! I can't wait for the next tutorial series!!! What does 'parse' mean, please?

[MrDavidRF]

Can you make it so there can be auctions like eBay?

[pakt40]

Awesome! Thanks for the video but I have to jump on the bandwagon and doubt you can have it done by Christmas.

[MrDewerbe]

THANK YOU! *-*

[ReeceYoung98]

I would have to agree with @cavking1

I don't think you will make it as in the UK at the minute you've got just over 12 hours...

Don't take me wrong, your awesome and if you do make it, I will give you a slobbery kiss! lol

[PrinceProStudio]

Can I sell web designs with this? Just live Devbooth?

[philly100000]

I'm sorry, but I hade to add things to your store :D

[cavking1]

I'm pretty sure that the "6 video's before christmas" may not apply for UK citizens as we are half a day ahead of you guy in the US of A.

Although I'm not complaining. You do a great thing here Adam.

Many Thanks 1000 times over. (INSERT whileloop here)

[MrShawnlloyd]

great series mang

[srgwiggles1]

Here are some suggested series id like to see done if you could.

One on using Flash CS5 Pro to make basic text iphone apps and some basic functions when using it.

Another on making a forum.

If people need this one. How to add it all together on one website

[notta3d]

Man, I checked all day long for the next video :) Thanks for the post.