Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- error_reporting(-1);
- ini_set('display_errors', 1);
- $dbHost = 'localhost';
- $dbUser = 'root';
- $dbPassword = 'password';
- $dbName= 'testDB';
- $dbCharset='utf8';
- $dsn = sprintf('mysql:host=%s;dbname=%s;charset=%s',$dbHost,$dbName,$dbCharset);
- try{
- $db = new PDO($dsn,$dbUser,$dbPassword);
- $db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
- $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE,PDO::FETCH_OBJ );
- }catch (PDOException $e){
- die("Failed to connect to Database");
- }
- $sql = "SELECT field1,field2 FROM table WHERE something=:something";
- $statement = $db->prepare($sql);
- $parameters = [':something'=>$_GET['something']];
- try{
- $statement->execute($parameters);
- }catch (PDOException $e){
- die("Failed to execute SQL");
- }
- $rows = $statement->fetchAll();
- foreach($rows as $row){
- echo $row->field1. ' - '.$row->field2.'<br/>';
- }
Add Comment
Please, Sign In to add comment