[LouisLO]

Dear all,

Can you help me?

I refer to URL "http://www.processmaker.com/running-lea ... ce-request", how to input the values of “Days”, “Days Taken” and “Comments” into MySQL database?

Many thanks!

Louis

[amosbatto]

Create a trigger which is set to execute after the DynaForm. If you are using an external database, then create a Database Connection to the database, then copy the UID for the database and use it in your code. If using a PM Table to store the data, then you don't need a Database Connection. Then use this trigger code:
Change the variables to match the variables associated with in your DynaForm fields:

Code: Select all

$db = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXX'; //set to the UID of your DB Connection
$Days = @@Days;  
$DaysTaken = @@DaysTaken; 
$Comments = mysql_real_escape_string(@@Comments);
$sql = "INSERT INTO TABLE_X (DAYS, DAYS_TAKEN, COMMENTS) VALUES ($Days, $DaysTaken, '$Comments')";
@@result = executeQuery($sql, $db);

See: http://wiki.processmaker.com/3.0/Proces ... uery.28.29

[LouisLO]

I installed processmaker-3.1-0-windows-x64. Please refer to attached file. This SQL statement does not work in Dynaform. Why? Please provide the advice. Many thanks!

[michaeltimoteo]

Hi LouisLO,

Basically you didn't create a trigger you made some mistake in your variable creation.
If you are going to insert it in a Mysql database(internal, external)
Here is some clarification on how you do it.
1.) Establish db connection

db.PNG (81.43 KiB) Viewed 6492 times

2.) Your variable should just hold a string value

stuff_id.PNG (27.12 KiB) Viewed 6492 times

3.) Create a trigger, you can modify my code ( I named my trigger "get_db")

trigger.PNG (105.86 KiB) Viewed 6492 times

4.) Right click the task and go to steps and assign the trigger after routing

assign trigger.PNG (106.3 KiB) Viewed 6492 times

There is also other way to record pm data into a mysql table, it's going to a report table, read this if interested.
http://wiki.processmaker.com/3.0/Report_Tables
I hope this helps

[LouisLO]

It works.

Many thanks to "michaeltimoteo".

[LouisLO]

It works.

Many thanks to amosbatto! ^^

[bilalk]

Hi LouisLO,

Basically you didn't create a trigger you made some mistake in your variable creation.
If you are going to insert it in a Mysql database(internal, external)
Here is some clarification on how you do it.
1.) Establish db connection

db.PNG

2.) Your variable should just hold a string value

stuff_id.PNG

3.) Create a trigger, you can modify my code ( I named my trigger "get_db")

trigger.PNG

4.) Right click the task and go to steps and assign the trigger after routing

assign trigger.PNG

There is also other way to record pm data into a mysql table, it's going to a report table, read this if interested.
http://wiki.processmaker.com/3.0/Report_Tables
I hope this helps

can you share attachted files again "michaeltimoteo"? they are not available to download.

[dvalenzuela]

can you share attachted files again "michaeltimoteo"? they are not available to download.