Arkadaşlar merhaba, veritabanındaki verileri güncellemeye çalışırken aşağıdaki hatayı alıyorum.
Warning: Header may not contain more than a single header, new line detected in C:xampphtdocscexincsubmit.php on line 180
submit.php dosya içeriğini aşağıya ekliyorum. Hata nerede yardım edebilir misiniz?
<?php
include 'connect.php';
if (isset($_POST['insert_process'])) {
$save=$db->prepare("INSERT into providers set
provider_name=:provider_name,
provider_dept1_name=:provider_dept1_name,
provider_dept1_email=:provider_dept1_email,
provider_dept1_phone=:provider_dept1_phone,
provider_dept1_emergency=:provider_dept1_emergency,
provider_dept1_note=:provider_dept1_note,
provider_dept1_workinghours=:provider_dept1_workinghours,
provider_dept2_name=:provider_dept2_name,
provider_dept2_email=:provider_dept2_email,
provider_dept2_phone=:provider_dept2_phone,
provider_dept2_emergency=:provider_dept2_emergency,
provider_dept2_note=:provider_dept2_note,
provider_dept2_workinghours=:provider_dept2_workinghours,
provider_dept3_name=:provider_dept3_name,
provider_dept3_email=:provider_dept3_email,
provider_dept3_phone=:provider_dept3_phone,
provider_dept3_emergency=:provider_dept3_emergency,
provider_dept3_note=:provider_dept3_note,
provider_dept3_workinghours=:provider_dept3_workinghours,
provider_url=:provider_url,
provider_login1_user1=:provider_login1_user1,
provider_login1_user2=:provider_login1_user2,
provider_login1_pass=:provider_login1_pass,
provider_login1_note=:provider_login1_note,
provider_login2_user1=:provider_login2_user1,
provider_login2_user2=:provider_login2_user2,
provider_login2_pass=:provider_login2_pass,
provider_login2_note=:provider_login2_note,
provider_login3_user1=:provider_login3_user1,
provider_login3_user2=:provider_login3_user2,
provider_login3_pass=:provider_login3_pass,
provider_login3_note=:provider_login3_note
");
$insert=$save->execute(array(
'provider_name' => $_POST['provider_name'],
'provider_dept1_name' => $_POST['provider_dept1_name'],
'provider_dept1_email' => $_POST['provider_dept1_email'],
'provider_dept1_phone' => $_POST['provider_dept1_phone'],
'provider_dept1_emergency' => $_POST['provider_dept1_emergency'],
'provider_dept1_note' => $_POST['provider_dept1_note'],
'provider_dept1_workinghours' => $_POST['provider_dept1_workinghours'],
'provider_dept2_name' => $_POST['provider_dept2_name'],
'provider_dept2_email' => $_POST['provider_dept2_email'],
'provider_dept2_phone' => $_POST['provider_dept2_phone'],
'provider_dept2_emergency' => $_POST['provider_dept2_emergency'],
'provider_dept2_note' => $_POST['provider_dept2_note'],
'provider_dept2_workinghours' => $_POST['provider_dept2_workinghours'],
'provider_dept3_name' => $_POST['provider_dept3_name'],
'provider_dept3_email' => $_POST['provider_dept3_email'],
'provider_dept3_phone' => $_POST['provider_dept3_phone'],
'provider_dept3_emergency' => $_POST['provider_dept3_emergency'],
'provider_dept3_note' => $_POST['provider_dept3_note'],
'provider_dept3_workinghours' => $_POST['provider_dept3_workinghours'],
'provider_url' => $_POST['provider_url'],
'provider_login1_user1' => $_POST['provider_login1_user1'],
'provider_login1_user2' => $_POST['provider_login1_user2'],
'provider_login1_pass' => $_POST['provider_login1_pass'],
'provider_login1_note' => $_POST['provider_login1_note'],
'provider_login2_user1' => $_POST['provider_login2_user1'],
'provider_login2_user2' => $_POST['provider_login2_user2'],
'provider_login2_pass' => $_POST['provider_login2_pass'],
'provider_login2_note' => $_POST['provider_login2_note'],
'provider_login3_user1' => $_POST['provider_login3_user1'],
'provider_login3_user2' => $_POST['provider_login3_user2'],
'provider_login3_pass' => $_POST['provider_login3_pass'],
'provider_login3_note' => $_POST['provider_login3_note']
));
if ($insert) {
header("Location:../admin_add_provider.php?result=success");
//echo "Kayıt başarılı";
exit;
} else {
header("Location:../admin_add_provider.php?result=failed");
//echo "Kayıt başarısız";
exit;
}
}
if (isset($_POST['update_process'])) {
$provider_id=$_POST['provider_id'];
$save=$db->prepare("UPDATE providers set
provider_name=:provider_name,
provider_dept1_name=:provider_dept1_name,
provider_dept1_email=:provider_dept1_email,
provider_dept1_phone=:provider_dept1_phone,
provider_dept1_emergency=:provider_dept1_emergency,
provider_dept1_note=:provider_dept1_note,
provider_dept1_workinghours=:provider_dept1_workinghours,
provider_dept2_name=:provider_dept2_name,
provider_dept2_email=:provider_dept2_email,
provider_dept2_phone=:provider_dept2_phone,
provider_dept2_emergency=:provider_dept2_emergency,
provider_dept2_note=:provider_dept2_note,
provider_dept2_workinghours=:provider_dept2_workinghours,
provider_dept3_name=:provider_dept3_name,
provider_dept3_email=:provider_dept3_email,
provider_dept3_phone=:provider_dept3_phone,
provider_dept3_emergency=:provider_dept3_emergency,
provider_dept3_note=:provider_dept3_note,
provider_dept3_workinghours=:provider_dept3_workinghours,
provider_url=:provider_url,
provider_login1_user1=:provider_login1_user1,
provider_login1_user2=:provider_login1_user2,
provider_login1_pass=:provider_login1_pass,
provider_login1_note=:provider_login1_note,
provider_login2_user1=:provider_login2_user1,
provider_login2_user2=:provider_login2_user2,
provider_login2_pass=:provider_login2_pass,
provider_login2_note=:provider_login2_note,
provider_login3_user1=:provider_login3_user1,
provider_login3_user2=:provider_login3_user2,
provider_login3_pass=:provider_login3_pass,
provider_login3_note=:provider_login3_note
WHERE provider_id={$_POST['provider_id']}
");
$insert=$save->execute(array(
'provider_name' => $_POST['provider_name'],
'provider_dept1_name' => $_POST['provider_dept1_name'],
'provider_dept1_email' => $_POST['provider_dept1_email'],
'provider_dept1_phone' => $_POST['provider_dept1_phone'],
'provider_dept1_emergency' => $_POST['provider_dept1_emergency'],
'provider_dept1_note' => $_POST['provider_dept1_note'],
'provider_dept1_workinghours' => $_POST['provider_dept1_workinghours'],
'provider_dept2_name' => $_POST['provider_dept2_name'],
'provider_dept2_email' => $_POST['provider_dept2_email'],
'provider_dept2_phone' => $_POST['provider_dept2_phone'],
'provider_dept2_emergency' => $_POST['provider_dept2_emergency'],
'provider_dept2_note' => $_POST['provider_dept2_note'],
'provider_dept2_workinghours' => $_POST['provider_dept2_workinghours'],
'provider_dept3_name' => $_POST['provider_dept3_name'],
'provider_dept3_email' => $_POST['provider_dept3_email'],
'provider_dept3_phone' => $_POST['provider_dept3_phone'],
'provider_dept3_emergency' => $_POST['provider_dept3_emergency'],
'provider_dept3_note' => $_POST['provider_dept3_note'],
'provider_dept3_workinghours' => $_POST['provider_dept3_workinghours'],
'provider_url' => $_POST['provider_url'],
'provider_login1_user1' => $_POST['provider_login1_user1'],
'provider_login1_user2' => $_POST['provider_login1_user2'],
'provider_login1_pass' => $_POST['provider_login1_pass'],
'provider_login1_note' => $_POST['provider_login1_note'],
'provider_login2_user1' => $_POST['provider_login2_user1'],
'provider_login2_user2' => $_POST['provider_login2_user2'],
'provider_login2_pass' => $_POST['provider_login2_pass'],
'provider_login2_note' => $_POST['provider_login2_note'],
'provider_login3_user1' => $_POST['provider_login3_user1'],
'provider_login3_user2' => $_POST['provider_login3_user2'],
'provider_login3_pass' => $_POST['provider_login3_pass'],
'provider_login3_note' => $_POST['provider_login3_note']
));
if ($insert) {
header("Location:../admin_edit_provider.php?id=$provider_id&result=success");
//echo "Kayıt başarılı";
exit;
} else {
header("Location:../admin_edit_provider.php?id=$provider_id&result=failed");
//echo "Kayıt başarısız";
exit;
}
}
?>