any one tells me resul is not displayed?

Question

<?php 

$stmt=DB_uf::prepare('SELECT c_id, c_name   FROM cata_log ORDER BY c_id, c_name') ;
  
     $stmt->execute();
    
  $result = $stmt->fetchall(PDO::FETCH_NUM);  
    foreach ($result as $key => $row) {
    $catalog = $row[':c_id'];
    $product_name = $row[':c_name'];
    echo $catalog ;
    echo $product_name;
   }
  
//if ($result->num_rows > 0) {}
//$stmt->execute();
?>

result finds as

Warning: Undefined array key ":c_id" in C:\xampp\htdocs\project\menu_selector.php on line 19

Warning: Undefined array key ":c_name" in C:\xampp\htdocs\project\menu_selector.php on line 20

Warning: Undefined array key ":c_id" in C:\xampp\htdocs\project\menu_selector.php on line 19

how i get feild valu from kindly help me? only this program improve

<?php 

$stmt=DB_uf::prepare('SELECT c_id, c_name   FROM cata_log ORDER BY c_id, c_name') ;
  
     $stmt->execute();
    
  $result = $stmt->fetchall(PDO::FETCH_NUM);  
    foreach ($result as $key => $row) {
    $catalog = $row[':c_id'];
    $product_name = $row[':c_name'];
    echo $catalog ;
    echo $product_name;
   }
  
//if ($result->num_rows > 0) {}
//$stmt->execute();
?>

Warning: Undefined array key ":c_id" in C:\xampp\htdocs\project\menu_selector.php on line 19

Warning: Undefined array key ":c_name" in C:\xampp\htdocs\project\menu_selector.php on line 20

Warning: Undefined array key ":c_id" in C:\xampp\htdocs\project\menu_selector.php on line 19

Warning: Undefined array key ":c_name" in C:\xampp\htdocs\project\menu_selector.php on line 20

Warning: Undefined array key ":c_id" in C:\xampp\htdocs\project\menu_selector.php on line 19

Warning: Undefined array key ":c_name" in C:\xampp\htdocs\project\menu_selector.php on line 20

print your array $row and you will see what your array keys are which have your values. You then use those key to show the values — Bhavik, Dec 09 '22 at 04:57

score 0 · Answer 1 · answered Dec 09 '22 at 05:01

delete the : in your arrayKeys

i.e.

<?php 

$stmt=DB_uf::prepare('SELECT c_id, c_name   FROM cata_log ORDER BY c_id, c_name') ;
  
     $stmt->execute();
    
  $result = $stmt->fetchall(PDO::FETCH_NUM);  
    foreach ($result as $key => $row) {
    $catalog = $row['c_id'];
    $product_name = $row['c_name'];
    echo $catalog ;
    echo $product_name;
   }
  
//if ($result->num_rows > 0) {}
//$stmt->execute();
?>

any one tells me resul is not displayed?

1 Answers1