Ajax Combo

getuser.php

<?php
$q=$_GET["q"];

$con = mysql_connect('localhost', 'root', '');
if (!$con){ die('Koneksi gagal: ' . mysql_error());}

mysql_select_db("db_coba", $con);
$sql="SELECT * FROM pegawai WHERE IdKar = '".$q."'";
$result = mysql_query($sql);

echo "<table border='1'>
<tr>
<th>Nama Depan</th>
<th>Nama Belakang</th>
<th>Umur</th>
</tr>";

while($d = mysql_fetch_array($result)){
 echo "<tr>";
 echo "<td>" . $d['fName'] . "</td>";
 echo "<td>" . $d['lName'] . "</td>";
 echo "<td>" . $d['Umur'] . "</td>";
 echo "</tr>";
 }
echo "</table>";

mysql_close($con);
?>
========================
<html>
<head>

<script type="text/javascript">
var xmlHttp

function showUser(str){ 
xmlHttp=GetXmlHttpObject()
if (xmlHttp==null){
 alert ("Browser tidak support HTTP Request")
 return
 } 
var url="getuser.php"
url=url+"?q="+str
url=url+"&sid="+Math.random()
xmlHttp.onreadystatechange=SC1 
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}

function SC1() { 
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){ 
 document.getElementById("txtHint").innerHTML=xmlHttp.responseText 
 } 
}

function GetXmlHttpObject(){
var xmlHttp=null;
try{xmlHttp=new XMLHttpRequest();}
catch (e){
try{xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");}
  catch (e){xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");}
 }
return xmlHttp;
}
</script>

</head>
<body>
<form> 
Pilih User:
<select name="users" onChange="showUser(this.value)">
<option value="1">Nama ID 1</option>
<option value="2">Nama ID 2</option>
<option value="3">Nama ID 3</option>
    <option value="4">Nama ID 4</option>
</select>
</form>
<p>
<div id="txtHint"><b>Informasi user akan tampil di sini...</b></div>
</p>
</body>
</html>



Komentar

Posting Komentar

Postingan populer dari blog ini

Source Code Koleksi Php dan java script

<?php //PHP: LOOP THROUGH EACH STRING LINE IN A TEXTAREA //trim off excess whitespace off the whole $text = trim($_POST['textareaname']); //explode all separate lines into an array $textAr = explode("\n", $text); //trim all lines contained in the array. $textAr = array_filter($textAr, 'trim'); //loop through the lines foreach($textAr as $line){ echo "$line"; } function bubble_sort($arr) {     $size = count($arr);     for ($i=0; $i<$size; $i++) {         for ($j=0; $j<$size-1-$i; $j++) {             if ($arr[$j+1] < $arr[$j]) {                 swap($arr, $j, $j+1);             }         }     }     return $arr; } function swap(&$arr, $a, $b) {     $tmp = $arr[$a];     $arr[$a] = $arr[$b];     $arr[$b] = $tmp; } /* test bubble sort *...
Baca selengkapnya

Java Script Auto refresh

<?php session_start(); $jmldata=10; ?> <html> <head> <script type="text/javascript"> function Ajax(){ var $http,$self = arguments.callee; if (window.XMLHttpRequest) {$http = new XMLHttpRequest();} else if (window.ActiveXObject) { try {$http = new ActiveXObject('Msxml2.XMLHTTP');} catch(e) {$http = new ActiveXObject('Microsoft.XMLHTTP');} } if ($http) { $http.onreadystatechange = function(){ if (/4|^complete$/.test($http.readyState)) { document.getElementById('ReloadThis').innerHTML = $http.responseText; setTimeout(function(){$self();}, 1000); } }; $http.open('GET', 'songinfo.php' + '?' + new Date().getTime(), true); $http.send(null); } } </script> <script type="text/javascript">setTimeout(function() {Ajax();}, 1000);</script> <meta http-equiv="Content-...
Baca selengkapnya

Java Script Membaca Lokasi Kita

Gambar
<!DOCTYPE html> <html> <head>     <title>Demo Cek Lokasi Geolocation HTML5</title> </head> <body> <center> <p id="tampilkan"></p> <p>Cek lokasi anda! >> <button onclick="getLocation()">Cek</button></p> <div id="mapcanvas"></div> </center> <script type="text/javascript" src="//maps.googleapis.com/maps/api/js?key=AIzaSyBhSg6I2JvHNU_jLqIpvc5MEwc_xi3Ttvg&sensor=true"></script> <script> var view = document.getElementById("tampilkan"); function getLocation() {     if (navigator.geolocation) {         navigator.geolocation.getCurrentPosition(showPosition, showError);     } else {         view.innerHTML = "Yah browsernya ngga support Geolocation bro!";     } } function showPosition(position) {     lat = position.coords.latitude;     lon = pos...
Baca selengkapnya