Webner Blogs – eLearning, Salesforce, Web Development & More

Create and Download CSV of table Records using OUTFILE Sql command and PHP 1. Create temporary CSV file using OUTFILE SQL command: OUTFILE command is used to write your sql command output to the specified location. You can write the output

Description: When we use auto debit system to charge our customers using their credit cards, it is possible some transactions get declined. This can happen due to different reasons like user’s credit card has expired or due to authentication failure

Suppose we have live websites and we are using bitbucket to save the code of plugins, themes etc of those websites. Then we can manage the deployment to live sites easily through the WP pusher plugin. WP Pusher plugin is

In one of our projects, requirement was to compare two password values using HTML5 form validation (display the message in the same format as regular HTML5 messages are displayed). Let us assume that we have a HTML5 form for change

With bootstrap timepicker plugin, one can select time similar to datepicker (we select date, month, year from datepicker). With bootstrap timepicker plugin, we can select hour, minutes and meridian. In the following screenshot, you can understand, what timepicker does: Screenshot

1. Place Scripts at the Bottom of the Page: If we include script at the top, sometime page elements are not loaded completely and script starts working. So we need to include scripts after loading all the elements. Also if scripts

SQL Report in ‘Configurable Reports’ plugin provides us an easy UI to write SQL Query and draw results immediately without involving any code complications. Suppose I want to generate my custom grades report based on some specific activities from course

‘Like’ operator of SQL can be used in the following ways in Moodle: Using expression $DB->sql_like: $grade_item_test = $DB->get_records_sql ( ‘SELECT * FROM {grade_items} WHERE ‘.$DB->sql_like(‘idnumber’, ‘:idnum’).’ AND courseid=:cid order by itemmodule’, array (‘idnum’=>’test’,’cid’=> $courseid) ); Using like operator: $grade_item_test

Execute dynamic query in salesforce. Also retrieve all fields from salesforce object without writing fields names in query. Solution: In Salesforce we can’t write as Select * from object. We have to mention the field specific field name to query