1
00:00:00,000 --> 00:00:03,493
>> [MUSIC PLAYING]

2
00:00:03,493 --> 00:00:04,934

3
00:00:04,934 --> 00:00:07,100
DOUG LLOYD: In videos
on web development topics,

4
00:00:07,100 --> 00:00:10,560
Supra diximus conceptum
aliquoties a database iudicium

5
00:00:10,560 --> 00:00:12,700
Ut a database es
forsit familiar, cum ex

6
00:00:12,700 --> 00:00:15,780
dico usura Microsoft Excel
aut Google Spreadsheets.

7
00:00:15,780 --> 00:00:20,650
Suus 'vere iustus an verat
set mensarum ordines et quinae denae.

8
00:00:20,650 --> 00:00:23,140
>> Et a database ubi est
our website stores

9
00:00:23,140 --> 00:00:26,760
notitia ut est maximus
nostrum website proprie operari.

10
00:00:26,760 --> 00:00:30,150
Iterum, a vere commune exemplum hic
est thesaurizantes Donec et passwords

11
00:00:30,150 --> 00:00:32,824
In datorum, ut cum
Acta filtri iniuriarum a user in nostrum website,

12
00:00:32,824 --> 00:00:36,690
database potest videre queried
quod si user est in database.

13
00:00:36,690 --> 00:00:39,260
Et si, quod aduersus
tesseram recte.

14
00:00:39,260 --> 00:00:43,420
Tesseram si recte
Quidquid ergo dicere possumus page

15
00:00:43,420 --> 00:00:45,370
Lorem postulans.

16
00:00:45,370 --> 00:00:48,590
>> Ita et vos es forsit iterum, familiar
vel cum hoc e Excel Google

17
00:00:48,590 --> 00:00:49,430
Spreadsheets.

18
00:00:49,430 --> 00:00:52,980
Habemus databases,
tabularum ordines et quinae denae.

19
00:00:52,980 --> 00:00:56,450
Et quod suus 'vere sort
fundamentalium set

20
00:00:56,450 --> 00:00:58,470
hierarchicae naufragii here.

21
00:00:58,470 --> 00:00:59,800
Hic igitur an Praecedo spreadsheet.

22
00:00:59,800 --> 00:01:02,640
Aenean semper aperuit et hoc
vel alius similis progressio

23
00:01:02,640 --> 00:01:06,780
tu scis quia isti sunt
rows-- I, II, III, IV, V, VI, VII.

24
00:01:06,780 --> 00:01:08,760
Hi sunt quinae denae.

25
00:01:08,760 --> 00:01:11,790
>> Fortasse hic licet,
non uti hoc pluma valde much--

26
00:01:11,790 --> 00:01:15,370
Ego zoom in-- habemus
haec idea de sheet.

27
00:01:15,370 --> 00:01:17,930
Sic maybe haec videbuntur chartis tibi, si
I alternare retro et foras,

28
00:01:17,930 --> 00:01:21,600
differunt mensas
usquam in hac mea database.

29
00:01:21,600 --> 00:01:25,210
Si manseritis in exemplum
via hoc nomen database

30
00:01:25,210 --> 00:01:26,940
is Book I.

31
00:01:26,940 --> 00:01:28,710
Maybe habeo librum III libro II.

32
00:01:28,710 --> 00:01:33,270
Sic indigne quisque Excel file est
database, singulis sheet est diligenter exara illud,

33
00:01:33,270 --> 00:01:39,530
singulis tabulis et intus habeo
hac ratione ordines columnarum.

34
00:01:39,530 --> 00:01:41,900
>> Sic quam operor ego operor hoc database?

35
00:01:41,900 --> 00:01:43,630
Quomodo ex notitia?

36
00:01:43,630 --> 00:01:47,540
Bene illic 'a lingua dicitur SQL--
quam solet iustus vocant Sequel--

37
00:01:47,540 --> 00:01:50,010
et pro
Query Language exstructa.

38
00:01:50,010 --> 00:01:52,981
Et est programming lingua
sed illud solum satis programming

39
00:01:52,981 --> 00:01:53,480
lingua.

40
00:01:53,480 --> 00:01:56,407
Suus 'non prorsus sicut et ceteri
quoniam translati sumus cooperante.

41
00:01:56,407 --> 00:01:58,240
Sed recuperat virginitatis propositum huius
programming lingua

42
00:01:58,240 --> 00:02:01,570
est query a database, ad
quaero notitia a database,

43
00:02:01,570 --> 00:02:04,480
reperio notitia in a
database, and so on.

44
00:02:04,480 --> 00:02:08,449
>> Nos quoque, in CS50-- quod suus 'valde
commune tribunal suus dicitur MySQL.

45
00:02:08,449 --> 00:02:10,600
Id scilicet adhibebimus.

46
00:02:10,600 --> 00:02:12,880
Suus 'an patefacio radix
suggestum qui stabilit

47
00:02:12,880 --> 00:02:16,732
a sic-accersitus obviat relationis database--
a database, efficaciter.

48
00:02:16,732 --> 00:02:18,440
Non postulo impetro
nimium in detail

49
00:02:18,440 --> 00:02:20,930
quod est a respectiva datorum.

50
00:02:20,930 --> 00:02:24,650
Sed in SQL sermone
ipsa instructissimos ad opus

51
00:02:24,650 --> 00:02:29,760
cum MySQL et cetera huius modi,
nativos obviat relationis databases.

52
00:02:29,760 --> 00:02:34,010
>> Dicebant autem multi ex installations
MySQL venit cum aliquid

53
00:02:34,010 --> 00:02:37,760
vocavit phpMyAdmin quod
est graphical user

54
00:02:37,760 --> 00:02:40,970
interface-- a GUI-- quod
facit eam aliquantulus magis

55
00:02:40,970 --> 00:02:44,410
user benignos esse faciendam
queries database,

56
00:02:44,410 --> 00:02:48,980
quia non iustus usus databases
per provectus programmers, ius?

57
00:02:48,980 --> 00:02:51,510
Aliquando autem non sunt
his parvis negotiis,

58
00:02:51,510 --> 00:02:53,900
et non possunt
ponderatis conducentes bigas programmers,

59
00:02:53,900 --> 00:02:56,700
sed tempus rursum indigetis ut congregem
notitia in a database.

60
00:02:56,700 --> 00:02:59,300
>> Aliquid simile phpMyAdmin
facit eam facillimum aliquis

61
00:02:59,300 --> 00:03:03,630
qui programmed numquam ante hoc tempus
colligebant et adsuesceret quam

62
00:03:03,630 --> 00:03:07,710
operari cum database.

63
00:03:07,710 --> 00:03:11,800
Difficultatem phpMyAdmin dum
suus 'a tool doctrina fantastic

64
00:03:11,800 --> 00:03:14,850
de databases, est manual.

65
00:03:14,850 --> 00:03:18,050
Habiturus es in log
et mandata exequi et type

66
00:03:18,050 --> 00:03:19,910
quae in manually.

67
00:03:19,910 --> 00:03:23,160
>> Et scimus ex nostris
exemplum in PHP web programming,

68
00:03:23,160 --> 00:03:26,550
habens manually
quae in nostrum website,

69
00:03:26,550 --> 00:03:30,970
si volumus dynamicam activa dociles
website fortasse non optimum aditus.

70
00:03:30,970 --> 00:03:33,980
Velimus iter
forte automate hoc qua libet efficias.

71
00:03:33,980 --> 00:03:37,864
Et hoc SQL efficiet.

72
00:03:37,864 --> 00:03:39,780
Cum ergo sis venturus ad
satus opus cum SQL,

73
00:03:39,780 --> 00:03:41,220
euidentiam oportet primo habere
database operari.

