Advertisement
bellaabby

Untitled

Jun 27th, 2016
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.45 KB | None | 0 0
  1. function viewdata() {
  2.  
  3. $cetak .="<h3>Daftar Peserta Didik</h3>";
  4. $cetak .= "<form action='index.php' method=get >
  5. Nama : <input type=text name=nama value='".$_GET['nama']."' /> <input type=submit value='Cari' />
  6. <input type=hidden name='id' value='lihat' /></form>";
  7. $cetak .= "<br><table id='tablebaru' width='800' ><tr >
  8. <td class='header' width='5'>No</td><td class='header' width='100'>NISN</td>
  9. <td class='header' >Nama</td><td class='header' width='50'>Kel</td>
  10. <td class='header' width='100'>Kontrol</td></tr>";
  11. $i=1;
  12. $host = localhost; // isi sesuai settingan sql kamu
  13. $username =root;
  14. $password = test123;
  15. $db = daftar_ulang;
  16. $con = mysqli_connect($host, $username, $password, $db);
  17. $sql = mysqli_query($con, "select * from t_siswa where namalengkap like'%".$_GET['nama']."%'");
  18.  
  19. while($row=mysqli_fetch_array($sql)) {
  20. $td = ($i % 2 ) ? $td ="td1":"td2";
  21. $cetak .="<tr class='$td' onMouseOver=\"this.className='highlight'\" onMouseOut=\"this.className='$td'\" >
  22. <td class='td' >".$i."</td>
  23. <td class='td' >".$row['id']."</td>
  24. <td class='td' >".$row['namalengkap']."</td>
  25. <td class='td' >".$row['kelamin']."</td>
  26.  
  27. <td class='td' ><a href='index.php?id=edit&kode=".$row['id']."' title='Klik untuk lihat data' >Lihat Data</a>
  28. </td>
  29. </tr>";
  30. $i++;
  31. }
  32. $cetak .="</table><br>";
  33.  
  34. return $cetak;
  35. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement