CiviCRM Community Forums (archive)

I would recommend reading this: http://book.civicrm.org/user/current/the-user-interface/profiles/

Kurund

I am new to civi also.
I could not find a form for users to add/update their own contact info in Wordpress, only Drupal and Joomla. So I wrote the following simple sign-up.

OBJECTIVE: generic signup form, accepts first name, last name, email, enters as a civi_contact with a default assigned group.

You need some logic, as you cannot insert to multiple tables with one SQL query.

Pseudo code: The logic works as follows
-- validate the names and email
-- insert to civicrm_contact, put the email temporarily into "nickname"
-- query civicrm_contact, discover your contact_id 
-- insert email to civicrm_email, then delete it from nickname
-- assign group by insert to civicrm_group_contact

The relevant SQL queries are as follows

insert contact
INSERT INTO civicrm_contact( contact_type, nick_name, first_name, middle_name, last_name, sort_name, display_name ) VALUES ( '$contact_type' , '$nick_name' , '$first_name' , '$middle_name' , '$last_name' , '$sort_name' , '$display_name' );

get contact id
SELECT id FROM civicrm_contact WHERE nick_name = '$email';

insert email
INSERT INTO civicrm_email (contact_id, location_type_id, email, is_primary) VALUES ($id, 3, '$email', 1);

nickname clear
UPDATE civicrm_contact SET nick_name = '' WHERE id = $id;

insert group (we assign group "2", you might need another group_id)
INSERT INTO civicrm_group_contact (group_id, contact_id, status) VALUES ($group_id, $id, '$status');

Attached, the basic logic
-- contact.php << a form to collect the first, last, email
-- contact-process.php << implementing the logic described above

Kurund--Thanks for the feedback on profiles, I modified my post.

Is there a procedure to enable a simple signup page in Wordpress? How about enabling contacts to manage their own profile details?

If so, I do not need the custom page I defined above!

Thanks in advance. - L