PHP Advanced Archives - MySQL Queries | PHP | JavaScript | JQuery | CSS | HTML | MySQL

August 14, 2018 admin

Download file with speed limit using PHP

Yes, using simple PHP snippet you can limit the download speed of a file. This can be done for Bandwidth throttling or

August 8, 2018 admin

PHP Socket Programming

You might not know this, but PHP comes with a very capable socket programming API. These socket functions now include

June 14, 2018 admin

Google Pie Charts with PHP and MySQL

Populating pie charts with google API is one of the simplest way to do. here we are showing you a

June 6, 2018 admin

Simple User Registration Form Using PHP, MySQL

In this tutorial, I am illustrating a simple user registration form. register form is a common need in any kind of

June 5, 2018 admin

How To Select Data From Table Using MySQL & PHP?

Step 1: Connect to MySQL Database


<?php
$DatabaseServer = "localhost";
$DatabaseUsername = "root";
$DatabasePassword = "root";
$DatabaseName = "demo";
$Connection = mysqli_connect($DatabaseServer , $DatabaseUsername ,    $DatabasePassword ,   $DatabaseName);

if ($Connection  === false)
	{
	die("ERROR: Could not connect. " . mysqli_connect_error());
	}

?>

<?php

$DatabaseServer = "localhost";

$DatabaseUsername = "root";

$DatabasePassword = "root";

$DatabaseName = "demo";

$Connection = mysqli_connect($DatabaseServer , $DatabaseUsername , $DatabasePassword , $DatabaseName);

if ($Connection === false)

{

die("ERROR: Could not connect. " . mysqli_connect_error());

}

Step 2: Fetch Data From MySQL Database


<?php
$SQL = "SELECT * FROM user";
$Result = mysqli_query($Connection, $SQL);

while ($Row = mysqli_fetch_assoc($Result)    
	{
	  echo $FirstName = $Row['FirstName '];
	echo $Email = $Row['Email'];
	   
	}

?>

<?php

$SQL = "SELECT * FROM user";

$Result = mysqli_query($Connection, $SQL);

while ($Row = mysqli_fetch_assoc($Result)

{

echo $FirstName = $Row['FirstName '];

echo $Email = $Row['Email'];

}

Mysql: Run these queries to