folderpreview.php

<?php $sqlpath = $_SERVER['DOCUMENT_ROOT'];
$sqlpath .= "/sql-connect.php";
include_once($sqlpath);

$parent = $_REQUEST['parent'];
$folderpreviews = array();
$sql = "SELECT * FROM notes WHERE lineage LIKE '%$parent%' ORDER BY edited DESC";
$sqldata = mysqli_query($dbcon, $sql) or die('error getting data');
while($row =  mysqli_fetch_array($sqldata, MYSQLI_ASSOC)) {
  if (str_ends_with($row['lineage'], '-'.$parent.'-'.$row['id']) ||$row['lineage'] == $parent.'-'.$row['id']){
    
    // Define the pattern to search for the <h1> header
    $pattern = '/<h1>(.*?)<\/h1>/';

    // Define the replacement with an anchor tag
    $replacement = '<a href="#" onclick="showpanel(' . $row['id'] . '); return false;" style="color: inherit; text-decoration: inherit;"><h1>$1</h1></a>';

    // Perform the replacement
    $updatedBody = preg_replace($pattern, $replacement, $row['body']);

    array_push($folderpreviews, $updatedBody, $row['id']);
  }
}
echo json_encode($folderpreviews);

?>