Barand

mysql> select * from table1; +----+-----------+ | id | published | +----+-----------+ | 22 | 1 | | 23 | 0 | | 24 | 1 | | 25 | 1 | +----+-----------+ 4 rows in set (0.00 sec) mysql> select * from table2; +----+------+ | id | car | +----+------+ | 22 | A | | 23 | B | | 24 | C | | 25 | A | +----+------+ 4 rows in set (0.03 sec) mysql> SELECT car -> , sum(published) as tot -> FROM table1 -> JOIN table2 USING (id) -> GROUP BY car; +------+------+ | car | tot | +------+------+ | A | 2 | | B | 0 | | C | 1 | +------+------+ 3 rows in set (0.00 sec)

Try the manual https://www.php.net/manual/en/features.file-upload.php

Your expectations are a little high if you expected that outputting "Hello" twice would produce image #2.

try $timestamp = date("Y-m-d H:i:s");

The closest x or y can be to the edge is the radius of the ball. When either of them reach that position, change direction.

I'd have to write a book to answer that question.

As output is dependent on employee schedule and overlapping appointments, and I have no idea what is in your data, then you are on your own.

You have a prepared statement with 10 placeholders but your execute() only provides 6 values

The SQL tutorial link in my signature may help to get you started.

Oops! 🥵 Hence the success with the *100 fix. Gives weight to the definition of test data : That data for which the code works.

How about it ^ @ChenXiu? I've shown you mine, you show me yours.

Of course, to risk stating the obvious, you will have to substitute your parameters and column names. $stmt_emp = $con->prepare(" Select employee_id from employees_schedule where employee_id = ? and day_id = ? and to_hour > ? and from_hour < ? "); $stmt_emp->execute(array($selected_employee,$day_id,$start, $result));

I modified the code slightly tot add a 'total' element to each of the arrays to make sequence order easier to check. Revised code <?php $data = [ [ 'price' => 8.50, 'postage' => 3.50 ], [ 'price' => 6.18, 'postage' => 2.33 ], [ 'price' => 6.13, 'postage' => 0 ], [ 'price' => 4.19, 'postage' => 2.63 ], [ 'price' => 2.50, 'postage' => 1.80 ] ]; // add total element to arrays foreach ($data as &$a) { $a['total'] = $a['price'] + $a['postage']; } usort($data, function($a, $b) { return $a['price'] + $a['postage'] - $b['price'] - $b['postage']; }); echo '<pre>' . print_r($data, 1) . '</pre>'; // $data[1] and $data[2] are in wrong position ?> My results Array ( [0] => Array ( [price] => 2.5 [postage] => 1.8 [total] => 4.3 ) [1] => Array ( [price] => 6.13 [postage] => 0 [total] => 6.13 ) [2] => Array ( [price] => 4.19 [postage] => 2.63 [total] => 6.82 ) [3] => Array ( [price] => 6.18 [postage] => 2.33 [total] => 8.51 ) [4] => Array ( [price] => 8.5 [postage] => 3.5 [total] => 12 ) ) The order definitely looks correct.

You will basically need 2 things a for() loop the modulo (%) operator (optional)

Give the formatted date a column alias SELECT date_format(created_at, '%b %e %Y %h:%i%p') as created_at Without the alias you need to use $row["date_format(created_at, '%b %e %Y %h:%i%p')"]

You can do it in your query with SELECT date_format(created_at, '%b %e %Y %h:%i%p'), ... or you can do it in php with date('M j Y g:ia', strtotime($row['created_at']))

PS As an aside, you have a query to find employees schedules overlapping with the time period A - B. The possible overlapping cases are shown below The following WHERE clause will find all 4 types whereas yours won't. WHERE S < B AND E > A

Below is the result of my running your for() loop. The highlighted bit look very much like Sunday to me

Your array (with the 0) sorted correctly for me without bringing in the menagerie ???

Do your prices contain the '$'?

I didn't suggest a separate script - the one will suffice. if record is posted append to cart.txt end if open cart.txt for reading foreach record write table row end foreach

As you add each item, write name, quantity and price to your cart.txt file. Then read the stored items back from cart.txt and display them all, each in its own row, calculating the price for each PS You may find fgetcsv() useful here.

