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 vote257 views1 answer
Session cakephp
PHP CakePHP
0 vote152 views1 answer
Php list *files
PHP
3 votes120 views2 answers
2 decimal round using php
PHP
42 votes123 views3 answers
How to split sting in php
PHP
2 votes150 views3 answers
Php remove html tag
PHP
0 vote127 views1 answer
Comment supprimer balise script hmtl en php regex
PHP
0 vote135 views1 answer
Error correction in qr code php
PHP
2 votes152 views1 answer
Add to url anchor tag laravel with variable
PHP Laravel
0 vote197 views1 answer
Double where condition in laravel
PHP
3 votes121 views6 answers
Php remove value from array if exists
PHP