Exporting MySQL Data to Excel using PHP - Learn infinity

Post Details:
Export to Excel
SNo. Post Name Post Description
1) D X
2) Rewrerw Erwrewr
3) Rewrerw Erwrewr
4) Hgfhdfgfdg Dsfdsfdsf
5) S S
6) Ewtyterg Grweg45g45g4w5g4
7) Xddn Nnncnfnn
8) Tessw Fgsegs
9) Kkkkkkkkkk Kkkkkkkkkkkkkk
10) Hello How are you my self
11) Angular Asdf
12) Post PostWeb post
13) Hugo Hugo is back
14) Sds Sdsd
15) Dfgh dfgh dfgh Dfgh dfgh dfgh
16) Rtyertyer Tyerty erty erty erty erty erty
17) 34563456 3456345634
18) Test Description
19) Ert Tet
20) 456456 456456
21) Weqeq Eqwe
22) Ddd Dddd
23) Op'[ Io[i
24) Re Kp
25) Sdf Sdfsdf
26) Gfdgdf Dfgdfg
27) Bhdfh Fghdfhdf
28) Hhg Ghhfg
29) T T
30) Afasf Asfa
31) Fsaf Afsfa
32) Hello မမမမမမမအမမမအအအအ
33) Re Rte
34) Sdasdassdadsadasdadasdasdasdsa Sadsadsad
35) Grthtgh Fhggfhg
36) Werwerwe Ewrwrwterwt
37) Asdv Sdc
38) Sss Asssssssssssss
39) Gffg Fghfghfghf
40) Fghf Hgfhgfhgfh
41) 3333 333
42) Eeee Eee
43) Hfg Ghfg
44) Ghghff Hgfhgj
45) Ghghff Hgfhgj
46) Ghghff Hgfhgj
47) Ghghff Hgfhgj
48) Ghghff Hgfhgj
49) Sas Asasas
50) Ghg Hfhf
51) ,n,l ,lklki
52) ;,';,afe,fdv d D ae; ;ea; ea;v ell;dm
53) Qwd Wqdw
54) Qwd Qwdqwd
55) Wqd Qwd
56) Jw Wj
57) Asasas Sasasasasas
58) Xzxzx Zxzxxz
59) D D
60) Jkl Hjk
61) Hjkl Ghygjhg jh h
62) Qwqqwqw Eweweweweewqwqwqwqwqwqwqwqwqwqw
63) Qwdqwd Qwddqw
64) Dqwd Qwddqwd
65) Rtretre Rtretre
66) Asndjnasjdn Asdajsdiasjdiasj
67) G Hh
68) Ol Lmlmlmlmlmlnk
69) Abc Avhsdbbdsn
70) Scadsdadas Asfdwe,lwjbklefnblewnc
71) Test Test
72) Diquery Digital Dsaddsdsdsdasdasdsdasd
73) Ttt Jjj
74) Fdfdf Dfdfdf
75) Dsfdsfsf Dsfdsfds
76) Dsfss Dsfdss
77) Xccvxc Cxvcxvxc
78) A A
79) Test Tttttttttttttttttt
80) A AA
81) Gnn Vbnvbnbv
82) חחח Ad
83) Hgjh Ggh
84) Ід Ід
85) Ід Вад
86) Вася Кітура
87) Вася Восм євл е млк
88) Dfjfh Ghnj
89) Juju Juju
90) Gjgh Jhgjhgj
91) Diquery Digital Form Submission With Validation Using AngularJS and PHP - Learn infinity
92) 2131231 23123123
93) Q4234 4234
94) 12312 3123
95) Ddfsfs Sfsf111111
96) D X
97) Mdnfmndm Fdsadfds
98) Mdnfmndm Fdsadfds
99) Oioui Ouiouio
100) Iyuiyu Iyuiyu
101) Adadsa Asdsadasd
102) Dasdasdsad Asdsadsadsa
103) Dsfsdf Dfsdf
104) Test Test description
105) Fffg Hhhh
106) Hfghf Ghfgh
107) Test Test Description
108) Sdsfdgf Aedsrfdgf
109) Qw Sds
110) D F
111) Eccxcc Hhfxvbbxx
112) Gf Fdd
113) Gf Fdd
114) Gf Fdd
115) Gf Fdd
116) Gf Fdd
117) Gf Fdd
118) Dfgd Gdsfgds
119) Asdfsd Asdasd
120) Hhhh Hhhh
121) Hhhh Hhhh
122) Fghg Gfhd
123) Dqweqwe Qweqweqw
124) Cf Asdasdcvsad
125) FILE UPLOAD USING MULTER IN NODE.JS AND EXPRESS In this post, we are going to know about File Upload Using Multer in Node.js and Express and it also helps us to understand about file handling. For this process following packages are used Express, Multer, and Body-parser.
126) CRUD OPERATION USING NODEJS EXPRESSJS MYSQL This post explains how we can build a CRUD using NodeJS ExpressJS MySQL database. Here we are going to use Express Framework and EJS as a template engine to build a CRUD operation. For CRUD operation we will use HTTP Methods to make our application.
127) PERFORMANCE BOOSTER USING MODEL CACHING IN LARAVEL 5.6 Hi, in this post we learn about Performance Booster Using Model Caching in Laravel 5.6. Nowadays most of the business and nonbusiness operation are running in web-based application only. In that, we are always facing worst page loading speed and query execution time to get operation data from a database.
128) LARAVEL LOG VIEWER USING LOGVIEWER PACKAGE IN LARAVEL 5.6 Hi, In this post we are going to know about Laravel Log Viewer using LogViewer Package in Laravel 5.6. As default Laravel Framework have a log file and it always keeps all runtime error & exception like Query error, URL not defined properly, Database exceptions Ect.
129) REST API USING LARAVEL 5 In this post, we are going to learn about REST API using Laravel 5 and MySQL. A RESTful web service helps us to perform CRUD operations with a database. In this post which is part of the REST API series, let us learn how to perform an easy and simple CRUD REST API using Laravel
130) CHARTS IN LARAVEL 5 USING CHARTS PACKAGE In this post, we will know how to display user data into graphical or Charts In Laravel 5 Using Charts Package. It helps us with our blog and application data analyzing and current system status. Most of the application need this kind of graphical or chart data representation to the user
131) EVENT CALENDAR IN LARAVEL 5 USING LARAVEL-FULLCALENDAR In this post, we are going to know how to make event calendar in Laravel 5 application. Nowadays most of the website will like to show our plan, holidays, schedule, events, tasks etc on a calendar that means we can see when starting date and ending date for every event
132) Server Side Datatable Using Laravel 5 In this post, we are going to know about Server Side Datatable using Laravel 5. Data Table is one of the most important plugins in jQuery Library. It provides the lot of user-friendly functionalities like sort, pagination, and searches etc to handle the database data in our web pages. In laravel, we can implement this Server Side Datatable using yajra/laravel-datatables-oracle package. It provides full data table functionalities in our laravel web applications. Server Side Datatable help us to load web page faster than normal HTML table.
133) Import and Export Excel and CSV in Laravel 5 Using maatwebsite In this post, we are going to learn about how to Import and Export Excel and CSV in Laravel 5 Using maatwebsite. Here I give a tutorial for import data from Excel & CSV into a database and also exporting data to Excel & CSV from a database using Laravel maatwebsite package. Laravel maatwebsite package helps us to do this import and export using Excel and CSV process as a very simplified method.
134) Laravel 5 API Authentication Using Passport In this post, I’m going to share how to build REST API web services authentication in Laravel 5 application using API Passport package. Nowadays Web services are very necessary while we are creating Web and Mobile application developing for multiple platform purpose. We need to create API for our mobile application developer. We understand Laravel is very popular and popular because of secure API. Laravel provides Passport package for secure API authentication. Passport package provides OAuth2, JWT authentication to access the web server using API.
135) Optimize Website Speed and Performance in Laravel 5.5 In this post, we are going to know how to Optimize website speed and performance of our application it will help us to improve or increase loading time twice. It is essential for each and every website or application to load faster load that means your website should load in fewer seconds like 4s or 5s. We are always facing issues regarding page load speed like how to improve website or application speed in laravel, how to decrease the loading time of website or application in laravel, and primarily, we have many questions about how to increase or improve our website performance in laravel.
136) Image Upload and Resize it using PHP In this post, we are going to know image processing like resizing, thumbnails and creating a new image with required file format and size with an uploaded image using PHP. Here we going to use simple PHP code for image upload and resize that image with the help of user-submitted image file data. Nowadays web-based applications are focused to share data, image files and documents to improve their personal profiles or promoting etc. As we all well know the importance of displaying the images on our website and applications.
137) Drag and Drop Table Row Sorting (Ajax, PHP and MySQLi) cvbzx In this post, We are going to know how to do Drag and Drop Table Row Sorting with Ajax and PHP script without a refresh of the page. Using this function we can quickly sort or re-order table row data with an easy user interface and Drag and Drop HTML element very useful us to a done table row sorting. Here we have used JQuery UI Drag and Drop library Sortable() function and using this function we can easily move any HTML element from one area to another and the particular element will be placed automatically and it will be sort element.
138) IMPORT XML DATA INTO MYSQL DATABASE (AJAX, PHP AND PDO) In this article, we are going to know how to Import XML Data into Mysql Database table by using PHP code with Ajax. We all know XML stands for eXtensible Markup Language and it is used for to save and read data on the web and this data readable format for human and machine also.
139) LIVE DATA SEARCH (AJAX, PHP AND MYSQLI) In this post, we are going to learn Ajax Live Data Search with a help of PHP, MySQLi and Ajax. In real-time most of the website and web applications providing content search option to make the application as most user-friendly.
140) Form Submission With Validation Using AngularJS and PHP In this post, we are going to learn How to submit form data to PHP script by using AngularJS. In modern web development, many of technology used to submit a form data to the server script. Nowadays AngularJS is one of the technique use front-end technology it will manage by Google Inc on their hosted library. Here we will handle form data submission by using AngularJS and we will make necessary field validation by using AngularJS form valid or PHP Script.
141) LOAD MORE DATA ON PAGE SCROLL (AJAX, PHP AND MYSQLI) In this post, we will see how we can load more post details list with the help of Ajax. This technique helps us to load the page quickly. At the initial page load time have some limited post details only. Whenever the page scrolling at end of the page it trigger the ajax request to server and get and load specified list of the post details at the end of the post list container. Load more data method is very useful because the data is loaded without loading or redirecting the page.
142) CRUD REST API USING PHP AND MySQLi In this post, we are going to learn about REST API implementation using PHP and MySQLi. A RESTful web service helps us to perform CRUD operations with MySQL database. In this post which is part of the REST API series, let us learn how to implement an easy and simple CRUD REST API using PHP and MySQLi for Create, Read, Update and Delete operations. The entire process will be handled with a help of core PHP not be using any framework as dependencies.
143) DISPLAY SWEET ALERT IN LARAVEL USING UXWEB/SWEET-ALERT In this post, we are going to learn to show notify information with an excellent user-friendly look using sweetAlert package in laravel application. Here we are going to use uxweb/sweet-alert package for Display Sweet Alert Notifications in Laravel web application.
144) GENERATE A WORD DOCUMENT USING PHPWORD IN LARAVEL In this post, we going to see how to generate word doc and docx file using phpword package in Laravel. Nowadays some user needs to export data into a word file for offline usages. Some of the client to give their relevant data like Terms and conditions, Private policy and Copyrights details into pdf or word document format. For this kind of purpose, it will help us to generate word file in laravel using phpoffice/phpword package.
145) 3-DIMENSIONAL(3D) PORTFOLIO IMAGE GALLERY USING HTML & CSS The Portfolio details is a very useful feature of the web page. You can establish your archived details and the works to the entire web community. It was outlined to bring in extra clients, get you selected based on this details.
146) GET WORDPRESS BLOG POST AND SHOW IN ANY PAGE In WordPress blog, our latest posts are publicized on the home page, and older posts access with the help of post page navigation. In this post, we are going to learn how to display our WordPress blog posts on any static or dynamic page using a simplexml_load_file() method with ATOM that works to get WordPress blog post details as XML data with domain link.
147) YOUTUBE CHANNEL VIDEO IMPORTING USING DATA API & PHP The YouTube Data API provides an easy way to access YouTube channel videos and include into our web application. The different sources package will get video details from YouTube channel using Data API. If we need to import and display YouTube video gallery on our web page means, YouTube Data API will help us to do this.
148) EXPORTING MYSQL DATA TO EXCEL USING PHP Exporting MySQL Data into Excel is a very useful method to keep the data list in a relevant area for offline usage. Exporting data method performs your web application as most user-friendly and improves the user to manage list data in offline.
149) GENERATE A PDF USING TCPDF IN LARAVEL In this post, we are going to know about generating PDF documents using TCPDF Package in Laravel. Most of the application needs to generate pdf documents for many reasons. It may use to produce E-Document for end user knowledge or reference. It helps to prepare Invoice bills, profile information, reports download etc.
150) SUGGESTION FIELD USING JQUERY, PHP AND MYSQL Suggestion field using jQuery is very useful for a web application. In this post, you will learn how to perform Google-like search textbox in PHP. Using jQuery UI we can efficiently show relevant suggestion from the database under a textbox.
151) IMAGE TO GRAYSCALE IMAGE CONVERSION IN LARAVEL In this post, I am going to share with you how to make a grayscale image from the original image in laravel. Sometimes, we may require making a grayscale image when user uploads image. The grayscale image looks better if you have a good layout website.
152) DELETE OPERATION IN CRUD USING PDO – PART 4 This post explains how to build a CRUD (Create, Read, Update, Delete) application in PHP & MySQL using PHP Data Objects (PDO). PDO is a PHP extension that implements an interface for accessing databases in PHP. PDO is compact and strong.
153) UPDATE OPERATION IN CRUD USING PDO – PART 3 This post explains how to build a CRUD (Create, Read, Update, Delete) application in PHP & MySQL using PHP Data Objects (PDO). PDO is a PHP extension that implements an interface for accessing databases in PHP. PDO is compact and strong.
154) READ OPERATION IN CRUD USING PDO – PART 2 This post explains how to build a CRUD (Create, Read, Update, Delete) application in PHP & MySQL using PHP Data Objects (PDO). PDO is a PHP extension that implements an interface for accessing databases in PHP. PDO is compact and strong.
155) CREATE OPERATION IN CRUD USING PDO – PART 1 This post explains how to build a CRUD (Create, Read, Update, Delete) application in PHP & MySQL using PHP Data Objects (PDO). PDO is a PHP extension that implements an interface for accessing databases in PHP. PDO is compact and strong.
156) SECURE FORM DATA SUBMISSION AND HANDLING WITH GOOGLE RECAPTCHA In many cases, we want to identify where the form request raised by human, robots or spammers. For a secure application, we need to identify form request raised by human only. To enable this Google reCaptcha API to help us to do this checking process.
157) CASCADING DROPDOWN LIST USING JSON DATA In this post, I show you how to create a cascading dropdown list with JSON datasets. The relevant list fields will load the data list with help of dependent selected list value. The dependent selected list are filed with the help of chosen data without a refresh of the page.
158) SERVER SIDE PROCESSING DATATABLE WITH PHP AND MYSQL DataTables is a jQuery library used to show the entire list of records in an HTML table. It combines some features like key search, pagination list, data sorting, filter and etc. In DataTables we can limit the number of records to be presented per page.
159) CREATE READ UPDATE DELETE (CRUD) PROCEDURES IN LARAVEL 5.2 In this post, we will know the most useful method laravel 5.2. Here we will create a simple Create Read Update Delete (CRUD) application with Laravel 5.2. Following steps help to beginners for implement Create Read Update Delete (CRUD) procedures in Laravel 5.2.
160) UTILIZING BROWSER LOCAL STORAGE FOR CLIENT SITE SCRIPT IN ANY WEB APPLICATION Local storage is utilized to save data locally within user’s browser. You can save a huge quantity of data locally and it is more secure. In many cases, we face some issues while handling data between the pages.
161) SERVER-SIDE PROCESSING DATATABLE WITH PHP DataTables is a jQuery library used to show the entire list of records in an HTML table. It combines some features like key search, pagination list, data sorting, filter and etc. In DataTables we can limit the number of records to be presented per page.
162) SHOW MORE DETAILS WITHOUT REFRESH USING AJAX In this post, we will see how we can load more post details list with the help of Ajax. This technique helps us to load the page quickly. At the initial page load time have some limited post details only. Whenever the show more button click it will load specified list of the post at
163) MULTIPLE AUTHENTICATIONS USING AUTHCONTROLLER IN LARAVEL 5.2 Multiple authentications are very important in the big application of laravel. If you work on a big project then you frequently prefer to various tables, like we always prefer “users” table for an end user registration and “admins” table for admin user that means secure strong protection.
164) PHP PDF GENERATION USING FPDF In this tutorial, we will produce PDF document with HTML information utilizing FPDF library. In this library, there are elements to include a large portion of PDF pages with required size like A4, A3, letter pad and much more, set content display font style, border, images and etc. Using FPDF, we can generate any content
165) PHP MYSQLI UTILIZATION WITH OUR APPLICATION MySqli is updated version and gives an object oriented and the number of enhancement over the regular MySql extension. These extensions are much faster, efficient and totally secure against SQL injections. In this post, we will understate the basic usage of MySqli, such as connect, select with many options and display the details.
166) BOOTSTRAP FORM VALIDATION Most of the time we need to validate the user inputs before submitting the form value to the server side script. It will help to collect required information from users. We are using bootstrap form validation using bootstrap validator jQuery plugin.
167) PASSWORD STRENGTH NOTIFIER A jQuery/Bootstrap Password Strength Notifier module that produces an advance bar beneath your secret key field to tell the watchword quality and presentations solid watchword prerequisite messages to provoke a client with right solid secret key.
168) SMTP CONFIGURATION AND SEND THE MAIL USING PHPMAILER & GMAIL PHPMailer is a standout amongst the most well-known open source PHP libraries to send messages. In this article, we will discuss why you should utilize PHPMailer rather than PHP’s mail() capacity and we’ll demonstrate to some code tests on generally accepted methods to utilize this library.
169) CREATE PAGE WITH BLADE TEMPLATE ENGINE IN LARAVEL Laravel present easy and very strong templating engine. This templating engine connects one or more templates which are made by inheritance and part to produce required views page. Blade template has its own control construction like loops and conditional statements. Inheritance and Section are main benefits of using Blade template engine.
170) FORM SUBMISSION WITH PHP, MYSQL WITH JQUERY AND AJAX In this exercise, we will see an illustration program to figure out how to do Form submission utilizing PHP and MySQL with Ajax-Post. Here we will go to handle the data values into a database as well as view page with the help of front-end UI.
171) UPLOAD MULTIPLE IMAGES USING PHP In this tutorial, we will see you how to upload multiple images using PHP. In many cases, we need to upload multiple images and submit to the server for the different scenario. Then we need to keep the uploaded documents and file with our server for future reference or share with others.
172) SECURE PROFILE INFORMATION USING PHP In this post, I will tell you how to replace characters with a special character in PHP. In a rare scenario, we need to hide particular information from original for security purposes. For example, when we made any transaction bank will send SMS with your first and last few digits for account numbers with Debit card details.
173) URL IMAGE CREATION AND SAVE IT AS PICTURE USING PHP In this exercise, I will reveal to you how to make a picture from URL and save it as a picture in a required index utilizing PHP. You need to enter finish URL path of the picture in the content box and after that click a button to get an image with specified file name.
174) IMAGE PREVIEW USING JQUERY In this instructional exercise, we will perceive how to pick pictures with picture review utilizing jQuery. You will find short simple and valuable script here to pick pictures with preview. I will show you on changed event utilizing jQuery without transferring images on the server.
175) AVOIDING COPY-DUPLICATE INFORMATION FROM A MULTI-DIMENSIONAL ARRAY IN PHP Some critical point you have to avoid copy values from a multi-dimensional array in PHP and you can take after with offered code to get one of a kind values in an avoid. array_unique() method are utilized to avoid copy information from given array with the help of array_map() method.
176) AVOIDING COPY-DUPLICATE INFORMATION FROM A ONE-DIMENSIONAL ARRAY IN PHP At whatever point you have to avoid copy values from a one-dimensional array in PHP and you can take after with offered code to get one of a kind values in an avoid. array_unique() method are utilized to avoid copy information from given array.
177) EMBEDDING OR INSTALLING PHP INSIDE HTML PAGE Before beginning to working with PHP you have to comprehend what it is the means by which to coordinate. The fundamental distinction amongst HTML and PHP is that PHP is utilized for making the page element and it is the server site scripting language.
178) SINGLE PAGE CRUD WITH PHP, MYSQL, VALIDATE.JS AND AJAX-POST In this exercise, we will see an illustration program to figure out how to do database CRUD operations utilizing PHP and MySQL with Ajax-Post. CRUD represented as Create, Read, Update and Delete operations with database table records.
179) DIGITAL E-SIGNATURE PAD WITH SAVING IT AS IMAGE USING HTML2CANVAS AND AJAX, PHP Digital E-Signature Pad is a jQuery module that exploits HTML5 canvas component and JavaScript to create an adaptable and smooth Signature Pad on your site page and application. The module additionally can record the attracted signature JSON for later recovery.
180) TWO-FACTOR VERIFICATION UTILIZING GOOGLE AUTHENTICATOR LIBRARY In our post, clarify you the login method utilizing PHP with MySQL association. Here is an additional element that can be added to login method for an additional layer of security. It is two-factor verification utilizing Google Authenticator App for Smartphones like Android/iPhone.
181) MAKING PROFESSIONAL LOOKING LETTERHEAD IN MS-WORD 2010 Proficient looking letterhead is an essential detail in relating with accomplices, different associations and customers – both potential and current. It is an imperative piece of your marking, and past its visual interest, letterheads can likewise be dealt with as lawfully restricting records. Correspondence on paper engraved with your official letterhead is perceived
182) LARAVEL 5 MULTIPLE IMAGES UPLOADING WITH DROPZONE JS SCRIPT We generally need to do pictures transferring in our laravel application, In this post, I give you case code of how to transfer different pictures utilizing dropzone.js. dropzone.js through we can make picture transferring basically. Dropzone.js is a jquery module, through this we can choose one or many picture and furthermore with see.
183) CREATING YOUR FIRST LARAVEL APPLICATION Laravel is an extraordinary PHP system. Right now, it is the most featured PHP extend and a lot of companies and individuals everywhere throughout the world utilize it to manufacture astonishing applications. In this instructional exercise, I’ll demonstrate to you that it is so simple to build a web application with Laravel.