Peruttu

MySQL update trigger for jos_rsform_submission_values table

Tables:

a) jos_rsform_submission_values (this is RS Form Pro 1.4 table)

b) cm_rsform_article_update (columns: id, form_id, submission_id, article_text, article_id)

In the cm_rsform_article_update table:

id: auto_increment column

form_id: refers to FormId column in jos_rsform_submission_values

submission_id: refers to SubmissionId column in jos_rsform_submission_values

article_id: refers to id column in jos_content

article_text: see sample value for this column below:

Affiliations

{affiliations:value}

Achievements

{achievements:value}

On after UPDATE trigger on 'jos_rsform_submission_values' table:

1) replace values in {} brackets with relevant values in jos_rsform_submission_values

2) Update intro_text column in jos_content table for corresponding article_id's in cm_rsform_article_update table with value obtained in step 1

3) Repeat steps 1 and 2 for all rows in cm_rsform_article_update table

The code should work for:

1. Joomla 1.5

2. MySQL 5.1

3. RS Form Pro 1.4

Taidot: Joomla, MySQL, PHP

Näytä lisää: php brackets, mysql update values, update values mysql, update php joomla, mysql tables rows, joomla table mysql, brackets php, mysql update table, joomla php update table, joomla trigger, php mysql trigger, mysql replace values, value table, replace values mysql, joomla step form, mysql replace, brackets joomla, joomla mysql php, joomla mysql trigger, php form mysql update, php sample code table, joomla brackets, mysql update column, columns replace value, update table mysql joomla

About the Employer:
( 160 reviews ) Cairo, Egypt

Projektin tunnus: #4264656

5 freelanceria on tarjonnut keskimäärin 90 $ tähän työhön

gopalvora

ready to start Thanks

70 $ USD 4 päivässä
(149 arvostelua)
6.7
hunterboss

Dear friend Please check your PMB to see more detail. Thank you

100 $ USD 5 päivässä
(92 arvostelua)
6.5
sunilexpert

I am an expert web developer with 8+ years of developing dynamic web applications and websites. I have understood and able to visualize what you are looking for, I can do this job quickly with quality.

100 $ USD 2 päivässä
(38 arvostelua)
5.5
truongngocthanh

Hello, I can do it quickly for you. Please check your private message for more detail. Thank you

80 $ USD 1 päivässä
(6 arvostelua)
3.8
joomlavenus

Hi D&D, I can do it, and ready to start.

100 $ USD 2 päivässä
(2 arvostelua)
2.0