Database Named: q2products Database User Name: q2user Database Users' Password:q2pass Database table: products Field Nam

[answerhappygod]

Database Named Q2products Database User Name Q2user Database Users Password Q2pass Database Table Products Field Nam 1 (407.61 KiB) Viewed 37 times

Database Named: q2products Database User Name: q2user Database Users' Password:q2pass Database table: products Field Name Datatype(size) Additional properties productid varchar(13) Primary key productname varchar(30) price int(3) For the following questions(q1 & q2); For sql queries either prepared statements(mysqli_stmt_) or object oriented interface(new mysqli(.....) ) should be used. Q1. Design and implement a self-calling php page named "add.php". This page iff product id exists within the database table, should update the name and price. If this product id is not in use should add the record to the database table. (4ots) <Place your answer to here> Q2. Design and implement a php page named "list.php". This page should list all the fields for all the records from the products table. (4pts) <Place your answer to here>