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

2 votes230 views2 answers
Laravel pagination with get parameters
PHP
0 vote237 views1 answer
Morph laravel without classes name
PHP Laravel
0 vote226 views1 answer
Pdo php search table
PHP
0 vote218 views1 answer
Redirect 404 in laravel
PHP
-1 vote283 views1 answer
Php get file location
PHP
0 vote222 views1 answer
Wordpress widget categories edit
PHP
1 vote239 views1 answer
Laravel + join 2 eloquent queries
PHP Laravel
0 vote215 views1 answer
Laravel sanctum Protecting routes
PHP Laravel
5 votes236 views2 answers
Time to string in php
PHP
0 vote224 views1 answer
Php text in thml
PHP