My company wants to develop and internal application for our content writers for inputting copy for our newsletters.
The newsletter is pretty dynamic and is build up of various blocks/modules. We typically want to have a list of these blocks (block: html tables with variable to pulll into Newsletter) these blocks of hml are each very different and have predefine fields.
As the copywriter select the block(s) and to mockup look of the template. So if you looked at the page on the left you would have the form fields for the selected block and on the right what that block of html looks like. And as you complete the form it fills in the preview on the right. The blocks need to be used as forms to imput data.
So and example would be block 1 wiil have
- Title
- Description
- Image
- Call to action ... you get the idea.
<table>
<tr>
<td>{Title }</td>
</tr>
<tr>
<td>{Description}</td>
</tr>
<tr>
<td>{Image}</td>
</tr>
<tr>
<td><button name="{CTA}"</td>
</tr>
<tr>
<td>Table Cell</td>
</tr>
</table>
As the form is called up it will show the input fields on the left but typically on the right of the page you will see how the copy looks in the template block 1. The fields can change and each block can be very different each time.
I need advice on how you would typically create a page do this?
How would you store the results of these fields in the SQL?
I know i would have to have a table where I can store all these blocks thats fine.
Any advice would be apprecated!