-2

When i am trying to fetch data from database showing warning error

Warning: mysqli_affected_rows() expects parameter 1 to be mysqli, boolean given in C:\xampp\htdocs\ajax-complete\live-table-post.php on line 23

I am trying to fetch data from database it is showing that error i am also used musqli_affedted_rows instead of mysqli_num_rows but its showing same error

<?php
    $host     = "localhost"; $username = "root"; $password = "";$db_name  = "ajax_complete";
    $conn = mysqli_connect( $host, $username, $password, $db_name ) or die("cannot connect");
    $output = '';
    $sql    = "SELECT * FROM tbl_live-crud ORDER BY id DESC";
    $result  = mysqli_query($conn,$sql);
    $output.= '
        <div class="table-responsive">
            <table class="table table-bordered">
                <tr>
                    <td width="10%;"></td>
                    <td width="20%;"></td>
                    <td width="20%;"></td>
                    <td width="20%;"></td>
                    <td width="10%;"></td>
                </tr>';
                if(mysqli_num_rows($result) > 0){
                    while($row = mysqli_fetch_array($result)){
                        $output .= '
                            <td>'.$row['id'].'</td>
                            <td class="fname" data-id1="'.$row['id'].'" contenteditable>'.$row['fname'].'</td>
                            <td class="lname" data-id2="'.$row['id'].'" contenteditable>'.$row['lname'].'</td>
                            <td class="email" data-id3="'.$row['id'].'" contenteditable>'.$row['email'].'</td>
                            <td><button name="delete" id="delete" data-id4="'.$row['id'].'">X</button></td>';
                            }

                        $output = '
                            <tr>
                                <td id="fname" contenteditable></td> 
                                <td id="lname" contenteditable></td> 
                                <td id="email" contenteditable></td> 
                                <td id="btn_add" name="btn_add" class="btn btn-xs btn-success"><button>+</button></td> 
                            </tr>';
                }else{
                    $output = '
                        <tr>
                            <td colaspan="4"> Data not Found</td>
                        </tr>';
                }
                $output .='</table>
                </div>';

?>
spydon
  • 9,372
  • 6
  • 33
  • 63
Apurva Kinkar
  • 35
  • 8

1 Answers1

-1

Try this.

$host     = "localhost"; 
$username = "root"; 
$password = "";
$db_name  = "ajax_complete";

$conn = mysqli_connect( $host, $username, $password, $db_name );
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$output = '';
$sql    = "SELECT * FROM tbl_live_crud ORDER BY id DESC";
$result = $conn->query($sql);

$output.= '
<div class="table-responsive">
    <table class="table table-bordered">
        <tr>
            <td width="10%;"></td>
            <td width="20%;"></td>
            <td width="20%;"></td>
            <td width="20%;"></td>
            <td width="10%;"></td>
        </tr>';
        if($result->num_rows > 0){
            while($row = $result->fetch_assoc()) {
                $output .= '
                            <td>'.$row['id'].'</td>
                            <td class="fname" data-id1="'.$row['id'].'" contenteditable>'.$row['fname'].'</td>
                            <td class="lname" data-id2="'.$row['id'].'" contenteditable>'.$row['lname'].'</td>
                            <td class="email" data-id3="'.$row['id'].'" contenteditable>'.$row['email'].'</td>
                            <td><button name="delete" id="delete" data-id4="'.$row['id'].'">X</button></td>
                        ';
            }

            $output = '
                    <tr>
                        <td id="fname" contenteditable></td> 
                        <td id="lname" contenteditable></td> 
                        <td id="email" contenteditable></td> 
                        <td id="btn_add" name="btn_add" class="btn btn-xs btn-success"><button>+</button></td> 
                    </tr>
            ';
        }else{
                $output = '
                        <tr>
                            <td colaspan="4"> Data not Found</td>
                        </tr>
                ';
        }
    $output .='</table>
</div>';
Anam Shah
  • 319
  • 1
  • 10