*************

SQL code: Upload Copy Format Clear

CREATE TABLE ef_offers_master ( offer_id TEXT, offer_advid TEXT, offer_advertiser TEXT, offer_class TEXT, offer_weight TEXT, offer_timestamp TIMESTAMP WITH TIME ZONE ); INSERT INTO ef_offers_master (offer_id, offer_advid, offer_advertiser, offer_class, offer_weight) VALUES ('1','1','adv1','app-trial','0'), ('2','2','adv2','app-trial','A0'), ('3','3','adv3','app-search','B111'), ('4','4','adv4','app-search','0'), ('5','1','adv1','app-hm','B111'), ('6','2','adv2','app-misc','0'), ('7','2','adv2','app-hm','A'), ('8','3','adv3','app-trial','F211'), ('9,','5','adv5','app-trial','Z22'), ('10,','5','adv5','app-trial','X12'), ('11,','11','adv11','app-search','A1'); CREATE TABLE default_class_weights ( offer_class TEXT, default_weight TEXT ); INSERT INTO default_class_weights ( offer_class, default_weight) VALUES ('app-trial' , 'A'), ('app-hm', 'B'), ('app-search', 'C'); CREATE TABLE default_adv_weights ( advertiser_name TEXT, advertiser_id TEXT, advertiser_weight TEXT ); INSERT INTO default_adv_weights ( advertiser_name, advertiser_id, advertiser_weight) VALUES ('adv1' , '1', '111'), ('adv2', '2', '222'), ('adv3', '3', '333'), ('adv4', '4', '444');

SQL Server: Preserve result

Result: Copy Clear

PHP code: Copy Format Clear

<?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->query("SELECT * from ef_offers_master ORDER by offer_weight")->fetchall(PDO::FETCH_ASSOC); $newarray = array(); //$newarray = $stmt; $newarray[]= [ 'offer_id' => '11', 'offer_advid' => '12', 'offer_advertiser' => 'new one', 'offer_class ' => 'app-national', 'offer_weight' => 'M23' ]; $newarray2[]= [ 'offer_id' => '12', 'offer_advid' => '11', 'offer_advertiser' => 'adv11', 'offer_class ' => 'app-search', 'offer_weight' => 'x123' ]; $newarray2[] = [ 'offer_id' => '13', 'offer_advid' => '11', 'offer_advertiser' => 'adv11', 'offer_class ' => 'app-search', 'offer_weight' => 'W223', 'other row' => 'its a row' ]; $newArrayCombined = array(); foreach ($newarray as $item) { $newArrayCombined[] = $item; } foreach ($newarray2 as $item) { $newArrayCombined[] = $item; } print_r($newArrayCombined); usort($newArrayCombined, 'sortByName'); print_r($newArrayCombined); function sortByName($a, $b) { $a = $a['offer_weight']; $b = $b['offer_weight']; if ($a == $b) return 0; return ($a < $b) ? -1 : 1; } foreach($newarray3 as $row){ echo "<pre>"; //print_r($row); echo "</pre>"; } $event_timestamp = date('Y-m-d H:i:s'); $stmt = $pdo->query("UPDATE ef_offers_master SET offer_timestamp = '". $event_timestamp . "' WHERE offer_id = '1';")->fetchall(PDO::FETCH_ASSOC); $stmt = $pdo->query("select * from ef_offers_master")->fetchall(PDO::FETCH_ASSOC); //date_default_timezone_set('America/New_York'); $event_timestamp = date('Y-m-d H:i:s America/New_York); $stmt = $pdo->query("UPDATE ef_offers_master SET offer_timestamp = '". $event_timestamp . "' WHERE offer_id = '2';")->fetchall(PDO::FETCH_ASSOC); $stmt = $pdo->query("select * from ef_offers_master")->fetchall(PDO::FETCH_ASSOC); var_dump($stmt);

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online