Below is the SQL Connection for a Groovy Script for a SELECT Command in Bonitasoft BPM import groovy.sql.Sql;def host = “localhost”;def user = “bonita”;def pass = “bpm”;def schema = “bonita_journal”;def query = “SELECT * FROM BN_USER where USER_PRO_EMAIL_=’${email_Address__}’ limit 1”;def list=[];sql = providedscripts.BonitaSql.newInstance(“jdbc:mysql://${host}/${schema}”,user, pass, new com.mysql.jdbc.Driver())sql.eachRow(query,{row-> list.add(row.USER_USERNAME_)}); IdentityAPI api = apiAccessor.getIdentityAPI();User userObj = api.findUserByUserName(list[0]);User manager1 […]
By running below query you can able to get the Current Timezone of the database server. select timediff(now(),convert_tz(now(),@@session.time_zone,’+00:00′));
Below is a simple program which shows email verification confirmation using a unique code, implemented in PHP,Mysql, Codeigniter. PHP Codeigniter Email Verification Step 1 :Create a table as shown below with email_verification_code as necessary column: [mysql] CREATE TABLE `users` ( `user_id` int(10) NOT NULL auto_increment, `first_name` varchar(45) NOT NULL, `last_name` varchar(45) NOT NULL, `email_verification_code` varchar(45) […]
