Database Report

I sent a note via the contact form, but thought I would try this as well. I have a Chronoforms V3 database report working well on a site that I am moving to Joomla 2.5. You can see a sample of the report here...

http://www.indianasoybean.com/index.php?option=com_chronocontact&chronoformname=CountyBridgeQuery&CountyID=Wayne

But, I can't figure out how to make the same thing happen with Chronofroms V4. I will gladly pay you to help me. Thanks.

Hi rstevens,

I saw a CC of your Contact Us email (made my eyes cross though). If you don't hear from Max by tomorrow email or PM me and we'll sort something out.

Bob

OK. Thanks.

Yes, I know there are several queries in the code and lots of fields. I am sure the code could be more elegant.

Once I learn how to migrate this over to V4, I will be able to make other reports.

Do you need access to my website to figure this out?

I sent you a reply by email with screen shots, but thought I would use the forum as well.

Thanks for your reply. Please keep track of your time, so I can pay you.

Taking your suggestion, I wrote a query to see if I could get a result from another chronoforms table that I created using the wizard. I know I have one record in the table because I can see the data using chronoforms…

<?php 

$db = JFactory::getDBO();

$query = "SELECT * from chronoforms_data_StFairVolunteer"; 
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$num_results = mysql_num_rows($result);
echo "Results: ";
print_r2($num_results);
?>

But, I get nothing more than Results: on the page when I look at the frontend view.

This is mysterious to me. Any suggestions?

Here are the results of adding the DB Multi Recorder Loader and debugger...

Data Array: 
Array
(
    [option] => com_chronoforms
    [tmpl] => component
    [chronoform] => BridgeDebug
    [Itemid] => 
    [ChronoformsDataStFairVolunteer] => Array
        (
            [0] => Array
                (
                    [cf_id] => 1
                    [cf_uid] => a55d169882c55c7668574f79522bbda6
                    [cf_created] => 2013-02-22 10:30:17
                    [cf_modified] => 0000-00-00 00:00:00
                    [cf_created_by] => 0
                    [cf_modified_by] => 0
                    [cf_ipaddress] => 24.123.21.131
                    [cf_user_id] => 0
                    [FName] => Roger
                    [LName] => Stevens
                    [Company] => Stevens & Associates, Inc.
                    [Email] => rstevens@saiindy.com
                    [Phone] => 3174418823
                    [Days] => 
                    [Morning] => 
                    [Afternoon] => 
                    [Evening] => 
                    [Weekday] => 
                    [Weekend] => 
                    [Size] => S
                    [Submit] => Submit
                )

        )

)

Validation Errors: 
Array
(
)

Results:

Hi rstevens,

The code in your last but one post is probably missing a #__ from the table name: Here's how I'd rewrite that:

<?php
$db = JFactory::getDBO();
$query = "
  SELECT * 
    FROM `#__chronoforms_data_StFairVolunteer` ;
";
$db->setQuery($query);
$data = $db->loadAssocList();
echo'<div>Results: '.print_r($data, true).'</div>';
?>

Bob

Hi rstevens,

Looking at your original email and the old page I think you can probably set this up in ChronoForms v4 using a series of DB Multi-Record loader actions with the Data Displayer turned on to create the tables.

By all means email or PM me the site URL and a SuperAdmin login and I'll take a quick look.

Bob

Did you get my PM?

Hi rstevens,

Yes I got it, will take a look shortly.

Bob