- Mon Jan 20, 2020 5:27 am
#827420
Hi,
Some times the executeQuery function is not working. To over come the issue i have gone through the processmaker source code. below code works well
Some times the executeQuery function is not working. To over come the issue i have gone through the processmaker source code. below code works well
Code: Select all
$cnn = Propel::getConnection(SYS_SYS); // SYS_SYS - will take the current database name
$stmt = $cnn->createStatement();
$date = date("Y-m-d h:i:s");
$query = "UPDATE PMT_BOOK SET NAME = '".$name."',TITLE = '".$title."',AUTHOR = '".$author."',BARROW = '".$barrow."', RETURNED = '".$return."' WHERE ID = 1";
$result = $stmt->executeQuery($query, ResultSet::FETCHMODE_ASSOC);
// echo '<pre>';print_r($result);die;