Click here to Skip to main content
15,881,715 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I have the same code for another form and I have no problem, I also complain about the form that this values

Warning: undefined array key with all variables in connection2.php  


<pre lang="PHP"><pre><?php


$mysqli = new mysqli("localhost", "root", "", "javiera");
 
// Check connection
if($mysqli === false){
    die("ERROR: Could not connect. " .$mysqli->connect_error);
}

$Cliente = $mysqli->real_escape_string($_REQUEST['Cliente']);
$Email = $mysqli->real_escape_string($_REQUEST['Email']);
$Fono = $mysqli->real_escape_string($_REQUEST['Fono']);
$Direccion = $mysqli->real_escape_string($_REQUEST['Direccion']);
$Comuna = $mysqli->real_escape_string($_REQUEST['Comuna']);
$Region = $mysqli->real_escape_string($_REQUEST['Region']);
$PersonalContacto = $mysqli->real_escape_string($_REQUEST['PersonalContacto']);
$Cargo = $mysqli->real_escape_string($_REQUEST['Cargo']);
$NSerie = $mysqli->real_escape_string($_REQUEST['NSerie']);
$Marca = $mysqli->real_escape_string($_REQUEST['Marca']);
$Modelo = $mysqli->real_escape_string($_REQUEST['Modelo']);
$Derecho = $mysqli->real_escape_string($_REQUEST['Derecho']);
$Izquierdo = $mysqli->real_escape_string($_REQUEST['Izquierdo']);
$VO = $mysqli->real_escape_string($_REQUEST['VO']);
$Contra = $mysqli->real_escape_string($_REQUEST['Contra']);
$Cabezal = $mysqli->real_escape_string($_REQUEST['Cabezal']);
$Sonda = $mysqli->real_escape_string($_REQUEST['Sonda']);
$Audiometro = $mysqli->real_escape_string($_REQUEST['Audiometro']);
$Microscopio = $mysqli->real_escape_string($_REQUEST['Microscopio']);
$Impedanciometro = $mysqli->real_escape_string($_REQUEST['Impedanciometro']);
$EOA = $mysqli->real_escape_string($_REQUEST['EOA']);
$IrrigadorCalorico = $mysqli->real_escape_string($_REQUEST['IrrigadorCalorico']);
$AccesorioGenerico = $mysqli->real_escape_string($_REQUEST['AccesorioGenerico']);
$AccesorioPC = $mysqli->real_escape_string($_REQUEST['AccesorioPC']);
$OtrosAccesorio = $mysqli->real_escape_string($_REQUEST['OtrosAccesorio']);
$ObservacionRecepcion = $mysqli->real_escape_string($_REQUEST['ObservacionRecepcion']);
$MotivoIngreso = $mysqli->real_escape_string($_REQUEST['MotivoIngreso']);
$RepuestosUsados = $mysqli->real_escape_string($_REQUEST['RepuestosUsados']);
$FechaRecepcion = $mysqli->real_escape_string($_REQUEST['FechaRecepcion']);
$FechaPropuesta = $mysqli->real_escape_string($_REQUEST['FechaPropuesta']);
$FechaEntrega = $mysqli->real_escape_string($_REQUEST['FechaEntrega']);
$Repuestos = $mysqli->real_escape_string($_REQUEST['Repuestos']);
$Total = $mysqli->real_escape_string($_REQUEST['Total']);

 
 
$sql = "INSERT INTO formulario_equipos (Cliente, Email, Fono, Direccion, Comuna, Region, PersonalContacto, Cargo, NSerie, Marca, Modelo, Derecho, Izquierdo, VO, Contra, Cabezal, Sonda,Audiometro, Microscopio, Impedanciometro, EOA, IrrigadorCalorico, AccesorioGenerico, AccesorioPC, OtrosAccesorio, ObservacionRecepcion, MotivoIngreso, RepuestosUsados, FechaRecepcion, FechaPropuesta, FechaEntrega, Repuestos, Total)
VALUES ('$Cliente', '$Email', '$Fono', '$Direccion', '$Comuna', '$Region', '$PersonalContacto', '$Cargo','$NSerie', '$Marca', '$Modelo', '$Derecho', '$Izquierdo', '$VO', '$Contra', '$Cabezal', '$Sonda', '$Audiometro', '$Microscopio', '$Impedanciometro', '$EOA', '$IrrigadorCalorico', '$AccesorioGenerico', '$AccesorioPC', '$OtrosAccesorio', '$ObservacionRecepcion', '$MotivoIngreso', '$RepuestosUsados, '$FechaRecepcion', '$FechaPropuesta', '$FechaEntrega', '$Repuestos', '$Total')";



if($mysqli->query($sql) === true){
    echo "Se ha ingresado la solicitud" ;

} else{
    echo "ERROR: Could not able to execute $sql. " . $mysqli->error;
}
 
// Close connection
$mysqli->close();
?>


What I have tried:

change some ways, I had included the if (isset ($_POST ['Cliente'])) {
       $Cliente= $_POST ['Cliente'];
} for everything but it didn't work
Posted
Comments
Patrice T 4-Jun-21 15:02pm    
Exact error messages, please.
Richard MacCutchan 5-Jun-21 3:44am    
Which line does the error occur on?
Zach Burnett 5-Jun-21 23:46pm    
Based on the Warning, look at how you are submitting your data. What is the action on your form when you click the submit button? Undefined array key indicates that either $_REQUEST is not being set properly, or you are submitting your data some other way.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900