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 vote269 views1 answer
Create table laravel give name table
PHP
70 votes289 views6 answers
Php truncate string
PHP
6 votes306 views1 answer
Wordpress get_date
PHP Wordpress
0 vote274 views1 answer
Autoloading classes
PHP
5 votes264 views5 answers
Laravel file permissions
PHP
0 vote243 views1 answer
Regex get text between braces
PHP
0 vote302 views1 answer
Add code return block phpstorm
PHP
12 votes276 views3 answers
Get index of element in array php
PHP
0 vote324 views1 answer
Wp get attachment id
PHP Wordpress
0 vote284 views1 answer
Method Illuminate\Support\Collection::appends does not exist.
PHP