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

0 vote190 views3 answers
Add factory data laravel
PHP Laravel
0 vote162 views1 answer
Laravel many to many migration
PHP
0 vote175 views1 answer
How to get yearly chart in laravel
PHP Laravel
0 vote276 views1 answer
Laravel media library regenerate
PHP Laravel
0 vote147 views3 answers
Remove string after comma in php
PHP
1 vote231 views1 answer
Wordpress echo the excerpt
PHP
1 vote145 views1 answer
How to add dummy records using factory in laravel 8
PHP
0 vote153 views1 answer
Gravity Form Shortcode Wordpress
PHP Wordpress
2 votes154 views1 answer
Redirect on validation error laravel to specific section laravel
PHP Laravel
4 votes170 views5 answers
Removing index.php in codeigniter
PHP