If you want to upload a csv file have large number of records and you don’t want to use any loop statement then You can use MySQL’s LOAD DATA INFILE statement to…
Category: MySQL
What is the difference between mysqli_fetch_array and mysqli_fetch_assoc?
Both mysqli_fetch_array and mysqli_fetch_assoc are PHP functions used to fetch rows from a MySQL database result set. However, they differ in how they return the fetched data. Example usage of mysqli_fetch_array: Example…
How to send push notification using PHP code to Android Mobile App
To send push notifications from PHP to an Android mobile app, you’ll need to use Firebase Cloud Messaging (FCM). Here are the basic steps: Here’s some sample PHP code to get you…
How to create pdf file from MySQL result in PHP?
To create a PDF file from MySQL results in PHP, you can use a library such as TCPDF or FPDF. Here’s an example using TCPDF:
How to save MySQL result to an array using php?
To save a MySQLi result to a MySQL array using procedural code, you can use the mysqli_fetch_array() function in a loop to fetch each row of the result set and add it…
How to upload and import multiple excel file into MySQL table using PHP without using LOAD DATA INFILE ?
If you cannot use the LOAD DATA INFILE statement to import Excel data into MySQL, you can alternatively use a PHP library to read the Excel files and insert the data into…
How to upload and import multiple excel file into MySQL table using PHP?
To upload and import multiple Excel files into a MySQL table using PHP, you can follow these steps: 1 Create an HTML form that allows the user to select multiple Excel files…
How to upload csv file and import data in MySQL table ?
If we have large amount of data in excel file and we need to import that data into a MySQL table we need to first convert the excel file into a .csv…
How to use DataTables in PHP for showing MySQL results?
To use DataTables in PHP for showing MySQL results, you can follow these steps: 3. Retrieve the data from MySQL using a PHP script, and encode it as a JSON object. Here’s…
How to implement paging in php for mysql result?
Paging in PHP for MySQL result can be implemented using LIMIT and OFFSET in the MySQL query. Here’s an example code snippet that you can use as a starting point: In the…