/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

3 votes294 views5 answers
Parse error: syntax error, unexpected 'location' (T_STRING) in C:\xampp\htdocs\loginsystem\login.php on line 23
PHP
0 vote308 views1 answer
Get only the first two word from a string php
PHP
0 vote333 views1 answer
Drop foreign key laravel eloquent
PHP
0 vote313 views1 answer
Laravel has one of many relationship
PHP
6 votes321 views3 answers
Laravel collection put
PHP
95 votes376 views6 answers
String to array php
PHP
4 votes336 views2 answers
Ubuntu laravel storage permission
PHP
2 votes373 views2 answers
How unset request parameter in laravel
PHP Laravel
16 votes363 views6 answers
Laravel model events
PHP
0 vote339 views1 answer
Laravel run php server by ipv4
PHP