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 vote214 views1 answer
Determining if input is present in Laravel
PHP Laravel
1 vote192 views2 answers
Laravel gmail
PHP
7 votes218 views5 answers
Jetstream laravel
PHP Laravel
3 votes205 views2 answers
Current user laravel
PHP Laravel
0 vote217 views3 answers
Add factory data laravel
PHP
1 vote209 views1 answer
Hex to dec php
PHP
0 vote209 views1 answer
Old function use in checkbox selected in laravel blade
PHP Laravel
0 vote311 views1 answer
How to use “find_in_set” in cakephp 3 find method
PHP CakePHP
0 vote180 views2 answers
New static laravel
PHP
0 vote269 views2 answers
Laravel date format valdiate
PHP Laravel