viewedit-user.php ( File view )

  • By cox 2014-08-14
  • View(s):156
  • Download(s):9
  • Point(s): 2
			<?php
	include('includes/start.php');
	require_once('includes/header.html');
?>
<?php


$page_title = 'View Users';

require_once("../dbcon.php");   // Include the database class

$display = 10;
//------Search-----
echo "<body onLoad=\"self.focus();document.searchform.search.focus()\">";
echo "<center>";
echo "<br /><form name=\"searchform\" method=\"GET\" action=\"search-edituser.php\">";
echo "<input type=\"text\" name=\"search\" size=\"20\" TABINDEX=\"1\" />";
echo " <input type=\"submit\" value=\"Search\" />";
echo "</form>";
echo "</table>";
//-----End of Search------

//----------Paging result-----
if(isset($_GET['np'])){

$num_pages = $_GET['np'];

}else{

 $query = "SELECT COUNT(*) FROM users";
 $result = mysql_query($query);
 $row = mysql_fetch_array($result, MYSQL_NUM);
 $num_records = $row[0];
 
 if($num_records > $display){

 $num_pages = ceil($num_records/$display);
 
}else{

 $num_pages = 1;
 
}

}

if(isset($_GET['s'])){

   $start = $_GET['s'];
  
}else{

  $start=0;
  
}
   
//----------Sorting-----------	
$link1 = "{
$_SERVER['PHP_SELF']
}?sort=uid";
$link2 = "{
$_SERVER['PHP_SELF']
}?sort=eid";
$link3 = "{
$_SERVER['PHP_SELF']
}?sort=fna";
$link4 = "{
$_SERVER['PHP_SELF']
}?sort=lna";
$link5 = "{
$_SERVER['PHP_SELF']
}?sort=pswd";
$link6 = "{
$_SERVER['PHP_SELF']
}?sort=pos";
$link7 = "{
$_SERVER['PHP_SELF']
}?sort=unme";


if(isset($_GET['sort'])){

switch($_GET['sort']){

	case 'uid':
 		$order_by = 'uid ASC';
		$link1 = "{
$_SERVER['PHP_SELF']
}?sort=fuid";
		break;
	case 'fuid':
		$order_by = 'uid DESC';
		$link1 = "{
$_SERVER['PHP_SELF']
}?sort=uid";
		break;
	case 'eid':
 		$order_by = 'eid ASC';
		$link2 = "{
$_SERVER['PHP_SELF']
}?sort=leid";
		break;
	case 'leid':
 		$order_by = 'eid DESC';
		$link2 = "{
$_SERVER['PHP_SELF']
}?sort=eid";
		break;
	case 'fna':
 		$order_by = 'fname ASC';
		$link3 = "{
$_SERVER['PHP_SELF']
}?sort=lfna";
		break;
	case 'lfna':
		$order_by = 'fname DESC';
		$link3 = "{
$_SERVER['PHP_SELF']
}?sort=fna";
		break;
	case 'lna':
 		$order_by = 'lname ASC';
		$link4 = "{
$_SERVER['PHP_SELF']
}?sort=llna";
		break;
	case 'llna':
		$order_by = 'lname DESC';
		$link4 = "{
$_SERVER['PHP_SELF']
}?sort=lna";
		break;
	case 'pswd':
 		$order_by = 'pswd ASC';
		$link5 = "{
$_SERVER['PHP_SELF']
}?sort=lpswd";
		break;
	case 'lpswd':
		$order_by = 'pswd DESC';
		$link5 = "{
$_SERVER['PHP_SELF']
}?sort=pswd";
		break;
	case 'unme':
 		$order_by = 'unme ASC';
		$link6 = "{
$_SERVER['PHP_SELF']
}?sort=lunme";
		break;
	case 'lunme':
		$order_by = 'unme DESC';
		$link6 = "{
$_SERVER['PHP_SELF']
}?sort=unme";
		break;
	
	

}
$sort = $_GET['sort'];

}else{

$order_by = 'date_added ASC';
$sort = 'dad';

}
		    //----------Get List of Employees-----------           
