<?php

	// variable is yor wish $conn or $ftl or $ftl_connect etc,.
	
	$ftl_connect = mysqli_connect("localhost", "root", "");
	// Check connection
	if (!$ftl_connect) {
		die("Connection failed: " . mysqli_connect_error());
	}
	
	// Create database
	$sql = "CREATE DATABASE ftl_db";
	if (mysqli_query($ftl_connect, $sql)) {
		echo "Database created successfully";
	} else {
		echo "Error creating database: " . mysqli_error($ftl_connect);
	}
	
	mysqli_close($ftl_connect);
?>

<?php
	$ftl_connect = mysqli_connect("localhost", "root", "");
	// Check connection
	if ($ftl_connect->connect_error) {
		die("Connection failed: " . $ftl_connect->connect_error);
	} 
	
	// Create database
	$sql = "CREATE DATABASE ftl_db";
	if ($ftl_connect->query($sql) === TRUE) {
		echo "Database created successfully";
	} else {
		echo "Error creating database: " . $ftl_connect->error;
	}
	
	// Close Connection
	$ftl_connect->close();
?>

<?php

	try {
		$ftl_connect = new PDO("mysql:host=localhost;dbname=ftl_db", "root", "");
		// set the PDO error mode to exception
		$ftl_connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
		$sql = "CREATE DATABASE ftl_db";
		// use exec() because no results are returned
		$ftl_connect->exec($sql);
		echo "Database created successfully<br>";
		}
	catch(PDOException $e)
		{
		echo $sql . "<br>" . $e->getMessage();
		}
	
	$conn = null;

?>