[Pro] Form -> PHP -> mySQL

This is probably well known and well discussed subject but maybe there are some news. What framework do you recommend for “simple” task: create form in FW, develop PHP script around it, send form data (fields) to a mySQL table? Maybe we have already some sort of super Action plugin? :-;


dynamo mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Have a look at Forms To Go. You can create a form in Freeway, ingest it into FTG, and create the scripts needed for your server. If you want to work in the other direction (start with the database table, generate an HTML interface to fit it) then look at my Generate script: GitHub - walterdavis/generate: Lightweight clone of script/generate scaffold for MyActiveRecord and pals. Note: this latter option does not involve Freeway in any way. Watch it in action here: http://freewaycast.com/screencasts/view/85-generate-a-database-application

Walter

On Dec 3, 2012, at 1:06 PM, Tomek wrote:

This is probably well known and well discussed subject but maybe there are some news. What framework do you recommend for “simple” task: create form in FW, develop PHP script around it, send form data (fields) to a mySQL table? Maybe we have already some sort of super Action plugin? :-;


dynamo mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options


dynamo mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

One of the easier ways is to use FormsTo Go, it’s all wrapped up nice and neat.

But if you want or need to customize things and don’t mind getting “hands-on” then here’s an old example I put together using Walter’s MyActiveRecord (MAR) framework, http://xiiro.com/development, click the “try demo” link to see the front- and back-end. But he has a newer more lightweight Generate script you should look at which automates a lot the techy bits.

Todd
http://xiiro.com


dynamo mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

I found FormsToGo very nice and useful but I have problems with proper characters handling when dumping text data to mySQL tables. International characters are interpreted on totally wrong way. What is strange → the same script produces proper email body contents with proper characters settings (UTF-8). Subject of email interprets international characters on the wrong way but this is not a big issue form me.

Any idea chow to force FormsToGo to load texts on a proper way? I am not sure but anyway I do not see possibility to use commands like: “SET NAMES utf8”, “SET CHARACTER_SET utf8_unicode_ci”


dynamo mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options