php

https://www.webslesson.info/2016/02/export-mysql-data-to-excel-in-php-php-tutorial.html This tutorial will learn you How to export Mysql data from web application to Excel file using PHP programming language. This functionality is mostly required in enterprise level web application. There are lots of data are transfer on daily basis and manage that into separate excel file. So, at that time this type of functionality is required in web application. This functionality reduce lots of time to take data into excel file. In this simple post we have learn something regarding  how to export data to Excel in PHP . If you have developed any project then that project you have to required this functionality like Exporting Data to Excel Sheet. So we have developed this tutorial, in which we have make simple PHP Script for Export Data from Web to Excel. Online Demo Export MySQL data to Excel in PHP Name Address City Postal Code Country Maria Anders Obere Str. 57 Berlin 12...

Generate QR Code using PHP Library https://reeteshghimire.com.np/2020/03/10/generate-qr-code-using-php-library/ Format Numbers in PHP ( like 1.2K, 3.1M, 2.5B ) https://reeteshghimire.com.np/2020/03/06/format-numbers-in-php-like-1-2k-3-1m-2-5b/ Calculate Distance between two location with Latitude Longitude using PHP https://reeteshghimire.com.np/2020/03/24/calculate-distance-between-to-location-with-latitude-longitude-using-php/ Free JSON API for News and Blog Articles https://reeteshghimire.com.np/2020/03/26/free-json-api-for-news-and-blog-articles/ Responsive FileManager as Standalone File Manager https://reeteshghimire.com.np/2020/03/31/responsive-filemanager-as-standalone-file-manager/ Install Laravel on Ubuntu with 4 simple steps https://reeteshghimire.com.np/2020/04/05/install-laravel-on-ubuntu-with-4-simple-steps/ Multiple File Upload with HTML and PHP https://reeteshghimire.com.np/2020/04/07/multiple-file-uplo...

https://reeteshghimire.com.np/2020/03/10/generate-qr-code-using-php-library/ According to Wikipedia, QR code (Quick Response Code) is the trademark for a type of matrix barcode (or two-dimensional barcode) first designed in 1994 for the automotive industry in Japan. A barcode is a machine-readable optical label that contains information about the item to which it is attached. In practice, QR codes often contain data for a locator, identifier, or tracker that points to a website or application. A QR code uses four standardized encoding modes (numeric, alphanumeric, byte/binary, and kanji) to store data efficiently; extensions may also be used. Installation Install endroid/qr-code library using composer $ composer require endroid/qr-code GitHub Link Here :  QR Code Generator First Download the library and then create a index.php file with the following code in it: <?php include ( 'vendor/autoload.php' ) ; use Endroid\QrCode\QrCode; $qrCode = new Q...

http://reeteshghimire.com.np/2019/07/04/backup-restore-mysql-database-using-php/ https://stackoverflow.com/questions/22195493/export-mysql-database-using-php-only <?php $connection = mysqli_connect ( 'localhost' , 'root' , '' , 'quiz' ) ; $tables = array ( ) ; $result = mysqli_query ( $connection, "SHOW TABLES" ) ; while ( $row = mysqli_fetch_row ( $result ) ) { $tables [ ] = $row [ 0 ] ; } $return = '' ; foreach ( $tables as $table ) { $result = mysqli_query ( $connection, "SELECT * FROM " .$table ) ; $num_fields = mysqli_num_fields ( $result ) ; $return .= 'DROP TABLE ' .$table. ';' ; $row2 = mysqli_fetch_row ( mysqli_query ( $connection, "SHOW CREATE TABLE " .$table ) ) ; $return .= "\n\n" .$row2 [ 1 ] . ";\n\n" ; for ( $i= 0 ;$i<$num_fields;$i++ ) { while ( $row = mysqli_fetch_row ( $result ) ) { $return .= "I...