I've purchased both Chrono Forms and Connectivity. I had my quote request form up and running in 30 minutes! Very good plug-in.
My problem is the following. I created a second form for approved users to upload a small text file and I wrote php to parse the data and to get the additional information and geocode the addresses. That was working just fine. I had a problem getting the map to display so I created a different page for debugging purposes to see if the problem was happening inside the article content or if there was an error in my logic. After I did that, the input form no longer writes the data to the table.
This has been an arduous process since I'm no expert in php and there are only bits of information in these posts. I've been doing LOTS of reading on these forums and trying to figure out where each bit goes has been an issue. I don't know where to go from here.
This is the code that the index.html page calls outside of joomla http://www.sheboyganhomeinspector.com/radon
I first tried placing the index code in an article. The map would show up but the overlay marker data would not appear. I unpublished that article and put the files in an alternate directory outside of joomla and it works fine there. But as I mentioned, the update form will not write additional data to the radon_tests table. I can use the form, enter data submit the data. The file uploads, DEBUG ON reports everything is OK. The variables are correct. I don't know where to go from here.
Any suggestions?
Thank you
My problem is the following. I created a second form for approved users to upload a small text file and I wrote php to parse the data and to get the additional information and geocode the addresses. That was working just fine. I had a problem getting the map to display so I created a different page for debugging purposes to see if the problem was happening inside the article content or if there was an error in my logic. After I did that, the input form no longer writes the data to the table.
This has been an arduous process since I'm no expert in php and there are only bits of information in these posts. I've been doing LOTS of reading on these forums and trying to figure out where each bit goes has been an issue. I don't know where to go from here.
This is the code that the index.html page calls outside of joomla http://www.sheboyganhomeinspector.com/radon
<?php
//createmarkers.php
//use this file to create an xml file from table radon_tests to map
require("dbinfoj.php");
function parseToXML($htmlStr)
{
$xmlStr=str_replace('<','<',$htmlStr);
$xmlStr=str_replace('>','>',$xmlStr);
$xmlStr=str_replace('"','"',$xmlStr);
$xmlStr=str_replace("'",''',$xmlStr);
$xmlStr=str_replace("&",'&',$xmlStr);
return $xmlStr;
}
// Opens a connection to a MySQL server
$connection=mysql_connect ($hostname, $username, $password);
if (!$connection) {
die('Not connected : ' . mysql_error());
}
// Set the active MySQL database
$db_selected = mysql_select_db($database, $connection);
if (!$db_selected) {
die ('Can\'t use db : ' . mysql_error());
}
// Select all the rows in the markers table
$query = "SELECT * FROM $table WHERE lat>0";
$result = mysql_query($query);
if (!$result) {
die('Invalid query: ' . mysql_error());
}
header("Content-type: text/xml");
// Start XML file, echo parent node
echo '<markers>';
// Iterate through the rows, printing XML nodes for each
while ($row = @mysql_fetch_assoc($result)){
// ADD TO XML DOCUMENT NODE
echo '<marker ';
echo 'name="' . parseToXML($row['inspector']) . '" ';
echo 'lat="' . $row['lat'] . '" ';
echo 'lng="' . $row['lng'] . '" ';
echo 'epa_avg="' . $row['epa_avg'] . '" ';
echo 'type="' . $row['m_type'] . '" ';
echo '/>';
}
// End XML file
echo '</markers>';
mysql_close($connection);
?>
I first tried placing the index code in an article. The map would show up but the overlay marker data would not appear. I unpublished that article and put the files in an alternate directory outside of joomla and it works fine there. But as I mentioned, the update form will not write additional data to the radon_tests table. I can use the form, enter data submit the data. The file uploads, DEBUG ON reports everything is OK. The variables are correct. I don't know where to go from here.
Any suggestions?
Thank you