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

24 votes357 views4 answers
Clear cache command in laravel controller
PHP Laravel
3 votes335 views6 answers
Remove square brackets from string php
PHP
1 vote301 views2 answers
How add field to table by another migration in laravel
PHP
7 votes301 views10 answers
Php .com
PHP
4 votes317 views2 answers
Laravel get authorization bearer token
PHP
7 votes353 views2 answers
Php get and print file contents
PHP
0 vote349 views1 answer
How to put external file in laravel listener class
PHP
2 votes308 views1 answer
Wordpress get current user role
PHP
6 votes309 views4 answers
Get featured image id wordpress
PHP
0 vote397 views1 answer
Comment faire en sorte que le numéro de téléphone ne soit pas un champ obligatoire dans WooCommerce
PHP