74
00:03:41,220 --> 00:03:42,510
Partum a database est
aliquid vos forsit

75
00:03:42,510 --> 00:03:45,350
faciam in phpMyAdmin, quia
youll 'postulo efficio nisi semel

76
00:03:45,350 --> 00:03:49,690
et syntax faciendi
est multum pronius.

77
00:03:49,690 --> 00:03:51,940
Etiam sit amet facilius faceret
graphic in a user interface

78
00:03:51,940 --> 00:03:53,520
eam quam typing secundum imperium.

79
00:03:53,520 --> 00:03:55,186
Praeceptum non modicum gravia.

80
00:03:55,186 --> 00:03:58,889
Similiter potest creando a mensa
get admodum aliquantulus necnon gravia moribunda.

81
00:03:58,889 --> 00:04:01,930
Itaque huiusmodi creando database
deserit tabulae, quae tu

82
00:04:01,930 --> 00:04:06,270
forsit tantum iens efficio once--
semel per mensam semel per database--

83
00:04:06,270 --> 00:04:09,040
Bene est quod facere
a graphical interface.

84
00:04:09,040 --> 00:04:11,570
In processu
partum a mensa, youll '

85
00:04:11,570 --> 00:04:14,840
dare etiam omnibus
columnarum quae in mensa.

86
00:04:14,840 --> 00:04:18,149
Qualem porro illam notitia do
vis congregem mensa?

87
00:04:18,149 --> 00:04:24,520
Aliquam a user nomen et diem nativitatis
password, user ID numero, maybe

88
00:04:24,520 --> 00:04:26,170
urbi imperioque missa est, aequum?

89
00:04:26,170 --> 00:04:30,080
>> Et quoties vis addere user
ad database volumus ut sex

90
00:04:30,080 --> 00:04:31,890
illorum pieces of notitia.

91
00:04:31,890 --> 00:04:34,840
Et faciemus quod additamento
ordines ad mensam.

92
00:04:34,840 --> 00:04:37,800
Ita primum partum a database,
ergo creans mensam.

93
00:04:37,800 --> 00:04:40,100
Ut pars creandi
mensam quaeratur a nobis,

94
00:04:40,100 --> 00:04:44,280
omne quod dat speciem ad column
volumus in hac tabula.

95
00:04:44,280 --> 00:04:47,247
Dehinc add cœperimus
notitia ad database

96
00:04:47,247 --> 00:04:49,580
et query database more
generally-- non iustus addendo,

97
00:04:49,580 --> 00:04:51,610
sed omne aliud
do-- puteus 'commercio

98
00:04:51,610 --> 00:04:58,870
vicorum mensa, unus
set ab omni user scriptor notitia.

99
00:04:58,870 --> 00:05:03,210
>> Sic omnis SQL column est capax
tenens data particularis notitia typus.

100
00:05:03,210 --> 00:05:06,560
Ita hoc genus removeatur
genera data idea in PHP,

101
00:05:06,560 --> 00:05:08,747
sed haerent huc SQL.

102
00:05:08,747 --> 00:05:10,080
Et data sit amet figura.

103
00:05:10,080 --> 00:05:13,420
Hic mox XX ex eis nisi
quod non universi.

104
00:05:13,420 --> 00:05:16,240
Sic habemus ideas quasi INTs--
Integers-- nos forsit scire

105
00:05:16,240 --> 00:05:17,760
Huic agmini ut sustineam integri.

106
00:05:17,760 --> 00:05:21,077
Et variationes dentur thereon--
SMALLINT, varchar, MEDIUMINT, BIGINT.

107
00:05:21,077 --> 00:05:22,660
Forsitan non oportet quod semper quatuor morsus.

108
00:05:22,660 --> 00:05:26,800
Maybe nos postulo octo bytes, ita et nos
can utor illae variationes in integri

109
00:05:26,800 --> 00:05:28,510
spatium sit amet elit.

110
00:05:28,510 --> 00:05:31,899
Possumus decimales numerorum,
potest facere natantis punctum numerorum.

111
00:05:31,899 --> 00:05:32,940
Hi sunt pulchellus simile.

112
00:05:32,940 --> 00:05:34,773
Sunt aliquibus differentiis differunt,
et si vultis

113
00:05:34,773 --> 00:05:37,330
amo spectare sursum
SQL quodam duce

114
00:05:37,330 --> 00:05:40,670
videri potest quid levi
differentiae sunt medium inter ea.

115
00:05:40,670 --> 00:05:43,250
>> Maybe nos volo ut congregem
information about date et tempus.

116
00:05:43,250 --> 00:05:47,047
Maybe erant custodientes semita of
utentis coniunctus cum nostrum website,

117
00:05:47,047 --> 00:05:48,880
et sic maybe volumus
habere column ut '

118
00:05:48,880 --> 00:05:52,820
date a tempore vel a timestamp quod
indicat cum user actu

119
00:05:52,820 --> 00:05:54,130
signati.

120
00:05:54,130 --> 00:05:56,132
Possumus et geometries linestrings.

121
00:05:56,132 --> 00:05:57,340
Hoc est actu pulchellus frigus.

122
00:05:57,340 --> 00:06:01,410
Possemus a describant eam iuxta
Geographicis area usura

123
00:06:01,410 --> 00:06:05,110
GIS coordinat an consilium de area.

124
00:06:05,110 --> 00:06:08,580
Ita possit actu congregem eius modi
SQL notitia in agmen.

125
00:06:08,580 --> 00:06:11,390
>> TEXT est iustus gigas Blobs of text, maybe.

126
00:06:11,390 --> 00:06:12,840
ENUMs sunt genus interesting.

127
00:06:12,840 --> 00:06:16,080
C. Et non in actu
quia loquuntur de illis es

128
00:06:16,080 --> 00:06:19,110
terribiliter plerumque adsuesco assuesco, saltem CS50.

129
00:06:19,110 --> 00:06:22,680
Sed an enumerantur notitia typus, quae
est capax limitatur valores.

130
00:06:22,680 --> 00:06:25,940
>> A bona essent exemplo
quae septemgeminus creare enum

131
00:06:25,940 --> 00:06:29,394
valores sunt solis, lune,
Martis, Mercurii, Veneris, Mercurii,

132
00:06:29,394 --> 00:06:30,060
Saturday, ius?

133
00:06:30,060 --> 00:06:33,311
Quod data type Dies
Week non existit,

134
00:06:33,311 --> 00:06:35,310
sed posset creare an
enumerantur data type talia

135
00:06:35,310 --> 00:06:39,400
nisi quod columna perpetuo
unus illorum septem valores.

136
00:06:39,400 --> 00:06:44,300
Weve enumerare causas omnes
possibilis valores.

137
00:06:44,300 --> 00:06:47,630
>> Et tunc habemus CHAR VARCHAR,
et quia commune aut inmundum super hoc virides color

138
00:06:47,630 --> 00:06:49,505
quia sumus actu
iens accipere secundo

139
00:06:49,505 --> 00:06:51,950
loqui de differentia
inter haec duo.

140
00:06:51,950 --> 00:06:55,780
CHAR ita, dissimilis C ubi
CHAR fuit uno character,

141
00:06:55,780 --> 00:07:00,730
in SQL a CHAR refertur ad
fixum string longitudo.

142
00:07:00,730 --> 00:07:02,620
Et cum hoc iam
agmen, actu

143
00:07:02,620 --> 00:07:05,070
dat speciem chordae longitudo.

144
00:07:05,070 --> 00:07:08,080
>> Ut in hoc exemplo,
dicamus CHAR (X).

145
00:07:08,080 --> 00:07:11,190
Quod significet quod omnia
elementum ut column

146
00:07:11,190 --> 00:07:13,910
constabunt ex X bytes of notitia.