$query = "SELECT * FROM users";
$result = @mysql_query($query);
$num = mysql_num_rows($result);
if($num > 0){

  echo "<p align='center'>There are $num employees entered in the system!</p>\n";

if($result){


echo '<table align="center" border="1" bgcolor="lightgreen">
<tr>
<td colspan="111" align="center"><b>Employees</td></tr>
<tr>
<td align="center"><b>User ID</a></b></td>
<td align="center"><b>Employee ID</a></b></td>
<td align="center"><b>User Name</a></b></td>
<td align="center"><b>First Name</a></b></td>
<td align="center"><b>Last Name</a></b></td>
<td align="center"><b>Position</a></b></td>

<td align="center"><b>Edit</b></td>
</tr>';

$bg = '#eeeeee';
while($row=mysql_fetch_array($result, MYSQL_ASSOC)){

$bg = ($bg == '#eeeeee' ? '#ffffff' : '#eeeeee');

echo '<tr bgcolor="'.$bg.'">
<td align="left">'.$row['userid'].'</td>
<td align="left">'.$row['eid'].'</td>
<td align="left">'.$row['username'].'</td>
<td align="left">'.$row['fname'].'</td>
<td align="left">'.$row['lname'].'</td>
<td align="left">'.$row['posid'].'</td>
<td align="left"><a href="edit-user.php?id='.$row['eid'].'"><img src="../images/edit.jpg" width="50" height="20"/></a></td>

</tr>';


}

echo '</table>';
//------------------End of Get list of Employees--------
mysql_free_result($result);

}else{

echo '<p class="error">There are currently no entered employees in the system!</p>';
/*echo '<p class="error">Data Can Not Be Retrieved!</p>';
echo '<p>'.mysql_error().'<br /><br />Query:'.$query.'</p>';*/

}
mysql_close();

//------End of Paging Result----


}

?>
<?php
echo "<br>";echo "<br>";
include('../includes/footer.html');
?>

			
...
Expand> <Close

Want complete source code? Download it here

Point(s): 2

Download
0 lines left, continue to read
Sponsored links

File list

