Register User

Adding a Record to PRODUCTS

Create database Delete database Create table Add Record View Records Delete Record Update Record Home

Item ID: |
Item Title: |
Item Description: |
Item Price: |

NOTES TO USERS:-

To add a products record to the database, please fill in the details in the text boxes and press 'Add Record' - note Item ID is a numerical item id. Item Price is also numerical, any characters other than numbers and decimal point will be rejected. After you added a products record, you must add a stocks record relating to the item id. To do this click on the 'Add Record' menu link and select option for adding stocks record. You will see in the Add Menu web page that there are several options for adding stocks record. If you wish to use the default category then click Add Stocks Record, if you wish to use user-defined category then click Add Stocks[User] Record - note the Stock ID and Stock Item must be same details as Products record. For example, you had product record with PID = 100 and Item Title = PHP Advanced for the World Wide Web; then the Stocks record should have Stock ID = 100 and Stock Item = PHP Advanced for the World Wide Web. Once you have finished inputting the details for the stocks record. Click on the Add Record to save it to database.