Project Objective: You are to fix SQL error (see below). Images are not showing, please fix and allow to appear online for users. Allow images to be uploaded by users and appear.
Website: http://www.cheapimagehosting.com
Username: demo
Password: 123456
Upload an image and you will get the following error, the image will show a red “X”, the image does not appear and the SQL Error generates the following error message for example:
“Database error with function: Set Image File Size
SQL: UPDATE images SET filesize= WHERE image_id=39343
mySQL Says: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE image_id=39343’ at line 1”
Currently, all images in the images folder are not showing. These images need to appear online and fixed as well. For example: http://www.cheapimagehosting.com/images/demo/lighthouse.jpg
Knowledge of PHP, MySQL, SQL, HTML required.
Thank you.
