Write Data to CSV File in PHP: Step-by-Step Guide
By byanjankarsujan
The process to write submitted data to a CSV file in PHP involves retrieving the data from the $_POST superglobal array, opening a CSV file for writing using fopen(), creating an array of the data, writing the array as a CSV row to the file using fputcsv(), and closing the file using fclose(). 1. Retrieve […]
Submit HTML Form to Google Sheets with PHP
Submit HTML form to Google sheets is convenient when we have requirement to just collect data form user or customers, while maintaining corporate consistency, without costly development. We can create a form in our website and save submitted form data in google sheets.
UUIDs in Laravel/Lumen applications with eloquent
By byanjankarsujan
Universal Unique Identifier (UUID) is a 128-bit string used to uniquely identify objects/resources in computer systems. It also termed as Global Unique Identifier (GUID). The probability of duplicated UUID not zero, but close enough to be zero, to be negligible. We can use UUIDs in Laravel as primary key of records in our database.
Data Encryption with Eloquent – Laravel
By byanjankarsujan
Few weeks back, one of my client asked me about the possibility of data encryption of his customers data, stored in database. It would be unusable, even if someone got the dump of those data. But those data should be usable and readable in his existing applications. My client has app built on built on […]
LDAP Authentication in Laravel Application
By byanjankarsujan
LDAP stands for Lightweight Directory Access Protocol. It is a lightweight client-server protocol for accessing directory services. A directory is similar to database but contains more descriptive and attribute -based information. It is a hierarchical database where data is stored in tree like structure, where leaf node holds the actual data. Microsoft Active Directory, Oracle […]
Custom Artisan command: Create one
By byanjankarsujan
Artisan is the command-line interface included with Laravel, driven by Symfony Console component. It provides an awesome set of useful and most often used commands to help in app development with Laravel. But it includes the common and widely used command set only, that sometime might not be enough for our app development. For such […]
Install PHP on IIS Windows Server – Web Platform Installer
By byanjankarsujan
Install PHP in IIS WIndows Server with Microsoft Web Platform Installer to run PHP applications. PHP is the popular server-side programming language to build websites and web applications. Most of the web hosts supports PHP and has good collection of libraries to cut the development time. But it is not supported by IIS out-of-the-box. Why […]
Oracle Instant Client setup in Ubuntu
By byanjankarsujan
Setup Oracle Instant Client in Ubuntu machine for connection to oracle database PHP oci8 extension