Gathering data from MYSQL table

Asked Mar 09 '17 at 11:44

Active Mar 09 '17 at 12:01

Viewed 32 times

I am trying to collect data from a few attribues from a MYSQL database to be viewed on a webpage, but I have an error somewhere in my code and really cannot figure it out. Please be patient since I am new to this. Below is my code:

<html>
    <head>
        <meta content="text/html; charset=ISO-8859-1"  http-equiv="content-type">
        <title>
            Food Orders 
        </title>
        <link rel="stylesheet" type ="text/css" href="default.css">
    </head>
    <body>
        <?php
        $server_name = "localhost";
        $user_name = "root";
        $password = "my_pass";
        $database_name = "menudb";
        $connection = new mysqli($server_name, $user_name, $password, $database_name);
        if ($connection->connect_error) {
            die("Connection Error: " . $connection->connect_error);
        }
        $attributes "SELECT tablenumber, food FROM clients";
        $results = $connection->query($attributes);
        if ($results->num_rows > 0) {
            while ($rows = $results->fetch_assoc()) {
                echo "Table Number: " . $rows["tablenumber"]. " Food Item: " . $rows ["food"].
                    "<br>";
            }
        } else {
            echo "No Results";
        }
        $connection->close();
        ?>
    </body>
</html>

Thanks in advance

edited Mar 09 '17 at 12:01

asked Mar 09 '17 at 11:44

IanD

wht is your error?? – Vimal Mar 09 '17 at 11:45
page cannot be displayed since i am trying to run the .php on a browser – IanD Mar 09 '17 at 11:48
@IanD Install a webserver locally for that matter. – Niek van der Maaden Mar 09 '17 at 11:51
A webserver is installed. It is run on a Raspberry PI3 using Apache2 webservice – IanD Mar 09 '17 at 11:54
$attributes "SELECT tablenumber, food FROM clients"; " = " is missing here. – Muthu17 Mar 09 '17 at 12:12
where should the " = " be placed ? after the attributes ? – IanD Mar 09 '17 at 12:36
This issue is solved. Thanks – IanD Mar 09 '17 at 13:07
Quick question. Is it possible to insert a
after each record? Thanks – IanD Mar 09 '17 at 13:50

Gathering data from MYSQL table

0 Answers0