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

2 votes219 views2 answers
Twig ternary
PHP
0 vote187 views2 answers
Current url wordpress
PHP Wordpress
0 vote263 views1 answer
Nova laravel image
PHP Laravel
2 votes218 views2 answers
Bootstrap pagination laravel
PHP Laravel
0 vote196 views1 answer
How to setup php mailer
PHP
3 votes159 views1 answer
Validate each value from array laravel
PHP
0 vote174 views1 answer
Haseeb php code
PHP
1 vote311 views1 answer
Include a file in laravel controller
PHP Laravel
0 vote249 views1 answer
How to pluck fullname database laravel
PHP
0 vote237 views1 answer
Php str_pad not working
PHP