<?php
/*
@TODO
* Detect type of Fields and run replace query on text & string
* Or you can use this: http://www.softwarerockstars.com/article/mysql-search-and-replace-stored-procedure
*/
$SearchReplace_Array = array(
"ي" => "ی",
"ك" => "ک" );
$mysqli = new mysqli("localhost", "USERNAME", "PASSWORD", "DATABASE_NAME");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$query_TABLES = "SHOW TABLES";
if ($result_TABLES = $mysqli->query($query_TABLES)) {
/* fetch object array */
while ($row_TABLES = $result_TABLES->fetch_row()) {
printf ("\n << %s >> \n", $row_TABLES[0]);
$query_COLUMNS = "SHOW COLUMNS FROM $row_TABLES[0]";
if ($result_COLUMNS = $mysqli->query($query_COLUMNS)) {
while ($row_COLUMNS = $result_COLUMNS->fetch_row()) {
printf ("%s ", $row_COLUMNS[0] );
foreach($SearchReplace_Array as $OldText => $NewText) {
//UPDATE [table_name] SET [field_name] = REPLACE([field_name],'[string_to_find]','[string_to_replace]');
$mysqli->query("UPDATE $row_TABLES[0] SET $row_COLUMNS[0] = REPLACE($row_COLUMNS[0],'$OldText','$NewText');");
}
}
}
}
/* free result set */
$result_TABLES->close();
$result_COLUMNS->close();
}
BY: Farid Ahmadian
TAG: php, mysql, farsi
DATE: 2012-06-1 00:00:01
With many thanks and best wishes for dear Pejman Moghadam, someone who taught me alot in linux and life :)