147
00:07:13,910 --> 00:07:15,770
Non magis nec minus.

148
00:07:15,770 --> 00:07:21,780
Si igitur velimus a XV abrepti
bit aut XV character elementum

149
00:07:21,780 --> 00:07:25,340
vel valor in hoc agmen,
prima tantum X erant.

150
00:07:25,340 --> 00:07:27,290
Si pones in utraque
character diu valorem,

151
00:07:27,290 --> 00:07:30,700
erant 'iens ut duobus
characters et tunc octo null morsus.

152
00:07:30,700 --> 00:07:34,990
Nos nunquam efficacius quam.

153
00:07:34,990 --> 00:07:37,727
>> A VARCHAR est genus sicut
At notio of a chorda

154
00:07:37,727 --> 00:07:39,560
quod sumus familiar
cum C aut PHP.

155
00:07:39,560 --> 00:07:40,830
Suus 'a longitudine varia filum.

156
00:07:40,830 --> 00:07:42,560
Et cum vos partum
Huic agmini, vos iustus

157
00:07:42,560 --> 00:07:44,860
maximum potest specificare longitudines.

158
00:07:44,860 --> 00:07:49,065
Sic maybe XCIX, aut communiter CCLV.

159
00:07:49,065 --> 00:07:50,440
Id enim maxime oblongam.

160
00:07:50,440 --> 00:07:52,890
Et eodem modo si essemus thesaurizantes
XV character nervo,

161
00:07:52,890 --> 00:07:56,157
volumus uti XV bytes, maybe XVI
bytes pro null Termino.

162
00:07:56,157 --> 00:07:57,990
Si sunt a thesaurizantes
tres character nervo,

163
00:07:57,990 --> 00:08:01,120
volumus in tribus aut quatuor bytes.

164
00:08:01,120 --> 00:08:03,050
Noluimus ergo uti plena XCIX.

165
00:08:03,050 --> 00:08:05,190
>> Cur ergo nos habere?

166
00:08:05,190 --> 00:08:08,210
Bene, ut instar sicco quam oportet
quamdiu aliquid est a VARCHAR,

167
00:08:08,210 --> 00:08:10,680
habemus ad genus iterate
Modo C. fecimus traiecerat

168
00:08:10,680 --> 00:08:12,230
et instar sicco qua subsistit.

169
00:08:12,230 --> 00:08:15,920
Si sciamus ea omnia
in hoc agmen excesserit X bytes, maybe

170
00:08:15,920 --> 00:08:19,220
Scimus notitia possumus rutrum
X bytes, X bytes, X bytes, X bytes,

171
00:08:19,220 --> 00:08:21,790
et in omni tempore invenies
incipiens de nervo.

172
00:08:21,790 --> 00:08:25,210
>> Et sic nihil prohibet aliquem
dissipasset spatium cum a CHAR,

173
00:08:25,210 --> 00:08:28,510
sed maybe illic 'a trade
off habendi melius celeritas

174
00:08:28,510 --> 00:08:30,160
in navigando in database.

175
00:08:30,160 --> 00:08:32,330
Sed maybe volumus
flexibilitatem a VARCHAR

176
00:08:32,330 --> 00:08:36,710
instead of having-- Si CHAR
CCLV erat, sed plerique nostrorum users

177
00:08:36,710 --> 00:08:40,537
sunt tantum tres pagellas vel quattuor scidit inputting bytes
notitia aut ternis aut quaternis denariis

178
00:08:40,537 --> 00:08:41,870
characters precium notitia.

179
00:08:41,870 --> 00:08:44,324
>> Surrexerunt autem quidam users uterentur
totum CCLV, maybe

180
00:08:44,324 --> 00:08:45,990
VARCHAR nulla aptior esset.

181
00:08:45,990 --> 00:08:49,840
Est quoddam artificium, et
plerumque ad fines CS50,

182
00:08:49,840 --> 00:08:54,107
non oportet multum curare de
utrum uti CHAR aut VARCHAR.

183
00:08:54,107 --> 00:08:57,190
In rerum natura ista
et quoniam ista materia columnas

184
00:08:57,190 --> 00:08:59,300
tollat ​​crucem actualis physica spatium.

185
00:08:59,300 --> 00:09:04,150
Et physica spatium, in
natura, quae ad premium.

186
00:09:04,150 --> 00:09:06,800
>> Igitur cum venisset unus alia consideratione
cum aedificant table

187
00:09:06,800 --> 00:09:09,840
esse enim unam columnam tollere
quod vocatur primum key.

188
00:09:09,840 --> 00:09:14,350
Et primo agmine amet
ubi omnia et singula unicum valorem.

189
00:09:14,350 --> 00:09:19,980
Atque id facilius possis
eligite uno intuitu iusta row

190
00:09:19,980 --> 00:09:22,450
ad primum key illius ordinis.

191
00:09:22,450 --> 00:09:24,580
Ut pro exemplo, vos
generaliter, cum users,

192
00:09:24,580 --> 00:09:27,210
nolo duo users qui
user ID idem numero.

193
00:09:27,210 --> 00:09:28,960
Et sic maybe vos habere
lots of notitia,

194
00:09:28,960 --> 00:09:30,793
et fortasse duo users potest
Habentes autem eumdem name--

195
00:09:30,793 --> 00:09:32,650
habes et Thomas Smith.

196
00:09:32,650 --> 00:09:34,520
Ut non solum quaestio
eo quod non sint plures homines

197
00:09:34,520 --> 00:09:35,830
Johannes Smith in mundo.

198
00:09:35,830 --> 00:09:40,766
Sed solum unum user ID numerum
X unus user ID numero XI, XII, XIII.

199
00:09:40,766 --> 00:09:42,640
Non enim habemus duo users
cum eiusdem numeri,

200
00:09:42,640 --> 00:09:46,010
et sic maybe user ID numero
primus key esset bonum.

201
00:09:46,010 --> 00:09:48,610
>> Neque enim ulla adjunxit,
et nunc possumus unice

202
00:09:48,610 --> 00:09:52,619
recognoscendas singulis row iustus
aspiciendo quod column.

203
00:09:52,619 --> 00:09:55,410
Eligentes primaria claves extingui posse etiam sequentis
facere sequenti mensam operationes

204
00:09:55,410 --> 00:09:59,710
ostendens quoniam potes facilisis leverage
eo quod quidam ordines volunt

205
00:09:59,710 --> 00:10:02,720
Unicum et quasi quaedam columna
vestri database seu mensa

206
00:10:02,720 --> 00:10:06,030
erit unique ad colligunt
ordines de particulari.

207
00:10:06,030 --> 00:10:08,790
>> Potes etiam primario coniuncta
key, quos poteris mecum potueris

208
00:10:08,790 --> 00:10:11,720
uti, quam sit amet
combinatione duarum columnarum quod

209
00:10:11,720 --> 00:10:13,280
praestatur unicam esse.

210
00:10:13,280 --> 00:10:16,410
Sic maybe vos habere unum
Ut id agmen bs

211
00:10:16,410 --> 00:10:19,290
agmine id est unum et duo
tribus autem diebus voltis

212
00:10:19,290 --> 00:10:23,660
A1 unum una
A2, et sic de aliis, et sic porro.

213
00:10:23,660 --> 00:10:28,980
Sed vos vires have a B2, a
C2 aut A1 A2, A3, A4.

214
00:10:28,980 --> 00:10:32,840
Ut habeamus quod multiplex multiplex
Bs, plures, multiple bina,

215
00:10:32,840 --> 00:10:38,567
sed tantum a semper
A1 uno, B2, C3, et sic deinceps.

216
00:10:38,567 --> 00:10:40,400
Itaque, ut dixi, a SQL
programming lingua,

