-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsearchemp.php
73 lines (62 loc) · 4.93 KB
/
searchemp.php
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
<?php
session_start();
$conn = mysql_connect("localhost","root","123123") or die(mysql_error());
mysql_select_db("APOLLO",$conn) or die(mysql_error());
if(empty($_GET)){
$store = $_SESSION['store'];
$query = "Select * from EMPLOYEE where store_id='$store'";
$results = mysql_query($query);
if(!$results)
{
die('Could not enter data: ' . mysql_error());
}
while($row = mysql_fetch_array($results))
{
echo "<div id='".$row['user_name']."' style='box-shadow: 1px 2px 2px 1px #888888;width:77em;background-color:#f0f0f0;margin-left:2em;height:32em;padding-right:20em;padding-top:2em'>";
echo "<input type='submit' class='btn btn-default' value='Delete' style='float:right;margin-right:-19em' onclick=deleteemp('".$row['user_name']."')>";
echo "<a href='editemp.php?employee_id=".$row['employee_id']."'><span class='glyphicon glyphicon-pencil' style='float:right;margin-right:-13em;margin-top:0.5em' >Edit</span></a>";
echo "<img src='imageView.php?image_id=" .$row['employee_id']. "' style='width:14em;height:15em;float:left;margin-top:-0.5em'/>";
echo "<table class='table table-hover' style='width:40em;float:right;margin-left:70em;margin-top:-17em; list-style-type: none'><tr><td colspan='2'><b style='color:#0000ff'>User Name:</b></td><td>".$row['user_name']."</td></tr>";
echo "<tr><td colspan='2'><b style='color:#0000ff'>First Name:   </b></td><td>".$row['first_name']."</td></tr>";
echo "<tr><td colspan='2'><b style='color:#0000ff'>Last Name:   </b></td><td>".$row['last_name']."</td></tr>";
echo "<tr><td colspan='2'><b style='color:#0000ff'>Date of Birth:   </b></td><td>".$row['dob']."</td></tr>";
echo "<tr><td colspan='2'><b style='color:#0000ff'>Sex:   </b></td><td>".$row['sex']."</td></tr>";
echo "<tr><td colspan='2'><b style='color:#0000ff'>Date Of Joining:   </b></td><td>".$row['date_of_joining']."</td></tr>";
echo "<tr><td colspan='2'><b style='color:#0000ff'>Address:   </b></td><td>".$row['address']."</td></tr>";
echo "<tr><td colspan='2'><b style='color:#0000ff'>Salary:   </b></td><td>".$row['salary']."</td></tr>";
echo "<tr><td colspan='2'><b style='color:#0000ff'>Employee Type:   </b></td><td>".$row['employee_type']."</td></tr>";
echo "<tr><td colspan='2'><b style='color:#0000ff'>Phone No:   </b></td><td>".$row['phone_no']."</td></tr>";
echo "<tr><td colspan='2'><b style='color:#0000ff'>Qualification:   </b></td><td>".$row['qualification']."</td></tr></table>";
echo "</div><br>";
}
}
else{
$name = $_GET['name'];
$query = "select * from EMPLOYEE where user_name LIKE '%$name%' or first_name LIKE '%$name%' or last_name LIKE '%$name%' and store_id=$store;";
$results = mysql_query($query,$conn);
if(!$results)
{
die('Could not enter data: ' . mysql_error());
}
while($row = mysql_fetch_array($results))
{
echo "<div id='".$row['user_name']."' style='box-shadow: 1px 2px 2px 1px #888888;width:60em;background-color:#f0f0f0;margin-left:10em;height:20em;padding-right:20em;padding-top:2em'>";
echo "<input type='submit' class='btn btn-default' value='Delete' style='float:right;margin-right:-19em' onclick=deleteemp('".$row['user_name']."')>";
echo "<img src='imageView.php?image_id=" .$row['employee_id']. "' style='width:12em;height:15em;float:left;margin-top:-0.5em'/>";
echo "<ul style='margin-left:25em;float:right;margin-left:-70em; list-style-type: none'><li><b style='color:#0000ff'>User Name:           </b>".$row['user_name']."<li>";
echo "<li><b style='color:#0000ff'>First Name:           </b>".$row['first_name']."</li>";
echo "<li><b style='color:#0000ff'>Last Name:           </b>".$row['last_name']."</li>";
echo "<li><b style='color:#0000ff'>Date of Birth:       </b>".$row['dob']."</li>";
echo "<li><b style='color:#0000ff'>Sex:                       </b>".$row['sex']."</li>";
echo "<li><b style='color:#0000ff'>Date of Joining:   </b>".$row['date_of_joining']."</li>";
echo "<li><b style='color:#0000ff'>Address:               </b>".$row['address']."</li>";
echo "<li><b style='color:#0000ff'>Salary:                   </b>".$row['salary']."</li>";
echo "<li><b style='color:#0000ff'>Employee Type:   </b>".$row['employee_type']."</li>";
echo "<li><b style='color:#0000ff'>Phone No:            </b>".$row['phone_no']."</li>";
echo "<li><b style='color:#0000ff'>Qualification:       </b>".$row['qualification']."</li></ul>";
echo "</div><br>";
}
}
echo "</table>";
mysql_close($conn);
?>