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 | } |