Showing data from MYSQL with a PHP connection shows nothing

166

January 03, 2018, at 9:13 PM

ob_start();
include("create.php");
ob_end_clean();
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "uploads";
$conn = new mysqli($servername, $username, $password, $dbname);
$sql = "SELECT * from submits (title, description, net)";
foreach ($conn->query($sql) as $row) {
        print $row['title'] . "\t";
        print $row['description'] . "\t";
        print $row['net'] . "\n";
    }

I am trying to get data from the submits table and get title, description and net and echo it out into the page. All the queries into the database are done from create.php. Why is me selecting from the database not printing ANYTHING into the page? (Yes there are things in the database the database is NOT empty.)

Answer 1

Here is what I think should work.
It uses fetch_assoc()

$conn = new mysqli($servername, $username, $password, $dbname);
$sql = "SELECT * from submits (title, description, net)";
$result = $conn->query($sql);
while ($row = $result->fetch_assoc()) {
    print $row['title'] . "\t";
    print $row['description'] . "\t";
    print $row['net'] . "\n";
}