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 vote272 views3 answers
Symfony start
PHP
0 vote243 views1 answer
Php get all function arguments
PHP
0 vote290 views1 answer
Wordpress get archive title
PHP Wordpress
0 vote247 views2 answers
Hide Categories - Woocommerce Product Page
PHP
1 vote259 views1 answer
How to json_encode an array in php unexpected identifier
PHP
0 vote310 views1 answer
How to display limited post content in wordpress
PHP Wordpress
7 votes251 views1 answer
Arredondando nyumnero php
PHP
0 vote254 views1 answer
Italic text in laravel notification
PHP
14 votes301 views6 answers
Get the Last Character of a String in PHP
PHP
1 vote244 views2 answers
Laravel return response with headers
PHP Laravel