Question: Consider a database ( mydb ) that has messages ( id , name, message, date ) in the message table. Data : The column date

Consider a database (mydb) that has messages (id, name, message, date) in the message
table.
Data :
The column "date" will be created while the records are inserted into the message table.
Please do the following:
a.insert data with PHP script (insertmes.php)(or addmessage.php from hw4)
b.print the messages (printmes.php)
c. print the messages in descent date order. (printordermes.php)
d. find the number of records (nummes.php) with messages in descent date order
e.update the "Bye" message with "Hi"(updmess.php)
f. delete the updated record (delmess.php
Hint: Give screenshots where it is needed. First give the PHP script and next put the
screenshots. For the update and delete operations first the record will appear giving the id (in
URL) and secondly the execution
 Consider a database (mydb) that has messages (id, name, message, date)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!