PHP Array from mysql assoc

Question

Confusing my values so messy

Home Code

$user = getventList();
    $response = array();
    if(mysql_num_rows($user) > 0){
    while ($row = mysql_fetch_assoc($user)){
         $response[] = $row;
         echo json_encode($response);
    }
    } else {
         return false;
    }


enter code here

Function event this one is function to generate result from mysql

$result = mysql_query("SELECT * from event where status = '2'"); return $result;

Bad Result

[  {"cPID":"123","image_event":"enjoy.jpg"} 
]

[  {"cPID":"123","image_event":"enjoy.jpg"},
   {"cPID":"1234","image_event":"enjoy.jpg"}
]

[  {"cPID":"123","image_event":"enjoy.jpg"},
   {"cPID":"1234","image_event":"enjoy.jpg"},
   {"cPID":"12345","image_event":"enjoy.jpg"}
]

[  {"cPID":"123","image_event":"enjoy.jpg"},
   {"cPID":"1234","image_event":"enjoy.jpg"},
   {"cPID":"12345","image_event":"enjoy.jpg"},
   {"cPID":"123456","image_event":"enjoy.jpg"}
]

[  {"cPID":"123","image_event":"enjoy.jpg"},
   {"cPID":"1234","image_event":"enjoy.jpg"},
   {"cPID":"12345","image_event":"enjoy.jpg"},
   {"cPID":"123456","image_event":"enjoy.jpg"},
   {"cPID":"1234567","image_event":"enjoy.jpg"}
]

i wanna get only like the last array

[  {"cPID":"123","image_event":"enjoy.jpg"},
   {"cPID":"1234","image_event":"enjoy.jpg"},
   {"cPID":"12345","image_event":"enjoy.jpg"},
   {"cPID":"123456","image_event":"enjoy.jpg"},
   {"cPID":"1234567","image_event":"enjoy.jpg"}
]

This extension MySQL was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used. And if you start to use MySQLi, you will be able to simplify your code to json_encode(mysqli_fetch_all($user, MYSQLI_ASSOC)); — splash58
– splash58, Commented Jun 26, 2016 at 7:25

user2560539 · Accepted Answer · 2016-06-26 06:40:48Z

2

Move json_encode out of the while loop. Additionally quit using mysql and start using mysqli or PDO functions.

$user = getventList();
    $response = array();
    if(mysql_num_rows($user) > 0){
    while ($row = mysql_fetch_assoc($user)){
         $response[] = $row;          
    }
    } else {
         return false;
    }
    echo json_encode($response);

Now your output will be the expected one

[  {"cPID":"123","image_event":"enjoy.jpg"},
   {"cPID":"1234","image_event":"enjoy.jpg"},
   {"cPID":"12345","image_event":"enjoy.jpg"},
   {"cPID":"123456","image_event":"enjoy.jpg"},
   {"cPID":"1234567","image_event":"enjoy.jpg"}
]

answered Jun 26, 2016 at 6:40

user2560539

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

Collectives™ on Stack Overflow

PHP Array from mysql assoc

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related