/PHP/How to connect to a database in php

How to connect to a database in php

<?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";
?>

Connect php to db

This is an update to a note I wrote earlier concerning how to set multiple attributes when you create you PDO connection string.

You can put all the attributes you want in an associative array and pass that array as the fourth parameter in your connection string. So it goes like this:
<?php
$options = [
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_CASE => PDO::CASE_NATURAL,
    PDO::ATTR_ORACLE_NULLS => PDO::NULL_EMPTY_STRING
];

// Now you create your connection string
try {
    // Then pass the options as the last parameter in the connection string
    $connection = new PDO("mysql:host=$host; dbname=$dbname", $user, $password, $options);

    // That's how you can set multiple attributes
} catch(PDOException $e) {
    die("Database connection failed: " . $e->getMessage());
}
?>

Source: php.net

How to connect to a mysql database using php

<?php
  $serverName = "localhost";
  $dBUsername = "root";
  $dBPassword = "";
  $dBName = "users";

  $conn = mysqli_connect($serverName, $dBUsername, $dBPassword, $dBName);

  if (!$conn) {
    die("Connection failed: " . mysqli_connection_error());
  }

-1

Php mysql connection

Connected successfully

-2

Source: javatpoint.com

Similar codes

1 vote185 views1 answer
Invalid datetime format laravel
PHP
0 vote161 views1 answer
Parse error: syntax error, unexpected ':', expecting ';' or '{' in //twilio-php-master/src/Twilio/autoload.php on line 61 
PHP
3 votes316 views2 answers
Two condition in one laravel query
PHP Laravel
3 votes245 views1 answer
Laravel back button
PHP Laravel
4 votes202 views1 answer
Remove index.php
PHP
0 vote207 views1 answer
Route pattern cannot reference variable name more than once. laravel
PHP Laravel
0 vote204 views2 answers
Laravel get namespace
PHP
10 votes164 views2 answers
Try and catch laravel
PHP
6 votes171 views4 answers
Laravel url previous
PHP
2 votes196 views2 answers
Laravel validation unique email except self
PHP