Php : Get a record Function but Error : Undefined property

Question

I have this problem when i try to build my function ! I need to build a function to get a record in database! And my error is Notice: Undefined property: mysqli_result::$fetch_assoc in database.php

function db_get_row($sql){
    db_connect(); // Connect to Database
    global $connect; // Get Global Variable
    $row = array(); // Create array
    $result = $connect->query($sql); // Excute the query and return a record
    if($result->num_rows > 0){ // If record > 0 -> TRUE
        $row = $result->fetch_assoc; // I get that record into $row      HERE IS MY ERROR   
    }
    return $row; // Return array
}

Possible duplicate of [PHP: "Notice: Undefined variable", "Notice: Undefined index", and "Notice: Undefined offset"](https://stackoverflow.com/questions/4261133/php-notice-undefined-variable-notice-undefined-index-and-notice-undef) — Marcin Orlowski, Jul 08 '17 at 21:00
yes, but fetch_assoc looks like a function / method to fetch rows from your resultset — Ivo P, Jul 08 '17 at 21:02
@IvoP sorry my mistake.you are right. I am thinking about `num_rows` — Alive to die - Anant, Jul 08 '17 at 21:05

score 0 · Accepted Answer · answered Jul 08 '17 at 21:08

0

Based on :- http://php.net/manual/en/mysqli-result.fetch-assoc.php

$row = $result->fetch_assoc;

Need to be

$row[] = $result->fetch_assoc(); //it's a function and you are assigning to array

answered Jul 08 '17 at 21:08

Alive to die - Anant

70,531
10
51
98

Thank you ! I have fixed it :P – Neko Jul 08 '17 at 21:13
Where i need to accept the answer ? i'm just starting to use stackoverflow , please help me . Thanks! – Neko Jul 08 '17 at 21:26
@Neko glad to help you – Alive to die - Anant Jul 08 '17 at 21:39
I have ticked it – Neko Jul 08 '17 at 21:40

Php : Get a record Function but Error : Undefined property

1 Answers1