Guest User

Untitled

a guest
Feb 8th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.50 KB | None | 0 0
  1. <?php
  2.  
  3. function connect_db()
  4. {
  5. $dsn = 'mysql:localhost=xxxx;dbname=xxxx;charset=utf8';
  6. $username = 'xxxx';
  7. $password = 'xxxx';
  8. $options =
  9. [
  10. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
  11. , PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
  12. ];
  13. return new PDO($dsn, $username, $password, $options);
  14. }
  15.  
  16. function insert($sql, $arr = [])
  17. {
  18. $pdo = connect_db();
  19. $stmt = $pdo->prepare($sql);
  20. $stmt->execute($arr);
  21. return $pdo->lastInsertId();
  22. }
  23.  
  24. function select($sql, $arr = [])
  25. {
  26. $pdo = connect_db();
  27. $stmt = $pdo->prepare($sql);
  28. $stmt->execute($arr);
  29. return $stmt->fetchAll();
  30. }
  31.  
  32. function h($string)
  33. {
  34. return htmlspecialchars($string, ENT_QUOTES, 'utf-8');
  35. }
  36.  
  37. try {
  38. $pdo = new PDO('mysql:host=127.0.0.1;dbname=test;charset=utf8','root','root', array(PDO::ATTR_EMULATE_PREPARES => false));
  39.  
  40. foreach ( $pdo->query ( 'select * from test' ) as $row ) {
  41. echo $row['imgname'].'<br>';
  42. }
  43. // fetchで回すなら
  44. // $stmt = $pdo->query("SELECT * FROM test");
  45. // while($row = $stmt -> fetch(PDO::FETCH_ASSOC)) {
  46. // echo $row['imgname'].'<br>';
  47. // }
  48.  
  49. //プリペアドステートメントの例
  50. $stmt = $pdo->prepare("SELECT * FROM test where test = ?");
  51. if ($stmt->execute(array('test1'))) {
  52. while ($row = $stmt->fetch()) {
  53. echo '<img src="'.$row['img_path'].'" alt="'.$row['title'].'" />';
  54. }
  55. }
  56.  
  57. } catch (PDOException $e) {
  58. exit('error!'.$e->getMessage());
  59. }
  60.  
  61. $pdo = null;// 切断
Add Comment
Please, Sign In to add comment