/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 vote383 views1 answer
How to pass parameters to relationships laravel
PHP Laravel
0 vote302 views1 answer
Laravel add model to polymorphic relationships
PHP
0 vote330 views1 answer
Obtener tipo
PHP
1 vote355 views2 answers
Laravel check if object empty
PHP Laravel
108 votes510 views6 answers
String contains php
PHP
13 votes270 views4 answers
Php sha256 with rsa
PHP
1 vote356 views2 answers
Wp include image inside theme folder
PHP Wordpress
0 vote305 views1 answer
Php dom get element innerhtml
PHP
0 vote378 views2 answers
How to upload two files on same form different path in codeigniter
PHP CodeIgniter
3 votes273 views3 answers
Class "App\Http\Controllers\Auth" not found
PHP