Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

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.

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote