Add Value to First JSON PHP

Question

i have some php to show result as JSON like this

$dp = $_GET['dp'];

$query = mysql_query("select trip_id, trip_desc from current_data where dispatcher='".$dp."'");

$json = array();    

while($row = mysql_fetch_assoc($query)){

    $tripdata["code"]=$row["trip_id"]." - ".$row["trip_code"];

    $json[] = $tripdata;

}

echo json_encode($json);

and result like this

[{"code":"S1.001 - UK"},{"code":"S1.002 - US"},{"code":"S1.003 - CA"}]

How to add value in First Result of my JSON, i want to result like this?

 [**{"code":"Select Country"}**,{"code":"S1.001 - UK"},{"code":"S1.002 - US"},{"code":"S1.003 - CA"}]

Thanks

Please stop using mysql_* functions. These extensions have been removed in PHP 7. Learn about prepared statements for PDO and MySQLi and consider using PDO, it's really pretty easy. — Jay Blanchard
– Jay Blanchard, Commented Nov 6, 2017 at 13:29
Little Bobby says your script is at risk for SQL Injection Attacks.. Even escaping the string is not safe! — Jay Blanchard
– Jay Blanchard, Commented Nov 6, 2017 at 13:29
I know this method will risk with SQL Inject, but this Script only backend for Andorid APK. thanks for your response guys,,, ^_^ — coco_nk4l
– coco_nk4l, Commented Nov 6, 2017 at 13:48
What does that ^ mean? Are you saying it is OK to ignore the risk? — Jay Blanchard
– Jay Blanchard, Commented Nov 6, 2017 at 13:52

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

Push the first value to the array before the while loop:

$json[] = [
       'code' => 'Select Country',
     ];

while($row = mysql_fetch_assoc($query)){

    $tripdata["code"]=$row["trip_id"]." - ".$row["trip_code"];

    $json[] = $tripdata;

}

echo json_encode($json);

This will add a the desired value in the beginning of json.

Note:

mysql_* is deprecated as of php-5.5 and removed as of php-7. So instead use mysqli_* or PDO.
Why shouldn't I use mysql_* functions in PHP?

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Nov 6, 2017 at 13:32

mega6382

9,39217 gold badges52 silver badges73 bronze badges

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

2 Comments

coco_nk4l Over a year ago

Thanks mega6382 for your Answer

mega6382 Over a year ago

@coco_nk4l If the answer was helpful, please be sure to accept it.

Collectives™ on Stack Overflow

Add Value to First JSON PHP

1 Answer 1

Note:

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Note:

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related