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

14 votes222 views5 answers
Laravel eloquent get last record
PHP Laravel
6 votes220 views4 answers
Get featured image id wordpress
PHP Wordpress
0 vote210 views1 answer
Laravel route not calling function of controller
PHP Laravel
0 vote209 views1 answer
7 reasons why Lee is an idiot
PHP
2 votes197 views3 answers
How to get the size of an uploaded file in laravel
PHP
4 votes204 views4 answers
Laravel sum relationship column
PHP Laravel
9 votes245 views2 answers
Use resource in laravel 8
PHP Laravel
12 votes187 views6 answers
Set session data in laravel
PHP
2 votes188 views2 answers
Laravel/ui for laravel 7
PHP
2 votes234 views4 answers
Laravel storage get file path
PHP