From Core to Advanced
In this tutorial, I will show you exactly how to validate a GSTIN in PHP using regex, with a checksum verification so you catch even subtly wrong numbers. I have also built a free live GSTIN validator tool at the bottom of this post — paste any GSTIN and it validates instantly. Hi friends, actually i was … Read more
Hi friends , in this article you will come to know about an important tool which is used to find duplicates in excel online and remove duplicates in excel 2026. Actually I was wondering in the internet to find a tool in order to remove duplicate data whether it is a csv file or excel … Read more
Hi friends, in this tutorial, you will learn how to send PHP curl post request to any URL and API endpoints. Before getting started with the tutorial, you must know the concept of CURL following with an example. What is CURL in PHP In PHP, cURL (Client URL Library) is a powerful and widely used … Read more
Hi friends, in this tutorial you will learn how to do the CCAvenue payment gateway integration in PHP. CCAvenue is one of India’s top payment gateways, including multiple payment options such as 200+ Mastercard, visa, Rupay, Netbanking, Wallet payments, UPI payments, etc., along with multi-currency options. This payment gateway is very fast, simple, and secure … Read more
Hi friends, in this tutorial, you will learn how to resolve SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table users add unique users_email_unique(email)). This error occurs when we run the database migrations in any of the Laravel projects with the help of … Read more
Hi friends, in this tutorial, you will learn how to export database in phpmyadmin. This is very simple and I am going to discuss it in a step-by-step process. As we all know that to run php programs or to establish a connection to the MySQL database with the PHP programs, we need a server … Read more
Hi friends, in this tutorial, you will learn how to select first 10 rows from MySQL using PHP. This kind of query is required very often when you need a certain number of rows from your MySQL database to display in the application or in the browser. Also read, Delete a row in MySQL There … Read more
Hi friends, in this tutorial, you will learn how to calculate balance from credit and debit using PHP MySQL and get the direct code you can use to calculate running balances from the ledger. If you are wondering how to accomplish this task then you have come to the right place. This is very important and often … Read more
Hi friends, in this tutorial, you will learn how to export data from MySQL to excel using PHP. It is often required in the case of web development or any kind of web application and there are various packages available online to do this task but here I have explained without any package. Also read, … Read more
Hi friends, in this tutorial you will learn how to delete a row in MySQL. Actually, there are two ways by which you can perform the delete operations in MySQL. In order to do so, you must have some data inside the table of your database. Suppose, I have table ‘employee‘ in my database as … Read more