Trying to use JSON but getting '500 Internal Server Error'

Question

I'm back with another question.

I'm trying to create a JSON file that gets data from my MySQL database. The thing is, I'm getting the '500 Internal Server Error' message.

The Code:

<?php

header('Content-Type: application/json');

if (!isset($_GET['query'])) {
    echo json_encode([]);
    exit();
}

$db = new PDO('mysql:host=127.0.0.1;dbname=mydbname', 'mydbuser', 'mydbpaswd');

$users = $db->prepare("SELECT id, username FROM users WHERE username LIKE :query");

$users->execute(['query' => "{$_GET['query']}%"]);

echo json_encode($users->fetchAll());
?>

I typed in http://mylink.com/users.php?query=ch this should have given me a page with possible usernames starting with 'ch'.

P.S. I used basic names for some things to not show my actual names.

Thanks, in advance.

What version of PHP are you running ? That array syntax could be the problem. — Tom Tom, Feb 21 '15 at 13:52
also https://stackoverflow.com/questions/845021/how-to-get-useful-error-messages-in-php — Gordon, Feb 21 '15 at 13:58

Tom Tom · Accepted Answer · 2017-01-03T22:57:48.193

2

The $array = ['myindex' => 'somevalue'] syntax for arrays has been implemented in PHP 5.4. Try with array() instead.

edited Jan 03 '17 at 22:57

answered Feb 21 '15 at 13:57

Tom Tom

3,680
5
35
40

I'll try upgrading my PHP from 5.3.3 to a newer version and will report back once it's done. Thanks for your comment. – Chris Feb 21 '15 at 14:03

Trying to use JSON but getting '500 Internal Server Error'

1 Answers1