Online PHP editor | rfc for 9GnKm

<?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>"; }

3v4l.org

Active branches

Archived branches