Submit a form to mySQL database - I don't get it

Hi,
please excuse my bad English (I’m from Germany). I hope you can understand my problem.

I made a form with the PHP Formmailer action with fields like “name”, “street” and “zip”. By submitting the form, it’s content should be saved in a mySQL database, which I made with phpmyadmin.

When I understand it right, I need to use the MySQL action to connect to my database - so I did.

But what now? I read so many posts, by I don’t understand it. In phpadmin I can e.g. simply ust SELECT * FROM tablename an get all the data. I tried the mySQL Get Records action, but it doesn’t work (I simply put the query from above in the “my SQL query” field of the action.

And further I would like to fill out a form and send the data to my database.

Could perhaps somebody point me into a right direction? This would be so nice.

Thanks for your time and brain ,-)

LG
tommy


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

As far as I know, the PHP Feedback Form Action (is that the one you
meant?) does not talk to MySQL. All it does is send an e-mail message
containing the form data to a designated admin.

To add the form content to the database, you would need to use a
different form handler than the one generated by PFF.

Walter

On Oct 2, 2010, at 11:04 AM, TomB wrote:

Hi,
please excuse my bad English (I’m from Germany). I hope you can
understand my problem.

I made a form with the PHP Formmailer action with fields like
“name”, “street” and “zip”. By submitting the form, it’s content
should be saved in a mySQL database, which I made with phpmyadmin.

When I understand it right, I need to use the MySQL action to
connect to my database - so I did.

But what now? I read so many posts, by I don’t understand it. In
phpadmin I can e.g. simply ust SELECT * FROM tablename an get all
the data. I tried the mySQL Get Records action, but it doesn’t work
(I simply put the query from above in the “my SQL query” field of
the action.

And further I would like to fill out a form and send the data to my
database.

Could perhaps somebody point me into a right direction? This would
be so nice.

Thanks for your time and brain ,-)

LG
tommy


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

Thanks Walter for your reply.

You’re right, I meant the PHP Feedback Form action. Okay, this action seems to be not the right one. Can you recommend something I can use fpr my purpose? Is there any action or possibility to save the content of form elements to a mySQL database?

I don’t care which tools I need as long as works ,-)

Thanks and best regards,

Tommy


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

Can you recommend something I can use fpr my purpose? Is there any
action or possibility to save the content of form elements to a
mySQL database?

Do you mean something similar to how this works?
http://xiiro.com/client/

Todd


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

Todd,

yes, that’s (nearly) what I want :slight_smile: And looks very nice, too.

We want to use the form to save customer data, but only for internal aims (e.g. when we spent a whole day on customer acquisition and want to share the results).

So my far aim is the third step: also to be able to CHANGE existing data.

Yes, we could use other tools - but I’d like to realize it in freeway, 'cause I love the program and the community.

Thanks for your answer,
Tommy


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

Freeway, all by itself, cannot create this sort of thing. You might be
able to plug together some of the PHP Actions with a healthy chunk of
hand-coded PHP logic and make a form handler and reporting tool. But
there’s nothing pre-built that I could put you in touch with, because
there are no two databases or applications alike out there.

I use a library called MyActiveRecord, written by Jake Grimley and
maintained and extended by me when I write PHP/MySQL code. This gives
me a huge foundation for building specific applications. But I still
need to write and understand code to work with it.

I have also used a JavaScript library called TableKit, which works
with the Prototype.js library and provides a very simple “data grid”
implementation, so you could double-click a row in a table and open an
in-place editor to touch up user-submitted data, for example.

I don’t have any admin-side examples available publicly, naturally
they are private to my clients, but I might be able to post something
later that would give you a sense of what you need to learn in order
to do something like this.

Walter

On Oct 2, 2010, at 2:29 PM, TomB wrote:

Todd,

yes, that’s (nearly) what I want :slight_smile: And looks very nice, too.

We want to use the form to save customer data, but only for internal
aims (e.g. when we spent a whole day on customer acquisition and
want to share the results).

So my far aim is the third step: also to be able to CHANGE existing
data.

Yes, we could use other tools - but I’d like to realize it in
freeway, 'cause I love the program and the community.

Thanks for your answer,
Tommy


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

If you have a look at Formstogo

That can send your Freeway form result into an SQL database

The software creates the form handler for you.

David

On 2 Oct 2010, at 16:04, “TomB” email@hidden wrote:

Hi,
please excuse my bad English (I’m from Germany). I hope you can understand my problem.

I made a form with the PHP Formmailer action with fields like “name”, “street” and “zip”. By submitting the form, it’s content should be saved in a mySQL database, which I made with phpmyadmin.

When I understand it right, I need to use the MySQL action to connect to my database - so I did.

But what now? I read so many posts, by I don’t understand it. In phpadmin I can e.g. simply ust SELECT * FROM tablename an get all the data. I tried the mySQL Get Records action, but it doesn’t work (I simply put the query from above in the “my SQL query” field of the action.

And further I would like to fill out a form and send the data to my database.

Could perhaps somebody point me into a right direction? This would be so nice.

Thanks for your time and brain ,-)

LG
tommy


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

Thanks again Walter!

It will take me some time to completely understand and check out your answer and links (my English is not too good…)

Here’s my “little dream”:

a) use site action MySQL Connect… to get the connection ,-)

b) use item action MySQL Get Records to read out what you want, that means you can choose wheter and/or which colums/rows will be displayed on your website…

c) use “XYZ” action to add new content to your database (within a form!)
d) When you want to change entries, you have the same form like in point “c” which is already filled out with the custormer’s information. By clicking a “left or right arrow” you see the next customer…and you can change the data.

That would be a really great solution - and I kep dreaming! ,-)

Thanks again and best regards,

Tommy


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

I use phpMyEdit to manage a couple of databases for customers http://www.phpmyedit.org/

It can easily be integrated into a FW page for just this sort of job.

The advantage being that it is all done on the 1 page.

David


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

Hi Dave,

this seems to be a very interesting idea! I thought about using “phpmyadmin” but that would have been too dangerous for a usage with 5 persons.

The phpMyEdit semms to be a lot more comfortable as I viewed in the demo.

I will have a closer look now - thangs again!

Okay, this is not the finest solution, but when it works - it’s okay.

Best regards,
Tommy


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

With …MyEdit you can disable parts of the process - unlike MyAdmin where they are let loose on the whole MySql shooting match

// Options you wish to give the users
// A - add,  C - change, P - copy, V - view, D - delete,
// F - filter, I - initial sort suppressed
$opts['options'] = 'ACPVDF';

D


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