Run the array mutiple times

Question

Hey i need help, right now my script connect to an api and send a sms, 1 number at a time, I want it to pull from a local sql db then repeat the response for each number in the db!

`$data['post'] = array ( '_rnr_se' => $rnrse, 'phoneNumber' => '1234567890', 'text' => 'This is a test SMS!', 'id' => '' );

// Send the SMS $response = xcurl::fetch('api.phonegateway.com/', $data);

// Evaluate the response $value = json_decode($response['data']);`

Answer 1

Copy from the docs

mysql_connect("localhost", "mysql_user", "mysql_password") or
    die("Could not connect: " . mysql_error());
mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while ($row = mysql_fetch_array($result)) {
    $data['post'] = array ( '_rnr_se' => $row['number'], 'phoneNumber' => $row['phone_number'], 'text' => $row['text'], 'id' => '' );

// Send the SMS $response = xcurl::fetch('api.phonegateway.com/', $data);

// Evaluate the response $value = json_decode($response['data']);` 
}