Our database is succesfully created.
We use a software called AppServ to create our database.
By typing MySQL commands into the software,
we are able to create a database for our website called "etrade_app"
Besides that, there are table created inside the database to save and store our data.
Inside our table, there are few rows that contain all the data.
Such as,
- Name
- Telephone
- Categories
- Product
- Description
- Price
- Image
Since we haven start the PHP coding, we can't test our database yet.
The main problem we facing is saving the product image into our database.
This is because there are pictures with different type,
for example, JPEG, BMP, PNG etc.
We can't confirm all type of pictures can be saved into our database.
Test and experiment will be conduct to verified this problems.
You can create tables etc. using PHPMyAdmin without programming in PHP first. Btw, how many tables you created, what are the table names, and what are the fields and data type u specify for your fields?
ReplyDeletewe create 1 table named etrade, the fields inside is all the thing i mention on top, such as name, telephone, email etc. Most data type of the field is varchar, except for the image which i use blob or mediumblob.
ReplyDeletemayb we will create more table to store other data.