<?php
$path = $_SERVER["DOCUMENT_ROOT"];
include_once $path."/connect_db.php";

if (isset($_GET["area_id"])) {

    $area_id = addslashes($_GET["area_id"]);

    $res_location = $connect->query("SELECT * FROM `locations` WHERE `area_id` = '{$area_id}' LIMIT 1");
    $row_loc = $res_location->fetch_array(MYSQLI_ASSOC);

    $meta_title = $row_loc["meta_title"];
    $meta_description = $row_loc["meta_description"];
    $page_title = $row_loc["page_title"];
    $page_text = $row_loc["page_text"];
    $area_parent_name = $row_loc["area_parent_name"];
    

    echo '<form action="" method="post">
    <div class="form-group">
            <label for="">Meta Title</label>
            <input type="text" placeholder="Enter page meta title.." value="'.$meta_title.'" class="form-control" name="meta_title">
    </div>
    <div class="form-group">
            <label for="">Meta Description</label>
            <textarea type="text" placeholder="Enter meta description.." class="form-control" name="meta_description">'.$meta_description.'</textarea>
    </div>
    <div class="form-group">
            <label for="">Page Title</label>
            <input type="text" placeholder="Enter page title.." value="'.$page_title.'" class="form-control" name="page_title">
    </div>
    <div class="form-group">
            <label for="">Page Text</label>
            <textarea type="text" placeholder="Enter page text.." class="form-control" name="pagetext">'.$page_text.'</textarea>
    </div>
    <input type="text" name="area_id" value="'.$area_id.'" hidden>
<input type="text" name="area_parent_name" value="'.$area_parent_name.'" hidden>
    <br>
    <div class="form-group">
            <button type="submit" name="submitedit" class="btn btn-primary">Save changes</button>
    </div>
</form>';
}else{
    echo "Something went wrong";
}

?>