preg_match("~(.+)\\((.+)\\)~", $val, $matches);
// var_dump($matches);
if (!empty($matches)) {
$matches[1] = srchstring($matches[1]);
$matches[1] = srchstring($matches[2]);
$query = "Replace into bus_stops_blr (place,srch) values ('" . mysql_real_escape_string($val) . "','" . trim(strtolower(mysql_real_escape_string($matches[1]))) . "'),('" . mysql_real_escape_string($val) . "','" . trim(strtolower(mysql_real_escape_string($matches[2]))) . "')";
if (mysql_query($query)) {
echo "<br>Record Inserted";
}
}
} elseif (strpos($val, "/") !== FALSE) {
preg_match("~(.+)\\/(.+)~", $val, $matches);
// var_dump($matches);
if (!empty($matches)) {
$matches[1] = srchstring($matches[1]);
$matches[1] = srchstring($matches[2]);
$query = "Replace into bus_stops_blr (place,srch) values ('" . mysql_real_escape_string($val) . "','" . trim(strtolower(mysql_real_escape_string($matches[1]))) . "'),('" . mysql_real_escape_string($val) . "','" . trim(strtolower(mysql_real_escape_string($matches[2]))) . "')";
if (mysql_query($query)) {
echo "<br>Record Inserted";
}
}
}
}
}
}
}
function srchstring($mystring)
{
$words = explode(" ", $mystring);
$ret = $words[0];
for ($i = 1; $i < count($words); $i++) {
<?php
include 'configdb2.php';
$query = "select * from `pin_district`";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
$srch_word = $row["district"];
$locality_id = $row["id"];
$srch_word = trim(preg_replace("~\\b(nagar|road|Street|Layout|Bazar|Town|Lane|Colony|Palya|Circle|City|block|junction|cross|Quarters|&|Gali|Temple|high)\\b~i", " ", $srch_word));
$srch_word = trim(preg_replace("~\\.|\\-|,~", " ", $srch_word));
$srch_word = trim(preg_replace("~[\\s]+~", " ", $srch_word));
$srch_word = srchstring($srch_word);
$q = "update `pin_district` set srch='" . mysql_real_escape_string($srch_word) . "' where id =" . $locality_id;
if (mysql_query($q)) {
echo "<br>Record updated";
}
}
function srchstring($mystring)
{
$words = explode(" ", $mystring);
$ret = $words[0];
for ($i = 1; $i < count($words); $i++) {
if (strlen($words[$i - 1]) == 1 && strlen($words[$i]) == 1) {
$ret .= $words[$i];
} else {
$ret .= " " . $words[$i];
}
}
return $ret;
}
