Using mysql code in a javascript?

Question

I'm stumped I've looked all over the internet and found no real way to access mysql within javascript, therefore I can't do what I need to.

Basically my javascript code is loading random websites using Iframes and I would like those list of sites to be pulled from a mysql database, but I see no way in doing this. I've tried using php's include function in javascript with no luck.

Any ideas?

More information:

Im using a script I have on my server called sitelist.js for the source of the script. All that script contains is the following:

targetURLs = [
'http://www.aol.com',
'http://www.yahoo.com',
'http://www.bing.com'
];

But i would like it to load websites from the mysql database instead of having those websites.

First off, javascript should not have direct access to your database. Second, what do you mean bt "I've tried using php's include function in javascript"? — Ivan
– Ivan, Commented Jan 4, 2012 at 1:20
You're misunderstanding the role of javascript. Mysql runs on the server, and so must be accessed by another language on the server. Javascript runs on the client's machine, and therefore cannot access mysql directly. Look into AJAX, which lets javascript call your PHP files (and more). — Ben D
– Ben D, Commented Jan 4, 2012 at 1:21
Why don't you just make a PHP script that returns a JSON list of those website strings. Then you can do whatever you want with the list in javascript. — styfle
– styfle, Commented Jan 4, 2012 at 1:24

Niet the Dark Absol · Accepted Answer · 2012-01-04 01:20:34Z

4

Try something along these lines, with $sites being your array of urls from the database...

<script type="text/javascript">
    var sites = JSON.parse("<?php echo addslashes(json_encode($sites)); ?>");
    // now do stuff with sites.
</script>

answered Jan 4, 2012 at 1:20

Niet the Dark Absol

326k86 gold badges480 silver badges604 bronze badges

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

4 Comments

Twister Over a year ago

I'm slightly confused on the implementation of this code. Can you explain a little more?

Niet the Dark Absol Over a year ago

First you use PHP to get your list of URLs from MySQL and put them in an array. Then use the code I gave you to transfer them into JavaScript.

Twister Over a year ago

Thank you that makes perfect sense. :D

user166390 Over a year ago

Is there a reason against: var sites = json_encode($sites);? (as JSON is a subet of JS object literals). I don't use PHP, but I am curious if there is a rational for this extra step.

Chris Eberle · Accepted Answer · 2012-01-04 01:20:11Z

1

This can't be done. Javascript (at the moment) doesn't have raw sockets. As a result, you can't call off to non-http network services like mysql. You could however wrap it using some horrible ajax API (SQL from javascript, no matter how it's accomplished, is a horrible idea).

answered Jan 4, 2012 at 1:20

Chris Eberle

48.9k12 gold badges85 silver badges123 bronze badges

2 Comments

Zoredache Over a year ago

Browser-side javascript doesn't have database access, but server side javascript can access databases. Your answer seems to make an absolute statement about what cannot be done with javascript, but it isn't true on all javascript platforms. The question is vague/unclear though.

Chris Eberle Over a year ago

Very true, I was assuming browser-side javascript. Good call.

Collectives™ on Stack Overflow

Using mysql code in a javascript?

2 Answers 2

4 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related