Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
Pencarian tidak berfungsi di hosting
mohon bantuannya gan. saya membuat pencarian untuk data user. ketika di localhoast pencarian tesebut berfungsi tapi pas dipasang hosting pencarian malah tidak berfungsi.
<form action="cari_user.php" method="GET">
<div class="input-group col-md-5 col-md-offset-7">
<span class="input-group-addon" id="basic-addon1"><span class="fa fa-search"></span></span>
<input type="text" class="form-control" placeholder="Cari User disini. Ketik lalu Enter.." aria-describedby="basic-addon1" name="cari">
</div>
</form>
<?php
include '../config/connection.php';
include 'pagination.php';
if (isset($_GET['cari'])) {
$cari = isset($_GET['cari']) ? $_GET['cari'] : '';
$sql = mysqli_query($conn,"SELECT * FROM user WHERE nama_user LIKE '%$cari%' OR uname LIKE '%$cari%' OR email LIKE '%$cari%' ORDER BY id_user DESC");
}else{
$sql = mysqli_query($conn,"SELECT * FROM user ORDER BY id_user DESC");
}
while ($row = mysqli_fetch_array($sql)) {
?>
<tr>
<td><?php echo ++$no ?></td>
<td><?php echo $row['uname'] ?></td>
<td><?php echo $row['nama_user'] ?></td>
<td><?php echo $row['email'] ?></td>
</tr>
<?php } ?>
cari_user.php
<?php
$cari=$_GET['cari'];
header("location:user.php?cari=$cari");
?>
Tanggapan
tidak berfungsinya gmna ya? apakah error, apakah blank putih, atau gmn
2 Jawaban:
isi file koneksi.php udah disesuaikan belum sama yg di hosting seperti host,user,password,nama database
mas @dianarifr tampilannya hanya seperti ini mas <img src=' https://i.imgur.com/T8DG3wg.png '>
klo di localhost pas diurlnya itu kan seperti ini mas <img src=' https://i.imgur.com/0oBMLgv.png '> tapi klo yang teah dihosting itu cuma /admin/user.php?cari=$cari aja mas
cari_user.php di hosting <pre> <?php $cari = isset($_GET['cari']) ? $_GET['cari'] : ''; echo '<META HTTP-EQUIV="Refresh" Content="0; URL=user.php?cari=$cari">'; exit; ?> </pre>
user.php di hosting <pre> <form action="cari_user.php" method="GET"> //form pencarian <div class="input-group col-md-5 col-md-offset-7"> <span class="input-group-addon" id="basic-addon1"><span class="fa fa-search"></span></span> <input type="text" class="form-control" placeholder="Cari User disini. Ketik lalu Enter.." aria-describedby="basic-addon1" name="cari"> </div> </form> .... <?php include '../config/connection.php'; include 'pagination.php'; if (isset($_GET['cari'])) { $cari = isset($_GET['cari']) ? $_GET['cari'] : ''; $sql = mysqli_query($conn,"SELECT * FROM user WHERE nama_user LIKE '%$cari%' OR uname LIKE '%$cari%' OR email LIKE '%$cari%' ORDER BY id_user DESC"); }else{ $sql = mysqli_query($conn,"SELECT * FROM user ORDER BY id_user DESC"); } //pagination ... while (($count < $perhal) && ($i < $tcount)) { mysqli_data_seek($sql, $i); $row = mysqli_fetch_array($sql); ?> <tr> <td><?php echo ++$no ?></td> <td><?php echo $row['uname'] ?></td> <td><?php echo $row['nama_user'] ?></td> <td><?php echo $row['email'] ?></td> </tr> <?php } ?>
</pre>
tapi klo di user lain (yg bukan level admin) cuma ngerefresh aja