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 vote167 views2 answers
"codeigniter 4" cart
PHP CodeIgniter
0 vote140 views1 answer
Wordpress disable theme editor
PHP
2 votes133 views1 answer
Two digits after decimal point in php
PHP
3 votes191 views2 answers
{{Str::limit laravel
PHP Laravel
0 vote133 views1 answer
Symfony change php version
PHP
6 votes147 views3 answers
Php mkdir
PHP
0 vote176 views1 answer
How to increase the WordPress Multisite Network limit for Maximum Filesize Upload?
PHP Wordpress
0 vote135 views2 answers
Laravel download file from s3
PHP
0 vote184 views1 answer
How to free session variable in php codeigniter
PHP CodeIgniter
0 vote130 views1 answer
Php group multidimensional array by value
PHP