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

5 votes176 views3 answers
Display all errors in blade laravel
PHP Laravel
1 vote137 views1 answer
Default time of session in php
PHP
14 votes169 views4 answers
Php get index of string
PHP
1 vote127 views1 answer
And php
PHP
0 vote131 views1 answer
Install php apache
PHP
2 votes131 views2 answers
Last insert id model codeigniter
PHP
1 vote172 views2 answers
Laravel route group middleware prefix
PHP Laravel
0 vote148 views1 answer
Create if not exist laravel
PHP
0 vote150 views2 answers
Wordpress wp_logout_url redirect
PHP Wordpress
1 vote181 views1 answer
Php 8 major changes - Nullsafe operator
PHP