[go: up one dir, main page]
Menu ▾ ▴

[r20]: / patientsTable.php  Maximize  Restore  History

Download this file

66 lines (59 with data), 2.7 kB 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
<?php 

include('includes/databaseLogin.php'); 

include('includes/installedLanguage.php'); 

echo "<!DOCTYPE html>";

?>



<html>

<head>

    <link rel="stylesheet" href="css/style.css" />

</head>



<body>

<?php

	if(isset($_POST[sCode])){

		echo "<table width=\"100%\" style=\"font-size:0.8em;\">";

		echo "	<tr>";

		echo "		<td width=\"14%\"><b>" . _T("Name")	. "</td>";

		echo "		<td width=\"14%\"><b>" . _T("Owner")	. "</td>";

		echo "		<td width=\"14%\"><b>" . _T("Species")	. "</td>";

		echo "		<td width=\"14%\"><b>" . _T("Breed")	. "</td>";

		echo "		<td width=\"14%\"><b>" . _T("Birthday")	. "</td>";

		echo "		<td width=\"14%\"><b>" . _T("Age")	. "</td>";

		echo "		<td width=\"14%\"><b>" . _T("Sex")	. "</td>";

		echo "	<tr>";

	

		$pName		= addslashes($_POST[pName]);

		$pLooks		= addslashes($_POST[pLooks]);

		$pType		= addslashes($_POST[pType]);

		$ctrlBDYear	= addslashes($_POST[pBYear]);

		$ctrlAgeYear	= addslashes($_POST[pAge]);

		$ctrlsrc	= addslashes($_POST[pSearchOpt]);

		if($ctrlBDYear == ''){$ctrlBDYear = '-';}

		if($ctrlAgeYear == ''){$ctrlAgeYear = '-';}



		$getPatients = mysql_query("SELECT * FROM patients WHERE petName REGEXP '^$pName' AND petLooks REGEXP '^$pLooks' AND petType REGEXP '^$pType' ORDER BY petName");

		while($row = mysql_fetch_array($getPatients)) {

			//Calcolo l'età dell'animale

			$today = mktime(0,0,0,date("m"),date("d"),date("Y"));

			$birthDayParts=split("/",$row[petBirthdate]);

			$birthday = mktime(0,0,0,$birthDayParts[1],$birthdayDayParts[0],$birthDayParts[2]);

			$ageYear = date("Y",$today-$birthday) - 1970;

			if(($ctrlBDYear == '-') || ($ctrlBDYear == $birthDayParts[2])){

				if(($ctrlAgeYear == '-') || (($ctrlAgeYear == $ageYear) && ($ctrlsrc == '2')) || (($ageYear >= $ctrlAgeYear) && ($ctrlsrc == '0')) || (($ageYear <= $ctrlAgeYear) && ($ctrlsrc == '1'))){

					echo "<tr>";

					echo "<td><a class=\"aPetName\" name=\"" . $row[petID] . "\" href=\"#\">" . $row[petName] . "</a></td>";

					$getClients = mysql_query("SELECT * FROM clients WHERE clients.clientID='$row[petOwner]'");

					while($row2 = mysql_fetch_array($getClients)) {

						echo "<td><a class=\"aClientNominative\" name=\"" . $row2[clientID] . "\" href=\"#\">" . $row2[clientName] . " " . $row2[clientSurname] . "</a></td>";

					}

						

					echo "<td>" . $row[petType] . "</td>";

					echo "<td>" . $row[petLooks] . "</td>";

					echo "<td>" . $row[petBirthdate] . "</td>";

					echo "<td>" . $ageYear . " anno/i</td>";

					echo "<td>" . _T("$row[petGender]") . "(" . _T("$row[petDesexed]") .")</td>";

					echo "</tr>";

				}	

			}

		}

		echo "</table>";

	}

?>

</body>

</html>