In my recent project, we have developed a small process monitoring system to check the health of the process and it should send emails if the process goes down. For sending emails we have used SendGrid and below is the […]
How to get last inserted id in Laravel
In this post, I would like to show the different ways to get last inserted ID from the database table when working with Laravel PHP Framework. In the core PHP, we will get last inserted ID with mysqli_insert_id() or PDO::lastInsertId() […]
How to get Mysql Table Comments
Let’s assume that we have a table with the following table schema:
|
1 2 3 4 5 |
CREATE TABLE employee ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT COMMENT 'The primary key for employee', name varchar(50) NOT NULL COMMENT 'The name of the employee', about TEXT NOT NULL COMMENT 'Short note about this employee' ) COMMENT='Table which holds data about employee'; |
|
1 |
SHOW FULL COLUMNS FROM employee; |
Merging PDFs using PHP and ghostscript
In this post, We will show you how you can use Ghostscript with PHP to merge multiple PDF files into single file. Using Ghostscript, it is possible to merge multiple PDF files into a single PDF file with a single command […]
How to use Twilio to send SMS with CodeIgniter
In this CodeIgniter Twilio tutorial, I would like to show sending SMS from the CodeIgniter app using the Twilio library. Twilio is a cloud communications platform for building SMS, Voice & Messaging applications. Here […]
How to list all globally installed NPM packages
Below is the npm command to view globally installed NPM packages. If you want to view current directory’s packages just execute the same command without the -g option.
|
1 |
$ npm list -g --depth=0 |
How to disable IPv6 on Ubuntu
In this post, I will show you disabling IPv6 on your Ubuntu machine. Before going further, let’s check the current status of the IPv6 on your machine. To check the status, open up the terminal and enter the following […]
How to serve node Socket IO connections with NGINX reverse Proxy
In this post, I would like to show you the configuration of Nginx web server to serve Socket IO connections with Nginx reverse proxy. Open your Nginx configuration file with vi or any other editor:
|
1 |
$ sudo vi /etc/nginx/sites-available/default |
How to insert data into database with CodeIgniter
In this post, I will show inserting data into database table using CodeIgniter. We gonna use CodeIgniter Active Records Pattern. This pattern allows information to be retrieved, inserted, and updated in your database with […]
How to Enable CSRF (Cross-Site Request Forgery) in CodeIgniter
In this post, I will show you enabling CSRF token in your CodeIgniter application. To enable CSRF (Cross-Site Request Forgery) protection in CodeIgniter open application/config/config.php file change $config[‘csrf_protection’] […]
