fork download
copy 
  1. <?php
  2.  
  3. function pdo() {
  4. 	$stmt = $pdo->prepare('SELECT * FROM employees WHERE name = :name');
  5. 	$stmt->execute(array('name' => $name));
  6. 	foreach ($stmt as $row) {
  7. 	// do something with $row
  8. 	}
  9. }
  10. function mysqli() {
  11. 	$stmt = $dbConnection->prepare('SELECT * FROM employees WHERE name = ?');
  12. 	$stmt->bind_param('s', $name);
  13. 	$stmt->execute();
  14. 	$result = $stmt->get_result();
  15. 	while ($row = $result->fetch_assoc()) {
  16. 	// do something with $row
  17. 	}
  18. }
Success #stdin #stdout 0.03s 52480KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
https://ideone.com/BPCF1z
防止SQL注入
language:
PHP (php 7.3.5)
created:
9 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!