Stripping JSON encoding of PHP array

Question

I have a MySQL query done using PHP, result is presented as array.

$stmt = $mysqli->prepare("SELECT word FROM words ORDER BY RAND() LIMIT 5");
    $stmt->bind_result($words);

$stmt->execute();
$result = array();

while ($stmt->fetch()) {
    $w = new StdClass();
    $w->word = $words;
    array_push($result, $w);
}
$stmt->close();

Then, i'm passing the array to javascript using JSON:

'words' : <?php echo json_encode($result); ?>,

But the output is:

[{"word":"Watermelon"},{"word":"Orange"},{"word":"Melon"},{"word":"Cucumber"},{"word":"Apple"}]

Is there any way to "strip" the "word" and make it look like that?

["Watermelon", "Orange", "Melon", "Cucumber", "Apple"]

Thank you in advance.

u_mulder · Accepted Answer · 2017-06-04 20:05:32Z

2

If you don't need array of objects ($ws) further in your code, you can simplify your code to:

$stmt = $mysqli->prepare("SELECT word FROM words ORDER BY RAND() LIMIT 5");
$stmt->bind_result($words);

$stmt->execute();
$result = array();

while ($stmt->fetch()) {
    array_push($result, $words);
}
$stmt->close();

answered Jun 4, 2017 at 20:05

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

2 Comments

Vlad Šutov Over a year ago

Thank you! Apparently i overcomplicated things :)

u_mulder Over a year ago

If answer helps - feel free to accept it, as answers for your previous questions. It helps both you and answerer)

Collectives™ on Stack Overflow

Stripping JSON encoding of PHP array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related