Home / Questions / 186354
Accepted
Javier
Asked: 2020-08-05 10:07:34 +0800 CST 2020-08-05 10:07:34 +0800 CST

Pass value from mysql to input

  • 772

Hello, good afternoon, I need to pass a value from mysql to input (text box), I am doing it in the following way but it throws me the following error:

    $conexion=mysqli_connect($nombre_host,$nombre_usuario,$contrasena_usuario,$nombre_bd);

$consulta="SELECT * FROM clientes WHERE cedula='08522002'";
$resultados=mysqli_query($conexion,$consulta);
$fila=mysqli_fetch_row($resultados);

echo "<script type='text/javascript'>
document.getElementById('nombre_cliente').value =" . $fila[1] .  "</script>";
}

enter image description here

php

2 Answers

  1. Best Answer

    Apart from the fact that the code seems to be quite poorly organized haha, the error it is throwing is because when interpreted it looks like this:

    document.getElementById('nombre_cliente').value = Brayan</script>";

    Where Javascript is expecting Brayan to be the name of a variable and not a string.

    Try to do the following:

    echo "<script type='text/javascript'>";
echo 'document.getElementById("nombre_cliente").value ='.'"'.$fila[1].'"'.'</script>';

    It should work that way. Greetings.

    • 1

  2. It's because by putting $row[1] you are not putting it in quotes and that makes javascript interpret it as a variable. And since that variable Brayan is not defined, it throws the error.

    You would have to change this:

     echo "<script type='text/javascript'>document.getElementById('nombre_cliente').value =" . $fila[1] .  "</script>";

    for something like:

     echo "<script type='text/javascript'>document.getElementById('nombre_cliente').value ='" . $fila[1] .  "'</script>";

    either

     echo "<script type='text/javascript'>document.getElementById('nombre_cliente').value ="."'" . $fila[1] ."'".  "</script>";

    I haven't tested the code so there may be bugs, but that's the bug.

    • 0