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

3 votes200 views2 answers
Wordpress get template url
PHP Wordpress
18 votes189 views1 answer
Specified key was too long; max key length is 767 bytes (s
PHP
43 votes180 views2 answers
Get array length using php
PHP
0 vote173 views1 answer
Php sort multidimensional array by child value
PHP
2 votes187 views2 answers
Assign multiple variables php
PHP
4 votes165 views2 answers
Laravel carbon get month name español
PHP
1 vote177 views1 answer
Php trim string if longer than
PHP
0 vote177 views2 answers
Symfony get query param
PHP
5 votes204 views5 answers
Laravel file permissions
PHP
0 vote205 views1 answer
Deleting all files inside a directory laravel 8
PHP