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 vote107 views1 answer
Php 3 months ago
PHP
6 votes114 views2 answers
Php empty object
PHP
1 vote109 views2 answers
Codeigniter order by
PHP
1 vote114 views4 answers
Create laravel project specific version
PHP
0 vote125 views2 answers
How to implement maatwebsite excel in my laravel project
PHP
0 vote106 views1 answer
<a href="<?php echo base_url(); ?>">somelink</a>
PHP
0 vote118 views1 answer
Use ternary operator as null coalescing operator in php
PHP
6 votes136 views2 answers
Laravel findorfail
PHP Laravel
14 votes115 views4 answers
How to get javascript variable value in php
PHP
0 vote157 views1 answer
Redirect all request to public folder laravel htaccess
PHP Laravel