Creating a contact form that writes to the database and sends email

frickinmuck · 2011-07-18 17:53:12

I’m using zem_contact_reborn for a feedback form on a site, and what I’d like to do is, in addition to having the user input emailed to whoever is listed on the form, I’d like to have the user input written to the database so that it can be pulled, sorted, etc. to my heart’s content.

Has this been done before? Could anyone point me to a post or a plugin or something that might get me headed in the right direction? If not, any ideas on what’s the best way to go about it? I like the security and spam-freeness of zem_contact, but I’m open to using a different approach, as long as I don’t end up with a database/inbox full of garbage.

Last edited by frickinmuck (2011-07-18 17:53:45)

Dimitri · 2011-07-18 18:50:49

You could have a look here

I am not sure which one, you can use this link as a reference so you can search here on the forum.

Good luck with the minor documentation :P

Dimitri · 2011-07-18 18:53:45

One time I gave up setting up attachment with the contact form… I stumbled this

Link

I use this alongside with textpattern with extra database. This may help you if you cant find any solution

frickinmuck · 2011-07-18 18:53:47

Thanks! I actually stumbled across this, which is looking promising. I’ll let you know how it works out.

Dimitri · 2011-07-18 18:56:28

The link you send me is interesting, but have a look at the first comment. its all in the first link I sent you

lithium002 · 2011-07-18 20:15:52

Hey,

I’m having a little trouble with the radio buttons. Basically, when you output a radio button with zem_contact, it comes with its own “value” field. How can I change this value field to what I want?

Dimitri · 2011-07-18 20:54:51

Link

Group and label parameters are required

<txp:zem_contact_radio label="something" group="Something group" />
<txp:zem_contact_radio label="something" />
<txp:zem_contact_radio label="something" />


<txp:zem_contact_radio label="Medium" group="I like my steak" />
<txp:zem_contact_radio label="Rare" />
<txp:zem_contact_radio label="Well done" />

lithium002 · 2011-07-18 21:23:40

Hey Dimitri,

Thanks for that info, however, the problem is the field ‘value’ associated with each radio button that is generated automatically by the plugin.

I’m trying to get the value associated with a radio button, which would either be a 0 or a 1, and use those values to perform different functions, however, there seems to be no field ‘value’ assigned to a radio button and the one generated by the form is a big string of random characters that changes each time.

Any way to work around this problem?

Dimitri · 2011-07-18 21:52:01

Not sure what you trying to say. Could you show me your code and the source code.

lithium002 · 2011-07-18 21:58:13

Are you checked?? <txp:zem_contact_radio group="Check" label="Yes" checked="1" /> <txp:zem_contact_radio group="Check" label="No" />

brings up :

Are you checked? <input value="q7b7508b0cf15ec0b96a56426f4ec8296" type="radio" id="q7b7508b0cf15ec0b96a56426f4ec8296" class="zemRadio" checked="checked" /> <label for="q7b7508b0cf15ec0b96a56426f4ec8296" class="zemRadio">Yes</label> <input value="q685c620ff5e57ec429ad8ccfbd447b7a" type="radio" id="q685c620ff5e57ec429ad8ccfbd447b7a" class="zemRadio" /> <label for="q685c620ff5e57ec429ad8ccfbd447b7a" class="zemRadio">No</label>

The value changes randomly. Is there anyway to assign a custom value to radio buttons?

Dimitri · 2011-07-18 22:11:48

I just remembered, zem does add random values. I dont think you need to worry about it, the plugin will automatically pick up the selected radio and will send the label value through the email.

I saw a small error in your tag, you added two groups… but it wont make a different

<p>Are you checked??</p> 
<p>
	<txp:zem_contact_radio group="Check" label="Yes" checked="1" />
	<txp:zem_contact_radio label="No" />
</p>

Last edited by Dimitri (2011-07-18 22:12:57)

lithium002 · 2011-07-19 14:42:38

Hey Dimitri,

I know it sends out the actual value in the email, however, I need the value before it is sent out for other purposes. :(

Dimitri · 2011-07-19 14:44:44

Ah k
Good luck, I advice you to post this thread to the plugin support

Gocom · 2011-07-19 19:29:11

Please read this thread before implementing Kevin’s (graphicPUSH) code. I myself and Ruud give some security related advices there which you should take into consideration.

For example do not trust and save the POST values blindly directly as Kevin advices. You do not want run into database filled with spam and other nasty stuff.

Instead it’s better to use zemcontact.submit callback and $zem_contact_values global array to handle the data, and use doSlash() to clean the values to avoid SQL injections. It’s also advisable to check posts status with get_zemcontact_evaluator() before saving anything to make sure the comment isn’t flagged as spam by an anti-spam plugin. Both anti-spam plugins and the saving function will be using the same callback after all.

As outlined in the forum thread I mentioned all you need to do to save comment data is something like this (untested, just an example, use with caution):

/**
	Registers the callback. xxx_my_saving_function() is
	now loaded on 'zemcontact.submit' event. You can find
	the callback spot from ZRC's source and what it can offer.
*/

register_callback('xxx_my_saving_function','zemcontact.submit');

/**
	The function that does the work on
	the submit event
*/

function xxx_my_saving_function() {
	/*
		get_zemcontact_evaluator() tells us if the comment is
		flagged as spam by an other plugin using the same callback.
		If spam, do not save the comment.

		PS. Remember to load the spam plugins
		before this plugin; set this plugin's load order to '6'
		and the anti-spam plugins '5'.

		We want to do the spam checks before this point.
	*/

	$evaluation =& get_zemcontact_evaluator();

	/*
		It's spam, end here
	*/

	if($evaluation->get_zemcontact_status() != 0)
		return;

	/*
		Saving the data goes here etc..
		$zem_contact_values global array holds
		all the form data.
	*/

	global $zem_contact_values;

	$set = 'timestamp=now()';

	foreach($zem_contact_values as $name => $val) {
		$set .= ', '. $name . "='" . doSlash($value) . "'";
	}

	/*
		Insert row to the database table
		named "xxx_enquiries_table".
	*/

	safe_insert(
		'xxx_enquiries_table',
		$set
	);
}

The code can be loaded as a plugin. Everything is prefixed to avoid conflicts with other core functions, plugins and tables.

Last edited by Gocom (2011-07-19 19:47:31)

Textpattern CMS

Textpattern CMS support forum

#1 2011-07-18 17:53:12

Creating a contact form that writes to the database and sends email

#2 2011-07-18 18:50:49

Re: Creating a contact form that writes to the database and sends email

#3 2011-07-18 18:53:45

Re: Creating a contact form that writes to the database and sends email

#4 2011-07-18 18:53:47

Re: Creating a contact form that writes to the database and sends email

#5 2011-07-18 18:56:28

Re: Creating a contact form that writes to the database and sends email

#6 2011-07-18 20:15:52

Re: Creating a contact form that writes to the database and sends email

#7 2011-07-18 20:54:51

Re: Creating a contact form that writes to the database and sends email

#8 2011-07-18 21:23:40

Re: Creating a contact form that writes to the database and sends email

#9 2011-07-18 21:52:01

Re: Creating a contact form that writes to the database and sends email

#10 2011-07-18 21:58:13

Re: Creating a contact form that writes to the database and sends email

#11 2011-07-18 22:11:48

Re: Creating a contact form that writes to the database and sends email

#12 2011-07-19 14:42:38

Re: Creating a contact form that writes to the database and sends email

#13 2011-07-19 14:44:44

Re: Creating a contact form that writes to the database and sends email

#14 2011-07-19 19:29:11

Re: Creating a contact form that writes to the database and sends email

Board footer