<?php
use Carbon\Carbon;
$now = Carbon::now()->format('d/m/Y');
printf("Today is %s\nCurrent PHP version: %s \n\n", $now, phpversion());
$query = "SELECT VERSION() as version;";
// get DB version using PDO
$stmt = $pdo->prepare($query);
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
printf('DB version (PDO): %s ' . PHP_EOL, $row['version']);
// Run query using mysqli
$result = $mysqli->query($query);
$version = $result->fetch_object();
printf('DB version (mysqli): %s ' . PHP_EOL, $version->version);
// Select using Laravel
$version = $db::select($db::raw("SELECT VERSION() as version;"));
printf('DB version (Laravel Query Builder): %s ' . PHP_EOL, $version[0]->version);
echo "<br/><br/><br/>";
$my_array = array(
array(
"id" => "1",
"date" => "2018-03-19",
"price" => "5",
"best" => '',
),
array (
"id" => "2",
"date" => "2018-03-19",
"price" => "50",
"best" => '',
),
array (
"id" => "3",
"date" => "2018-03-19",
"price" => "25",
"best" => '',
)
);
$numbers = array_column($my_array, "price", "id");
foreach($my_array as $k => $v){
$my_array[$k] = $v;
if(array_search(min($numbers), $numbers) == $v['id']){
$my_array[$k]['best'] = true;
}else{
$my_array[$k]['best'] = false;
}
}
print_r($my_array);