How to create PHP array from MySQL data

Question

I have a database with a column "regId" in a table users What I want to do is select all rows but only that column (SELECT regId FROM users)

However, in PHP, I want this as

Array("the first row ID", "the second row ID", and so on)

I am building an app using the Google Cloud Messaging and the registration IDs are needed in an array like "Array("something", "something else")

Here's my code

<?php
session_start();
require_once("global.php");



$qry = "SELECT `regId` FROM `users` WHERE regId IS NOT NULL"; //Here's where the IDs are
$fetchQry = mysqli_query($connection, $qry);

// Replace with the real server API key from Google APIs
$apiKey = "/////";

// Replace with the real client registration IDs




$registrationIDs = array("","","",""); //heres how they need the IDs

// Message to be sent
$message = "somethinnnnnn";

// Set POST variables
$url = 'https://android.googleapis.com/gcm/send';

$fields = array(
    'registration_ids' => $registrationIDs,
    'data' => array( "message" => $message ),
);
$headers = array(
    'Authorization: key=' . $apiKey,
    'Content-Type: application/json'
);

// Open connection
$ch = curl_init();

// Set the URL, number of POST vars, POST data
curl_setopt( $ch, CURLOPT_URL, $url);
curl_setopt( $ch, CURLOPT_POST, true);
curl_setopt( $ch, CURLOPT_HTTPHEADER, $headers);
curl_setopt( $ch, CURLOPT_RETURNTRANSFER, true);
//curl_setopt( $ch, CURLOPT_POSTFIELDS, json_encode( $fields));

curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
// curl_setopt($ch, CURLOPT_POST, true);
// curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode( $fields));

// Execute post
$result = curl_exec($ch);

// Close connection
curl_close($ch);
echo $result;
//print_r($result);
//var_dump($result);
?>

And I have checked similar questions and they all use a while loop such as

$rows = [];
while($row = mysqli_fetch_array($result))
{
    $rows[] = $row;
}

However, if I set the $registrationIDs variable equal to $rows or array($rows), it does not work! (even echoing them doesn't show the data)

possible duplicate of Convert SQL results into PHP array

m1xolyd1an
– m1xolyd1an

2015-07-22 03:33:42 +00:00
Commented Jul 22, 2015 at 3:33 — m1xolyd1an
– m1xolyd1an, Commented Jul 22, 2015 at 3:33

Community · Accepted Answer · 2017-05-23 11:43:48Z

1

I ended up sussing it out. Thanks to Create PHP array from MySQL column

Here's what I did:

$column = array();

while($row = mysqli_fetch_array($result)){
    $column[] = $row['regId'];
//Edited - added semicolon at the End of line.1st and 4th(prev) line

}

I did earlier try this however it was originally mysql and not mysqli!! I then also set my $registrationIDs variable equal to $column

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Jul 22, 2015 at 3:54

Callum Atwal

1651 silver badge11 bronze badges

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

1 Comment

Abdul Jabbar Over a year ago

Callum when you know there is already a question like that then you should remove yours otherwise you will get down voted for making site bulky with same repeated questions.

stevenlee · Accepted Answer · 2015-07-22 03:50:29Z

0

try this one:

$rows = [];
while($row = mysqli_fetch_array($fetchQry)) {
    $rows[] = $row;
}

see if it can work.

answered Jul 22, 2015 at 3:50

stevenlee

315 bronze badges

2 Comments

Callum Atwal Over a year ago

I did try something like that, however I've just posted my fix. Thanks tho! :)

stevenlee Over a year ago

U can use print_r($variable); to see the structure of any variables when u want to know what it contains.

Collectives™ on Stack Overflow

How to create PHP array from MySQL data

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related