<?php
echo "Today is ".date("Y/m/d")."<br>";
echo "Today is ".date("Y.m.d")."<br>";
echo "Today is ".date("Y-m-d")."<br>";
echo "Today is ".date("1")."<br>";
?>

////////////////////////////////////////////////////////

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

//CREATE CONNECTION HERE
$conn = mysqli_connect($servername, $username, $password);

//CHECK CONNECTION HERE
if (!$conn) {
	 					die("Connection failed: ".mysqli_connect_error());
					}
echo "Connection successful";
?>

////////////////////////////////////////////////////////////

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


//Create connection
$conn = mysqli_connect($servername, $username, $password);
//Check connection
if (!$conn) {
	 			die("Connection failed: ".mysqli_connect_error());
}

// Create database
$sql = "CREATE DATABASE myDB";
if (mysqli_query($conn, $sql)) {
				echo "Database successfully created!" ;
		} else {
				echo "Error creating database: ".mysqli_error($conn);
}

mysqli_close($conn);
?>

////////////////////////////////////////////////////////////////////////

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


//Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
//Check connection
if (!$conn) {
	 			die("Connection failed: ".mysqli_connect_error());
}

//sql to create table
$sql = "CREATE TABLE MyGuests (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP
) " ;


if (mysqli_query($conn, $sql)) {
			echo "Table MyGuests has been successfully created!";
	} else {
			echo "Error! Unable to create Table MyGuests: " . mysqli_error($conn);
}


mysqli_close($conn);
?>

///////////////////////////////////////////////////////

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


//Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
//Check connection
if (!$conn) {
	 			die("Connection failed: ".mysqli_connect_error());
}

$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('Roland' , 'Wimbledon' , ' ayylmao@oamlyya.com')";

if (mysqli_query($conn, $sql)) {
		echo "New record has been recorded!";
	} else {
		echo "Error: " . $sql. "<br>" . mysqli_error($conn);
}


mysqli_close($conn);
?>