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 votes85 views2 answers
Php unique string
PHP
104 votes245 views6 answers
String length php
PHP
2 votes90 views3 answers
How to get the size of an uploaded file in laravel
PHP
1 vote101 views1 answer
Str_ireplace
PHP
10 votes87 views4 answers
Twig dump
PHP
0 vote90 views1 answer
Php check jwt token expired
PHP
0 vote97 views2 answers
"message": "Call to a member function canNot() on null", "exception": "Symfony\\Component\\Debug\\Exception\\FatalThrowableError",
PHP
3 votes95 views3 answers
Php pluck from array of objects
PHP
0 vote107 views1 answer
Last_insert_id() php
PHP
30 votes147 views6 answers
Php loop
PHP