search script

[soil]

how do i do a search script for mysql?

iv looked at tutorials and have found non that i can get working, could some one post 1 or a link to a good tutorial or some thing, thx

:unsure:

[krankyiuys]

search script? not quite sure what you mean.... if you just want to search for info and display it on a page, just use php...

[soil]

:unsure: like when u search the forum it shows all the topics with that title name.

that type of search script.

[krankyiuys]

  soil said:

:unsure: like when u search the forum it shows all the topics with that title name.

585472280[/snapback]

you'll probably want to use php. i made something like that for my website (link below). it's really simple and all you need is:

searching for 'neowin' in 'Post titles' in database called 'Forum'

SELECT col1, col2 etc. FROM 'Forum WHERE ('Post titles' LIKE 'neowin');

you can also add in ORDER functions to sort by date or whatever you like.

[soil]

:unsure: i sort of under stand that, its for this site http://www.twilektemplefiles.tk/

could u post up the php code for it?

[krankyiuys]

i'm at work right now so i can't access my code back home, but all you need is just a simple select statement to search the database for the info you need.

so in php it goes something like this:

$sql = "SELECT * FROM .... etc. etc." // insert your sql query here

mysql_query($sql);

don't forget to connect to the localhost first!

[soil]

how does it get the info from the form tho?

i found this 1 on the net but couldnt get it to work...

<form method=post action="search.php">arch For:
<p>
User Name: <input type=text name=user size=25 maxlength=25>
<p>
Password: <input type=text name=passwd size=25 maxlength=25>
<p>
<input type=submit>
</form>                                             

//search.php
<?
//You should now this but be sure to connect to your database or this is useless. :/
if ($user == "")
{$user = '%';}

if ($passwd == "")
{$passwd = '%';}
// $user and $passwd are the two column names I used.  Change this to fit your database
$result = mysql_query ("SELECT * FROM yourtable
                         WHERE user LIKE '%$user%'
                         AND passwd LIKE '%$passwd%'
                       ");

if ($row = mysql_fetch_array($result)) {

do {
  PRINT "<b>User Name:?????</b>     ";
  print $row["user"];
  print (" ");
  print ("<br>");
  PRINT "<b>Passwd:?????</b>     ";
  print $row["passwd"];
  print ("<p>");
  PRINT "<b>FirstName:?????</b>     ";
  print $row["firstname"];
  print ("<p>");
} while($row = mysql_fetch_array($result));
} else {print "Sorry, no records were found!";}

//The end result prints the username / passwd / firstname / lastname / ID / email
//you will have to change these fields also to fit your needs
?>

Edited February 15, 2005 by soil

[soil]

:unsure: ok ermm i editd it but its not showing what i search forr :no:

  Quote

        <form method="post" name="search" action="index.php?page=search">

 

    <table width="190%" border="0" cellspacing="0" cellpadding="0">

            <tr>

              <td height="20">

<div align="center">

                  <input type=text name=search size=28 maxlength=25 class=dropdown>

                </div></td>

            </tr>

            <tr>

              <td height="20">

<div align="center">

                  <input name="submit" type=submit class=button value="Search">

                </div></td>

            </tr>

          </table>

  </form>

  Quote

<TABLE cellSpacing="1" cellPadding="4" width="100%" border="0">

  <TBODY>

    <TR>

      <TD class=header align=middle width=69 height=10><FONT

                  size=1><a class=link href="index.php?page=files">Added</a></FONT></TD

      <TD width="381" height=10 align=middle class=header><FONT

                  size=1><a class=link href="index.php?page=sort-name">Name</a></FONT></TD

      <TD class=header align=middle width=117 height=10><FONT

                  size=1><a class=link href="index.php?page=sort-author">Author</a></FONT></TD

      <TD class=header align=middle width=76 height=10><FONT

                  size=1><a class=link href="index.php?page=sort-section">Section</a></FONT></TD

      <TD class=header align=middle width=83 height=10><FONT

                  size=1><a class=link href="index.php?page=sort-version">Version</a></FONT></TD

    </TR>

<?php

include("db_config.php");

if ($search == "")

{$search = '%';}

$result = mysql_query ("SELECT * FROM files

                        WHERE search LIKE '%$downloadsignername%'

      WHERE search LIKE '%$info%'

                      ");

if ($row = mysql_fetch_array($result)) {

do {

?>

  <TR>

    <TD width="69" align=middle class=primary ><font size="1"><?php echo date("m-d-Y", $row['date']); ?></font></TD>

    <TD width="381" class=secondary><a class=link href="<?php echo $row['downloadurl']; ?>" target="_blank"><?php echo $row['info']; ?></a></TD>

    <TD width="117" class=primary><div align="center"><a class=link href="mailto:<?php echo $row['downloademail']; ?>"><?php echo $row['downloadsignername']; ?></a></div></TD>

    <TD width="76" align=middle class=secondary><div align="center"><font size="1"><?php echo $row['downloadpic']; ?></font></div></TD>

    <TD width="83" align=middle class=primary><div align="center"><font size="1"><?php echo $row['version']; ?></font></div></TD>

  </TR>

<?php

} while($row = mysql_fetch_array($result));

} else {print "Sorry, no records were found!";}

?>

</table>

Edited February 15, 2005 by soil

[dnast]

  Quote

include("db_config.php");
if ($search == "")
{$search = '%';}
$result = mysql_query ("SELECT * FROM files
                        WHERE search LIKE '%$downloadsignername%'
       WHERE search LIKE '%$info%'
               ");

I'm not sure how PHP is set up on your server, but you might need to use $_POST. Also, a field name should follow 'WHERE' and the search keyword should follow 'LIKE'.

For example

include("db_config.php");
$search = $_POST['search'];
if ($search == "")
    {$search = '%';}
$result = mysql_query ("SELECT * FROM files
                         WHERE downloadsingername LIKE '%$search%'
                         OR info LIKE '%$search%'");

(I'm assuming 'downloadsingername' [you made a typo there, BTW] and 'info' are fields in your table.)

[soil]

:D yet again thx for the help works now

:D :punk: :bounce: :drool: