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

-1 vote98 views1 answer
Turn error log WP
PHP
0 vote111 views1 answer
Laravel eloquent get x number of results
PHP Laravel
0 vote119 views1 answer
Email configuration for gmail in laravel
PHP Laravel
7 votes155 views2 answers
How to check the day of any date in php
PHP
0 vote94 views1 answer
Php get url after question mark
PHP
45 votes155 views6 answers
Laravel outer join
PHP Laravel
0 vote124 views1 answer
Check website ssl certificate using php openssl_x509_parse
PHP
0 vote104 views1 answer
Onde fica o php ini ubuntu
PHP
0 vote102 views1 answer
Php function to minify javascript and css
PHP
3 votes111 views3 answers
Axios post php
PHP