Generate PDF from MySQL Data using PHP.

In this tutorial I explains how to generate PDF from MySQL Data using PHP. You are going to see how to convert MySQL Data into PDF using FPDF library.
Before start learning first of all we should know about Fpdf.

What is Fpdf.?

The FPDF is awesome PHP class to generate PDF using PHP from MySQL/MySqli database.This is open source php library to generate pdf file using PHP.
Awesome Features of FPDF.

  • Choice of measure unit, page format and margins.
  • Page header and footer management.
  • Automatic page and line break with text justification
  • Image support (JPEG, PNG and GIF).
  • Colors
  • Links
  • TrueType, Type1 and encoding support
  • Page compression.

Import an Excel file in MySql Database using php

welcome back to shortlearner.com, In this tutorial, we will see how to Import an Excel file in Mysql database. In the First step we will create a Database to insert an excel data into Mysql table, a form to make a view to upload an Excel Sheet and also create a PHP script to perform operation to insert data into Database.

Create Database

To Insert excel sheet data into MySql database, we need to create a database named as ‘test_excel’ and also create a table named as ‘excel_sheet’

Also Read :
How to Install PHP on CentOS.
How to integrate Razorpay Payment Gateway using PHP.

PHP Login Script With Remember me.
Change password using javascript, php and mysqli.
Password and Confirm Password Validation Using JavaScript
Check Email is Already Registered in Database using Ajax and JavaScript.
How to hide extension of html and php file.?

Config.php

after creating database , we move on the config.php page.. here we make a database connection.

Index.php

after creating database , we move on the index page.. in the index page we take a csv file from our computer and redirect it to functions.php page . where we check that the file which is selected is CSV  or not.

functions.php

In this page we catch the file and check it , if our file is  csv than it import into database otherwise it shows the error and redirect to index.php page.

Keep Learning..

Improve your website Ranking with Social Media SEO meta Tags

Welcome back to Shortlearner.com, todays post is about meta tags.

Meta Tags are one of the most basic elements of SEO(search engine optimization). The search engines reads the meta tags to get a summarized idea of what your site is about and what exactly your keywords are.Meta tags list your site in Top.Meta tags are located inside your html’s head area.

Important attributes of meta tag: