recipeData.php

<?php
//checks for active session, if none, start a new session.
if (session_status() == PHP_SESSION_NONE) {
    session_start();
}

date_default_timezone_set('Asia/Kuala_Lumpur');


//phpMyAdmin credentials
$servername = "localhost";
$username = "root";
$password = "10101010";
$dbname = "overcooked";

//connect to database table
$conn = mysqli_connect($servername, $username, $password, $dbname) or die('Database connection error');



$query = "SELECT * FROM recipeData WHERE `rID` = ".$_GET['id']."";
$results = mysqli_query($conn, $query);
$rows = [];

while($row = mysqli_fetch_assoc($results)) {
    $rows[] = $row;

    $rJSON = json_encode($row);
    $rArray = json_decode($rJSON, true);
    $rID = $rArray['rID'];
    $rTitle = $rArray['rTitle'];
    $rDesc = $rArray['rDesc'];
    $rAuthor = $rArray['rAuthor'];
    $rDate = $rArray['rDate'];
    $rSteps = str_replace(";","<br><li>",$rArray['rSteps']);
    $rIng = str_replace(";","<br><li>",$rArray['rIng']);
    $rImage = $rArray['rImage'];
    $rTag1 = $rArray['rTag1'];
    $rTag2 = $rArray['rTag2'];
    $rTag3 = $rArray['rTag3'];
    $rCooktime = $rArray['rCooktime'];
}
?>