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.