Menu
Community /Pin to ProfileBookmark
@NogDogMar 26.2020 — #This would not be the final code I'd want to deploy, but for some quick debugging, let's get all defensive-coding about it:
My wild guess is that
(Warning: all code is untested.)
Notice : Undefined index: id line 4
Hello, I am in a problem and it is that it appears to me that I have indefinite id , I have actually been able to solve it. I give you my code waiting for advice. Thank you
Sign in
to post a comment23 Comments(s) ↴
0
@NogDogMar 26.2020 — #This would not be the final code I'd want to deploy, but for some quick debugging, let's get all defensive-coding about it:<i>
</i><?php
ini_set('display_errors', true);
error_reporting(E_ALL);
if(empty($_GET['id'])) {
die("<pre>ERROR: 'id' not set.</pre>");
}
$consulta = ConsultarCuenta($_GET['id']);
if($consulta == false) {
die("<pre>Nothing returned by query</pre>");
}
function ConsultarCuenta($id)
{
require 'conexion.php'; // it's not optional, so <span><code>require</code></span> it
$sentencia = "SELECT * FROM cuenta WHERE id='$id'";
$resultado = $conexion->query($sentencia);
if($resultado == false) {
die("<pre>QUERY ERROR:n".print_r($conexion->errorInfo(), true)."nQuery:n$$sentencia</pre>");
}
$fila = $resultado->fetch(PDO::FETCH_ASSOC);
return $fila;
}
My wild guess is that
cuenta.id<i>
</i>function ConsultarCuenta($id)
{
require 'conexion.php'; // it's not optional, so <span><code>require</code></span> it
$sentencia = "SELECT * FROM cuenta WHERE id = :id";
$stmt = $conexion->prepare($sentencia);
if($stmt == false) {
die("<pre>INVALID QUERY:n".print_r($conexion->errorInfo())."nSQL:n$sentencia</pre>");
}
$resultado = $stmt->execute($stmt, array('id' => $id));
if($resultado == false) {
die("<pre>QUERY ERROR:n".print_r($stmt->errorInfo(), true)."nQuery:n$$sentencia</pre>");
}
$fila = $resultado->fetch(PDO::FETCH_ASSOC);
return $fila;
}
(Warning: all code is untested.)