/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 vote240 views1 answer
Parameter to laravel seeder
PHP Laravel
1 vote209 views1 answer
How to define variable as object in blade laravel
PHP
35 votes208 views5 answers
Remove the Last Character From a String in PHP
PHP
0 vote205 views1 answer
Image::make en php
PHP
6 votes212 views1 answer
PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes") laravel 8
PHP
0 vote293 views1 answer
Failed to open stream permission denied laravel
PHP Laravel
0 vote222 views1 answer
Instalar Lamp server en Ubuntu
PHP
0 vote215 views1 answer
What does the initals of php stand for?
PHP
3 votes213 views2 answers
Php session auto expire
PHP
3 votes213 views1 answer
How to modify a string that’s passed by reference in php
PHP