fork(2) download
copy 
  1. <?php
  2.  
  3. 	/*
  4. 		PDO-SQLite Example using prepared statements with IN Clause
  5. 	*/
  6.  
  7.         echo "<pre>";
  8.         try {
  9.                 $db = new PDO('sqlite:/tmp/mydb.sq3');
  10. 		$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  11.                 if (!$db->query('SELECT * FROM test') && stripos($db->errorInfo()[2], 'no such table') !== FALSE) {
  12.                         $db->query("CREATE TABLE test (id INTEGER PRIMARY KEY, data VARCHAR(50))");
  13.                         $stmt = $db->prepare("INSERT INTO test(data) VALUES(?)");
  14.                         foreach (array('foo','bar','baz','quix') as $d) {
  15.                                 $stmt->execute(array($d));
  16.                         }
  17.                 }
  18. 		$args = array(1,3,4);
  19. 		$params = implode(',',array_fill(0, count($args), '?'));
  20. 		$stmt = $db->prepare("SELECT * FROM test WHERE id IN ($params)");
  21. 		$stmt->execute($args);
  22.                 foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row => $data) {
  23.                         echo "Row #$row:\t\t{$data['id']}\t{$data['data']}\n";
  24.                 }
  25.         }
  26.         catch(PDOException $e) {
  27.                 echo "Connection failed: {$e->getMessage()}\n";
  28.         }
  29.         echo "</pre>";
  30. ?>
Runtime error #stdin #stdout 0.02s 13664KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Parse error: syntax error, unexpected '[' in /home/VWg868/prog.php on line 11
https://ideone.com/XklUB
language:
PHP (php 7.3.5)
created:
13 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!