harrypotterse
4/26/2018 - 12:36 PM

Judy_Hopps_II

Judy_Hopps_II

<?php
    class harry_potter {

        const Database = 'php';
        const username = 'root';
        const password = '';
        const Server = 'localhost';

        public $array;
        public $tablename = "";
        public $msg_ins = "";
        public $msg_up = "";
        public $db = "";
        public $localhost = "";
        public $pas = "";
        public $user = "";
        public $id_up = ""; //اسم المستخدم   
        public $ok = false;

        public function __construct($table, Array $value)
        {
            $this->localhost = harry_potter::Server;
            $this->user = harry_potter::username;
            $this->pas = harry_potter::password;
            $this->db = harry_potter::Database;
            $this->tablename = $table;
            $this->tablename = $table;
            $this->array = $value;
        }

        function get_num_of_words($string)
        {
            $string = preg_replace('/\s+/', ' ', trim($string));
            $words = explode(" ", $string);
            return count($words);
        }

        public function up_col_2_Basic($var1, $id)
        {
            try {
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];

//----------------------------------------------------------
                $sql = "UPDATE `$tablename` SET `$coulam1` = :$coulam1  WHERE  `id` = :id;";
                $con = $this->con_db();
                if ($statement = $con->prepare($sql))
                {
                    $statement->bindValue(":$coulam1", $var1, PDO::PARAM_STR);
                    $statement->bindValue(":id", $id, PDO::PARAM_INT);
                    if ($statement->execute())
                    {
                        $this->msg_up;
                    }
                }
            } catch (PDOException $exc) {
                $exc->getMessage();
            }
        }

        public function up_col_3($var1, $var2, $id)
        {
            try {
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];

                $coulam2 = $column[2];

//----------------------------------------------------------
                $sql = "UPDATE `$tablename` SET `$coulam1` = :$coulam1, `$coulam2` = :$coulam2  WHERE  `id` = :id;";
                $con = $this->con_db();
                if ($statement = $con->prepare($sql))
                {
                    $statement->bindValue(":$coulam1", $var1, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam2", $var2, PDO::PARAM_STR);
                    $statement->bindValue(":id", $id, PDO::PARAM_INT);
                    if ($statement->execute())
                    {
                        echo $this->msg_up;
                    }
                }
            } catch (PDOException $exc) {
                echo $exc->getMessage();
            }
        }

        public function up_col_4($var1, $var2, $var3, $id)
        {
            try {
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];

                $coulam2 = $column[2];

                $coulam3 = $column[3];

//----------------------------------------------------------
                $sql = "UPDATE `$tablename` SET `$coulam1` = :$coulam1, `$coulam2` = :$coulam2, `$coulam3` = :$coulam3  WHERE  `id` = :id;";
                $con = $this->con_db();
                if ($statement = $con->prepare($sql))
                {
                    $statement->bindValue(":$coulam1", $var1, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam2", $var2, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam3", $var3, PDO::PARAM_STR);
                    $statement->bindValue(":id", $id, PDO::PARAM_INT);
                    if ($statement->execute())
                    {
                        echo $this->msg_up;
                    }
                }
            } catch (PDOException $exc) {
                echo $exc->getMessage();
            }
        }

        public function up_col_5($var1, $var2, $var3, $var4, $id)
        {
            try {
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];

                $coulam2 = $column[2];

                $coulam3 = $column[3];

                $coulam4 = $column[4];

//----------------------------------------------------------
                $sql = "UPDATE `$tablename` SET `$coulam1` = :$coulam1, `$coulam2` = :$coulam2, `$coulam3` = :$coulam3, `$coulam4` = :$coulam4  WHERE  `id` = :id;";
                $con = $this->con_db();
                if ($statement = $con->prepare($sql))
                {
                    $statement->bindValue(":$coulam1", $var1, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam2", $var2, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam3", $var3, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam4", $var4, PDO::PARAM_STR);
                    $statement->bindValue(":id", $id, PDO::PARAM_INT);
                    if ($statement->execute())
                    {
                        echo $this->msg_up;
                    }
                }
            } catch (PDOException $exc) {
                echo $exc->getMessage();
            }
        }

        public function up_col_6($var1, $var2, $var3, $var4, $var5, $id)
        {
            try {
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];

                $coulam2 = $column[2];

                $coulam3 = $column[3];

                $coulam4 = $column[4];

                $coulam5 = $column[5];

//----------------------------------------------------------
                $sql = "UPDATE `$tablename` SET `$coulam1` = :$coulam1, `$coulam2` = :$coulam2, `$coulam3` = :$coulam3, `$coulam4` = :$coulam4, `$coulam5` = :$coulam5  WHERE  `id` = :id;";
                $con = $this->con_db();
                if ($statement = $con->prepare($sql))
                {
                    $statement->bindValue(":$coulam1", $var1, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam2", $var2, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam3", $var3, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam4", $var4, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam5", $var5, PDO::PARAM_STR);
                    $statement->bindValue(":id", $id, PDO::PARAM_INT);
                    if ($statement->execute())
                    {
                        echo $this->msg_up;
                    }
                }
            } catch (PDOException $exc) {
                echo $exc->getMessage();
            }
        }

        public function up_col_7($var1, $var2, $var3, $var4, $var5, $var6, $id)
        {
            try {
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];

                $coulam2 = $column[2];

                $coulam3 = $column[3];

                $coulam4 = $column[4];

                $coulam5 = $column[5];

                $coulam6 = $column[6];


//----------------------------------------------------------
                $sql = "UPDATE `$tablename` SET `$coulam1` = :$coulam1, `$coulam2` = :$coulam2, `$coulam3` = :$coulam3, `$coulam4` = :$coulam4, `$coulam5` = :$coulam5 , `$coulam6` = :$coulam6  WHERE  `id` = :id;";
                $con = $this->con_db();
                if ($statement = $con->prepare($sql))
                {
                    $statement->bindValue(":$coulam1", $var1, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam2", $var2, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam3", $var3, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam4", $var4, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam5", $var5, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam6", $var6, PDO::PARAM_STR);

                    $statement->bindValue(":id", $id, PDO::PARAM_INT);
                    if ($statement->execute())
                    {
                        echo $this->msg_up;
                    }
                }
            } catch (PDOException $exc) {
                echo $exc->getMessage();
            }
        }

        public function up_col_8($var1, $var2, $var3, $var4, $var5, $var6, $var7, $id)
        {
            try {
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];
                $coulam1 = $column[1];

                $coulam2 = $column[2];

                $coulam3 = $column[3];

                $coulam4 = $column[4];


                $coulam6 = $column[6];

                $coulam7 = $column[7];

//----------------------------------------------------------
                $sql = "UPDATE `$tablename` SET `$coulam1` = :$coulam1, `$coulam2` = :$coulam2, `$coulam3` = :$coulam3, `$coulam4` = :$coulam4, `$coulam5` = :$coulam5 , `$coulam6` = :$coulam6, `$coulam7` = :$coulam7  WHERE  `id` = :id;";
                $con = $this->con_db();
                if ($statement = $con->prepare($sql))
                {
                    $statement->bindValue(":$coulam1", $var1, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam2", $var2, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam3", $var3, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam4", $var4, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam5", $var5, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam6", $var6, PDO::PARAM_STR);
                    $statement->bindValue(":$coulam7", $var7, PDO::PARAM_STR);
                    $statement->bindValue(":id", $id, PDO::PARAM_INT);
                    if ($statement->execute())
                    {
                        echo $this->msg_up;
                    }
                }
            } catch (PDOException $exc) {
                echo $exc->getMessage();
            }
        }

        public function con_db()
        {
            try {
                //  jjjjj  "mysql:host=$this->localhost;dbname=$this->db";
                //  "<br>" . $this->user, $this->pas + "<br>";
                $cnn = new PDO("mysql:host=$this->localhost;dbname=$this->db;charset=utf8", $this->user, $this->pas);
                $cnn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                $cnn->exec('SEt NAMES utf8');
                "CONECT OK";
                return $cnn;
            } catch (PDOException $exc) {
                echo 'NOT conected' . $exc->getMessage();
            }
        }

        public function Malcom_xx_up($id)
        {
            $keys = array_keys($this->array);
            $count = count($this->array);
            if ($count == 2)
            {
                $valyes = array_values($this->array);
                $val = $valyes[1];
                try {
                    $cdn = $this->con_db();
                    $tablename = $this->tablename;
                    $select = $cdn->query('SELECT * FROM ' . $tablename);
                    $total_column = $select->columnCount();
                    for ($counter = 0; $counter <= $total_column; $counter ++)
                    {
                        $meta = $select->getColumnMeta($counter);
                        $column[] = $meta['name'];
                    }
                    $coulam = $column[0];

                    $coulam1 = $column[1];

                    //----------------------------------------------------------
                    $sql = "UPDATE `$tablename` SET `$coulam1` = :$coulam1  WHERE  `id` = :id;";
                    $con = $this->con_db();
                    if ($statement = $con->prepare($sql))
                    {
                        $statement->bindValue(":$coulam1", $val, PDO::PARAM_STR);
                        $statement->bindValue(":id", $id, PDO::PARAM_INT);
                        if ($statement->execute())
                        {
                            echo $this->msg_up;
                        }
                    }
                } catch (PDOException $exc) {
                    echo $exc->getMessage();
                }
            }
            elseif ($count == 3)
            {
                $valyes = array_values($this->array);
                $val = $valyes[0];
                $val2 = $valyes[1];
                $val3 = $valyes[2];

                try {
                    $cdn = $this->con_db();
                    $tablename = $this->tablename;
                    $select = $cdn->query('SELECT * FROM ' . $tablename);
                    $total_column = $select->columnCount();
                    for ($counter = 0; $counter <= $total_column; $counter ++)
                    {
                        $meta = $select->getColumnMeta($counter);
                        $column[] = $meta['name'];
                    }
                    $coulam = $column[0];
                    $coulam1 = $column[1];

                    $coulam2 = $column[2];

                    //----------------------------------------------------------
                    $sql = "UPDATE `$tablename` SET `$coulam1` = :$coulam1, `$coulam2` = :$coulam2  WHERE  `id` = :id;";
                    $con = $this->con_db();
                    if ($statement = $con->prepare($sql))
                    {
                        $statement->bindValue(":$coulam1", $val2, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam2", $val3, PDO::PARAM_STR);
                        $statement->bindValue(":id", $id, PDO::PARAM_INT);
                        if ($statement->execute())
                        {
                            echo $this->msg_up;
                        }
                    }
                } catch (PDOException $exc) {
                    echo $exc->getMessage();
                }
            }
            elseif ($count == 4)
            {
                $valyes = array_values($this->array);
                $val = $valyes[0];
                $val2 = $valyes[1];
                $val3 = $valyes[2];
                $val4 = $valyes[3];
                try {
                    $cdn = $this->con_db();
                    $tablename = $this->tablename;
                    $select = $cdn->query('SELECT * FROM ' . $tablename);
                    $total_column = $select->columnCount();
                    for ($counter = 0; $counter <= $total_column; $counter ++)
                    {
                        $meta = $select->getColumnMeta($counter);
                        $column[] = $meta['name'];
                    }
                    $coulam = $column[0];
                    $coulam1 = $column[1];

                    $coulam2 = $column[2];

                    $coulam3 = $column[3];

                    //----------------------------------------------------------
                    $sql = "UPDATE `$tablename` SET `$coulam1` = :$coulam1, `$coulam2` = :$coulam2, `$coulam3` = :$coulam3  WHERE  `id` = :id;";
                    $con = $this->con_db();
                    if ($statement = $con->prepare($sql))
                    {
                        $statement->bindValue(":$coulam1", $val2, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam2", $val3, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam3", $val4, PDO::PARAM_STR);
                        $statement->bindValue(":id", $id, PDO::PARAM_INT);
                        if ($statement->execute())
                        {
                            echo $this->msg_up;
                        }
                    }
                } catch (PDOException $exc) {
                    echo $exc->getMessage();
                }
            }
            elseif ($count == 5)
            {

                try {
                    $cdn = $this->con_db();
                    $tablename = $this->tablename;
                    $select = $cdn->query('SELECT * FROM ' . $tablename);
                    $total_column = $select->columnCount();
                    for ($counter = 0; $counter <= $total_column; $counter ++)
                    {
                        $meta = $select->getColumnMeta($counter);
                        $column[] = $meta['name'];
                    }
                    $coulam = $column[0];

                    $coulam1 = $column[1];

                    $coulam2 = $column[2];

                    $coulam3 = $column[3];

                    $coulam4 = $column[4];

                    $valyes = array_values($this->array);
                    $val = $valyes[0];
                    $val2 = $valyes[1];
                    $val3 = $valyes[2];
                    $val4 = $valyes[3];
                    $val5 = $valyes[4];
                    //----------------------------------------------------------
                    $sql = "UPDATE `$tablename` SET `$coulam1` = :$coulam1, `$coulam2` = :$coulam2, `$coulam3` = :$coulam3, `$coulam4` = :$coulam4  WHERE  `id` = :id;";
                    $con = $this->con_db();
                    if ($statement = $con->prepare($sql))
                    {
                        $statement->bindValue(":$coulam1", $val2, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam2", $val3, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam3", $val4, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam4", $val5, PDO::PARAM_STR);
                        $statement->bindValue(":id", $id, PDO::PARAM_INT);
                        if ($statement->execute())
                        {
                            echo $this->msg_up;
                        }
                    }
                } catch (PDOException $exc) {
                    echo $exc->getMessage();
                }
            }
            elseif ($count == 6)
            {

                try {
                    $cdn = $this->con_db();
                    $tablename = $this->tablename;
                    $select = $cdn->query('SELECT * FROM ' . $tablename);
                    $total_column = $select->columnCount();
                    for ($counter = 0; $counter <= $total_column; $counter ++)
                    {
                        $meta = $select->getColumnMeta($counter);
                        $column[] = $meta['name'];
                    }
                    $coulam = $column[0];

                    $coulam1 = $column[1];

                    $coulam2 = $column[2];

                    $coulam3 = $column[3];

                    $coulam4 = $column[4];

                    $coulam5 = $column[5];

                    $valyes = array_values($this->array);
                    $val = $valyes[0];
                    $val2 = $valyes[1];
                    $val3 = $valyes[2];
                    $val4 = $valyes[3];
                    $val5 = $valyes[4];
                    $val6 = $valyes[5];
                    //----------------------------------------------------------
                    $sql = "UPDATE `$tablename` SET `$coulam1` = :$coulam1, `$coulam2` = :$coulam2, `$coulam3` = :$coulam3, `$coulam4` = :$coulam4, `$coulam5` = :$coulam5  WHERE  `id` = :id;";
                    $con = $this->con_db();
                    if ($statement = $con->prepare($sql))
                    {
                        $statement->bindValue(":$coulam1", $val2, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam2", $val3, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam3", $val4, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam4", $val5, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam5", $val6, PDO::PARAM_STR);
                        $statement->bindValue(":id", $id, PDO::PARAM_INT);
                        if ($statement->execute())
                        {
                            echo $this->msg_up;
                        }
                    }
                } catch (PDOException $exc) {
                    echo $exc->getMessage();
                }
            }
            elseif ($count == 7)
            {

                try {
                    $cdn = $this->con_db();
                    $tablename = $this->tablename;
                    $select = $cdn->query('SELECT * FROM ' . $tablename);
                    $total_column = $select->columnCount();
                    for ($counter = 0; $counter <= $total_column; $counter ++)
                    {
                        $meta = $select->getColumnMeta($counter);
                        $column[] = $meta['name'];
                    }
                    $coulam = $column[0];

                    $coulam1 = $column[1];

                    $coulam2 = $column[2];

                    $coulam3 = $column[3];

                    $coulam4 = $column[4];

                    $coulam5 = $column[5];

                    $coulam6 = $column[6];


                    //----------------------------------------------------------
                    $valyes = array_values($this->array);
                    $val = $valyes[0];
                    $val2 = $valyes[1];
                    $val3 = $valyes[2];
                    $val4 = $valyes[3];
                    $val5 = $valyes[4];
                    $val6 = $valyes[5];
                    $val7 = $valyes[6];
                    $sql = "UPDATE `$tablename` SET `$coulam1` = :$coulam1, `$coulam2` = :$coulam2, `$coulam3` = :$coulam3, `$coulam4` = :$coulam4, `$coulam5` = :$coulam5 , `$coulam6` = :$coulam6  WHERE  `id` = :id;";
                    $con = $this->con_db();
                    if ($statement = $con->prepare($sql))
                    {
                        $statement->bindValue(":$coulam1", $val2, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam2", $val3, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam3", $val4, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam4", $val5, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam5", $val6, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam6", $val7, PDO::PARAM_STR);
                        $statement->bindValue(":id", $id, PDO::PARAM_INT);
                        if ($statement->execute())
                        {
                            echo $this->msg_up;
                        }
                    }
                } catch (PDOException $exc) {
                    echo $exc->getMessage();
                }
            }
            elseif ($count == 8)
            {

                try {
                    $cdn = $this->con_db();
                    $tablename = $this->tablename;
                    $select = $cdn->query('SELECT * FROM ' . $tablename);
                    $total_column = $select->columnCount();
                    for ($counter = 0; $counter <= $total_column; $counter ++)
                    {
                        $meta = $select->getColumnMeta($counter);
                        $column[] = $meta['name'];
                    }
                    $coulam = $column[0];

                    $coulam1 = $column[1];

                    $coulam2 = $column[2];

                    $coulam3 = $column[3];

                    $coulam4 = $column[4];

                    $coulam5 = $column[5];

                    $coulam6 = $column[6];

                    $coulam7 = $column[7];

                    $val = $valyes[0];
                    $val2 = $valyes[1];
                    $val3 = $valyes[2];
                    $val4 = $valyes[3];
                    $val5 = $valyes[4];
                    $val6 = $valyes[5];
                    $val7 = $valyes[6];
                    $val8 = $valyes[7];
                    //----------------------------------------------------------
                    $sql = "UPDATE `$tablename` SET `$coulam1` = :$coulam1, `$coulam2` = :$coulam2, `$coulam3` = :$coulam3, `$coulam4` = :$coulam4, `$coulam5` = :$coulam5 , `$coulam6` = :$coulam6, `$coulam7` = :$coulam7  WHERE  `id` = :id;";
                    $con = $this->con_db();
                    if ($statement = $con->prepare($sql))
                    {
                        $statement->bindValue(":$coulam1", $val2, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam2", $val3, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam3", $val4, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam4", $val5, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam5", $val6, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam6", $val7, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam7", $val8, PDO::PARAM_STR);
                        $statement->bindValue(":id", $id, PDO::PARAM_INT);
                        if ($statement->execute())
                        {
                            echo $this->msg_up;
                        }
                    }
                } catch (PDOException $exc) {
                    echo $exc->getMessage();
                }
            }
            elseif ($count == 9)
            {

                try {
                    $cdn = $this->con_db();
                    $tablename = $this->tablename;
                    $select = $cdn->query('SELECT * FROM ' . $tablename);
                    $total_column = $select->columnCount();
                    for ($counter = 0; $counter <= $total_column; $counter ++)
                    {
                        $meta = $select->getColumnMeta($counter);
                        $column[] = $meta['name'];
                    }
                    $coulam = $column[0];

                    $coulam1 = $column[1];

                    $coulam2 = $column[2];

                    $coulam3 = $column[3];

                    $coulam4 = $column[4];

                    $coulam5 = $column[5];

                    $coulam6 = $column[6];

                    $coulam7 = $column[7];

                    $coulam8 = $column[8];

                    //----------------------------------------------------------
                    $valyes = array_values($this->array);
                    $val = $valyes[0];
                    $val2 = $valyes[1];
                    $val3 = $valyes[2];
                    $val4 = $valyes[3];
                    $val5 = $valyes[4];
                    $val6 = $valyes[5];
                    $val7 = $valyes[6];
                    $val8 = $valyes[7];
                    $val9 = $valyes[8];

                    $sql = "UPDATE `$tablename` SET `$coulam1` = :$coulam1, `$coulam2` = :$coulam2, `$coulam3` = :$coulam3, `$coulam4` = :$coulam4, `$coulam5` = :$coulam5 , `$coulam6` = :$coulam6, `$coulam7` = :$coulam7, `$coulam8` = :$coulam8   WHERE  `id` = :id;";
                    $con = $this->con_db();
                    if ($statement = $con->prepare($sql))
                    {
                        $statement->bindValue(":$coulam1", $val2, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam2", $val3, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam3", $val4, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam4", $val5, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam5", $val6, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam6", $val7, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam7", $val8, PDO::PARAM_STR);
                        $statement->bindValue(":$coulam8", $val9, PDO::PARAM_STR);
                        $statement->bindValue(":id", $id, PDO::PARAM_INT);
                        if ($statement->execute())
                        {
                            echo $this->msg_up;
                        }
                    }
                } catch (PDOException $exc) {
                    echo $exc->getMessage();
                }
            }

            //----------------------------------------------------------
        }

        public function Malcom_xx_ins()
        {
            $keys = array_keys($this->array);


            $count = count($this->array);
            $count;


            if ($count == 1)
            {
                $string = array_values($this->array);

                $string[0];

                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];

                try {
                    $val = $string[0];
                    $string_SQL = "INSERT INTO `$tablename` ($coulam1 ) VALUES (?);";
                    $sth = $cdn->prepare($string_SQL);
                    $sth->bindParam(1, $val, PDO::PARAM_STR);
                    if ($sth->execute())
                    {
                        echo $this->msg_ins;
                    }
                    else
                    {
                        echo "Input failure to the database";
                    }
                } catch (PDOException $ex) {
                    $ex->getMessage() . "err";
                }
                $cdn = NULL;
            }
            elseif ($count == 2)
            {
                $string = array_values($this->array);
                $val = $string[0];
                $val2 = $string[1];
                //كده البحث عن عمودين
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];

                $coulam2 = $column[2];


                //----------------------------------------------------------

                try {
                    $string_SQL = "INSERT INTO `$tablename` ($coulam1 ,$coulam2) VALUES (?, ?);";

                    $sth = $cdn->prepare($string_SQL);
                    $sth->bindParam(1, $val, PDO::PARAM_STR);
                    $sth->bindParam(2, $val2, PDO::PARAM_STR);
                    if ($sth->execute())
                    {
                        echo $this->msg_ins;
                    }
                    else
                    {
                        echo "Input failure to the database";
                    }
                } catch (PDOException $ex) {
                    $ex->getMessage() . "err";
                }
                $cdn = NULL;
            }
            elseif ($count == 3)
            {
                $valyes = array_values($this->array);
                $val = $valyes[0];
                $val2 = $valyes[1];
                $val3 = $valyes[2];

                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];

                $coulam2 = $column[2];

                $coulam3 = $column[3];


                //----------------------------------------------------------

                try {
                    $string_SQL = "INSERT INTO `$tablename` ($coulam1 ,$coulam2,$coulam3) VALUES (?, ?, ?);";
                    $sth = $cdn->prepare($string_SQL);
                    $sth->bindParam(1, $val, PDO::PARAM_STR);
                    $sth->bindParam(2, $val2, PDO::PARAM_STR);
                    $sth->bindParam(3, $val3, PDO::PARAM_STR);
                    if ($sth->execute())
                    {
                        echo $this->msg_ins;
                    }
                } catch (PDOException $ex) {
                    $ex->getMessage() . "err";
                }
                //كده البحث عن ثلاثة اعمدة
            }
            elseif
            ($count == 4)
            {
                $count;
                $valyes = array_values($this->array);
                $val = $valyes[0];
                $val2 = $valyes[1];
                $val3 = $valyes[2];
                $val4 = $valyes[3];
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];

                $coulam2 = $column[2];

                $coulam3 = $column[3];

                $coulam4 = $column[4];


                //----------------------------------------------------------

                try {
                    $string_SQL = "INSERT INTO `$tablename` ($coulam1 ,$coulam2,$coulam3,$coulam4) VALUES (?, ?, ?, ?);";
                    $sth = $cdn->prepare($string_SQL);
                    $sth->bindParam(1, $val, PDO::PARAM_STR);
                    $sth->bindParam(2, $val2, PDO::PARAM_STR);
                    $sth->bindParam(3, $val3, PDO::PARAM_STR);
                    $sth->bindParam(4, $val4, PDO::PARAM_STR);
                    if ($sth->execute())
                    {
                        echo $this->msg_ins;
                    }
                } catch (PDOException $ex) {
                    $ex->getMessage() . "err";
                }
                //كده البحث عن اربع اعمدة
            }
            elseif ($count == 5)
            {

                //كده البحث عن خمس اعمدة
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];

                $coulam2 = $column[2];

                $coulam3 = $column[3];
                $coulam4 = $column[4];
                $coulam5 = $column[5];


                //----------------------------------------------------------
                $valyes = array_values($this->array);
                $val = $valyes[0];
                $val2 = $valyes[1];
                $val3 = $valyes[2];
                $val4 = $valyes[3];
                $val5 = $valyes[4];
                try {
                    $string_SQL = "INSERT INTO `$tablename` ($coulam1 ,$coulam2,$coulam3,$coulam4,$coulam5) VALUES (?, ?, ?, ?, ?)";
                    $sth = $cdn->prepare($string_SQL);
                    $sth->bindParam(1, $val, PDO::PARAM_STR);
                    $sth->bindParam(2, $val2, PDO::PARAM_STR);
                    $sth->bindParam(3, $val3, PDO::PARAM_STR);
                    $sth->bindParam(4, $val4, PDO::PARAM_STR);
                    $sth->bindParam(5, $val5, PDO::PARAM_STR);
                    if ($sth->execute())
                    {
                        echo "insert data";
                    }
                } catch (PDOException $ex) {
              echo      $ex->getMessage() . "err";
                }
            }
            elseif ($count == 6)
            {
                $valyes = array_values($this->array);
                $val = $valyes[0];
                $val2 = $valyes[1];
                $val3 = $valyes[2];
                $val4 = $valyes[3];
                $val5 = $valyes[4];
                $val6 = $valyes[5];
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];

                $coulam2 = $column[2];

                $coulam3 = $column[3];

                $coulam4 = $column[4];

                $coulam5 = $column[5];

                $coulam6 = $column[6];


                //----------------------------------------------------------
                $valyes = array_values($this->array);
                $val = $valyes[0];
                $val2 = $valyes[1];
                $val3 = $valyes[2];
                $val4 = $valyes[3];
                $val5 = $valyes[4];
                $val6 = $valyes[5];
                try {
                    $string_SQL = "INSERT INTO `$tablename` ($coulam1 ,$coulam2,$coulam3,$coulam4,$coulam5,$coulam6) VALUES (?, ?, ?, ?, ?, ?);";
                    $sth = $cdn->prepare($string_SQL);
                    $sth->bindParam(1, $val, PDO::PARAM_STR);
                    $sth->bindParam(2, $val2, PDO::PARAM_STR);
                    $sth->bindParam(3, $val3, PDO::PARAM_STR);
                    $sth->bindParam(4, $val4, PDO::PARAM_STR);
                    $sth->bindParam(5, $val5, PDO::PARAM_STR);
                    $sth->bindParam(6, $val6, PDO::PARAM_STR);
                    if ($sth->execute())
                    {
                        $this->msg_ins;
                    }
                } catch (PDOException $ex) {
                    $ex->getMessage() . "err";
                }
            }
            elseif ($count == 7)
            {

                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];

                $coulam2 = $column[2];

                $coulam3 = $column[3];

                $coulam4 = $column[4];

                $coulam5 = $column[5];

                $coulam6 = $column[6];

                $coulam7 = $column[7];



                $valyes = array_values($this->array);
                $val = $valyes[0];
                $val2 = $valyes[1];
                $val3 = $valyes[2];
                $val4 = $valyes[3];
                $val5 = $valyes[4];
                $val6 = $valyes[5];
                $val7 = $valyes[6];
                //----------------------------------------------------------

                try {
                    $string_SQL = "INSERT INTO `$tablename` ($coulam1 ,$coulam2,$coulam3,$coulam4,$coulam5,$coulam6,$coulam7) VALUES (?, ?, ?, ?, ?, ?, ?);";
                    $sth = $cdn->prepare($string_SQL);
                    $sth->bindParam(1, $val, PDO::PARAM_STR);
                    $sth->bindParam(2, $val2, PDO::PARAM_STR);
                    $sth->bindParam(3, $val3, PDO::PARAM_STR);
                    $sth->bindParam(4, $val4, PDO::PARAM_STR);
                    $sth->bindParam(5, $val5, PDO::PARAM_STR);
                    $sth->bindParam(6, $val6, PDO::PARAM_STR);
                    $sth->bindParam(7, $val7, PDO::PARAM_STR);
                    if ($sth->execute())
                    {
                        echo $this->msg_ins;
                    }
                } catch (PDOException $ex) {
                    $ex->getMessage() . "err";
                }
            }
            elseif ($count == 8)
            {

                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];

                $coulam2 = $column[2];

                $coulam3 = $column[3];

                $coulam4 = $column[4];

                $coulam5 = $column[5];

                $coulam6 = $column[6];

                $coulam7 = $column[7];

                $coulam8 = $column[8];


                //----------------------------------------------------------

                try {
                    $valyes = array_values($this->array);
                    $val = $valyes[0];
                    $val2 = $valyes[1];
                    $val3 = $valyes[2];
                    $val4 = $valyes[3];
                    $val5 = $valyes[4];
                    $val6 = $valyes[5];
                    $val7 = $valyes[6];
                    $val8 = $valyes[7];
                    $string_SQL = "INSERT INTO `$tablename` ($coulam1 ,$coulam2,$coulam3,$coulam4,$coulam5,$coulam6,$coulam7,$coulam8) VALUES (?, ?, ?, ?, ?, ?, ?, ?);";
                    $sth = $cdn->prepare($string_SQL);
                    $sth->bindParam(1, $val, PDO::PARAM_STR);
                    $sth->bindParam(2, $val2, PDO::PARAM_STR);
                    $sth->bindParam(3, $val3, PDO::PARAM_STR);
                    $sth->bindParam(4, $val4, PDO::PARAM_STR);
                    $sth->bindParam(5, $val5, PDO::PARAM_STR);
                    $sth->bindParam(6, $val6, PDO::PARAM_STR);
                    $sth->bindParam(7, $val7, PDO::PARAM_STR);
                    $sth->bindParam(8, $val8, PDO::PARAM_STR);
                    if ($sth->execute())
                    {
                        echo $this->msg_ins;
                    }
                } catch (PDOException $ex) {
                    $ex->getMessage() . "err";
                }
            }
        }
        public function rows_Duplicate($Query)
        {
            //   $Query = "select * from positive where  positive = 'col1'  and Address = 'col2'";
            $sql_con = $this->con_db();
            //  echo  $Query;
            $queryResult = $sql_con->query($Query);
            $foundRows = $queryResult->rowCount();
            if ($foundRows >= 1)
            {
                
            }
            else
            {
                $this->Malcom_xx_ins();
            }
        }
        function DuplicateMySQLRecord($table, $id_field, $id)
        {
            $sql_con = $this->con_db();
            $result = $sql_con->query("SELECT * FROM " . $table . " 
                                WHERE " . $id_field . " = '" . $id . "' LIMIT 1");
            $row = $result[0];
        }
        public function count_rows($Query)
        {
            $dbh = $this->con_db();
            $sql = $Query;

            $stmt = $dbh->prepare($sql);
            try {
                $stmt->execute();
            } catch (PDOException $e) {
                echo $e->getMessage();
            }

            return $stmt->rowCount();
        }
        public function count_rows_cond($Query, $array)
        {
            $dbh = $this->con_db();
            $sql = $Query;

            $stmt = $dbh->prepare($sql);
            try {
                $stmt->execute($array);
            } catch (PDOException $e) {
                echo $e->getMessage();
            }

            return $stmt->rowCount();
        }
        public function Field_Protection($data)
        {
            $data = trim($data);
            $data = stripslashes($data);
            $data = htmlspecialchars($data);
            return $data;
        }
        public function General_extraction($Query)
        {
            $con = new PDO("mysql:host=$this->localhost;dbname=$this->db", "$this->user", $this->pas);
            $con->query("SET NAMES utf8");
            $sth = $con->prepare($Query);
            $sth->execute();
            return $result = $sth->fetchAll();
        }
        public function General_extraction_Row($Query)
        {
            $con = new PDO("mysql:host=$this->localhost;dbname=$this->db", "$this->user", $this->pas);
            $con->query("SET NAMES utf8");
            $sth = $con->prepare($Query);
            $sth->execute();
            return $result = $sth->fetch();
        }
        public function General_extraction_ADV($Query, $array)
        {
            /*
             * وضع الأستعلام في مصفوفة
             */
            $arr = array($Query);
            /*
             * الخطو الثانية ايجاد عدد مرات الأستبدال
             */
            str_ireplace("?", "?", $arr, $i);
            $i;
            /*
             * الأتصال بقاعدة البيانات
             */
            $con = new PDO("mysql:host=$this->localhost;dbname=$this->db", $this->user, $this->pas);
            /*
             * 
             */
            /*
             * وضع شرط لعدد مرات الأستبدال
             */
            if ($i = 1)
            {
                try {
                    $valyes = array_values($array);

                    $val = $valyes[0];
                    $val2 = $valyes[1];
                    $sth = $con->prepare($Query);
                    $sth->bindParam(1, $val, PDO::PARAM_STR);
                    $sth->bindParam(2, $val2, PDO::PARAM_STR);
                    $sth->execute();
                    return $result = $sth->fetchAll();
                } catch (PDOException $exc) {
                    echo $exc->getMessage();
                }
            }
            elseif ($i = 2)
            {
                try {
                    $valyes = array_values($array);
                    print_r($valyes);
                    $val = $valyes[0];
                    $val2 = $valyes[1];
                    $sth = $con->prepare($Query);
                    $sth->bindParam(1, $val, PDO::PARAM_STR);
                    $sth->bindParam(2, $val2, PDO::PARAM_STR);
                    $sth->execute();
                    return $result = $sth->fetchAll();
                } catch (PDOException $exc) {
                    echo $exc->getMessage();
                }
            }
            elseif ($i = 3)
            {
                try {
                    $valyes = array_values($array);
                    $val = $valyes[0];
                    $val2 = $valyes[1];
                    $val3 = $valyes[2];
                    $sth = $con->prepare($Query);
                    $sth->bindParam(1, $val, PDO::PARAM_STR);
                    $sth->bindParam(2, $val2, PDO::PARAM_STR);
                    $sth->bindParam(3, $val3, PDO::PARAM_STR);
                    $sth->execute();
                    return $result = $sth->fetchAll();
                } catch (PDOException $exc) {
                    echo $exc->getMessage();
                }
            }
            elseif ($i = 4)
            {
                try {
                    $valyes = array_values($array);
                    $val = $valyes[0];
                    $val2 = $valyes[1];
                    $val3 = $valyes[2];
                    $val4 = $valyes[3];
                    $sth = $con->prepare($Query);
                    $sth->bindParam(1, $val, PDO::PARAM_STR);
                    $sth->bindParam(2, $val2, PDO::PARAM_STR);
                    $sth->bindParam(3, $val3, PDO::PARAM_STR);
                    $sth->bindParam(4, $val4, PDO::PARAM_STR);
                    $sth->execute();
                    return $result = $sth->fetchAll();
                } catch (PDOException $exc) {
                    echo $exc->getMessage();
                }
            }
            elseif ($i = 5)
            {
                try {
                    $valyes = array_values($array);
                    $val = $valyes[0];
                    $val2 = $valyes[1];
                    $val3 = $valyes[2];
                    $val4 = $valyes[3];
                    $val5 = $valyes[4];
                    $sth = $con->prepare($Query);
                    $sth->bindParam(1, $val, PDO::PARAM_STR);
                    $sth->bindParam(2, $val2, PDO::PARAM_STR);
                    $sth->bindParam(3, $val3, PDO::PARAM_STR);
                    $sth->bindParam(4, $val4, PDO::PARAM_STR);
                    $sth->bindParam(5, $val5, PDO::PARAM_STR);
                    $sth->execute();
                    return $result = $sth->fetchAll();
                } catch (PDOException $exc) {
                    echo $exc->getMessage();
                }
            }
            elseif ($i = 6)
            {
                try {
                    $valyes = array_values($array);
                    $val = $valyes[0];
                    $val2 = $valyes[1];
                    $val3 = $valyes[2];
                    $val4 = $valyes[3];
                    $val5 = $valyes[4];
                    $val6 = $valyes[6];
                    $sth = $con->prepare($Query);
                    $sth->bindParam(1, $val, PDO::PARAM_STR);
                    $sth->bindParam(2, $val2, PDO::PARAM_STR);
                    $sth->bindParam(3, $val3, PDO::PARAM_STR);
                    $sth->bindParam(4, $val4, PDO::PARAM_STR);
                    $sth->bindParam(5, $val5, PDO::PARAM_STR);
                    $sth->bindParam(5, $val6, PDO::PARAM_STR);
                    $sth->execute();
                    return $result = $sth->fetchAll();
                } catch (PDOException $exc) {
                    echo $exc->getMessage();
                }
            }
        }
        public function strlen($val, $lenth)
        {
            $this->Field_Protection($val);
            if (strlen($this->$val) < $lenth)
            {
                return $ok = FALSE;
            }
            else
            {
                return $ok = TRUE;
            }
        }
        public function emp($val)
        {
            $this->Field_Protection($val);
            if (empty($this->Field_Protection($val)))
            {
                return 1;
            }
            else
            {
                return 2;
            }
        }
        public function validateEmail($email, $inp_nam)
        {
            $this->Field_Protection($email);
            if (!filter_input(INPUT_POST, $inp_nam, FILTER_VALIDATE_EMAIL))
            {
                return $ok = FALSE;
            }
            else
            {
                return $ok = TRUE;
            }
        }
        public function validate_url($url, $inp_nam)
        {
            $this->Field_Protection($url);
            if (!filter_input(INPUT_POST, $inp_nam, FILTER_VALIDATE_URL))
            {
                return $ok = 1;
            }
            else
            {
                return $ok = 2;
            }
        }
        public function PAS_INT($PAS, $msg, $inp_nam)
        {
            $this->Field_Protection($PAS);
            if (!filter_input(INPUT_POST, $inp_nam, FILTER_VALIDATE_INT))
            {

                return $ok = FALSE;
            }
            else
            {
                return $ok = TRUE;
            }
        }
        public function isValidEmail($email)
        {
            $this->Field_Protection($email);
            $pattern = "^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$";

            if (eregi($pattern, $email))
            {
                return $ok = TRUE;
            }
            else
            {

                return $ok = FALSE;
            }
        }
        public function PAS_Match($val1, $val2, $true, $false)
        {
            $this->Field_Protection($val1);
            $this->Field_Protection($val2);

            if ($val1 == $val2)
            {
                return $ok = TRUE;
            }
            else
            {
                return $ok = FALSE;
            }
        }
        public function opt_email($email, $true, $false, $opt)
        {
            $this->Field_Protection($email);
            if ($opt = 1)
            {
                $val = strtolower($email);
                $text1 = "@yahoo.com";
                if (stristr($text, $val))
                {
                    return $ok = TRUE;
                }
                else
                {
                    return $ok = FALSE;
                }
            }
            elseif ($opt = 2)
            {
                if ($opt = 1)
                {
                    $val = strtolower($email);
                    $text1 = "@gmail.com";
                    if (stristr($text, $val))
                    {
                        return $ok = TRUE;
                    }
                    else
                    {
                        return $ok = FALSE;
                    }
                }
            }
        }
        public function serch_db_col_BAC($keyword, $col)
        {
            try {
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $sql = "SELECT * FROM `$this->tablename` WHERE `$col` LIKE ? ;";
                $sth = $cdn->prepare($sql);
                $sth->bindValue(1, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->execute();
                return $result = $sth->fetchAll();
            } catch (PDOException $exc) {
                echo $exc->getMessage();
            }
        }
        public function serch_db_col1($keyword)
        {
            try {
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];
                $coulam1 = $column[1];
                $sql = "SELECT * FROM `$this->tablename` WHERE `$coulam1` LIKE ? ;";
                $sth = $cdn->prepare($sql);
                $sth->bindValue(1, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->execute();
                return $result = $sth->fetchAll();
            } catch (PDOException $exc) {
                echo $exc->getMessage();
            }
        }
        public function serch_db_col2($keyword)
        {
            try {
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];
                $coulam2 = $column[2];


                $sql = "SELECT * FROM `$this->tablename` WHERE `$coulam1` LIKE ? UNION  "
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam2` LIKE ?;";
                $sth = $cdn->prepare($sql);
                $sth->bindValue(1, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(2, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->execute();
                return $result = $sth->fetchAll();
            } catch (PDOException $exc) {
                echo $exc->getMessage();
            }
        }
        public function serch_db_col3($keyword)
        {
            try {
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];
                $coulam2 = $column[2];
                $coulam3 = $column[3];


                $sql = "SELECT * FROM `$this->tablename` WHERE `$coulam1` LIKE ? UNION  "
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam2` LIKE ?;"
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam3` LIKE ?";
                $sth = $cdn->prepare($sql);
                $sth->bindValue(1, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(2, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(3, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->execute();
                return $result = $sth->fetchAll();
            } catch (PDOException $exc) {
                echo $exc->getMessage();
            }
        }
        public function serch_db_col4($keyword)
        {
            try {
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];
                $coulam2 = $column[2];
                $coulam3 = $column[3];
                $coulam4 = $column[4];


                $sql = "SELECT * FROM `$this->tablename` WHERE `$coulam1` LIKE ? UNION  "
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam2` LIKE ?;"
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam3` LIKE ?"
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam4` LIKE ?";
                $sth = $cdn->prepare($sql);
                $sth->bindValue(1, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(2, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(3, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->execute();
                return $result = $sth->fetchAll();
            } catch (PDOException $exc) {
                echo $exc->getMessage();
            }
        }
        public function serch_db_col5($keyword)
        {
            try {
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];
                $coulam2 = $column[2];
                $coulam3 = $column[3];
                $coulam4 = $column[4];
                $coulam5 = $column[5];


                $sql = "SELECT * FROM `$this->tablename` WHERE `$coulam1` LIKE ? UNION  "
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam2` LIKE ?;"
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam3` LIKE ?"
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam4` LIKE ?"
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam5` LIKE ?";
                $sth = $cdn->prepare($sql);
                $sth->bindValue(1, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(2, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(3, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(4, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(5, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->execute();
                return $result = $sth->fetchAll();
            } catch (PDOException $exc) {
                echo $exc->getMessage();
            }
        }
        public function serch_db_col6($keyword)
        {
            try {
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];
                $coulam2 = $column[2];
                $coulam3 = $column[3];
                $coulam4 = $column[4];
                $coulam5 = $column[5];
                $coulam6 = $column[6];


                $sql = "SELECT * FROM `$this->tablename` WHERE `$coulam1` LIKE ? UNION  "
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam2` LIKE ?;"
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam3` LIKE ?"
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam4` LIKE ?"
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam5` LIKE ?"
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam6` LIKE ?";
                $sth = $cdn->prepare($sql);
                $sth->bindValue(1, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(2, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(3, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(4, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(5, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(6, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->execute();
                return $result = $sth->fetchAll();
            } catch (PDOException $exc) {
                echo $exc->getMessage();
            }
        }
        public function serch_db_col7($keyword)
        {
            try {
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $select = $cdn->query('SELECT * FROM ' . $tablename);
                $total_column = $select->columnCount();
                for ($counter = 0; $counter <= $total_column; $counter ++)
                {
                    $meta = $select->getColumnMeta($counter);
                    $column[] = $meta['name'];
                }
                $coulam = $column[0];

                $coulam1 = $column[1];
                $coulam2 = $column[2];
                $coulam3 = $column[3];
                $coulam4 = $column[4];
                $coulam5 = $column[5];
                $coulam6 = $column[6];
                $coulam7 = $column[7];


                $sql = "SELECT * FROM `$this->tablename` WHERE `$coulam1` LIKE ? UNION  "
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam2` LIKE ?;"
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam3` LIKE ?"
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam4` LIKE ?"
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam5` LIKE ?"
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam6` LIKE ?"
                   . "SELECT * FROM `$this->tablename` WHERE `$coulam7` LIKE ?";
                $sth = $cdn->prepare($sql);
                $sth->bindValue(1, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(2, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(3, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(4, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(5, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(6, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->bindValue(7, '%' . $keyword . '%', PDO::PARAM_STR);
                $sth->execute();
                return $result = $sth->fetchAll();
            } catch (PDOException $exc) {
                echo $exc->getMessage();
            }
        }
        public function del_row($id)
        {
            try {
                $con = $this->con_db();
                if ($query = $con->prepare("DELETE FROM $this->tablename WHERE id=?"))
                    ;
                $query->bindValue(1, $id, PDO::PARAM_INT);
                if ($query->execute())
                {
                    $this->msg_del;
                }
            } catch (PDOException $ex) {
                echo  $ex;
            }
        }
        public function General_extraction_array($Query, $array)
        {
            $con = new PDO("mysql:host=$this->localhost;charset=utf8;dbname=$this->db", $this->user, $this->pas);
            try {

                $sth = $con->prepare($Query);
                $sth->execute($array);
                return $result = $sth->fetchAll();
            } catch (PDOException $exc) {
                echo $exc->getMessage();
            }
        }
        function highlightWords($string, $word)
        {

            $string = str_replace($word, "<span class='highlight'>" . $word . "</span>", $string);
            /*             * * return the highlighted string ** */
            return $string;
        }
        function truncateTable($tabel)
        {
            try {
                //  echo       "TRUNCATE TABLE $this->tablename";
                // echo "Truncating..";
                $cdn = $this->con_db();
                $query = $cdn->exec("TRUNCATE TABLE $tabel");
                //    echo "Truncated table $tblname!";
            } catch (PDOException $ex) {
                //echo $ex;
            }
        }
        public function ins_col_2($var1)
        {
            $cdn = $this->con_db();
            $tablename = $this->tablename;
            $select = $cdn->query('SELECT * FROM ' . $tablename);
            $total_column = $select->columnCount();
            for ($counter = 0; $counter <= $total_column; $counter ++)
            {
                $meta = $select->getColumnMeta($counter);
                $column[] = $meta['name'];
            }
            $coulam = $column[0];
            echo "<br>";
            $coulam1 = $column[1];
            "<br>";


//----------------------------------------------------------

            try {
                echo $string_SQL = "INSERT INTO `$tablename` ($coulam1 ) VALUES (?);";
                $sth = $cdn->prepare($string_SQL);
                $sth->bindParam(1, $var1, PDO::PARAM_STR);
                if ($sth->execute())
                {
                    echo $this->msg_ins;
                }
                else
                {
                    echo "Input failure to the database";
                }
            } catch (PDOException $ex) {
                $ex->getMessage() . "err";
            }
            $cdn = NULL;
        }
        public function ins_col_3($var1, $var2)
        {

            $cdn = $this->con_db();
            $tablename = $this->tablename;
            $select = $cdn->query('SELECT * FROM ' . $tablename);
            $total_column = $select->columnCount();
            for ($counter = 0; $counter <= $total_column; $counter ++)
            {
                $meta = $select->getColumnMeta($counter);
                $column[] = $meta['name'];
            }
            $coulam = $column[0];
            echo "<br>";
            $coulam1 = $column[1];
            "<br>";
            $coulam2 = $column[2];
            echo "<br>";

//----------------------------------------------------------

            try {
                echo $string_SQL = "INSERT INTO `$tablename` ($coulam1 ,$coulam2) VALUES (?, ?);";

                $sth = $cdn->prepare($string_SQL);
                $sth->bindParam(1, $var1, PDO::PARAM_STR);
                $sth->bindParam(2, $var2, PDO::PARAM_STR);
                if ($sth->execute())
                {
                    echo $this->msg_ins;
                }
                else
                {
                    echo "Input failure to the database";
                }
            } catch (PDOException $ex) {
                $ex->getMessage() . "err";
            }
            $cdn = NULL;
        }
        public function ins_col_4($var1, $var2, $var3)
        {

            $cdn = $this->con_db();
            $tablename = $this->tablename;
            $select = $cdn->query('SELECT * FROM ' . $tablename);
            $total_column = $select->columnCount();
            for ($counter = 0; $counter <= $total_column; $counter ++)
            {
                $meta = $select->getColumnMeta($counter);
                $column[] = $meta['name'];
            }
            $coulam = $column[0];
            echo "<br>";
            $coulam1 = $column[1];
            "<br>";
            $coulam2 = $column[2];
            echo "<br>";
            $coulam3 = $column[3];
            echo "<br>";

//----------------------------------------------------------

            try {
                echo $string_SQL = "INSERT INTO `$tablename` ($coulam1 ,$coulam2,$coulam3) VALUES (?, ?, ?);";
                $sth = $cdn->prepare($string_SQL);
                $sth->bindParam(1, $var1, PDO::PARAM_STR);
                $sth->bindParam(2, $var2, PDO::PARAM_STR);
                $sth->bindParam(3, $var3, PDO::PARAM_STR);
                if ($sth->execute())
                {
                    echo $this->msg_ins;
                }
            } catch (PDOException $ex) {
                $ex->getMessage() . "err";
            }
        }
        public function ins_col_5($var1, $var2, $var3, $var4)
        {

            $cdn = $this->con_db();
            $tablename = $this->tablename;
            $select = $cdn->query('SELECT * FROM ' . $tablename);
            $total_column = $select->columnCount();
            for ($counter = 0; $counter <= $total_column; $counter ++)
            {
                $meta = $select->getColumnMeta($counter);
                $column[] = $meta['name'];
            }
            $coulam = $column[0];
            echo "<br>";
            $coulam1 = $column[1];
            "<br>";
            $coulam2 = $column[2];
            echo "<br>";
            $coulam3 = $column[3];
            echo "<br>";
            $coulam4 = $column[4];
            echo "<br>";

//----------------------------------------------------------

            try {
                echo $string_SQL = "INSERT INTO `$tablename` ($coulam1 ,$coulam2,$coulam3,$coulam4) VALUES (?, ?, ?, ?);";
                $sth = $cdn->prepare($string_SQL);
                $sth->bindParam(1, $var1, PDO::PARAM_STR);
                $sth->bindParam(2, $var2, PDO::PARAM_STR);
                $sth->bindParam(3, $var3, PDO::PARAM_STR);
                $sth->bindParam(4, $var4, PDO::PARAM_STR);
                if ($sth->execute())
                {
                    echo $this->msg_ins;
                }
            } catch (PDOException $ex) {
                $ex->getMessage() . "err";
            }
        }
        public function ins_col_6($var1, $var2, $var3, $var4, $var5)
        {

            $cdn = $this->con_db();
            $tablename = $this->tablename;
            $select = $cdn->query('SELECT * FROM ' . $tablename);
            $total_column = $select->columnCount();
            for ($counter = 0; $counter <= $total_column; $counter ++)
            {
                $meta = $select->getColumnMeta($counter);
                $column[] = $meta['name'];
            }
            $coulam = $column[0];
            echo "<br>";
            $coulam1 = $column[1];
            "<br>";
            $coulam2 = $column[2];
            echo "<br>";
            $coulam3 = $column[3];
            echo "<br>";
            $coulam4 = $column[4];
            echo "<br>";
            $coulam5 = $column[5];
            echo "<br>";

//----------------------------------------------------------

            try {
                echo $string_SQL = "INSERT INTO `$tablename` ($coulam1 ,$coulam2,$coulam3,$coulam4,$coulam5) VALUES (?, ?, ?, ?, ?);";
                $sth = $cdn->prepare($string_SQL);
                $sth->bindParam(1, $var1, PDO::PARAM_STR);
                $sth->bindParam(2, $var2, PDO::PARAM_STR);
                $sth->bindParam(3, $var3, PDO::PARAM_STR);
                $sth->bindParam(4, $var4, PDO::PARAM_STR);
                $sth->bindParam(5, $var5, PDO::PARAM_STR);
                if ($sth->execute())
                {
                    echo $this->msg_ins;
                }
            } catch (PDOException $ex) {
         echo       $ex->getMessage() . "err";
            }
        }
        public function ins_col_7($var1, $var2, $var3, $var4, $var5, $var6)
        {

            $cdn = $this->con_db();
            $tablename = $this->tablename;
            $select = $cdn->query('SELECT * FROM ' . $tablename);
            $total_column = $select->columnCount();
            for ($counter = 0; $counter <= $total_column; $counter ++)
            {
                $meta = $select->getColumnMeta($counter);
                $column[] = $meta['name'];
            }
            $coulam = $column[0];
            echo "<br>";
            $coulam1 = $column[1];
            "<br>";
            $coulam2 = $column[2];
            echo "<br>";
            $coulam3 = $column[3];
            echo "<br>";
            $coulam4 = $column[4];
            echo "<br>";
            $coulam5 = $column[5];
            echo "<br>";
            $coulam6 = $column[6];
            echo "<br>";

//----------------------------------------------------------

            try {
                echo $string_SQL = "INSERT INTO `$tablename` ($coulam1 ,$coulam2,$coulam3,$coulam4,$coulam5,$coulam6) VALUES (?, ?, ?, ?, ?, ?);";
                $sth = $cdn->prepare($string_SQL);
                $sth->bindParam(1, $var1, PDO::PARAM_STR);
                $sth->bindParam(2, $var2, PDO::PARAM_STR);
                $sth->bindParam(3, $var3, PDO::PARAM_STR);
                $sth->bindParam(4, $var4, PDO::PARAM_STR);
                $sth->bindParam(5, $var5, PDO::PARAM_STR);
                $sth->bindParam(6, $var6, PDO::PARAM_STR);
                if ($sth->execute())
                {
                    echo "Has been added to the statement";
                }
            } catch (PDOException $ex) {
                $ex->getMessage() . "err";
            }
        }

        public function ins_col_8($var1, $var2, $var3, $var4, $var5, $var6, $var7)
        {

            $cdn = $this->con_db();
            $tablename = $this->tablename;
            $select = $cdn->query('SELECT * FROM ' . $tablename);
            $total_column = $select->columnCount();
            for ($counter = 0; $counter <= $total_column; $counter ++)
            {
                $meta = $select->getColumnMeta($counter);
                $column[] = $meta['name'];
            }
            $coulam = $column[0];
            echo "<br>";
            $coulam1 = $column[1];
            "<br>";
            $coulam2 = $column[2];
            echo "<br>";
            $coulam3 = $column[3];
            echo "<br>";
            $coulam4 = $column[4];
            echo "<br>";
            $coulam5 = $column[5];
            echo "<br>";
            $coulam6 = $column[6];
            echo "<br>";
            $coulam7 = $column[7];
            echo "<br>";

            echo "<br>";

//----------------------------------------------------------

            try {
                echo $string_SQL = "INSERT INTO `$tablename` ($coulam1 ,$coulam2,$coulam3,$coulam4,$coulam5,$coulam6,$coulam7) VALUES (?, ?, ?, ?, ?, ?, ?);";
                $sth = $cdn->prepare($string_SQL);
                $sth->bindParam(1, $var1, PDO::PARAM_STR);
                $sth->bindParam(2, $var2, PDO::PARAM_STR);
                $sth->bindParam(3, $var3, PDO::PARAM_STR);
                $sth->bindParam(4, $var4, PDO::PARAM_STR);
                $sth->bindParam(5, $var5, PDO::PARAM_STR);
                $sth->bindParam(6, $var6, PDO::PARAM_STR);
                $sth->bindParam(7, $var6, PDO::PARAM_STR);
                if ($sth->execute())
                {
                    echo $this->msg_ins;
                }
            } catch (PDOException $ex) {
                $ex->getMessage() . "err";
            }
        }

        public function db_rows($coulam, $input)
        {
            try {
                $cdn = $this->con_db();
                $tablename = $this->tablename;
                $stmt = $cdn->prepare("SELECT count(*) from $tablename WHERE $coulam = :steam_id");
                $stmt->bindValue(':steam_id', $input);
                $stmt->execute();
                $count = $stmt->fetchColumn();
                return $count;
            } catch (PDOException $ex) {
                $ex->getMessage() . "err";
            }
        }

    }
    class pagination_bootstrap extends harry_potter {

        public function pagnation($pag_name, $number_pag)
        {
            error_reporting("E_ALL & ~E_NOTIC");
            $con = $this->con_db();
            $get_page = $_GET['id'];
            $numpag = $number_pag; //كم عدد النتئاج المعروضة في الصفحة
            $pagname = $pag_name;
            $rows = $this->count_rows("select * from $this->tablename");
            $len = (int) ceil($rows / $numpag);
            if (!$get_page)
            {
                $get_page = 0;
            }
            $string_sql = "select * from $this->tablename limit $get_page,$numpag";
            $quuery = $con->query($string_sql);
            $x = $quuery->fetchAll(PDO::FETCH_ASSOC);

            return array($len, $x, $numpag);
        }

        public function pagnation2($pag_name, $number_pag, $pagname)
        {
            error_reporting("E_ALL & ~E_NOTIC");
            $con = $this->con_db();

            $numpag = $number_pag; //كم عدد النتئاج المعروضة في الصفحة

            $rows = $this->count_rows("select * from $this->tablename");
            $len = intval($rows / $numpag);
            if (!$get_page)
            {
                $get_page = 0;
            }
            $start = ($pagname - 1) * $numpag;


            $string_sql = "select * from $this->tablename limit $start,$numpag";
            $quuery = $con->query($string_sql);
            $x = $quuery->fetchAll(PDO::FETCH_ASSOC);

            return array($len, $x, $numpag);
        }

    }
?>