404

D7net
:/ var / www / html / rosario / adm / app / adms / Models / helper /
Filename : AdmsUpdate1.php
back
<?php

namespace App\adms\Models\helper;


/**
 * Description of AdmsUpdate
 *
 * @copyright (c) year, Cesar Szpak - Celke
 */
class AdmsUpdate1 extends AdmsConn1
{

    private $Tabela;
    private $Dados;
    private $Query;
    private $Conn;
    private $Resultado;
    private $Termos;
    private $Values;

    function getResultado()
    {
        return $this->Resultado;
    }

    public function exeUpdate($Tabela, array $Dados, $Termos = null, $ParseString = null)
    {
        
        $this->Tabela = (string) $Tabela;
        $this->Dados = $Dados;
        $this->Termos = (string) $Termos;
      //  var_dump($this->Tabela);
      // var_dump($this->Dados);
      //  var_dump($this->Termos);
        parse_str($ParseString, $this->Values);
        $this->getIntrucao();
        $this->executarInstrucao();
    }

    private function getIntrucao()
    {
        foreach ($this->Dados as $key => $Value) {
            $Values[] = $key . '= :' . $key;
        }
        $Values = implode(', ', $Values);
         
        
       $this->Query = "UPDATE {$this->Tabela} SET {$Values} {$this->Termos}";
      
      
    }

    private function executarInstrucao()
    {
        $this->conexao();
        try {
            $this->Query->execute(array_merge($this->Dados, $this->Values));
            $this->Resultado = true;
        } catch (Exception $ex) {
            $this->Resultado = null;
        }
    }

    private function conexao()
    {
        $this->Conn = parent::getConn();
        $this->Query = $this->Conn->prepare($this->Query);
    }

}