11 02, 2019

Invalid value for header \u0067x-ms-request-id\u0067

2019-02-11T12:48:45+00:00February 11, 2019|Database|0 Comments

|
| ByWebner

Resolved Issue “Invalid value for header \u0067x-ms-request-id\u0067. The header must contain a single valid GUID” I was facing the issue “Invalid value for header \u0067x-ms-request-id\u0067. The header must contain a single valid GUID” while making request to the Azure Database [...]

27 08, 2018

Sending email using Amazon SES service

2018-08-28T05:50:10+00:00August 27, 2018|Database|0 Comments

|
| ByWebner

Sending email with or without Attachment using Amazon SES service First download the aws library using the this link: http://docs.aws.amazon.com/aws-sdk-php/v3/download/aws.zip link and save it in project. Now the usage of library is below where we write the code to send [...]

17 08, 2018

PostgreSQL – Server doesn’t listen error

2018-08-17T12:30:30+00:00August 17, 2018|Database|0 Comments

|
| ByWebner

How to fix PostgreSQL server doesn’t listen error While trying to connect to Postgress you may face this error - Server doesn’t listen. Error: This is not an error exactly but an exception that occurs when we are running two [...]

7 08, 2018

Improve SQL query performance

2018-08-07T12:27:59+00:00August 7, 2018|Database|0 Comments

|
| ByWebner

Tips to improve SQL query performance 1. Avoid usage of multiple joins in a single query. Unnecessary joins degrade your query performance. 2. Creation of indexes on the table. Indexes are used for improving your queries. We need to create [...]

29 03, 2018

MySQL | Communications link failure

2018-04-05T07:34:54+00:00March 29, 2018|Database|0 Comments

|
| ByWebner

MySql Communication link failure while connecting MySql server remotely I'm getting the following error when I tried to connect MySql server remotely: ERROR: ------------------------------------------ Cannot connect to database server Communications link failure The last packet sent successfully to the server [...]

16 10, 2017

SQL Transaction in Cakephp 3

2017-11-14T09:40:55+00:00October 16, 2017|Database, PHP Frameworks|0 Comments

|
| ByWebner

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 [...]

10 07, 2017

Moodle: Performing search through wildcard queries with ‘Like’ operator

2017-07-10T08:46:42+00:00July 10, 2017|Database, Web Development|0 Comments

|
| ByWebner

‘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 [...]

Go to Top