PHP search engine-need some advice

darkcarnival · #1 (**permalink**) 07-11-03, 02:10 PM

hi,

now this script isnt done yet.but i am almost done but i want to see if this is stable enough to run. now im going to add the admin file once im done w/that.if you think i should add something tell me, this is my 1st program.remember i just want to see if it is runable it doesnt work(as of yet)

darkcarnival · #2 (**permalink**) 07-16-03, 09:20 AM

see ppl r downloadin my script but hasnt told me if it is runable or not.

Jerome · #3 (**permalink**) 07-17-03, 06:04 AM

the problem is we are not able to test the thing without the config.php and the mysql query execute ... so i guess for a full test to the script , pls provide these file too

darkcarnival · #4 (**permalink**) 07-17-03, 08:43 AM

um did u read it, it doesnt work! i only want to see if it is coded right.once i get the admin panel done then ill allow other to fully try it.this is just to see if it is coded right.since it is my 1st program.

Damian · #5 (**permalink**) 07-17-03, 05:44 PM

how are we supposed to read your code without testing it !??! heh...come on dude it's doesn't work that way... provide everything and we will be more than happy to help you out

darkcarnival · #6 (**permalink**) 07-17-03, 07:20 PM

look i want u to look at the code NOT run it. geez just look at it and see if it is coded right. you guys are smart, just look at the source code and tell me if i coded it right. i dont want to hear if it runs good ill decide that. just want to see if it is coded like a search engine should be. im still working on the admin panel like i said so i want someone to look over the code and tell me if i coded it wrong.

i swear if i hear one more post telling to post the other files ill just find another place to help me cause u guys cant read what im typing!!

BdSBB · #7 (**permalink**) 07-17-03, 07:29 PM

it doesn't work... you will see common errors when you actually try running the script. also you are using HTML inside of your PHP, don't do that.

...html goes here...
<?php
...php goes here...
?>
...html goes here...

Another thing I see is that your re-writing variables and connecting to the database in each IF statement. Try and lessen these by placing common variables at the top including database connections.

Chris Boulton · #8 (**permalink**) 07-18-03, 08:11 AM

PHP Code:


			
<?

/********************************\

 #Metal Search v1.0

\********************************/



include ("config.php");



IF ($Choice == "Artist")

{



    $VER="1.0"

    $date = Date("F d, Y");

    $keyword = $_GET['query']

    $db_connection = mysql_connect ($DB_HOST, $DB_USER, $DB_PASS) or die ('Could not connect to MySQL: ' . mysql_error());



    mysql_select_db ($DB_NAME) or die ('Could not select database: ' . mysql_error());



    $query = "SELECT Name, Address, Description, Keywords FROM SSearch_Artist";



    $results = mysql_query ($query) or die (mysql_error());



    echo "<HTML>\n";

    echo "<HEAD>\n";

    echo "<TITLE>Results for $keyword</TITLE>\n";

    echo "</HEAD>\n";

    echo "<BODY BGCOLOR=\"#000000\" TEXT=\"$FFFFFF\" LINK=\"#66CCFF\" VLINK=\"#66CCFF\" ALINK=\"#66CCFF\">\n";

    echo "<FONT FACE=\"Verdana\" SIZE=\"2\">\n";

    echo "<H1>Search Result(s) for: query</H1>\n";



    while ($row = mysql_fetch_array ($results, MYSQL_ASSOC)) {

        echo "<A HREF=\"$row['address']\">$row['Name']</A> - $row['Description']<br />\n";



    }

    mysql_query("INSERT INTO SSearch_log (Date, Keyword, Choice) VALUES ($date, $keyword, $Choice);");



    mysql_free_result($results);

    mysql_close()



    echo "<BR><BR><CENTER>Metal Search<BR>\n";

    echo "$VER</CENTER>\n";



    echo "</BODY>\n";

    echo "</HTML>\n";

}

There is the first part rewritten into code that should work. You can use it for ideas on how to fix up the rest of the script.

Chris

darkcarnival · #9 (**permalink**) 07-18-03, 09:12 AM

ok thx dude. im alittle busy wokring my site new style now but i will get that added.i could also use help on my admin panel i dont know how to show different titles w/o using <title>

Damian · #10 (**permalink**) 07-18-03, 05:46 PM

look man don't give us attitude here... you don't expect someone to browse trough your crap and give him attitude. We're all friends...after all we're just trying to help you out ! cut the bullshit and if you want help, you can start by showing some respect !