--- In firebird-php@yahoogroups.com, masotti <masotti@...> wrote:

>
> Hi,
> seems like you think to program in Delphi Win32 and not in a Web
> development model.
> Every time you post the page (Button1Click isn't a JS method) you
> restart execution of php from the beginning, so your query is

reexecuted

> again and again.
>
> Let me suggest some hints, see details in code
>
>
> > `<?php
> > require_once("vcl/vcl.inc.php");
> > use_unit("forms.inc.php");
> > use_unit("extctrls.inc.php");
> > use_unit("stdctrls.inc.php");
> > $conn = ibase_connect("JAYS-PC:C:/DWebsite/files/APPLY.FDB", "SYSDBA",
> > "masterkey");
> >
> Use ibase_pconnect(), because if you've already a connection opened

that

> is used; normal connection are closed at the end of script, but it

takes

> time to reconnect each time. Using pooled connection may speed

execution

> and simplify program logic.
>
> $stmtf = "SELECT * FOR 1 SKIP ? FROM APPLIED";
>
> Use a form loaded Javascript event to sprintf() and open query: that is
> the best moment to do that tipe of management, see below.
> >
> > //Class definition
> > class QuerySample extends Page
> > {
> > public $displabel = null;
> > public $Button1 = null;
> > public $Enterrec = null;
> > public $datalabel = null;
> > public $labelinput = null;
> >
> >
> >
> > function Button1Click($sender, $params)
> >
> > {
> > GLOBAL $conn;
> > GLOBAL $iaquery;
> > GLOBAL $row;
> > GLOBAL $stmt;
> > GLOBAL $rcursor;
> >
> > // if input record number was N for Next,
> > // cant get N or next to work
> > // i must have to pass varible to session, I thought being

global

> > $rcursor would retain value.??
> >
> No, as explained elsewhrere D4PHP destroys $_SESSION in page loading.
> For workaround see:
> http://www.qadram.com/vcl4php/forums/viewtopic.php?t=480
> The simplest solution is to use a hidden field in the form. You can
> retrieve in PHP with
>
> $val = $this->HiddenField1->value;
>
> and with JavaScript with
>
> aa = findObj('HiddenField1').value;
>
> > ... skipped
> > }
> >
> function QuerySampleJSLoaded {
>
> // As explained D4PHP erases $_SESSION vars each time a page is

loaded. But here we can do all in JSLoaded().

> // Beware: PHP code is executed BEFORE dumping page code to client,
> // Javascript code is executed AFTER the HTML has been loaded to client
>
> global $rcursor, $conn, $stmtf ;
> $job_id = "<b>EOF</b>";
> if ( $rsrc = ibase_query ( $conn, $stmtf, $rcursor )) {
> if ( $row = ibase_fetch_object ( $rsrc, IBASE_TEXT )) {
> $job_id = $row->JOB_ID;
> }
> }
> echo "var aa = \"$job_id\";
> ";
> ?>
> // here is javascript executed AFTER page loaded (code expanded for

clarity, so you can debug it)

> var xx = findObj('displabel');
> xx.innerHTML = aa;
> <?php
> }
>
> > }
> >
> > global $application;
> >
> > global $QuerySample;
> >
> > //Creates the form
> > $QuerySample = new QuerySample($application);
> >
> > //Read from resource file
> > $QuerySample->loadResource(__FILE__);
> >
> > //Shows the form
> > $QuerySample->show();
> >
> > ?>
> >
> Hope this helps (and not being too much off topic in this list).
> Ciao.
> Mimmo.
>

Many thanks Mimmo, this is very informative, I didnt give javascript
any consideration in helping us retain record info. One of my
paranoid visions is not everyone will have javascript enabled on their
browsers and will complain to web administrator, but today I don't
think non-js script use is as prevalent as it used to be.

Also the select statement has been changed... Besides it obviously
being different word wise, what differences does this invoke? Does
this allow us to acquire one row at a time in a sequential manner?


$stmtf = "SELECT * FOR 1 SKIP ? FROM APPLIED";


Thanks Again!
Jay