View difference between Paste ID: A7bj7qWy and pWB3ki6A
SHOW: | | - or go back to the newest paste.
1
<?php
2
error_reporting(-1);
3
ini_set('display_errors', 1);
4
5
$dbHost = 'localhost';
6
$dbUser = 'root';
7
$dbPassword = 'password';
8
$dbName= 'testDB';
9
$dbCharset='utf8';
10
11
$dsn = sprintf('mysql:host=%s;dbname=%s;charset=%s',$dbHost,$dbName,$dbCharset);
12
try{
13
    $db = new PDO($dsn,$dbUser,$dbPassword);
14
    $db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
15
    $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE,PDO::FETCH_OBJ );
16
}catch (PDOException $e){
17
    die("Failed to connect to Database");
18
}
19
20
21
$sql = "SELECT field1,field2 FROM table WHERE something=:something";
22
23
$statement = $db->prepare($sql);
24
25
$parameters = [':something'=>$_GET['something']];
26-
$statement->execute($parameters);
26+
27
    $statement->execute($parameters);  
28
}catch (PDOException $e){
29
    die("Failed to execute SQL");
30
}
31
32
33
$rows = $statement->fetchAll();
34
35
foreach($rows as $row){
36
    echo $row->field1. ' - '.$row->field2.'<br/>';
37
}