PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE tbl_pdt ( order_id int, pdf boolean, zap boolean, date date );
Copy Clear
Copy Format Clear
<?php define('DB_PREFIX', 'tbl_'); $order_id=1; $query = "INSERT INTO " . DB_PREFIX . "pdt (order_id, pdf, zap, date) SELECT * FROM (SELECT '" . (int) $order_id . "', '" . true . "', '" . false . "', NOW()) AS tеmp WHERE NOT EXISTS (SELECT order_id FROM " . DB_PREFIX . "pdf WHERE order_id = '" . (int) $order_id . "')"; echo $query; $pdo->query( ); $stmt = $pdo->prepare("SELECT * FROM " . DB_PREFIX . "pdt"); $stmt->execute(); $rows = $stmt->fetch(PDO::FETCH_ASSOC); print_r($rows); echo 'end';
Show:  
Copy Clear