convertcheckboxes.php

<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);
$sqlpath = $_SERVER['DOCUMENT_ROOT'];
$sqlpath .= "/sql-connect.php";
include_once($sqlpath);

$parsepath = $_SERVER['DOCUMENT_ROOT'];
$parsepath .= "/plugins/Parsedown.php";
include_once($parsepath);

$parsedown = new Parsedown();

// Fetch the data from your database
$sql = "SELECT * FROM notes";
$sqldata = mysqli_query($dbcon, $sql) or die('Error getting data');

// Loop through each record
while ($row = mysqli_fetch_assoc($sqldata)) {
    $noteID = $row['id'];  // Assuming there's an 'id' column in your 'notes' table
    $htmlContent = $row['body'];  // Get the already parsed HTML content

    // Replace Markdown checkboxes with HTML checkboxes
    $htmlContent = preg_replace_callback(
        '/\[\s?([x ]?)\]/',  // Match [ ] or [x]
        function($matches) {
            // If the box is checked ([x]), add the checked attribute
            $checked = ($matches[1] === 'x') ? 'checked' : '';
            return '<input type="checkbox" ' . $checked . ' disabled>';
        },
        $htmlContent
    );

    // Update the content in the database with the new HTML checkboxes
    $updateSql = "UPDATE notes SET body = ? WHERE id = ?";
    $stmt = $dbcon->prepare($updateSql);
    if (!$stmt) {
        die('Statement preparation failed: ' . $dbcon->error);
    }
    $stmt->bind_param("si", $htmlContent, $noteID);  // 's' for string, 'i' for integer
    $stmt->execute();

    if ($stmt->affected_rows > 0) {
        echo "Note ID $noteID updated successfully.<br>";
    } else {
        echo "Error updating Note ID $noteID.<br>";
    }
}

echo "All selected notes processed and updated with checkboxes.";
?>