/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 vote202 views1 answer
Php check if two arrays are equal
PHP
4 votes205 views3 answers
Php array formatter online
PHP
44 votes255 views6 answers
Call seeder laravel
PHP Laravel
0 vote175 views1 answer
Php extract number from string without comma
PHP
0 vote220 views1 answer
Laravel collection prepend
PHP Laravel
0 vote175 views1 answer
Laravel send ajax
PHP
0 vote204 views1 answer
Wordpress remove current post in sidebar php
PHP Wordpress
0 vote215 views1 answer
Take and skip in laravel
PHP Laravel
0 vote182 views1 answer
Count array index foreach in php
PHP
0 vote173 views1 answer
Capture the echo php
PHP