Dear Friends,
Help me to fix this..
Error Message : mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in
Code is,

<?php
            class Login
            {   
                public function login_proses($u, $p){
                    include ('koneksi.php');
                    $pass = base64_encode($p);
                    $_mysqli->query("START TRANSACTION;");
                    $cek_login = $_mysqli->query("SELECT * FROM penduduk, hak_akses, hak_akses_user 
                                    WHERE penduduk.nik = hak_akses_user.nik 
                                    AND hak_akses.id_akses = hak_akses_user.id_akses
                                    AND penduduk.username = $u
                                    AND penduduk.password = $pass");
                    $cek = mysqli_num_rows($cek_login);
                    $sesi = mysqli_fetch_array($cek_login);
                    if ($cek > 1) {
                        session_start();
                        $_SESSION['userdata'] = $sesi['nik'];
                        $nik = $sesi['nik'];
                        date_default_timezone_set('Asia/Jakarta');
                        $waktu = date("d-m-Y  H:i");
                        $_mysqli->query("INSERT INTO online (nik, waktu) VALUES ('$nik', '$waktu')");
                        $_mysqli->query("UPDATE penduduk SET status = 1 WHERE nik = '$nik'");
                        $res = $_mysqli->query("COMMIT");
                        if ($res) {
                            header('location:validasi.php');
                            return TRUE;
                        }
                    }elseif($cek > 0){
                        session_start();
                        $nik = $sesi['nik'];
                        date_default_timezone_set('Asia/Jakarta');
                        $waktu = date("d-m-Y  H:i");
                        $_SESSION['userdata'] = $sesi['nik'];
                        $_SESSION['level'] = $sesi['nama_akses'];
                        $_mysqli->query("INSERT INTO online (nik, waktu) VALUES ('$nik', '$waktu')");
                        $_mysqli->query("UPDATE penduduk SET status = 1 WHERE nik = '$nik'");
                        $res = $_mysqli->query("COMMIT");
                        if ($res) {
                            header('location:pilihan.php');
                            return TRUE;
                        }
                    }else{
                        $res = $_mysqli->query("ROLLBACK");
                        var_dump($res);
                        $nilai =
        <<<HEREDOCS
                    <!-- Danger Alert -->
                    <div class="alert alert-danger alert-dismissable">
                        <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
                        <h4><strong>Login Gagal</strong></h4>
                        <p>Maaf, username dan password tidak cocok !</p>
                    </div>
                    <!-- END Danger Alert -->
        HEREDOCS;
                        setcookie("alert", $nilai, time()+2);
                        header('location:index.php');
                        return TRUE;
                    }
                }

                public function validasi_user(){
                    session_start();
                    $_SESSION['level'] = $_POST['nama_akses'];
                    header('location:pilihan.php');
                    return TRUE;
                }

                public function get_profil(){
                    include ("../koneksi.php");
                    $aa = $_SESSION['userdata'];
                    $u = $_mysqli->query("SELECT * FROM penduduk, hak_akses, hak_akses_user 
                                            WHERE penduduk.nik = hak_akses_user.nik 
                                            AND hak_akses.id_akses = hak_akses_user.id_akses
                                            AND penduduk.nik = '$aa'");
                    $sesi = mysqli_fetch_array($u);
                    return $sesi;
                }

                public function get_validasi(){
                    include ("koneksi.php");

                    $aa = $_SESSION['userdata'];
                    $sesi = $_mysqli->query("SELECT * FROM penduduk, hak_akses, hak_akses_user 
                                            WHERE penduduk.nik = hak_akses_user.nik 
                                            AND hak_akses.id_akses = hak_akses_user.id_akses
                                            AND penduduk.nik = '$aa'");
                    return $sesi;
                }

                public function daftar(){
                    include ('koneksi.php');
                        $username = $_POST['val-username'];
                        $password = base64_encode($_POST['val-password']);
                        $nik      = $_POST['val-number'];
                        $cek = $_mysqli->query("SELECT nama FROM penduduk WHERE nik = '$nik'");
                        $cek1 = mysqli_num_rows($cek);
                        $cekakses = $_mysqli->query("SELECT * FROM hak_akses_user WHERE id_akses='akses04' AND nik = '$nik'");
                        $cek2 = mysqli_num_rows($cekakses);
                        if ($cek2 > 0) {
                            $nilai =
        <<<HEREDOCS
                    <!-- Danger Alert -->
                    <div class="alert alert-danger alert-dismissable">
                        <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
                        <h4><strong>Pendaftaran Gagal</strong></h4>
                        <p>NIK <strong>$nik</strong> sudah terdaftar !</p>
                    </div>
                    <!-- END Danger Alert -->
        HEREDOCS;
                        setcookie("alert", $nilai, time()+2);
                        header('location:index.php');
                        return TRUE;
                        }else{
                            $_mysqli->query("TRANSACTION START;");
                            if ($cek1 > 0) {
                                $_mysqli->query("INSERT INTO hak_akses_user VALUES('$nik', 'akses04')");
                                $_mysqli->query("UPDATE penduduk SET username = '$username' , password = '$password' WHERE nik = '$nik'");
                                $res = $_mysqli->query("COMMIT");
                                if ($res) {
                                    $nilai =
        <<<HEREDOCS
                                <!-- Danger Alert -->
                                <div class="alert alert-success alert-dismissable">
                                    <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
                                    <h4><strong>Pendaftaran Berhasil</strong></h4>
                                    <p>SIlahkan Login!</p>
                                </div>
                                <!-- END Danger Alert -->
        HEREDOCS;
                                setcookie("alert", $nilai, time()+2);
                                header('location:index.php');
                                return TRUE;
                                }else{
                                    $res = $_mysqli->query("ROLLBACK");
                                    var_dump($res);

                                    $nilai =
        <<<HEREDOCS
                                <!-- Danger Alert -->
                                <div class="alert alert-danger alert-dismissable">
                                    <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
                                    <h4><strong>Pendaftaran Gagal</strong></h4>
                                    <p>Maaf, NIK anda salah !</p>
                                </div>
                                <!-- END Danger Alert -->
        HEREDOCS;
                                setcookie("alert", $nilai, time()+2);
                                header('location:index.php');
                                return TRUE;
                                }
                            }
                        }
                }

                public function logout(){
                    include ('koneksi.php');
                    if ($_GET['menu'] == 404) {
                        session_start();
                        $cc = $_SESSION['userdata'];
                        $_mysqli->query("TRANSACTION START;");
                        $_mysqli->query("UPDATE penduduk SET status = '0' WHERE nik = '$cc'");
                        $_mysqli->query("DELETE FROM online WHERE nik = '$cc'");
                        $res = $_mysqli->query("COMMIT");
                        if ($res) {
                            session_destroy();
                            header('location:index.php');
                        }else{
                            $res = $_mysqli->query("ROLLBACK");
                            var_dump($res);
                        }
                    }
                }
            }
         ?>

Recommended Answers

It means that one of your MySQL queries failed due to an error message of some sort (improper syntax, etc.). I'm not sure which one because the error message seems to be chopped off. The complete error message should specify the line of the PHP file that failed.

Jump to Post

All 2 Replies

It means that one of your MySQL queries failed due to an error message of some sort (improper syntax, etc.). I'm not sure which one because the error message seems to be chopped off. The complete error message should specify the line of the PHP file that failed.

On line 11 and 12 single quotes are missing to surround $u and $pass.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.