Nsryjdtyk

I have My code Below. I have a function "getdet" that return array of record,but i cant able to print the all records the codes displaying only the first records may time. Pls help to solve this issue.

<?php



function getdet($qry){

global $con;

$Selecting=mysqli_query($con,$qry);

 $Fetch=mysqli_fetch_array($Selecting);

 return $Fetch;

 }

$qry="SELECT * FROM `tbs_employee` WHERE EmpId='1' limit 1";

$GetData=getdet($qry);

$i=0;

while($GetData){

echo $i."-".$GetData['EmpId'].":".$GetData['EmpName']."<br>";

$i++;

}

?>

Below is my Table

enter image description here

Here is my result

0-1:Fst Employee

1-1:Fst Employee

2-1:Fst Employee

3-1:Fst Employee

4-1:Fst Employee

5-1:Fst Employee

6-1:Fst Employee

.

.

.

infinity

Well, your function only return a data. Here's the right way:

<?php

function getdet($qry){

global $con;

$Selecting=mysqli_query($con,$qry);

  while($row=mysqli_fetch_array($Selecting, MYSQLI_ASSOC)){

    $Fetch = $row;

  }

 return $Fetch;

 }

$qry="SELECT * FROM `tbs_employee`";

$GetData=getdet($qry);

foreach($GetData as $i=>$row){

  echo $i."-".$row['EmpId'].":".$row['EmpName']."<br/>";

}

?>

You are running the same query ($Selecting=mysqli_query($con,$qry);) over and over again inside your getDet-Function, so it will never quit the while-loop:

while($GetData){

Should be:

$qry="SELECT * FROM `tbs_employee` WHERE EmpId='1' limit 1";

$Selecting=mysqli_query($con,$qry);

$i=0;

while($GetData = mysqli_fetch_array($Selecting)){

  echo $i."-".$GetData['EmpId'].":".$GetData['EmpName']."<br>";

  $i++;

}

mysqli_fetch_array will return null, if all results are returned, then the while-loop can exit.

In your query you filtered employers by the ID
WHERE EmpId='1' limit 1

If you wants to get all records, delete this statement.