PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
-- Adminer 4.8.1 MySQL 8.0.29-0ubuntu0.20.04.3 dump SET NAMES utf8; SET time_zone = '+00:00'; SET foreign_key_checks = 0; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; SET NAMES utf8mb4; CREATE TABLE `ref_history` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int DEFAULT NULL, `ref_id` int DEFAULT NULL, `amount` decimal(11,2) NOT NULL DEFAULT '0.00', `status` int NOT NULL DEFAULT '1', `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ); INSERT INTO `ref_history` (`user_id`, `ref_id`, `amount`) VALUES (2, 1, 100), (2, 1, 30), (4, 1, 30); CREATE TABLE `users` ( `id` int NOT NULL AUTO_INCREMENT, `username` varchar(255) DEFAULT NULL, `bets_amount` decimal(11,2) NOT NULL DEFAULT '0.00', `ref_used` varchar(25) DEFAULT NULL, `ref_invite` varchar(25) DEFAULT NULL, `register_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ); INSERT INTO `users` (`username`, `ref_used`, `ref_invite`) VALUES ('owner', NULL, 'abc'), ('admin', 'abc', NULL), ('guest', 'abc', NULL), ('user', 'abc', NULL); -- 2022-09-05 19:38:31
Copy Clear
Copy Format Clear
<?php use Carbon\Carbon; $users = $db::table('users') ->join('ref_history', 'users.id', '=', 'ref_history.user_id') ->where(['users.ref_used' => 'abc']) ->orderBy('users.id', 'desc') ->select(['users.id', 'users.username', 'users.bets_amount', 'users.register_at', 'SUM(ref_history.amount)']) ->get(); var_dump($users); /*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);*/
Show:  
Copy Clear