Using mysql client create a database named supermarket create a table named groceryitems in the supermarket database. Groceryitems table should have the following information : itemname, itemtype(i.e fruit, vegetable, pantry, meat, dairy etc), item description, price per unit, quantity available. Use appropriate data type for each of the columns. Itemname should be the primary key. Create a php page through which you can connect to the grocery database and you can insert information into the grocery table. The php page displays an interface , texboxes for itemname , textfield for item description, radio button for item type, text box for unit price , text box for quantity available and a submit button. Once you click the submit button the php file should first validate the data types inserted. After successfully adding a row of information the same php page should show a confirmation message about successful information in the table. Make the radio buttons used for item-type sticky.
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Using mysql client
create a
create a table named groceryitems in the supermarket database. Groceryitems table should have the following information : itemname, itemtype(i.e fruit, vegetable, pantry, meat, dairy etc), item description, price per unit, quantity available. Use appropriate data type for each of the columns. Itemname should be the primary key.
Create a php page through which you can connect to the grocery database and you can insert information into the grocery table.
The php page displays an interface , texboxes for itemname , textfield for item description, radio button for item type, text box for unit price , text box for quantity available and a submit button.
Once you click the submit button the php file should first validate the data types inserted.
After successfully adding a row of information the same php page should show a confirmation message about successful information in the table.
Make the radio buttons used for item-type sticky.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