217
00:10:40,400 --> 00:10:42,024
sed tamen satis limitatur loquantur.

218
00:10:42,024 --> 00:10:44,880
Suus 'non satis ut sicut expansivum
C et PHP et aliis linguis

219
00:10:44,880 --> 00:10:46,350
dicimus quod in cursu.

220
00:10:46,350 --> 00:10:49,960
Beatius est magis verbose
linguam quam sumus

221
00:10:49,960 --> 00:10:52,789
iens loqui de in hoc
video, quia in hoc video

222
00:10:52,789 --> 00:10:54,830
nos erant 'iens loqui de
quatuor operationes animae, quae nos

223
00:10:54,830 --> 00:10:55,720
potest in mensam.

224
00:10:55,720 --> 00:10:56,761
>> Sunt plura.

225
00:10:56,761 --> 00:10:58,730
Possumus hoc plus,
sed ad propositum,

226
00:10:58,730 --> 00:11:02,250
erant 'iens uti plerumque
sicut quatuor operations-- insert,

227
00:11:02,250 --> 00:11:05,360
lego, update, et delete.

228
00:11:05,360 --> 00:11:08,750
Et vos potest probabiliter suspicari intuitive
Haec quattuor, quae faciunt.

229
00:11:08,750 --> 00:11:12,520
Sed paulo ingredi
of detail supra singulos.

230
00:11:12,520 --> 00:11:15,780
>> Ita ad fines huius
video, lets assumere

231
00:11:15,780 --> 00:11:18,870
sumus duo
tabulas in uno database.

232
00:11:18,870 --> 00:11:23,460
Habemus a mensa dicitur quod habet Users
quattuor columns-- ID numerus, username,

233
00:11:23,460 --> 00:11:25,350
password, et plena nomen.

234
00:11:25,350 --> 00:11:27,430
Et habemus a secunda
mensam in eodem database

235
00:11:27,430 --> 00:11:32,129
Moms dicitur quod sicut notitia recondit
de usoris parente colebant.

236
00:11:32,129 --> 00:11:33,920
In hunc modum cuncti exemplorum
in hoc video, nos tibi placet

237
00:11:33,920 --> 00:11:37,945
et continuo adhibebitis database
subsequent updates ei.

238
00:11:37,945 --> 00:11:40,070
Itaque vis dicimus
add notitia ad mensam.

239
00:11:40,070 --> 00:11:44,460
Qui est scriptor quid insert operatio facit.

240
00:11:44,460 --> 00:11:46,550
In explicandis omnes
haec ait Dominus exercituum, Im 'iens

241
00:11:46,550 --> 00:11:48,860
uti tibi communis ossa.

242
00:11:48,860 --> 00:11:51,661
Quia basically, in queries
geruntur vultus pulchellus simile,

243
00:11:51,661 --> 00:11:54,660
erant 'iustus iens ut muteris
leviter diversis frusta of notitia

244
00:11:54,660 --> 00:11:56,750
ad mensam diversa.

245
00:11:56,750 --> 00:11:59,200
>> Sic enim ADINDO, osseus
genus spectat sicut est hodie.

246
00:11:59,200 --> 00:12:02,230
Volumus inseres
peculiari mensam.

247
00:12:02,230 --> 00:12:05,290
Deinde habemus apertam parenthesis
et a album of columns

248
00:12:05,290 --> 00:12:08,070
quod volumus imbuendas.

249
00:12:08,070 --> 00:12:10,974
Close parentheses, in
sequentes valores, et tunc

250
00:12:10,974 --> 00:12:13,390
etiam libet valores
volumus in mensa.

251
00:12:13,390 --> 00:12:15,950
>> Et huius exemplum
poterit esse talis.

252
00:12:15,950 --> 00:12:19,170
Volo inseres table
users sequentibus columns--

253
00:12:19,170 --> 00:12:21,010
username, password, et fullname.

254
00:12:21,010 --> 00:12:25,282
Ita novum row ubi Im posito
columnae erant in

255
00:12:25,282 --> 00:12:30,030
iens ut posuit in valoribus
Newman, USMAIL et Newman.

256
00:12:30,030 --> 00:12:32,730
Ac per hoc non sum
posito lowercase newman

257
00:12:32,730 --> 00:12:38,710
in nomen usoris agmen, ignoro
USMAIL, et plena nomen capitis N

258
00:12:38,710 --> 00:12:41,940
Newman in fullname column.

259
00:12:41,940 --> 00:12:44,240
>> Ita hic 'quod database
quasi ante.

260
00:12:44,240 --> 00:12:48,250
Lorem users mensam quid in
top quasi ante nos hoc.

261
00:12:48,250 --> 00:12:50,760
Recto cursu venimus hoc facere
query, nos adepto hoc.

262
00:12:50,760 --> 00:12:54,790
Diximus addidit novum ordinem ad mensam.

263
00:12:54,790 --> 00:12:56,810
Illud tamen animadvertite unum
quia non dat speciem,

264
00:12:56,810 --> 00:12:59,880
atqui putate pretium teneo
Nam hoc quod est praesens XII.

265
00:12:59,880 --> 00:13:02,820
Non dico volui
put in ID numerus ibi.

266
00:13:02,820 --> 00:13:04,900
Et cogitabant interficere username,
password, fullname.

267
00:13:04,900 --> 00:13:06,440
Et ille, Bene.

268
00:13:06,440 --> 00:13:07,760
>> Sed hanc quoque XII.

269
00:13:07,760 --> 00:13:09,490
XII Quare hoc?

270
00:13:09,490 --> 00:13:12,904
Bene, evenit quod
cum diffinire

271
00:13:12,904 --> 00:13:15,570
columnae modo uestris futuris
primus key, quae solet,

272
00:13:15,570 --> 00:13:16,510
sicut diximus, ID numerus.

273
00:13:16,510 --> 00:13:18,718
Suus 'non semper necessario
iens futurus ID numerum

274
00:13:18,718 --> 00:13:22,380
sed solet utilem
Numerus aliqua valorem.

275
00:13:22,380 --> 00:13:25,950
Optare in phpMyAdmin
cum vestri 'creando vestri database

276
00:13:25,950 --> 00:13:31,130
vel quod in mensa tua occurrerunt enim separare
uenienti agmini incrementing auto.

277
00:13:31,130 --> 00:13:34,520
>> Quod cum admodum utilem
ad principale opus es clavibus

278
00:13:34,520 --> 00:13:39,330
quia vis omnis value
Unicum in agmen.

279
00:13:39,330 --> 00:13:43,310
Et si vos obliviscamini ad specificare
ad plures,

280
00:13:43,310 --> 00:13:46,240
tu nunc habes, ubi
columna una non est.

281
00:13:46,240 --> 00:13:50,200
Habes utrumque codicellos ita nihil
longer unice identify a column--

282
00:13:50,200 --> 00:13:54,150
aut salutis potes ultra conferre unice
identify a row substructio in quod column.

283
00:13:54,150 --> 00:13:57,010
Suus 'periit omni supellectili sua
tamquam primario key valorem.

284
00:13:57,010 --> 00:14:02,010
>> Ergo videtur quod egi
hic configuratur usoris ID

285
00:14:02,010 --> 00:14:07,790
to auto column incrementum ut omne
Additum uero temporis notitia mensae

286
00:14:07,790 --> 00:14:12,220
is mos automatically da mihi
primaria key valorem.

287
00:14:12,220 --> 00:14:15,570
Quia nunquam potest sic oblivisci
fac me datorum.

288
00:14:15,570 --> 00:14:16,587
Quod genus nice.

289
00:14:16,587 --> 00:14:18,670
Et ideo fit
XII ibi enim sum

290
00:14:18,670 --> 00:14:21,772
set quod agmen erexere ad auto incrementum.

