Rabu, 13 November 2019

getData idwebhost000

function getData($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
//$arr = $rs->fetch_all(MYSQLI_ASSOC);
//$arr = mysqli_fetch_all($rs, MYSQLI_ASSOC);
$arr=$rs->fetch_assoc();
$rs->free();
return $arr;
}


  $sql="select * from `$tbadmin` order by `id_admin` desc";
  $jum=getJum($conn,$sql);
if($jum > 0){

$arr=getData($conn,$sql);
$rs=$conn->query($sql);
while ($d = $rs->fetch_assoc()) {
//foreach($arr as $d) {
$id_admin=$d["id_admin"];
$nama_admin=$d["nama_admin"];
$username=$d["username"];
$email=$d["email"];
$password=$d["password"];


======================================================
Sebelumnya:


function getData($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
$arr = $rs->fetch_all(MYSQLI_ASSOC);
//foreach($arr as $row) {
//  echo $row['nama_kelas'] . '*<br>';
//}

$rs->free();
return $arr;
}








Tidak ada komentar:

Posting Komentar

global_priv WARNING Selalu

 Jika muncul pesan kesalahan: Warning in .\libraries\classes\Dbal\DbiMysqli.php#209  mysqli::query(): (HY000/1034): Index for table 'glo...