Php pdo oops crud functions

See more:

PHP

PDO

Hi Everyone,

Just wondering if anyone can shed some light and direction to make this pdo class works and sanitize data.

The first part of the code works fine DB extend PDO, but the delete function doesnt work and i would like the delete function to sanitize the data before it performs the delete action, such as check the where clause and sanitize.


Any help is highly appreciated and thanks for reading.

What I have tried:

<?php

    class DB extends PDO {
    protected $db_name = "xxxx";
    protected $db_user = "root";
    protected $db_pass = "";
    protected $db_host = "localhost";

    public function __construct() {
        try {
            parent::__construct("mysql:host={$this->db_host};dbname={$this->db_name}", $this->db_user, $this->db_pass);
        } catch (PDOException $e) {
            //echo $e->getMessage();
echo "Failed to connect with MySQL: " . $e->getMessage();
        }    } 
  
// This where the CURD functions i am having issue, the DBConnect I tried to create the connection is failing.  See my code below:
     
	public function delete($table,$cond,$limit=1){
      $sql = "DELETE FROM $table WHERE $cond LIMIT $limit ";
      return $this->DBconnect->exec($sql);
    }
	
    // Validate data
        public function test_input($data) {
            $data = trim($data);
            $data = stripslashes($data);
            $data = htmlspecialchars($data);
            return $data;        }
        
}
?>