291
00:14:21,772 --> 00:14:23,730
Si additur aliquid aliud
XIII pergratum erit, si adiectum

292
00:14:23,730 --> 00:14:27,890
non alienum fore XIV, et sic de aliis.

293
00:14:27,890 --> 00:14:30,190
>> Sic lets iustus quisquam immittere.

294
00:14:30,190 --> 00:14:34,530
Puteus inseres moms super mensam meam in
Nominatim vero tum Ecclesia username et matrem

295
00:14:34,530 --> 00:14:37,390
column tacile determinabuntur illi valores
kramer et Babs Kramer.

296
00:14:37,390 --> 00:14:39,140
Itaque prius habuimus.

297
00:14:39,140 --> 00:14:41,800
Post exequimur quod
SQL interrogatione accepimus.

298
00:14:41,800 --> 00:14:47,290
Weve 'added Kramer et Babs
Kramer moms ad mensam.

299
00:14:47,290 --> 00:14:48,350
>> Ita ut 'inserentes.

300
00:14:48,350 --> 00:14:51,850
LEGO est quod utimur ut extraho
notitia de mensa.

301
00:14:51,850 --> 00:14:54,390
Et hoc est quomodo nos adepto
notitia de database.

302
00:14:54,390 --> 00:14:59,589
Et mandata SELECT futura sunt
persaepe usus est in programming.

303
00:14:59,589 --> 00:15:02,130
Eos Aequorum imperator in framework--
general osseus spectat sicut est hodie.

304
00:15:02,130 --> 00:15:06,550
Select a paro of columnas
diligenter exara illud, et tunc optionally

305
00:15:06,550 --> 00:15:11,090
vos can proprius vel a condition--
quod typice vocate praedicatum,

306
00:15:11,090 --> 00:15:13,010
SQL utimur nomine solet.

307
00:15:13,010 --> 00:15:16,490
>> Tamen suus 'basically quid
particulares ordines uis.

308
00:15:16,490 --> 00:15:19,100
Si vis, pro questus
omnia arta eam,

309
00:15:19,100 --> 00:15:20,060
est ubicumque tibi facere.

310
00:15:20,060 --> 00:15:22,777
Deinde ad libitum: vos can quoque
ordinem particularis column.

311
00:15:22,777 --> 00:15:25,860
Sic maybe vos volo ut habere sorted
alphabetically fundantur super uno agmine

312
00:15:25,860 --> 00:15:27,540
aut alphabetically fundatur in alio.

313
00:15:27,540 --> 00:15:30,610
>> Item ubi et ordine per indifferentibus.

314
00:15:30,610 --> 00:15:32,681
Sed youll 'forsit esse
praesertim useful--

315
00:15:32,681 --> 00:15:34,680
Ubi erit utilis
graciliorem non ita et vos faciatis

316
00:15:34,680 --> 00:15:37,460
adepto vestri universus database et
ad aliquid, vos iustus adepto

317
00:15:37,460 --> 00:15:39,300
niam ea fragmenta.

318
00:15:39,300 --> 00:15:44,932
Ita ut ego volo eligere
ID numero et ex fullname users.

319
00:15:44,932 --> 00:15:46,140
Et quid hoc vultus amo?

320
00:15:46,140 --> 00:15:48,270
Hic users mensam meam.

321
00:15:48,270 --> 00:15:51,080
Volo desumo idnum
et FullName ex users.

322
00:15:51,080 --> 00:15:52,300
Ut et ego quo ibo?

323
00:15:52,300 --> 00:15:53,580
Ego rem hanc.

324
00:15:53,580 --> 00:15:56,930
Non est angustum, ita me
questus ID numerus enim omnis row

325
00:15:56,930 --> 00:16:00,850
et Im 'questus plena
nomen ab omni ordine.

326
00:16:00,850 --> 00:16:02,210
>> OK.

327
00:16:02,210 --> 00:16:05,640
Quod si velis eligere tesserae
de users WHERE-- ita nunc

328
00:16:05,640 --> 00:16:10,370
Im 'addita condicione, a predicate--
ubi idnum est minus quam XII.

329
00:16:10,370 --> 00:16:13,660
Hic meus database iterum
users mensam meam in vertice.

330
00:16:13,660 --> 00:16:17,030
Si volo ut et ego quo ibo
lego ut informacione tesserae

331
00:16:17,030 --> 00:16:21,550
ubi user ID idnum vel minus quam XII?

332
00:16:21,550 --> 00:16:24,910
Im 'iens ut hoc
notitia retro, a dextris?

333
00:16:24,910 --> 00:16:29,170
Contingit idnum est X, minus
quam XII, XI ID numerus minus quam XII.

334
00:16:29,170 --> 00:16:32,160
Im 'questus ignoro illos ordines.

335
00:16:32,160 --> 00:16:33,914
Id peterem.

336
00:16:33,914 --> 00:16:34,580
Quid igitur?

337
00:16:34,580 --> 00:16:39,170
Quod si velis eligere stella
moms mensam ubi pares username Jerry?

338
00:16:39,170 --> 00:16:43,780
OK, selectis stella est speciale
dicuntur ferae genus card

339
00:16:43,780 --> 00:16:45,670
ut omnia, quibus utimur.

340
00:16:45,670 --> 00:16:48,620
Ita ipsi erant 'dicens selectis
username comma matrem tuam, quod

341
00:16:48,620 --> 00:16:51,060
Accidit quoque ut solus
duo hostium agmina hanc monstrabunt mensam,

342
00:16:51,060 --> 00:16:53,260
EGO can iustus lego stella
et omnia

343
00:16:53,260 --> 00:16:55,030
ubi pares username Jerry.

344
00:16:55,030 --> 00:16:59,380
Itaque id quod daret
quod si hoc quaero.

345
00:16:59,380 --> 00:17:01,810
>> Nunc databases sunt
magna quia sino

346
00:17:01,810 --> 00:17:06,074
nos ad organize notitia fortasse
aliquantulus magis efficenter quam nos

347
00:17:06,074 --> 00:17:06,740
ut aliter.

348
00:17:06,740 --> 00:17:10,240
Nos dont 'necesse congregem
relevant omnis piece of notitia

349
00:17:10,240 --> 00:17:12,230
circa eandem mensam in ludo.

350
00:17:12,230 --> 00:17:13,730
Habuimus duas tabulas ibi.

351
00:17:13,730 --> 00:17:15,734
>> Nos postulo ut congregem
omnium: nomen matris ejus,

352
00:17:15,734 --> 00:17:18,900
et fortasse non habent securitati sociali
numero tenentur die nativitatis.

353
00:17:18,900 --> 00:17:21,819
Quod non oportet quod semper
in eadem mensa.

354
00:17:21,819 --> 00:17:25,339
Quamdiu possumus definire
necessitudines inter tables--

355
00:17:25,339 --> 00:17:28,440
et ut 'ubi obviat relationis
database term genus venit

356
00:17:28,440 --> 00:17:32,130
in play-- quamdiu possumus definire
necessitudines inter mensas,

357
00:17:32,130 --> 00:17:35,545
possumus sort of compartmentalize
vel res abstractae a via,

358
00:17:35,545 --> 00:17:37,670
ubi tantum
vere maximus notitia

359
00:17:37,670 --> 00:17:39,270
volumus in user mensam.

360
00:17:39,270 --> 00:17:43,220
Et tunc habemus ancillis notitia
susicivus notitia vel in alias mensas

361
00:17:43,220 --> 00:17:48,260
ad summam coniungere possumus
users mensam modo peculiari peraguntur.

362
00:17:48,260 --> 00:17:52,200
>> Hic habemus binis tabulis, sed
ibi est inter eos

363
00:17:52,200 --> 00:17:53,010
ius?

