clinico/getdata.php at master · amritsarstartups/clinico · GitHub

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
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
<?php
include "connection.php";
$sym = $_REQUEST['s'];
$string = $sym;
$array11 = explode(',', $string);
$leng = count($array11);

	$stack = array();

for($i=0;$i<$leng;$i++)
{
//	echo $array[$i];


	$select = "select symptomid from symptoms where symptom='$array11[$i]'";
	$res = mysqli_query($conn, $select);


	while ($res1=mysqli_fetch_array($res)){


		$select1 = "select diseaseid from symptoms where symptomid='$res1[0]'";

		$res1 = mysqli_query($conn,$select1);

		while($res2=mysqli_fetch_array($res1)){

			$select2 = "select diseasename from diseases where diseaseid='$res2[0]'";

			$res3 = mysqli_query($conn,$select2);
			while($res4 = mysqli_fetch_array($res3)){

			array_push($stack,"$res4[0]");

			}

		}

}


}
$stack1 = array_unique($stack);
$stack1 = array_values($stack1);
sort($stack1);
//print_r($stack1);

//	$res1=mysqli_fetch_array($res);
//	$res2=array_unique($res1);
//
//	while($res3 = $res2)
//	{
//		$select1 = "select diseaseid from symptoms where symptomid='$res3'";
//		$res5=mysqli_query($conn,$select1);
//		while($res6=mysqli_fetch_array($res5)){
//			echo $res6[0];
//		}
//	}


?>
<br>
<h2 class="text-center">List of Possible Diseases</h2><br>
    <table class="table table-bordered"  >
		<thead>
		<tr>
			<th class="text-center">Sr. No.</th>
			<th class="text-center">Disease Name</th>
			<th class="text-center">Symptoms</th>
		</tr>
		</thead>

		<?php
        $count = 0;
        $less=count($stack1);
		$stackss = array();
        for($j=0;$j<$less;$j++)
		{
			?>
			<tr>
				<?php
			$c = "select DISTINCT diseaseid from diseases where diseasename='$stack1[$j]'";
			//echo $c;
			$c_res = mysqli_query($conn, $c);
			while($ccc = mysqli_fetch_array($c_res))
			{
?>


			<td><?php echo ++$count ?></td>
		<td><?php echo $stack1[ $j ] ?></td>
				<?php
				$ss = "select DISTINCT symptom from symptoms where diseaseid=$ccc[0]";
//				echo $ss;
				$cc = mysqli_query($conn, $ss);
				while($cc1 = mysqli_fetch_array($cc))
				{

					$cc2 = $cc2 . ' | ' .$cc1[0];


				}
				$cc2 = $cc2 . ' | ';?>
					<td><?php echo $cc2?>	<?php $cc2 = ''?>	</td>
<?php
				}?>
		</tr>
		<?php
		}
//		$stack1ss = array_unique($stackss);
//		$stack1ss = array_values($stack1ss);
//		sort($stack1ss);
//		print_r($stackss);
		?>
	</table>
<div class="form-group">
	<input id="consult" value="Consult Doctor" class="btn btn-success center-block" onclick="appoint()">
</div>