MySqll | Learn MySql with the Core PHP

Category: Mysql

How to Create Pagination in PHP

In this article, you will earn How to Create Pagination in PHP.

<?php
include('db.php');?>
<html>
<head>
<title>Pagination in PHP</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>
<table border="1">
    <tr>
    <th>Sr No.</th>
    <th>Name</th>
    <th>Father Name</th>
 <th>Email</th>
   <th>Mobile</th>

…

How to Generate PDF from MySQL Database

In this article, you will learn How to Generate PDF from MySQL Database.

Example:-

Table of Employees

CREATE TABLE IF NOT EXISTS `employee` (
 `EmpId` int(11) NOT NULL,
 `EmpName` varchar(200) DEFAULT NULL,
 `EmpDepartment` varchar(200) DEFAULT NULL,
 `EmpRegDate` timestamp NULL DEFAULT

…

How to Get last id From Mysql Using PHP

In this article, you will learn How to Get the last id From Mysql Using PHP. Get the last id from tables using the below example.

Example:-

db.php

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname =

…

How to Create Email Verification Script in PHP

In this article, you will learn How to Create Email Verification Script in PHP.

user_registration table

CREATE TABLE IF NOT EXISTS `user_registration` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,

…

How to Delete Multiple Records from Database using PHP

In this article, you will learn How to Delete Multiple Records from Database using PHP.

Example:-

SQL Table

CREATE TABLE `users` (
  `id` int(10) NOT NULL,
  `name` varchar(140) DEFAULT NULL,
  `education` varchar(120) DEFAULT NULL,
  `doj` int(11) NOT NULL
) ENGINE=InnoDB

…