Create two tables in your database as USERS(UserFullName, Username, Password) an
ID: 3801282 • Letter: C
Question
Create two tables in your database as USERS(UserFullName, Username, Password) and PHOTOS(PhotoName, caption, photodata, Username). Write PHP scripts that allow a user to do the following:
1.Register with a username and password;
2.Login with a registered username and password;
3.Upload a photo together with a photo name and a caption;
4.Query the database to retrieve photos using a keyword in either the photo name or the caption;
5.Both search by photo name and caption should allow partial match. Your scripts should list all photos whose name or caption contains the search keyword.
Explanation / Answer
1.)
2.)
Code for DB.PHP is given below
Code for config.PHP is given below
I hope this helps. Don't forget to give a thumbs up if you like this.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.