单击图像时，将图像URL保存到sql数据库

Question

I would like to make it so that when you click an image it saves that images url to a field in a database... I know how to do the SQL UPDATE part but i don't know how to get the the image url?

I am sorry but i have no code because i don't know where to start!

Thanks in advance!

Answer 1

You can get the url of the image with jQuery like this:

$(document).ready(function(){
   $('img').click(function(){
       var img = $(this.src)
   });
});

Then execute your Ajax request using your var img to send the information in your php file.

Edit: Remember to escape the URL that is going to be returned as someone could easily try and SQL injection or some kind of breach in your database.