Creating A Database & Table (phpMyAdmin)

5 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$99.99
List Price:  $139.99
You save:  $40
€95.97
List Price:  €134.37
You save:  €38.39
£79.79
List Price:  £111.71
You save:  £31.92
CA$140.31
List Price:  CA$196.44
You save:  CA$56.13
A$153.75
List Price:  A$215.26
You save:  A$61.51
S$134.64
List Price:  S$188.51
You save:  S$53.86
HK$778.36
List Price:  HK$1,089.74
You save:  HK$311.37
CHF 89.34
List Price:  CHF 125.09
You save:  CHF 35.74
NOK kr1,107.14
List Price:  NOK kr1,550.05
You save:  NOK kr442.90
DKK kr715.75
List Price:  DKK kr1,002.09
You save:  DKK kr286.33
NZ$171.37
List Price:  NZ$239.93
You save:  NZ$68.55
د.إ367.26
List Price:  د.إ514.18
You save:  د.إ146.92
৳11,945.63
List Price:  ৳16,724.36
You save:  ৳4,778.73
₹8,442.99
List Price:  ₹11,820.52
You save:  ₹3,377.53
RM446.75
List Price:  RM625.47
You save:  RM178.72
₦169,271.38
List Price:  ₦236,986.70
You save:  ₦67,715.32
₨27,777.22
List Price:  ₨38,889.22
You save:  ₨11,112
฿3,446.26
List Price:  ฿4,824.91
You save:  ฿1,378.64
₺3,454.90
List Price:  ₺4,837
You save:  ₺1,382.10
B$580.04
List Price:  B$812.08
You save:  B$232.04
R1,815.38
List Price:  R2,541.61
You save:  R726.22
Лв187.66
List Price:  Лв262.73
You save:  Лв75.07
₩140,436.95
List Price:  ₩196,617.35
You save:  ₩56,180.40
₪371.46
List Price:  ₪520.07
You save:  ₪148.60
₱5,893.31
List Price:  ₱8,250.87
You save:  ₱2,357.56
¥15,475.45
List Price:  ¥21,666.25
You save:  ¥6,190.80
MX$2,042.64
List Price:  MX$2,859.78
You save:  MX$817.14
QR364.56
List Price:  QR510.41
You save:  QR145.84
P1,367.06
List Price:  P1,913.94
You save:  P546.88
KSh12,945.58
List Price:  KSh18,124.33
You save:  KSh5,178.75
E£4,964.52
List Price:  E£6,950.52
You save:  E£1,986
ብር12,237.67
List Price:  ብር17,133.23
You save:  ብር4,895.55
Kz91,290.87
List Price:  Kz127,810.87
You save:  Kz36,520
CLP$97,782.75
List Price:  CLP$136,899.76
You save:  CLP$39,117.01
CN¥724.22
List Price:  CN¥1,013.94
You save:  CN¥289.72
RD$6,024.63
List Price:  RD$8,434.73
You save:  RD$2,410.09
DA13,426.15
List Price:  DA18,797.15
You save:  DA5,371
FJ$227.57
List Price:  FJ$318.61
You save:  FJ$91.03
Q771.64
List Price:  Q1,080.33
You save:  Q308.69
GY$20,913.50
List Price:  GY$29,279.73
You save:  GY$8,366.23
ISK kr13,962.80
List Price:  ISK kr19,548.48
You save:  ISK kr5,585.67
DH1,005.63
List Price:  DH1,407.93
You save:  DH402.29
L1,821.98
List Price:  L2,550.85
You save:  L728.86
ден5,904.20
List Price:  ден8,266.12
You save:  ден2,361.91
MOP$801.48
List Price:  MOP$1,122.11
You save:  MOP$320.62
N$1,812.81
List Price:  N$2,538.01
You save:  N$725.20
C$3,678.31
List Price:  C$5,149.78
You save:  C$1,471.47
रु13,500.25
List Price:  रु18,900.90
You save:  रु5,400.64
S/379.05
List Price:  S/530.69
You save:  S/151.63
K402.47
List Price:  K563.48
You save:  K161
SAR375.40
List Price:  SAR525.58
You save:  SAR150.17
ZK2,764.29
List Price:  ZK3,870.12
You save:  ZK1,105.82
L477.77
List Price:  L668.90
You save:  L191.12
Kč2,432.37
List Price:  Kč3,405.42
You save:  Kč973.04
Ft39,496.05
List Price:  Ft55,296.05
You save:  Ft15,800
SEK kr1,103.50
List Price:  SEK kr1,544.95
You save:  SEK kr441.44
ARS$100,363.46
List Price:  ARS$140,512.86
You save:  ARS$40,149.40
Bs690.75
List Price:  Bs967.07
You save:  Bs276.32
COP$438,931.09
List Price:  COP$614,521.09
You save:  COP$175,589.99
₡50,918.63
List Price:  ₡71,288.12
You save:  ₡20,369.49
L2,526.16
List Price:  L3,536.73
You save:  L1,010.56
₲780,388.98
List Price:  ₲1,092,575.79
You save:  ₲312,186.81
$U4,261.82
List Price:  $U5,966.72
You save:  $U1,704.90
zł416.31
List Price:  zł582.85
You save:  zł166.54
Already have an account? Log In

