Anonymous
Почему Ajax возвращает ошибку при отправке данных в базу данных?
Сообщение
Anonymous » 02 окт 2024, 22:17
Я получаю сообщение об ошибке «
ошибка: НЕВЕРНЫЙ ВВОД: (CREATE) ». Я знаю, откуда возникает эта ошибка, но не знаю точно, почему код ее возвращает. Я знаю, что приведенный ниже код не является идеей, но этот проект все еще находится на этапе тестирования, и я буду очищать его по мере создания.
Ниже приведен мой JavaScript
Код: Выделить всё
//Data To Pass Through Ajax Request
var formData = new FormData();
formData.append('create', 1);
formData.append('name', name);
formData.append('ctrl', ctrl);
formData.append('dept', dept);
formData.append('author', author);
formData.append('manager', manager);
formData.append('createDate', create_date);
formData.append('type', type);
formData.append('revm', revm);
formData.append('line', line);
formData.append('num', num);
formData.append('description', description),
formData.append('pdrawing', pdrawing);
formData.append('pdrev', pdrev);
formData.append('cdrawing', cdrawing);
formData.append('cdrev', cdrev);
formData.append('sdrawing', sdrawing);
formData.append('sdrev', sdrev);
formData.append('statutory', statutory);
formData.append('customer', customer);
formData.append('config', config);
formData.append('bonding', bonding);
formData.append('other', other);
formData.append('changes', changes);
formData.append('applications', applications);
formData.append('patents', patents);
formData.append('approvers', approver_string);
formData.append('link1', link_1);
formData.append('link2', link_2);
formData.append('link3', link_3);
formData.append('link4', link_4);
formData.append('link5', link_5);
formData.append('link6', link_6);
formData.append('link7', link_7);
formData.append('link8', link_8);
formData.append('link9', link_9);
formData.append('link10', link_10);
formData.append('link11', link_11);
formData.append('link12', link_12);
formData.append('link13', link_13);
formData.append('link14', link_14);
formData.append('link15', link_15);
formData.append('link16', link_16);
formData.append('link17', link_17);
formData.append('link18', link_18);
formData.append('link19', link_19);
formData.append('link20', link_20);
formData.append('linkName1', linkName_1);
formData.append('linkName2', linkName_2);
formData.append('linkName3', linkName_3);
formData.append('linkName4', linkName_4);
formData.append('linkName5', linkName_5);
formData.append('linkName6', linkName_6);
formData.append('linkName7', linkName_7);
formData.append('linkName8', linkName_8);
formData.append('linkName9', linkName_9);
formData.append('linkName10', linkName_10);
formData.append('linkName11', linkName_11);
formData.append('linkName12', linkName_12);
formData.append('linkName13', linkName_13);
formData.append('linkName14', linkName_14);
formData.append('linkName15', linkName_15);
formData.append('linkName16', linkName_16);
formData.append('linkName17', linkName_17);
formData.append('linkName18', linkName_18);
formData.append('linkName19', linkName_19);
formData.append('linkName20', linkName_20);
//Ajax
$.ajax({
url: './ajax/submitData.ajax.php',
type: 'POST',
data: formData,
processData: false,
contentType: false,
dataType: 'json',
success: function(response) {
console.log(response);
//Check For Timeout
ajaxTimeoutCheck(response);
if (response.success === 1){
closeAndCearCreateModal();
//refreshData();
} else {
document.getElementById("errorMSGCreate").innerHTML = response.error;
}
}
});
Именно здесь возникает моя ошибка в моем файле submitData.ajax.php
Код: Выделить всё
if (isset($_POST['create'])){
if(isset($_POST['name']) && isset($_POST['ctrl']) && isset($_POST['dept']) && isset($_POST['author']) && isset($_POST['manager']) && isset($_POST['createDate']) && isset($_POST['type']) && isset($_POST['revm']) && isset($_POST['line']) && isset($_POST['num']) && isset($_POST['description']) && isset($_FILES['pdrawing']) && isset($_POST['pdrev']) && isset($_FILES['cdrawing']) && isset($_POST['cdrev']) && isset($_FILES['sdrawing']) && isset($_POST['sdrev']) && isset($_POST['statutory']) && isset($_POST['customer']) && isset($_POST['config']) && isset($_POST['bonding']) && isset($_POST['other']) && isset($_POST['changes']) && isset($_POST['applications']) && isset($_POST['patents']) && isset($_POST['approvers']) && isset($_FILES['link1']) && isset($_FILES['link2']) && isset($_FILES['link3']) && isset($_FILES['link4']) && isset($_FILES['link5']) && isset($_FILES['link6']) && isset($_FILES['link7']) && isset($_FILES['link8']) && isset($_FILES['link9']) && isset($_FILES['link10']) && isset($_FILES['link11']) && isset($_FILES['link12']) && isset($_FILES['link13']) && isset($_FILES['link14']) && isset($_FILES['link15']) && isset($_FILES['link16']) && isset($_FILES['link17']) && isset($_FILES['link18']) && isset($_FILES['link19']) && isset($_FILES['link20']) && ($_POST['linkName1']) && ($_POST['linkName2']) && ($_POST['linkName3']) && ($_POST['linkName4']) && ($_POST['linkName5']) && ($_POST['linkName6']) && ($_POST['linkName7']) && ($_POST['linkName8']) && ($_POST['linkName9']) && ($_POST['linkName10']) && ($_POST['linkName11']) && ($_POST['linkName12']) && ($_POST['linkName13']) && ($_POST['linkName14']) && ($_POST['linkName15']) && ($_POST['linkName16']) && ($_POST['linkName17']) && ($_POST['linkName18']) && ($_POST['linkName19']) && ($_POST['linkName20'])) {
echo json_encode(createEntry($_POST['name'], $_POST['ctrl'], $_POST['dept'], $_POST['author'], $_POST['manager'], $_POST['createDate'], $_POST['type'], $_POST['revm'], $_POST['line'], $_POST['num'], $_POST['description'], $_FILES['pdrawing'], $_POST['pdrev'], $_FILES['cdrawing'], $_POST['cdrev'], $_FILES['sdrawing'], $_POST['sdrev'], $_POST['statutory'], $_POST['customer'], $_POST['config'], $_POST['bonding'], $_POST['other'], $_POST['changes'], $_POST['applications'], $_POST['patents'], $_POST['approvers'], $_FILES['link1'], $_FILES['link2'], $_FILES['link3'], $_FILES['link4'], $_FILES['link5'], $_FILES['link6'], $_FILES['link7'], $_FILES['link8'], $_FILES['link9'], $_FILES['link10'], $_FILES['link11'], $_FILES['link12'], $_FILES['link13'], $_FILES['link14'], $_FILES['link15'], $_FILES['link16'], $_FILES['link17'], $_FILES['link18'], $_FILES['link19'], $_FILES['link20'], $_POST['linkName1'], $_POST['linkName2'], $_POST['linkName3'], $_POST['linkName4'], $_POST['linkName5'], $_POST['linkName6'], $_POST['linkName7'], $_POST['linkName8'], $_POST['linkName9'], $_POST['linkName10'], $_POST['linkName11'], $_POST['linkName12'], $_POST['linkName13'], $_POST['linkName14'], $_POST['linkName15'], $_POST['linkName16'], $_POST['linkName17'], $_POST['linkName18'], $_POST['linkName19'], $_POST['linkName20']));
} else {
//Here is the error I am getting
echo json_encode(array("error" => "INVALID INPUT: (CREATE)"));
}
} else {
echo json_encode(array("error" => "INVALID SUBMIT"));
}
Я неправильно написал один из моих ajax-запросов или я делаю что-то еще неправильно в этой ситуации?
Подробнее здесь:
https://stackoverflow.com/questions/790 ... o-database
1727896634
Anonymous
Я получаю сообщение об ошибке «[b]ошибка: НЕВЕРНЫЙ ВВОД: (CREATE)[/b]». Я знаю, откуда возникает эта ошибка, но не знаю точно, почему код ее возвращает. Я знаю, что приведенный ниже код не является идеей, но этот проект все еще находится на этапе тестирования, и я буду очищать его по мере создания. Ниже приведен мой JavaScript [code]//Data To Pass Through Ajax Request var formData = new FormData(); formData.append('create', 1); formData.append('name', name); formData.append('ctrl', ctrl); formData.append('dept', dept); formData.append('author', author); formData.append('manager', manager); formData.append('createDate', create_date); formData.append('type', type); formData.append('revm', revm); formData.append('line', line); formData.append('num', num); formData.append('description', description), formData.append('pdrawing', pdrawing); formData.append('pdrev', pdrev); formData.append('cdrawing', cdrawing); formData.append('cdrev', cdrev); formData.append('sdrawing', sdrawing); formData.append('sdrev', sdrev); formData.append('statutory', statutory); formData.append('customer', customer); formData.append('config', config); formData.append('bonding', bonding); formData.append('other', other); formData.append('changes', changes); formData.append('applications', applications); formData.append('patents', patents); formData.append('approvers', approver_string); formData.append('link1', link_1); formData.append('link2', link_2); formData.append('link3', link_3); formData.append('link4', link_4); formData.append('link5', link_5); formData.append('link6', link_6); formData.append('link7', link_7); formData.append('link8', link_8); formData.append('link9', link_9); formData.append('link10', link_10); formData.append('link11', link_11); formData.append('link12', link_12); formData.append('link13', link_13); formData.append('link14', link_14); formData.append('link15', link_15); formData.append('link16', link_16); formData.append('link17', link_17); formData.append('link18', link_18); formData.append('link19', link_19); formData.append('link20', link_20); formData.append('linkName1', linkName_1); formData.append('linkName2', linkName_2); formData.append('linkName3', linkName_3); formData.append('linkName4', linkName_4); formData.append('linkName5', linkName_5); formData.append('linkName6', linkName_6); formData.append('linkName7', linkName_7); formData.append('linkName8', linkName_8); formData.append('linkName9', linkName_9); formData.append('linkName10', linkName_10); formData.append('linkName11', linkName_11); formData.append('linkName12', linkName_12); formData.append('linkName13', linkName_13); formData.append('linkName14', linkName_14); formData.append('linkName15', linkName_15); formData.append('linkName16', linkName_16); formData.append('linkName17', linkName_17); formData.append('linkName18', linkName_18); formData.append('linkName19', linkName_19); formData.append('linkName20', linkName_20); //Ajax $.ajax({ url: './ajax/submitData.ajax.php', type: 'POST', data: formData, processData: false, contentType: false, dataType: 'json', success: function(response) { console.log(response); //Check For Timeout ajaxTimeoutCheck(response); if (response.success === 1){ closeAndCearCreateModal(); //refreshData(); } else { document.getElementById("errorMSGCreate").innerHTML = response.error; } } }); [/code] Именно здесь возникает моя ошибка в моем файле submitData.ajax.php [code]if (isset($_POST['create'])){ if(isset($_POST['name']) && isset($_POST['ctrl']) && isset($_POST['dept']) && isset($_POST['author']) && isset($_POST['manager']) && isset($_POST['createDate']) && isset($_POST['type']) && isset($_POST['revm']) && isset($_POST['line']) && isset($_POST['num']) && isset($_POST['description']) && isset($_FILES['pdrawing']) && isset($_POST['pdrev']) && isset($_FILES['cdrawing']) && isset($_POST['cdrev']) && isset($_FILES['sdrawing']) && isset($_POST['sdrev']) && isset($_POST['statutory']) && isset($_POST['customer']) && isset($_POST['config']) && isset($_POST['bonding']) && isset($_POST['other']) && isset($_POST['changes']) && isset($_POST['applications']) && isset($_POST['patents']) && isset($_POST['approvers']) && isset($_FILES['link1']) && isset($_FILES['link2']) && isset($_FILES['link3']) && isset($_FILES['link4']) && isset($_FILES['link5']) && isset($_FILES['link6']) && isset($_FILES['link7']) && isset($_FILES['link8']) && isset($_FILES['link9']) && isset($_FILES['link10']) && isset($_FILES['link11']) && isset($_FILES['link12']) && isset($_FILES['link13']) && isset($_FILES['link14']) && isset($_FILES['link15']) && isset($_FILES['link16']) && isset($_FILES['link17']) && isset($_FILES['link18']) && isset($_FILES['link19']) && isset($_FILES['link20']) && ($_POST['linkName1']) && ($_POST['linkName2']) && ($_POST['linkName3']) && ($_POST['linkName4']) && ($_POST['linkName5']) && ($_POST['linkName6']) && ($_POST['linkName7']) && ($_POST['linkName8']) && ($_POST['linkName9']) && ($_POST['linkName10']) && ($_POST['linkName11']) && ($_POST['linkName12']) && ($_POST['linkName13']) && ($_POST['linkName14']) && ($_POST['linkName15']) && ($_POST['linkName16']) && ($_POST['linkName17']) && ($_POST['linkName18']) && ($_POST['linkName19']) && ($_POST['linkName20'])) { echo json_encode(createEntry($_POST['name'], $_POST['ctrl'], $_POST['dept'], $_POST['author'], $_POST['manager'], $_POST['createDate'], $_POST['type'], $_POST['revm'], $_POST['line'], $_POST['num'], $_POST['description'], $_FILES['pdrawing'], $_POST['pdrev'], $_FILES['cdrawing'], $_POST['cdrev'], $_FILES['sdrawing'], $_POST['sdrev'], $_POST['statutory'], $_POST['customer'], $_POST['config'], $_POST['bonding'], $_POST['other'], $_POST['changes'], $_POST['applications'], $_POST['patents'], $_POST['approvers'], $_FILES['link1'], $_FILES['link2'], $_FILES['link3'], $_FILES['link4'], $_FILES['link5'], $_FILES['link6'], $_FILES['link7'], $_FILES['link8'], $_FILES['link9'], $_FILES['link10'], $_FILES['link11'], $_FILES['link12'], $_FILES['link13'], $_FILES['link14'], $_FILES['link15'], $_FILES['link16'], $_FILES['link17'], $_FILES['link18'], $_FILES['link19'], $_FILES['link20'], $_POST['linkName1'], $_POST['linkName2'], $_POST['linkName3'], $_POST['linkName4'], $_POST['linkName5'], $_POST['linkName6'], $_POST['linkName7'], $_POST['linkName8'], $_POST['linkName9'], $_POST['linkName10'], $_POST['linkName11'], $_POST['linkName12'], $_POST['linkName13'], $_POST['linkName14'], $_POST['linkName15'], $_POST['linkName16'], $_POST['linkName17'], $_POST['linkName18'], $_POST['linkName19'], $_POST['linkName20'])); } else { //Here is the error I am getting echo json_encode(array("error" => "INVALID INPUT: (CREATE)")); } } else { echo json_encode(array("error" => "INVALID SUBMIT")); } [/code] Я неправильно написал один из моих ajax-запросов или я делаю что-то еще неправильно в этой ситуации? Подробнее здесь: [url]https://stackoverflow.com/questions/79047899/why-is-ajax-returning-error-when-submitting-data-to-database[/url]