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

8 votes409 views3 answers
Laravel log query for model
PHP Laravel
0 vote386 views2 answers
Laravel permission to vuejs
PHP Laravel
0 vote329 views1 answer
Php date in human readable form
PHP
1 vote383 views3 answers
Get page title wordpress
PHP Wordpress
0 vote332 views1 answer
Laravel make migration in subfolder
PHP
4 votes356 views2 answers
Auth guard (admin) is not defined laravel 8
PHP
0 vote319 views1 answer
Rule for radio button in laravel
PHP
6 votes363 views3 answers
Wordpress query a post by id
PHP
4 votes302 views2 answers
Php slice last arrat
PHP
0 vote347 views1 answer
Checks whether the session is set or not, if not it will redirect the user to login page.
PHP