HEADER

I made a form earlier that was storing everything in the Show Data field. Recently I revised my form and made a new one from scratch. Now I've noticed that it is not posting this to the Show Data section. I have it set to email the results so it's not a big loss, just something I would like to see. Is there a setting that maybe I turned off? Or something I didn't set up?

You are right... Something must be wrong with the form. I clicked on Create Table up at the top, and it said that a table was already created for this form. When I click on Show Data I get nothing. Is there maybe a problem with MySQL or is there something I can edit? It seems as if this may be a database problem, although I'm not quite sure.

Nothing... Might this be the problem?

OK... I backed up the form, deleted it, and then restored. When I restored the form I had an option to create the table. I selected it and confirmed my fields. Now I have some code in the auto generated tab. However I'm still not showing anything in the show data field. Here is the auto generated code. Hopefully we can figure this out. Thanks for your help.

Code: Select all

<?php
   $database =& JFactory::getDBO();
   srand((double)microtime()*10000);
   $inum   =   "I" . substr(base64_encode(md5(rand())), 0, 16);
   
$database->setQuery( "INSERT INTO #__chronoforms_2
VALUES  (
'' ,
'".$inum."',
'". date('Y-m-d')." - ".date("H:i:s")."',
'".$_SERVER['REMOTE_ADDR']."' ,
'".JRequest::getVar('name','', 'post', 'string', '' )."'
, '".JRequest::getVar('company','', 'post', 'string', '' )."' ,
'".JRequest::getVar('email','', 'post', 'string', '' )."' ,
'".JRequest::getVar('phone','', 'post', 'string', '' )."' ,
'".JRequest::getVar('website','', 'post', 'string', '' )."' ,
'".JRequest::getVar('url','', 'post', 'string', '' )."' ,
'".JRequest::getVar('complete','', 'post', 'string', '' )."' ,
'".JRequest::getVar('em_svc','', 'post', 'string', '' )."' ,
'".JRequest::getVar('hosting','', 'post', 'string', '' )."' ,
'".JRequest::getVar('other','', 'post', 'string', '' )."' ,
'".JRequest::getVar('redesign','', 'post', 'string', '' )."' ,
'".JRequest::getVar('maintenance','', 'post', 'string', '' )."' ,
'".JRequest::getVar('ecommerce','', 'post', 'string', '' )."' ,
'".JRequest::getVar('time','', 'post', 'string', '' )."' ,
'".JRequest::getVar('method','', 'post', 'string', '' )."' ,
'".JRequest::getVar('description','', 'post', 'string', '' )."' ,
'".JRequest::getVar('reset','', 'post', 'string', '' )."' ,
'".JRequest::getVar('submit','', 'post', 'string', '' )."');"
);
if (!$database->query()) {
echo "<script> alert('".$database->getErrorMsg()."');
window.history.go(-1); </script>
";
}
?>

Ok... I went back and checked the database and removed the table and went back to chronoforms and then created the table and I'm still not receiving anything in the show data...

Ok here is the new code... My database now has a table labled jos_chronoforms_1. I'm still not getting anything to show up in the show data field...

Code: Select all

<?php
   $database =& JFactory::getDBO();
   srand((double)microtime()*10000);
   $inum   =   "I" . substr(base64_encode(md5(rand())), 0, 16);
   
$database->setQuery( "INSERT INTO #__chronoforms_1
VALUES  (
'' ,
'".$inum."',
'". date('Y-m-d')." - ".date("H:i:s")."',
'".$_SERVER['REMOTE_ADDR']."' ,
'".JRequest::getVar('name','', 'post', 'string', '' )."' ,
'".JRequest::getVar('company','', 'post', 'string', '' )."' ,
'".JRequest::getVar('email','', 'post', 'string', '' )."' ,
'".JRequest::getVar('phone','', 'post', 'string', '' )."' ,
'".JRequest::getVar('website','', 'post', 'string', '' )."' ,
'".JRequest::getVar('url','', 'post', 'string', '' )."' ,
'".JRequest::getVar('complete','', 'post', 'string', '' )."' ,
'".JRequest::getVar('em_svc','', 'post', 'string', '' )."' ,
'".JRequest::getVar('hosting','', 'post', 'string', '' )."' ,
'".JRequest::getVar('other','', 'post', 'string', '' )."' ,
'".JRequest::getVar('redesign','', 'post', 'string', '' )."' ,
'".JRequest::getVar('maintenance','', 'post', 'string', '' )."' ,
'".JRequest::getVar('ecommerce','', 'post', 'string', '' )."' ,
'".JRequest::getVar('time','', 'post', 'string', '' )."' ,
'".JRequest::getVar('method','', 'post', 'string', '' )."' ,
'".JRequest::getVar('description','', 'post', 'string', '' )."' ,
'".JRequest::getVarif (!$database->query()) {
echo "<script> alert('".$database->getErrorMsg()."');
window.history.go(-1); </script>
";
}
?>

No that wasn't a slip... That code isn't there. Here is the backup. [file name=Quote.cfbak size=10558]http://www.chronoengine.com/images/fbfiles/files/Quote.cfbak[/file]

GreyHead wrote:Hi jpc0480,

Your form appears to work OK for me. I did have to add 'addslashes' to the textarea input, mainly because I typed some junk in there. Here's the Autogenerated code I ended up with - including some debug code.

Code: Select all

<?php
$database =& JFactory::getDBO();
srand((double)microtime()*10000);
$inum = "I" . substr(base64_encode(md5(rand())), 0, 16);
$sql = "INSERT INTO #__chronoforms_67
VALUES  (
'' ,
  '".$inum."',
'". date('Y-m-d')." - ".date("H:i:s")."', '".$_SERVER['REMOTE_ADDR']."' ,
'".JRequest::getVar('name','', 'post', 'string', '' )."' ,
'".JRequest::getVar('company','', 'post', 'string', '' )."' ,
'".JRequest::getVar('email','', 'post', 'string', '' )."' ,
'".JRequest::getVar('phone','', 'post', 'string', '' )."' ,
'".JRequest::getVar('website','', 'post', 'string', '' )."' ,
'".JRequest::getVar('url','', 'post', 'string', '' )."' ,
'".JRequest::getVar('complete','', 'post', 'string', '' )."' ,
'".JRequest::getVar('em_svc','', 'post', 'string', '' )."' ,
'".JRequest::getVar('hosting','', 'post', 'string', '' )."' ,
'".JRequest::getVar('other','', 'post', 'string', '' )."' ,
'".JRequest::getVar('redesign','', 'post', 'string', '' )."' ,
'".JRequest::getVar('maintenance','', 'post', 'string', '' )."' ,
'".JRequest::getVar('ecommerce','', 'post', 'string', '' )."' ,
'".JRequest::getVar('time','', 'post', 'string', '' )."' ,
'".JRequest::getVar('method','', 'post', 'string', '' )."' ,
'".addslashes(JRequest::getVar('description','', 'post', 'string', '' ))."');";
if ( $debug ) {
  echo "sql: ";print_r($sql); echo"<br />";
}
$database->setQuery( $sql );
if (!$database->query()) {
echo "<script> alert('".$database->getErrorMsg()."'); window.history.go(-1); </script>
";
}
?>

Bob

Thank you! At first it didn't work and I checked the code and had to change the table it was posting to. Once I did that, everything worked fine. Thanks again!

No problems. It was an easy fix.