/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 votes163 views2 answers
Foreach sort orderby php
PHP
0 vote190 views1 answer
Create or update laravel 5.8 stackoverflow
PHP
0 vote193 views1 answer
Searching for new lines
PHP
10 votes212 views4 answers
Laravel migration set default value
PHP Laravel
0 vote193 views1 answer
Add “Affected Products” in catalog price rule
PHP
0 vote195 views1 answer
Php number format without rounding
PHP
2 votes178 views3 answers
Class 'Intervention\Image\ImageServiceProvider' not found
PHP
0 vote323 views1 answer
Wp wc php use comma separated thousands
PHP
18 votes235 views1 answer
Laravel migation error
PHP Laravel
0 vote134 views1 answer
Check custom post type post exists
PHP