AJAX ﺩﺮﮐ ﻩﺩﺎﻔﺘﺳﺍ ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺎﺑ ﯽﻠﻣﺎﻌﺗ ﻁﺎﺒﺗﺭﺍ ﯼﺍﺮﺑ ﻥﺍﻮﺗ ﯽﻣ ﺍﺭ.
ﺩﻮﺷ ﯽﺸﮐﺍﻭ ﺪﻧﺍﻮﺗ ﯽﻣ ﺏﻭ ﻪﺤﻔﺻ ﮏﯾ ﻪﻧﻮﮕﭼ ﻪﮐ ﺪﻫﺩ ﯽﻣ ﻥﺎﺸﻧ ﺮﯾﺯ ﻝﺎﺜﻣ
→ ﺪﯿﻨﮐ ﻥﺎﺤﺘﻣﺍ ﺍﺭ ﻥﺁ ﻥﺎﺗﺩﻮﺧ
<!DOCTYPE html>
<html>
<style>
th,td {
padding: 5px;
}
</style>
<body>
<h2>The XMLHttpRequest Object</h2>
<form action="">
<select name="customers" onchange="showCustomer(this.value)">
<option value="">Select a customer:</option>
<option value="ALFKI">Alfreds Futterkiste</option>
<option value="NORTS ">North/South</option>
<option value="WOLZA">Wolski Zajazd</option>
</select>
</form>
<br>
<div id="txtHint">Customer info will be listed here...</div>
<script>
function showCustomer(str) {
if (str == "") {
document.getElementById("txtHint").innerHTML = "";
return;
}
const xhttp = new XMLHttpRequest();
xhttp.onload = function() {
document.getElementById("txtHint").innerHTML = this.responseText;
}
xhttp.open("GET", "getcustomer.php?q="+str);
xhttp.send();
}
</script>
</body>
</html>
ﺍﺭ .ﺩﻮﺷ ﯽﻣ ﺍﺮﺟﺍ showCustomer() ﻡﺎﻧ ﻪﺑ ﯽﻌﺑﺎﺗ ،ﺪﻨﮐ ﯽﻣ
function showCustomer(str) {
if (str == "") {
document.getElementById("txtHint").innerHTML = "";
return;
}
const xhttp = new XMLHttpRequest();
xhttp.onload = function() {
document.getElementById("txtHint").innerHTML = this.responseText;
}
xhttp.open("GET", "getcustomer.php?q="+str);
xhttp.send();
} :ﺪﻫﺩ ﯽﻣ ﻡﺎﺠﻧﺍ ﺍﺭ ﺮﯾﺯ ﺩﺭﺍﻮﻣ showCustomer() ﻊﺑﺎﺗ
ﺖﺳﺍ ﻩﺪﺷ ﺏﺎﺨﺘﻧﺍ ﯼﺮﺘﺸﻣ ﺎﯾﺁ ﻪﮐ ﺪﯿﻨﮐ ﯽﺳﺭﺮﺑ
ﺪﯿﻨﮐ ﺩﺎﺠﯾﺍ XMLHttpRequest ﯽﺷ ﮏﯾ
ﺩﻮﺷ ﺍﺮﺟﺍ ﺖﺳﺍ ﻩﺩﺎﻣﺁ ﺭﻭﺮﺳ ﺦﺳﺎﭘ ﯽﺘﻗﻭ ﻪﮐ ﺪﯿﻨﮐ ﺩﺎﺠﯾﺍ ﺍﺭ ﯽﻌﺑﺎﺗ
ﺪﯿﻨﮐ ﻝﺎﺳﺭﺍ ﺭﻭﺮﺳ ﯼﻭﺭ ﻞﯾﺎﻓ ﮏﯾ ﻪﺑ ﺍﺭ ﺖﺳﺍﻮﺧﺭﺩ
(ﯽﯾﻮﺸﮐ ﺖﺴﯿﻟ ﯼﺍﻮﺘﺤﻣ ﺎﺑ) ﺖﺳﺍ ﻩﺪﺷ ﻪﻓﺎﺿﺍ URL ﻪﺑ (q) ﺮﺘﻣﺍﺭﺎﭘ ﮏﯾ ﻪﮐ ﺪﯿﺷﺎﺑ ﻪﺘﺷﺍﺩ ﻪﺟﻮﺗ
.ﺖﺳﺍ "getcustomer.php" ﻡﺎﻧ ﻪﺑ PHP ﻞﯾﺎﻓ ﮏﯾ ﻻﺎﺑ ﺖﭙﯾﺮﮑﺳﺍ ﺍﻭﺎﺟ ﻂﺳﻮﺗ ﻩﺪﺷ ﯽﻧﺍﻮﺧﺍﺮﻓ ﺭﻭﺮﺳ ﺭﺩ
.ﺪﻧﺍﺩﺮﮔ ﯽﻣﺮﺑ HTML ﮏﯾ ﺭﺩ ﺍﺭ ﻪﺠﯿﺘﻧ ﻭ ﺪﻨﮐ ﯽﻣ ﺍﺮﺟﺍ ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺮﺑﺍﺮﺑ ﺭﺩ ﺍﺭ ﻮﺟ ﻭ ﺱﺮﭘ ﮏﯾ "g
<?php
$mysqli = new mysqli("servername", "username",
"password", "dbname");
if($mysqli->connect_error) {
exit('Could not connect');
}
$sql = "SELECT customerid, companyname,
contactname, address, city, postalcode, country
FROM customers WHERE
customerid = ?";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param("s", $_GET['q']);
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($cid,
$cname, $name, $adr, $city, $pcode, $country);
$stmt->fetch();
$stmt->close();
echo "<table>";
echo "<tr>";
echo "<th>CustomerID</th>";
echo
"<td>" . $cid . "</td>";
echo "<th>CompanyName</th>";
echo "<td>" . $cname
. "</td>";
echo "<th>ContactName</th>";
echo "<td>" . $name . "</td>";
echo "<th>Address</th>";
echo "<td>" .
$adr . "</td>";
echo "<th>City</th>";
echo "<td>" . $city . "</td>";
echo "<th>PostalCode</th>";
echo "<td>" .
$pcode . "</td>";
echo "<th>Country</th>";
echo "<td>" . $country .
"</td>";
echo "</tr>";
echo "</table>";
?>