<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<script language="JavaScript" type="text/javascript" src="js/jquery.js"></script>
<script language="JavaScript" type="text/javascript" src="jTPS.js"></script>
<link rel="stylesheet" type="text/css" href="jTPS.css">
<script type='text/javascript' src='js/jquery.js'></script>
<script type='text/javascript' src='js/jquery.simplemodal.js'></script>
<script type='text/javascript' src='js/osx.js'></script>
<script>
$(document).ready(function () {
$('#demoTable').jTPS( {perPages:[5,12,15,50,'ALL'],scrollStep:1,scrollDelay:30,
clickCallback:function () {
// target table selector
var table = '#demoTable';
// store pagination + sort in cookie
document.cookie = 'jTPS=sortasc:' + $(table + ' .sortableHeader').index($(table + ' .sortAsc')) + ',' +
'sortdesc:' + $(table + ' .sortableHeader').index($(table + ' .sortDesc')) + ',' +
'page:' + $(table + ' .pageSelector').index($(table + ' .hilightPageSelector')) + ';';
}
});
// reinstate sort and pagination if cookie exists
var cookies = document.cookie.split(';');
for (var ci = 0, cie = cookies.length; ci < cie; ci++) {
var cookie = cookies[ci].split('=');
if (cookie[0] == 'jTPS') {
var commands = cookie[1].split(',');
for (var cm = 0, cme = commands.length; cm < cme; cm++) {
var command = commands[cm].split(':');
if (command[0] == 'sortasc' && parseInt(command[1]) >= 0) {
$('#demoTable .sortableHeader:eq(' + parseInt(command[1]) + ')').click();
} else if (command[0] == 'sortdesc' && parseInt(command[1]) >= 0) {
$('#demoTable .sortableHeader:eq(' + parseInt(command[1]) + ')').click().click();
} else if (command[0] == 'page' && parseInt(command[1]) >= 0) {
$('#demoTable .pageSelector:eq(' + parseInt(command[1]) + ')').click();
}
}
}
}
// bind mouseover for each tbody row and change cell (td) hover style
$('#demoTable tbody tr:not(.stubCell)').bind('mouseover mouseout',
function (e) {
// hilight the row
e.type == 'mouseover' ? $(this).children('td').addClass('hilightRow') : $(this).children('td').removeClass('hilightRow');
}
);
});
</script>
<style>
body {
font-family: Tahoma;
font-size: 9pt;
}
#demoTable thead th {
white-space: nowrap;
overflow-x:hidden;
padding: 3px;
}
#demoTable tbody td {
padding: 3px;
}
</style>
</head>
<body>
<table id="demoTable" style="border: 1px solid #ccc;" cellspacing="0" width="700">
<thead>
<tr>
<th sort="index">User ID</th>
<th sort="date">User Name</th>
<th sort="description">User Password</th>
<th sort="description">First Name</th>
<th sort="description">Last Name</th>
<th sort="description">Artist Name</th>
<th sort="description">Lable Name</th>
<th sort="description">Country</th>
<th sort="description">Phone No</th>
<th sort="beds">E-mail</th>
<th sort="maxGuests">View Details</th>
</tr>
</thead>
<tbody>
<?
mysql_connect("localhost","root","");
mysql_select_db("plaincart");
$query=mysql_query('select * from tbl_user');
$num_rows = mysql_num_rows($query);
if($num_rows >0)
{
for($k=0;$k<$num_rows;$k++)
if($row2=mysql_fetch_array($query))
{
//
echo "<tr>
<td valign='top' style='text-align:center;'>"; echo $row2['user_id']; echo "</td>
<td valign='top'>"; echo $row2['user_name']; echo "</td>
<td valign='top'>"; echo $row2['user_password']; echo "</td>
<td valign='top'>"; echo $row2['fname']; echo "</td>
<td valign='top'>"; echo $row2['lname']; echo "</td>
<td valign='top'>"; echo $row2['artistname']; echo "</td>
<td valign='top'>"; echo $row2['lablename']; echo "</td>
<td valign='top'>"; echo $row2['country']; echo "</td>
<td valign='top'>"; echo $row2['phoneno']; echo "</td>
<td valign='top'>"; echo $row2['email']; echo "</td>
<td valign='top' style='text-align:center;'>"; ?> <a href='viewdetails.php?id=<?=$row2['user_id']?>'>View</a> <? echo "</td>
</tr>
";
}}
?>
</tbody>
<tfoot class="nav">
<tr>
<td colspan=7>
<div class="pagination"></div>
<div class="paginationTitle">Page</div>
<div class="selectPerPage"></div>
<div class="status"></div>
</td>
</tr>
</tfoot>
</table>
</body>
<html>
<head>
<script language="JavaScript" type="text/javascript" src="js/jquery.js"></script>
<script language="JavaScript" type="text/javascript" src="jTPS.js"></script>
<link rel="stylesheet" type="text/css" href="jTPS.css">
<script type='text/javascript' src='js/jquery.js'></script>
<script type='text/javascript' src='js/jquery.simplemodal.js'></script>
<script type='text/javascript' src='js/osx.js'></script>
<script>
$(document).ready(function () {
$('#demoTable').jTPS( {perPages:[5,12,15,50,'ALL'],scrollStep:1,scrollDelay:30,
clickCallback:function () {
// target table selector
var table = '#demoTable';
// store pagination + sort in cookie
document.cookie = 'jTPS=sortasc:' + $(table + ' .sortableHeader').index($(table + ' .sortAsc')) + ',' +
'sortdesc:' + $(table + ' .sortableHeader').index($(table + ' .sortDesc')) + ',' +
'page:' + $(table + ' .pageSelector').index($(table + ' .hilightPageSelector')) + ';';
}
});
// reinstate sort and pagination if cookie exists
var cookies = document.cookie.split(';');
for (var ci = 0, cie = cookies.length; ci < cie; ci++) {
var cookie = cookies[ci].split('=');
if (cookie[0] == 'jTPS') {
var commands = cookie[1].split(',');
for (var cm = 0, cme = commands.length; cm < cme; cm++) {
var command = commands[cm].split(':');
if (command[0] == 'sortasc' && parseInt(command[1]) >= 0) {
$('#demoTable .sortableHeader:eq(' + parseInt(command[1]) + ')').click();
} else if (command[0] == 'sortdesc' && parseInt(command[1]) >= 0) {
$('#demoTable .sortableHeader:eq(' + parseInt(command[1]) + ')').click().click();
} else if (command[0] == 'page' && parseInt(command[1]) >= 0) {
$('#demoTable .pageSelector:eq(' + parseInt(command[1]) + ')').click();
}
}
}
}
// bind mouseover for each tbody row and change cell (td) hover style
$('#demoTable tbody tr:not(.stubCell)').bind('mouseover mouseout',
function (e) {
// hilight the row
e.type == 'mouseover' ? $(this).children('td').addClass('hilightRow') : $(this).children('td').removeClass('hilightRow');
}
);
});
</script>
<style>
body {
font-family: Tahoma;
font-size: 9pt;
}
#demoTable thead th {
white-space: nowrap;
overflow-x:hidden;
padding: 3px;
}
#demoTable tbody td {
padding: 3px;
}
</style>
</head>
<body>
<table id="demoTable" style="border: 1px solid #ccc;" cellspacing="0" width="700">
<thead>
<tr>
<th sort="index">User ID</th>
<th sort="date">User Name</th>
<th sort="description">User Password</th>
<th sort="description">First Name</th>
<th sort="description">Last Name</th>
<th sort="description">Artist Name</th>
<th sort="description">Lable Name</th>
<th sort="description">Country</th>
<th sort="description">Phone No</th>
<th sort="beds">E-mail</th>
<th sort="maxGuests">View Details</th>
</tr>
</thead>
<tbody>
<?
mysql_connect("localhost","root","");
mysql_select_db("plaincart");
$query=mysql_query('select * from tbl_user');
$num_rows = mysql_num_rows($query);
if($num_rows >0)
{
for($k=0;$k<$num_rows;$k++)
if($row2=mysql_fetch_array($query))
{
//
echo "<tr>
<td valign='top' style='text-align:center;'>"; echo $row2['user_id']; echo "</td>
<td valign='top'>"; echo $row2['user_name']; echo "</td>
<td valign='top'>"; echo $row2['user_password']; echo "</td>
<td valign='top'>"; echo $row2['fname']; echo "</td>
<td valign='top'>"; echo $row2['lname']; echo "</td>
<td valign='top'>"; echo $row2['artistname']; echo "</td>
<td valign='top'>"; echo $row2['lablename']; echo "</td>
<td valign='top'>"; echo $row2['country']; echo "</td>
<td valign='top'>"; echo $row2['phoneno']; echo "</td>
<td valign='top'>"; echo $row2['email']; echo "</td>
<td valign='top' style='text-align:center;'>"; ?> <a href='viewdetails.php?id=<?=$row2['user_id']?>'>View</a> <? echo "</td>
</tr>
";
}}
?>
</tbody>
<tfoot class="nav">
<tr>
<td colspan=7>
<div class="pagination"></div>
<div class="paginationTitle">Page</div>
<div class="selectPerPage"></div>
<div class="status"></div>
</td>
</tr>
</tfoot>
</table>
</body>
No comments:
Post a Comment
Thank you for your Comment....