Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function connect_db()
- {
- $dsn = 'mysql:localhost=xxxx;dbname=xxxx;charset=utf8';
- $username = 'xxxx';
- $password = 'xxxx';
- $options =
- [
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
- , PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
- ];
- return new PDO($dsn, $username, $password, $options);
- }
- function insert($sql, $arr = [])
- {
- $pdo = connect_db();
- $stmt = $pdo->prepare($sql);
- $stmt->execute($arr);
- return $pdo->lastInsertId();
- }
- function select($sql, $arr = [])
- {
- $pdo = connect_db();
- $stmt = $pdo->prepare($sql);
- $stmt->execute($arr);
- return $stmt->fetchAll();
- }
- function h($string)
- {
- return htmlspecialchars($string, ENT_QUOTES, 'utf-8');
- }
- try {
- $pdo = new PDO('mysql:host=127.0.0.1;dbname=test;charset=utf8','root','root', array(PDO::ATTR_EMULATE_PREPARES => false));
- foreach ( $pdo->query ( 'select * from test' ) as $row ) {
- echo $row['imgname'].'<br>';
- }
- // fetchで回すなら
- // $stmt = $pdo->query("SELECT * FROM test");
- // while($row = $stmt -> fetch(PDO::FETCH_ASSOC)) {
- // echo $row['imgname'].'<br>';
- // }
- //プリペアドステートメントの例
- $stmt = $pdo->prepare("SELECT * FROM test where test = ?");
- if ($stmt->execute(array('test1'))) {
- while ($row = $stmt->fetch()) {
- echo '<img src="'.$row['img_path'].'" alt="'.$row['title'].'" />';
- }
- }
- } catch (PDOException $e) {
- exit('error!'.$e->getMessage());
- }
- $pdo = null;// 切断
Add Comment
Please, Sign In to add comment