File: /var/www/html/tmpr/..//tmpr/../tmpr/..//tmpr/../tmpr/../tmpr/../insights/ai-insights-details.php
<?php
/* $host = 'localhost';
$dbname = 'thebrand';
$username = 'root';
$password = 'Pw4TheBrand!';
$pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);*/
// Pagination setup
$limit = 1;
$id = $_GET['id'];
$sql1 = "SELECT COUNT(*) FROM prompts2 where ID = $id";
$sql2 = "SELECT * FROM prompts2 where ID = $id LIMIT :limit OFFSET :offset";
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$offset = ($page - 1) * $limit;
// Fetch total count
$totalStmt = $pdo->query($sql1);
$totalRows = $totalStmt->fetchColumn();
$totalPages = ceil($totalRows / $limit);
// Fetch data with pagination
$stmt = $pdo->prepare($sql2);
$stmt->bindValue(':limit', $limit, PDO::PARAM_INT);
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->execute();
$prompts = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
<link rel="stylesheet" href="assets/vendor/css/pages/insights-details.css"/>
<?php foreach ($prompts as $prompt) : ?>
<?php $parts = explode('-', $prompt['Community']);
// Get the first part (before the hyphen)
$communityExtracted = $parts[0];
$breadcrumbs = explode('/', trim($prompt['CanonicalURL'], '/'));
// Extract first and second breadcrumbs
$firstBreadcrumb = $breadcrumbs[0] ?? '';
$secondBreadcrumb = $breadcrumbs[1] ?? '';
// Get current blog title
$current_title = $prompt['Title']; // Example title
$keywords = extractKeywords($current_title);
// Fetch related content using FULLTEXT search
$sqlrelated = "SELECT * FROM prompts2 WHERE MATCH(Title, Teaser) AGAINST(:keywords IN NATURAL LANGUAGE MODE) LIMIT 10";
$stmt = $pdo->prepare($sqlrelated);
$stmt->bindParam(":keywords", $keywords, PDO::PARAM_STR);
$stmt->execute();
$resultsRelated = $stmt->fetchAll(PDO::FETCH_ASSOC);
print_r($resultsDesignsRelated);
// Manually filter out the current ID
$current_id = $prompt['ID'];
$filteredResults = array_filter($resultsRelated, function ($row) use ($current_id) {
return $row['ID'] != $current_id;
});
// Re-index array (optional)
$resultsRelated = array_values($filteredResults);
//related designs
error_reporting(E_ALL); // Report all errors
ini_set('display_errors', '1'); // Display errors on screen
// Fetch related content using FULLTEXT search
$sqlrelateddesign = "SELECT slug,alias,id,title,poster,keywords FROM profilepicture WHERE MATCH(title, keywords) AGAINST(:keywords IN NATURAL LANGUAGE MODE) LIMIT 10";
$stmtddesign = $pdo->prepare($sqlrelateddesign);
$stmtddesign->bindParam(":keywords", $keywords, PDO::PARAM_STR);
$stmtddesign->execute();
$resultsDesignsRelated = $stmtddesign->fetchAll(PDO::FETCH_ASSOC);
?>
<div class="row g-6">
<div class="col-lg-8">
<div class="card">
<div class="card-body">
<div class="d-flex justify-content-between align-items-center flex-wrap mb-6 gap-2">
<div class="me-1">
<h3 class="mb-0">
<?= htmlspecialchars($prompt['Title']) ?>
</h3>
<p class="mb-0">Category: <span
class="fw-medium text-heading"> <!-- <?/*= htmlspecialchars($firstBreadcrumb) */?>
/ --><?/*= htmlspecialchars($secondBreadcrumb) */?>
<?= htmlspecialchars($prompt['Category']) ?>
</span></p>
</div>
<div class="d-flex align-items-center">
<span class="badge bg-label-danger"><?= htmlspecialchars($communityExtracted) ?></span>
<i class='bx bx-share-alt bx-lg mx-4'></i>
<i class='bx bx-bookmarks bx-lg'></i>
</div>
</div>
<div class="card academy-content shadow-none border">
<div class="p-2">
<div class="cursor-pointer rounded-2 "
style="height: 400px; display: flex; align-items: center; justify-content: center; overflow:hidden">
<?php
$pichaID = $prompt['ID'];
$file = "assets/images/$pichaID.png";
if (file_exists($file) && is_file($file)) {
$picha = "$siteaddress2/assets/images/$pichaID.png";
} else {
$picha = "assets/img/pages/app-academy-tutor-1.png";
}
?>
<img class="img-fluid"
src="<?php echo $siteaddress2; ?>/assets/images/<?php echo $pichaID; ?>.png"
alt="Prompt Image">
</a>
</div>
</div>
<div class="card-body pt-4">
<h5>About this insight</h5>
<p class="mb-0"><?= htmlspecialchars($prompt['Teaser']) ?></p>
<hr class="my-6">
<h5>Example how to use AI Insight</h5>
<div class="d-flex flex-wrap row-gap-2">
<div class="me-12">
<p class="text-nowrap mb-2"><i
class='bx bx-check me-2 align-bottom'></i><?= htmlspecialchars($prompt['PromptHint']) ?>
</p>
</div>
</div>
<hr class="my-6">
<div class="mb-6">
<div class="chat-history-footer shadow-xs">
<div class="message-actions d-flex align-items-center">
<a data-bs-toggle="offcanvas" data-bs-target="#useInsight" aria-controls="offcanvasBackdrop" class="card-link">
<button class="btn btn-warning d-flex send-msg-btn btn-lg">
<span class="align-middle d-md-inline-block d-none">Use this insight</span>
<i class="bx bx-paper-plane bx-sm ms-md-2 ms-0"></i>
</button></a>
<!--
<button class="btn btn-primary btn-page-block-custom">
Custom Message
</button>
-->
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="col-lg-4">
<div class="accordion stick-top accordion-custom-button" id="courseContent">
<div class="accordion-item active mb-0">
<div class="accordion-header" id="headingOne">
<button type="button" class="accordion-button " data-bs-toggle="collapse"
data-bs-target="#chapterOne" aria-expanded="true" aria-controls="chapterOne">
<span class="d-flex flex-column">
<span class="h5 mb-0">Related Insights</span>
<span class="text-body fw-normal"> Based on <?= htmlspecialchars($prompt['Title']) ?></span>
</span>
</button>
</div>
<div id="chapterOne" class="accordion-collapse collapse show" data-bs-parent="#courseContent">
<div class="accordion-body py-4" style="max-height: 300px; overflow-y: auto ">
<?php
// Display related posts
if ($resultsRelated) {
echo ' <div class="card-body pt-4">
<ul class="p-0 m-0">';
foreach ($resultsRelated as $rowRelated) {
$partsX = explode('-', $rowRelated['Community']);
// Get the first part (before the hyphen)
$communityExtractedX = $partsX[0];
$pichaIDRelated = $rowRelated['ID'];
$file = "assets/images/$pichaIDRelated.png";
if (file_exists($file) && is_file($file)) {
$pichaIDRelated = "$siteaddress2/assets/images/$pichaIDRelated.png";
} else {
$pichaIDRelated = "assets/img/pages/app-academy-tutor-1.png";
}
echo ' <li class="d-flex align-items-center mb-6">
<div class="avatar flex-shrink-0 me-3">
<img src="'. $pichaIDRelated .'" alt="User" class="rounded">
</div>
<div class="d-flex w-100 align-items-center gap-2" style="position: relative;">
<div class="d-flex justify-content-between flex-grow-1 flex-wrap">
<div>
<a href="dashboard?feature=ai-insights-details&id='. htmlspecialchars($rowRelated["ID"]) .'"><h6 class="mb-0 fw-normal">'. htmlspecialchars($rowRelated["Title"]) .' </h6></a>
<small> '.htmlspecialchars($communityExtractedX).' </small>
</div>
</div>
<div class="resize-triggers">
<div class="expand-trigger">
<div style="width: 379px; height: 44px;"></div>
</div>
<div class="contract-trigger"></div>
</div>
</div>
</li>';
}
echo ' </ul>
</div>';
}
?>
</div>
</div>
</div>
<div class="accordion-item">
<div class="accordion-header" id="headingTwo">
<button type="button" class=" accordion-button collapsed" data-bs-toggle="collapse"
data-bs-target="#chapterTwo" aria-expanded="false" aria-controls="chapterTwo">
<span class="d-flex flex-column">
<span class="h5 mb-0"> Related Designs </span>
<span class="text-body fw-normal"> Based on <?= htmlspecialchars($prompt['Title']) ?></span>
</span>
</button>
</div>
<div id="chapterTwo" class="accordion-collapse " data-bs-parent="#courseContent">
<div class="accordion-body py-4" style="max-height: 300px; overflow-y: auto ">
<?php
if ($resultsDesignsRelated) {
echo ' <div class="card-body pt-4">
<ul class="p-0 m-0">';
foreach ($resultsDesignsRelated as $rowRelatedDesign) {
// $partsX = explode('-', $rowRelatedDesign['Community']);
// Get the first part (before the hyphen)
// $communityExtractedX = $partsX[0];
$pichaIDRelated = $rowRelatedDesign['poster'];
$file = "https://www.thebrand.ai/taswira.php?width=80&height=80&quality=70&cropratio=1:1&image=/v/uploads/gallery/$pichaIDRelated";
echo ' <li class="d-flex align-items-center mb-6">
<div class="avatar flex-shrink-0 me-3">
<img src="'. $file .'" alt="User" class="rounded">
</div>
<div class="d-flex w-100 align-items-center gap-2" style="position: relative;">
<div class="d-flex justify-content-between flex-grow-1 flex-wrap">
<div>
<a href="https://www.thebrand.ai/i/' . $rowRelatedDesign['alias'] . '" target="_blank"><h6 class="mb-0 fw-normal">'. htmlspecialchars($rowRelatedDesign["title"]) .' </h6></a>
</div>
</div>
<div class="resize-triggers">
<div class="expand-trigger">
<div style="width: 379px; height: 44px;"></div>
</div>
<div class="contract-trigger"></div>
</div>
</div>
</li>';
}
echo ' </ul>
</div>';
}?>
</div>
</div>
</div>
</div>
</div>
</div>
<?php endforeach; ?>
<!-- Page JS -->
<script src="assets/js/insight-details.js"></script>