PHP Builder

Re: HOW TO: three methods to make a filed as link to edit mode

administrator — Wed Mar 14, 2007 8:18 pm

Author: administrator

Posted: Wed Mar 14, 2007 8:18 pm

Right version

Code:

Fixed in new version, but don't write
Code:
"byFieldValue"=>"tblCountries.Name"

Right syntax:
Code:
"byFieldValue"=>"Name"

Solved

fcallez — Wed Mar 14, 2007 4:20 am

Author: fcallez

Posted: Wed Mar 14, 2007 4:20 am

Solved

Please, checking the previous forum (Published the Mar 13, 2007 10:59 am)

I suggest that the option keep on, It is interesting and can be useful....

Greetings

As is he the difference?

fcallez — Tue Mar 13, 2007 10:17 pm

Author: fcallez

Posted: Tue Mar 13, 2007 10:17 pm

Good day

As is he the difference?

administrator wrote:

Fixed in new version, but don't write

Code:

"byFieldValue"=>"tblCountries.Name"

Right syntax:

Code:

"byFieldValue"=>"tblCountries.Name"

Generally, I plan to redo this option or remove it in nearests versions.

It would be interesting that it be used with the primary key of the table

Thanks

Re: HOW TO: three methods to make a filed as link to edit mode

administrator — Tue Mar 13, 2007 8:56 pm

Author: administrator

Posted: Tue Mar 13, 2007 8:56 pm

Fixed in new version, but don't write

Code:

"byFieldValue"=>"tblCountries.Name"

Right syntax:

Code:

"byFieldValue"=>"tblCountries.Name"

Generally, I plan to redo this option or remove it in nearests versions.

This second option does not operate

fcallez — Tue Mar 13, 2007 3:59 pm

Author: fcallez

Posted: Tue Mar 13, 2007 3:59 pm

This second option does not operate

At the class, the code:

************************************
Line 1457

if(isset($this->modes['edit'][$this->mode]) && $this->modes['edit'][$this->mode]){
if (isset($this->modes['edit']['byFieldValue']) && ($this->modes['edit']['byFieldValue'] == "")){
$this->colOpen("center",0,"nowrap",$main_td_color,"class_td_main");
$this->drawModeButton("edit", $curr_url, $this->lang['edit'], $this->lang['edit_record'], "edit.gif", "\"javascript:document.location.href='http://".$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF'].$curr_url."'\"", false, $nbsp=" ");
$this->colClose();
}else{
$this->colOpen(($this->direction == "rtl")?"right":"left",0,"nowrap",$main_td_color,"class_td_main");echo " <a class='class_a' href='$curr_url'>".$row[$this->modes['edit']['byFieldValue']]."</a> ";$this->colClose();
}
}
********************************

It's not right

********************************

Solved ---->> Suggestion
---------------------------------------------

if(isset($this->modes['edit'][$this->mode]) && $this->modes['edit'][$this->mode]){
if (isset($this->modes['edit']['byFieldValue']) && ($this->modes['edit']['byFieldValue'] == "")){
$this->colOpen("center",0,"nowrap",$main_td_color,"class_td_main");
$this->drawModeButton("edit", $curr_url, $this->lang['edit'], $this->lang['edit_record'], "edit.gif", "\"javascript:document.location.href='http://".$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF'].$curr_url."'\"", false, $nbsp=" ");
$this->colClose();
}else{

$this->colOpen(($this->direction == "rtl")?"right":"left",0,"nowrap",$main_td_color,"class_td_main");echo " <div align='center'><a class='class_a' href='http://".$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF'].$curr_url."'>".$row[$this->getFieldOffset($this->modes['edit']['byFieldValue'])]."</a></div> ";$this->colClose();

}
}

****************************************

It's supposed to be the value of the selected field in ("byFieldValue"):

Correct
--------

"edit"=>array("view"=>true, "edit"=>true, "type"=>"link", "byFieldValue"=>"Name"),

Incorrect
----------

"edit"=>array("view"=>true, "edit"=>true, "type"=>"link", "byFieldValue"=>"tblCountries.Name"),

Thanks

HOW TO: three methods to make a filed as link to edit mode

administrator — Thu Feb 08, 2007 2:09 pm

Author: administrator

Posted: Thu Feb 08, 2007 2:09 pm

1) Click on edit button and copy all address string from your browser
(when you want to hide specifical field)

Let it be:
http://mysite.com/pid=39&mode=edit&rid=33&page_size=100&p=1&sort_field=1&sort_type=desc

Change it on
http://mysite.com/pid=39&mode=edit&page_size=100&p=1&sort_field=1&sort_type=desc&rid=

And write in $vm_colimns:

"name"=>array("header"=>"Full Name", "type"=>"link", "align"=>"left", "field"=>"mid", "prefix"=>"http://mysite.com/pid=39&mode=edit&page_size=100&p=1&sort_field=1&sort_type=desc&rid=", "target"=>"",
"text_length"=>"-1"),
Where mid is field name (primary key) in the target table

2) Let you have field, named d_field in SELECT statment.
(when you want to use specifical field instead of 'Edit')

Now, write in $modes :
"edit"=>array("view"=>true, "edit"=>true, "type"=>"link", "byFieldValue"=>"d_field"),

3) Make a link on a separate page, where you can proccess edit/update operations:
(when you use hardly linked tables etc.)

"name"=>array("header"=>"Full Name", "type"=>"link", "align"=>"left", "field"=>"rid",
"prefix"=>"http://mysite.com/my_edit.php?rid=", "target"=>"",
"text_length"=>"-1"),

4) You also can save needed url parameters in $_SESSION
See here: http://www.phpbb88.com/phpbuilder/viewtopic.php?t=82&mforum=phpbuilder