display mysql database in HTML div element

[spyderfusion02]

Hello, I was wondering how I can grab information from the mysql database and place that information into a specified HTML div element.

Here is my PHP that I am using to connect to the database:

<?php

$mysql = new mysqli('localhost', 'root', 'root', 'ajax_demo') or die('you\'re dead');
$result = $mysql->query("SELECT * FROM explore") or die($mysql->error);

if($result) {
    
    while($row = $result->fetch_object()) {
        $siteName[] = $row->site_name;
        $siteDescription[] = $row->site_description;
        $siteURL[] = $row->site_url;
        $sitePrice[] = $row->site_price;
        
        # note that this isn't ideal - to echo out text before the doctype. This is just for example. In a real-world app, we'd echo this info out within the container div.
    }
}

Any help would be great. Thanks.

[zahidraf]

Yes, you can do this by using Ajax.

Go to Wschool and find some example.

Here is the latest phone by Samasung

samsung i637 Jack

[spyderfusion02]

I would still like to view the page source and see that the information is there. When I use ajax, nothing appears in the source.

[spyderfusion02]

Would something like this be the proper way to go? it seems like it will get messy since I need to grab lots of data from the DB.

<div id="container">    
    <ul>
        <?php foreach($siteName as $n) echo "<li> $n </li>\n"; ?>
    </ul>
</div>