How to call random picture from MySql database using JavaScript

Question

I need to make a call from my webpage to database and select random picture from single table from database. Database is based on server (mysql) and i call it from javascript code. So my question is: Is there a code snippet for that, I am not that good with Javascript.

Thanks in advance.

Javascript can't connect directly to mySQL. What are you using on server side? — Pekka
– Pekka, Commented Nov 26, 2010 at 18:14
You left out the server-side language you're using. That's what you need to write an API in. Also, you might want to show your db schema. — Matthew Flaschen
– Matthew Flaschen, Commented Nov 26, 2010 at 18:14

onurbaysan · Accepted Answer · 2010-11-26 18:19:19Z

1

You can do this in your Server-Side Script. Eg: PHP , ASP.Net

Look this: Random images shower

Maybe it isn't related to question but you should stroe your pics link in database. You should try to store pics in your web-site directory , for example

answered Nov 26, 2010 at 18:19

onurbaysan

1,2339 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dejan Stuparic Over a year ago

Where do i need to put server-side script, in witch directory?

onurbaysan Over a year ago

I think you should use AJAX. Here is a good example: w3schools.com/PHP/php_ajax_database.asp

cambraca · Accepted Answer · 2010-11-26 18:16:01Z

1

You need a server side script that gives you the picture. Then you need some js that loads it. If you use php, and jQuery on the client-side, your js could look like:

$('div#image_container').load('yourscript.php');

And then your php would query the database and return something like:

<img src="the_random_image_url.jpg" />

answered Nov 26, 2010 at 18:16

cambraca

28k17 gold badges71 silver badges102 bronze badges

Collectives™ on Stack Overflow

How to call random picture from MySql database using JavaScript

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related