Forums

hi,

I am using chrono forms for user registration which takes user information required in joomla registration as well as much extra info. For that, i have created tables, written my php script for insertion in those tables and the data is going into tables too...😈 Now comes the problem, i have activated joomla registration plugin and provided id's of the corresponding fields into the plugin field. Problem is that data is not going into the joomla_users table as it was supposed to and the redirection page is also not coming after form submission, email is not send to user as well as admins. i don't know what the problem is... I am using my own written script insertion_main.php into the action of the form and after submitting the data, it is going to my personally created tables and a blank page is shown. But the data is not going into the joomla table.😶 Pleaseeeee Help me.

Thanks

Gaurav

Hi Gaurav,

changing the action url of the form means you lost all these features, change this and try to put the code in this file in the onsubmit code box!

Chronoforms can save data to any table in the same joomla database too without any code!

Regards
Max

Thanks!! I hope you are referring to the following

form code >> on submit code(after 0r before sending email)

which one to choose (before sending email or after sending the email??) because i tried this option before too but i got an error saying invalid argument supplied to eval() blah blah blah

One more question (probably dumb one), do i need to open the database connection in this code because i am already opening it in my FORM HTML code.

Please help. Thanks

Gaurav

i have tried what you told by putting the code in onsubmit(before sending email) and got the following error:

Warning: implode() [function.implode]: Invalid arguments passed in /xxx/libraries/joomla/database/database/mysql.php on line 538

What does that mean??

Gaurav

Hi Guarev,

The message probably means that you are trying to save an empty object into the database.

It is impossible to diagnose this without knowing what your code is doing. It sounds as though your script "insertion_main.php" is taking over execution from ChronoForms or interfering with it and creating these errors.

As Max said, you should not need a database connection in either your Form HTML or the OnSubmit code. Even if your custom code needs to make a connection you should do so through the Joomla database object - not through a bare MySQL connection.

Bob

Thanks for your so quick reply but as i am a newbie can you tell how to create database connection using joomla object

Gaurav

Hi Guarav,

Please take a look at the Joomla documentation wiki at http://docs.joomla.org/

Bob

searching the forums iwll show you too many examples too, btw, don't use a regular mysql connection code!

Regards
Max

i converted my code into joomla form as below but i am getting an error "Restricted access" when i run the following code onsubmit(before sending the email), mambots not enabled,sending email is enabled.

<?php

defined('JEXEC') or die('Restricted access');

$db =& JFactory::getDBO();
//Grab and format all the variable entries from the form.

$uname = "'" . $db->getEscaped(JRequest::getVar('uname')) . "'";
$pass  = "'" . $db->getEscaped(JRequest::getVar('pass'))  . "'";
$email = "'" . $db->getEscaped(JRequest::getVar('email')) . "'";
$name  = "'" . $db->getEscaped(JRequest::getVar('name'))  . "'";
$fname = "'" . $db->getEscaped(JRequest::getVar('fname')) . "'";
$dob_d = "'" . $db->getEscaped(JRequest::getVar('dob'))   . "'";
$dob_m = "'" . $db->getEscaped(JRequest::getVar('dob-m')) . "'";
$dob_y = "'" . $db->getEscaped(JRequest::getVar('dob-y')) . "'";
$sex   = "'" . $db->getEscaped(JRequest::getVar('sex'))   . "'";
$cadd  = "'" . $db->getEscaped(JRequest::getVar('caddress'))  . "'";
$ccity  = "'" . $db->getEscaped(JRequest::getVar('ccity'))  . "'";
$cstate  = "'" . $db->getEscaped(JRequest::getVar('cstate'))  . "'";
$czip  = $db->getEscaped(JRequest::getVar('czip'));
$cph   = "'" . $db->getEscaped(JRequest::getVar('cph'))   . "'";
$padd  = "'" . $db->getEscaped(JRequest::getVar('paddress'))  . "'";
$pcity  = "'" . $db->getEscaped(JRequest::getVar('pcity'))  . "'";
$pstate  = "'" . $db->getEscaped(JRequest::getVar('pstate'))  . "'";
$pzip  = "'" . $db->getEscaped(JRequest::getVar('pzip'))  . "'";
$pph   = $db->getEscaped(JRequest::getVar('pph'));
$mob   = "'" . $db->getEscaped(JRequest::getVar('mob'))   . "'";
$image = "'" . $db->getEscaped(JRequest::getVar('abc'))   . "'";
$degree = "'" . $db->getEscaped(JRequest::getVar('degree')) . "'";
$course = "'" . $db->getEscaped(JRequest::getVar('course')) . "'";

$dob = "'" . 'dob_y' . 'dob_m'. 'dob_d' . "'";

//Insert values into zip

$sql_czip = "INSERT INTO zip ".
                "(zip_id,city,state)".
                "VALUES (" .$czip. "," .$ccity. "," .$cstate. ");";
$db->setQuery(sql_czip);
$db->query();

?>

Please guide me what's the problem.

Thanks

Gaurav

Hi, try to remove:

defined('JEXEC') or die('Restricted access');

Regards
Max

Thanks for reply but i am getting following error

Warning: implode() [function.implode]: Invalid arguments passed in /libraries/joomla/database/database/mysql.php on line 538

I am afraid i am not passing an empty object??

Please help...

Gaurav

Hi, ok, cut your code into pieces and test it one by one to see where the problem is!

Regards
Max