Gegevens uit database hallen

Jan Koehoorn schreef op 02.08.2007 22:11

Het script dat je gebruikt, heb je dat helemaal zelf gemaakt?

Ja hoezo?

Ps. ik denk dat het in orde is ...

Ik heb male en de date tussen ' ' gezet ...
en ik krijg toch al enige output ...

EDIT: Het is in orde!

Thx to you all

Als de oplossing ook nog even op het forum zet, dan is de cirkel rond.

Dit is een oplossing ...
Mr nog niet volledig waterdicht ...
Ik ga er nog een functie opzetten dat die bepaald welk de eerste en welk de laatste datum is ...

want als age1 bevoorbeeld 50 is en age 2 bevoorbeeld 20 is ...

Dan zal er geen match gevonden worden ...

Toch alvast het script ... (ps. dit is uitgebreid met een weergave voor het aantal matches ...)

<?

$matches_found = 0;

include("config.php");

function age($birthDate) {
    list($year, $month, $day) = explode('-', $birthDate);
    $ageOfPerson = date('Y') - $year;
    if ($month > date('m')) {
        $ageOfPerson--;
    }
    if ($month == date('m') && $day > date('d')) {
        $ageOfPerson--;
    }
    $ageOfPerson .= ' ';
    return $ageOfPerson;
}

if ($_SERVER['REQUEST_METHOD'] == "POST")
{
	extract($_POST); //alle post variabelen ophalen
	  if ($gender == '')
	    {
		echo('Select a gender please!');
		}
		else
		{
		  if ($age1 == '')
		    {
			echo('Enter a starting age please!');
			}
			else
			{
			  if ($age2 == '')
			    {
				echo('Enter a ending age please!');
				}
				else
				{
				
			$year1 = date("Y") - $age1;
			$date1 = "'" . $year1 . "-" . date("m") . "-" . date("d") . "'";
			$year2 = date("Y") - $age2;
			$date2 = "'" . $year2 . "-" . date("m") . "-" . date("d") . "'";
			$gender1 = "'" . $gender . "'";
					  
					  
					  
	$sql = "
       SELECT 
        user_id,
        user_name,
        user_dateofbirth,
        user_gender
       FROM
        tbl_users
       WHERE
        user_dateofbirth BETWEEN $date2 AND $date1
       AND
         user_gender = $gender1
       ";

        if (!$res = mysql_query ($sql)) 
	      {
          echo '<pre>';
          trigger_error (mysql_errno() . ': ' . mysql_error());
          echo $sql;
          echo '</pre>';
         }
		 
		 elseif(mysql_num_rows($res) < 1)
      {
		    
      }
		  
         else 
   
         {
         while($row = mysql_fetch_assoc($res))
         {
        $matches_found = $matches_found + 1;
         }
         }



							
echo '<b>' . $matches_found . ' </b> matches found.<br><br>';

       $sql = "
       SELECT 
        user_id,
        user_name,
        user_dateofbirth,
        user_gender
       FROM
        tbl_users
       WHERE
        user_dateofbirth BETWEEN $date2 AND $date1
       AND
         user_gender = $gender1
       ";

        if (!$res = mysql_query ($sql)) 
	      {
          echo '<pre>';
          trigger_error (mysql_errno() . ': ' . mysql_error());
          echo $sql;
          echo '</pre>';
         }
		 
		 elseif(mysql_num_rows($res) < 1)
      {
	  
	  echo "<br><a href=\"matching.php\">Click here to search an other match</a>";
		
      }
		  
         else 
   
         {
         while($row = mysql_fetch_assoc($res))
         {
         echo '<a href="profile.php?act=view&user_id='.$row['user_id'].'"><font face="Verdana" style="font-size: 11pt" color="#000000">Username: '.$row['user_name'].' ';
         echo '<a href="profile.php?act=view&user_id='.$row['user_id'].'"><font face="Verdana" style="font-size: 11pt" color="#000000">(';
		 $geboorteDatum = $row['user_dateofbirth'];
		 echo age($geboorteDatum);
         echo '<a href="profile.php?act=view&user_id='.$row['user_id'].'"><font face="Verdana" style="font-size: 11pt" color="#000000">'.$row['user_gender'].')<br>';
		 echo '<a href="profile.php?act=view&user_id='.$row['user_id'].'"><font face="Verdana" style="font-size: 11pt" color="#000000">Click Here to vieuw the profile!<br><br>';
         }
         }

   	  }					      

						      }
							}
							



                                }
                                else
                                {
                                ?>
<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post" name="frm" onSubmit="return checkEmail(this)" enctype="multipart/form-data">
<table width="575" height="113">
  <tr>
    <td height="25"><font face="Verdana" style="font-size: 11pt">Search for a: </font></td>
    <td height="19">&nbsp;</td>
  </tr>
  <tr>
    <td height="25"><p>&nbsp;</p>      </td>
    <td height="19"><select name="gender" size="1" id="gender">
      <option value="male">Male</option>
      <option value="female">Female</option>
            </select>
      <font face="Verdana" style="font-size: 11pt"> (Gender)</font></td>
  </tr>
<tr>
	<td width="172" height="25">
      <div align="right"><font face="Verdana" style="font-size: 11pt">Between:</font></div></td>
	<td width="391" height="19"><font color="#FFFFFF">
	  <input type="DATE" name="age1" id="type0" size="7"> 
</font><font face="Verdana" style="font-size: 11pt">and </font>	<font color="#FFFFFF">
<input type="DATE" name="age2" id="bedrijf" size="7">
</font><font face="Verdana" style="font-size: 11pt">(Age)</font></td>
</tr>
<tr>
	<td width="172" height="26">&nbsp;</td>
	<td width="391" height="26"><font color="#FFFFFF">
	  <input type="submit" name="submit" value="Search"></font></td>
</tr>
</table>
</form>
                                <?
                                }
								echo "<br><a href=\"index.php\">Main Page</a>";
                                ?>