Home / MYSQL / belajar 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 ========================
?>

belajar mysql Rating: 4.5 Diposkan Oleh: Catatanku