Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
CREATE TABLE offers (
id INT(11) UNSIGNED PRIMARY KEY,
title VARCHAR(1400) NOT NULL,
description TEXT NOT NULL
);
INSERT INTO offers
(id, title, description)
VALUES (1, "AssisiOAssisifAssisifAssisirAssisiiAssisi AssisisAssisieAssisirAssisivAssisiiAssisizAssisiiAssisi AssisidAssisiiAssisi AssisitAssisirAssisiaAssisisAssisilAssisioAssisicAssisioAssisi AssisiaAssisi AssisiCAssisieAssisirAssisiiAssisigAssisinAssisioAssisilAssisiaAssisi AssisicAssisioAssisinAssisi AssisiEAssisirAssisinAssisieAssisisAssisitAssisioAssisi", ""),
(2, "This title is good enough. Corsico.Still is good, Corsico.", "FormigineGFormigineoFormigineoFormigined FormiginejFormigineoFormigineb."),
(3, "FormigineGFormigineoFormigineoFormigined FormiginejFormigineoFormiginebFormigine.", "FormigineGFormigineoFormigineoFormigined FormiginejFormigineoFormiginebFormigine")
;
SELECT * FROM offers;
<?php
function replaceCities(string $data)
{
$pattern = '/((?<=[\w])Assisi|(?<=[ ])?Assisi(?![ \.,!?])|(?<=[\w])Corsico|Corsico(?![ \.,!?])|(?<=[\w])Formigine|Formigine(?![ \.,!?]))/m';
return preg_replace($pattern, '', $data);
}
$query = "SELECT id, title, description FROM offers;";
$result = $mysqli->query($query);
$insertData = [];
while ($row = mysqli_fetch_assoc($result)) {
$insertData[] = [
'id' => $row['id'],
'title' => replaceCities($row['title']),
'description' => replaceCities($row['description']),
];
}
$stmt = $mysqli->prepare("UPDATE offers SET title = ?, description = ? WHERE id = ?");
$stmt->bind_param("ssi", $title, $description, $id);
foreach($insertData as $row) {
$id = $row['id'];
$title = $row['title'];
$description = $row['description'];
$stmt->execute();
}
$query = "SELECT id, title, description FROM offers;";
$result = $mysqli->query($query);
while ($row = mysqli_fetch_assoc($result)) {
var_dump($row);
}