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 vote140 views1 answer
Is legged in wodpress
PHP
35 votes153 views3 answers
Run seeder command in laravel
PHP Laravel
0 vote280 views1 answer
Composer Fatal error: Call to undefined function Symfony\Polyfill\Mbstring\iconv() in phar
PHP Symfony
0 vote181 views2 answers
Codeigniter 4 limit query
PHP CodeIgniter
0 vote135 views1 answer
Laravael Blog Project
PHP
19 votes130 views5 answers
Php check string
PHP
0 vote151 views1 answer
Eager load relationships by default in the model laravel
PHP Laravel
0 vote126 views1 answer
Multiple databases user validation in Laravel
PHP
3 votes123 views2 answers
Remove cookies php
PHP
1 vote118 views1 answer
Convert comma separated number to number in php
PHP