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 vote248 views1 answer
How to prevent user to add duplicate card in stripe using laravel
PHP
1 vote184 views2 answers
Php document root
PHP
0 vote191 views1 answer
SQLSTATE[HY000]: General errorstring(58)
PHP
1 vote215 views1 answer
How to find mysql server name in php
PHP
0 vote210 views1 answer
Laravel factory get foreign key
PHP Laravel
1 vote212 views3 answers
Php hide errors
PHP
0 vote177 views1 answer
Change WordPress Login Logo Url
PHP
90 votes187 views4 answers
If text contains word then in php
PHP
3 votes184 views6 answers
Convertir datetime a string en php
PHP
1 vote177 views1 answer
Php get bool from string
PHP