php mysql

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

// Create connection
$conn = new mysqli($servername, $username, $password);

 // Check connection

 if ($conn->connect_error) {

  die("Connection failed: " . $conn->connect_error);
}


 
// Create database

 $sql = "CREATE DATABASE myDB";
if ($conn->query($sql) === TRUE) {
  echo "Database created successfully";
} else {
  echo "Error creating database: " . $conn->error;
}

$conn->close();

?>
 

<?php
$servername = "localhost";
$username = "username";

 $password = "password";

try {
  $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password);

    // set the PDO error mode to exception
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    echo "Connected successfully";
 
} catch(PDOException $e) {
  echo "Connection failed: " . $e->getMessage();
}

?>
 

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

// Create connection
$conn = new mysqli($servername, $username, $password);

 
// Check connection

 if ($conn->connect_error) {

  die("Connection failed: " . $conn->connect_error);
}

echo "Connected successfully";

?>
 

<?php
$servername = "localhost";
$username = "username";

 $password = "password";

// Create connection

$conn = mysqli_connect($servername, $username, $password);

 
// Check connection

 if (!$conn) {

    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";

?>
 

In order to send data to a databse securely use prepared statements otherwise 
you can get attacked by an SQL Injection easily.
----
https://www.w3schools.com/php/php_mysql_prepared_statements.asp