CakePHP | How to handle special characters (like apostrophes) in queries

| By Webner

Let us take an example: We have table employees with following fields: id int primary key, name varchar(50), city varchar(50) We have following records in the table: (1, isha, amr); (2, Hamlet’s, ghy); (3, éhjj, amr); 2nd and 3rd records

Salesforce | Data Loader Application error about upgrade to TLS 1.1 or Higher

| By Webner

You may receive receive error in Salesforce Data Loader Application about upgrade of TLS 1.1 or Higher. To resolve this issue follow these steps: Step 1: Install latest version of Java. Step 2: Goto setup in Salesforce > type Data

PostgreSQL | Create a connection to a local postgres database in pgAdmin |||

| By Webner

Steps to create a connection to a local postgres database in pgAdmin ||| : 1. Make sure PostgresSql and its components should be installed in ubuntu system. 2. Check what databases are available in postgresSql through terminal 3. Login to

MYSQL | #1293 – Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP

| By Webner

Suppose we want to have columns created_date and last_modified_time with default timestamp in any table in MySQL/Phpmyadmin. Let us take an example of Students table. Create table Students using following query : CREATE TABLE students( id INT AUTO_INCREMENT PRIMARY KEY

CakePHP | How to implement Internationalization in CakePHP 3.X

| By Webner

To implement Internationalization, CakePHP will pick all your strings which start with “__(“ double underscore ) and generate a default file for you. For Example: one of the strings defined in our project is as below: echo __ ( ‘ Gift

Selenium | How to perform search with Selenium script

| By Webner

In this post I will give an example of how to perform search with Selenium script on a webpage. Below is the screenshot of the webpage: Code to automatically enter a keyword “paint” in the textbox and then click Search