I'd go with a "token_transaction" table and store token accumulation/disposal in that instead of updating totals. TABLE: token_transaction transaction types +----+---------+------------+---------------------+-----+ +---------------+---------------+ | id | user_id | trans_type | trans_time | qty | | type | quantity | +----+---------+------------+---------------------+-----+ +---------------+---------------+ | 1 | 1 | earn | 2023-01-03 15:25:20 | 10 | | earn | +ve | | 2 | 2 | earn | 2023-01-03 15:25:20 | 10 | | receive | +ve | | 3 | 2 | donate | 2023-01-04 10:15:50 | -1 | | spend | -ve | | 4 | 3 | receive | 2023-01-04 10:15:50 | 1 | | donate | -ve | | 5 | 1 | donate | 2023-02-04 12:00:00 | -1 | | cancel | -ve | | 6 | 4 | receive | 2023-02-04 12:00:00 | 1 | +---------------+---------------+ | 7 | 1 | donate | 2023-01-14 14:49:29 | -3 | | 8 | 8 | receive | 2023-01-14 14:49:29 | 3 | | 9 | 8 | donate | 2023-01-14 14:51:13 | -2 | | 10 | 1 | receive | 2023-01-14 14:51:13 | 2 | +----+---------+------------+---------------------+-----+ When a donation is made, two transactions are generated, both with identical timestamps. negative quantity for the donor positive quantity for the recipient When you need to know how many tokens a user has, just SUM their quantities in the transactions. For example, given the transactions above SELECT user_id , username , COALESCE(SUM(qty), 0) as tokens FROM users u LEFT JOIN token_transaction t USING (user_id) GROUP BY username; +---------+----------+--------+ | user_id | username | tokens | +---------+----------+--------+ | 4 | blitzen | 1 | | 1 | comet | 8 | | 2 | cupid | 9 | | 5 | dancer | 0 | | 7 | dasher | 0 | | 3 | donner | 1 | | 6 | prancer | 0 | | 8 | vixen | 1 | +---------+----------+--------+ The donation code would then look like this <?php session_start(); include 'db_inc.php'; // USE YOUR OWN $pdo = pdoConnect(); // PDO CONNECTION CODE # # Ensure user is logged in # if (!isset($_SESSION['user_id'])) { header("Location: login.php"); exit; } $errors = []; # # Get user's current token quantity # $res = $pdo->prepare("SELECT sum(qty) as wealth FROM token_transaction WHERE user_id = ? "); $res->execute([ $_SESSION['user_id']]); $wealth = $res->fetchColumn() ?? 0; # # If data was POSTed, process it # if ($_SERVER['REQUEST_METHOD'] == 'POST') { $post = array_map('trim', $_POST); if ($post['recipient']=='') { $errors[] = 'You must specify a recipient'; } if ($post['qty']==0) { $errors[] = 'You did not specify how many tokens'; } elseif ($post['qty'] > $wealth) { $errors[] = 'You have insufficient tokens'; } if (!$errors) { $now = date('Y-m-d H:i:s'); $pdo->beginTransaction(); try { $stmt = $pdo->prepare("INSERT INTO token_transaction (user_id, trans_type, trans_time, qty) VALUES (?, ?, '$now', ?) "); $stmt->execute( [ $_SESSION['user_id'], 'donate', -$post['qty'] ] ); // donor transaction $stmt->execute( [ $post['recipient'], 'receive', $post['qty'] ] ); // recipient transaction $pdo->commit(); } catch(PDOException $e) { $pdo->rollBack(); throw $e; } header("Refresh: 0"); // reload the page exit; } } # # FUNCTIONS # function userOptions(PDO $pdo, $current) { $opts = "<option value=''>- select user -</option>\n"; $res = $pdo->query("SELECT user_id , username FROM users ORDER BY username "); foreach ($res as $r) { $sel = $r['user_id'] == $current ? 'selected' : ''; $opts .= "<option $sel value='{$r['user_id']}'>{$r['username']}</option>\n"; } return $opts; } ?> <!DOCTYPE html> <html lang="en"> <head> <title>sample</title> <meta charset="utf-8"> <script type='text/javascript'> </script> <style type='text/css'> body { font-family: arial; } header { background-color: #006EFC; color: white; padding: 16px; } #form1 { width: 500px; margin: 32px auto; padding: 16px; border: 1px solid gray; } #info { width: 500px; margin: 32px auto; padding: 16px; background-color: yellow; } label { display: inline-block; background-color: gray; color: white; padding: 8px; width: 120px } </style> </head> <body> <header> <h1>Token Donation</h1> </header> <div id='info'> <?php if ($errors) { echo "<p>" . join('<br>', $errors) . "</p>\n"; } else { echo "<p>You currently have <b>$wealth</b> tokens</p>\n"; } ?> </div> <form method='POST' id='form1'> <label for='recipient'>Donate to</label> <select name='recipient' id='recipient'> <?= userOptions($pdo, $post['recipient']??'') ?> </select> <br><br> <label for='qty'>How many?</label> <input type='number' name='qty' id='qty' min='0' max='<?=$wealth?>' value='<?= $post['qty'] ?? 1 ?>'> <br><br> <input type='submit'> </form> </body> </html>

Works for me with decimal values. <?php $data = [ [ 'price' => 8.50, 'postage' => 3.50 ], [ 'price' => 2.50, 'postage' => 1.50 ], [ 'price' => 7.50, 'postage' => 2.10 ], [ 'price' => 10.00, 'postage' => 1.50 ], [ 'price' => 2.50, 'postage' => 1.80 ] ]; usort($data, function($a, $b) { return $a['price'] + $a['postage'] - $b['price'] - $b['postage']; }); echo '<pre>' . print_r($data, 1) . '</pre>'; ?> results Array ( [0] => Array ( [price] => 2.5 [postage] => 1.5 ) [1] => Array ( [price] => 2.5 [postage] => 1.8 ) [2] => Array ( [price] => 7.5 [postage] => 2.1 ) [3] => Array ( [price] => 8.5 [postage] => 3.5 ) [4] => Array ( [price] => 10 [postage] => 1.5 ) )