1. In the Lecture Notes this
   week you were given the PHP code to produce a list of devices in the mobiles
   database and to update the fields for an existing device. The code for
   all the examples in the Lecture Notes is in the Lecture Note Code Examples
   zip file in this week’s Learning Resources. Supply the PHP code to do the following:

1. Add a new product to the
   database.
2. Delete an existing product
   from the database.

1. Utilise an include
   statement to refer to connection.php instead of the long version of
   the database connection code so that you can keep the database more
   secure. See Notes for more details

1. When you are testing your
   script, you should only delete records which you have added. This way you
   will not accidentally remove records which you or your colleagues are
   expecting to find.

You should also consider how to validate the requests, i.e. you should
not delete a record that is not there or add a product with an existing code. In
particular, you should not use complex regular expressions without a detailed explanation
of what each symbol means.

Attachments:

CKIT503-Week0….zip

CKIT503-Week0….pdf