how to display output of PHP MySQL query using Angular

Question

I have written MySQL query to get a number of records from the table. I'm very new to angular js, I don't know how will I display output of it into the Angular js. kindly check with below PHP and MySQL query.

<?php

include("../include/connect.php");

$sql="SELECT clientDB_Status FROM ms_approach_clients where clientDB_Status='Lead-Successful'";

if ($result=mysqli_query($con,$sql))
  {
  // Return the number of rows in result set
  $rowcount=mysqli_num_rows($result);
  printf("Result set has %d rows.\n",$rowcount);
  // Free result set
  mysqli_free_result($result);

  }

mysqli_close($con);
?>

An introductory tutorial on Angular seems like the ideal place to start here. Tutorials will cover how to make an AJAX request and handle the response. — David
– David, Commented Apr 22, 2017 at 9:14

Md.Jewel Mia · Accepted Answer · 2017-04-22 09:32:40Z

1

You can try it.

<?php

include("../include/connect.php");

$sql="SELECT clientDB_Status FROM ms_approach_clients where clientDB_Status='Lead-Successful'";

if ($result=mysqli_query($con,$sql))
  {
  // Return the number of rows in result set
  $rowcount=mysqli_num_rows($result);
  printf("Result set has %d rows.\n",$rowcount);
  // Free result set
  $data = array();

while ($row = mysqli_fetch_array($result)) {
  $data[] = $row;
}
    print json_encode($data);


  }

mysqli_close($con);
?>

You can see example link

http://stackoverflow.com/questions/26229382/how-to-display-data-from-mysql-using-angular-js-php

answered Apr 22, 2017 at 9:32

Md.Jewel Mia

3,4573 gold badges22 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

how to display output of PHP MySQL query using Angular

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related