accessing the database via index.php

john47

I have code using Jopmla 3 (used in https://www.stmaryscalne.org/index.php/academic) written below and it enables me to style pages according to their id, category or parent category. I used it for having different banner images for different categories.

Unfortunately it doesn't work with Joomla 4 as some at least of the code is deprecated. Any help appreciated.

<!-- John's script for body tags -->	
<?php
  $id = JRequest::getInt('id');
  $view = JRequest::getCmd('view', 0);
  $db = &JFactory::getDBO();
  $db->setQuery('SELECT catid FROM #__content  WHERE id='.$id);   
  $cat_id = $db->loadResult();

// if (JRequest::getInt('id') == ('1774') ) :``
if ($cat_id >= ('0') ) :
{
$db->setQuery('SELECT parent_id FROM #__categories WHERE id='.$cat_id);

$parent_cat_id = $db->loadResult();
}
endif;
if ($cat_id == '' ) :
{
$parent_cat_id = 'blank';
$cat_id = 'blank';
}
endif;
?>


<body class = " {t4post:bodyclass} parent_cat_id_<?php echo $parent_cat_id; ?> cat_id_<?php echo $cat_id; ?> menu_id_<?php echo JRequest::getInt('Itemid'); ?> article_id_<?php echo JRequest::getInt('id'); ?>    view_<?php echo $view; ?>   "> 

RESULT!

<body class = " site-home-slider-only navigation-default theme-default layout-default-slider-only nav-breakpoint-lg com_content view-article item-1698 parent_cat_id_7 cat_id_8 menu_id_1698 article_id_8    view_article   ">

saguaros

Hi john47

JRequest class has been changed in even J3, and it entirely doesn't exist in 4.0. You should put in Joomla forum for further help in this customization.

https://docs.joomla.org/Retrieving_request_data_using_JInput
https://api.joomla.org/cms-3/classes/Joomla.CMS.Input.Input.html

Regards

john47

Hi Saguaros

I can't find a standard index.php file in the T4_bs5_blank template, just a small amount of code. There are lots of json files but I am lost!

I got some advice on the Joomla forum and have created a new file (‎/local/html/layouts/t4/index.php) by adapting code from the cassiopeia template and a previous version of the t4 index.php file.

It gives this info which others might find helpful ..
<body class="
site-default navigation-default theme-default layout-default nav-breakpoint-lg oc-desktop com_content view-article item-973 site id-32 catid-44 parentid-41">

I am sure this can be improved!

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="{t4:language}" lang="{t4:language}" dir="{t4:direction}">

<head>
  {t4:system_advancedCodeAfterHead}
  {t4post:head}

  <!--[if lt IE 9]>
    <script src="<?php echo JUri::root(true); ?>/media/jui/js/html5.js"></script>
  <![endif]-->
  <meta name="viewport"  content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=yes"/>
  <style  type="text/css">
    @-webkit-viewport   { width: device-width; }
    @-moz-viewport      { width: device-width; }
    @-ms-viewport       { width: device-width; }
    @-o-viewport        { width: device-width; }
    @viewport           { width: device-width; }
  </style>
  <meta name="HandheldFriendly" content="true"/>
  <meta name="apple-mobile-web-app-capable" content="YES"/>
  <!-- //META FOR IOS & HANDHELD -->
  
 <?php 
  use Joomla\CMS\Factory;
use Joomla\CMS\HTML\HTMLHelper;
use Joomla\CMS\Language\Text;
use Joomla\CMS\Uri\Uri;

/** @var Joomla\CMS\Document\HtmlDocument $this */

$app = Factory::getApplication();
// $wa  = $this->getWebAssetManager();
 ?> 
 <?php 
// Detecting Active Variables
// $option   = $app->input->getCmd('option', '');
// $view     = $app->input->getCmd('view', '');
// $layout   = $app->input->getCmd('layout', '');
// $task     = $app->input->getCmd('task', '');
$itemid   = $app->input->getCmd('Itemid', '');
$id   = $app->input->getCmd('id', '');
// $catid   = $app->input->getCmd('catid', '');

// $sitename = htmlspecialchars($app->get('sitename'), ENT_QUOTES, 'UTF-8');
// $menu     = $app->getMenu()->getActive();
// $pageclass = $menu !== null ? $menu->getParams()->get('pageclass_sfx', '') : '';
 ?> 
  
  

 <!-- John's script for body tags -->	
	<?php	
$input = Factory::getApplication()->input;
$view = $input->get('view', 0);


$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select($db->quoteName('catid'));
$query->from($db->quoteName('#__content'));
$query->where($db->quoteName('id') . ' = ' . $db->quote($id));
$db->setQuery($query);
$catid = $db->loadResult();

$query = $db->getQuery(true);
$query->select($db->quoteName('parent_id'));
$query->from($db->quoteName('#__categories'));
$query->where($db->quoteName('id') . ' = ' . $db->quote($catid));
$db->setQuery($query);
$parentid = $db->loadResult();
	?>
	<!-- end of John's script for body tags -->
  
  {t4:system_advancedCodeBeforeHead}
</head>
<!--
<body class="{t4post:bodyclass}">
-->
    

<body class="
{t4post:bodyclass}

site <?php echo 
// $option
//	($itemid ? ' itemid-' . $itemid : '')
	 ($id ? ' id-' . $id : '')
	. ($catid ? ' catid-' . $catid : '')
	. ($parentid ? ' parentid-' . $parentid : '');
//	. ($pageclass ? ' ' . $pageclass : '')
//	. $hasClass
//	. ($this->direction == 'rtl' ? ' rtl' : '');
?>">
    
  {t4:offcanvas}
  <div class="t4-wrapper">
    <div class="t4-content">
      <div class="t4-content-inner">
        {t4:system_advancedCodeAfterBody}
        {t4:body}
        {t4:system_advancedCodeBeforeBody}
      </div>
    </div>
  </div>
</body>
</html>

saguaros

john47 If there is no override for index.php file of T4 plugin in template on your site. You can copy the based file:

/plugins/system/t4/themes/base/html/layouts/t4/index.php

to the 'local' folder and customize as you wish.