1

I am using Ubuntu 14.04 and I am using lamp. I had a more complex issue but I figured out what is causing the error and made a small php-mysql connection snippet. When the connection file is included into the php/html file the whole thing displays a blank page.

My connect.php code:

  <?php
$db_host = "localhost";
$db_user = "root";
$db_pass = "";
$db_name = "ecalendar";
$conn = mysqli_connect($db_host,$db_user,$db_pass,$db_name);
if(mysqli_connect_errno(){
    echo "Error".mysqli_connect_errno();
}

?>

and my web page with connection file included:

    <?php
include "connect.php";
?>
<!DOCTYPE html>
<html>
<head>
    </head>
    <body>
        <p>Testing</p>
        <?php
            $sql="SELECT * FROM events WHERE eventid=1";
            $result = mysqli_query($sql);

        ?>
        <ul>
            <li><?php $row = mysqli_fetch_array($result);
                echo $result;

             ?>
            </li>
    </body>
</html>
<?php
mysqli_close($conn);
?>
Ihsan Izwer
  • 133
  • 2
  • 11
  • 2
    Check your Apache logs. – D4V1D Sep 16 '15 at 09:23
  • 1
    Could you turn error reporting on ? – Simon Duflos Sep 16 '15 at 09:24
  • [Turn error reporting on](http://stackoverflow.com/questions/1053424/how-do-i-get-php-errors-to-display) so that you can see a description of what's wrong. If you still can't solve the issue after reading the error, post the error message here. – Andrew Sep 16 '15 at 09:31

1 Answers1

2

The following line in connect.php:

if(mysqli_connect_errno(){

Should be:

if(mysqli_connect_errno()){ // note the extra ')'

You were not properly enclosing your condition with ().

D4V1D
  • 5,805
  • 3
  • 30
  • 65
  • Thanks D4V1D now the page is displaying but still the database record isn't displaying in the page – Ihsan Izwer Sep 16 '15 at 09:27
  • So your question has been resolved. You should ask another one and, in the meantime, accept the one that solves your problem. Also, try `echo`ing `$row` instead of `$result`. – D4V1D Sep 16 '15 at 09:28
  • Thanks D4VID. The $row didn't work. I'll search on that. Yes my question has been resolved – Ihsan Izwer Sep 16 '15 at 09:34
  • @D4V1D problem in this line `` OP is try to echo `$result` instead `print_r($row);` – Saty Sep 16 '15 at 09:39