2. PHPRunner General questions
  3. ADD Page + paramers in the URL
This topic is locked

ADD Page + paramers in the URL

 		12/9/2009 2:36:28 AM
PHPRunner General questions
N
 netmedia59 author

Hello,
I have a database with a table named docs with some fields
Num : Auto Inc

Field1 : Var

Field2 : Var

Field3 : Var
Is there a way to add a new record straight from a URL

for example
docs_add.php? Field1=BLABLABLA &Field2=YYYYAAAA &Field3=XXXXXXX
Thanks
netmedia59

Lille (FRANCE)
J
 		Jane 12/9/2009

Hi,
use List page: Before process event for this purpose.

Here is a sample:

global $dal;

if (@$_REQUEST["Field1"] && @$_REQUEST["Field2"] && @$_REQUEST["Field3"])

{

$dal->docs->Value["Field1"] = $_REQUEST["Field1"];

$dal->docs->Value["Field2"] = $_REQUEST["Field2"];

$dal->docs->Value["Field3"] = $_REQUEST["Field3"];

$dal->docs->Add();

}
N
 		netmedia59 author 12/9/2009

Hey Jane,
Thanks for your answer
Is it 'List page: Before process event' or 'Add page: Before process event'
How the URL shold be ?

  • docs_add.php?Field1=AAAAAAA&Field2=BBBBBB
  • docs_add.php?&Field1=AAAAAAA&Field2=BBBBBB or ???????????????
    Thanks for your answer !!!
    Olivier


    Hi,
    use List page: Before process event for this purpose.

    Here is a sample:

global $dal;

if (@$_REQUEST["Field1"] && @$_REQUEST["Field2"] && @$_REQUEST["Field3"])

{

$dal->docs->Value["Field1"] = $_REQUEST["Field1"];

$dal->docs->Value["Field2"] = $_REQUEST["Field2"];

$dal->docs->Value["Field3"] = $_REQUEST["Field3"];

$dal->docs->Add();

}
J
 		Jane 12/9/2009

Olivier,
docs_add.php?Field1=AAAAAAA&Field2=BBBBBB
N
 		netmedia59 author 12/9/2009

Hey Jane,
Thanks

It works great !!
Olivier