Mam problem z ponizszym skryptem.
Nie wiem co jest nie tak, gdzie jest blad. Niezaleznie czy cos wpisze czy nie,
w wynikach wyszukiwania za kazdym razem wyswietlane sa wszystkie wpisy z bazy.
<head>
<link rel="stylesheet" type="text/css" href="includescss.css">
</head>
<html>
<body>
<font face="tahoma" size="4"> <font face="Verdana, Arial, Helvetica, sans-serif"></font></font>
<form action="
<?php echo($_SERVER['PHP_SELF']); ?>" method="post">
<font face="Verdana, Arial, Helvetica, sans-serif">
<input type="text" name="words" value="
<?php echo($words); ?>">
<br>
<br>
<input type="hidden" name="good" value="yes">
<input type="submit" value="Szukaj">
</font>
</form>
<p><font face="Verdana, Arial, Helvetica, sans-serif"><br>
<br>
<?
/*
This script is set up specifically for me so some things will need changing.
I made this script because there is a lack of good mysql serching scripts out th
ere.
*/
if($_POST['good']=='yes')
{
echo("<font face="tahoma
" size="3" color="green
"><b>Wyszukiwanie dla : $words</b></font><br><br>"); $location = "localhost"; // database host (localhost)
$username = "uzytkownik"; // mysql username
$password = "haslo"; //mysql password
$database = "nazwa_bazy"; //mysql database name
$db_table = "tabelka"; // mysql table name to search
$mysql_row = "opis"; // This is the row in your mysql database that you want to search for text in.
if (!$conn) die ("Could not connect MySQL");
$query = "ALTER TABLE $db_table ORDER BY nazwa DESC";
$query = "SELECT * FROM $db_table";
{
/*
event_id
event_date
event_venue
event_headline
event_town
are all rows in my mysql table. You must replace them with your own rows / rows
*/
$rawid = ($row[id]);
$rawmonth = ($row[nazwa]); //yes strange variable names. It works so it doesnt matter.
$rawdate = ($row[adres]); //T just grab extra data to be added with the search tool
$rawyear = ($row[kontakt_osoba]);
$newnews = preg_replace("/$words/i", "<b><font color="red
">$words</font></b>", $row[$mysql_row]); $display = '<font face="tahoma" size="2"><b>' .$rawmonth . ' ' . $rawdate . ', ' . $rawyear . '</b><br>' . $newnews . '</font><br><br>';
$foundcount++;
}
$totalcount++;
}
if(is_null($foundcount)){$foundcount=0;} echo("<font face="tahoma
" size="3" color="green
"><b>Przeszukano: $totalcount wpisy, Znaleziono: $foundcount </b></font>"); }
?>
<br>
</font></p>
moze mi pomozecie
wyszukiwarka nie szuka
graf wyszukiwarka nie szuka 2.06.2007, 21:25:06 
