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

15 votes150 views3 answers
Laravel timezone
PHP Laravel
0 vote110 views1 answer
Create table laravel give name table
PHP
0 vote109 views1 answer
Wordpress add to cart redirect php
PHP
9 votes125 views3 answers
Wp_enqueue_script
PHP
0 vote118 views1 answer
Wordpress if is not page template
PHP
0 vote127 views1 answer
Change request value laravel
PHP
5 votes150 views3 answers
Mobile number validation in laravel 8
PHP Laravel
3 votes123 views1 answer
Back route laravel
PHP
0 vote146 views1 answer
Pusher in laravel array_merge(): Argument #2 is not an array
PHP Laravel
0 vote129 views1 answer
Php ffi get load average
PHP