fetching all rows in my mysql database using ajax and php

Question

Guys i have a problem actually my php code is correct but i dont know why it display undefined into my client side script. Could somebody help me

here is my api.php this is where i put my php

<?php 
 $dbcon = mysqli_connect("localhost", "root", "", "orms") or die("Server not  available" . mysql_error());
 $data = array();
 $result = mysqli_query($dbcon,"SELECT * FROM cottages") or die(mysqli_error());            //query
//$array = mysqli_fetch_row($result);
$data = array();
while($row = mysqli_fetch_assoc($result))
 {
  $data[] = $row;
 }
 echo json_encode( $data )                          //fetch result    
?>

here is my client.php code

   <?php 
     $dbcon = mysqli_connect("localhost", "root", "", "orms") or die("Server not available" . mysql_error());
 ?>
<html>
 <head>
<script language="javascript" type="text/javascript" src="jquery.js">    </script>
 </head>
 <body>
  <h2> Client example </h2>
 <h3>Output: </h3>
  <div id="output"></div>

  <script id="source" language="javascript" type="text/javascript">

  $(function () 
  {
$.ajax({                                      
url: 'api.php', data: "POST", dataType: 'json',  success: function(rows)        
 {
   for (var i in rows)
   {
  var row = rows[i];          

  var cot_id = row[0];
  var image = row[1];
  $('#output').append("<b>cottage: </b>"+cot_id+"<b> image: </b>"+image)
              .append("<hr />");
      } 
     } 
       });

    }); 
  </script>

       </body>
         </html>

Thanks for your help in advance..

Since the script doesn't read parameters, it doesn't matter whether he uses GET or POST. — Barmar
– Barmar, Commented May 22, 2015 at 6:24
mysql_error() wont work with mysqli_connect different drivers. php.net/manual/en/mysqli.error.php — chris85
– chris85, Commented May 22, 2015 at 6:24
Hi Chris error still occured. with your suggestion to change it to mysqli_error(); — Patrick
– Patrick, Commented May 22, 2015 at 6:25

Barmar · Accepted Answer · 2015-05-22 06:27:40Z

1

You're using mysqli_fetch_assoc, so the row will be an associative array, which turns into a Javascript object. But in the Javascript code you're accessing row as if it's an array, not an object. You need to use the column names:

var cot_id = row.cot_id;
var image = row.image;

(I'm just guessing the column names, because you used SELECT * so I can't see the actual names in your table.)

answered May 22, 2015 at 6:27

Barmar

789k57 gold badges555 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Patrick Over a year ago

Hi barmar! very thanks to your help.. this is now working. but wait theres more ill be trying to include javascript on this one :) wait a minute ill post it in a while.

Collectives™ on Stack Overflow

fetching all rows in my mysql database using ajax and php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related