Connect php to db

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';    
}

Similar codes

0 vote538 views1 answer
Laravel pass multipale provider
PHP Laravel
0 vote303 views1 answer
How to check if page is opened by bot
PHP
2 votes318 views2 answers
Import big sql file phpmyadmin
PHP
1 vote329 views2 answers
Laravel update only changed fields
PHP
0 vote317 views1 answer
Yajra laravel datatables rawcolumn
PHP
6 votes342 views6 answers
Search query in laravel
PHP Laravel
5 votes340 views4 answers
Get Parameters From a URL String in PHP
PHP
2 votes404 views2 answers
Laravel forcefill
PHP Laravel
0 vote502 views1 answer
Yii2 modules commands are not showing in console
PHP Yii
9 votes338 views1 answer
Php string to uppwe
PHP