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

18 votes230 views1 answer
Specified key was too long; max key length is 767 bytes (s
PHP
0 vote282 views1 answer
Db seed in controller
PHP
0 vote227 views2 answers
Php check new month
PHP
0 vote261 views5 answers
Laravel tricks and tips
PHP Laravel
13 votes243 views3 answers
Inplode php
PHP
10 votes233 views2 answers
Convert php array into json online
PHP
4 votes221 views2 answers
Php shorthand if isset
PHP
9 votes240 views6 answers
Laravel 8 date format
PHP
3 votes263 views1 answer
Laravel validate max file size
PHP Laravel
9 votes243 views4 answers
Laravel route pattern
PHP Laravel