Transcript

Hello, in this video I am going to show you how to create a database and a table. Not using code will actually you know do some of that later on in the my SQL section of this series. But using PHP, my admin first of all in your panel, make sure you have my SQL started. If it is great, if not start it and then we're good to go. You may need to start in a different way for your online server. You'll feel free to contact your server you know your host provider, ask them to do it should already be activated, they'll probably be a specific URL that you need to access it if you haven't any trouble with that feel free to shoot me a message and you know let me know what hos providing you with and I'll you know have a look see if I can find a solution.

So to get to it, you can type in localhost you know what you usually would wave the port number to access your website for slash PHP my admin like so and it will take you to this little page. So I'll say get very used to it, because this is what you'll be using a lot locally and online as well. So this will allow us to create databases already some databases created here. So the PHP myadmin one, and inside here there are tables if I go to use it, for example, they are no users. But let's go to the homepage. We can go to databases, and we can create a new database name.

And do I want Latins Swedish. Okay, weird. And a while we'll say Latin one Swedish she should be UTF English range leave it up. UTF generally is really where you should want to not say stuff like that. Okay, so if we say, epic database and click Create, that's the database created, that's a right over here at the moment, it's empty, because there are no tables in there. So we need to create a table.

So we could so this database, usually you'll have the one database for your website, you can have multiple tables in there. And you could have a table for users will have a table for let's say, a social media site, a table for comments, table for posts, table for, you know, tracking or the likes and thumbs up on a website, for example, stuff like that. So this is number column, basically, the manage data you're storing. Don't worry, you can add extra columns and take away columns, or like data if you have you know, some in mind. You can just put them right yeah, I'm going to put two for now and the name I'm going to put up So if I go to go is created it. And now you want to tell it, what each, you know column is what each piece of data is.

One should always have his ID keep that into jack. And you don't want to default, you want to go to index primary. So yes, click Go. So this primary and unique, unique index is well it can't be, what's the code, you can't have a duplicate row in your table with you know, with a value in another row, that's the same, whereas primary is the same as unique, but it is the primary one used to identify particular row so you always have one primary and there'll be unique as well. We could have multiple unique and do AI which is auto increment. So you're basically just start off with 0123 and you know, etc.

We don't need to really mess with The US for what we need for now. And I'm going to put this username. And I'm going to put this a VAR char which means a variable Kota. Essentially, you can put strings here, and then a bunch of different formats like text date, now integers, tiny integers. So really small number two big NT can store a really big number. And the reason you might have a small one compared to a big one, if you know you're only going to store small numbers, then it will, you know, reduce the amount of space that you need.

And if you really need really big text, you can go to stuff like long text binary, and even stuff like blob and non blob, which is essentially allows you to elegancy store actual gigabytes worth of data and the lock down this bar chart, and we produce MPs or per length of 32 because either names usually aren't too long. There we go. So if we click Save That's our table created five go to growth. This shows us all is at our table. And there's nothing there because we haven't actually added any, you can insert data here as well. And we'll actually be inserting it using code and we'll be viewing it all in here.

So over the next few videos, we'll be connecting to the database in code. We will be adding data to it. We'll be doing a whole heap of stuff, the really cool stuff. Any questions, feel free to pop me a message and as usual, I look forward to seeing you in the next video.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.