How to Generate PDF from Mysql Database using PHP

Generate PDF from mysql database

In this post I will explain you How to Generate PDF from Mysql Database using PHP. To Generate PDF file with mysql data content and output, we will use popular php library FPDF which will help us to generate PDF file. What is FPDF ? FPDF is a PHP class library which allow us to generate PDF file using PHP. In FPDF, ‘F’ stands for Free. So We can say FPDF  means Free PDF . It is Open Source library. You may use it  and modify for any kind of usage to…

Read More

How to Import MySQL Database from SQL File using PHP

Importing SQL script via programming will be useful when we need to create database structure dynamically. For example, if we provide APP or plugin to download and install from online, the dynamic SQL import will be used to setup the application database at the time of installing the APP or plugin. To import SQL file in the database, you have to login to your hosting server or phpMyAdmin. Also, you can import the database from PHP script without login to your hosting server or phpMyAdmin. Import database from PHP script…

Read More

How to Integrate Paypal Payment System with Paypal API in PHP and MySql

paypal-integration

In this article, you will learn about How to Integrate PayPal Payment System with PayPal API in PHP and MySQL. Here i will show you how to use PayPal Sandbox test account for payment system development and passing arguments while click on buy now button. It’s a simple and easy way to integrate in your own web projects to process payment with PayPal gateway. You need to follow our step by step process: Step-1: Create a Sandbox account at https://developer.paypal.com/ Step-2: Now signup a test account for payment system. Take a look at…

Read More

How to Export database records to CSV File using PHP and MySQL

export data to csv file using php and mysql

Import and export CSV file data is mostly used in web based application. Generally, CSV file data is used to import and export tabular data between programs because CSV is most popular file format to store tabular data in plain text. In this article, i will show you how to export mysqldatabase table records to CSV file using PHP. Also , you will get the knowledge to create CSV file in PHP and download the save MySQL data in CSV file. Before start export to CSV functionality, we will create…

Read More

How to Import Excel To Mysql Database Using PHP

How to Import Excel To Mysql Database Using PHP

Hello friends, In this post we will learn about “How to import excel or csv file to MySQL database using PHP”. Before start this topic, i want to discuss the use of this function?. As you know that if we have 10 to 20 records of employee than we can insert this records manually into database, but if we have more than 1000 records than it not a possibility to enter 1000 records manually one by one. To insert morethan 1000 records at a time, we create a excel or csv file of…

Read More

How to insert data into database using HTML form

“How to insert data into database using HTML form” is locked How to insert data into database using HTML form

Hello, In this post we will learn about mysqli query to insert data into database using  HTML form. For this process we have to required 2 files, one is HTML file and another is php file. HTML file is used to create a HTML form and php file is used to define database connection or insert query. Here i created a simple HTML form that have <input> text field and submit field to trigger insert query. index.html

From above HTML form, when user fill the fields detail and click…

Read More

How to insert data using MySQLi query in php

How to insert data using MySQLi query in php

In this tutorial you will learn how to insert records in a table using MYSQLi query . Let’s start to create a INSERT INTO statement with values using MYSQLi Procedural and MYSQLi Object-oriented method. Here we are going to insert a record into user table by specifying coloum fields like: ‘ user_id’, ‘first_name’, ‘last_name’, ’email’, ‘phone’. Here ‘user_id’ is an  AUTO_INCREMENT PRIMARY KEY  coloum. Example: MYSQLi Query MYSQLi Procedural Method

  MYSQLi Object-oriented Method MySQLi Object-oriented method is more faster and secure than MYSQLi Procedural method. That’s the reason…

Read More

how to connect mysqli with php

how to connect mysqli with php

MYSQLi Tutorial for Beginners – how to create MySQLi connection with php in simple and easy steps starting from basic to advanced level. To create connection 4 parameter is required : “hostname” , “username“, “password” and “database name” see below..how to do it..  

if you are using xampp or wamp then by default username is root and password is blank. Also you can check our video tutorials:

Read More

How to write connection class to mysql database using php

Hello! In this post, you will learn to how to write and test the OOP based connection class to mysql database using php. see below..how to do it.. connection.php

Now you have create the database connection class let’s see how to call this connection class inside your project. To test the connection we will create another php file and create a object from my existing connection class.. see below..how to do it.. >test.php

Read More