php form with mysql

Navigation
0
<?php
    include 'conectar.php';
    //recibir datos - tabla persona
    $nombre = $_POST['nombre'];
    $apellidoP = $_POST['apellidoP'];
    $apellidoM = $_POST['apellidoM'];
    $direccion = $_POST['direccion'];
    $sexo = $_POST['sexo'];

    //recibir datos - tabla cliente
    $usuario = $_POST['usuario'];
    $mail = $_POST['mail'];
    $contra = $_POST['contra'];
    $foto = $_POST['foto'];
    $persona_idpersona = 0;
    $cliente = 0;


    //consulta para insertar - tabla persona
    $insertarPersona = "INSERT INTO persona(NombrePersona, ApellidoPaterno, ApellidoMaterno, DireccionPersona, SexoPersona) VALUES ('$nombre', '$apellidoP', '$apellidoM', '$direccion', '$sexo')";

    //consulta para insertar - tabla cliente
    /* $insertarCliente = "INSERT INTO cliente (Persona_idPersona, NombreUsuario, TipoCliente_idTipoCliente, Correo, Contraseña, Foto) VALUES ('$persona_idpersona´, '$usuario', '$cliente' '$mail', '$contra', '$foto')";*/

    //ejecutar consulta
    $resultado = mysqli_query($cnx, $insertarPersona);

    //condicion para verificar si se registro
    if (!$resultado) {
        echo 'Error no se registro';
    } else {
        ?>
        <script type="text/javascript">
            window.alert('USUARIO REGISTRADO EXITOSAMENTE');
        </script>
        <?php
    }

    //cerrar conexion
    mysqli_close($cnx);
?>

<meta http-equiv="refresh" content="0,url=inicio_sesion.php">

a question how can I insert data into two tables with the same form in php since I only do the incersion to a single table, I do not know if it is a reason for the relationships that can not insert the other data

    
asked by angel 11.06.2018 в 04:15
source

1 answer

0

You could put the two query in a function, execute them and ask then 

if(mysql_query){
  echo "saved data";
}else{
echo mysql_error();
}
    
answered by 11.06.2018 в 05:10
java.io.FileNotFoundException: When starting Android Error in handling of fork fork waitpid, bash does not return, it remains waiting