Step 5: Insert results into the Database

fb_collect.php

/*************************************************************************************
5. Insert the results into the database using a prepared statement and a foreach loop.
**************************************************************************************/
foreach ($fb_array[data] as $i) {
    
    
    $stmt1=$conn->prepare("INSERT INTO fb_api_results
    (FID, 
    fb_web,
    fb_cover,
    fb_about,
    fb_culinary_team,
    fb_description,
    fb_name, 
    fb_likes, 
    fb_were_here, 
    fb_talking_about, 
    fb_street, 
    fb_city, 
    fb_state, 
    fb_zip, 
    fb_lat, 
    fb_lng)
    VALUES
    (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
    
    
$stmt1->bind_param("dssssssiiisssidd", 
        $FID, 
        $fb_web, 
        $fb_cover, 
        $fb_about, 
        $fb_culinary_team, 
        $fb_description, 
        $fb_name, 
        $fb_likes, 
        $fb_were_here, 
        $fb_talking_about, 
        $fb_street, 
        $fb_city, 
        $fb_state, 
        $fb_zip, 
        $fb_lat, 
        $fb_lng);
    
    
        $FID=               mysqli_real_escape_string($conn, $i['id']);
        $fb_web=            mysqli_real_escape_string($conn, $i['website']);
        $fb_cover=          mysqli_real_escape_string($conn, $i['cover']['source']);
        $fb_about=          mysqli_real_escape_string($conn, $i['about']);
        $fb_culinary_team=  mysqli_real_escape_string($conn, $i['culinary_team']);
        $fb_description=    mysqli_real_escape_string($conn, $i['description']);
        $fb_name=           mysqli_real_escape_string($conn, $i['name']);
        $fb_likes=          mysqli_real_escape_string($conn, $i['likes']);
        $fb_were_here=      mysqli_real_escape_string($conn, $i['were_here_count']);
        $fb_talking_about=  mysqli_real_escape_string($conn, $i['talking_about_count']);
        $fb_street=         mysqli_real_escape_string($conn, $i['location']['street']);
        $fb_city=           mysqli_real_escape_string($conn, $i['location']['city']);
        $fb_state=          mysqli_real_escape_string($conn, $i['location']['state']);
        $fb_zip=            mysqli_real_escape_string($conn, $i['location']['zip']);
        $fb_lat=            mysqli_real_escape_string($conn, $i['location']['latitude']);
        $fb_lng=            mysqli_real_escape_string($conn, $i['location']['longitude']);
    
    $stmt1->execute();
}
$stmt1->close();
?>