@ 2024-06-18T18:34:05Z <?php
function KB_ArticlesList() {
XeinzKB_Menu_Top();
Echo "<div><a href='index.php?page=kb_kb'>KBs</a> >>> ".(new KB($_REQUEST['KBid']))->KBname()." >>> <a href='index.php?page=XeinzKB_ArticlesList&KBid={$_REQUEST['KBid']}'>Articles List</a></div> ";
if (empty($_REQUEST['KBid'])) {
Echo "<div class='redbox'>Sorry, KBid is required here.</div>";
return;
}
$query = "SELECT KBArt.id,
KBArt.sectionid,
KBArtparent.title as parenttitle,
KBArt.original_html,
KBArt.html,
KBArt.title,
KBArt.uniqid,
KBsec.name,
(SELECT STRING_AGG(keyword, ', ') FROM [KBKeywords] WHERE article=KBArt.id) as keywords
FROM [WP_PORTALSUPPORT].[dbo].[KBArticle] KBArt
inner join XeinzKBSections KBSec
on KBArt.sectionid=KBSec.id
left outer join KBArticle KBartparent
on KBArt.parentarticleid=KBartparent.id
where KBsec.KBid= :KBid
Order By KBArt.id";
$bindings = array(':KBid' => $_REQUEST['KBid']);
$result = (new PORTAL())->get_array($query, $bindings);
datatables_newdatatable('KBArticleList');
Echo "<table class='w-100' id='KBArticleList'>
<thead>
<tr>
<th><b>Section</b><br><i>Parent</i></th>
<th>Title</th>
<th>Keywords</th>
<th></th>
</tr>
</thead>
<tbody>";
foreach ($result as $value) {
Echo " <tr id='ArticleBookMark{$value['id']}'>
<td>
<b>{$value['name']}</b><br>
<i>{$value['parenttitle']}</i>
</td>
<td>{$value['title']}</td>
<td>{$value['keywords']}</td>
<td>
<form name='form' method='post' action='index.php' >
<input name='page' value='KB_Article' type='hidden'>
<input name='article' value='{$value['id']}' type='hidden'>
<button class='btn btn-primary' type='submit'>Edit</button>
</form>
</td>
</tr>";
}
Echo "</tbody></table>";
}
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).
Version System time (s) User time (s) Memory (MiB) 8.4.12 0.011 0.010 20.64 8.4.11 0.015 0.004 22.47 8.4.10 0.012 0.007 17.70 8.4.9 0.013 0.008 18.52 8.4.8 0.011 0.009 19.33 8.4.7 0.013 0.003 17.76 8.4.6 0.014 0.008 18.74 8.4.5 0.006 0.014 19.04 8.4.4 0.006 0.013 17.69 8.4.3 0.013 0.007 18.73 8.4.2 0.003 0.005 21.55 8.4.1 0.004 0.004 19.37 8.3.25 0.006 0.003 19.04 8.3.24 0.004 0.004 16.74 8.3.23 0.011 0.007 16.50 8.3.22 0.007 0.004 17.09 8.3.21 0.004 0.004 18.43 8.3.20 0.004 0.005 16.44 8.3.19 0.008 0.009 17.18 8.3.18 0.014 0.005 17.07 8.3.17 0.011 0.007 20.66 8.3.16 0.014 0.004 16.39 8.3.15 0.009 0.009 17.09 8.3.14 0.005 0.003 16.37 8.3.13 0.004 0.004 18.24 8.3.12 0.004 0.004 16.57 8.3.11 0.003 0.007 16.50 8.3.10 0.006 0.003 16.36 8.3.9 0.011 0.003 18.30 8.3.8 0.009 0.011 30.84 8.3.7 0.000 0.008 30.84 8.3.5 0.005 0.003 30.84 8.2.29 0.011 0.007 20.67 8.2.28 0.010 0.010 18.46 8.2.27 0.010 0.006 17.23 8.2.26 0.004 0.004 17.19 8.2.25 0.004 0.004 16.74 8.2.24 0.005 0.005 18.60 8.2.23 0.003 0.006 20.94 8.2.22 0.008 0.000 24.06 8.2.21 0.005 0.005 26.77 8.2.20 0.008 0.000 30.84 8.2.19 0.006 0.003 30.84 8.1.33 0.010 0.009 23.54 8.1.32 0.011 0.007 15.73 8.1.31 0.014 0.003 18.36 8.1.30 0.010 0.010 16.17 8.1.29 0.003 0.012 30.84
preferences:dark mode live preview ace vim emacs key bindings
52.24 ms | 403 KiB | 5 Q