Tips: You can preview the content of files by clicking file names^_^
Name Size Date
add-employee.php8.98 kB04-07-14 10:43
add-user.php3.26 kB04-07-14 10:27
approve.php157.00 B07-02-09 04:33
date-added.php496.00 B14-02-09 00:10
db-backup-1371292492-5cac8f65a378cc19b150279db357c567.sql3.23 kB15-06-13 06:34
db-backup-1371360757-5cac8f65a378cc19b150279db357c567.sql3.80 kB16-06-13 01:32
db-backup-1371377572-5cac8f65a378cc19b150279db357c567.sql4.88 kB16-06-13 06:12
db-backup-1402914697-5cac8f65a378cc19b150279db357c567.sql6.12 kB16-06-14 13:31
db_backup.php1.79 kB09-11-08 22:21
del-users.php2.39 kB09-02-09 14:49
delete-employee.php2.51 kB07-02-09 05:11
delete-users.php2.32 kB10-02-09 14:45
del_emp.php2.44 kB07-02-09 05:14
deny.php158.00 B07-02-09 04:33
edate.php499.00 B13-02-09 13:42
edit-user.php2.15 kB14-02-09 00:05
editemp-frm.php3.08 kB30-12-08 15:53
edit_emp.php5.08 kB29-11-08 23:07
emp-list.php6.30 kB04-02-09 14:35
emp-profile.php1.67 kB14-02-09 00:03
endate.php499.00 B13-02-09 13:44
fdate.php487.00 B12-02-09 13:24
footer.html104.00 B18-06-14 18:01
header.html5.94 kB18-06-14 15:10
start.php344.00 B16-12-08 05:35
dwsync.xml286.00 B18-06-14 18:01
index.php2.14 kB25-06-14 15:21
logout.php848.00 B18-06-14 17:45
main-index.php397.00 B16-06-14 13:26
month.php486.00 B11-02-09 07:10
month2.php499.00 B13-02-09 14:59
print-report.php1.17 kB11-02-09 07:07
print.php5.41 kB25-06-14 13:41
search-edit.php3.86 kB17-12-08 06:09
search-edituser.php3.86 kB17-12-08 06:11
search.php3.89 kB15-06-13 12:53
verify-editemp.php561.00 B09-02-09 08:09
verifyedit-user.php454.00 B09-02-09 14:35
view-leave.php3.06 kB17-06-13 04:32
viewedit-employee.php5.72 kB14-02-09 00:15
viewedit-user.php4.38 kB09-02-09 07:03
viewpending-leaves.php2.50 kB15-06-13 12:49
dwsync.xml860.00 B04-07-14 10:43
ccse.sql7.20 kB15-08-13 06:14
date.inc.php589.00 B07-11-08 17:12
dbcon.php467.00 B11-06-14 17:19
dapproved.php184.00 B27-02-09 02:11
ddeny.php191.00 B07-02-09 04:33
emp-profile.php1.66 kB14-02-09 00:02
footer.html104.00 B18-06-14 18:00
header.html6.01 kB18-06-14 17:50
start.php344.00 B08-09-08 13:34
dwsync.xml286.00 B18-06-14 18:00
logout.php848.00 B18-06-14 17:43
main-index.php403.00 B18-06-14 17:58
search.php3.96 kB16-06-13 00:26
view-leave.php1.98 kB16-06-13 01:29
viewpending-leaves.php2.50 kB16-06-13 00:28
dwsync.xml288.00 B18-06-14 17:58
fidfrm.php1.64 kB16-06-13 01:15
approval.jpg1.82 kB01-12-08 06:42
approved.jpg1.87 kB01-12-08 06:40
back.gif7.49 kB15-10-08 20:36
Brain_Mill_Logo_1b-1.gif8.41 kB16-02-09 13:23
cancel.gif2.49 kB11-02-09 00:45
delete.jpg1.61 kB01-12-08 06:43
disapproval.jpg1.99 kB01-12-08 06:42
disapproved.jpg2.07 kB01-12-08 06:42
edit.jpg1.35 kB30-11-08 00:37
exthome.png79.83 kB16-02-09 12:16
login.gif208.73 kB08-02-09 07:34
logo.png106.01 kB16-06-14 13:23
nzoia.jpg425.23 kB15-06-13 15:31
print2.gif2.50 kB31-12-08 03:14
resume.gif3.03 kB30-12-08 15:26
top.gif13.75 kB16-06-14 13:36
view.gif2.52 kB20-12-08 00:06
top.gif.mno113.00 B16-06-14 13:36
footer.html104.00 B16-06-14 12:39
header.html5.76 kB18-06-14 17:51
start.php344.00 B08-09-08 13:34
dwsync.xml286.00 B18-06-14 17:51
index.php2.17 kB19-06-14 10:24
leave.php8.69 kB30-07-14 17:17
logout.php842.00 B18-06-14 17:27
main-index.php380.00 B18-06-14 18:07
mysql_connect.php645.00 B07-11-08 03:55
<NSC>0.00 BSystem.ppt 1940992
Reminder.txt192.00 B12-05-09 07:22
Resume.doc35.50 kB18-06-13 00:14
search.php3.50 kB16-06-13 01:21
setid.php1.31 kB21-02-09 08:21
view-availableleave.php1.41 kB07-02-09 04:59
view-leave.php1.67 kB20-02-09 15:51
viewpending-leaves.php2.19 kB16-06-13 01:17
dwsync.xml621.00 B30-07-14 17:17
<_notes>0.00 B09-08-14 11:29
<_notes>0.00 B09-08-14 11:29
<includes>0.00 B09-08-14 11:29
<New>0.00 B0% 15-06-13
<_notes>0.00 B09-08-14 11:29
<includes>0.00 B09-08-14 11:29
<_notes>0.00 B09-08-14 11:29
<_notes>0.00 B09-08-14 11:29
<_notes>0.00 B09-08-14 11:29
<admin>0.00 B09-08-14 11:29
<database>0.00 B09-08-14 11:29
<director>0.00 B09-08-14 11:29
<images>0.00 B09-08-14 11:29
<includes>0.00 B09-08-14 11:29
<presentation>0.00 B09-08-14 11:29
<resume>0.00 B09-08-14 11:29
<sick-leave>0.00 B28-04-09 00:20
<_notes>0.00 B09-08-14 11:29
<OnlineLeaveSystem>0.00 B09-08-14 11:29
...
Sponsored links

viewedit-user.php (931.49 kB)

Need 2 point
Your Point(s)

Your Point isn't enough.

Get point immediately by PayPal

More(Debit card / Credit card / PayPal Credit / Online Banking)

Submit your source codes. Get more point

LOGIN

Don't have an account? Register now
Need any help?
Mail to: support@codeforge.com

切换到中文版?

CodeForge Chinese Version
CodeForge English Version

Where are you going?

^_^"Oops ...

Sorry!This guy is mysterious, its blog hasn't been opened, try another, please!
OK

Warm tip!

CodeForge to FavoriteFavorite by Ctrl+D