[RESOLVED] Query on values passed in

[kemnet]

Hello.
Im trying to implement the following into my program but im a little stuck.
Imagine each student has a name and an birthdate

-you can do the search using the student's name AND birthdate
or just the student's name

this is my code(that deals with that section of course

if (isset($_POST["f_name"])&& isset($_POST["birth_d"])) { 


   $f_name=$_POST["f_name"];
   $birth_d=$_POST["birth_d"];

	 $stmt = $this->db->prepare('SELECT id,expires,book, FROM student WHERE f_name=? AND birth_d=?');

       $stmt->bind_param("si", $f_name,$birth_d);

    $stmt->execute();
    $stmt->bind_result($id,$expires,$book);

Thanks

[johanafm]

And the question is?

[kemnet]

oh sorry!
how do i write it so i can do a search using the name AND the birthdate or just the name

[johanafm]

Change from isset to !empty(), and continue checking for what has been specified.

if (!empty($_POST["f_name"]) && !empty($_POST["birth_d"])) { 
	# as before
}
elseif(!empty($_POST["f_name"]))
{
	# search on name only
}
elseif(!empty($_POST["birt_d"]))
{
	# search on date only
}

[kemnet]

Perfect! thank