Advertisement
Guest User

db

a guest
Nov 29th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.61 KB | None | 0 0
  1. <?php
  2. $dbName="Ody";
  3. $dbUser="root";
  4. $dbPass="";
  5. try{
  6.  $con= new PDO("mysql:host=localhost;dbname=$dbName", $dbUser, $dbPass);
  7.  $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  8. }catch(PDOException  $e ){
  9. echo "Error: <p style='color: red'>".$e->getMessage()."</p>";
  10. }
  11.  
  12. function getData($db,$query,$parm = []) {
  13.   $stmt = $db->prepare($query);
  14.   $stmt->execute($parm);
  15.   $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
  16.   return $rows;
  17. }
  18. function setData($db,$query,$parm = []) {
  19.   $stmt = $db->prepare($query);
  20.   $stmt->execute($parm);
  21.   $count = $stmt->rowCount();
  22.   return $count;
  23. }
  24. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement