/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

0 vote152 views1 answer
Button back php
PHP
0 vote205 views1 answer
Provide filter condition in autocomplet field in drupal form using property
PHP Drupal
0 vote236 views1 answer
Laravel\Socialite\Two\InvalidStateException
PHP Laravel
0 vote186 views1 answer
Single row data from table in laravel
PHP Laravel
44 votes240 views6 answers
Call seeder laravel
PHP Laravel
0 vote156 views1 answer
How to set timezone for iran in laravel
PHP
1 vote165 views2 answers
Php password validation preg_match
PHP
0 vote206 views1 answer
Store image to s3 laravel
PHP Laravel
1 vote222 views2 answers
Laravel eloquent with query extra parameter
PHP Laravel
3 votes180 views5 answers
What does php stand for
PHP