notice undefined offset : 0 what am I missing here?

[220061]

I have this error on if(mysqli_num_rows($query) > 0 )??? and I'm not seeing what the problem is can someone help me?

<?php
session_start();
if(isset($_SESSION['unique_id'])){
    include_once "config.php";
    $outgoing_id = mysqli_real_escape_string($conn, $_POST['outgoing_id']);//outgoing = sender
    $incoming_id = mysqli_real_escape_string($conn, $_POST['incoming_id']);
    $output = "";

    $sql = "SELECT * FROM messages
            LEFT JOIN users ON users.unique_id = messages.outgoing_msg_id
            WHERE (outgoing_msg_id = {$outgoing_id} AND incoming_msg_id = {$incoming_id})
            OR (outgoing_msg_id = {$incoming_id} AND incoming_msg_id = {$outgoing_id}) ORDER BY msg_id DESC"; //huh
    $query = mysqli_query($conn, $sql);
    if(mysqli_num_rows($query) > 0 ){
        while($row = mysqli_fetch_assoc($query)){
            if($row['outgoing_msg_id' === $outgoing_id]){// if this is equal to then he is a msg sender
                $output .= '<div class="chat outgoing">
                            <div class="details">
                                <p>'. $row['msg'] .'</p>
                            </div>
                            </div>';
            }else{//he is a message reciever
                $output .= '<div class="chat incoming">
                            <img src="php/images/'.$row['img'].'" alt="">
                            <div class="details">
                                <p>'. $row['msg'] .'</p>
                            </div>
                            </div>';
            }
        }
        echo $output;
    }
    
}else{
    header("../login.php");
}
?>

 

[simong1993]

Hey,

Print the $query and see what it is showing, Maybe there is too much data or a issue with the query 🙂

 

[220061]

Hey,

Print the $query and see what it is showing, Maybe there is too much data or a issue with the query 🙂

it says mysqli_result object ( [current_field] =>0 [field_count] => 12 [lengths] => [num_rows] => 0 [type] =>0)

 

[220061]

I also see a problem in the db so what it does it that when I send a message to someone it only sends it to himself: so for example I ,user 1, send a message to user 2. it will put in the db that user 1 sends a message to user 1

 

[220061]

this is the insert chat code so maybe this does the wrong thing? but idk what

<?php
    session_start();
    if(isset($_SESSION['unique_id'])){
        include_once "config.php";
        $outgoing_id = mysqli_real_escape_string($conn, $_POST['outgoing_id']);
        $incoming_id = mysqli_real_escape_string($conn, $_POST['incoming_id']);
        $message = mysqli_real_escape_string($conn, $_POST['message']);
        if(!empty($message)){
            $sql = mysqli_query($conn, "INSERT INTO messages (incoming_msg_id, outgoing_msg_id, msg)
                                        VALUES ({$incoming_id}, {$outgoing_id}, '{$message}')") or die();
        }
    }else{
        header("location: ../login.php");
    }


    
?>