I have an issue with code field which does not allow the use of "use"
How could I call the DB from within CB ?
use Joomla\CMS\Factory;
$db = Factory::getDbo();
$query = "SELECT parent_id FROM #__affiliate_tracker_accounts where user_id='[user_id]' ";
$db->setQuery($query);
$comid= $db->loadResult();
$query = "SELECT a.firstname, a.lastname, a.user_id FROM #__comprofiler a inner join #__affiliate_tracker_accounts b on b.user_id=a.id where b.id='$comid' ";
$db->setQuery($query);
$comProfiler_user= $db->loadObject();
That's not caused by CB Code Field. That's just how PHP works. use statements MUST be at the top of the PHP file being executed. You can't put them inline wherever you like. So your options are to include a PHP file and run your code from there or to supply the full path. Example as follows.
FROM: Factory::getDbo();
TO: \Joomla\CMS\Factory::getDbo();
You shouldn't be nor need to call Joomla API directly. The benefit of CB is it's very platform agnostic. Meaning if you use our API as much as possible you don't really have to worry about what version of Joomla you're using. You can access CBs global database object with the following.
Note I've modified your query to be safely escaped. Please be careful directly accessing the database if you do not know how to safely escape as you risk creating a vulnerability.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
krileon
