Postingan lainnya
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