how do i reformat my query_string in PHP?

alexander_s

Hi guys!

Im using:
MySQL
Apache2
PHP
powered by Gentoo.

My problem is when i search for example diablo in my database, sure i get diablo
the title and the text.

And when i try to insert something else into the database like linux rox and penguins are sexy 😉

it wont just give me the diablo text when i search for diablo it gives me all the text in the entire database 🙁

So what im saying is if i want to have an "ok" searchengine it should be able to separate the texts from eachother right?

And i guess i can do this by reformatting my query_string?

I would really appreciate some examples or just the syntax thats needed.

Thanks !! / Alexander

rachel2004

It would be helpful if you post your CREATE TABLE statement and some sample queries that you are doing. Then say what you want to further do on top of that query.

alexander_s

This is my php.index file.

<?php
// Functionen kan vara vettig att sätta i en annan fil som man
// kallar på med include. Då behöver du inte ha dina databas
// uppgifter, password i alla filer, om du gör sql förfrågningar
// i flera filer.
function texter()
{
global $conn;
$conn = mysql_connect("localhost", "user", "iwonttellyou") or die(mysql_error());
mysql_select_db("databas",$conn) or die(mysql_error());
}
?>

<html><head></head>
<body>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">
Sök efter: <input type="text" size="25" name="searchfor" /><br />
<input type="submit" value="Sök!" />
</form>

<?php
// isset() kollar ifall du gjort en sökning, alltså om det finns ett
// värde på $POST['searchfor']. trim() trimmar bort tomma
// tecken i början och slutet. Förhindrar att allt kommer fram
// ifall du gör en tom sökning.
if (isset($POST['searchfor']) && trim($_POST['searchfor']) != '')
{
texter();

$searchfor = addslashes($_POST['searchfor']);
$sql="SELECT title, text FROM texts,details WHERE title LIKE '%".$searchfor."%';";
$result=mysql_query($sql, $conn);

if(mysql_affected_rows()>0)
{
echo "Följande poster hittades:<br />";

while($row = mysql_fetch_array($result))
{
  $details = $row['title'];
  $texts = $row['text'];
  printf("%s, %s<br />", $title, $text);
}

mysql_free_result($result);
}
else
echo "Inga poster hittades.<br />";

mysql_close($conn);
}
?>
</body>
</html>

As you can see my database is set up like this:

create database texter;
create table details (textid int not null primary key auto_increment,title varchar(255),date date);
create table texts (textid int not null,text longtext);

Thanks! / Alexander