364
00:17:53,010 --> 00:17:55,070
Videtur quasi username
ut esse aliquid

365
00:17:55,070 --> 00:17:59,909
quod est in communi sita sunt
his duabus diversis tabulis.

366
00:17:59,909 --> 00:18:01,700
Quid enim si quam nunc habemus
a situ ubi demorati sumus

367
00:18:01,700 --> 00:18:06,046
uis a user plena ab
usoris mensam matris

368
00:18:06,046 --> 00:18:07,170
nominare ex matre mensa?

369
00:18:07,170 --> 00:18:10,960
Non habemus via impetro
stat quod iustum

370
00:18:10,960 --> 00:18:17,790
Nulla mensa una continet
utrumque plenum nomen et nomen matris eius.

371
00:18:17,790 --> 00:18:20,400
We do not have quod option
patet ex his quae hactenus vidi.

372
00:18:20,400 --> 00:18:22,950
>> Et quantum ad hoc inducere
idea JOIN.

373
00:18:22,950 --> 00:18:24,857
Elevans et jungens es forsit
maxime complex--

374
00:18:24,857 --> 00:18:27,940
suus 'vere maxime complexu operatio
erant 'iens loqui de video.

375
00:18:27,940 --> 00:18:30,040
Haerent parum complicatas,
tamen quondam vos impetro pendent ex ea,

376
00:18:30,040 --> 00:18:31,248
profecto non es nimis.

377
00:18:31,248 --> 00:18:32,820
Suus 'iustus a casu Virgil.

378
00:18:32,820 --> 00:18:37,120
Sumamus eligere statuto
columnas mensam jungens

379
00:18:37,120 --> 00:18:40,650
in secunda mensa enim stabit in aliquod praedicatum.

380
00:18:40,650 --> 00:18:45,340
>> Ita cogitare velim Teraho
ergo recumbens unus est hic circulus,

381
00:18:45,340 --> 00:18:47,530
mensam duo est alius circulus super hic.

382
00:18:47,530 --> 00:18:49,410
Et quod ex parte praedicati
in medio, suus '

383
00:18:49,410 --> 00:18:51,701
sort of sicut si putas
tamquam Venn diagram quod

384
00:18:51,701 --> 00:18:52,670
habent in communi?

385
00:18:52,670 --> 00:18:55,960
Volumus pagina hae duae tabulae
secundum quod sunt communia

386
00:18:55,960 --> 00:19:01,230
et creans hypothetica table
eive qui utriusque.

387
00:19:01,230 --> 00:19:03,480
Et certe hoc in
exemplum et maybe quod youll auxilium

388
00:19:03,480 --> 00:19:04,521
illud parum constat.

389
00:19:04,521 --> 00:19:09,260
Sic maybe vos volo desumo
user.fullname et moms.mother

390
00:19:09,260 --> 00:19:13,220
ex users in conjunctione
moms mensam in omnibus vitae condicionibus destinentur

391
00:19:13,220 --> 00:19:16,790
ubi username column
quæ est inter eos.

392
00:19:16,790 --> 00:19:19,240
Et hoc est a novo
syntax hic, hoc user.

393
00:19:19,240 --> 00:19:20,460
et moms ..

394
00:19:20,460 --> 00:19:26,697
Si ego facio multiple tabulas
simul discumbentibus speciem possum.

395
00:19:26,697 --> 00:19:29,530
Possum distinguere in particulari in
quod in fundo est.

396
00:19:29,530 --> 00:19:33,220
Possum distinguere litteras maiusculas
columna users mensam

397
00:19:33,220 --> 00:19:36,010
ex username columna
moms mensa, quae sunt otherwise--

398
00:19:36,010 --> 00:19:38,070
si dictum username pares
username, quod non vere

399
00:19:38,070 --> 00:19:38,970
dico aliquid.

400
00:19:38,970 --> 00:19:41,440
Ubi volumus facere par.

401
00:19:41,440 --> 00:19:46,080
>> Dat speciem et mensa et propositio
nominis causa res column

402
00:19:46,080 --> 00:19:48,370
ubi esset obscurum,
quod Im 'sermo super.

403
00:19:48,370 --> 00:19:51,880
Tota itaque facio me est
Haec columnam mensa illa

404
00:19:51,880 --> 00:19:54,020
et valde explicit.

405
00:19:54,020 --> 00:19:56,810
Sic ego seligendis
plenum nomen et nomen matris

406
00:19:56,810 --> 00:20:00,950
de users mensam connexa
mensam cum moms in omnibus vitae condicionibus destinentur

407
00:20:00,950 --> 00:20:05,960
ubi huius column--
username quod participant rationem.

408
00:20:05,960 --> 00:20:08,580
>> Ita hic habuimus ante mensae.

409
00:20:08,580 --> 00:20:12,210
Haec est fortunae nostrae statum locuti
prout database elit.

410
00:20:12,210 --> 00:20:16,390
Notitia sumus extrahendis
hoc cum committitur.

411
00:20:16,390 --> 00:20:19,820
Hoc novo schemate iens
creare combining nobis objicit simul.

412
00:20:19,820 --> 00:20:23,585
Et nota non sumus highlighting
Newman user scriptor in ordine mensae

413
00:20:23,585 --> 00:20:25,960
Exerciti sumus et non quatenus
Kramer scriptor row in mensa moms

414
00:20:25,960 --> 00:20:31,250
quia nec unus est in
utrumque sets-- in utraque tabula.

415
00:20:31,250 --> 00:20:36,260
>> Sed notitia communia
inter eos in utraque tabula Jerry

416
00:20:36,260 --> 00:20:39,100
et gcostanza est in utraque tabula.

417
00:20:39,100 --> 00:20:42,620
Quando facere SQL JOIN quid
get-- et vere adepto hoc facimus.

418
00:20:42,620 --> 00:20:44,830
Suus 'genus of a temporaria variabilis.

419
00:20:44,830 --> 00:20:47,330
Suus 'quasi hypotheticae
merger duorum tabulis.

420
00:20:47,330 --> 00:20:49,930
Nos vere adepto aliquid
sicut hoc, ubi

421
00:20:49,930 --> 00:20:54,730
weve 'simul immersa in tabulis
cognitum habere communia.

422
00:20:54,730 --> 00:20:58,334
>> Sic animadverto ut users.username
et moms.username column,

423
00:20:58,334 --> 00:20:59,250
suus 'exigo idem eadem idem.

424
00:20:59,250 --> 00:21:01,820
Quod indicium erat quod
consentaneum ab utentibus

425
00:21:01,820 --> 00:21:02,890
mensamque et moms mensam.

426
00:21:02,890 --> 00:21:04,270
Itaque corporali immersa eos.

427
00:21:04,270 --> 00:21:06,919
Nos depellitur Kramer quia
non esset in users mensam

428
00:21:06,919 --> 00:21:09,710
et abdicavit Newman, quia
non sunt in tabula moms.

429
00:21:09,710 --> 00:21:16,450
Existimo ergo hoc bonum hypotheticae merger
usura JOIN operatio LEGO.

430
00:21:16,450 --> 00:21:21,250
>> Deinde expectabant
nomen usoris plena utentis matrem

431
00:21:21,250 --> 00:21:24,999
et nuntiatum est
Discamus ex altiore quaero

432
00:21:24,999 --> 00:21:26,040
quod pepigit cum LEGO.

433
00:21:26,040 --> 00:21:28,873
Ita iunximus mensas simul
et expressa ista columnas

434
00:21:28,873 --> 00:21:31,610
ita ut id quod volumus.

435
00:21:31,610 --> 00:21:33,370
Sed SQL iungit quoddam voluptua.

436
00:21:33,370 --> 00:21:36,770
Nimium fortasse vos non feceritis,
sed aliqua idea sceletum

