PHPize Online / SQLize Online  /  SQLtest Online

<?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);