Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function viewdata() {
- $cetak .="<h3>Daftar Peserta Didik</h3>";
- $cetak .= "<form action='index.php' method=get >
- Nama : <input type=text name=nama value='".$_GET['nama']."' /> <input type=submit value='Cari' />
- <input type=hidden name='id' value='lihat' /></form>";
- $cetak .= "<br><table id='tablebaru' width='800' ><tr >
- <td class='header' width='5'>No</td><td class='header' width='100'>NISN</td>
- <td class='header' >Nama</td><td class='header' width='50'>Kel</td>
- <td class='header' width='100'>Kontrol</td></tr>";
- $i=1;
- $host = localhost; // isi sesuai settingan sql kamu
- $username =root;
- $password = test123;
- $db = daftar_ulang;
- $con = mysqli_connect($host, $username, $password, $db);
- $sql = mysqli_query($con, "select * from t_siswa where namalengkap like'%".$_GET['nama']."%'");
- while($row=mysqli_fetch_array($sql)) {
- $td = ($i % 2 ) ? $td ="td1":"td2";
- $cetak .="<tr class='$td' onMouseOver=\"this.className='highlight'\" onMouseOut=\"this.className='$td'\" >
- <td class='td' >".$i."</td>
- <td class='td' >".$row['id']."</td>
- <td class='td' >".$row['namalengkap']."</td>
- <td class='td' >".$row['kelamin']."</td>
- <td class='td' ><a href='index.php?id=edit&kode=".$row['id']."' title='Klik untuk lihat data' >Lihat Data</a>
- </td>
- </tr>";
- $i++;
- }
- $cetak .="</table><br>";
- return $cetak;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement