Transcript

00:39 very simple form that I have set up that
00:41 just collects name a message and an
00:44 uploaded image so in this case I'm just
00:46 going to quickly go in here and put in
00:48 my
00:50 name and I'm just going to upload an
00:53 image and submit the
00:56 form now after I submit the form I have
00:58 a redirection that will take me me to a
01:01 feeds page that pulls from this
01:04 database so right now we can see here
01:06 that we have this entry Joshua
01:09 hello we can view this entry as well as
01:13 edit this entry the edit function is
01:15 part of the F6 to sq update stack this
01:19 allows us to actually update the fields
01:22 that are in the record for the SQ
01:27 table we'll just change the message from
01:29 hello so Hello nice to meet you
01:39 today so see here now that we have
01:41 updated this entry you can also go back
01:43 to the database list and that record has
01:45 been
01:47 updated so this data is stored in an sqa
01:50 database and is being updated via the F6
01:54 to sq update stack and feeds here
01:57 viewing the database let's just just put
02:00 in another
02:04 entry you can see in here we have now
02:08 added another entry into the database we
02:11 also have the ability to view this one
02:12 as well as edit the entry and update any
02:15 of the
02:17 details so that is the basics of the F6
02:20 to sq Stacks now let's have a look into
02:24 this so after you have created your form
02:27 that need to collect the data that
02:28 you're looking to do you're going to
02:29 drag the F6 to escalate stack onto your
02:32 page in here some very basic settings
02:34 that you need to set up you need to set
02:36 where your database is going to be the
02:38 database name and the table name this
02:41 will create the database even if it does
02:43 not exist already you can choose where
02:46 you want to store your files and whether
02:47 or not you want to store the files in
02:49 the table I'm not going to go over the
02:51 store files in the table option in this
02:53 video but that is an option that you can
02:55 do in this case I've selected to have
02:58 the URL of the file to be stored into
03:01 the database what this allows us to do
03:04 is actually have the files right here
03:07 stored in the same location as the
03:09 database so I've chosen to put the
03:11 images into this data folder and then
03:15 the URL to that file stored into the
03:17 database what this looks like on your
03:19 actual server would be this so in here
03:23 is the escate database and these are the
03:25 two images that we uploaded with the
03:28 form and that's all the setting you need
03:30 there now part of setting up F6 sq8 is
03:33 getting this Ajax request set
03:36 up so if we actually preview the
03:38 settings
03:42 here and you see the step one is to add
03:44 a aex request to your form so we've
03:47 added an Ajax request to our form and in
03:49 there you need to set the URL to F6
03:52 tosql light. PHP by default your Ajax
03:55 request will be a post so all you need
03:57 to do is add in the F6 sq. pH HP in that
04:02 URL now in my form I also wanted it to
04:05 redirect after it successfully added
04:08 data to the database so I added a
04:10 redirect to the actual database page
04:13 where we've set up the feeds that view
04:15 the data and that's it that's all you
04:17 need to do to start collecting data into
04:19 an sqa database now for the database
04:22 page what I have here is just a feeds
04:25 hooked up to the SQ database I'm not
04:27 really going to go over the feed setup
04:28 this is something that you can do on one
04:29 of the feeds videos from Weaver
04:32 space one of the important things to set
04:35 up with feeds is the option to view the
04:37 entry and that we've done this here
04:39 where we have a link that would go to
04:41 the entry into the
04:44 ID what this allows us to do is go to
04:46 this entry page which we've set up here
04:49 and this entry page allows you to view
04:51 the ID as well as edit so how do we set
04:54 up the editing portion well first of all
04:57 you'll see here that this is the entry
04:59 page
05:00 I've set this up as
05:01 entry and on the actual site when we go
05:03 to
05:05 view you can see in the URL up here that
05:09 we're on the entry ID equals 1 if we go
05:12 back and View the second one this is ID
05:16 equals 2 to set up the editing with F6
05:19 to sq8 update first we're going to
05:22 create another page called
05:24 edit so on this here you see the
05:26 navigation is edit index.php and then we
05:29 Dr the F6 to escalate update stack onto
05:32 the page in this stack we are going to
05:34 also point to the exact same
05:36 database now on redirect on submit we
05:40 want it to go back to the entry and we
05:43 want it to pass the record ID what this
05:45 allows you to do is after you've gone
05:47 into this record to edit the record when
05:49 you hit submit it's going to pass you
05:52 back to the entry and the ID that this
05:55 is so you see this is
05:57 id2 how do we get this edit button but
05:59 to work so after we've created this page
06:03 and we know that it's edit all we need
06:05 to do is pass off the ID the entry ID
06:09 that we're in to the edit page so if we
06:12 were to go look at this
06:15 link we'll see here that we're going up
06:18 a page and then going to the edit and
06:21 we're passing the ID equals an ID
06:25 macro and that's it so now when you
06:27 click the edit entry see that when we
06:30 hover this button now that it has the
06:32 proper link to the record of id2 that we
06:35 programmed into the link and we click
06:37 that link now we're editing that now
06:40 this page is really cool is this page is
06:41 being dynamically created from the
06:43 database entry there is some other
06:45 settings inside of the um F6 to escalate
06:48 update where you could remove specific
06:50 fields from being edited this is
06:52 beneficial if you don't want specific
06:54 Fields being changed by the
06:57 user for instance say we didn't want the
06:59 F name to be edited we can actually just
07:01 go in here and type in file
07:06 name and publish this out so now when we
07:09 go to edit this
07:10 entry file name is no longer there which
07:13 is very useful if you have fields that
07:15 you don't need to be
07:17 edited that is a quick video on how to
07:19 use F6 to sqlite Stacks from stack app
07:23 stacks