admin管理员组

文章数量:1130349

I have problem with function insert. I've got error SHOW FULL COLUMNS FROM `pt_participant. Unfortunatelly i don't know what m'i doing wrong. Code look ok to me. Please help. My code:

    global $wpdb;
    $data = array( 
    'id'=>'',
    'course_id' => (int)$formElements['tripId'],
    'name_and_surname_participant' => $formElements['participantNameSurname'], 
    'date_of_birth' => $formElements['participatntDateOfBirth'],
    'PESEL_participant' => (int)$formElements['participantPESEL'], 
    'comments' => $formElements['participantComment'],
    'name_and_surname_parent' => $formElements['parentNameAndSurname'], 
    'PESEL_parent' => (int)$formElements['parentPESEL'],
    'ID_document' => $formElements['parentIDdocument'], 
    'street' => $formElements['street'],
    'house_number' => (int)$formElements['houseNumber'], 
    'post_id' => $formElements['postID'],
    'city' => $formElements['city'],
    'telephone_number' => (int)$formElements['telephoneNumber'], 
    'email_adress' => $formElements['email'],

    'payment' => (float)0.0,
    'pay_to_date' => date('Y-m-d'),
    'status' => (int)0,
    'contract' => (int)0,
    'regulations' => (int)0,
    'RODO' => (int)0,
    'card' => (int)0,
    'settlement' => (int)0,
    'startPoint' => (int)$formElements['listOfCities']
    ); 

    try{
        $wpdb->show_errors();
        $wpdb->insert('pt_participant', $data);
        echo $wpdb->print_error();
    }
    catch (Exception $e)
    {
    echo $e->getCode().' : '.$e->getMessage();
    }}

And that's my database:

I have problem with function insert. I've got error SHOW FULL COLUMNS FROM `pt_participant. Unfortunatelly i don't know what m'i doing wrong. Code look ok to me. Please help. My code:

    global $wpdb;
    $data = array( 
    'id'=>'',
    'course_id' => (int)$formElements['tripId'],
    'name_and_surname_participant' => $formElements['participantNameSurname'], 
    'date_of_birth' => $formElements['participatntDateOfBirth'],
    'PESEL_participant' => (int)$formElements['participantPESEL'], 
    'comments' => $formElements['participantComment'],
    'name_and_surname_parent' => $formElements['parentNameAndSurname'], 
    'PESEL_parent' => (int)$formElements['parentPESEL'],
    'ID_document' => $formElements['parentIDdocument'], 
    'street' => $formElements['street'],
    'house_number' => (int)$formElements['houseNumber'], 
    'post_id' => $formElements['postID'],
    'city' => $formElements['city'],
    'telephone_number' => (int)$formElements['telephoneNumber'], 
    'email_adress' => $formElements['email'],

    'payment' => (float)0.0,
    'pay_to_date' => date('Y-m-d'),
    'status' => (int)0,
    'contract' => (int)0,
    'regulations' => (int)0,
    'RODO' => (int)0,
    'card' => (int)0,
    'settlement' => (int)0,
    'startPoint' => (int)$formElements['listOfCities']
    ); 

    try{
        $wpdb->show_errors();
        $wpdb->insert('pt_participant', $data);
        echo $wpdb->print_error();
    }
    catch (Exception $e)
    {
    echo $e->getCode().' : '.$e->getMessage();
    }}

And that's my database:

本文标签： databaseError SHOW FULL COLUMNS FROM ptparticipant

版权声明：本文标题：database - Error: SHOW FULL COLUMNS FROM `pt_participant` 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://it.en369.cn/questions/1749070451a2311491.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。