PRIOR NEXT feature

Dale,
unfortunatelly there is no easy way to do that.
We'll add this fetaure in one of the next PHPRunner versions.

Any progress on this.
I would like to be able to browse through records in the View format as well as the option of returning to the list.
http://www.bordeauxreport.com/db-2007/03/W...w.php?editid1=1
Would be cool to have next and prior or all records or selected records in the current search.
Cheers Chris
PHPrunner is better than ever

This can be done via "Insert PHP code snippet" function in Visual Editor.
Write the code that gets IDs of both Next and Previous records and dispaly corrsponding links.

Cool - are there are examples of this.
Cheers Chris

This can be done via "Insert PHP code snippet" function in Visual Editor.

Hi,
here is a sample code for event with Next link:

global $conn,$strTableName;

Hi,

Here is what I found worked for me... I added it to the events page. "EditPage: OnLoad event". "Display a message on the Web Page"

Bold Italics = needs to be replaced with information related to your project

Red = changes I made from the above comment

(Note - this only give a next link... you can design similar code for a previous link)
global $conn,$strTableName;

$links = "";

$current = $_REQUEST["editid1"];

$next=0;

$strSelect = "select * from ".$strTableName;

$rs = db_query($strSelect,$conn);

while ($data = db_fetch_array($rs))

{

if ($next) {

$links = "<a href=\"TableName_edit.php?editid1=".$data["IDField"]."\">next</a>";

$next = 0;

}

if ($current==$data["IDField"])

$next = $current+1;

}

echo $links;

Thanks for that i will report back on my progress.

Cheers Chris

Hi,
I have hundreds of check lists in my project and this prev<-->next feature is very handy. I have implemented the a.m. event for a next link but .
( by setting [color=#FF0000]$current = $_REQUEST["editid1"] - 2 I was able to browse some prior records)
best regards
Jouni I

Hi,

The following changes, which I've highlighted in red, will allow you to have a prev and next link.

Once again, replace anything in bold italics with information related to your project. Add the code to the OnLoad event of the correct page, using the "Display a message on the web page" option.
Finally, note this code works on the edit page. To add it to the view page, change TableName_edit to TableName_view. Oh, and of course the "prev" link will not show up if it's the first record... so to check if they both work, please use a record that is in the middle of your table.
global $conn,$strTableName;

$links = "";
$current = $_REQUEST["editid1"];

$next=0;

$strSelect = "select * from ".$strTableName;

$rs = db_query($strSelect,$conn);

while ($data = db_fetch_array($rs))

{

if ($next) {

$links [color=#FF0000].= " <a href=\"TableName_edit.php?editid1=".$data["IDField"]."\">next</a>";

$next = 0;

}
if ($current==$data["IDField"])

$next = $current+1;

[color=#FF0000]$links = $prevLink;

}

else {

$prevLink = "<a href=\"TableName_edit.php?editid1=".$data["IDField"]."\">prev</a>";

}

}

echo $links;

Thanks a million Hax0r,
the code snippet works just great and makes things much easier for me and my clients.
best regards from Finland
Jouni I

Cool I have added the code as follows

screen grab below code below that
OnLoad event

using the "Display a message on the web page"

For page: http://www.bordeauxreport.com/db-2007/view...w.php?editid1=1

I dont get an error mesage but no sign of the links either.

Do I neeed to create the button and link them in some way?
Cheers Chris

Cool I have added the code as follows

I dont get an error mesage but no sign of the links either.

Do I neeed to create the button and link them in some way?
Cheers Chris

Hi,
try this
if ($current==$data["Ref"]) {
regards
Jouni I

Thanks Jouni. I forgot to bold italics that one.
Also, Chris... since you want the links on the view page, you should change "Wine_Data_edit.php" to "Wine_Data_view.php"

I changed then forgot the edit view page thing

I didnt know to change the id!
So here it is again - I must be close now! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=22925&image=1&table=forumreplies' class='bbc_emoticon' alt=';)' />

Can anyone post a screen grab or this working?
Cheers Chris

I changed then forgot the edit view page thing

Here is a code with navigation buttons (note del is a field in a table that checks deleted records ):
[codebox]global $conn,$strTableName;

$links = "";

$prevLink = "";

$current = $_REQUEST["editid1"];

$next=0;

$strSelect = "select * from ".$strTableName." where del='0'";

$rs = db_query($strSelect,$conn);

while ($data = db_fetch_array($rs))

{

if ($next) {

$links .= " <a href=\"riski_edit.php?editid1=".$data["id_riski"]."\"><img border=0 src='images/nav_right.png'></a>";//

$next = 0;

}
if ($current==$data["id_riski"]) {

$next = $current+1;

$links = $prevLink;

}

else {

$prevLink = "<a href=\"riski_edit.php?editid1=".$data["id_riski"]."\"><img border=0 src='images/nav_left.png'></a>";

}

}

echo "<table width=40% ><tr><td style= 'border-color: #f1f1f1;' align=center>".$links."</td></tr></table>";//table aligns navigation buttons[/codebox]
Works well for me.
regards
Jouni I

Jouni,
What is displaying the message in your target page?
Can you post that part of the page - is it the $message?
I think i must have altered the template and removed whatever is used to display the data.
Thanks for your help
Cheers Chris

Jouni,

Hi Chris
Your code seems to be ok but can you post the code in text format so I can copy and test it in my project.
regards Jouni I

My code

Page to display it in!

Cheers Chris

My code

Page to display it in!

Cheers Chris

Hi Chris,
Your code is correct. If this is your view page the viewonload event is missing. So insert this code snippet {doevent name="ViewOnLoad"} right after the first body tag.
best regards
Jouni I

Thanks guys but now I get this error!
Cheers Chris

I dont know what causes this error but when code is removed the view pages display fine.

When added the PHP error occurs.
2 changed files are:
Upload file templates\Wine_Data_view.htm ...ok

Upload file include\Wine_Data_events.php ...ok

Upload finished OK. 2 of 2 files uploaded
Slightly odd that Wine_Data_events.php has so many blank lines

Current Wine_Data_view.htm

Hi,

try to change .
regards Jouni I

the table is `Wine Data`
Is there a problem with the space in the table name?
Looks like $conn $strTableName should find the connection and table name.
Seems it is looking for

Table 'Bauduc-_GQ0701.Wine'

Not

Table 'Bauduc-_GQ0701.Wine Data'
Error description Table 'Bauduc-_GQ0701.Wine' doesn't exist

URL bordeauxreport.com/db-2007/view/Wine_Data_view.php?editid1=60
global $conn,$strTableName;

Should this be line become

global $conn,`Wine Data`;
Thanks again to everyone for there help.
Cheers Chris