php json_encode array acess

Question

i am tring to get a json request from query string id it almost works but it is adding somesort of extra array object

$id = $_GET['id']; 
$result = mysqli_query($con,'SELECT * FROM ContactInfo WHERE id =' . $id );
$row = mysqli_fetch_array($result);
echo json_encode($row);

{"0":"terry","FirstName":"terry","1":"rihoff","LastName":"rieff","2":"alientory","website":"alieory","3":"`123","PhoneNumber":"`123","4":"123","Fax":"123","5":"2","id":"2"}

i should only be getting one contact but looks like exrtra array being add to each field

AbraCadaver · Accepted Answer · 2014-03-06 18:54:24Z

1

mysqli_fetch_array() returns an array with numeric and string keys so you have the data twice (once with a numeric index and once with a string index). Try:

$row = mysqli_fetch_assoc($result);

Or:

$row = mysqli_fetch_array($result, MYSQLI_ASSOC);

answered Mar 6, 2014 at 18:54

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

1 Comment

Terry Over a year ago

both those option worked great thanks i new it had to be something simple

Collectives™ on Stack Overflow

php json_encode array acess

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related