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