<?php
    class pdo_handler{

        public $DBH;

        //Connection, MIGHT OUTSOURCE IT TO INDIA (aka another file).
        public function __construct(){
            $host = 'localhost';
            $dbname = 'wedding';
            $user = 'root';
            $pass = 'root';

            try{
            //MySQL with PDO_MYSQL
              $this->DBH = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8", PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));

            }catch(PDOException $e){
                echo $e->getMessage();
            }

        }

        //Function to insert data, takes an associative array, builds a strings to insert data securely using PDO in the table specified.
        public function insert($array, $table){
            $string = '';

            foreach($array as $key => $value){
                $string .=  ":" . $key . ", ";
            }

            $string =  substr($string, 0, -2);

            $STH = $this->DBH->prepare("INSERT INTO $table values(" . $string . ")");
            $STH->execute($array);

        }

        //Select function returns an array with all the rows affected, each array has all the column names requested, also returns the [rows] affected.
        public function select($what, $where){
            $i = 0;
            $data = array();

            $STH = $this->DBH->query("SELECT $what from $where");
            $STH->setFetchMode(PDO::FETCH_ASSOC);

            while($row = $STH->fetch()){
                foreach($row as $key => $value){
                    $data[$i][$key] = $value;
                }
                $i++;
            }
            $data['rows'] = $i;
            return $data;
        }

    }

?>