dongwei1263 2018-10-10 22:09
浏览 61

未知列和未定义索引[重复]

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>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 自适应 AR 模型 参数估计Matlab程序
    • ¥100 角动量包络面如何用MATLAB绘制
    • ¥15 merge函数占用内存过大
    • ¥15 Revit2020下载问题
    • ¥15 使用EMD去噪处理RML2016数据集时候的原理
    • ¥15 神经网络预测均方误差很小 但是图像上看着差别太大
    • ¥15 单片机无法进入HAL_TIM_PWM_PulseFinishedCallback回调函数
    • ¥15 Oracle中如何从clob类型截取特定字符串后面的字符
    • ¥15 想通过pywinauto自动电机应用程序按钮,但是找不到应用程序按钮信息
    • ¥15 如何在炒股软件中,爬到我想看的日k线