Below simple program will export mysql data values to excel sheet without using any PHP libraries. Export to Excel Using PHP and Mysql <!–?php </p> <p>//write your db connection</p> <p>$xlsFile= ‘file_’.date(‘Y-m-d’).’.xls’; <br ?–>$separator = "t";</pre> $sql = "Select * from emp"; $Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password) or die("Failed to connect: " . mysql_error() . " […]
You can initilize local settings in a php file.You can set values like max_execution_time, default_socket_timeout, memory_limit, mysql.connect_timeout, user_ini.cache_ttl, display_errors and log_errorsit always nice to check the errors in PHP files with error_reporting. Below is the sample script to set ini_set values. If you dont want to set every time in PHP script simply set the […]
Below error occurs because it is not allowing Less secure apps to access gmail account from Bonitasoft. Go to this link https://www.google.com/settings/security/lesssecureapps then Turn On and check the email connector it should work. smtp.gmail.com with port: 587 for TLS s,tp.gmail.com with port: 465 for SSL java.lang.reflect.InvocationTargetException org.bonitasoft.engine.bpm.connector.ConnectorExecutionException: USERNAME=install | org.bonitasoft.engine.core.connector.exception.SConnectorException: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: javax.mail.AuthenticationFailedException: 534-5.7.14 […]