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

9 votes169 views5 answers
Return view with variable laravel
PHP Laravel
0 vote135 views1 answer
Laravel eloquent many to many query using whereHas
PHP
2 votes133 views2 answers
Laravel eloquent randomise data from database
PHP
1 vote137 views1 answer
How to upload pdf file using php
PHP
0 vote130 views1 answer
Dynamic base url
PHP
0 vote146 views1 answer
Multi file delete in php
PHP
0 vote150 views1 answer
Fetch values and display in bar chart php mysql
PHP
3 votes144 views4 answers
Round() laravel
PHP
0 vote213 views1 answer
Create symfony demo app
PHP Symfony
0 vote183 views4 answers
Laravel get last created id
PHP Laravel