MySqll | Learn MySql with the Core PHP

Category: Mysql

How to Fetch Logged in Username

after login, we need to fetch Username. We will explain How to Fetch Logged in Username.

<?php
include("db.php");
session_start();
if($_SESSION['username']=="")
{
session_destroy();
header("location:index.php");
}
?>
<html>
<head>
<title>Fetch Loged in Username</title>
</head>
</body>
	       <?php
		   include('db.php'); 
	$query="select * from user

…

How to Create Dynamic Dependent select box using ajax

You need a dynamic dependent select box. We will explain how to create a dynamic dependent select box in PHP, jquery and ajax.

index.php

<?php
include_once 'dbconfig.php';
?>
<html>
<head>
<title>Dynamic Dependent Select Box using Ajax</title>
<script type="text/javascript" src="jquery-1.4.1.min.js"></script>
<script

…

How to Create Database and tables in MySql

In this article will explain How to Create Database and tables in MySql.

Create a Database

CREATE DATABASE DATABASE_NAME;

In MySql, if you want to display a list of all databases to run the below query.

SHOW DATABASES;

Create Tables:…

How to use ORDER BY in Mysql

In this article, you will learn How to use ORDER BY in Mysql.

Syntax:-

SELECT column1, column2, ...
FROM table_name
ORDER BY column1, column2, ... ASC/DESC;

ORDER BY DESC Example:-

SELECT * FROM Students ORDER BY StudentID DESC;

ORDER BY …

How to Create Cookies in PHP on Browser

In this article, you will learn How to Create Cookies in PHP.on Browser A Cookie is used to identify any user. With the help of the PHP, you can retrieve and create the cookie.

Syntax:-

setcookie(name, value, expire, path, domain,

…