I don’t know about easy, but take a look at this page of code: https://github.com/walterdavis/mini-active-record/blob/master/demo/index.php and tell me if it makes any amount of sense to you. What this page demonstrates is a simple messages form and handler. It uses the ActiveRecord programming pattern to manage the relationship between the code and the database.
Lines 19-23 define the model that stands for the messages. Line 21 sets up validations, requiring that the person enter their name and the message (named body in this schema) in order to save. Line 22 sets up those two fields as “writeable”.
Line 40 is where we start writing the form contents into the database. The check for $_POST[‘commit’] checks to see if the form was submitted (since that’s the name of the submit button, and it would only be in the $_POST array if the button was pushed). Line 41 takes whatever was submitted from the form and writes it to the model. The model then validates whatever was entered, and if it passes muster, it writes a new record into the database with the form values.
The rest of the code is there to either display errors to the user, or to show a success message, or to show all the successfully submitted messages.
This is all wrapped together into one page of code, mixing PHP and HTML, which is not how normal apps are written. It’s just a demo. If you were to build the form in Freeway, you could use the PHP Use Include Pages action PHP Use Include Pages - ActionsForge to insert the PHP code into the top of the page, so you’d have a little separation between layout and code.
So the test for “easy” here is how much sense does the code on this page make to you. If the answer is “none”, then I don’t have anything easier to show you. If it makes some small amount of sense, then you may find this framework useful. Back when I used to write PHP, I used it all the time, and it really makes wiring up a database to the rest of the page quite straightforward.
Walter
On Mar 6, 2020, at 11:12 AM, Richard Cacciato email@hidden wrote:
I’m trying to create a form in Freeway and capture the form data in a MySQL Database. I’m hoping (lazily) that there’s an easy way to do this. I’ve set up the form and applied the mySQL connect action. From what I can see, the mySQL connect action sets up the database connection and theoretically all I would need to do is have a post action to post the form data to the db. There is the MySQL Get Records action on ActionsForge MySQL Get Records - ActionsForge but there’s no equivalent post action.
Hoping someone can point me in the right direction, and that it’s not too hard…
Thanks in advance.
freewaytalk mailing list
email@hidden
Update your subscriptions at:
Information for existing FreewayTalk / Groups.io users - Site Feedback - Softpress Talk
freewaytalk mailing list
email@hidden
Update your subscriptions at:
https://freewaytalk.softpress.com/person/options