jQuery AJAX? ???? MySQL?? ??? ??

jQuery? ?? AJAX(??? JavaScript ? XML)? ???? MySQL?? ???? ??? ? ????. ?? ???? ?? ???? ??? ??????? ????? ??? ? ????. ?? ????? ?? ??? ????.

jQuery AJAX ??

HTML ??? jQuery ?????? ???? ?? AJAX ??? ?????.

<script type="text/javascript" src="jquery-1.9.1.min.js"></script>
<script type="text/javascript">
    $(document).ready(function() {
        var response = '';
        $.ajax({
            type: "GET",
            url: "Records.php",
            async: false,
            success: function(text) {
                response = text;
            }
        });

        alert(response);
    });
</script>

PHP ??

Records.php ??? ???? MySQL ??????? ???? ??? ???? ???? ?????.

$con = mysql_connect("localhost","root","");
$dbs = mysql_select_db("simple_ajax",$con);
$query = "SELECT Name, Address FROM users";
$result = mysql_query($query);

// Create the response in HTML format
$html = "";
while ($row = mysql_fetch_array($result)) {
    $html .= "<tr><td>$row[Name]</td><td>$row[Address]</td></tr>";
}

echo $html;

?? ??

??? ??? ???? ?? ? ????. ??? ?? ?? ???:

• list.php?? ?? ?? ?? ??(??) ?? ????. AJAX ??? ???? ?? ? ??? ????.
• Records.php ??? ? ?? ???? ?? mysql_* ??? ???? ????. ?????? ??? ???? mysqli_* ?? PDO? ???? ???.

?? ??

??? ??? ????? ??? ??? ?? ?????. ??? ??? ????.

list.php

<script type="text/javascript">
    $(document).ready(function() {
        $.ajax({
            type: "GET",
            url: "Records.php",
            async: false,
            success: function(text) {
                $("#div1 h2").html(text);
            }
        });
    });
</script>

Records.php

<?php

$mysqli = new mysqli("localhost", "root", "", "simple_ajax");
if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

$result = $mysqli->query("SELECT Name, Address FROM users");

// Create the response in HTML format
$html = "";
while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
    $html .= "<tr><td>{$row['Name']}</td><td>{$row['Address']}</td></tr>";
}

$mysqli->close();
echo $html;

??? ?? ???? ?? AJAX? ??? MySQL ???????? ???? ????? ???? ?? ???? ??? ????? ???? ???.

? ??? jQuery AJAX? ???? MySQL ???? ???? ?? ???? ?? ? ???? ???? ??? ??????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!