I was handed a solution by a

mmi — Fri, 05 Sep 2008 02:13:59 +0000

I was handed a solution by a colleague:

add $ingredient = $_REQUEST['ingredient'];

WORKS!

Hey Like a voice (hopefully

mmi — Thu, 04 Sep 2008 04:26:54 +0000

Hey

Like a voice (hopefully not too nightmarish) from the somewhat distant past, I've returned to yer friendly community in an effort to get the little search engine on mmy recipe page working again. It stopped working a few years ago when I moved the code to a different server. Yesterday, I again tried changing the username — and it worked!

Well, I got a result at least. The problem is: the code designed to cause a subset of the recipes to be returned (those with an ingredient matching the string entered in the textbox) isn't functioning. You instead get all the recipes held in the db (currently only about fifteen or so that I've entered for testing).

Here's the search page. Here's the code for results.php

<html><head><title>CMW Search Results for <? echo $ingredient ?></title>

<SCRIPT LANGUAGE=javascript TYPE="text/javascript">

function openCmwWindow(){
    cmwWindow=window.open('','cmwWin','menubar=yes,status=yes,scrollbars=no,resizable=yes,width=740,height=420');}

</script>

<STYLE TYPE="text/css"><!--

BODY {font: 10pt Tahoma; color: #fffff0}
SPAN {font: 500 13pt Tahoma; color: #f4c508}
A {font: 600 14pt Tahoma; color:orange; text-decoration:none}

--></style>

</head>

<body bgcolor="#000080" text="#000000" id=all>

<div width="95%" align="right"><a href="http://ememi.com/cmw/realindex.html">another<br>search </a></div>

<?

$db = mysql_connect("localhost", "username","password");

mysql_select_db("mmi_ememicom",$db);

$query = "SELECT * FROM RECIPES WHERE (ing1 LIKE '%$ingredient%') OR (ing2 LIKE '%$ingredient%') OR (ing3 LIKE '%$ingredient%')";

$query .= " AND (ing1 IS NOT NULL) AND (ing2 IS NOT NULL) AND (ing3 IS NOT NULL)";

if (mysql_errno()) { echo mysql_error(); }

$result = mysql_query($query,$db);

if (mysql_num_rows($result) == 0) {

?> <SPAN> <? echo "Sorry, no recipes for that - try another ingredient"; ?> </span>

<?

}

while ($recipe = mysql_fetch_array($result)) {

?>

<a href="<? echo $recipe[href]; ?>" target="cmwWin"><? echo $recipe[recipe]; ?></a>

<a href="<? echo $recipe[href]; ?>" target="cmwWin"><span><? echo $recipe[recipes]; ?></span></a><br><br>

<?

}  #END while

?>

</body></html>

Anything jump out as a reason for all recipes being returned?

Thanks!

Mark Hensler — Sat, 10 Feb 2001 07:53:37 +0000

looking good

Couldn't have Made it Without your help

mmi — Thu, 08 Feb 2001 15:48:36 +0000

thanks as always for the useful info - my understanding is that ASPs can only run on Windows NT servers and since my provider has those "no longer patchy" ones, I figger I can't do 'em - I kinda expected that there wasn't gonna be a way around the limitations of these wildcards but at least now I KNOW that's the case and I can express an intelligent opinion about an alternative - you really helped me out on this to say the least and I very much appreciate it - CMW is Cooking My Way - ya might wanna check out the navbar's index !!

Mark Hensler — Thu, 08 Feb 2001 07:47:58 +0000

I'm not sure what you want to do. What do you want "pa" to return? nothing?

you can do a strict search by taking out the wildcards. So "pa" will not return anything, and "salt" will only match "salt" and not "saltines".

If you want you could get even wilder, and allow the user to choose 'partial word' matches, 'exact phrases', or 'any word'.

Example... search criteria: "apple pie"
Partial word would break up the spaces and search for anything with "apple" or "pie" in it. This could return "apple", "pie", "apple pie", and "pineapple".
Exact phrase would search for just that... the exact phrase. and return only "apple pie".
Any word would split the spaces and search for "apple" or "pie". And return "apple", and "pie". But not "pineapple"

If you want a search that powerful, it will require a bit of ASP coding. So make a new post in the 'Other Scripting Languages Help Forums'.

I'm drawing a blank... what's CMW?

EXCELLENT !!

mmi — Tue, 06 Feb 2001 17:22:07 +0000

this is great!! HOWEVER , how should I try to handle the lollowing? - if ya type in, say, "parsnip", I get the response I want - but is there any way to better manage an entry like "pa"? - right now I get Lasagna cuz it's got pasta and a chicken dish that features paprika - is a return like this the price I MUST pay for using the wildcards or is there a way to limit things and get a more "reasoned" response? btw, I suppose I'll be at least morally obligated to credit your contribution to CMW - or would that be an honor of dubious distinction?
----------
guess I'll hafta dig out my Oracle / SQL books :eek:

yeah, blah [code] blah

mmi — Tue, 06 Feb 2001 07:40:26 +0000

thanks a lot - I'll see what I can make 'a that mess after my nightly nap - Produce Theater Productions is apparently gettin' struck by the Teamsters at the moment - just wonderin', you got any ideas on how to get my flippin' apple integrated into this? - I've been advised to move it from the "search" page to the "results" page? - does that seem more workable to you?

Mark Hensler — Tue, 06 Feb 2001 06:32:38 +0000

Make this change to the query string....

// old
$query = "SELECT * FROM RECIPES WHERE (ing1 LIKE '%$ingrediant%') OR (ing2 LIKE '%$ingrediant%') OR (ing3 LIKE '%$ingrediant%')";

// new
$query = "SELECT * FROM RECIPES WHERE (ing1 LIKE '%$ingrediant%') OR (ing2 LIKE '%$ingrediant%') OR (ing3 LIKE '%$ingrediant%')";
$query .= " AND (ing1 IS NOT NULL) AND (ing2 IS NOT NULL) AND (ing31 IS NOT NULL)";

'
then, check to see if you have any results....

if (mysql_num_rows($result) == 0) {
  // "Sorry nuthin' on that"
}

while ($recipe = mysql_fetch_array($result) {
  // if there are no rows returned, this part will never be used
  //  so don't bother putting this in an IF statement

  // blah (do your loop thing here) blah
}

default link, like a "friendly 404"

mmi — Tue, 06 Feb 2001 01:29:35 +0000

well, here's one - how would I direct viewers to a page that says "sorry, nuthin' on that"? -I'm wonderin' if this is gonna be complicated by the use of LIKE - I know a little about db's and SQL and I'm guessing that working out the final details on this may get complicated - thanks
---------
do I wanna test to see if the return on ingredient is null and then print a string? - is this something to be handled in SQL, PHP, js? - easily apparently

[Edited by mmi on Feb. 06, 2001 at 12:58 AM]

ALMOST THERE!!

mmi — Sat, 03 Feb 2001 07:55:48 +0000

go to Cooking My Way

click on "index" in the navbar

type in an accepted keyword, e.g., cheese

voilà!!

just need to set up a timeout to let the apple spin for a couple 'a seconds - I'm kinda concerned though cuz when I try to put the code back the way it was the movie displays but it's static