Jump to content

Webpage Using HTML5, SQL and PHP

Recommended Posts

Soooo I am taking a class called Electronic Commerce. My professor is is requiring us to make a website "selling" a product (not for real) and the website must use html 5, php and sql. He is not going to waste class time teaching us these because this is a "capstone" class and we should already be familiar. Well Html 5 I am ok with, but SQL and PHP, I am so lost.


As far as I can figure out, the SQL is for my database. I have already gathered the jpgs, made a database of the spices with prices I will sell.


I am not really sure how to attack this project and any help will by greatly appreciated. There is no mention of this project in his syllabus and folks that have taken his class before said that he doesn't even grade this project, I really just want to have something to turn in just in case.



Share this post

Link to post
Share on other sites

SQL is the language that the database executes, right. PHP would build SQL statements and then send them to the database to get the result. That's sort of a tall order though, PHP is a programming language so if you aren't already familiar with programming then that's a lot to learn for this. You can copy and paste individual pieces of PHP and probably get something to work, but if you're going to understand everything then that sounds like a lot of work for a single project. If your database is MySQL, for example, then this shows some examples for connecting to the database and running SQL queries:




I'm not really sure what to say though. The first step is designing the site on paper, where you list everything that each page can do so that you can have a flow of what's going on. Once you know what each page needs to do then I guess you can research how to do that particular thing. Most pages will just do a single thing, like list products in a category, or add a product to the cart, or whatever. You might want to start with the PHP tutorial on w3schools and go through what they have there.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...