如何使用mysql数据库中的网站显示iframe？

Question

Hi guys I'm trying to somewhat of an autosurfer and for the life of my I cannot figure out how to use iframes on my site to display all of the sites I have in my mysql database. Now all of the website urls are stored in a column in my table in the database, so I assume I'll need to assign them to an array. But my main problem is getting them to display each site for fifteen seconds then load a different one. I understand iframes for the most part, but I don't get how to get it to show a site, refresh show another, etc. I also can't figure out how to load the sites into an array for the iframe to use. Please help. Thanks.

Answer 1

You will need to use JavaScript to refresh your iframe.

Let's say this is your iframe:

<iframe id="iframe" src="http://www.google.com"></iframe>

You'll need to use JavaScript to do the refresh, and AJAX if you want it to get data from your database. So do something like this in a javascript file (I'm using jQuery):

$(function(){
    function refresh_iframe(){
        $.get('iframe_url.php', function(data){
            // set iframe src to the url that the php gave us
            $('#iframe').attr('src', data);
            // run this function again in 15s
            setTimeout("refresh_iframe()",15000);
        });
    }
    // run the first time
    refresh_iframe()
});

Then in iframe_url.php you'd have something like:

    <?php
            $q = mysql_query("SELECT `url` from `iframe_urls`");
            $results = mysql_fetch_assoc($q);
            $key = array_rand($results);
            echo($results[$key]['url']);
    ?>