我无法使用php连接到phpmyadmin

Question

I'm obviously new to PHP, and I've been asked by a friend to create a dynamic blog that could use continuously. I wanted it to connect to phpMyAdmin so it would be easier, but when I try to connect with it to my web page, it always fails and my set error appears. I don't know what to look up to help me. I'm sorry if I'm not clear. Post if you want me to go more into detail.

Here's my code:

<?php



$dbhost = 'localhost';

$dbuser = ' root';

$dbpass = '';

$dbname = 'blog1';

$connect = mysqli_connect($dbname, $dbuser, $dbhost, $dbpass) or die ('Cannot connect to database.');

echo "Succesfully connected to database!";



?>

Answer 1

Test This

<?php
$dbhost = 'localhost';

$dbuser = ' root';

$dbpass = '';

$dbname = 'blog1';

$connect = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or die ('Cannot connect to database.');

echo "Succesfully connected to database!";

The mysqli_connect() was called in wrong way.

Answer 2

$dbhost = 'localhost';

    $dbuser = 'root';

    $dbpass = 'root123';

    $dbname = 'mydb';

    $connect = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or die ('Cannot connect to database.');

If you run PHPMyAdmin on localhost uncomment in file:

sudo gedit /etc/php5/apache2/php.ini

this line: mysqli.allow_local_infile = On

Restart Apache:

sudo /etc/init.d/apache2 restart or   sudo service apache2 restart