437
00:21:36,770 --> 00:21:41,992
ut posset iungi utrumque
simul tabulæ si necessarius.

438
00:21:41,992 --> 00:21:43,700
Aliae vero duae ultimae sunt a
aliquantulus simplicior promitto.

439
00:21:43,700 --> 00:21:48,040
Sic adaequationis, possumus uti UPDATE
mutare notitia in mensa.

440
00:21:48,040 --> 00:21:53,880
Eos Aequorum imperator format aliqua est UPDATE
mensam SET quidam column ad modicum utilis

441
00:21:53,880 --> 00:21:55,540
UBI aliquod praedicatum ipsius saturabunt eum.

442
00:21:55,540 --> 00:21:57,850
Ut puta si vellet
ut update users mensam

443
00:21:57,850 --> 00:22:04,400
et posuit signum ad yada
yada ubi X ID numerus.

444
00:22:04,400 --> 00:22:06,400
>> Ita hic sumus
adaequationis ad users mensam.

445
00:22:06,400 --> 00:22:08,275
In ID numerus X pro
quod primo versu,

446
00:22:08,275 --> 00:22:10,690
et volumus ut update
password ad yada yada.

447
00:22:10,690 --> 00:22:12,170
Et ut quid esset futurum.

448
00:22:12,170 --> 00:22:13,628
Suus 'pulchellus simplex iudicium

449
00:22:13,628 --> 00:22:17,990
Suus 'iustus a valde simplex
modificatio ad mensam.

450
00:22:17,990 --> 00:22:22,250
>> Est usus operatione DELETE
aufero notitia ex a mensa.

451
00:22:22,250 --> 00:22:24,817
DELETE FROM mensam WHERE
aliquod praedicatum ipsius saturabunt eum.

452
00:22:24,817 --> 00:22:26,900
Nos volo ut delete ex
users mensam exemplum

453
00:22:26,900 --> 00:22:28,254
ubi est username Newman.

454
00:22:28,254 --> 00:22:31,420
Probabiliter suspicari potes futurum
hic aguntur post exequimur quod SQL

455
00:22:31,420 --> 00:22:35,790
interrogatione Newman exierit de mensa.

456
00:22:35,790 --> 00:22:40,460
>> Et haec omnia, ut dixi,
valde securus efficio in phpMyAdmin.

457
00:22:40,460 --> 00:22:43,020
Est valde user familiaris interface.

458
00:22:43,020 --> 00:22:45,930
Sed opus manuum labore.

459
00:22:45,930 --> 00:22:47,840
Nolumus manibus uti conatur.

460
00:22:47,840 --> 00:22:51,280
Optamus progressio
hoc nobis iudicium

461
00:22:51,280 --> 00:22:53,190
Ut simus initium volo efficio
hoc programmatically.

462
00:22:53,190 --> 00:22:56,410
Volumus et incorporate SQL
aliud facere nobis.

463
00:22:56,410 --> 00:23:02,710
>> Quod vidimus admittit
nos programmatically facere aliquid?

464
00:23:02,710 --> 00:23:03,690
Vidimus PHP iudicium

465
00:23:03,690 --> 00:23:05,760
Inducit aliquam
dynamicam mentibus nostris progressio.

466
00:23:05,760 --> 00:23:10,430
Et feliciter, et SQL
PHP ludere simul nicely.

467
00:23:10,430 --> 00:23:13,230
Illic ', munus in PHP
vocavit query, quod can exsisto adsuesco assuesco.

468
00:23:13,230 --> 00:23:15,870
Et cum volueritis potestis Factumque est secundum sermonem
aut parameter argumentum

469
00:23:15,870 --> 00:23:19,210
ad query a SQL query quod
vos would amo ad sumendum supplicium.

470
00:23:19,210 --> 00:23:23,250
PHP et faciam in vobis.

471
00:23:23,250 --> 00:23:25,564
>> Ita post youve coniunctum
to your database cum PHP,

472
00:23:25,564 --> 00:23:26,980
ibi duo prima feceris.

473
00:23:26,980 --> 00:23:29,230
Illic 'aliquid vocavit MySQLi
et descendens vas quoddam vocatur PDO.

474
00:23:29,230 --> 00:23:31,063
Non ibimus in ingentem
amount ibi.

475
00:23:31,063 --> 00:23:32,957
In CS50 utimur PDO.

476
00:23:32,957 --> 00:23:34,790
Post youve coniunctum
to your database, vobis

477
00:23:34,790 --> 00:23:40,980
potest ergo quaero vestri database
transeundo ad queries non argumentabor

478
00:23:40,980 --> 00:23:42,730
ad PHP functiones.

479
00:23:42,730 --> 00:23:46,460
Cum feceris tibi copia
result posuit in an consuetudinis array.

480
00:23:46,460 --> 00:23:50,290
>> Et cum scirent fabre operari
in PHP vestit associative.

481
00:23:50,290 --> 00:23:52,630
Ita ut inde aliquid dicere satagamus
sicut Teraho $ results--

482
00:23:52,630 --> 00:23:55,470
hoc est in PHP-- pares denuo.

483
00:23:55,470 --> 00:23:57,660
Et tunc intus est
query functio, ut argumentum

484
00:23:57,660 --> 00:24:00,130
quod Im 'non transeat query
SQL ut vultus amo.

485
00:24:00,130 --> 00:24:01,160
Denique quod SQL.

486
00:24:01,160 --> 00:24:05,700
Id velim filo quaero
ut faciant in me datorum.

487
00:24:05,700 --> 00:24:09,250
>> Red Itaque hoc PHP.

488
00:24:09,250 --> 00:24:11,890
Hoc est SQL ut Im '
integrandi in PHP faciendo

489
00:24:11,890 --> 00:24:15,020
illud argumentum ad query functio.

490
00:24:15,020 --> 00:24:19,640
Volo desumo a fullname
ubi users ID numero X pares.

491
00:24:19,640 --> 00:24:22,560
Et fortasse hoc feci,
Possem dicere aliquid simile.

492
00:24:22,560 --> 00:24:25,550
Volo ut procer sicco
Gratias agens pro nuntio logging in.

493
00:24:25,550 --> 00:24:32,530
>> Et volo volo interpolate--
interponere $ fullname results.

494
00:24:32,530 --> 00:24:36,280
Sic quam operor illud
consuetudinis array quod recepit.

495
00:24:36,280 --> 00:24:39,730
$ Results fullname noluit
basically terminus sursum excudendi, ex,

496
00:24:39,730 --> 00:24:42,870
gratias logging in, Jerry Seinfeld.

497
00:24:42,870 --> 00:24:46,570
Quod erat plenum nomen
ubi idnum X pares.

498
00:24:46,570 --> 00:24:48,850
>> Et sic omnis facio
is ego sum now-- recondita

499
00:24:48,850 --> 00:24:52,780
mea interrogatione mea quaero praecessi
et facit ut an consuetudinis array

500
00:24:52,780 --> 00:24:56,330
fullname et vocatum est nomen eius
acquiritis agmen erat.

501
00:24:56,330 --> 00:25:01,010
Ut in nulla amet mea
consuetudinis array quod volo.

502
00:25:01,010 --> 00:25:05,930
Gratias igitur colligationem in $ results
fullname et procer sicco, haerebunt

503
00:25:05,930 --> 00:25:08,654
placitum inter illos crispus
capreolis collocatae, lateribus Jerry Seinfeld.

504
00:25:08,654 --> 00:25:11,820
Et placebit imprimendi verbi
Gratias logging in Jerry Seinfeld.

505
00:25:11,820 --> 00:25:16,652
>> Nos autem non vis dura probabiliter
signum quod talia in iudicium?

