|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
PHP Outputting finite amount of lines from a file
Post 87633 by pondlife on Wednesday 26th of October 2005 11:44:23 AM
10-26-2005
Solution found!
I went with a database solution in the end but the method to display the output would've been the same - here's the final code:
print '<table class="tborder" border="0" width="95%" align="center">';
$t=0;
print '<tr>';
while ($data=mysql_fetch_array($result)) {
// include code to display results as you see fit
$t++;
print '<td align="center">';
print "<a href=\"" .$data['link']."\" title=\"Add An Image - Link No. ".$data['linknum']."\"><img src=\"phpThumb.php?src=" .$data['link']. "&w=100\"></a><br>";
print "submitted by<br>";
print $data['name']."<br>";
print $data['date_entered']."<br>";
print '</td>';
if ($t == 5) {
print '</tr>';
$t=0;
}
}
print '</table>';
print '<p align="center">';
// next we need to do the links to other results
if($offset >= $limit){
$newoffset=$offset-$limit;
print "<a href=\"$PHP_SELF?catagory=$catagory&offset=$newoffset\">PREV</a> ";
}
// calculate number of pages needing links
$pages=intval($numrows/$limit);
// $pages now contains int of pages needed unless there is a remainder from division
if ($numrows%$limit) {
// has remainder so add one page
$pages++;
}
for ($i=1;$i<=$pages;$i++) { // loop thru
$newoffset=$limit*($i-1);
if ($newoffset != 0){
print "<a href=\"$PHP_SELF?catagory=$catagory&offset=$newoffset\">$i</a> \n";
}
}
// check to see if last page
if($numrows-$offset > $limit){
$newoffset=$offset+$limit;
print "<a href=\"$PHP_SELF?catagory=$catagory&offset=$newoffset\">NEXT</a>\n";
}
print '</p>';
?>
print '<table class="tborder" border="0" width="95%" align="center">';
$t=0;
print '<tr>';
while ($data=mysql_fetch_array($result)) {
// include code to display results as you see fit
$t++;
print '<td align="center">';
print "<a href=\"" .$data['link']."\" title=\"Add An Image - Link No. ".$data['linknum']."\"><img src=\"phpThumb.php?src=" .$data['link']. "&w=100\"></a><br>";
print "submitted by<br>";
print $data['name']."<br>";
print $data['date_entered']."<br>";
print '</td>';
if ($t == 5) {
print '</tr>';
$t=0;
}
}
print '</table>';
print '<p align="center">';
// next we need to do the links to other results
if($offset >= $limit){
$newoffset=$offset-$limit;
print "<a href=\"$PHP_SELF?catagory=$catagory&offset=$newoffset\">PREV</a> ";
}
// calculate number of pages needing links
$pages=intval($numrows/$limit);
// $pages now contains int of pages needed unless there is a remainder from division
if ($numrows%$limit) {
// has remainder so add one page
$pages++;
}
for ($i=1;$i<=$pages;$i++) { // loop thru
$newoffset=$limit*($i-1);
if ($newoffset != 0){
print "<a href=\"$PHP_SELF?catagory=$catagory&offset=$newoffset\">$i</a> \n";
}
}
// check to see if last page
if($numrows-$offset > $limit){
$newoffset=$offset+$limit;
print "<a href=\"$PHP_SELF?catagory=$catagory&offset=$newoffset\">NEXT</a>\n";
}
print '</p>';
?>
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I did search the posts for info on this and while there were some in the ballpark, none addressed this specifically. (also I tried to post this once it said I was logged out, so hopefully I'm not sending a duplicate here).
I have a set of files (250 +/-) where I need to delete the first "$x"... (4 Replies)
Discussion started by: benair
4 Replies
2. Shell Programming and Scripting
Dear Gurus,
I have this output file:
F1BDEV13 NTIAF101 2006/09/21 14:54:51 14:55:29 1 0560-0570 LAN
F1BDEV14 NTIAF101 2006/09/21 14:55:30 14:55:49 1 0000-0000 LAN
F1FSP001 NTIAF101 2006/09/21 14:55:51 14:55:53 1 0000-0000 LAN
F1NSP001 ... (6 Replies)
Discussion started by: lweegp
6 Replies
3. Shell Programming and Scripting
Well I have a 3000 lines result log file that contains all the machine data when it does the testing... It has 3 different section that i am intrsted in
1) starting with "20071126 11:11:11 Machine Header 1"
1000 lines...
"End machine header 1"
2) starting with "20071126 12:12:12 Machine... (5 Replies)
Discussion started by: vikas.iet
5 Replies
4. Shell Programming and Scripting
Hi guys, looking for a bit of advise, and as I am a complete novice, please excuse the daft questions!!
I have a list of events and of which entry looks like this;
#
# Event 1
# NAME = Event 1
#
12345 : 123 : 1 : 1 : L,1,N : 1,0 : Event
#
# Event 2
# NAME = Event 2
#
12346... (8 Replies)
Discussion started by: JayC89
8 Replies
5. Shell Programming and Scripting
I had a question about grep.
If I grep for something in a file, the output shows me all the lines in which that 'something' is contained in.
Is there a way to also output all the lines in which that 'something' wasnt contained in.
Say I have a file with a bunch of names and I do:
grep scott... (2 Replies)
Discussion started by: ndedhia1
2 Replies
6. Shell Programming and Scripting
I an trying to parse a file looking for pattern1, or pattern2, or pattern3 and when found print that line and the next 4 lines after it. I am using korn shell script on AIX and grep -A isn't available. (1 Reply)
Discussion started by: daveisme
1 Replies
7. UNIX for Dummies Questions & Answers
I need to enable set -x in my croned script as at times the script is not returning all data that it should be. This only happens intermittently and as such I would like a means of being able to check what goes wrong.
My question is how to output the debug of set -x to file? (1 Reply)
Discussion started by: rob171171
1 Replies
8. UNIX for Dummies Questions & Answers
Hello,
I have to write a script to compare the sum of the amount fields in a source file and the amount field in another file.
details are:
based on the name of the source file (say SALES as an example), a file already available in a path will be grabbed (say SALES_ParmFile) and this file... (4 Replies)
Discussion started by: vijaylak
4 Replies
9. UNIX for Advanced & Expert Users
Is there a limit on the amount of lines less can handle? I grepped for something that is pretty common in my files so I tried to filter it through less so it was easier to look at. So I then used a redirect ">" to create a file. It created a file that was 103K long. So that makes me think there is... (6 Replies)
Discussion started by: cokedude
6 Replies
10. Shell Programming and Scripting
Hi I wanted to call the AutoFsm function (given below) in vim to generate a code something like:
**********verilog code to generate *************
always @(posedge clk or negedge rst_n) begin
if(!rst_n) begin
state_r <= #1 next_stateascii_r; ... (0 Replies)
Discussion started by: dll_fpga
0 Replies
LEARN ABOUT SUNOS
cancel
cancel(1) cancel(1) NAME
cancel - cancel print request SYNOPSIS
cancel [ request-ID...] [destination...] cancel -u user... [destination...] The cancel utility cancels print requests. There are two forms of the cancel command. The first form of cancel has two optional arguments: print requests (request-ID) and destinations (destination). Specifying request-ID with destination cancels request-ID on destination. Specifying only the destination cancels the current print request on destination. If desti- nation is not specified, cancel cancels the requested print request on all destinations. The second form of cancel cancels a user's print requests on specific destinations. Users can only cancel print requests associated with their username. By default, users can only cancel print requests on the host from which the print request was submitted. If a super-user has set user-equivalence=true in /etc/printers.conf on the print server, users can cancel print requests associated with their username on any host. Super-users can cancel print requests on the host from which the print request was submitted. Superusers can also cancel print requests from the print server. The print client commands locate destination information using the printers database in the name service switch. See nsswitch.conf(4), printers(4), and printers.conf(4) for details. The following options are supported: -u user The name of the user for which print requests are to be cancelled. Specify user as a username. The following operands are supported: destination The destination on which the print requests are to be canceled. destination is the name of a printer or class of printers (see lpadmin(1M)). If destination is not specified, cancel cancels the requested print request on all destinations. Specify destination using atomic or POSIX-style (server:destination), names. See for information regarding using POSIX-style des- tination names with cancel. See standards(5) for information regarding POSIX. request-ID The print request to be canceled. Specify request-ID using LP-style request IDs (destination-number). user The name of the user for which the print requests are to be cancelled. Specify user as a username. The following exit values are returned: 0 Successful completion. non-zero An error occurred. /var/spool/print/* LP print queue. $HOME/.printers User-configurable printer database. /etc/printers.conf System printer configuration database. printers.conf.byname NIS version of /etc/printers.conf. printers.org_dir NIS+ version of /etc/printers.conf. See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWpcu | +-----------------------------+-----------------------------+ lp(1), lpq(1B), lpr(1B), lprm(1B), lpstat(1), lpadmin( 1M), nsswitch.conf(4), printers(4), printers.conf(4), attributes(5), standards(5) POSIX-style destination names (server:destination) are treated as print requests if destination has the same format as an LP-style request- ID. See standards(5). Some print servers send cancelation notification to job owners when their print jobs have been cancelled. This notification usually comes in the form of an email message. Cancelation notices cannot be disabled on a Solaris server. 23 Feb 2005 cancel(1)