Forums

Hi All

I have been asked to create a Volunteer Opportunity board for my local church.

I have been searching around and found that ChronoForms will be the best option for this.

I have created the form:

http://widowmaker.is-a-geek.com/joomla/index.php?option=com_chronoforms&chronoform=VolunteerOpportunity

On clicking submit the form then creates the database entries for this information in my MYSQL database and emails the information to the contact person in the email to confirm that the opportunity is created.

I have then created a php script to extract the data from the database into a table (crudely):

http://widowmaker.is-a-geek.com/joomla/testing.php

<?php
$con=mysqli_connect("localhost","root","PASSWORD","joomla");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$result = mysqli_query($con,"SELECT Opp_Name,Op_Campus,OP_Area,OP_DateNeeded,OP_ContactName,OP_ContactEmail,OP_ContactTelephone,Op_EndDate FROM zag59_chronoforms_data_volunteeropportunity where Op_EndDate >= CURDATE()");

echo "<table border='1'>
<tr>
<th>Opportunity Name</th>
<th>Campus</th>
<th>Area</th>
<th>Date Needed</th>
<th>Contact Name</th>
<th>Contact Email</th>
<th>Contact Telephone</th>
<th>End Date</th>
</tr>";

while($row = mysqli_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['Opp_Name'] . "</td>";
  echo "<td>" . $row['Op_Campus'] . "</td>";
  echo "<td>" . $row['OP_Area'] . "</td>";
  echo "<td>" . $row['OP_DateNeeded'] . "</td>";
  echo "<td>" . $row['OP_ContactName'] . "</td>";
  echo "<td>" . $row['OP_ContactEmail'] . "</td>";
  echo "<td>" . $row['OP_ContactTelephone'] . "</td>";
  echo "<td>" . $row['Op_EndDate'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysqli_close($con);
?>

However I understand that Chronoforms can retrieve the information as well.

I have tried to follow the Tutorial in the tutorials section however I cannot get this to work correctly.

Here is the current Volunteer opportunities they use

http://www.adventsuntree.com/index.php?option=com_content&view=article&id=110&Itemid=47

This is a docx which is published to a google drive and embedded in the website to apply the person clicks on the persons name and an email is opened up for them to enter, im thinking we can go further with creating a form which will email the person responsible with the applicants details.

I hope you can help me with this🙂

Thanks

Martin

Hi UK_Tomcat_Fan,

You can create a simple listing with the ChronoForms DB Multi-Record Loader action. If you set the Date Displayer option to Yes it will create a simple listing.

Or you can create much more complex listings with the ChronoConnectivity app if you need a lot of customisation.

Bob