506
00:25:16,652 --> 00:25:19,860
Nos vis facere aliquid simile print
f ubi forte substituere

507
00:25:19,860 --> 00:25:22,443
diversa colligere notitia,
vel maybe habere query processus

508
00:25:22,443 --> 00:25:23,370
diversis notitia.

509
00:25:23,370 --> 00:25:27,920
Itaque quaero, in query functio habet
haec notio modi substitutiones

510
00:25:27,920 --> 00:25:32,310
simillima s print f percent
c et sentio, et variae.

511
00:25:32,310 --> 00:25:34,290
>> Et possumus uti question
marcas ipsa analogice

512
00:25:34,290 --> 00:25:38,400
ut procer f ad substitutum variabilium.

513
00:25:38,400 --> 00:25:44,120
Sic maybe vestri user logged in superius,
user ID numero et liberasti eos

514
00:25:44,120 --> 00:25:51,710
in $ _SESSION of PHP eximius
in global clavem ID.

515
00:25:51,710 --> 00:25:55,947
Et fortasse non apertum,
quem calcaverit vestigium $ ID _SESSION X pares,

516
00:25:55,947 --> 00:25:58,280
extrapolating ab exemplo
nos iustus vidit a secunda ago.

517
00:25:58,280 --> 00:26:01,960
>> Et ita cum actu exequi
hoc nunc query consequitur,

518
00:26:01,960 --> 00:26:08,440
esset plug in X vel aliud
ad $ _SESSION ID valorem.

519
00:26:08,440 --> 00:26:10,790
Et sic quod permittit nos
esse aliquantulus magis strenuus.

520
00:26:10,790 --> 00:26:12,699
Non sumus dura coding in anymore.

521
00:26:12,699 --> 00:26:14,490
Sumamus nisi notitia
et alicubi

522
00:26:14,490 --> 00:26:18,924
possumus uti ad informationes
genus generaliter quod nolo illud facio

523
00:26:18,924 --> 00:26:21,090
atque in obturaculum mutatio
moribus nostris page

524
00:26:21,090 --> 00:26:26,489
fundata usoris ID numerum
versatur post auditionem apertum.

525
00:26:26,489 --> 00:26:28,530
Est etiam, quamquam
set ut results

526
00:26:28,530 --> 00:26:30,840
magis posset consistere multiplex ordines.

527
00:26:30,840 --> 00:26:33,990
In quo casu, habes
an array of arrays--

528
00:26:33,990 --> 00:26:35,334
an array of consuetudinis vestit.

529
00:26:35,334 --> 00:26:37,000
Vos iustus postulo ut repetere eam.

530
00:26:37,000 --> 00:26:41,950
Et scimus quam iterate
per an array in PHP, ius?

531
00:26:41,950 --> 00:26:45,600
Sic hic est forsit plurrimi
quatenus aliquid complexum vidimus.

532
00:26:45,600 --> 00:26:49,640
Illud actu integrates
trium linguarum peritus simul.

533
00:26:49,640 --> 00:26:52,920
>> Hic rubeis hic aliqua HTML.

534
00:26:52,920 --> 00:26:56,872
Im 'hoc est apparenter starting--
aliquam a snippet HTML mea.

535
00:26:56,872 --> 00:26:59,580
Im 'satus novum caput illius
dicit moms de TV scriptor Seinfeld.

536
00:26:59,580 --> 00:27:02,350
Et statim postea
Im 'satus a mensa.

537
00:27:02,350 --> 00:27:06,060
Deinde post haec
aliqua PHP, ius?

538
00:27:06,060 --> 00:27:08,229
Habeo autem omnia in PHP codice.

539
00:27:08,229 --> 00:27:09,645
Im 'iens ut videtur facere aliquid querit.

540
00:27:09,645 --> 00:27:14,180
Et ut interrogatione: Ego
usura SELECT matres FROM moms.

541
00:27:14,180 --> 00:27:15,970
>> Ita hoc getting-- SQL hoc est.

542
00:27:15,970 --> 00:27:17,300
Ita caeruleum est SQL.

543
00:27:17,300 --> 00:27:19,680
Rubrum praeceptor vidimus quendam secunda ago erat HTML.

544
00:27:19,680 --> 00:27:21,360
Et virens est PHP.

545
00:27:21,360 --> 00:27:23,400
Ita Im faciens a query
meo database, Im '

546
00:27:23,400 --> 00:27:26,040
eligendo omnibus
matres moms in mensa.

547
00:27:26,040 --> 00:27:30,710
Non iustus eam angustans particularibus
ordo postulat sum omnia.

548
00:27:30,710 --> 00:27:33,290
>> Tunc reprehendo si fit
non pares pares esse falsum.

549
00:27:33,290 --> 00:27:37,410
Hoc tantum modo uerecundia legum restinguenda
aut si nullus eventus aequalis,

550
00:27:37,410 --> 00:27:40,260
ut videre est c.

551
00:27:40,260 --> 00:27:44,000
Basically iustus reprehendo hoc facere
certus quod actu got data retro.

552
00:27:44,000 --> 00:27:47,041
Quia nolo ut satus printing
ex data si non adepto ullus data.

553
00:27:47,041 --> 00:27:50,690
Tunc enim resultat Hinc
foreach syntax ex PHP, omnia facio

554
00:27:50,690 --> 00:27:53,399
est excudendi, ex $ result matres.

555
00:27:53,399 --> 00:27:55,940
Ita Im 'iens impetro set
omnium matres each--

556
00:27:55,940 --> 00:27:59,980
suus 'an array of associative
arrays-- et Im excudendi, ex

557
00:27:59,980 --> 00:28:03,649
ut sua cuique mensa ordinis.

558
00:28:03,649 --> 00:28:05,690
Et quod suus pulchellus
quantum ad omnes est.

559
00:28:05,690 --> 00:28:07,750
Scio illic 'a parum
bit hic geritur

560
00:28:07,750 --> 00:28:13,210
in hoc exemplum ex vestit
arrays-- vestit de vestit associative.

561
00:28:13,210 --> 00:28:17,340
Sed revera iustus arderent igni
descendit in SQL query ad aliquid,

562
00:28:17,340 --> 00:28:21,102
solet discriptis post youve 'iam
posuit notitia in mensa,

563
00:28:21,102 --> 00:28:22,310
et iustus scidit eas.

564
00:28:22,310 --> 00:28:25,710
>> Et hoc volumus convellendum
in hoc casu.

565
00:28:25,710 --> 00:28:31,120
Volumus singulis extrahe omnem
maternam a mensa moms.

566
00:28:31,120 --> 00:28:35,970
Totius Materiae Venimus et nos
nolo repetere atque imprimere

567
00:28:35,970 --> 00:28:37,630
unusquisque.

568
00:28:37,630 --> 00:28:40,510
Et iterum, hoc est forsit
maxime exemplum complicated

569
00:28:40,510 --> 00:28:44,510
vidimus enim tribus misces
ut puta genera linguarum sunt, ius?

570
00:28:44,510 --> 00:28:50,100
>> Praeterea, sicut hic HTML rubeis
mixta cum SQL hic ex hyacintho,

571
00:28:50,100 --> 00:28:52,049
aliqua PHP viridi mixtus.

572
00:28:52,049 --> 00:28:53,840
Sed horum omnium ludere
simul nicely, suus '

573
00:28:53,840 --> 00:28:57,060
iustus a res of developing
ut bonis moribus licebit

574
00:28:57,060 --> 00:28:58,780
cooperantur ad viam vis.

575
00:28:58,780 --> 00:29:03,790
Et revera hoc modo
exercent, usu, usu.

576
00:29:03,790 --> 00:29:06,740
Lloyd doug sum hoc CS50.

577
00:29:06,740 --> 00:29:08,647