<?php
$conn = new mysqli('localhost', 'root', '', 'granny_restaurant');

echo "Recipes table structure:\n";
$result = $conn->query('DESCRIBE recipes');
while ($row = $result->fetch_assoc()) {
    echo $row['Field'] . ' - ' . $row['Type'] . "\n";
}

echo "\n\nActual recipe data (raw SQL):\n";
$result = $conn->query('SELECT * FROM recipes LIMIT 2');
while ($row = $result->fetch_assoc()) {
    print_r($row);
}
