i need to show data with php/mysql request .
here is the request :
$select_query = mysqli_query($connection,"select * from tblinvoices where clientid='" . $useridd . "'");
if (mysqli_num_rows($select_query) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($select_query)) {
echo "
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => 'https://localhost/api/invoices/" . $row["id"]. "',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'GET',
CURLOPT_HTTPHEADER => array(
'Authtoken: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyIjoiYW1jIiwibmFtZSI6ImRhbm9sIiwiQVBJX1RJTUUiOjE3MTYzNzg1OTl9.DVwo'
),
));
$response = curl_exec($curl);
curl_close($curl);
$datas = json_decode($response, true);
print_r($datas);
";
}
} else {
echo "0 results";
}
the result show this:
curl_setopt_array(, array( CURLOPT_URL => 'https://localhost/api/invoices/5891', CURLOPT_RETURNTRANSFER => true, CURLOPT_ENCODING => '', CURLOPT_MAXREDIRS => 10, CURLOPT_TIMEOUT => 0, CURLOPT_FOLLOWLOCATION => true, CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST => 'GET', CURLOPT_HTTPHEADER => array( 'Authtoken: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyIjoiYW1jIiwibmFtZSI6ImRhbm9sIiwiQVBJX1RJTUUiOjE3MTYzNzg1OTl9.DVwoIA_ZiaT8TOMo2jJ_e2HePGAkCdCsm' ), )); = curl_exec(); curl_close(); = json_decode(, true); print_r(); = curl_init(); curl_setopt_array(, array( CURLOPT_URL => 'https://localhost/api/invoices/28971', CURLOPT_RETURNTRANSFER => true, CURLOPT_ENCODING => '', CURLOPT_MAXREDIRS => 10, CURLOPT_TIMEOUT => 0, CURLOPT_FOLLOWLOCATION => true, CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST => 'GET', CURLOPT_HTTPHEADER => array( 'Authtoken: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c2VyIjoiYW1jIiwibmFtZSI6ImRhbm9sIiwiQVBJX1RJTUUiOjE3MTYzNzg1OTl9.DVwoIA_ZiaT8TOMo2jJ_e2HeP' ), )); = curl_exec(); curl_close(); = json_decode(, true); print_r(); = curl_init(); curl_setopt_array(, array( CURLOPT_URL => 'https://localhost/api/invoices/34736',
i need to show data from JSON API from loop with mysql fetch array .
please i nedd your help for it