insertion in related tables

Question

Hello, I am working with some related tables and I can not insert the values in the next rabela, I found that I need to recover the last id inserted in the still can not use it, without the relation the tables work perfectly. Follow commands. OBS: Do not execute it does not return any error.

Customer class

public function sendDado(){

  if($_POST){
    try{
      $query = $this->db->prepare("INSERT INTO CLIENTE(nome, email) values(:nome,:email)");
      $query->bindValue(":nome", $_POST['nome'], PDO::PARAM_STR);
      $query->bindValue(":email", $_POST['email'], PDO::PARAM_STR);
      $query->execute();
      echo "Enviado com sucesso";
      header('Location: telefone.tpl.php');
      //return ($query);
    }catch(PDOException $e){
        echo "Não foi possivel enviar";
    }
  }else{
      echo "";
  }

    return $query;
}

Telephone class

public function sendDado($scan){

    //$scan = new Cliente();
    //$esse->scan = $scan->sendDado();
    //$esse-> sendDado($scan);

    $u_id = $this->db->query("SELECT LAST_INSERT_ID()");

    if($u_id != null){
        if($_POST){
            try{
                $query = $this->db->prepare("INSERT INTO TELEFONES(rel_id,telefone,celular,ramal) values (:u_id,:telefone,:celular,:ramal)");
                $query->bindValue(":u_id",$_POST['u_id'],PDO::PARAM_INT);
                $query->bindValue(":telefone",$_POST['telefone'],PDO::PARAM_INT);
                $query->bindValue("celular",$_POST['celular'],PDO::PARAM_INT);
                $query->bindValue("ramal",$_POST['ramal'],PDO::PARAM_INT);
                $query->execute();
                echo "Enviado com sucesso";

                //if(){
                    header('Location: emp.tpl.php');
                //)else{
                    //header('Location: ');
                //}
            }catch(PDOException $e){
                echo 'Informacao não pode ser enviada';
            }

        }

    }else{
        echo $u_id;
        //header('Location: cliente.tpl.php');
    }
}

Answer 1

Since your code is not complete, I don’t know exactly how it was implemented.

NOTE: I wouldn’t use the header('Location:...., would make the CLIENT class instantiating the PHONE class.

Anyway, it follows a solution based on your code:

Customer class

error_reporting (E_ALL);

public function sendDado(){

  if($_POST){
    try{
      $query = $this->db->prepare("INSERT INTO CLIENTE(nome, email) values(:nome,:email)");
      $query->bindValue(":nome", $_POST['nome'], PDO::PARAM_STR);
      $query->bindValue(":email", $_POST['email'], PDO::PARAM_STR);
      $query->execute();

      // lê o ID do cliente inserido
      $cliente_id = $this->db->lastInsertId();  

      echo "Enviado com sucesso";

      // passa ID do cliente via GET para TELEFONE
      header('Location: telefone.tpl.php?id_cliente=' . $cliente_id); 
      //return ($query);
    }catch(PDOException $e){
        echo "Não foi possivel enviar";
    }
  }else{
      echo "";
  }

    return $query;
}

Telephone class

error_reporting (E_ALL);

public function sendDado($scan) {

// RECEBE o GET com o ID DO CLIENTE e filtra, deixando só inteiros
$u_id = filter_input(INPUT_GET, 'id_cliente', FILTER_VALIDATE_INT, 1);

if ($u_id != null) {

    try {
        $query = $this->db->prepare("INSERT INTO TELEFONES(rel_id,telefone,celular,ramal) values (:u_id,:telefone,:celular,:ramal)");
        $query->bindValue(":u_id", $_POST['u_id'], PDO::PARAM_INT);
        $query->bindValue(":telefone", $_POST['telefone'], PDO::PARAM_INT);
        $query->bindValue("celular", $_POST['celular'], PDO::PARAM_INT);
        $query->bindValue("ramal", $_POST['ramal'], PDO::PARAM_INT);
        $query->execute();
        echo "Enviado com sucesso";

        //if(){
        header('Location: emp.tpl.php');
        //)else{
        //header('Location: ');
        //}
    } catch (PDOException $e) {
        echo 'Informacao não pode ser enviada';
    }
} else {
    echo $u_id;
    //header('Location: cliente.tpl.php');
}
}

I hope I’ve helped.