CiviCRM Community Forums (archive)

I'm trying to use the CiviCRM API to create some functionality for the front end of a Joomla based website

I'm using Jumi to insert the path to the php file

The PHP file in question is stored in "administrator\components\com_civicrm\civicrm" (at least for the time being - I'll want to move it out to a dedicated code library directory)

The PHP code is simple (at least at the moment)

print ("<h3>Leicester Business Club Members</h3><p>This page will - eventually - list all the members of the specified Business Club</p>");

require_once 'api/api.php';

$params = array(
  'version' => 3,
);

$result = civicrm_api( 'contact','get',$params );

However I'm getting the following error message from api.php

Warning: require_once(api/v3/utils.php) [function.require-once]: failed to open stream: No such file or directory in D:\websites\joomla\administrator\components\com_civicrm\civicrm\api\api.php on line 47

Fatal error: require_once() [function.require]: Failed opening required 'api/v3/utils.php' (include_path='.;c:\php\includes') in D:\websites\joomla\administrator\components\com_civicrm\civicrm\api\api.php on line 47

utils.php is in the api/v3 directory, so what am I doing wrong

Server is Windows XP running Apache. Jumla and CiviCRM are all up to date

As a follow on, what would I need to change to move the file to top a subdirectory (php-library) off the top level of the website - do I only need to change the path to the api.php?

Cheers

Thanks I'll try that. Where was that documented?

I've looked at the profile tools, but it seems as though they're only accessible when logged in to the back end of Joomla (although I'll be happy to be shown wrong) and I need to do this at the front end.

profiles can all be exposed through the front of the site -- in create/edit/view/search modes.
try creating a new joomla menu item for civicrm. you'll see the list of options available for frontend civi pages.

You can sometimes uses the profile as the basis, and then enhance it with the buildForm hook and postProcess hook, is that an option for you?

If you want to do it quick and dirty you can use CRM_Core_DAO::executeQuery( $yourQuery )

and obviously you will need to do something like this:
$qry = "SELECT * FROM civicrm_contact";
$daoContact = CRM_Core_DAO::executeQuery( $qry );
while ($daoContact->fetch()) {
<do your processing>
}



I am not sure I fully understand your question....your civicrm.setting.php should be in <yoursite>/sites/default