<?php

    class DBmanager {
        private $conn;
        private $db = "oci:dbname=localhost/XE";
        function __construct() {
            $db_username = "hr";
            $db_password = "hr";
            try {
                $this->conn = new PDO($this->db,$db_username,$db_password);
            } catch(PDOException $e){
                echo ($e->getMessage());
            }
        }

        function vasarlo_regisztral($nev, $cim, $telefon, $e_mail, $szul_dat, $jelszo, $kell_hirlevel) {
            $reg_ideje=date('Y/m/d');
            $reg="INSERT INTO Vasarlok(va_id, nev, cim, telefon, e_mail, egyenleg, reg_ideje, torzsvasarlo, szul_datum, jelszo, kell_hirlevel)
                    VALUES(va_id.nextval, '$nev', '$cim', '$telefon', '$e_mail',
                    '0', to_date('$reg_ideje','yyyy/mm/dd'), '0', to_date('$szul_dat','yyyy/mm/dd'), '$jelszo', '$kell_hirlevel');";
            print $reg;
                try {
                    $val=$this->conn->exec($reg);
        }       catch(PDOException $e){
                echo ($e->getMessage());
            }
        }


        function termek_felvesz($nev, $kategoria, $ar, $leiras, $kep){

        }

        /*function termek_torol ($t_id) {
            $torol="DELETE FROM Termek WHERE t_id = '$t_id';";

            $term_torol=oci_parse($conn, $torol);
            oci_execute($term_torol);
        }*/

    }
    /*Jelszó titkosító*/
    function crypto($p){
        $pass = crypt($p);
        return md5($pass);

    }

?>