1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
| $REQ_RESULTS = mysqli_query($_DB_CON, 'SELECT * FROM MEALS');
while($DATA_RESULTS = mysqli_fetch_assoc($REQ_RESULTS))
{
$DATA_COOK = mysqli_fetch_assoc(mysqli_query($_DB_CON, 'SELECT * FROM USERS WHERE ID_UNIQUE = "'.$DATA_RESULTS['FROM_USER'].'"'));
$DISTANCE_TO = urlencode(''.$DATA_COOK['FULL_ADRESS'].'');
$DISTANCE_DATA = json_decode(file_get_contents('http://maps.googleapis.com/maps/api/distancematrix/json?origins='.$DISTANCE_FROM.'&destinations='.$DISTANCE_TO.'&sensor=false'));
$DISTANCE_TIME = 0;
$DISTANCE_DISTANCE = 0;
foreach($DISTANCE_DATA->rows[0]->elements as $DISTANCE_ROAD)
{
$DISTANCE_TIME = $DISTANCE_ROAD->duration->text;
$DISTANCE_DISTANCE = $DISTANCE_ROAD->distance->text;
}
$a = array(
'distance' => $DISTANCE_DISTANCE
);
asort($a);
foreach ($a as $k => $v)
{
$PRICE = $DATA_RESULTS['PRICE'];
$PRICE = number_format(($PRICE), 2, '.', '');
$FROM_CURRENCY = $DATA_RESULTS['CURRENCY'];
if($FROM_CURRENCY == $TO_CURRENCY)
if($TO_CURRENCY == 'USD')
$PRICE_CONVERTED = '$ '.$PRICE .'';
else
$PRICE_CONVERTED = $PRICE .' '. $CURRENCY_SYMBOL[''.$FROM_CURRENCY.''];
elseif($TO_CURRENCY == 'USD')
$PRICE_CONVERTED = '$ '. round(currencyConverter($FROM_CURRENCY, $TO_CURRENCY, $PRICE), 2);
else
$PRICE_CONVERTED = round(currencyConverter($FROM_CURRENCY, $TO_CURRENCY, $PRICE), 2) .' '. $CURRENCY_SYMBOL[''.$TO_CURRENCY.''];
echo '<div class="meal">
<div style="background-image:url(themes/'.$_THEME.'/img/img1.jpg)" class="mealImg">
<p class="mealPrice">'.$PRICE_CONVERTED.'</p>
</div>
<div class="mealContent">
<a href="#"><h3>'.$DATA_RESULTS['TITLE'].'</h3></a>
<p>'.$DATA_RESULTS['DESCRIPTION'].'</p><br>
<p class="mealInfo">'.$DATA_COOK['CITY'].'</b></p>
<p class="mealInfo">'.$DISTANCE_DISTANCE.'</b></p>
<p class="mealInfo">'.$lang['RESULTS_NBR_OF_PART'].' <b>'.$DATA_RESULTS['PARTS'].'</b></p>
<p class="mealInfo">'.$lang['RESULTS_FROM'].' <b>16:00</b> '.$lang['RESULTS_TO'].' <b>19:00</b></p>
<div class="separator"></div>
<a href="#" class="mealProfil">
<div class="mealProfilImg" style="background-image:url(themes/'.$_THEME.'/img/Amaury.jpg)"></div>
'.$DATA_COOK['FIRSTNAME'].'
</a>
</div>
</div>';
}
} |
Partager