7. E - Commerce Website Tutorial - PHP MySQL Dynamic Home Page

[kizzel77]

Can someone help me get the Items to render out horizontal instead of vertical? i got it working partly but it is only doing one item per line instead of putting the next item to the right of the first.

[timschloeder64]

@kizzel77 yeah same problem here! any help?

[mitchellcthomas218]

I like that

[RaqseeBismil]

Hello Adam, I have a question Is it possible to make a php email function and store data into a database. I am confuse that how to email the stored database data to an email address? Could you tell me any tutorials which can help me. I have develop a website and currently I am using only php script to email website form data to an email address. I want to use databases.

Please advise.

Thanks

[sutistalica]

Thanks ...

[ITurnTheMusicUp]

How would you go about creating pages for your results...ie like here you only want to show 6 on a page how would you make the rest of the rest go onto page 2, 3, 4 etc?

[BenMur777]

Thank you for posting this video :

[queencitypete1]

I've got my index page just like you have it, except my footer is above the content section, and ideas?

Thanks guys,

Nice tutorial-

[madmanhelp]

your the man dude these tutorials are epic. i have one little problem with this and my products page though when i try to create a dynamic table with 2 columns so i can display more products it just duplicates the products so ile have two black tops next to each other and 2 black hats next to each other etc etc etc i have tryed editing the php code to like ID++ or +1 to no prevail and also as "tanib10" said how can i implement a next button?? please help or anyone who has got this working

[ZenCartEasyHelp]

Thank you for such a nice video!  Set up your ecommerce business for free with our Easy Help Zen Cart Tutorials and our Free Zen Cart Templates.

[tanib10]

@@

In the dynamic page,suppose i have 20 item for selling..using LIMIT i can show up product,how much i like.that okkk.......but if i like to show 10 product in home page ,then how can i show next 10 product is home page using a "NEXT " button..

i mean i would like to use a "NEXT" button in dynamic home page,to disply more product ,with LIMIT.....

adam please help us.....

or any one of you can define the "NEXT" button with code,,,please upload the code .here.

thank you all.

@@

[tanib10]

hi adam,

hopfuly thanks to you for providing us this great tutorial...........in the hole world some people are greatly differant from all of others...you are one of the differant guys..so great you are..............thaks to you again...

[Ifritmaster]

i cant upload the rest of the codes

[Ifritmaster]

$dynamiclist ="";

$sql = mysql_query("SELECT * FROM dougandpete_products_plants_an­nual ORDER BY date_added DESC LIMIT 6");

$productCount = mysql_num_rows($sql); // count output amount

if ($productCount > 0){ while($row = mysql_fetch_array($sql)){ $id = $row["id"]; $product_name = $row["product_name"]; $price = $row["price"]; $date_added = strftime ("%b %d, %Y", strtotime($row["date_added"]))­; 

[Ifritmaster]

hello adam, thanks for the tutorial but i am wondering how can i make tables , show side by side? ps sorry about my english.. exmaple i made mine like this

<?php

//connect to database include ('../../../../includes/conn/co­nn_to_mysql.php');

// this block grabs the whole list of veiewing

[graemeswann]

i dont get any products to display!? please help...

[henrydueck]

hey i love these toutorials. its better than i have ever seen.

still im kinda new to this but i have 1 hookup.

i am using Globat and looks like the site works fine but the store admin wil not work. any of those pages i go it kiks me right to the login page.

can anyone help?

[EyesTheSouth]

i want to make a three column layout like | pic | pic | pic | anyone know how to do it?

[TechyVidz]

Hi Adam,

Is there a way for me to stop the "Latest Designer Fashions" from displaying more than two products? I'd like to limit it, on this page and then list them all on the Products Page. Thanks.

[TechyVidz]

@TechyVidz

Upon about a half our of investigation I realized that I am an idiot and just needed to change it in the SQL query instead of the PHP code. If anyone needs to know, I just changed LIMIT 6 to LIMIT 2.

Thanks

[shakaama]

I am a CSS DIV zen masta.

I practice DIV fu all day longs.

sometimes I even

put a div inside a div, when I div,

so i can div when i div, inside my div. [thumbs up if you get it]

[engeljakob]

@shakaama div u!

[shakaama]

@engeljakob what kinda div are you trying to pull there morklork?

[Grimmwood]

@shakaama rofl

[sportnastava]

if i meet you some day face to face will get drunk 4 sure :D coz youre tuts ROX

[SuperDissolved]

Nice Video! :)

Subbed !

[cockerspanielhome]

Adam,

Thank you so much for your time and efforts in continuing this series, I really appreciate your efforts. I hope you have a great holiday and well deserved time off. I am trying to learn everything you are teaching and look forward to your continued tutorials.

Thanks,

Eric

[kyleparisi]

Just to support your table comments... look at Amazon. They are heavy table users for their layout.

[techgeekh]

Hey Adam, how many parts are there going to be? I can't wait! You are awsome!

[shakaama]

Happy new year to you too Adam.

[ohdaush]

u sound like a chinese!!!! I WANT MY MONEY, WHERE IS MY MONEY!!! FAIVE HAUNDRED DOLAA!!!

[XMAnuca]

@1161858 Godaddy is not a really good Hosting, most times doesn't render php blocks... I recomend you Hosting24...

[XMAnuca]

I understand what you said about the id's but... Can you tell us a MYSQL comand to re-order the id's? (if it exists...).

Would you teach us to create the PayPal account?

These are the best tutorials!!!!!!!

[ghostdancer12]

Adam even though I'm not going to be building an Ecommerce website, there is so much that I will take away from these tutorials. Thanks for taking the time to put these tutorials online... for free!!. Nothing is free these days apart from Adam's tutorials - how cool is that? Adam I will point my students to your new (updated) vid library on brainvid.com, yet another brilliant (creative!!) idea. Speak to you again on Facebook...soon.

[ngshane]

thanks adam

i look forward to the next part :)

[1161858]

if godaddy wont render my php pages is it the site or my coding

[pakt40]

@1161858 I am using godaddy as well and I am stuck at video 3 until Adam releases the source code. All the other php files renders fine, just the last php page he did in video 3 went screwy so I am thinking it is a coding error that is causing this not godaddy but that's jut my thinking.

[WalnutPro]

@pakt40

Go to develophph and read what others are doing. Do a search for e-commerce (ON THE SITE) and you may find your answwer. For the GoDaddy users (hosted accounts) you need to go to Hosting controls and set your file permissions to write for the inventory_images dir. Tried to reset mine in Filezilla and the changes do not take effect. I think you have to actually go to godaddy and make your changes to be 100% sure they are accepted and work.

[pakt40]

@WalnutPro Thanks for the info. Just went and clicked on E-commerce and that part is exactly were I screwed up.

[ronny22]

yes been waiting for this for ages lol

oh and Adam will you be adding a Quantity function on edit and add list where you add the amount of products you have and show the quantity of that product you have in stock

:)

[WalnutPro]

YEA!!!! Welcome back Adam. Hey, the break was good for you I hope. I learned so much having to copy the code. THANK YOU!!!! I am so much more ready for 7 now. Out of ALL of the VID gurus out there YOU SET THE BAR. Now on to the show.....

[Zackary210]

"Hang Up!" at the end hahaha

[abanda3d]

first .. nice tut