PR7fhCp0

1<pre><?php
2
3//    CREATE TABLE IF NOT EXISTS `test` (
4//      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
5//      `title` varchar(100) NOT NULL,
6//      `created` datetime NOT NULL,
7//      PRIMARY KEY (`id`),
8//      KEY `created` (`created`)
9//    );
10//
11//    INSERT INTO `test` (`id`, `title`, `created`) VALUES
12//    (1, 'test1', '2009-04-22 13:11:50'),
13//    (2, 'test2', '2009-04-22 13:11:50');
14
15
16
17mysqli_report(MYSQLI_REPORT_ALL);
18
19$m = new mysqli('localhost', '***', '***', '***');
20
21$queries = array();
22$queries[] = "SELECT id FROM test WHERE created < NOW()";
23$queries[] = "SELECT title FROM test WHERE created < NOW()";
24$queries[] = "SELECT created FROM test WHERE created < NOW()";
25$queries[] = "SELECT id, title, created FROM test WHERE created < NOW()";
26$queries[] = "SELECT * FROM test WHERE created < NOW()";
27
28foreach ($queries as $query) {
29    try {
30        $m->query($query);
31        echo "Success: {$query}\n";
32    } catch (Exception $e) {
33        echo "Error: {$query}\n";
34    }
35}
36
37mysqli_report(MYSQLI_REPORT_OFF);
38
39// Result:
40//    Error: SELECT id FROM test WHERE created < NOW()
41//    Success: SELECT title FROM test WHERE created < NOW()
42//    Error: SELECT created FROM test WHERE created < NOW()
43//    Success: SELECT id, title, created FROM test WHERE created < NOW()
44//    Success: SELECT * FROM test WHERE created < NOW()
45
46
47?></pre>