<?php
    class Database
    {
        // private static $dbName = 'naw' ;
        private static $dbName = 'naw';
        // private static $dbHost = 'localhost' ;
        private static $dbHost = 'localhost' ;
        // private static $dbUsername = 'root';
        private static $dbUsername = 'root';
        // private static $dbUserPassword = '';
        private static $dbUserPassword = '';

        private static $cont  = null;


        public static function connect()
        {
            // One connection through whole application
                if ( null == self::$cont )
                {
                    try
                    {
                        self::$cont =  new PDO( "mysql:host=".self::$dbHost.";"."dbname=".self::$dbName, self::$dbUsername, self::$dbUserPassword);
                    }
                    catch(PDOException $e)
                    {
                        die($e->getMessage());
                    }
                }
                return self::$cont;
        }

        public static function query($query) {
            try {

                $q = self::$cont->prepare($query);
                $q->execute();

                $data = $q->fetchAll();

            } catch (PDOException $e) {
                echo $e;
            }
            return $data;
        }



        public static function disconnect()
        {
            self::$cont = null;
        }
    }
?>

<?php
    require_once '../php/conector.php';

    $id                = $_POST['id'];
    $nombre      = $_POST['nombre'];
    $telefono      = $_POST['telefono'];
    $correo        = $_POST['correo'];
    $comuna          = $_POST['comuna'];
    $actualizado = $_POST['actualizado'];


    // function update_modal() {
        try {
            $pdo = new Database;
            $pdo->connect();
            $sql = "UPDATE `menmbresia`
                                                        SET `nombre_apellido` =             $nombre         ,
                                                                `telefono` =                            $telefono       ,
                                                                `correo` =                              $correo         ,
                                                                `comuna` =                              $comuna         ,
                                                                `actualizado` =                     $actualizado,
                                                        WHERE id ='{$id}'";
            try {
                $w = $pdo->update($sql);
            } catch (PDOExecption $e) {
                $pdo->rollback();
            }
        } catch ( PDOExecption $e) {
        }
        // database::disconnect();
        $pdo->disconnect();
        return;
    // }

            ?>

public static function update($sql) {
        try {

            $q = self::$cont->prepare($sql);
            $q->execute();

        } catch (PDOException $e) {
            echo $e;
        }
    }