Възникна проблем...имам скрипт който търси в дадена таблица и колона някакъв текст, обаче когато съдържа няколко думи м/у тях трея да има някакъв символ или дума...обаче аз искам да няма да е разтояни...
ето скрипта
<?
$db_host = "";
$db_user = "";
$db_pass = "";
$db_name = "";
$dbac = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die ("Не мога да се свържа с базата данни!");
$chars="SET CHARACTER SET cp1251";mysql_query($chars);
if (!$_POST['search']){
// Breaking out of php to display the form.
?>
<form name="Търсене" method="post" action="">
<label>
<input name="swords" type="text" size="30" maxlength="30">
</label>
<br>
<label>
<input name="search" type="submit" id="search" value="Търси">
</label>
</form>
<?
}else{
// Adding slashes and changing tags so that people trying to take advantage of the system can't
$searchwords = addslashes(htmlspecialchars($_POST['swords']));
// Checking the length of string to make sure its more than 3 characters long
if (strlen($searchwords) < 2){
echo "Думата ,която сте написали е прекалено къса, моля напишете друга.";
}else{
$words = explode(' ',$searchwords);
$totalwords = count($words);
$i = 0;
$searchstring = "";
// Now we are looping to get the search string, however we could use a for loop.
// But i think while loops are much easier to teach with/edit
while ($i != $totalwords){
if ($i != 0 and $i != $wordcount){
$searchstring .= " and ";//тук е това с символа искам да е празно място
}
$searchstring .= "name LIKE '%$words[$i]%' or type LIKE '%$words[$i]%'";
// Incrementing the value
$i = $i + 1;
}
// Now we are gong to execute the query with the search string we have just created.
$query = mysql_query("SELECT DISTINCT * FROM proekt where $searchstring");
// Want to check that we got something
if (mysql_num_rows($query) == 0){
echo "Няма намерени Проекти ";
}else{
while ($fet = mysql_fetch_array($query)){
echo "<a href=\"index.php?s=proektinfo&id={$fet['id']}\">{$fet['name']}</a></br></br>";
}// End While
}// End Else
}// End Else
}// End Else
?>
или да ми предоложите друго решение
ето скрипта
<?
$db_host = "";
$db_user = "";
$db_pass = "";
$db_name = "";
$dbac = mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db ($db_name) or die ("Не мога да се свържа с базата данни!");
$chars="SET CHARACTER SET cp1251";mysql_query($chars);
if (!$_POST['search']){
// Breaking out of php to display the form.
?>
<form name="Търсене" method="post" action="">
<label>
<input name="swords" type="text" size="30" maxlength="30">
</label>
<br>
<label>
<input name="search" type="submit" id="search" value="Търси">
</label>
</form>
<?
}else{
// Adding slashes and changing tags so that people trying to take advantage of the system can't
$searchwords = addslashes(htmlspecialchars($_POST['swords']));
// Checking the length of string to make sure its more than 3 characters long
if (strlen($searchwords) < 2){
echo "Думата ,която сте написали е прекалено къса, моля напишете друга.";
}else{
$words = explode(' ',$searchwords);
$totalwords = count($words);
$i = 0;
$searchstring = "";
// Now we are looping to get the search string, however we could use a for loop.
// But i think while loops are much easier to teach with/edit
while ($i != $totalwords){
if ($i != 0 and $i != $wordcount){
$searchstring .= " and ";//тук е това с символа искам да е празно място
}
$searchstring .= "name LIKE '%$words[$i]%' or type LIKE '%$words[$i]%'";
// Incrementing the value
$i = $i + 1;
}
// Now we are gong to execute the query with the search string we have just created.
$query = mysql_query("SELECT DISTINCT * FROM proekt where $searchstring");
// Want to check that we got something
if (mysql_num_rows($query) == 0){
echo "Няма намерени Проекти ";
}else{
while ($fet = mysql_fetch_array($query)){
echo "<a href=\"index.php?s=proektinfo&id={$fet['id']}\">{$fet['name']}</a></br></br>";
}// End While
}// End Else
}// End Else
}// End Else
?>
или да ми предоложите друго решение