php-website/search.php at master · harinath001/php-website · 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
<?php

if(isset($_POST['id']))
{
	$id=$_POST['id'];
	$search=$_POST['search'];
	if($search != "")
{


	require("connect.php");
	mysql_select_db("winter");
	$extract=mysql_query("SELECT * FROM table2 WHERE id=$id");
	$row=mysql_fetch_assoc($extract);
	 $branch=$row['branch'];

	$extract=mysql_query("SELECT * FROM table2 WHERE id != '$id' AND branch='$branch'");
	$k=0;

	while($row=mysql_fetch_assoc($extract))
	{

	    $flag=1;
		$description=$row['description'];
		$research =$row['research'];
		$id1=$row['id'];
		$split1=explode(" ",$description);
		// echo $split1;
		$i=0;
		if(sizeof($split1)>0)
		{
		    $size=sizeof($split1);
			while($i<$size)
		{
			if($search==$split1[$i] || $search==strtoupper($split1[$i]) || $search==strtolower($split1[$i]))
			{
			    $k++;
				$flag=0;
				echo "<h1>YOUR KEY WORD WAS FOUND IN THE DESCRIPTION OF A PERSON IN YOUR BRANCH LIKE THIS:</h1><br /> <br /> <br /> /";
				echo "$description<br /> <br />";

				echo "<a href=\"show.php?id1=$id1 & id2=$id\">SHOW DETAILS</a><br />";
			}

			    $i++;


		}
		}


		if($research != "NO NEED TO DESSCRIBE" && $flag==1)
		{
			$split1=explode(" ",$research);
			$i=0;
			if(sizeof($split1)>0)
			{


				$size=sizeof($split1);
				while($i<$size)
	      	{
			if($search==$split1[$i] || $search==strtoupper($split1[$i]) || $search==strtolower($split1[$i]))
		     	{
				$k++;
				echo "<h1>YOUR KEY WORD WAS FOUND IN THE DESCRIPTION OF A PERSON'S RESEARCH PAPERS IN YOUR BRANCH LIKE THIS:</h1><br />";
				$len=sizeof($research);

			   $research2= str_replace($split1[$i],"$split1[$i]",$research);
				echo "$research2<br /> <br />";

				echo "<a href=\"show.php?id1=$id1 & id2=$id\">SHOW DETAILS</a><br />";
			    }
			$i++;
		     }


			}

		}


	}
	if($k==0)
{
	echo "NO PERSON MENTIONED THIS KEY WORD IN HIS RECORDS <br />";
}

}
else
{
	echo "PLEASE ENTER A VALID WORD TO SEARCH <br />";
}
}


else
{
	echo "PLEASE LOGIN";
	require("login.php");

}


?>