isEmpty, Empty or ==&quot;&quot; ????

isEmpty, Empty or =="" ????

AlGale

Hi, very simple one I think (and yet I can`t get it)!

I have a search query which works well, but on initially opening the page the search term is of course "", i.e. blank. This means my whole database is being pulled through onto the page the first time it is referenced.

How do I check that if $Search =="" then do nothing,

or, better still, if $Search <>"" do the search?

Many thanks.

:rolleyes:

khattak

you can use javascript with the html, or php page, i.e. when the submit button is clicked, it will check the field whether it is empty or not, if it is then it will prompt an error, the code is omething like this:

<html>
<head><title>Checking</title>
<SCRIPT LANGUAGE="JavaScript">

<!-- Begin
function noEntry() {
mt1=document.thisForm.txt1.value;
if (mt1.length<1) {
alert("Name Field is Required!");
return false;

document.thisForm.empty.focus();
}

return true;
}
// End -->
</SCRIPT>
</head>
<body>
<form name=thisForm method=post action=search.php>
Search: : <input type=text name=txt1><p>
<input type=submit value=Invite onClick="return noEntry()">
</form>
</font>
</body>
</html>

that is the php page will only be called only if there is some value in the field.

kucukadam

if $Search ==""

i know thats working..

AlGale

Hi. Thanks for the rely.

The submission part of the form works fine. It`s just when the page is first loaded, obviously there is nothing in the serach term, so $Search = ""

I have tried:

if ($Search <> "")
{
exectute code
}

Clearly if this is the case I do not want to execute my MySQL query, as otherwise I pull in over 3200 entries! But this is giving me parse errors. I am therefore guessing I need to use either NUL, isEmpty or empty. Or something else I am not aware about.

AlGale

Don`t worry about it - found the problem. Common one - left off a ;

Thanks anyway

KoshNaranek

instead of if($string=='') you can use if (!$string)

keith73

Originally posted by AlGale
Hi, very simple one I think (and yet I can`t get it)!

I have a search query which works well, but on initially opening the page the search term is of course "", i.e. blank. This means my whole database is being pulled through onto the page the first time it is referenced.

How do I check that if $Search =="" then do nothing,

or, better still, if $Search <>"" do the search?

Many thanks.

:rolleyes:

you can use:

if(isset($String)){
 //execute search queries here
}

OR
if the form is submitted and you want to make sure something was entered:

if(strlen(trim($String)) > 0){
 //execute search queries here
}

this ensures that if someone can't just hit the space bar in the input field and also saves you from executing a needless query.

keith