Sometimes requirement arises to display a field value as column name in output and adjacent values in the same row below it as its values.
Suppose I have a table “students” with marks of each student in different subjects. Each student may not appear in every subject:
students
We want Read more…
Steps to auto generate AWS S3 Policy that you can use to provide access rights according to requirement:
→ Open S3 from AWS console:
1. Click on AWS bucket
2. Now, click properties
3. Click on Add bucket policy:
4. Now, Click on AWS Policy Generator:
Else use the Read more…
Description:
We are registering our customers using Stripe payment gateway where we are storing customer card details. We are doing recurring payment for customers periodic billing cycle. But if customer’s card expires or card number changes, we will not get any information about that and our billing cycle will Read more…
How to set logout URL for customer portal:
-> Go to Quick find box and write customer portal settings.
-> Now, open the portal that you want to edit.
-> Click on the edit button:
-> Enter the URL under the portal default setting→logout URL.
Note Read more…
Step to insert PHP Page in Salesforce:
1. Go to setup->Create->Tabs in Salesforce:
2. Under Web Tab, click on new button. Now you can select the Page layout you want to set – full page width or 2 columns with Salesforce.com slider:
3. Fill Read more…
AngularJS 2 is the most popular Framework of Javascript which is used to build Web/Mobile applications in html and javascript. AngularJS 2 has the abilities to build apps for web, mobile web, native mobile and native desktop and it has features like Web Workers and server-side rendering.
Read more…
Error: Blocked a frame with origin “http://xxx.xxx.xxx.xxx” from accessing a frame with origin “http://xxxxx:xxx”. Protocols, domains, and ports must match.
Scenario: We have a cakephp website. In one webpage say “Parent Page” of this website we have used iframe to Read more…
To download attachments from Zoho CRM from a module, like Contacts, fetch detail of all the attachments related to that module, then download each attachment by its attachment id using download file API in Zoho and finally convert blob to the image file.
For Examle: Download attachment from Read more…
Error: Call to a member function schema() on a non-object
File: /home/user/git/!defaultRepo!/Appname/lib/Cake/Model/Datasource/Database/Postgres.php
Line: 404
Description: I was trying to execute the following cake query to fetch the records:
$records = $this->find ( ‘all’, array Read more…
Stripe payment gateway provides different webhook events like customer_created, customer_source_updated, customer_deleted and so on. By setting up our webhook urls to the events provided by Stripe, we can capture the Stripe event requests and can write our own customer code. Now there is a problem with security. If our url Read more…
Regular expressions provide a powerful way of adding validations to the web forms.
To allow UTF encoded characters (Letters) either UTF -8 or UTF -16 like Á á É é Í ÑÓ ¿ € ₧ å ∫ ç ∂´ƒ ©˙ ∆˚ ¬µ ˜ø π œ ® ß † ¨√ ∑ ≈ ¥ Ω ¡™ £ ¢¡™£¢∞§ ¶
Use Regex expression \p{L}
Here L stands for ‘Letter’ from any language. It includes all the utf encoded characters from all Read more…
Solution: When you have a drive which is encrypted and password protected and you want the drive to be mounted automatically at startup below are the steps that you can use:
Step 1. Open the encrypted drive as you usually do and mount it to any location.
Read more…
Problem: I was unable to launch the latest Firefox browser 54.0 with Selenium 3
Solution: Earlier I was using the Firefox version 43.0 and I was able to launch the Firefox properly with my selenium script. But recently I have updated my Firefox browser from 43 to latest Read more…
SOLVING DATABASE TABLE PREFIX ISSUE IN WORDPRESS
When we create WordPress plugins then we generally need to create new tables for storing some data. As plugin should generally work on any WordPress site so it is important to keep in mind that the queries must work on all Read more…
Two ways to see deployed app files on Azure server.
1. Azure scm
2. Ftp publish settings file.
1. Azure scm:
Azure has its service site scm where you can view your deployed files. For that you must have the azure credentials where the Web app is deployed 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…
Create a new Salesforce customer portal:
1. Go to quick find box and type customer portal.
2. Click on customer portal settings.
3. Click edit and enable customer portal.
4. click save.
Now after enabling customer portal feature, we can create a customer portal:
=> Go Read more…
Number of stages for a software, before it is released, may vary project to project and company to company. But in general pre-alpha (nightly builds, which may not have all features implemented), alpha (with all requirements implemented, unit-tested but before testing by QA), beta (after Alpha-testing by Read more…
What is the importance of image sprite in html and how these Sprite images can be used in html and css?
Image sprite is a collection of different images put into a single image. Image sprites are are used in web pages to lower down the bandwidth and the page Read more…
Suppose have a data table as below:
Screenshot 1
HTML for table is:
<table id=”productsTable” class=”table table-striped table-bordered table-hover dataTable no-footer table-custom-style”>
<thead>
<tr>
<th>#</th>
<th>Product Name< Read more…
