/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 vote90 views1 answer
Array collapse laravel
PHP
5 votes122 views4 answers
Php globals
PHP
0 vote150 views1 answer
Verzeichnis einlesen php
PHP
0 vote156 views2 answers
How to concat in where clause like laravel query builder
PHP Laravel
0 vote141 views1 answer
Wp show logo
PHP
2 votes118 views1 answer
Php ternary shorthand
PHP
7 votes158 views3 answers
Class 'App\Models\Auth' not found
PHP
0 vote121 views1 answer
Laravel post request page csrf disable
PHP
12 votes114 views6 answers
Php remove new line character from string
PHP
0 vote146 views2 answers
Laravel filesystem
PHP Laravel