Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class DBCLASS
- {
- function Connect()
- {
- try
- {
- $connect = new PDO("mysql:host=localhost;dbname=OOP", "root", "");
- $connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- }
- catch(PDOException $e ){
- echo "Connect Error: <p style='color: red'> " . $e ."</p>";
- }
- }
- public function getData($db, $query, $parm = [])
- {
- $stmt = $db->prepare($query);
- $stmt->execute($parm);
- $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
- return $rows;
- }
- public function setData($db, $query, $parm = [])
- {
- $stmt = $db->prepare($query);
- $stmt->execute($parm);
- $count = $stmt->rowCount();
- return $count;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement