PHP Indonesia - Facebook: ASK gan baru belajar autosugest ni kira-kira ini ...

PHP Indonesia - Facebook PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/

Creating iOS Games: Beginner Course Marin Todorov teaches you how to create an iPhone game easily and simply using Cocos2d in this $99 online course. From our sponsors

ASK gan baru belajar autosugest ni kira-kira ini ... Sep 6th 2013, 02:44, by Gunawan Frincencius Gunawan Frincencius 2:44am Sep 6 ASK gan baru belajar autosugest ni kira-kira ini salah di mana ya, tidak mau tampil soalnya <?php $db = new mysqli('localhost', 'root' ,'', 'dbskripsi'); if(!$db) { echo 'Could not connect to the database.'; } else { if(isset($_POST['queryString'])) { $queryString = $db->real_escape_string($_POST['queryString']); if(strlen($queryString) >0) { $query = $db->query("SELECT tsiswa.nama_lengkap, tkelas.namakelas, tkelas.idkelas, ttapel.semester, ttapel.tahunajaran FROM tsiswa, tkelas, ttapel WHERE tsiswa.NIS=tkelas.NIS AND ttapel.idtapel=tkelas.idtapel ANF tkelas.aktif='Y' AND tsiswa.nama_lengkap LIKE '$queryString%'"); if($query) { echo '<ul>'; while ($result = $query ->fetch_object()) { echo '<li onClick="fill5(\''.addslashes($result->['tahunajaran']).'\');"fill4(\''.addslashes($result->['semester]').'\');"fill3(\''.addslashes($result->['namakelas']).'\');"fill2(\''.addslashes($result->['nama_lengkap']).'\');fill(\''.addslashes($result->['idkelas']).'\');">'.$result->idkelas.'&nbsp;&nbsp;'.$result->nama_lengkap.'&nbsp;&nbsp;'.$result->namakelas.'&nbsp;&nbsp;'.$result->semester.'&nbsp;&nbsp;'.$result->tahunajaran.'</li>'; } echo '</ul>'; } else { echo 'OOPS we had a problem :('; } } else { // do nothing } } else { echo 'There should be no direct access to this script!'; } } ?> Gunawan Frincencius 2:46am Sep 6 UP Abu Unaisah Setianto 2:53am Sep 6 error-nya apa om? Gunawan Frincencius 2:54am Sep 6 Abu Unaisah Setianto ga tampil gan saat diketik muncul 'oops we had a problem Gunawan Frincencius 2:56am Sep 6 sepertinya kesalahannya ada di sini while ($result = $query ->fetch_object()) { echo '<li onClick="fill5(\''.addslashes($result->['tahunajaran']).'\');"fill4(\''.addslashes($result->['semester]').'\');"fill3(\''.addslashes($result->['namakelas']).'\');"fill2(\''.addslashes($result->['nama_lengkap']).'\');fill(\''.addslashes($result->['idkelas']).'\');">'.$result->idkelas.'&nbsp;&nbsp;'.$result->nama_lengkap.'&nbsp;&nbsp;'.$result->namakelas.'&nbsp;&nbsp;'.$result->semester.'&nbsp;&nbsp;'.$result->tahunajaran.'</li>' saya belum tahu caru penulisan untuk yang dari beberapa tabel Abu Unaisah Setianto 2:57am Sep 6 ANF tkelas.aktif='Y' ?? Gunawan Frincencius 2:59am Sep 6 Iya maksudnya untuk yang siswa statusnya aktif Abu Unaisah Setianto 3:03am Sep 6 seharusnya AND atau ANF? Gunawan Frincencius 3:10am Sep 6 AND gan thanks koreksinya, da muncul nilai auto suggestnya cuma muncul permasalahn baru saat dipilih tidak terisi ke text field tahun pelajaran saja yan terisi Gunawan Frincencius 3:22am Sep 6 javascrtpnya seperti ini //auto suggest function suggest(inputString){ if(inputString.length == 0) { $('#suggestions').fadeOut(); } else { $('#country').addClass('load'); $.post("modul/modul_guru/mod_nilai/autosuggest.php", {queryString: ""+inputString+""}, function(data){ if(data.length >0) { $('#suggestions').fadeIn(); $('#suggestionsList').html(data); $('#country').removeClass('load'); } }); } } function fill(thisValue) { $('#idk').val(thisValue); setTimeout("$('#suggestions').fadeOut();", 10); } function fill2(thisValue) { $('#nama').val(thisValue); setTimeout("$('#suggestions').fadeOut();", 10); } function fill3(thisValue) { $('#nk').val(thisValue); setTimeout("$('#suggestions').fadeOut();", 10); } function fill4(thisValue) { $('#s').val(thisValue); setTimeout("$('#suggestions').fadeOut();", 10); } function fill5(thisValue) { $('#t').val(thisValue); setTimeout("$('#suggestions').fadeOut();", 10); } Gunawan Frincencius 3:23am Sep 6 text fieldnya seperti ini <div id="suggest"> Id Kelas:<br> <input type="text" onKeyUp="suggest(this.value);" name="idkelas" onBlur="fill();" id="idk" size="3"/> *Ketik Nama Siswa <div class="suggestionsBox" id="suggestions" style="display: none;"> <img src="images/arrow.png" style="position: relative; top: -12px; left: 30px;" alt="upArrow" /> <div class="suggestionList" id="suggestionsList"> &nbsp; </div></div> <br> Nama Siswa:<br> <input type="text" disabled="disabled" name="nama_lengkap" onBlur="fill2();" id="nama" size="10"/> <br>Kelas:<br> <input type="text" disabled="disabled" name="namakelas" onBlur="fill3();" id="nk" size="10"/> <br>Semester:<br> <input type="text" disabled="disabled" name="semester" onBlur="fill4();" id="s" size="10"/> <br>Tahun Ajaran:<br> <input type="text" disabled="disabled" name="tahunajaran" onBlur="fill5();" id="t" size="10"/> <div> Abu Unaisah Setianto 3:28am Sep 6 udah cek di error console? ane juga ikut bingung :D Gunawan Frincencius 3:29am Sep 6 ini screen shootnya Abu Unaisah Setianto 3:29am Sep 6 ane biasanya pake datalist (simple) : http://www.w3schools.com/tags/tag_datalist.asp Gunawan Frincencius 3:36am Sep 6 Abu Unaisah Setianto datalist ya saya belum pernah coba masih baru belajar

You are receiving this email because you subscribed to this feed at blogtrottr.com. If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions