SQL Transaction in Cakephp 3

written by : Parminder Kaur (Software Engineer)
|
0 Comments
|

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.

Initialize the statement using begin() method.
Execute the statement which includes database query using Read more…

Brief introduction to TinyMCE Editor

written by : Sahil Bhalla (Software Engineer)
|
0 Comments
|

TinyMCE is an editor which lets you create your own editor functionality similar to MsWord. We can manipulate editor code and functionality according to our requirements.
Some features of TinyMCE editor:-
1. It is a stable WYSIWYG HTML editor.
2. It performs on all the browsers (Cross-Browser Performance).
3 Read more…

Moodle | New Database table not getting created

written by : Kritika Sood (Software Engineer)
|
0 Comments
|

In Moodle, we were creating a new table for our custom plugin in db/install.xml file.

Install.xml file:

<TABLES>

<TABLE NAME=”test_student” COMMENT=”Student details.”>

<FIELDS>

<FIELD NAME=”id” TYPE=”int” LENGTH=”10″ NOTNULL=”true” SEQUENCE=”true”/>

<FIELD NAME Read more…

Bit | An introduction to get started

written by : Tanuj Sharma (Software Engineer)
|
0 Comments
|

Git is a distributed version control system. It is a system that records changes in a file or set of files over time so that user can recall previous versions later. As a result of which a user can revert files or project back to previous version, can compare changes Read more…

Salesforce | Toggle button to let TinyMCE editor switch between text or html mode

written by : Kiranpreet Kaur (Software Engineer)
|
0 Comments
|

Situation: We need to use tinyMCE editor for the rich text field so that user can switch from Visual to html editor. It means he can also use html coding or add effects from UI as required. As we know there is a default editor in salesforce for Read more…

Azure | Consumer Web application to crerate copy of SQL Database

written by : Harleen Kaur (Software Engineer)
|
0 Comments
|

Azure provides various rest apis to perform different actions and operations that are possible in the azure server like to create web applications, databases and many more. User can design their own simplified UI to perform actions, instead of logging into Azure and perform all the steps one by one Read more…

Run Apache Tomcat server via cron job and notify an email id

written by : Navneet Kashyap (Senior System Administrator)
|
0 Comments
|

Below is the shell script which can start Apache Tomcat server via cron job and send notification to defined email ids:

1. #!/bin/sh
2.
3. RESULT=`netstat -na | grep 8009 | awk ‘{print $7}’ | wc -l`
4. if [ “$RESULT” != 0 ]; then
echo “TOMCAT IS RUNNING”
5. elif [ “$RESULT” = 0 ]; then Read more…

MySql | Display Latest entries of two columns of two rows into single row

written by : Ishpreet Kaur (Senior Software Engineer)
|
0 Comments
|

Suppose we have two tables : articles and article_comments

CREATE TABLE articles(
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`title` VARCHAR( 200 ) NOT NULL ,
`content` VARCHAR( 500 ) NOT NULL ,
`author_name` VARCHAR( 20 ) DEFAULT 1 NOT NULL ,
`author_email` VARCHAR( 50 ) NOT NULL ,
`created_date` TIMESTAMP NOT NULL DEFAULT ‘0000-00-00 00:00:00 Read more…

Producer and Consumer in RabbitMQ

written by : Kritika Sood (Software Engineer)
|
0 Comments
|

To implement RabbitMQ in our project we need to write the code for producer and consumer.

What is Producer?
Producer produces the messages and sends it to exchange. Exchange receives the messages and routes it to the corresponding queue.

What is Consumer?
Consumer consumes the messages from queue and processes Read more…

Salesforce | Get the field list recursively of related objects

written by : Deepika Saini (Software Engineer)
|
0 Comments
|

If you want to fetch the Field names recursively of Related objects up in Salesforce how to do this?

Solution:- You have to first fetch the field names of one Object Name and scan the list to find the field type of Reference. Then you have to check the Parent Read more…

CakePHP | Get user profile information through Gmail API (2.2.0)

written by : Rita Sharma (Software Consultant)
|
0 Comments
|

Steps to extract user profile information through Gmail API (2.2.0) in CakePHP:

Step1: Set up developer test account inside google api developer console

Use https://console.developers.google.com/ link to open developer console.

Add new project inside your developer console and enable the Google+ API. You will Read more…

How to enable the settings to run the cron using browser in Moodle/Totara

written by : Manju Kashyap (Senior Software Engineer)
|
0 Comments
|

Description: If you need to run the moodle cron job to test any task which will be executed by the cron job then you can do so by typing the following url in the address bar of your browser:
http://localhost/your-moodle-site-name/admin/cron.php

But, if Read more…

AWS | How to start/stop Amazon EC2 server using Lambda Services

written by : Navneet Kashyap (Senior System Administrator)
|
0 Comments
|

If you want to improve utilization of your Amazon EC2 machine instances by stopping and starting instances at specific time intervals then you have to use a CloudWatch Event to trigger a Lambda function to start and stop your EC2 instances at scheduled intervals. Cloud watch is used to schedule Read more…

Zoho CRM | How to hide some account records from view

written by : Kunal Kumar (Software Engineer)
|
0 Comments
|

Zoho does not provide any direct mechanism to hide or unhide account information of any user. However, we have an alternative solution for this problem. We can use a listview to solve this problem. The List view can be used to customize records to show in Zoho.

For example: Suppose Read more…

1and1.com | Create FTP account for specific directory

written by : Ishpreet Kaur (Senior Software Engineer)
|
0 Comments
|

How to create new FTP user on 1and1.com for specific directory

(1.) Login to your 1and1.com account.

(2.) Control panel page will be opened, shown in following screenshot

(3.) Click on Secure FTP Account shown at the left menu of Screenshot 1.
Following screen will be opened.

(4 Read more…

How to integrate CyberSource payment gateway with CakePHP 2.*

written by : Webner
|
0 Comments
|

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:

<?phpRead more…

Handling attachments in IndependentSoft MSG.NET package

written by : Harleen Kaur (Software Engineer)
|
0 Comments
|

(1.) Handling attachments and Embedded content in Body of the Msg file read by IndependentSoft MSG.NET package

As we know that the MSG.NET package by IndependentSoft is used for creating, parsing, reading and converting the Msg email without requiring Outlook to be Installed on System.

The link http Read more…

WordPress | Building custom wordpress theme options panel

written by : Komal Dhiman (Software Engineer)
|
0 Comments
|

With each theme we install, we get its default options panel that provides settings for the theme like color etc. But sometimes there can be requirement of some more options that are not already in theme’s option panel.  So in that case wordpress provides the facility to add our Read more…

Integrate Google Analytics with website

written by : Manju Kashyap (Senior Software Engineer)
|
0 Comments
|

How to integrate Google Analytics with website and enable settings in Google Analytics for tracking various user activities on the website.

When we want to monitor visitors’ activity on our website in Google Analytics for that we need to add a script provided by Google Analytics on every page of Read more…

CakePHP | How to change Epoch timestamp (unix timestamp) timezone in cakephp find query

written by : Kailash Kumar (Software Engineer)
|
0 Comments
|

Suppose we have a table cake_test with a column named modified that contains epoch values.

CakePHP code:
$options = array (
‘fields’ => array (
“modified”,
“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…

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Next page ›
Send your message