<?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:350px; 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
//=============PAGING ========================
$batas=20;
$halaman=$_GET['halaman'];
$posisi=null;
if(empty($halaman)){
$posisi=0;
$halaman=1;
}else{
$posisi=($halaman-1)* $batas;
}
//=============PAGING ========================
$query1 = mysql_query("
SELECT a.id, a.firstname, a.city, a.lastname, b.roleid, b.contextid, c.instanceid, e.name, e.parent FROM `info_user` a
left join info_role_assignments b on b.userid=a.id
left join info_context c on c.id=b.contextid
left join info_context d on d.id=c.instanceid
left join info_course_categories e on e.id=c.instanceid
WHERE a.firstname LIKE 'teknik' and b.roleid='3' and e.parent='13'
and (a.firstname 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>
<?} ?>
<h3>
<br>
<?php
//=============PAGING ========================
$sql_paging = mysql_query("SELECT a.id, a.firstname, a.city, a.lastname, b.roleid, b.contextid, c.instanceid, e.name, e.parent FROM `info_user` a
left join info_role_assignments b on b.userid=a.id
left join info_context c on c.id=b.contextid
left join info_context d on d.id=c.instanceid
left join info_course_categories e on e.id=c.instanceid
WHERE a.firstname LIKE 'teknik' and b.roleid='3' and e.parent='13'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://elearning.unmuhjember.ac.id/dosen_ti/?all=new?&halaman=$i>$i</a>,";
} else {
echo "<b>$i</b>,";
}
mysql_close();
?>
</center>
<br>
NB: Dimohon untuk edit profile melengkapi biodata.
<?
$row2=mysql_fetch_array (mysql_query("SELECT count(*) as ini FROM `data` ORDER BY `data`.`date` DESC"));
?>
<!-- <?=$row2['ini']?>
<! yg ini href=/user/view.php?id=<?=$row['id']?>--------bwt profile>
Belajar select join sukses di elearning
Related Articles :
Pagging //=============PAGING ======================== $batas=11; $halaman=$_GET['halaman']; $posisi=null; if(empty($halaman)){ $posisi=0; ...
belajar mysql <?php //===================================== session_start(); if(isset($_POST['kirim'])){ $src = $_POST['cari']; }else{ $src = $_ ...
Belajar duluSELECT count(*) as ini FROM `info_log` $date = date("Y-m-d H:i:s"); $ip = isset($_SERVER['HTTP_X_FORWARDED_FOR']) ? $_SERVER['HTTP_X_ ...
mereset passwod Joomla dan Moodle update mysql di phpmyadmin cari tabel user ganti 827ccb0eea8a706c4c34a16891f84e7b itu artinya : 12345 untuk Joomla ...
Reset Password MySQL di Ubuntu Serversudo /etc/init.d/mysql start alhamdulillah beress... 30 desember 2014 .. mysql broken Cara Pertama: Gunakan perintah sudo dpkg-reconf ...