foreach ($array as $key => $value) {
$id = $key;
$text = $value;
$query = "SET @last_id = LAST_INSERT_ID(); ";
$query .= "CREATE TEMPORARY TABLE foo AS SELECT * FROM texts WHERE id = $id; ";
$query .= "UPDATE foo SET id = @last_id, html_text = '$text'; ";
$query .= "INSERT INTO texts SELECT * FROM foo; ";
$query .= "DROP TABLE foo; ";
mysqli_multi_query($link, $query);
}
mysqli_close($link);
$sql = "INSERT INTO texts SELECT null, page_id, ballon_no, text_lang, font_size, html_left,
html_top, html_width, html_height, ?, rotate, text_align, aspect_ratio,
position_ratio, calc_width, calc_left, font_color, line_height, font_type
FROM texts WHERE id=?";
$stmt = $link->prepare($sql);
$stmt->bind_param("ss", $text, $id);
foreach ($array as $id => $text) {
$stmt->execute();
}
Средний
Средний
Простой
Средний