Warning: Undefined array key, the query mysql is working well, is a php problem

[bertrc]

Warning: Undefined array key "chocolate.id_chocolate" in /var/www/html/cocoa/cocoa_type_chocolate.php on line 17

Warning: Undefined array key "chocolate.name_chocolate" in /var/www/html/cocoa/cocoa_type_chocolate.php  on line 17

Warning: Undefined array key "type_chocolate.id_type_chocolate" in /var/www/html/cocoa/cocoa_type_chocolate.php  on line 17

Warning: Undefined array key "chocolate_chocolate.type__chocolate" in /var/www/html/cocoa/cocoa_type_chocolate.php on line 17
Warning: Undefined array key "type__chocolate.id_chocolate" in /var/www/html/cocoa/cocoa_type_chocolate.php  on line 17

<?php

ini_set('display_errors', 1);

ini_set('display_startup_errors', 1);

error_reporting(E_ALL);





mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

$mysqli = mysqli_connect("localhost", "root", "P-11fl32fg14", "cocoa");



$query = "SELECT chocolate.id_chocolate,chocolate.name_chocolate,type_chocolate.id_type_chocolate, type_chocolate.type_chocolate ,type_chocolate.id_chocolate FROM chocolate INNER JOIN type_chocolate ON chocolate.id_chocolate =type_chocolate.id_type_chocolate WHERE type_chocolate='dark'";

$result = mysqli_query($mysqli, $query);



/* numeric array */

while ($row = mysqli_fetch_array($result, MYSQLI_BOTH))

{

printf("%s %s %s %s %s\n", $row["chocolate.id_chocolate"], $row["chocolate.name_chocolate"], $row["type_chocolate.id_type_chocolate"],$row["type_chocolate.type_chocolate"],$row["type_chocolate.id_chocolate"]);?> <br>

<?php

}

?>

 

[Barand]

The column names in the query results wil be

• id_chocolate
• name_chocolate
• id_type_chocolate
• type_chocolate
• id_chocolate

The tablename. prefixes are not part of them.