ModelUsuario.php

//ModelUsuario.php
<?php
include_once '../util/Conexion.php';
class ModelUsuario
{
    public function __construct()
    {
        $con = new Conexion();
    }

    public function ModelInsertarUsuario($idtar,$nom,$ape,$niv,$usu,$cla,$tiptar,$numtar,$fecven,$ccv,$saldo){
      try{
           $obj = Conexion::singleton();
           $query = $obj->prepare('INSERT INTO tbusuarios VALUES(?,?,?,?,?,?,?,?,?,?,?)');

           $query->bindParam(1, $idtar);
           $query->bindParam(2, $nom);
           $query->bindParam(3, $ape);
           $query->bindParam(4, $niv);
           $query->bindParam(5, $usu);
           $query->bindParam(6, $cla);
           $query->bindParam(7, $tiptar);
           $query->bindParam(8, $numtar);
           $query->bindParam(9, $fecven);
           $query->bindParam(10,$ccv);
           $query->bindParam(11,$saldo);

           $query->execute();//Ejecuta la consulta SQL
        }catch(PDOException $e){
              $e->getMessage();
        }
      }
    public function ModelValidarUsuario($usu,$cla){
      try{
           $obj = Conexion::singleton();
           $query = $obj->prepare('SELECT * FROM tbusuarios WHERE Username=? AND Password=?');

           $query->bindParam(1, $usu);
           $query->bindParam(2, $cla);

           $query->execute();//Ejecuta la consulta SQL
           $vector = $query->fetchAll();
           $query=null;
           return $vector;
        }catch(Exception $e){
            throw $e;
        }
      }
      public function ModelObtenerUsuario($user, $pass){
          try{
               $obj = Conexion::singleton();
               $query = $obj->prepare("SELECT * FROM tbusuarios WHERE Username=? and Password=?");

               $query->bindParam(1, $user);
               $query->bindParam(2, $pass);

               $query->execute();//Ejecuta la consulta SQL
               $vector = $query->fetchAll();
               $query=null;
               return $vector;
            }catch(Exception $e){
                throw $e;
            }
      }
      public function ModelModificarUsuario($id,$numt,$fec,$ccv,$rec){
          try{
               $obj = Conexion::singleton();
               $query = $obj->prepare('UPDATE tbusuarios SET Numero_Tarjeta=?, Fecha_Vencimiento=?,CCV=?, Saldo=? WHERE idtbusuarios=?');

               $query->bindParam(5, $id);
               $query->bindParam(1, $numt);
               $query->bindParam(2, $fec);
               $query->bindParam(3, $ccv);
               $query->bindParam(4, $rec);

               $query->execute();//Ejecuta la consulta SQL
            }catch(PDOException $e){
                  $e->getMessage();
            }
          }

}
?>