[ASK] JQuery PHP dynamic Select Option ,,Help gan

Beranda
Komunitas
Tech
Programmer Forum
[ASK] JQuery PHP dynamic Select Option ,,Help gan

deff.stuff

03-05-2019 15:53

[ASK] JQuery PHP dynamic Select Option ,,Help gan

hallo agan-agan sekalian, ane lagi belajar programming web dikit" nih gan.

kebetulan ane ga ngerti jquery, beginilah hasil code pulungan ane gan :

Spoiler for masalah (hasil code):

[ASK] JQuery PHP dynamic Select Option ,,Help gan

ane search "TKJX01", value option di kotak merah bener gan -> "soekarni","dono".
nah pas ane Search "TKJX02" value yang harusnya muncul di kotak merah itu "Irma" (ada db nya gan di bawah).
eh ternyata ga berubah sama sekali gan.

nih gan:

[ASK] JQuery PHP dynamic Select Option ,,Help gan

source code ane gan.

Spoiler for b.php:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">

<html lang="pt" dir="ltr">

<head>

<title>Search And Show Without Refresh</title>

<meta HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<meta http-equiv="Content-Style-Type" content="text/css">


[removed][removed]

[removed]
$(function() {
$('#myItem').change(function(){
var value = $('#str').val();
$.post('a.php',{value:value}, function(data){
$("#search_results").html(data);
});
return false;
});
});
[removed]

</head>

<body style="margin:0;padding:0px;width:100%;height:100%;background-color:#FFFFFF;">

<div style="width:1024px;margin:0 auto;height:100px;background-color:#f0f0f0;text-align:center;">
HEADER
</div>
<div style="width:1024px;margin:0 auto;height:568px;background-color:#f0f0f0;text-align:center;">
<form id="lets_search" action="" style="width:400px;margin:0 auto;text-align:left;">
Search:
<?php
$conn= mysqli_connect("localhost","root","","crud");
$queryy="SELECT * FROM kelas ";
$get=mysqli_query($conn,$queryy);
?>
<select id="myItem">
<?php
while ($rows=mysqli_fetch_assoc($get)):;
$kelas=$rows['kd_kelas'];?>
<option id="str" value="<?php echo $kelas; ?>"><?php echo $kelas; ?> </option>
<?php endwhile; ?>
</select>
</form>
<div id="search_results"></div>
</div>
<div style="width:1024px;margin:0 auto;height:100px;background-color:#f0f0f0;text-align:center;">
FOOTER
</div>

</body>

</html>

Spoiler for a.php:

<?php

define("HOST", "localhost");

// Database user
define("DBUSER", "root");

// Database password
define("PASS", "");

// Database name
define("DB", "crud");

// Database Error - User Message
define("DB_MSG_ERROR", 'Could not connect!<br />Please contact the site\'s administrator.');

############## Make the mysql connection ###########

$conn = mysql_connect(HOST, DBUSER, PASS) or die(DB_MSG_ERROR);

$db = mysql_select_db(DB) or die(DB_MSG_ERROR);

$query = mysql_query("
SELECT *
FROM siswa
WHERE kd_kelas='".$_POST['value']."'
");

echo '<select>';

while ($d = mysql_fetch_array($query)) {

echo '
<option value="'.$d["nama"].'">'.$d["nama"].'</option>
</tr>';

}

echo '</select>';

?>

ini database ane gan

Spoiler for database nya gan:

ini tabel kelas gan.
[ASK] JQuery PHP dynamic Select Option ,,Help gan

ini table siswa
[ASK] JQuery PHP dynamic Select Option ,,Help gan

untuk siapapun yg nyempetin baca/bantu/solve, ane ucapin terimakasih banyak gan/sist.

Diubah oleh deff.stuff 03-05-2019 17:19

nona212 memberi reputasi

876

Kutip

Balasan

Komentar yang asik ya

Urutan

Terbaru

Terlama

Komentar yang asik ya

Komunitas Pilihan