• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: add submission into other database

add submission into other database 9 years 9 months ago #32382

  • info382
  • info382's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 10
I was reading www.rsjoomla.com/support/documentation/r...-external-table.html for adding the submissions into another database.
But it's not working.

Below you'll find my form and script. How can i fix it?

<form method="post"  id="userForm" action="http://www.kshipbroker.com/"><div id="rsform_error_4" style="display: none;"><p class="formRed">Please complete all required fields!</p></div>
<!-- Do not remove this ID, it is used to identify the page so that the pagination script can work correctly -->
<table class="formTableLayout" border="0" id="rsform_4_page_0">
	<tr>
		<td class="formTableLeft" valign="top">
			<table class="formTableLayout" border="0">
				<tr class="rsform-block rsform-block-name">
					<td>Uw naam (*)</td>
					<td><input type="text" value="" size="20"  name="form[Name]" id="Name"  class="rsform-input-box"/><br/>
					<span id="component31" class="formNoError">Vul uw naam in</span></td>
					<td></td>
				</tr>
				<tr class="rsform-block rsform-block-email">
					<td>Uw Emailadres (*)</td>
					<td><input type="text" value="" size="20"  name="form[Email]" id="Email"  class="rsform-input-box"/><br/>
					<span id="component32" class="formNoError">Vul een (geldig) emailadres in</span></td>
					<td></td>
				</tr>
				<tr class="rsform-block rsform-block-send">
					<td></td>
					<td><input type="submit" value="Aanmelden" name="form[Send]" id="Send"  class="rsform-submit-button" /><br/>
					</td>
					<td></td>
				</tr>
			</table>
 
		</td>
		<td class="formTableRight" valign="top">
			<table class="formTableLayout" border="0">
				<tr class="rsform-block rsform-block-achternaam">
					<td>Uw achternaam (*)</td>
					<td><input type="text" value="" size="20"  name="form[achternaam]" id="achternaam"  class="rsform-input-box"/><br/>
					<span id="component33" class="formNoError">Vul uw achternaam in</span></td>
					<td></td>
				</tr>
				<tr class="rsform-block rsform-block-tel">
					<td>Uw telefoonnummer</td>
					<td><input type="text" value="" size="20"  name="form[tel]" id="tel"  class="rsform-input-box"/><br/>
					<span id="component36" class="formNoError">Ongeldige invoer</span></td>
					<td></td>
				</tr>
			</table>
 
		</td>
	</tr>
</table>

and here my script:
if(isset($_POST['form']['Email'])) 
		{
$date = date( "Y-m-d" );
			$database2 = $database;
			$database2 = new database( 'localhost', 'dbname', 'password', 'dbuser');
			$database2->setQuery("INSERT INTO `crm` (`firstname`,`lastname`,`email`,`home`,`laatste_boeking`) VALUES ('{$processform['Name']}', '$processform['achternaam']', '$processform['Email']', '$processform['tel']', '$date')");
			$database2->query();
 
			} 
}
The administrator has disabled public write access.

add submission into other database 9 years 9 months ago #32387

  • alexp
  • alexp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 2253
  • Thank you received: 180
....so you were reading an RSForm! script topic and trying to apply it to RSForm!Pro? Given that these are two totally different extensions, scripts are not compatible.

You can easily do this in RSForm!Pro Mapping feature.
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.

add submission into other database 9 years 9 months ago #32388

  • info382
  • info382's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 10
Ok, i'm using RSForm!Pro. I'll look at the mapping feature!
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!