lowongan (pake mysqli)

<?php
include_once('koneksi.php');

include_once"config/kodeauto.php";
include_once"config/fungsi_indotgl.php";
$mysqli = @new mysqli($server, $user, $pass, $mysql_db);

// Works as of PHP 5.2.9 and 5.3.0.
if ($mysqli->connect_error) {
    die('Connect Error: ' . $mysqli->connect_error);
}


?>
<div class="content_right">
<h2>&#187; Info Pekerjaan Terbaru</h2>
<table border='0' width='700'>

<?php
$per_laman = 7;
$laman_sekarang = 1;
if(isset($_GET['laman'])){
    $laman_sekarang = $_GET['laman'];
    $laman_sekarang = ($laman_sekarang > 1) ? $laman_sekarang : 1;
}

$sql="SELECT count(*) c FROM lowongan,perusahaan ORDER BY id_lowongan DESC";
if ($result = $mysqli->query($sql)) {

    /* Get field information for all columns */
     $finfo = $result->fetch_object();
     //echo '<pre>';var_dump($finfo);die;
     $total_data = $finfo->c;
}else{
    printf("Errorcode: %s\n", $mysqli->error);die;
}



//mysql_num_rows(mysql_query("SELECT * FROM lowongan,perusahaan ORDER BY id_lowongan DESC"));
$total_laman = ceil($total_data/$per_laman);
$awal = ($laman_sekarang - 1) * $per_laman;

//$tampil=mysql_query("SELECT * FROM lowongan,perusahaan where lowongan.id_perusahaan=perusahaan.id_perusahaan  ORDER BY id_lowongan DESC limit $per_laman OFFSET $awal");

$sql="SELECT * FROM lowongan
left join perusahaan
on lowongan.id_perusahaan=perusahaan.id_perusahaan
ORDER BY id_lowongan DESC
limit $per_laman OFFSET $awal";
if ($result = $mysqli->query($sql)) {
    //ok
    //echo "<div>$sql</div>";
}else{
    printf("Errorcode: %s\n", $mysqli->error);die;
}
$no=5;
while ($r=$result->fetch_assoc() ){
    //$r=mysql_fetch_array($tampil)){
    $tgl=tgl_indo($r['tgl_lowongan']);

?>
    <tr><td>
    <img src="foto_lowongan/<? echo $r['foto'];?>" width='130' height='130' />
    <div class='title_perusahaan1'><b><? echo $r['nama_p'];?></b></div>
    <?=  $tgl;?> - <? echo $r['alamat'];?>
    <p><?=substr($r['deskripsi'],0,350);?> <a href='?page=detail_lowongan&id=<? echo$r['id_lowongan'];?>&idp=<?=$r['id_perusahaan'];?>'> Lihat Selengkapnya >> </a></p>
    </td></tr>
<?php
}
?>
</table>
</div>

<?php if(isset($total_laman)) { ?>
  <?php if($total_laman > 1) { ?>
    <nav class="text-center">
      <ul class="pagination">
        <?php if($laman_sekarang > 1) {?>
          <li>
            <a href="index.php?laman=<?= $laman_sekarang - 1 ?>" aria-label="Sebelumnya">
              <span aria-hidden="true">Sebelumnya</span>
            </a>
          </li>
        <?php }else { ?>
          <li class="disabled">
          <a
            <span aria-hidden="true">Sebelumnya</span>
          </li>
          </a>
        <?php } ?>
        <?php if($laman_sekarang < $total_laman) {?>
          <li>
            <a href="?page=lowongan&laman=<?= ++$laman_sekarang  ?>" aria-label="Selanjutnya">
              <span aria-hidden="true">Selanjutnya</span>
            </a>
          </li>
        <?php }else {?>
          <li class="disabled">
            <span aria-hidden="true">Selanjutnya</span>
          </li>
        <?php } ?>
      </ul>
    </nav>
  <?php } ?>
<?php } ?>