This question already has an answer here:
could you guys help me with this code, please conects perfectly to mysql and reads the json file but show that also in json parse see array (array[0]...
require_once('conn_v2_1.php');
$json = file_get_contents('results.json');
$data = json_decode($json, true);
foreach ( $data as $inv ) {
$record_id= $inv['$record_id'];
$contact_info= $inv['contact_info'];
$contact_info_type= $inv['contact_info_type'];
$record_type= $inv['record_type'];
$record_status= $inv['record_status'];
$call_result= $inv['call_result'];
$attempt= $inv['attempt'];
$daily_from= $inv['daily_from'];
$daily_till= $inv['daily_till'];
$tz_dbid= $inv['tz_dbid'];
$email_subject= $inv['email_subject'];
$chain_id= $inv['chain_id'];
$chain_n= $inv['chain_n'];
$direccion= $inv['direccion'];
$NomCliente= $inv['NomCliente'];
$Contrato= $inv['Contrato'];
$st = mysqli_prepare($conn,'INSERT INTO oficinas_contestadas
(record_id,contact_info, contact_info_type, record_type,
record_status,call_result,attempt,
daily_from,daily_till,tz_dbid,email_subject,chain_id,chain_n,
direccion,NomCliente,Contrato)
VALUES($record_id,$contact_info,$contact_info_type,$record_type,
$record_status,$call_result,$attempt,$daily_from,$daily_till,
$tz_dbid,$email_subject,$chain_id,$chain_n,$direccion,
$NomCliente,$Contrato)') or
die(mysqli_error($conn));
// bind variables to insert query params
mysqli_stmt_bind_param($record_id,$contact_info,$contact_info_type,
$record_type,$record_status,$call_result,$attempt,$daily_from,
$daily_till,$tz_dbid,$email_subect,$chain_id,$chain_n,
$direccion,$NomCliente,$Contrato);
// executing insert query
mysqli_stmt_execute($st);
}
error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE);
?>
i get this error
Notice: Undefined index: Contrato in http:localhost/autoload.php on line 44 Unknown column 'record_id' in 'field list'
</div>