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

3 votes151 views2 answers
Laravel longblob migration
PHP Laravel
0 vote134 views2 answers
Symfony get query param
PHP
0 vote142 views1 answer
Magento 2 laravel valet 502 bad gateway
PHP
13 votes131 views5 answers
Zsh: command not found: laravel
PHP
0 vote179 views1 answer
Db connection postgres laravel
PHP
0 vote144 views1 answer
Laravel move file from local to s3
PHP
0 vote155 views2 answers
How to save array of inputs in php
PHP
0 vote205 views1 answer
Get database columns laravel
PHP Laravel
0 vote132 views1 answer
Wp varnish ip
PHP
7 votes126 views2 answers
Php laravel between dates
PHP