 |
รบกวนช่วยชี้แนะทีครับ เลือกdropdown แล้วแสดงข้อมูลที่เลือกทีครับ |
| |
 |
|
|
 |
 |
|
ช่วยชี้แนะทีครับ อยากให้เลือกบริษัทที่ dropdown แล้วแสดงข้อมูลของบริษัทนั้น ขอบคุณนะครับ
Code (PHP)
<html>
<head>
<script>
function showUser(str) {
if (str == "") {
document.getElementById("txtHint").innerHTML = "";
return;
} else {
if (window.XMLHttpRequest) {
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp = new XMLHttpRequest();
} else {
// code for IE6, IE5
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange = function() {
if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
document.getElementById("txtHint").innerHTML = xmlhttp.responseText;
}
};
xmlhttp.open("GET","testdropdown.php?q="+str,true);
xmlhttp.send();
}
}
</script>
</head>
<body>
<tr>
<td>Company<span>*</span></td><td>
<?
$objConnect = mysql_connect("localhost","root","abcd1234") or die("Error Connect to Database");
mysql_query("SET NAMES UTF8");
$objDB = mysql_select_db("thaimee");
$query = mysql_query("select DISTINCT company_name_english from supplier ORDER BY company_name_english ASC;"); // Run your query
echo '<select name="Company">'; // Open your drop down box
// Loop through the query results, outputing the options one by one
while ($row = mysql_fetch_array($query)) {
echo '<option value="'.$row['company_name_english'].'">'.$row['company_name_english'].'</option>';
}
echo 'Thaimeetable</select>';// Close your drop down box
?>
</td>
</tr>
<br>
<div id="txtHint"></div>
</body>
</html>
Code (PHP)
<!DOCTYPE html>
<html>
<head>
</head>
<body>
<?php
$q = intval($_GET['q']);
$serverName = "localhost";
$userName = "root";
$userPassword = "abcd1234";
$dbName = "thaimee";
$con = mysqli_connect($serverName,$userName,$userPassword,$dbName);
mysqli_set_charset($con, "utf8");
if (!$con) {
die('Could not connect: ' . mysqli_error($con));
}
mysqli_select_db($con,"thaimee");
$sql="SELECT * FROM product WHERE Supplier_ID = '".$q."'";
$result = mysqli_query($con,$sql);
echo "<table class='Thaimeetable'>
<tr>
<td>Product(T)</td>
<td>Product(E)</td>
<td>Size</td>
<td>Amount</td>
<td>Unit Price</td>
<td>Total</td>
</tr>";
while($row = mysqli_fetch_array($result)) {
echo "<tr>";
echo "<td>" . $row['Product_thainame'] . "</td>";
echo "<td>" . $row['Productname'] . "</td>";
echo "<td>" . $row['Packing'] . "</td>";
echo "<td>" . $row['Amount'] . "</td>";
echo "<td>" . $row['price'] . "</td>";
echo "<td>" . $row['Total'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysqli_close($con);
?>
</body>
</html>
Tag : PHP, MySQL, Ajax
|
|
|
 |
 |
 |
 |
| Date :
2016-05-25 09:55:34 |
By :
athiwatbuun |
View :
806 |
Reply :
4 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
Code (PHP)
$( select option selector).change(function() {
//ต่อด้วย ajax
});
น่าจะง่ายกว่า
|
| |
|
|
| |
| Date :
2016-05-25 11:51:28 |
By :
fossil31 |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
มาอยู่ที่จุดนี้ ไม่ถนัดก็ต้องถนัดแล้วล่ะงานนี้
หา! อะไรเว็บๆ นะ thaimee เหรอ
นักสืบโคนันทำงาน
เหตุผลยอดฮิตที่ชอบบอกกันก็ เป็นนักศึกษาฝึกงานนะ ช่วยหนูหน่อย
|
| |
|
|
| |
| Date :
2016-05-25 15:12:48 |
By :
ห้ามตอบเกินวันละ 2 กระทู้ |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
file1.php
Code (PHP)
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.2/jquery.min.js"></script>
</head>
<body>
<select id="supplier" name="supplier">
<?php
//connected+run->query
while ($row = mysql_fetch_array($rs)) {
echo '<option value="'.$row['supp_id'.'">'.$row['supp_name'].'</option>';
}
?>
</select>
<!-- php close connection -->
<div id="content"></div>
<script>
$(document).ready(function(){
$("#supplier").change(function(){
$("#content").html("loading...");
$("#content").load("testdropdown.php?q=".$(this).val());
});
});
</script>
</body>
</html>
testdropdown.php
Code (PHP)
<?php
$q = intval($_GET['q']);
$serverName = "localhost";
$userName = "root";
$userPassword = "abcd1234";
$dbName = "thaimee";
$con = mysqli_connect($serverName,$userName,$userPassword,$dbName);
mysqli_set_charset($con, "utf8");
if (!$con) {
die('Could not connect: ' . mysqli_error($con));
}
mysqli_select_db($con,"thaimee");
$sql="SELECT * FROM product WHERE Supplier_ID = '".$q."'";
$result = mysqli_query($con,$sql);
echo "<table class='Thaimeetable'>
<tr>
<td>Product(T)</td>
<td>Product(E)</td>
<td>Size</td>
<td>Amount</td>
<td>Unit Price</td>
<td>Total</td>
</tr>";
while($row = mysqli_fetch_array($result)) {
echo "<tr>";
echo "<td>" . $row['Product_thainame'] . "</td>";
echo "<td>" . $row['Productname'] . "</td>";
echo "<td>" . $row['Packing'] . "</td>";
echo "<td>" . $row['Amount'] . "</td>";
echo "<td>" . $row['price'] . "</td>";
echo "<td>" . $row['Total'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysqli_close($con);
?>
Concept ประมาณนี้
|
| |
|
|
| |
| Date :
2016-05-25 15:21:36 |
By :
fossil31 |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
