/** @api */ function execSql($s, $silent = false) { $rv = null; if (preg_match('/^\\s*select/i', $s)) { $sth = $this->dbh->query($s); $rv = $sth->fetchAll(\PDO::FETCH_ASSOC); if (!$silent) { print_rs($rv); } } else { $rv = $this->dbh->exec($s); if (!$silent) { echo "=== {$rv} records Affected.\n"; } } return $rv; }
<html> <body> <?php function print_rs($recordset) { while ($row = $recordset->fetch_assoc()) { print_r($row); } } $db = mysql_connect(); $result = mysql_query('SELECT NOW();'); if (!$result) { die('Invalid query: ' . mysql_error()); } echo $db; echo "<br>"; echo $result; echo "<br>"; print_rs($result); echo "<br>"; echo date("Y-m-d H:i:s"); echo "<br>"; echo "<br>"; echo "Try a <a href='/HelloWorld'>servlet</a>!"; ?> </body> </html>