Tag: Business Website
How to read csv from S3 bucket and insert into database
While working on a project, we wanted to read csv from s3 bucket, store this data in another local file and insert it into database. We had S3 bucket url where csv was kept. Samp S3 URL -‘http://www.xyz.com/1234.csv’; Below is
PHP | Deleting files from local machine (unlink(): No such file or directory)
Assume following is the path on your system in which you want to delete some files through code (unlink function): C:\wamp\www Now if we use the same address in source variable (“C:\wamp\www”), it gives the following error: unlink(): No such
HTML | Browser Notifications
Below is the sample code to get permission of user to display browser notifications in case he approves. Save the following code in simple HTML file: <script> document.addEventListener(‘DOMContentLoaded’, function () { if (Notification.permission !== “granted”) { Notification.requestPermission(); } }); function
JavaScript/HTML | Get Id of inner child element
Suppose from html code below we want to get id of each <a> element inside home_menu. <ul id=”home_menu” class=”appendmenu” style=”float: left”> <li> <span class=”arrow sep”>►</span> <a id=”breadcrumb_mainc3″ style=”cursor:pointer;color:#087bb1;”>Programming Courses</a> </li> <li> <span class=”arrow sep”>►</span> <a id=”breadcrumb_sc34″ style=”cursor:pointer;color:#087bb1;”>Javascript </a> </li> <li>
Javascript | How to change form action dynamically
Suppose on click of an element we want to change the form action URL. In this example, we are assuming a textbox in which user will type a value and then click search magnifying glass icon. On click of search
Netsuite | Authentication/Login to Netsuite sandbox account through java code using Netsuite WSDL
Authentication/Login to Netsuite sandbox account through java code using Netsuite WSDL In order to login to your sandbox Netsuite sandbox account via code, you need to have below files handy: 1. Netsuite sandbox WSDL: The latest version of wsdl can
Mysql Workbench | How to copy Remote database into your local machine
1. Select Database: Schema Transfer Wizard from the Mysql workbench menu bar. You will see schema transfer wizard on your screen as below: Click on Start the Wizard option. 2. Connection Selection: Now select your source and destination location to copy database:
How to send SMS through code
There are many SMS sending gateways that provide REST services to send SMS. You need to register and purchase credits first before SMS can be sent. One such gateway is ClickaTell: Click to view Below is the sample REST call
Using UNION syntax in CakePHP 2.4.6
Following UNION syntax works properly in CakePHP 2.4.6 version but it doesn’t work in CakePHP 2.5.2 version: $unionQuery = $dbo->buildStatement ( array( ‘fields’ => array( required fields), ‘table’ => $dbo->fullTableName(database_table_name), ‘alias’ => ‘customObject1’, ‘limit’ => null, ‘offset’ => null, ‘joins’