MYSQL belajar mysql <?php //===================================== session_start(); if(isset($_POST['kirim'])){ $src = $_POST['cari']; }else{ $src = $_SESSION['cari']; } $_SESSION['cari'] = $src ; ?> <form method="post" action=""> <left> <input type="text" id="cari" class="form-control" style="width:150px; vertical-align:middle;" name="cari" placeholder="Cari nama dosen" value="<?=$src?>"> <button type="submit" name="kirim" class="btn">Cari</button> <br></form> <hr> <center> <link rel="stylesheet" type="text/css" href="wahid74.css" /> <?php $batas=11; $halaman=$_GET['halaman']; $posisi=null; if(empty($halaman)){ $posisi=0; $halaman=1; }else{ $posisi=($halaman-1)* $batas; } $query1 = mysql_query(" SELECT a.lastaccess, a.id, a.firstname, a.city, a.lastname, b.roleid, b.contextid, c.instanceid, e.name, e.parent FROM `m_user` a left join m_role_assignments b on b.userid=a.id left join m_context c on c.id=b.contextid left join m_context d on d.id=c.instanceid left join m_course_categories e on e.id=c.instanceid WHERE b.roleid='3' and (a.username LIKE '%$src%' or a.lastname LIKE '%$src%' ) ORDER BY `a`.`lastaccess` DESC LIMIT $posisi,$batas"); while($row=mysql_fetch_array($query1)){ ?> <div class="wahid_dosen"> <table width="100%" border="0"> <tbody> <tr><td width="10px" valign="top"> <a href="/course/category.php?id=<?=$row['instanceid']?>" class="alumni-2"><img src="../user/pix.php?file=/<?=$row['id']?>/f1.jpg" width="80px" height="80px"/></a> </td><td valign="top"><div class="rightDownRadius"> <?=$row['lastname']?><br> <?=$row['city']?><br> <a href="/course/category.php?id=<?=$row['instanceid']?>">Matakuliah yang diampu :</a> </div> </td></tr></tbody></table> </div> <?} ?> <br> <?php $sql_paging = mysql_query(" SELECT a.lastaccess, a.id, a.firstname, a.city, a.lastname, b.roleid, b.contextid, c.instanceid, e.name, e.parent FROM `m_user` a left join m_role_assignments b on b.userid=a.id left join m_context c on c.id=b.contextid left join m_context d on d.id=c.instanceid left join m_course_categories e on e.id=c.instanceid WHERE b.roleid='3' and (a.firstname LIKE '%$src%' or a.lastname LIKE '%$src%' ) "); $jmldata = mysql_num_rows($sql_paging); $jumlah_halaman = ceil($jmldata / $batas); echo "Halaman :"; for($i = 1; $i <= $jumlah_halaman; $i++) if($i != $halaman) { echo "<a href=http://virtualclass.unmuhjember.ac.id/?all=new?&halaman=$i>$i</a>,"; } else { echo "<b>$i</b>,"; } mysql_close(); //=============Bawah bawah ======================== ?>