/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 votes351 views2 answers
Get details of user using token in laravel passport
PHP Laravel
2 votes313 views3 answers
Add data to the collection laravel
PHP
0 vote327 views6 answers
Php email
PHP
0 vote293 views1 answer
Laravel This package is not auto-updated. Please set up the GitHub Hook for Packagist so that it gets updated whenever you push!
PHP
0 vote340 views1 answer
Creating dynamic subdomain in php
PHP
2 votes349 views1 answer
Laravel get only the Ids of an eloquent arrays
PHP
0 vote321 views1 answer
RequestCriteria laravel
PHP Laravel
0 vote367 views2 answers
Pluck only category name and id from model in laravel
PHP Laravel
3 votes362 views1 answer
Codeigniter form_validation email
PHP
1 vote340 views2 answers
Get ip address in laravel
PHP