Create a Json array in a for loop - php

Question

<?php
include '../connection.php';

$sql="SELECT userid,name,batch FROM dbusers";
$results=mysql_query($sql) or die("Cannot execute query");
$count=mysql_num_rows($results);
$arr=array();
for($i=0; $i < $count; $i++){
$rows=mysql_fetch_array($results);
//What to put here ?
}
json_encode($arr);

?>

This is my php code. I want to ask what to put inside the for loop so that I can create a an array of array in php. The inner array will have userid, name and batch as its elements .

mickmackusa · Accepted Answer · 2021-03-24 06:40:02Z

3

What to put here ?

$arr[] = $rows;

Full code

<?php
include '../connection.php';

$sql="SELECT userid,name,batch FROM dbusers";
$results=mysql_query($sql) or die("Cannot execute query");
$count=mysql_num_rows($results);
$arr=array();
for($i=0; $i < $count; $i++){
    $rows=mysql_fetch_array($results, MYSQL_ASSOC);//use MYSQL_ASSOC so you wouldn't have duplicate data
    $arr[] = $rows;
}
$json = json_encode($arr);

?>

edited Mar 24, 2021 at 6:40

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

answered Jan 10, 2013 at 5:43

Musa

97.9k17 gold badges123 silver badges144 bronze badges

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

Comments

2 revs, 2 users 86% · Accepted Answer · 2021-03-24 06:40:35Z

0

<?php
include '../connection.php';

$sql     = "SELECT userid,name,batch FROM dbusers";
$results = mysql_query($sql) or die("Cannot execute query");
$arr     = array();

while($rows = mysql_fetch_assoc($results)){
    $arr[] = $row;
}
echo json_encode($arr);

?>

try this.

edited Mar 24, 2021 at 6:40

community wiki

2 revs, 2 users 86%
Prasanth Bendra

Collectives™ on Stack Overflow

Create a Json array in a for loop - php

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related