0:00
Hi friends, welcome to tutors for
0:02
channel. Today I'm going to teach you
0:05
how to make the inventory management
0:07
system using PHP with a. So here first
0:11
I'm going to go to the GP
0:15
simply now I'm going to go to make the
0:18
point of simple inventory management
0:21
system. So you have to tell them what
0:23
are the things you need. Okay. So first
0:25
what I'm going to do is I'm going to
0:28
first I'm going to tell them they will
0:50
inventory management system.
0:58
It consist of consist of
1:04
stuff. You can tell them category,
1:17
we have a sales. Simple. This is simple.
1:20
Simple, manageable. and print receipt.
1:24
Printable and printable receipt.
1:47
You have to tell them like okay it
1:49
consist of you can tell them simple you
1:51
can tell them can write here put the
1:54
double quotation mark and tell them they
1:57
a easily understand what the user need
2:00
consist of we can easily understand okay
2:03
you don't care about the spelling
2:05
mistake this all the uh phm that a to
2:09
understand that so let's
2:17
modules. What are the modules here?
2:19
Category management. These are the
2:20
modules. Okay. This is the SQL execution
2:23
that this is a brand creation execution.
2:26
This a product execution and it's a
2:29
sales execution. Okay. This is the first
2:34
This is the first step. When the sale is
2:36
completed, we we have to put up data.
2:39
Okay. This is a structure.
2:43
This is a very good structure. So first
2:45
we will be look at this one.
2:48
Okay. So first if you have not installed
2:51
a zam in your machine you have to
2:54
install the zam server. Go to here zam
2:59
download and install them. This is first
3:02
after install them. What you're going to
3:04
do is I'm going to go to
3:15
cl run. Okay, we have start.
3:21
Now what I'm going to do is I'm going to
3:36
instead of do like this you can simply
3:45
Click the admin button
3:49
this code. Okay. Here the thing is you
3:54
have to create the tables. Don't create
3:57
manually. You have to create by the code
4:00
wise. That is a efficient. You have to
4:02
create a code wise. You have right here
4:04
create a table categories ID
4:06
autogreement. It's a category category
4:10
name. It's a greater uh time stamp.
4:13
Create a date of the category. This is a
4:15
must. Okay. This how that efficient way
4:17
to create the database. Okay. So after
4:19
that what I'm going to do is first I'm
4:21
going to create a database new. I'm
4:24
going to create the uh shop. You have uh
4:28
put some shop name. Okay. So you have to
4:32
uh I'm going to create the G M Y. This
4:38
is my shop name. GM by J Y
4:50
Okay, you have to tell them the
4:52
meaningful name. This is my top name.
4:54
This this is my inventory.
4:58
My database created successfully. Inside
5:00
database, we have to get the table. So,
5:06
Okay, this is the column we needed
5:10
each category click go
5:14
added successfully again I'm going to go
5:16
to SEO tab uh SQL tab second one the
5:20
brand table consist of brand ID brand
5:23
name and type so here what is the
5:35
and brand what's the meaning
5:39
category is a which is known as a
5:42
product okay so we have a product mean
5:46
uh if you have a fan this one category
5:57
okay so TV another category these are
6:00
called as category what is a brand it is
6:02
a this uh The TV consists of many brand.
6:07
It may be a LG or Samsung water. Okay.
6:17
so it is called as a brand. So each
6:20
category as a brand. Okay. So you have a
6:25
brand. So when when you implement the
6:28
inventory management system you have you
6:31
have to implement this this two must
6:33
category and it's brand. So now here
6:41
we have to what I have to we have to
6:43
create a brand also. Okay. So what I'm
6:44
going to say here brand click
6:50
now your category is created
6:51
successfully. Brand has been created
6:53
success. After that what I'm going to do
6:56
is I'm going to go to another one is a
6:57
product. Okay product. This is a very
7:00
important part. When you add the product
7:03
okay when you add the product we have
7:05
these are the columns. What are the
7:08
columns? ID category ID brand ID.
7:12
product name, B code which is this is
7:15
the B code mean which is this is the
7:18
uh when when the customers come to our
7:20
shop we easily we can scan it the
7:23
particular product instead of we have to
7:25
search for their price we just punch the
7:30
barcode we can pick the
7:33
product details and we can easily we can
7:36
compress the states it's very quickly we
7:38
can run the v the barcode when you are
7:41
uh make the sales. When the sales is
7:44
happening, the bar code is working. It
7:46
is very easy easy product to complete
7:49
the sales. Cost price, sales price,
7:51
quantity, image and everything consist
7:53
of the product. So this product it
7:56
consists of a foreign key. Okay. So what
7:58
foreign keys when you select the product
8:01
we have to select the product as its
8:05
okay the if you have a shop it consists
8:08
of product it brand. When a customer ask
8:11
TV, it ask that specific category uh
8:15
brand. Okay. So the imagine you have a
8:19
TV, the TV customer might ask I need a
8:22
TV uh brand should be LG. So we have to
8:26
select the category TV brand should be
8:29
LG. So when you implement the
8:31
relationship so one to many relationship
8:35
one product category consist of many
8:37
brands. So how to implement this
8:44
category table where is the ID category
8:47
table where is the ID
8:54
to product table which is called as a
8:56
foreign key there's a primary key it's
8:58
called as a foreign key you have to
9:00
implement the reference which categories
9:02
table ID it's a reference here this is a
9:06
foreign key the foreign key which
9:07
nothing but This is a foreign key mean
9:09
it is go to another table it's called as
9:12
a foreigner it's concern considered as a
9:15
foreign if you consider you have go to
9:17
another country you are called as a
9:20
foreign so the same thing implement in
9:22
the program the one ID is to available
9:26
in another table which called as a
9:28
foreign key okay the category
9:32
category ID is a foreign key that the
9:34
brand ID which is a foreign key okay
9:36
this all the things we just copied
9:40
Paste it over here. Go to sexual
9:43
paste it over here and click go.
9:48
Now we successfully we we created the
9:52
tables brand table category table and
9:54
products. Okay. So these are the
9:58
important stuff we did. Okay. Okay. So
10:01
what are the things we have uh we have
10:03
did on category and brand and product.
10:06
So here in this system we have to do
10:09
manually take too much of time because
10:12
we have to here we have to everything is
10:16
here you can see the cost price selling
10:18
price everything should be there it is
10:19
very easy rather than we have write the
10:22
code it is take too much of time to
10:24
complete okay so the time also we have
10:27
the the AI will be save our time and all
10:31
to generate the code itself okay so this
10:33
is the scenario okay I hope you can
10:36
understand the things well. In my next
10:38
tutorial, I cover about the remaining
10:41
the rest of the part of the tutorial as
10:43
well. Thank you for watching. If you
10:45
love my channel, please subscribe and
10:46
love me. Uh please share your friends as
10:49
well those who are interested in
10:51
programming journey. Thank you.
