Database connection 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

Database connection in php

<?php

$hostName = 'localhost';
$userNmame = 'root';
$password = '';
$dbname = 'topproduct';
$db_name = "mysql:host=$hostName;dbname=$dbname";
$conn = new PDO($db_name,$userNmame,$password);

if(!$conn){
    echo 'Error database connection';    
}

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 sql server connect

$serverName = "serverName\sqlexpress"; //serverName\instanceName
$connectionInfo = array( "Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

-1

Connect database using php

php db connect

-2

Similar codes

0 vote173 views1 answer
Laravel Exclude URI from csrf token verification
PHP
1 vote204 views3 answers
Laravel get url segment
PHP Laravel
6 votes199 views3 answers
Php calculate hours and minutes between two times
PHP
1 vote212 views1 answer
How create page 419 in laravel
PHP Laravel
0 vote253 views1 answer
Laravel use variable inside callback function
PHP Laravel
0 vote212 views1 answer
Password change logout from wordpress
PHP Wordpress
7 votes225 views3 answers
Laravel 8 validation unique 2 columns
PHP
1 vote195 views1 answer
Max_input_time in wordpress
PHP
23 votes263 views6 answers
Laravel make model with migration and controller
PHP
0 vote187 views1 answer
Php file_get_contents html with special characters
PHP