Php plugin list - run PHP code

[georgie]

Hello

I wish to execute PHP code with a button, thanks to the great plugin php! But I can not retrieve the id of the selected record.

Php well executed this query:

$db =& JFactory::getDBO();
$query = " update apr set valide='yes' ";
$db->setQuery($query);
$db->execute();

But I can not seem to apply only to the selected record !

Can you help me!

THX

 

[startpoint]

Hi,
I think this plugin can help you:
http://fabrikar.com/forums/index.php?wiki/update-columns-list-plugin/

Regards

 

[georgie]

It is the Php Plugin to use in list ? Beacause it is this plugin that I already use.

No ?

 

[driveman]

Hello, you need to catch the rowid of item you selected (or item attached on you php button) and fix a WHERE condition in your query, otherwise your update will be applied on all datas of table apr.
Try this:


//Catch your selected data

$IDinput = '{rowid}';

//Create connection to database

$db =& JFactory::getDBO();

//SQL query - update table apr, set field 'value' to yes if line is selected

$query = " update apr set valide='yes' where id IN('.$IDinput.')";

$db->setQuery($query);

$db->execute();

 

[georgie]

Hi ! Thank you but it doesn't run. No bug, query seems be executed, but without correct catch of the rowid !

Any idea ? I am on Joomla 3.3.0 !

 

[troester]

Did you read the WIKI startpoint mentioned?
Update column plugin is NOT the list php plugin but may be doing what you want to do without php coding.
For the php list plugin see
http://fabrikar.com/forums/index.php?wiki/php-list-plugin/
which shows also how to get the selected ids and how to set up a query.
Additionally see http://fabrikar.com/forums/index.php?wiki/common-php-tasks/

 

[georgie]

Yeah !!!!! THX it is exactly this !

THX you very much !