mysqli_multi_query verliert connection
Lynky
- php
Hallo zusammen,
ich verwende die mysqli_multi_query funktion um alte datensaetze aus einer tabelle zu loeschen und neue datensaetze einzufuegen. Mein Code:
...
$Query = "DELETE FROM `resumes_education` WHERE resume_id = ".$this->POSTV['res_id'].";";
$Query .= "DELETE FROM `resumes_certifications` WHERE resume_id = ".$this->POSTV['res_id'].";";
$Query .= "DELETE FROM `resumes_skills` WHERE resume_id = ".$this->POSTV['res_id'];
$res1 = mysqli_multi_query($MYSQL_LINK, $Query);
$Query = '';
if (isset($this->POSTV['resume_edu_institution'])) {
foreach ($this->POSTV['resume_edu_institution'] as $idx => $instvals) {
$Query .= "INSERT INTO `resumes_education` (
`resume_id`,
`institution` ,
`location` ,
`certificate` ,
`year` ,
`qualifications`
)
VALUES (
".myesc($this->POSTV['res_id']).",
".myesc($this->POSTV['resume_edu_institution'][$idx]).",
".myesc($this->POSTV['resume_edu_certificate'][$idx]).",
".myesc($this->POSTV['resume_edu_location'][$idx]).",
".myesc($this->POSTV['resume_edu_year'][$idx]).",
".myesc($this->POSTV['resume_edu_qualifications'][$idx])."
);";
}
}
$res2 = true;
if ($Query != '') {
echo $Query;
$res2 = mysqli_multi_query($MYSQL_LINK, $Query);
}
...
Die DELETE statements in der ersten Query werden ausgefuehrt, nicht allerdings die INSERTS. Die geben mir folgende Fehlermeldung:
2013: Lost connection to MySQL server during query
Wenn ich nur _ein_ DELETE ausfuehre ("welches" spielt keine Rolle) und nur _ein_ INSERT dann funktioniert die Geschichte. Wuerde jedoch nur ungern auf meine foreach-schleife verzichten!
Weiss jemand Rat?
Gruesse,
Lynky