Forums

Will not post to DB

offstage 03 Jul, 2009
I would like to say up front that I am very excited about this application...I can see how this will come in very handy and will encourage me to learn more and expand my coding abilities. Thanks for putting this out her for us.

next is the question, I've tried to follow the step completely, but for some reason, no matter what I do, I can not get my form to post to my DB, or pass the info on to my Acajoom Mailing list application.

Below is the debug:
1. Form passed first SPAM check OK
2. Form passed the submissions limit (if enabled) OK
3. Form passed the Image verification (if enabled) OK
4. Form passed the server side validation (if enabled) OK
5. $_POST Array: Array ( [email] => [email]offstage@offstagetheatre.com[/email] [name] => Doug [lastname] => Shell [address1] => 1 test [address2] => [city] => [state] => [zip] => 45891 [homephone] => [cellphone] => 111-111-111 [check0] => Array ( [0] => Costume Design [1] => Set Construction ) [chrono_verification] => AUq8h [hidden_16] => value= [button_17] => Submit [bfa510b936bd2cb51527c554228a9063] => 1 [1cf1] => a916327e3970d6af57d01f95d5860170 [chronoformname] => OSPMailing )
6. $_FILES Array: Array ( )
7. Form passed the plugins step (if enabled) OK
8. Debug End

Now,I'll just get this out of the way now...I don't know a stick of PHP, but I have tried to follow the instructions both on this forum and on the Acajoom website on how to make my form save to the DB and then subscribe the user to the newsletter if an email and name are present. but in doing so i might have totally missed the boat...so ANY help would be greatly appreciated.

Thanks in advance for the assistance.
Doug
Max_admin 03 Jul, 2009
Hi Doug,

show me the onSubmit code you have got from the forums or the Acajoom site please, or the forum posts you found here!

Regards
Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
offstage 04 Jul, 2009
I believe this is what you were asking about.

<p>formrow->redirecturl = JURI::base()."index.php?option=com_acajoom&act=subscribe&listid=5&receive_html=1&email=$email&name=$name"; ?></p>
offstage 04 Jul, 2009
Just to make sure we understand...I am wanting to get this to work for my acajoom newsletter app, but even if I removed that code from the onsubmit box...records will still not save to my database which still doesn't make sense to me. Hope this helps.
offstage 06 Jul, 2009
Just checking on this...is there any help that anyone can give...I'm really wanting to get this form working for our upcoming marketing push. appreciate any suggestions at all!!
Max_admin 06 Jul, 2009
Hi offstage,

I see, your code got messed up when you visited the wizard, please get the latest release so this doesn't happen again and make your code like this:


<?php
$name = JRequest::getVar('name');
$email = JRequest::getVar('email');
$listid = JRequest::getVar('listid');
$MyForm->formrow->redirecturl = JURI::base()."index.php?option=com_acajoom&act=subscribe&listid=$listid&receive_html=1&email=$email&name=$name"; 
?>


your form should have a field called name will hold the user name and another field called "email" will hold the email address to be subscribed! the field listid should have a valid listid number!

Regards
Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
offstage 07 Jul, 2009
I appreciate the help...unfortunately it's not helping at this point.

I even rebuilt a whole new form and a new db table and put in the new code you gave me...but it still will not save to the DB. I don't even have any idea what to do now.

Any other ideas?
GreyHead 07 Jul, 2009
Hi offstage,

If the site is on-line and it's OK with you, please email or PM me a SuperAdmin login and I'll take a look. You really shouldn't be having problems saving a simple form to the database so something is amiss, perhaps a fresh pair of eyes can see it.

Bob
This topic is locked and no more replies can be posted.