PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE transaction ( tr_date DATE DEFAULT (CURRENT_DATE), tr_sched VARCHAR(8) ); INSERT INTO transaction (tr_sched) VALUES ('6:00 Am'), ('8:00 Am'), ('10:00 Am');
Copy Clear
Copy Format Clear
<?php $sql = <<<SQL SELECT tr_sched, 0 counter FROM transaction WHERE tr_date = CURRENT_DATE() SQL; var_export( array_column( $mysqli->query($sql)->fetch_all(MYSQLI_ASSOC), 'counter', 'tr_sched' ) );
Show:  
Copy Clear