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?
$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);
michaeltimoteo wrote: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 2.) Your variable should just hold a string value 3.) Create a trigger, you can modify my code ( I named my trigger "get_db") 4.) Right click the task and go to steps and assign the trigger after routing There is also other way to record pm data into a mysql table, it's going to a report table, read this if interested.
I hope this helps
Hello! If you did not find the mcrypt extension […]
Hello! You have a mistake in the url, the correct […]
Hello! It is very rare since I could not replicate[…]
Hello! It is likely that the design you are doin[…]