/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 vote156 views1 answer
Create a custom method laravel model
PHP
0 vote173 views1 answer
Confirm password in codeigniter
PHP CodeIgniter
2 votes168 views2 answers
How to add data to the request object in laravel
PHP Laravel
0 vote136 views1 answer
Laravel query with optional filter
PHP
3 votes161 views1 answer
Artisan to make model controller factroy seeder at once
PHP
9 votes181 views4 answers
Pretty json php
PHP
0 vote141 views1 answer
Igaster\Laravel Theme\Exceptions\theme Already Exists
PHP
0 vote145 views1 answer
Php artisan test
PHP
2 votes141 views1 answer
Php file_get_contents disable ssl check
PHP
3 votes142 views2 answers
How to create shortcode
PHP