Skip to content

Instantly share code, notes, and snippets.

@davepagurek

davepagurek/query.php

Created June 29, 2015 22:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save davepagurek/d567295dea4ea7a6b682 to your computer and use it in GitHub Desktop.
Save davepagurek/d567295dea4ea7a6b682 to your computer and use it in GitHub Desktop.
Download ZIP
PDO example
Raw
query.php
$DBH = new PDO("mysql:host=$host;dbname=$database", $username, $password);
$DBH->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
$STH=$DBH->prepare("SELECT * FROM jokes WHERE id=:joke");
$STH->setFetchMode(PDO::FETCH_ASSOC);
$STH->execute(array(":joke" => $joke));
$result = $STH->fetchAll();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment