Generally, Google PageSpeed Insights API is used to measure the performance of a web page but you can also use Google PageSpeed Insights API to get a screenshot of the website from URL. In this post, we will show you how to capture a screenshot of the webpage using its Read more…
Here are the steps to set up PHPMYADMIN to connect to database servers located at different ip addresses:
1. Open config.inc.php located in C:\xampp\phpMyAdmin directory in windows and located in /etc/phpmyadmin directory in Ubuntu.
2. Add the below written code at the end of the Read more…
In Cakephp, To translate the application language into another, we use internationalization and localization. To display the correct translated date string on change of locale, we need to use right classes.
I18n::Locale(‘es’’); // es locale is for Spanish
$date = ‘2017-08 Read more…
SQL transaction in Cakephp 3 is a series of statements working in a logical order to handle database errors and ensure data integrity. There are four main methods being used in Sql transaction in Cakephp 3.
1. Initialize the statement using begin() method.
2. Execute the statement which Read more…
Steps to integrate CyberSource payment gateway with CakePHP 2.*:
1. Download zip file of CyberSource library from “https://github.com/chrismeller/cybersource”.
2. Extract cybersource-master folder into cakephp vendors folder.
3. Create tests/config.php for test transaction with code and add credentials like below:
Suppose we have a table cake_test with a column named modified that contains epoch values.
$options = array (
‘fields’ => array (
“to_timestamp(modified) as New__original”,
“to_timestamp(modified) AT TIME ZONE ‘America/Denver’ as New__converted”
$result = $this->CakeTest->find ( ‘all’, $options );
In the above query we have Read more…
Error: Call to a member function schema() on a non-object
Description: I was trying to execute the following cake query to fetch the records:
$records = $this->find ( ‘all’, array Read more…
Use Heroku cron jobs to run CakePHP code at fixed intervals of time.
Cron is a time-based scheduler used to run commands periodically at fixed intervals. Cron means time. It is used for scheduling repetitive tasks. In order to use it in Heroku, you just need to install the Read more…
First of all, we should know what features are provided by jquery-ui plugin. To know about details, please see link,
Jquery UI plugin can be downloaded from the link
Now, today, we will discuss about Autocomplete feature of jquery-ui plugin Read more…
How to use concatenate, cases, substring in CakePHP 2.* find query.
Suppose given records are:
Problem: Display user details in one column and the first character of user role in front of the user full name. Also suppose in case of superadmin role as well we want to display (a Read more…
Before uploading any document to Amazon AWS S3 server, make sure that user has to write access on the bucket where files will be saved else it will throw ‘Access denied’ error. Apart from the write permissions, access keys are also required in the code which we get while creating Read more…
Question: Can we add custom functions in quickbook?
Answer: Yes, In quickbook.php file we need to add Constants to make custom function and we can add as many as we want. After defining these constant we can map these in our web service.
Suppose we Read more…
CSRF stands for cross-site request forgery. CSRF token is basically used for security purpose in Laravel forms. To understand how it works read here: https://laravel.com/docs/5.4/csrf
How to disable it if required?
CSRF protection is enabled by default in all routes of Laravel 5 Read 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 to some files using OUTFILE when required Read more…
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 password screen:
<div Read more…
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 are loaded at the top, browser has Read more…
JSONB (JSON Blob) datatype in Postgres is used to save JSON data. We can search on JSONB type of column after creating an index on it.
Usage in PostgreSQL:
1. Create table and index
CREATE TABLE tests
id integer NOT NULL,
email citext NOT NULL,
address jsonb NOT Read more…
Handling content and image sharing with twitter and google plus share buttons in wordpress
To achieve dynamic content(including image) sharing from a website with share buttons (or links) for share and likes on social sites like twitter and google plus, wordpress requires somewhat more specific functions while creating plugin Read more…
To create a new customized plugin with email functionality and sending a pdf file as attachment requires some simple lines of code with TCPDF library file inside the library directory of moodle. And for performing file operations, filelib.php reference is required. For creating pdf file from HTML content, append Read more…
Google reCaptcha is a free service API provided by Google to protect your site from unauthorized access, abuses and spam. The API uses advanced risk analysis technique to distinguish among a human being and a bot. The reCaptcha API comes in the form of a widget and it can be Read more…