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 vote289 views1 answer
Phph call functions from other .php file
PHP
4 votes311 views1 answer
Laravel relation of relation
PHP
0 vote344 views1 answer
Merge two objects php laravel
PHP Laravel
6 votes301 views3 answers
Ubuntu php uninstall
PHP
2 votes345 views2 answers
Laravel websockets
PHP Laravel
0 vote319 views1 answer
Add Spatie provider to providers
PHP
1 vote419 views1 answer
Save error cakephp 2
PHP CakePHP
0 vote281 views1 answer
Pdo prepare multiple queries
PHP
1 vote341 views1 answer
Date casting from datetime to d-m-Y laravel
PHP Laravel
0 vote284 views1 answer
Php remove slash from string
PHP