1
00:00:00,000 --> 00:00:02,000
[Powered by Google Translate] [Week VIII, Permansit]

2
00:00:02,000 --> 00:00:04,000
[David J. Malan] [Harvard University]

3
00:00:04,000 --> 00:00:08,000
[Hoc est CS50.] [CS50.TV]

4
00:00:08,000 --> 00:00:13,000
>> Hoc est CS50, sic hoc, est finis Week VIII hic.

5
00:00:13,000 --> 00:00:16,000
Atqui nos aliquid ante hujus hebdomadis tempestate,

6
00:00:16,000 --> 00:00:19,000
et ita plane ut in isto nunc schola aula

7
00:00:19,000 --> 00:00:22,000
sed hodie pergimus sermones PHP

8
00:00:22,000 --> 00:00:25,000
et circa telam programming magis generaliter, et etiam nos introducere idea

9
00:00:25,000 --> 00:00:29,000
de databases, praesertim unum vocatur MySQL, quod est satis popularis his diebus,

10
00:00:29,000 --> 00:00:34,000
propter quod ex parte esse quam scalability auctor ac patenti.

11
00:00:34,000 --> 00:00:37,000
>> Sed ante ultimum tempus at ubi desivit.

12
00:00:37,000 --> 00:00:40,000
Recole quod nos spectabant ad plures Frosh IMs exemplis,

13
00:00:40,000 --> 00:00:44,000
et hoc fuit deforme forma, qua ingressus sum sursum per nonnullus XV + annos elapsos

14
00:00:44,000 --> 00:00:49,000
ut haberet studiosorum campum registri pro freshman intramural sports

15
00:00:49,000 --> 00:00:52,000
sine habens actu ad Iter anymore trans antenna ad Wigglesworth

16
00:00:52,000 --> 00:00:56,000
illabi physici piece of paper subter quidam procurator scriptor ostium.

17
00:00:56,000 --> 00:00:59,000
Vestibulum sed omne quod movetur, sed ad usus necessaria

18
00:00:59,000 --> 00:01:03,000
paucorum Technologies, ita unum, nobis necessaria HTML, Curabitur markup lingua,

19
00:01:03,000 --> 00:01:07,000
quod rursum est hoc markup idioma cum lingua quos facies paginas telae constitutione.

20
00:01:07,000 --> 00:01:10,000
>> Usura aliquantulus of CSS his diebus, SUBMISSUS style cadurco,

21
00:01:10,000 --> 00:01:16,000
quo utimur stylizations de paginae usura paulo aliter syntax,

22
00:01:16,000 --> 00:01:19,000
autem HTML erat omne circa structuram eius.

23
00:01:19,000 --> 00:01:21,000
Egemus etiam ad introducendam telam programming lingua.

24
00:01:21,000 --> 00:01:25,000
In hoc casu, puteus 'utor PHP, et PHP est iens permittat nos

25
00:01:25,000 --> 00:01:28,000
ad dynamically output content tarn bene ceu programmatic rebus quasi

26
00:01:28,000 --> 00:01:33,000
emails missis, sicut patet in ultima septimana nota relinquentes.

27
00:01:33,000 --> 00:01:35,000
>> Pars II in memoriam huius Codicis.

28
00:01:35,000 --> 00:01:38,000
Unum, habuimus froshims3.php,

29
00:01:38,000 --> 00:01:42,000
et hoc erat plerumqe markup cum HTML forma inside of eam,

30
00:01:42,000 --> 00:01:45,000
a vegrandis frenum of CSS eam hic in genere attributa

31
00:01:45,000 --> 00:01:48,000
ita quod ipsa forma sit ipsum centrum, sed ultra

32
00:01:48,000 --> 00:01:51,000
habuimus aliquando repraesentativum forma inputs, a text ager, checkbox,

33
00:01:51,000 --> 00:01:55,000
quidam radio buttons, delectis menu, et Submit puga pyga.

34
00:01:55,000 --> 00:02:01,000
Et per hac forma, dedimus manum ad a lima ut erat appellari videntur register3.php,

35
00:02:01,000 --> 00:02:04,000
quod ipse vidi tale breve.

36
00:02:04,000 --> 00:02:08,000
Nunc, plerique code in register3.php, reminiscere, erat omne circa email.

37
00:02:08,000 --> 00:02:11,000
Neque parum firma radice, ut saltem formae

38
00:02:11,000 --> 00:02:14,000
quod agri sunt actu iam praeditae, qui erant expectata.

39
00:02:14,000 --> 00:02:18,000
Deinde nos, appellavit, PHP functiones usura leviter novum syntax,

40
00:02:18,000 --> 00:02:20,000
C. mutuati tamen suus

41
00:02:20,000 --> 00:02:24,000
>> Hunc arcum operator nobis praebet, uti aliquo vocavit obiectum accumsan programming.

42
00:02:24,000 --> 00:02:27,000
Non intrabit in aliquo derogare, sed nunc sciant

43
00:02:27,000 --> 00:02:31,000
socius suus officium habet rationem obiecti,

44
00:02:31,000 --> 00:02:34,000
quod est specialis forma, ut visum est C.

45
00:02:34,000 --> 00:02:37,000
Nunc autem ita accipere fidem est ut probe constet

46
00:02:37,000 --> 00:02:41,000
PHPMailer usu huiusmodi librariae elit.

47
00:02:41,000 --> 00:02:44,000
Et tunc per finem huius file nos dynamically generatur an email

48
00:02:44,000 --> 00:02:47,000
quod got missis nostra jharvard@cs50.net propter

49
00:02:47,000 --> 00:02:50,000
ex mea jharvard@cs50.net existimaverat,

50
00:02:50,000 --> 00:02:54,000
Mauris pretium notum fuisse et hoc ideo ludus.

51
00:02:54,000 --> 00:02:57,000
Id est pulchellus ultum quid Frosh IMs site fecit omnia illis annis abhinc

52
00:02:57,000 --> 00:03:00,000
impletur autem cum licet per alia verba,

53
00:03:00,000 --> 00:03:02,000
nisi forte vis tibi ostendit

54
00:03:02,000 --> 00:03:05,000
iam sis, ut exprimi potest, teipsum non solum programmatically

55
00:03:05,000 --> 00:03:08,000
parvo complanate in linguam quasi C sed ad multo altiori level

56
00:03:08,000 --> 00:03:11,000
istis ipsis rerum applications quasi email ut actu solvere

57
00:03:11,000 --> 00:03:13,000
quidam realis mundi problems.

58
00:03:13,000 --> 00:03:16,000
>> Quod quidem etsi generare ex hac littera

59
00:03:16,000 --> 00:03:20,000
emails dynamically a jharvard@cs50.net, quae est quidem rationem

60
00:03:20,000 --> 00:03:23,000
quod ego accessum habent ad, noli sint admodum solliciti, ut mittere

61
00:03:23,000 --> 00:03:26,000
mail solum ex compotis sunt actualiter vestra,

62
00:03:26,000 --> 00:03:30,000
quae ne accipere aliquid in calidam aquam vitae.

63
00:03:30,000 --> 00:03:35,000
Cum dixit, Nunc alia quaestio solvenda est omnino mutatio,

64
00:03:35,000 --> 00:03:37,000
qui retinendi civitatium.

65
00:03:37,000 --> 00:03:39,000
Quid sibi vult hoc esse?

66
00:03:39,000 --> 00:03:42,000
HTTP, hoc Curabitur translationis protocollo,

67
00:03:42,000 --> 00:03:45,000
est vere a stateless protocollo, et quid medium hoc est quod

68
00:03:45,000 --> 00:03:48,000
cum te revellat aliquid simile Google.com et tunc ledo intrare

69
00:03:48,000 --> 00:03:51,000
solet vestri pasco habet aliquam telarum icon quod tunc

70
00:03:51,000 --> 00:03:54,000
sequatur paginam ens downloaded,

71
00:03:54,000 --> 00:03:57,000
et tunc illud parum icon sistit stamina et id quidem suggerit

72
00:03:57,000 --> 00:04:02,000
qui HTTP expletum aliquod genus connexionem ad servo quod ut 'eam.

73
00:04:02,000 --> 00:04:05,000
HTTP est stateless in sensu quod non manutenere

74
00:04:05,000 --> 00:04:08,000
adsidua, connexionem ad server eodem modo Skype facit

75
00:04:08,000 --> 00:04:11,000
aut Gchat facit quia cum HTTP

76
00:04:11,000 --> 00:04:15,000
consectetur adipiscing elit semel ponatur quod id ex quo inferunt.

77
00:04:15,000 --> 00:04:18,000
>> Nunc, in re his diebus in sites sicut Facebook et Google Maps

78
00:04:18,000 --> 00:04:21,000
et Twitter et similia illic 'multus magis dynamismum qua

79
00:04:21,000 --> 00:04:25,000
etiam post quod icon sistit telarum vos facto possunt impetro magis updates

80
00:04:25,000 --> 00:04:29,000
a server, magis tweets, magis status updates in Facebook et similia.

81
00:04:29,000 --> 00:04:33,000
Sed scientia est sub altera in sabbato, ut certe fama

82
00:04:33,000 --> 00:04:36,000
notus ut Aiax usura a lingua vocavit JavaScript,

83
00:04:36,000 --> 00:04:38,000
sed in fine diei stateless HTTP est.

84
00:04:38,000 --> 00:04:42,000
Et tamen si vos volo ut quodammodo meminerunt res circa a user

85
00:04:42,000 --> 00:04:44,000
etiam post theyve 'disiungitur a vestris server

86
00:04:44,000 --> 00:04:47,000
PHP facit praebeant vobis Modos ad hoc

87
00:04:47,000 --> 00:04:52,000
quia, ut dictum est ultimum tempus eu superglobals habeat numerum,

88
00:04:52,000 --> 00:04:55,000
et superglobal est iterum, et speciale global variabilis

89
00:04:55,000 --> 00:04:59,000
ut 'tradidit ad vos per telam server et per PHP se.

90
00:04:59,000 --> 00:05:02,000
>> Quid te ut non in pretio,

91
00:05:02,000 --> 00:05:05,000
et inter superglobals weve sic conspicitur longe sunt adepto et proponebat,

92
00:05:05,000 --> 00:05:08,000
quae est ubi forma agros ponantur automatically pro vobis,

93
00:05:08,000 --> 00:05:11,000
Alii quoque duo non viderunt.

94
00:05:11,000 --> 00:05:17,000
Inside of $ _server sunt quidam specialis variabiles comparatur ad server se.

95
00:05:17,000 --> 00:05:22,000
Quis 'IP oratio, quid protocollo, HTTP aut https did vos utor,

96
00:05:22,000 --> 00:05:25,000
quid petitionem methodo did vos uti et huiusmodi, illic 'nonnullus interesting,

97
00:05:25,000 --> 00:05:29,000
De rebus liquidis ornare et Nam ut mauris in nulla.

98
00:05:29,000 --> 00:05:33,000
Illic '$ _cookie, quae est ubi haec vocavit crustulum sunt recondita.

99
00:05:33,000 --> 00:05:36,000
Nos non vacare crustulum se hodie,

100
00:05:36,000 --> 00:05:40,000
sed scito nunc enim quod crustulum est iustus a particulam informationes

101
00:05:40,000 --> 00:05:43,000
qui telam server potest plantabo super telam pasco

102
00:05:43,000 --> 00:05:46,000
et in convertere RAM vel eius computer quod est scriptor ferreus coegi

103
00:05:46,000 --> 00:05:49,000
Lorem ipsum quasi condere, ut eorum nomen usoris

104
00:05:49,000 --> 00:05:52,000
ut aperias quoties id genus non habent vel

105
00:05:52,000 --> 00:05:55,000
unique numerum vel Identifier pro illo user

106
00:05:55,000 --> 00:05:58,000
nec ut genus de quaestionibus eisdem ut Lacessunt

107
00:05:58,000 --> 00:06:00,000
postea mauris at re

108
00:06:00,000 --> 00:06:02,000
ius nunc est $ _session.

109
00:06:02,000 --> 00:06:07,000
>> Hoc superglobal, quae, sicut et alia, est proditum ad vos automatically a PHP

110
00:06:07,000 --> 00:06:10,000
ut vestri 'scribens PHP-substructio websites

111
00:06:10,000 --> 00:06:13,000
potest reponunt quod vis, chordae, integri,

112
00:06:13,000 --> 00:06:16,000
natantis punctis, valores, vestit, rerum,

113
00:06:16,000 --> 00:06:20,000
quod quidem vis et facultas reservaret, ita ut

114
00:06:20,000 --> 00:06:23,000
ut etiam si user visitat vos nunc et tunc,

115
00:06:23,000 --> 00:06:26,000
retrocedit a minute a nunc vel V minutes a nunc quia

116
00:06:26,000 --> 00:06:28,000
capiunt tempus ante clicking aliqua alia nectunt

117
00:06:28,000 --> 00:06:32,000
PHP invigilet ut quidquid posuistis in quod session superglobal

118
00:06:32,000 --> 00:06:37,000
V minutes ago adhuc paulisper, dum vel mauris redit.

119
00:06:37,000 --> 00:06:40,000
Et subter cucullo hoc superglobal impletur per modum

120
00:06:40,000 --> 00:06:44,000
ea vocavit crustulum, sed pro nunc, suus 'iustus abstractio

121
00:06:44,000 --> 00:06:47,000
qua suus 'eiusmodi programmatic Arreum shopping cart.

122
00:06:47,000 --> 00:06:50,000
Quidquid vobis est, programmer, posuit in illa

123
00:06:50,000 --> 00:06:53,000
superglobal consuetudinis array erit ibi aliquot minutes laxus

124
00:06:53,000 --> 00:06:59,000
insquequo vos delete is vel donec user paenamque vel eius pasco omnino.

125
00:06:59,000 --> 00:07:02,000
>> Sit hujus rei exemplum aliquod inspice usi.

126
00:07:02,000 --> 00:07:07,000
In counter.php inter hodierno frusta of code

127
00:07:07,000 --> 00:07:09,000
habebimus hanc linea.

128
00:07:09,000 --> 00:07:13,000
In initio is lima habemus fasciculum de hyacintho comments, quae INERS nunc enim.

129
00:07:13,000 --> 00:07:15,000
XIII nova nobis in linea recta,

130
00:07:15,000 --> 00:07:18,000
session_start et ipsum facit quod dicit.

131
00:07:18,000 --> 00:07:20,000
Is satus sessions.

132
00:07:20,000 --> 00:07:25,000
$ Superglobal _session eius ope magnum usum esse et quod est simplex.

133
00:07:25,000 --> 00:07:30,000
Sed si procedatur versus XVI spectant, sit instar experiar quid sit quod facturus est paginam.

134
00:07:30,000 --> 00:07:35,000
Si (isset ($ _SESSION ["Define"]) tunc grassor

135
00:07:35,000 --> 00:07:39,000
et horrea in calculo variabilis, lowercase calculo

136
00:07:39,000 --> 00:07:42,000
$ _SESSION ["Define"].

137
00:07:42,000 --> 00:07:45,000
Quod tamen videtur esse affirmans localis variabilis vocavit occurro

138
00:07:45,000 --> 00:07:48,000
inside de qua suus 'posito a copy quidquid id est, intus est superglobal

139
00:07:48,000 --> 00:07:52,000
vocavit sedere ad location "considit."

140
00:07:52,000 --> 00:07:56,000
Aliud, apparenter, parvulum hoc localis variabilis calculo est initialized 0.

141
00:07:56,000 --> 00:08:01,000
>> Sed tunc paucorum versuum postea in XXVI adverte quod session scriptor exemplar calculo

142
00:08:01,000 --> 00:08:06,000
ejus clavem, habet novus valor assignatis quod est eius vis praesens plus I.

143
00:08:06,000 --> 00:08:09,000
Denique hunc fasciculum videtur adaequationis

144
00:08:09,000 --> 00:08:13,000
calculus ut 'condideris intus est session superglobal

145
00:08:13,000 --> 00:08:16,000
a incrementing eam per I, sed primo retinet exemplar priore valor

146
00:08:16,000 --> 00:08:20,000
a thesaurizantes eam in loci variabilis vocavit $ calculo

147
00:08:20,000 --> 00:08:22,000
Lorem ipsum dolor sit hic et reliqua.

148
00:08:22,000 --> 00:08:24,000
Evenit suus 'pulchellus multum iustus HTML.

149
00:08:24,000 --> 00:08:29,000
Imo videmus ipsum quia visitavit iaculis versus XXXVII

150
00:08:29,000 --> 00:08:33,000
occurro pluries, sic illic 'a iugo interesting features hic.

151
00:08:33,000 --> 00:08:36,000
, Hoc patet differentia, sed non sufficit tantum dimittere

152
00:08:36,000 --> 00:08:39,000
$ Occurro in corpore vestra HTML quia scilicet

153
00:08:39,000 --> 00:08:43,000
si suus 'iustus illic apud vos HTML PHP est iens ut suppono quod suus' iustus HTML.

154
00:08:43,000 --> 00:08:48,000
Vos litteram volo $ contra imprimendorum in screen.

155
00:08:48,000 --> 00:08:51,000
>> Sed pro a distillans in PHP modus

156
00:08:51,000 --> 00:08:55,000
cum hoc piece of syntax possumus dynamically inserito, valorem hic

157
00:08:55,000 --> 00:08:58,000
quid fecimus simile ultimo spiritu

158
00:08:58,000 --> 00:09:00,000
inserentes valores in tangite.

159
00:09:00,000 --> 00:09:04,000
Nam quid est dicere ad litteram solam denominationem notarius,

160
00:09:04,000 --> 00:09:12,000
print ($ occurro) seu etiam aliquid simile printf (% s, occurro),

161
00:09:12,000 --> 00:09:14,000
aut etiam, ut videris online vel in tradenda,

162
00:09:14,000 --> 00:09:17,000
illic ', munus in PHP vocavit echo

163
00:09:17,000 --> 00:09:20,000
quod idem est et modis omnibus, iusto amplius winded

164
00:09:20,000 --> 00:09:25,000
dicere <? =.

165
00:09:25,000 --> 00:09:28,000
Ut in hoc casu non oportet

166
00:09:28,000 --> 00:09:30,000
verbum PHP post quaestionem marcam.

167
00:09:30,000 --> 00:09:34,000
Hoc est notarius notatio enim, rursus, quid nos iustus vidit paulo ante

168
00:09:34,000 --> 00:09:37,000
quod resonan alicuius valoris.

169
00:09:37,000 --> 00:09:39,000
>> Lorem ipsum dolor sit finis ex hoc habet.

170
00:09:39,000 --> 00:09:43,000
Counter.php vadam in lima,

171
00:09:43,000 --> 00:09:47,000
et nos youll 'animadverto ut David iustus fecit errorem ludit codice ibi.

172
00:09:47,000 --> 00:09:50,000
Eamus redintegro quicquid ille life, ascendit,

173
00:09:50,000 --> 00:09:54,000
et videtur error inde abiit in linea XXXVII.

174
00:09:54,000 --> 00:09:59,000
Ut ipsum verticem 0 Cras interdum visitavi.

175
00:09:59,000 --> 00:10:02,000
Age, eamus ante nunc, tincidunt in summo pasco

176
00:10:02,000 --> 00:10:05,000
Reload icon, et ego click Reload,

177
00:10:05,000 --> 00:10:12,000
I nunc odio habui saluto vicis, II, III, IV, V, VI, VII, VIII.

178
00:10:12,000 --> 00:10:16,000
Et quidem si attendamus ad ipsum principium ipsum dolor sit causa mutandi

179
00:10:16,000 --> 00:10:19,000
Praesent et nulla penitus nescios, et quod est

180
00:10:19,000 --> 00:10:23,000
PHP Codex perpensum aut interpretata server latus,

181
00:10:23,000 --> 00:10:27,000
et ita quod idem significat quod output de PHP scriptum est quid ultimate misit ad pasco,

182
00:10:27,000 --> 00:10:31,000
quae hoc in casu est aliqua crudum HTML et quidam crudum text.

183
00:10:31,000 --> 00:10:33,000
Quid hic agitur?

184
00:10:33,000 --> 00:10:37,000
>> Bene possum relative paucis versibus tani amet

185
00:10:37,000 --> 00:10:40,000
decursu constanter tacuit, quod si diu moratus,

186
00:10:40,000 --> 00:10:44,000
minutes, etiam horas, alicuius valoris in via facit HTTP

187
00:10:44,000 --> 00:10:47,000
videntur stateful quasi weve retenta

188
00:10:47,000 --> 00:10:51,000
Ad quod quidem servo, quia dixi memori ultricies et extremum,

189
00:10:51,000 --> 00:10:55,000
re autem illic 'a toto fasciculumque complexitate iens in subter cucullo

190
00:10:55,000 --> 00:10:59,000
involvente crustulum ut 'enabling PHP ad da mihi hanc illusio

191
00:10:59,000 --> 00:11:02,000
huius shopping cart-amo pluma.

192
00:11:02,000 --> 00:11:05,000
Nam modo, Leve exemplo, ubi erant 'iustus thesaurizantes integer,

193
00:11:05,000 --> 00:11:08,000
esse autem magni ueniet pluma

194
00:11:08,000 --> 00:11:10,000
quando nos satus meditentur magis intricatae eminet,

195
00:11:10,000 --> 00:11:12,000
inter eos problemate VII.

196
00:11:12,000 --> 00:11:16,000
Haec est vestra novissimum minutum problemate in CS50.

197
00:11:16,000 --> 00:11:19,000
Novi triste illud, sed quod erant 'iens ut sciat se esse

198
00:11:19,000 --> 00:11:22,000
hac parte semester in actu, transitioning

199
00:11:22,000 --> 00:11:25,000
Aliquam C ex contextu certo contextu

200
00:11:25,000 --> 00:11:27,000
sed dum usura quidam de ipsa eadem fundamentals

201
00:11:27,000 --> 00:11:29,000
cumque aliquamdiu habuimus.

202
00:11:29,000 --> 00:11:33,000
>> Obiectivam cum pset VII est ad operandam CS50 Lorem

203
00:11:33,000 --> 00:11:37,000
quae tua est poema poematis of Yahoo Oeconomi vel Google Oeconomi

204
00:11:37,000 --> 00:11:40,000
habet etiam potentiam qua Etrade.com

205
00:11:40,000 --> 00:11:43,000
suspiciam stirpe prices for data symbola, sed etiam magis quam quod

206
00:11:43,000 --> 00:11:48,000
habetis facultatem "emunt" et "vendere" nervo

207
00:11:48,000 --> 00:11:51,000
, qui dicuntur, ipsi institores super diversas stirpe commutationibus quia cum eo home page

208
00:11:51,000 --> 00:11:55,000
innuit hic est vere inchoata quantum diximus

209
00:11:55,000 --> 00:11:59,000
problematis paro pro vobis, habes forma ut 'petendo a user nomen et a password.

210
00:11:59,000 --> 00:12:03,000
Habet Submit puga pyga, postea tamen, ut puteus 'eventually videre,

211
00:12:03,000 --> 00:12:06,000
nihil est realiter iens in subter cucullo quia tamen

212
00:12:06,000 --> 00:12:09,000
restat tibi ut ad operandam facultatem ut subcriptio novus users,

213
00:12:09,000 --> 00:12:12,000
facultatem ad emendum nervum, vendere nervum,

214
00:12:12,000 --> 00:12:14,000
ut vere suspiciam current stirpe prices.

215
00:12:14,000 --> 00:12:17,000
>> Atque hoc maxime rerum, quia non erit

216
00:12:17,000 --> 00:12:20,000
Codicis aliquid poni una operatio sinet

217
00:12:20,000 --> 00:12:25,000
ad Query Yahoo Oeconomi, quae mirabiliter facit available liberum notitia

218
00:12:25,000 --> 00:12:31,000
pro suspiciens stirpe prices substructio in stirpe symbolum aut ticker symboli,

219
00:12:31,000 --> 00:12:34,000
quod vos adepto reducitis current stirpe price diei.

220
00:12:34,000 --> 00:12:37,000
Notitia vestri 'cerneret in hoc particulari pset erit

221
00:12:37,000 --> 00:12:40,000
circa, ut reales mundo ut eam can adepto ut vestri 'actu interfacing

222
00:12:40,000 --> 00:12:43,000
vera cum mundo nervum, rerum prices,

223
00:12:43,000 --> 00:12:47,000
si potes, et videbimus quantum pecuniae

224
00:12:47,000 --> 00:12:51,000
ludi deinde aliquot dies in problemate tuo.

225
00:12:51,000 --> 00:12:55,000
>> Sed signifer scriptor primum proficiscentur scaena quomodo enim ad excogitandum aliquid ut 'certe magis complicated

226
00:12:55,000 --> 00:12:59,000
quam counter.php, ut 'magis complicated quam ullum de Frosh IMs exempla hactenus,

227
00:12:59,000 --> 00:13:02,000
et hic est paradigms nituntur inducere liceat paucis

228
00:13:02,000 --> 00:13:06,000
tam pro pset VII quod maybe pro vestra finalis project si feceritis aliquid telam fundatur

229
00:13:06,000 --> 00:13:11,000
ut servo vestri codice bene regulato, ut custodiant te sanus,

230
00:13:11,000 --> 00:13:15,000
et accipere step ad adlaborandi, sive in CS50 ultima project

231
00:13:15,000 --> 00:13:18,000
quod si ultra ipsum semper futurum.

232
00:13:18,000 --> 00:13:21,000
Illic 'hoc generali consilio paradigma

233
00:13:21,000 --> 00:13:24,000
in computatrum scientia quidem et software development magis generaliter

234
00:13:24,000 --> 00:13:27,000
notus ut MVC, forma visum gubernatrix,

235
00:13:27,000 --> 00:13:30,000
quod inepte satis Acronym Belle describit,

236
00:13:30,000 --> 00:13:34,000
a ratione discessum est alia ratio,

237
00:13:34,000 --> 00:13:39,000
specie custodientes separata logicam aut negotium logica a website

238
00:13:39,000 --> 00:13:42,000
ut puta quod habet

239
00:13:42,000 --> 00:13:45,000
vocans functiones et querying databases et similia

240
00:13:45,000 --> 00:13:48,000
contingit non inter vestra HTML

241
00:13:48,000 --> 00:13:51,000
sed magis in separatas files, et quidem, illic 'hoc uno file

242
00:13:51,000 --> 00:13:54,000
typice ut vos have vocavit controller

243
00:13:54,000 --> 00:13:56,000
animus vero post id opus, quod puteus 'animadverto ut

244
00:13:56,000 --> 00:13:58,000
Ut enim hac hora.

245
00:13:58,000 --> 00:14:01,000
>> Illic 'a exemplum cuius est programming codice

246
00:14:01,000 --> 00:14:05,000
qui facit confabulationem vestris databases, quod loquitur to Yahoo Oeconomi et similia,

247
00:14:05,000 --> 00:14:08,000
et tunc nulla suus 'V in MVC est, sententias,

248
00:14:08,000 --> 00:14:11,000
omnibus de effercio ut 'comparatur ad AESTHETICA, lima ut etiam continent

249
00:14:11,000 --> 00:14:14,000
vestra HTML, maybe vestra CSS et similia.

250
00:14:14,000 --> 00:14:17,000
Ratio hic ut hanc imaginem suggerit, ut arbitrium

251
00:14:17,000 --> 00:14:21,000
est file, sicut et nos mox hic et sicut youll praesertim videre in pset VII,

252
00:14:21,000 --> 00:14:24,000
quod mundus loquitur ad via eorum web navigatores.

253
00:14:24,000 --> 00:14:27,000
Id est lima ut sudatio, visitavit in publicis penitus,

254
00:14:27,000 --> 00:14:30,000
sed controller loquitur ad potentia exemplar,

255
00:14:30,000 --> 00:14:34,000
quod est unum aut plura lima ut postulo codice cognatam notitia,

256
00:14:34,000 --> 00:14:37,000
databases ad bibendum et similia, et sic loquuntur

257
00:14:37,000 --> 00:14:40,000
aut plura cognosci dolor arbitrium sententiae

258
00:14:40,000 --> 00:14:43,000
quae sunt AESTHETICA of a web page, templates of generis,

259
00:14:43,000 --> 00:14:47,000
Mauris ut aliquam input posse, sed in fine diei

260
00:14:47,000 --> 00:14:50,000
solum logica inside de visu debet esse reddicione quod notitia,

261
00:14:50,000 --> 00:14:53,000
iterando super a loop et actu expuens aliquem

262
00:14:53,000 --> 00:14:56,000
HTML-substructio rendition eius vel etiam aliquid instar PDF.

263
00:14:56,000 --> 00:14:59,000
>> Quis 'fastidiose MVC est ut vos potest habere diversas views

264
00:14:59,000 --> 00:15:02,000
Ratio autem procedit ratio illa procedit de forma etiam, genus documenti

265
00:15:02,000 --> 00:15:04,000
Curabitur velit ostendere.

266
00:15:04,000 --> 00:15:10,000
Lets 'take a inviso pauci successive magis intricatae et bene disposuerat exempla

267
00:15:10,000 --> 00:15:13,000
venantes, primum cum version 0, hic.

268
00:15:13,000 --> 00:15:16,000
Dimitte me ante et aperuerit sursum in nostrum MVC presul hodie

269
00:15:16,000 --> 00:15:21,000
a lima vocavit index.php in presul 0.

270
00:15:21,000 --> 00:15:26,000
Animadverto hoc est a eximius simplex et valde underwhelming website

271
00:15:26,000 --> 00:15:29,000
ut 'genus version 0, of a homepage pro CS50,

272
00:15:29,000 --> 00:15:32,000
Ecce quam nobis pagina lectionibus habent LEX pagina,

273
00:15:32,000 --> 00:15:35,000
et si nexum sequi ad Lectures adverte quod URL

274
00:15:35,000 --> 00:15:39,000
ascendit verticem est iens ut mutari in lectures.php.

275
00:15:39,000 --> 00:15:44,000
Si ergo ego nexum sequi ad Week I adverte quod URL changes ut week1.php.

276
00:15:44,000 --> 00:15:46,000
Structuram hierarchicam non videtur satis facilia est.

277
00:15:46,000 --> 00:15:49,000
>> Lets 'take a velox inviso subter cucullo ad quomodo hoc positum,

278
00:15:49,000 --> 00:15:53,000
Etenim si illud aspicio index.php amet adipiscing elit.

279
00:15:53,000 --> 00:15:57,000
In facto, quamvis vocavi hoc PHP file illic 'nullum actuale programming code.

280
00:15:57,000 --> 00:16:01,000
Illic 'a comment scripsi hic in PHP ita et user non terminus sursum videns eam.

281
00:16:01,000 --> 00:16:05,000
Scilicet ut, felis eu quidquam inter

282
00:16:05,000 --> 00:16:08,000
gets interpretatum est, si velit, cursus ut interpretetur

283
00:16:08,000 --> 00:16:11,000
Iustum est abicere non autem in fine diei

284
00:16:11,000 --> 00:16:15,000
mitte pasco, sic panton in hic iustus est AESTHETICA.

285
00:16:15,000 --> 00:16:20,000
Si ego patefacio sursum similiter lectures.php hoc etiam iustum est Asperum coded lima.

286
00:16:20,000 --> 00:16:23,000
Contingit vocari aliquid. Php,

287
00:16:23,000 --> 00:16:27,000
sed re vera iustum est. html, et week1.php, week2.php

288
00:16:27,000 --> 00:16:31,000
similiter sicut markup ita defectum consilio fasciculum est.

289
00:16:31,000 --> 00:16:33,000
Unum, suus 'a ingens amount of copy / conspérsio.

290
00:16:33,000 --> 00:16:37,000
Quamvis solus res ut 'mutans inter illorum lima est inordinatum album,

291
00:16:37,000 --> 00:16:41,000
et li tags, ego tamen hoc doc typus, HTML, caput,

292
00:16:41,000 --> 00:16:44,000
title, confertae corpus, confertae HTML et magis

293
00:16:44,000 --> 00:16:47,000
omnibus adire, si quando id velit restructure

294
00:16:47,000 --> 00:16:50,000
hoc web pagina aut restylize eam ire debeo in et mutare

295
00:16:50,000 --> 00:16:54,000
haec omnia lima manually aut cum aliqua ingens invenire et reponet.

296
00:16:54,000 --> 00:17:01,000
>> Lets gradi ad smarter, longioribus ratus erat consilium version I hic

297
00:17:01,000 --> 00:17:04,000
Quare per me in lecto ut diximus psallentem cum etiam

298
00:17:04,000 --> 00:17:07,000
his languidius domi adverte quod habemus hic

299
00:17:07,000 --> 00:17:10,000
I situ adipiscing lectus in summa,

300
00:17:10,000 --> 00:17:13,000
et videtur mihi memet suscepta est simile de

301
00:17:13,000 --> 00:17:17,000
commune aliquod scripta, header.php et footer.php.

302
00:17:17,000 --> 00:17:20,000
Age, quid intus est primum illorum inspice.

303
00:17:20,000 --> 00:17:23,000
Header.php spectat familiare,

304
00:17:23,000 --> 00:17:26,000
Donec sed notandum quod ubi incidit?

305
00:17:26,000 --> 00:17:30,000
Iure post linea XIX, ita ut 'omne quod erat commune

306
00:17:30,000 --> 00:17:33,000
ex scriniis index.php, lectures.php,

307
00:17:33,000 --> 00:17:36,000
week1 et week2.php ex priori exemplo.

308
00:17:36,000 --> 00:17:40,000
Quod ego feci totum quod exemplar commune erat omnibus ordinibus praecisis,

309
00:17:40,000 --> 00:17:44,000
posuit illud in separato caput capitis file, et similiter in footer.php

310
00:17:44,000 --> 00:17:48,000
non ego applicare idem principium quo solum interesting lineas

311
00:17:48,000 --> 00:17:52,000
in footer.php sunt duae, confertae corpus et consere HTML.

312
00:17:52,000 --> 00:17:55,000
>> Sed quid est quod nunc nova

313
00:17:55,000 --> 00:17:59,000
de index.php Observate Quanto est simplicius eam habere possumus.

314
00:17:59,000 --> 00:18:02,000
Concessimus, aliquantulus magis crypticus respicientes paulo minus intuitiva

315
00:18:02,000 --> 00:18:06,000
imo sequi, sed Deo, qui egressus est nugatio.

316
00:18:06,000 --> 00:18:10,000
Requirimus usura a PHP functio litteram vocavit requirere ascendit summitatem,

317
00:18:10,000 --> 00:18:15,000
quod est valde simile revocare C est scriptor # includunt mechanism.

318
00:18:15,000 --> 00:18:17,000
Header.php requiritur in summo.

319
00:18:17,000 --> 00:18:20,000
Imo requiritur footer.php et alias res

320
00:18:20,000 --> 00:18:25,000
Suspendisse id velit vel specialibus unicam esse contentus est lima ipsum.

321
00:18:25,000 --> 00:18:29,000
Ingrediar si forte lectures.php idem adhibetur modus.

322
00:18:29,000 --> 00:18:32,000
Rursus quidam comments ascenderunt verticem, sed tunc requiram caput capitis, require footer,

323
00:18:32,000 --> 00:18:35,000
Lorem ipsum dolor esse in medio illud tantum mutato.

324
00:18:35,000 --> 00:18:38,000
Et si nos prospexit in Week I et Week II wed 'videre

325
00:18:38,000 --> 00:18:42,000
eadem ratione adhibita est.

326
00:18:42,000 --> 00:18:44,000
Recte facta sunt non iam sumus.

327
00:18:44,000 --> 00:18:48,000
>> II inspice sit amet congue quam forma simile,

328
00:18:48,000 --> 00:18:50,000
tamen animadvertite nunc Ive 'introducta aliquid aliud.

329
00:18:50,000 --> 00:18:53,000
In linea X Ive 'introducta helpers.php,

330
00:18:53,000 --> 00:18:55,000
quae apparenter continet auxiliator functionum.

331
00:18:55,000 --> 00:18:58,000
Adjutor functio plerumque est relative brevis functio

332
00:18:58,000 --> 00:19:01,000
quod scribis te adiuvare loca,

333
00:19:01,000 --> 00:19:04,000
quod lets videre quid suus 'inside of helpers.php.

334
00:19:04,000 --> 00:19:07,000
Hic videtur habere II elit.

335
00:19:07,000 --> 00:19:10,000
Revocare a alia die cum nostris cube exemplum

336
00:19:10,000 --> 00:19:13,000
tibi possit diffinire vestri own functiones PHP, et quod egi nunc est mihi sunt

337
00:19:13,000 --> 00:19:17,000
definitur functiones vocavit reddere footer et reddere caput capitis,

338
00:19:17,000 --> 00:19:21,000
quarum prima sumit a parameter vocavit notitia,

339
00:19:21,000 --> 00:19:25,000
cuius default valor est inani praeparati quasi suggessit ibi,

340
00:19:25,000 --> 00:19:29,000
et nos possit actu et haec scribimus magis etiam succincte in tardus poema poematis of PHP

341
00:19:29,000 --> 00:19:32,000
dicendo platea bracket, claudi quadratum bracket.

342
00:19:32,000 --> 00:19:35,000
Ut opes inani array molis 0 sed tamen an ordinata.

343
00:19:35,000 --> 00:19:38,000
>> Hoc extract functio est parum speciale in quod

344
00:19:38,000 --> 00:19:41,000
quod autem agit, est accipit quasi argumenti an consuetudinis array

345
00:19:41,000 --> 00:19:45,000
quod habet 0 vel plus key valorem septena, et si quas habetis a key of foo

346
00:19:45,000 --> 00:19:48,000
et valor bar extractum functio

347
00:19:48,000 --> 00:19:51,000
quae res efficit, iamque aciem XI,

348
00:19:51,000 --> 00:19:57,000
vos habere localis variabilis vocavit $ foo cuius hoc pretium est talea.

349
00:19:57,000 --> 00:19:59,000
Et si valores claves magis notitia instructo

350
00:19:59,000 --> 00:20:03,000
similiter eos et, si extrahatur in loci scope

351
00:20:03,000 --> 00:20:06,000
seu nomine spatium ita ut footer.php et

352
00:20:06,000 --> 00:20:09,000
eadem idea hic ponitur ita ut header.php

353
00:20:09,000 --> 00:20:12,000
habere aditus eorum variabilium.

354
00:20:12,000 --> 00:20:15,000
Nam rursum aperiam header.php

355
00:20:15,000 --> 00:20:18,000
quid hoc videtur et veluti conspiciendum proponunt velit.

356
00:20:18,000 --> 00:20:22,000
>> Potius quam durum coding CS50 ut titulus singulos page

357
00:20:22,000 --> 00:20:24,000
animadverto impulsionem, ut 'possibile nunc.

358
00:20:24,000 --> 00:20:29,000
In linea V Im sonanti title variabilis,

359
00:20:29,000 --> 00:20:34,000
sed primum Im transeas in title variabilis functio vocavit htmlspecialchars.

360
00:20:34,000 --> 00:20:38,000
Nomen stultus facit dum tamen quod revera dicit.

361
00:20:38,000 --> 00:20:41,000
Eam efficit, ut aliquem specialem characters

362
00:20:41,000 --> 00:20:46,000
in chorda ut 'transierunt, rite sint effugi HTML.

363
00:20:46,000 --> 00:20:49,000
Is est vere viam vitandi aliquid vocavit autem crucis site scripting impetum

364
00:20:49,000 --> 00:20:52,000
quo aliquis can vel malitiose aut per accidens

365
00:20:52,000 --> 00:20:55,000
injiciunt sua HTML in vestri website

366
00:20:55,000 --> 00:20:59,000
preteritus per aliquam formam, scilicet

367
00:20:59,000 --> 00:21:02,000
tu aliquid sunt, non satis sperentur, praesertim JavaScript scripta,

368
00:21:02,000 --> 00:21:05,000
aut alterius certe in sabbato, ut fama est.

369
00:21:05,000 --> 00:21:08,000
>> Hoc nunc header.php, suus 'a sententia

370
00:21:08,000 --> 00:21:12,000
in sensu quod sino vos ad considerandam aesthetically contentis aliqua notitia paro.

371
00:21:12,000 --> 00:21:14,000
Sed magis specifice, suus 'a template.

372
00:21:14,000 --> 00:21:19,000
Id cuius modi sit iam blueprint omnium paginarum Vestibulum spectare volumus,

373
00:21:19,000 --> 00:21:23,000
sed illic 'nonnullus dynamismum in illa volumus title esse dynamically inserta

374
00:21:23,000 --> 00:21:26,000
fundatur super title variabilis

375
00:21:26,000 --> 00:21:30,000
qui eductus fuit quando dictus a nobis, rursus,

376
00:21:30,000 --> 00:21:33,000
redditionis caput capitis muneris.

377
00:21:33,000 --> 00:21:36,000
Quod si aspexi Cras reddat, non multum est quod nunc nondum

378
00:21:36,000 --> 00:21:40,000
quia in footer.php illic 'haud dynamismum quodcumque.

379
00:21:40,000 --> 00:21:43,000
Ibi posset esse, sed eo momento suus 'Asperum coded album of II tags

380
00:21:43,000 --> 00:21:46,000
ipsum autem ratio, ut innuat quod etiam

381
00:21:46,000 --> 00:21:49,000
vidimus tererent tempus habens Reddat caput capitis et Reddat footer functio?

382
00:21:49,000 --> 00:21:52,000
Dimitte me instead nunc in poema poematis III,

383
00:21:52,000 --> 00:21:56,000
et in poema poematis III in adiutores EGO certus simpliciorem reddere eam magis etiam.

384
00:21:56,000 --> 00:21:58,000
>> Dimitte me habere unum Reddat muneris.

385
00:21:58,000 --> 00:22:02,000
Alia est in me arguitur, dicitur hoc ipsum,

386
00:22:02,000 --> 00:22:05,000
Lorem ipsum dolor sit quae intelligitur nomine,

387
00:22:05,000 --> 00:22:11,000
et tunc volo IUNCTUS intumescat superbia. php ad illius variabilis est scriptor valorem,

388
00:22:11,000 --> 00:22:17,000
et tunc si existit foo.php, bar.php aut header.php et footer.php,

389
00:22:17,000 --> 00:22:20,000
tunc Im 'iens ut antecedat et extractum variabilis notitia

390
00:22:20,000 --> 00:22:23,000
et tunc requirunt, ut semitam.

391
00:22:23,000 --> 00:22:29,000
Praeterea, uti si aperiamus index.php

392
00:22:29,000 --> 00:22:32,000
animadverto ut non voco ego Reddat caput capitis anymore.

393
00:22:32,000 --> 00:22:36,000
EGO iustus vocant reddere, sed ego transire in inducta valorem caput capitis

394
00:22:36,000 --> 00:22:39,000
ad declarandum quae template ego vere volo ut oneratis.

395
00:22:39,000 --> 00:22:41,000
>> Deinde super hic animadverto quis Im facientem.

396
00:22:41,000 --> 00:22:44,000
Im 'transeunter dynamically a key of title,

397
00:22:44,000 --> 00:22:47,000
CS50 valorem, idque ita ut ante

398
00:22:47,000 --> 00:22:51,000
Praesent fermentum in versionem fieri succinctior

399
00:22:51,000 --> 00:22:54,000
ubi ego can restituo array functio quadris brackets,

400
00:22:54,000 --> 00:22:57,000
Rem haud magis quam readable

401
00:22:57,000 --> 00:22:59,000
paulo facilius ut typus.

402
00:22:59,000 --> 00:23:02,000
Et sane cum dicitur reddat Cras in imo,

403
00:23:02,000 --> 00:23:05,000
utriusque omnino ratio non transeunter aut consuetudinis apparatu

404
00:23:05,000 --> 00:23:07,000
quia nihil dynamic inside of quod footer.

405
00:23:07,000 --> 00:23:10,000
Suus 'iustus quaedam vicina tags for HTML.

406
00:23:10,000 --> 00:23:14,000
Bonum, erant 'accipiens gradus ad realiter Purgato res sursum hic,

407
00:23:14,000 --> 00:23:17,000
sed permitte mihi patefacio sursum II finalis exempla.

408
00:23:17,000 --> 00:23:21,000
Hic numerus IV adverte quod iam pridem factum conscium consilium

409
00:23:21,000 --> 00:23:26,000
priore exemplo usus emendare postremo ad aliquam hierarchiam lectus.

410
00:23:26,000 --> 00:23:29,000
>> Animadverto ut in hoc summary, in hoc me legat, Ive 'introducta

411
00:23:29,000 --> 00:23:32,000
an includit presul et templates presul

412
00:23:32,000 --> 00:23:35,000
cuius contenta in eodem futura sunt quae volo ut comprehendo

413
00:23:35,000 --> 00:23:38,000
et reddent ipsum cupio utrumque.

414
00:23:38,000 --> 00:23:42,000
Is est vere mihi res ani, et quaererem retinere luculentam,

415
00:23:42,000 --> 00:23:45,000
custodiant related files simul, sed terminus praecessi

416
00:23:45,000 --> 00:23:48,000
parum est tidier jam habeat, sed memento ut

417
00:23:48,000 --> 00:23:51,000
in, puta index.php

418
00:23:51,000 --> 00:23:55,000
quando requirimus file helpers.php

419
00:23:55,000 --> 00:24:01,000
nos have ut nunc requiret illud via includit / helpers.php

420
00:24:01,000 --> 00:24:06,000
sed quia iam est actu pars helpers.php dicere justo.

421
00:24:06,000 --> 00:24:09,000
Sed ut omissis aliis exempla videas etiam in

422
00:24:09,000 --> 00:24:11,000
functiones similis, requirunt, requirere semel.

423
00:24:11,000 --> 00:24:15,000
Illic 'actu functio vocatur ipsa includunt, et omnes habent inmutato moribus.

424
00:24:15,000 --> 00:24:18,000
Hic dico requirere semel facere superessentialem patet quod sed volo illis

425
00:24:18,000 --> 00:24:20,000
adiutores includitur in mea project semel.

426
00:24:20,000 --> 00:24:24,000
Sed si Im 'diligens et si Im' cogitans actualiter per meum logica proprie

427
00:24:24,000 --> 00:24:27,000
eam sufficere debent modum iustus dicere requirere ascenderunt verticem

428
00:24:27,000 --> 00:24:31,000
Ego non quaeram adhuc illo casu lima alibi.

429
00:24:31,000 --> 00:24:34,000
Nam paulo fortius agendi sic sit sub

430
00:24:34,000 --> 00:24:38,000
requirere, confestim Peius 'tonderi eam usque ad iustus requiratis.

431
00:24:38,000 --> 00:24:40,000
>> Lets tollerent unam step ulterius.

432
00:24:40,000 --> 00:24:46,000
Hoc ultimum exemplum nunc, version V, habet etiam lautus folder hierarchiae.

433
00:24:46,000 --> 00:24:50,000
Animadverto quod egi hic per in me legat novissima hac in version

434
00:24:50,000 --> 00:24:54,000
Aliquam fermentum nunc habeo, quod cum omnia mihi tempora

435
00:24:54,000 --> 00:24:58,000
sed inside of nunc ibi est tantum index.php, lectures.php,

436
00:24:58,000 --> 00:25:01,000
week1.php et week2.php.

437
00:25:01,000 --> 00:25:05,000
In includit presul nunc vivit e regione de HTML directorium

438
00:25:05,000 --> 00:25:08,000
Par quasi fratrem sic dicere.

439
00:25:08,000 --> 00:25:10,000
Sic templates folder.

440
00:25:10,000 --> 00:25:14,000
Clavem takeaway hic est Ive 'introducta pauco plus structuram,

441
00:25:14,000 --> 00:25:17,000
sed key pluma nunc est soli files

442
00:25:17,000 --> 00:25:21,000
opus illud esse web accessibilis, publice addressable

443
00:25:21,000 --> 00:25:25,000
per URL in publicis interrete sunt in mea HTML presul.

444
00:25:25,000 --> 00:25:28,000
>> Inter haec aliae lima, helpers.php, footer.php,

445
00:25:28,000 --> 00:25:32,000
header.php, qui sunt arguably maybe magis sensitivum,

446
00:25:32,000 --> 00:25:35,000
maybe adiutores actu habet aliquam user nomina et passwords vel aliqua intellectualis

447
00:25:35,000 --> 00:25:39,000
Proprium mihi esse nolo functiones ad mundum, quamvis per accidens.

448
00:25:39,000 --> 00:25:45,000
Suus 'bonus praxi ut custodiant de publico HTML presul

449
00:25:45,000 --> 00:25:48,000
non indigent aliquo ad publica lectus.

450
00:25:48,000 --> 00:25:51,000
Cum facias omnia intuentis in causa, ut

451
00:25:51,000 --> 00:25:55,000
in HTML presul est scriptor index.php lima,

452
00:25:55,000 --> 00:25:58,000
animadverto nos iustus debuit esse paulo diligentiorem quando postulantes

453
00:25:58,000 --> 00:26:00,000
aut exigere semel haec lima.

454
00:26:00,000 --> 00:26:03,000
EGO postulo fac prius .. Aliquam erat ad patrem,

455
00:26:03,000 --> 00:26:06,000
ergo dicunt / includit / helpers.php

456
00:26:06,000 --> 00:26:12,000
intendere reversi sunt et descenderunt in impetro file quod ego curat opus.

457
00:26:12,000 --> 00:26:16,000
>> Ullus questions deinde super MVC

458
00:26:16,000 --> 00:26:20,000
vel hoc relative simplex incarnationis eius?

459
00:26:20,000 --> 00:26:23,000
Et ostendet mihi declarabimus ut nos focused admodum aliquantulus super

460
00:26:23,000 --> 00:26:27,000
V, qui hie views et factoring ex his templates.

461
00:26:27,000 --> 00:26:30,000
M a C tamen non distinguuntur realiter sicut diximus.

462
00:26:30,000 --> 00:26:33,000
Nam vere non est hic M etiam nostra,

463
00:26:33,000 --> 00:26:36,000
arbitrium, non tamen totum hoc multum plus accipias tibi

464
00:26:36,000 --> 00:26:39,000
familiarior cum utriusque illorum II epistolas ab MVC,

465
00:26:39,000 --> 00:26:43,000
vel potius, youll 'adepto multo magis nota cum C

466
00:26:43,000 --> 00:26:49,000
in MVC pro forsit paro VII, sic illic 'magis quod die horizon.

467
00:26:49,000 --> 00:26:51,000
Quaestiones?

468
00:26:51,000 --> 00:26:53,000
Illic 'actu nemo hic.

469
00:26:53,000 --> 00:26:57,000
>> Okay, lets nunc movere ad secundam et finalis topic pro hodie.

470
00:26:57,000 --> 00:27:00,000
Quod introductio datorum.

471
00:27:00,000 --> 00:27:03,000
Ad haec usque punctum weve esset paucis vias thesaurizantes notitia.

472
00:27:03,000 --> 00:27:05,000
Weve solebat variabilium.

473
00:27:05,000 --> 00:27:08,000
Back in nostra C lima, EGO / O discursu coepi usura text files

474
00:27:08,000 --> 00:27:11,000
et utentes files quasi fprintf, et tunc etiam started

475
00:27:11,000 --> 00:27:14,000
meditentur CSV Lima pauco, distingue separata valores,

476
00:27:14,000 --> 00:27:17,000
sic haec omnia permissam nobis habere notitia condideris

477
00:27:17,000 --> 00:27:19,000
aut non-obstinatius aut obstinatius.

478
00:27:19,000 --> 00:27:23,000
Sed etiam CSVs non realiter conducunt ad inquirenda

479
00:27:23,000 --> 00:27:25,000
commemorati et deleting.

480
00:27:25,000 --> 00:27:28,000
Suus 'vere iustus stolida text file separari per commata

481
00:27:28,000 --> 00:27:30,000
row a row a row a row, ita, si vos volo ut

482
00:27:30,000 --> 00:27:32,000
, perscrutabor file optimum vos can operor vere est linearibus search.

483
00:27:32,000 --> 00:27:34,000
Tu fasciculum summo exordio legitur in totum,

484
00:27:34,000 --> 00:27:36,000
et quaere commodo pretium.

485
00:27:36,000 --> 00:27:39,000
Vis tibi faciendum idem sit inseres,

486
00:27:39,000 --> 00:27:41,000
iterando super eam et inserentes in particulari loco,

487
00:27:41,000 --> 00:27:45,000
et denique ratio investigat omnia facias tibi.

488
00:27:45,000 --> 00:27:49,000
>> Non potes facere ingeniosi exemplar matching on a CSV lima nisi tu ipse scribere code.

489
00:27:49,000 --> 00:27:51,000
Non poteris a CSV lima filtration

490
00:27:51,000 --> 00:27:53,000
nisi tu ipse scribere code.

491
00:27:53,000 --> 00:27:56,000
Non esset sit nice quod si quis alius, posuit in omnibus laboris

492
00:27:56,000 --> 00:27:59,000
actu et scrutans facilis et insertionem facilis

493
00:27:59,000 --> 00:28:01,000
et deletionem et adaequationis, et huiusmodi?

494
00:28:01,000 --> 00:28:04,000
Ut 'exigo quis a database est.

495
00:28:04,000 --> 00:28:07,000
SQL, exstructa query lingua, tamen est alia lingua

496
00:28:07,000 --> 00:28:10,000
qui erant 'introducendis hic etiam hodie, sed hoc quoque est modice facilem,

497
00:28:10,000 --> 00:28:13,000
quid facturi sumus iusti eruam de re aliqua maxime salientibus

498
00:28:13,000 --> 00:28:16,000
characteristics ita quod pro pset VII, et si aliquid facere telam fundatur,

499
00:28:16,000 --> 00:28:19,000
ultimus elit vobis sentire possunt

500
00:28:19,000 --> 00:28:22,000
in terminis of notitia queries.

501
00:28:22,000 --> 00:28:25,000
Modicum habes facultatem componunt dolor sit amet

502
00:28:25,000 --> 00:28:28,000
Multo ordine in fine diei itinere

503
00:28:28,000 --> 00:28:32,000
planto vestri vita facilius quia cum SQL vos can sentire

504
00:28:32,000 --> 00:28:35,000
multo magis praecise, multo magis methodice in ordine ad

505
00:28:35,000 --> 00:28:40,000
impetro tergum aliqua subset of notitia plurium hierarchia notitia.

506
00:28:40,000 --> 00:28:45,000
>> Vos can cogitant de database, in hoc casu, SQL database, realiter sicut Praecedo

507
00:28:45,000 --> 00:28:48,000
aut Numbers ubi suus 'a spreadsheet,

508
00:28:48,000 --> 00:28:50,000
vel maybe multiple spreadsheets, et spreadsheet, sane,

509
00:28:50,000 --> 00:28:53,000
habet ordines et columnae, et quod suus 'quoniam

510
00:28:53,000 --> 00:28:56,000
SQL databases sunt relationis, relationis in sensu

511
00:28:56,000 --> 00:28:59,000
qui reponunt notitia in istis mensas,

512
00:28:59,000 --> 00:29:01,000
ordines columns.

513
00:29:01,000 --> 00:29:03,000
Sunt superiora Faciendo quam aliquid quasi spreadsheet,

514
00:29:03,000 --> 00:29:05,000
spreadsheet humana et sit utendum.

515
00:29:05,000 --> 00:29:08,000
A database intelligitur utendum per programmer

516
00:29:08,000 --> 00:29:12,000
scribens codice contra eam, sic incarnationem a database

517
00:29:12,000 --> 00:29:14,000
neque aciem imperii fore.

518
00:29:14,000 --> 00:29:18,000
>> Unum ex maxime popularis relationis databases sicco illic est iterum MySQL,

519
00:29:18,000 --> 00:29:22,000
Mirum est liber magni faciens, et hoc

520
00:29:22,000 --> 00:29:24,000
Lorem ipsum usu quodam et hodie mane

521
00:29:24,000 --> 00:29:27,000
multa eius indicia condere et certe videmus nunc per

522
00:29:27,000 --> 00:29:30,000
ut usura relative simplex mandata

523
00:29:30,000 --> 00:29:33,000
nos can lego notitia, interserunt notitia, update notitia,

524
00:29:33,000 --> 00:29:37,000
delete notitia et similia, sed gratanter, illic 'a plus user-amica interface

525
00:29:37,000 --> 00:29:39,000
quam iustus typing ad nigrum et album promptus hic.

526
00:29:39,000 --> 00:29:43,000
Puteus 'uti ad pset VII et trans liberum tool vocavit phpMyAdmin.

527
00:29:43,000 --> 00:29:45,000
Nomen est, dato.

528
00:29:45,000 --> 00:29:47,000
, Tool contingit ad effectum erunt adducendae in PHP,

529
00:29:47,000 --> 00:29:49,000
tamen ut 'fundamentaliter impertinens.

530
00:29:49,000 --> 00:29:53,000
Quis 'utilis circa phpMyAdmin est ut suus' telam-substructio utilitas.

531
00:29:53,000 --> 00:29:55,000
INSTRUMENTUM habuimus in pre-installed vos

532
00:29:55,000 --> 00:29:58,000
et inde datorum tabulis creare,

533
00:29:58,000 --> 00:30:01,000
vos can inserere notitia, delete notitia, et generaliter videre

534
00:30:01,000 --> 00:30:04,000
vestri notitia in a iuste user-amica environment.

535
00:30:04,000 --> 00:30:07,000
Your users futura non sunt uti phpMyAdmin.

536
00:30:07,000 --> 00:30:09,000
>> Is est vere iustus an administrativus aut elit scriptor tool

537
00:30:09,000 --> 00:30:12,000
cum qua videre et TAGO inter vestri notitia quod instar sicco quam ut formare eam,

538
00:30:12,000 --> 00:30:15,000
simillumae tu ipse uteretur Praecedo aut Numeri,

539
00:30:15,000 --> 00:30:19,000
Duis sed est magna futura sub cucullo visualizing quid est in

540
00:30:19,000 --> 00:30:22,000
Ista quaestio solvenda non tam iucundum dolor

541
00:30:22,000 --> 00:30:25,000
in artium arcanorum imperat.

542
00:30:25,000 --> 00:30:28,000
Inspice dolor sit amet istud exemplum tabularly sit amet

543
00:30:28,000 --> 00:30:30,000
in respectiva database.

544
00:30:30,000 --> 00:30:32,000
Hic 'unum ex huiusmodi exemplum.

545
00:30:32,000 --> 00:30:35,000
Nunc, quod valde dolendum phpMyAdmin erravit in latere jactans, modo quoque multa verba

546
00:30:35,000 --> 00:30:38,000
et graphics simul te, sed si te acuunt in iustos ad

547
00:30:38,000 --> 00:30:42,000
ID agmen, nomen usoris agmen, et cinis agmen,

548
00:30:42,000 --> 00:30:45,000
Quod efficacius spreadsheet sed contingit esse PRAECISIO

549
00:30:45,000 --> 00:30:49,000
INSTRUMENTUM interius tabulae

550
00:30:49,000 --> 00:30:53,000
lima te ut in problemate providere VII.

551
00:30:53,000 --> 00:30:57,000
>> Praesertim quod plane damus lima

552
00:30:57,000 --> 00:31:01,000
a user mensam domini, ita spreadsheet continens users cum III columns,

553
00:31:01,000 --> 00:31:05,000
quarum una est a unique ID satus procul I et incremented deinceps.

554
00:31:05,000 --> 00:31:08,000
Nullam est nibh in nomine Hacker Quae quidem,

555
00:31:08,000 --> 00:31:12,000
in Hacker edition pro pset II, recognosceret, possetque quidam ex his user nomina ad minus.

556
00:31:12,000 --> 00:31:16,000
In dextro-manus manus pars sunt passwords, sed non es litteralis passwords.

557
00:31:16,000 --> 00:31:19,000
Sunt hashes ejus, et fit

558
00:31:19,000 --> 00:31:22,000
quod thesaurizantes passwords in a database est permalum idea.

559
00:31:22,000 --> 00:31:25,000
Youve omnes forsit legere ad quodvis punctum cuiuspiam website

560
00:31:25,000 --> 00:31:28,000
vel aliquam dolor database ens compromised, et tunc vos have ut

561
00:31:28,000 --> 00:31:31,000
mutare tortor, egestas ut quae refunds

562
00:31:31,000 --> 00:31:34,000
quia quidam mali guy actu erupit in rationem vestram inde laborem.

563
00:31:34,000 --> 00:31:38,000
>> Thesaurizantes passwords in clara textu, unencrypted in a database

564
00:31:38,000 --> 00:31:41,000
est omnino asininam, et tamen suus 'valde amusing

565
00:31:41,000 --> 00:31:44,000
deinde quod scriptum notum dolor aliquam

566
00:31:44,000 --> 00:31:47,000
quandoque in torculari cuius databases sunt suspectus,

567
00:31:47,000 --> 00:31:50,000
et quod pars non est funny, sed hoc quod databases continent unencrypted

568
00:31:50,000 --> 00:31:53,000
passwords est ridiculum, quia ad literam unam lineam of code

569
00:31:53,000 --> 00:31:57,000
vos tueri, potes contra quod particulares comminatio, et quod 'quis weve hic aguntur.

570
00:31:57,000 --> 00:32:00,000
Etiam pro fake paulo CS50 Oeconomi version

571
00:32:00,000 --> 00:32:03,000
Tesserae sunt tantum encrypting mensuram bonam, et quod

572
00:32:03,000 --> 00:32:07,000
$ $ I Primum est de his conventio passwords.

573
00:32:07,000 --> 00:32:10,000
Qui justis modis haerent encrypted vel vere hashed,

574
00:32:10,000 --> 00:32:13,000
quod est quasi unus-via encryption functio

575
00:32:13,000 --> 00:32:17,000
qua vos can non indulsit eius effectus cum aliquo vocavit MD5.

576
00:32:17,000 --> 00:32:21,000
>> Hoc quod L post illam est intelligitur quod sal valor

577
00:32:21,000 --> 00:32:24,000
de L adhiberetur ad hashing his omnibus passwords nisi pro una.

578
00:32:24,000 --> 00:32:27,000
Mihi quidem non ut vides, euge,

579
00:32:27,000 --> 00:32:30,000
erat usura a diversis sale vobis eorum qui got leviter tripped ascendit

580
00:32:30,000 --> 00:32:33,000
II Hacker fortasse qui usi fuissent ex nobis

581
00:32:33,000 --> 00:32:36,000
a diversus Nullam quam aliae propter mea password est actu eadem

582
00:32:36,000 --> 00:32:38,000
ex aliquo alio user sursum illic.

583
00:32:38,000 --> 00:32:41,000
Si enim omnes expectantes dies invenire fuistis

584
00:32:41,000 --> 00:32:44,000
quid illi passwords sunt hic erant passwords vos eo provocatus

585
00:32:44,000 --> 00:32:48,000
crack in Hacker edition of forsit paro II, ita qui plus captiosius.

586
00:32:48,000 --> 00:32:50,000
In facto, malan scriptor esset idem jharvard,

587
00:32:50,000 --> 00:32:54,000
Sed redeamus diversa respicere.

588
00:32:54,000 --> 00:32:58,000
>> Focus in jharvard purpura quia erant saliétur differenter.

589
00:32:58,000 --> 00:33:01,000
In algorithm erat perturbetur in a via ut

590
00:33:01,000 --> 00:33:05,000
Nullam extimatione encrypted valorem spectat paulo aliter

591
00:33:05,000 --> 00:33:08,000
quia inputs iam leviter alius, sed password subter cucullo

592
00:33:08,000 --> 00:33:10,000
erat adhuc ultimate vermiculus.

593
00:33:10,000 --> 00:33:12,000
Quis hoc curat?

594
00:33:12,000 --> 00:33:15,000
Sane, praebes vos cum sample users, in sample user nomina

595
00:33:15,000 --> 00:33:18,000
et hashes eorum passwords ita ut vos vere aliquam habent,

596
00:33:18,000 --> 00:33:23,000
teloneariorum pro CS50 Oeconomi ut vos primoris impetro excute tritum cum vestris code.

597
00:33:23,000 --> 00:33:27,000
Youll 'have ad effectum deducendi pluribusue mensis inside of MySQL, intus est database.

598
00:33:27,000 --> 00:33:30,000
Youll 'have creare plus spreadsheets, effective, sed nos certus dare vobis hoc uno

599
00:33:30,000 --> 00:33:33,000
incipe possidere et speciem problemate videamus tibi

600
00:33:33,000 --> 00:33:37,000
Quod ambulat super mensam importat ordinem vestrum

601
00:33:37,000 --> 00:33:39,000
et quoque explicando quod quidam de characteristics sunt,

602
00:33:39,000 --> 00:33:41,000
quin etiam tibi et providebo ut risus

603
00:33:41,000 --> 00:33:44,000
tractare hashing vel encryption horum passwords,

604
00:33:44,000 --> 00:33:49,000
Non itaque multum curaret de actu circa hujusmodi MD5.

605
00:33:49,000 --> 00:33:53,000
>> Sic, SQL, exstructa query lingua.

606
00:33:53,000 --> 00:33:56,000
Hoc est, simpliciter, lingua sumus circa ut satus usura in pset VII

607
00:33:56,000 --> 00:34:01,000
et forte ultra ad impe notitia ex aliqua database.

608
00:34:01,000 --> 00:34:06,000
Notitia est, rursus, condideris tabularly in his relationis mensas, columnarumque et ordines,

609
00:34:06,000 --> 00:34:09,000
sed usura aliqua relative simplex syntax quasi delete,

610
00:34:09,000 --> 00:34:12,000
inserere, update et elegere possumus exigo ut.

611
00:34:12,000 --> 00:34:15,000
Nos can delete a database, inserere,

612
00:34:15,000 --> 00:34:19,000
update data electa ut scilicet ex notitia datorum cipiat.

613
00:34:19,000 --> 00:34:21,000
Quomodo hoc facturus?

614
00:34:21,000 --> 00:34:23,000
Dimitte me grassor in INSTRUMENTUM.

615
00:34:23,000 --> 00:34:28,000
Dimitte me revellat http://localhost,

616
00:34:28,000 --> 00:34:30,000
quod iterum est locus INSTRUMENTUM.

617
00:34:30,000 --> 00:34:32,000
Ut 'eius default agnomen.

618
00:34:32,000 --> 00:34:35,000
Abeam ad / phpmyadmin.

619
00:34:35,000 --> 00:34:39,000
Hoc contingit esse speciale URL quod INSTRUMENTUM est preconfigured intelligere

620
00:34:39,000 --> 00:34:42,000
quod statim suggerit mihi pro a user nomen et password.

621
00:34:42,000 --> 00:34:46,000
>> More jharvard genus Aemilianus, et purpura,

622
00:34:46,000 --> 00:34:48,000
sed animadverto ut suus 'administrator rationem in computer.

623
00:34:48,000 --> 00:34:53,000
Suus 'iustus fortuitum ut illic' quoque a jharvard descripserunt pro CS50 Oeconomi.

624
00:34:53,000 --> 00:34:56,000
Jharvard coccino intra dapibus usura reddit quod sumus

625
00:34:56,000 --> 00:34:59,000
modo perceptio et illud parum superanti primo

626
00:34:59,000 --> 00:35:02,000
quies autem exploratum habeto, vestri 'nunquam habiturus ut click plerique links in hoc instrumentum.

627
00:35:02,000 --> 00:35:05,000
Youll 'terminus sursum usura a parva subset, qui sunt superessentialem prodest,

628
00:35:05,000 --> 00:35:08,000
quarum prima est databases ascendit hic.

629
00:35:08,000 --> 00:35:11,000
Si ascendam databases attende facere promptus sum datorum.

630
00:35:11,000 --> 00:35:14,000
Hoc enim perinde est creando novum Praecedo lima, effective.

631
00:35:14,000 --> 00:35:18,000
Ego hunc praecedere, et concionum, et in acie agnoscere Im 'iustus iens collat.

632
00:35:18,000 --> 00:35:20,000
Mauris sit ad imaginem ea

633
00:35:20,000 --> 00:35:24,000
Nullam et Aemilianus, creamus et nunc intendat facere ut dimittere

634
00:35:24,000 --> 00:35:27,000
Nihil ibi de sinistrali parte databases

635
00:35:27,000 --> 00:35:30,000
Ne ego mox videbis auditorio database.

636
00:35:30,000 --> 00:35:32,000
>> Si igitur jam click ad sinistrum-manus manus pars, concionum database,

637
00:35:32,000 --> 00:35:34,000
animadverto meus tabs mutare pauco.

638
00:35:34,000 --> 00:35:38,000
Ive 'got structura, SQL, export, important et quaedam alia.

639
00:35:38,000 --> 00:35:40,000
Structura est pulchellus ultum vacuam scripsisti.

640
00:35:40,000 --> 00:35:43,000
Non mensas found in database, sicut hic dicitur,

641
00:35:43,000 --> 00:35:47,000
ita quod simul tabulae et eamus simul et tabula ante

642
00:35:47,000 --> 00:35:53,000
similis alumni, et quot columns operor nos volunt?

643
00:35:53,000 --> 00:35:55,000
Sit ne simplex et omnium studiosorum memoriam sui

644
00:35:55,000 --> 00:35:58,000
an ID numero qui est nomen et email oratio.

645
00:35:58,000 --> 00:36:02,000
>> Puteus 'custodiunt illud simplex similis, sic III columnas, vade.

646
00:36:02,000 --> 00:36:05,000
Iam videtis formam parum superanti et nuntius,

647
00:36:05,000 --> 00:36:08,000
sed nos iustus have ut vado per eam row a row, ita realiter cito lets dare

648
00:36:08,000 --> 00:36:14,000
prima columna in hoc database nomen ID pro unique Identifier.

649
00:36:14,000 --> 00:36:17,000
Erit integer. Ego possit actu ignoratorum longitudine et valores.

650
00:36:17,000 --> 00:36:21,000
An int est iens futurus XXXII bits quidquid illud est quod typus in inde ut lets relinquatis eam vacuam scripsisti.

651
00:36:21,000 --> 00:36:24,000
Suspendisse pretium, nulla fieri posse, ut definitur.

652
00:36:24,000 --> 00:36:27,000
Ego solus exire. Sit suus 'non fatigo super default valores.

653
00:36:27,000 --> 00:36:29,000
Sit volumen huc ad dextram, etc.

654
00:36:29,000 --> 00:36:31,000
Hoc est interesting.

655
00:36:31,000 --> 00:36:33,000
Lets grassor et aliquanto libitu dicunt quod IDs oportet esse unsigned.

656
00:36:33,000 --> 00:36:35,000
Lets non attero ulla numeri negative.

657
00:36:35,000 --> 00:36:37,000
>> Eamus 0 ad IV billion dare, vel accipe,

658
00:36:37,000 --> 00:36:40,000
Non solum igitur agri et tamen ibi tangatis quidquam eorum,

659
00:36:40,000 --> 00:36:43,000
sed tunc permitte mihi typus in nomen descendit hic,

660
00:36:43,000 --> 00:36:46,000
et tunc aliud erat email, ita in captura est email

661
00:36:46,000 --> 00:36:50,000
nomen quippe non integri, ita aliud est mutare pugnam.

662
00:36:50,000 --> 00:36:53,000
Evenit varchar, longitudine varia chari,

663
00:36:53,000 --> 00:36:56,000
similis est chorda in an SQL database

664
00:36:56,000 --> 00:36:59,000
at variae longitudinis, et ante quam habes indicare

665
00:36:59,000 --> 00:37:02,000
maxima longitudo fili sic placitum Ego aliquantulum

666
00:37:02,000 --> 00:37:05,000
per institutionem type CCLV ingenia.

667
00:37:05,000 --> 00:37:08,000
Possem totaliter dicere XXXII. Possem dicere 1,000.

668
00:37:08,000 --> 00:37:11,000
Vos genus postulo statuo pro teipso fundatur in vestri Mauris diam quid est

669
00:37:11,000 --> 00:37:14,000
Discipulus maximum numerum nominis ire aut paulo maiora

670
00:37:14,000 --> 00:37:17,000
sed quid suus 'nice de varchar est suus' non iens ut vastem

671
00:37:17,000 --> 00:37:19,000
CCLV bytes ex omni discipulam nomine dixit.

672
00:37:19,000 --> 00:37:23,000
Si suus 'DAVID suus' non iens ut uti totum CCLV bytes,

673
00:37:23,000 --> 00:37:26,000
sed tenetur illud superius sic CCLV nunc ibo ad placitum,

674
00:37:26,000 --> 00:37:30,000
viliorem esse disputandum, sed posset aliquo et inscriptionem electronicam

675
00:37:30,000 --> 00:37:34,000
CCLV consentaneum modo, sed etiam eadem disputatione poterimus.

676
00:37:34,000 --> 00:37:36,000
Ego autem ad huc aliud facere dextrum.

677
00:37:36,000 --> 00:37:40,000
>> Quis 'potens circa database quod possit operor multus of gravis exaltatione

678
00:37:40,000 --> 00:37:42,000
sive complexa quia opus te.

679
00:37:42,000 --> 00:37:46,000
In particulari, EGO vere non curo quid mea, studiosum est scriptor ID numeri sunt.

680
00:37:46,000 --> 00:37:49,000
Suus 'iustus destinatum a unique Identifier in a database

681
00:37:49,000 --> 00:37:52,000
sic EGO have a XXXII frenum succincta repraesentatione eam discipulam

682
00:37:52,000 --> 00:37:55,000
ita ut aliquod iter unice distinguendis eos

683
00:37:55,000 --> 00:37:58,000
II Davids ne puta in genere.

684
00:37:58,000 --> 00:38:01,000
Nam pulvinar AI Ego hanc coerceret, auto incremento

685
00:38:01,000 --> 00:38:04,000
ita ut database, MySQL, figuras, ex

686
00:38:04,000 --> 00:38:08,000
singuli quod noviter inserta studiosum scriptor ID est futurum esse.

687
00:38:08,000 --> 00:38:11,000
Curet etiam ut me non scripta,

688
00:38:11,000 --> 00:38:13,000
indice me quoque aliquid eligendum et lectus.

689
00:38:13,000 --> 00:38:17,000
Index stillabunt hic primarium, unica,

690
00:38:17,000 --> 00:38:19,000
indicem et full text.

691
00:38:19,000 --> 00:38:21,000
Fortasse potes conicere quod haec duo,

692
00:38:21,000 --> 00:38:24,000
tamen evenit in relationis databases

693
00:38:24,000 --> 00:38:28,000
vobis programmer vel database administrator adepto ut praeverure

694
00:38:28,000 --> 00:38:32,000
dare innuit ad database, ut quid agros

695
00:38:32,000 --> 00:38:34,000
in parva mensa speciali.

696
00:38:34,000 --> 00:38:37,000
>> Sicut id quod Ego in hoc

697
00:38:37,000 --> 00:38:42,000
prius est futurum indicem seu ut prima clavis.

698
00:38:42,000 --> 00:38:44,000
Quid his significaverit, per definitionem est illa ID amodo

699
00:38:44,000 --> 00:38:48,000
erit unice identify alumni in hac tabula.

700
00:38:48,000 --> 00:38:53,000
Non studiosum eandem habebit ID quoniam Im imponentesque hoc coactione, aut hoc index.

701
00:38:53,000 --> 00:38:55,000
Quae autem facturus est, dicturus est nobis fringilla

702
00:38:55,000 --> 00:38:58,000
MySQL qui ID speciali.

703
00:38:58,000 --> 00:39:03,000
Curo praesertim de ID, sic vade et praemittat vestram facere ludo notitia structura est scriptor magicae,

704
00:39:03,000 --> 00:39:05,000
alia aedificant lignum.

705
00:39:05,000 --> 00:39:08,000
B proprie dicitur aliquid factum est arbor, quae non spectant ago,

706
00:39:08,000 --> 00:39:11,000
tamen suus 'alia tali notitia structura simili in spiritu in binariae arbores

707
00:39:11,000 --> 00:39:15,000
et quod vult se, dicturum tamen suus

708
00:39:15,000 --> 00:39:18,000
ad database in hoc campo est ita magnum ut ego forsit

709
00:39:18,000 --> 00:39:22,000
inquirere possit quod velit, et aedificabo nonnulli putant praecedere

710
00:39:22,000 --> 00:39:25,000
notitia structura in memoria expediendam searches ita ut idealiter

711
00:39:25,000 --> 00:39:28,000
tempus semper id Curabitur et quam vel prope

712
00:39:28,000 --> 00:39:32,000
ut in aliquot accidere non quaerens quod non est futurum

713
00:39:32,000 --> 00:39:34,000
altissimi faciendo aditu.

714
00:39:34,000 --> 00:39:37,000
Sed primum potuit Suspendisse amet.

715
00:39:37,000 --> 00:39:41,000
>> In theoria, cujusvis email oratio est unica, nisi vestri 'communicansque aliquam rationem,

716
00:39:41,000 --> 00:39:45,000
sed usus fere non est quasi vinculum

717
00:39:45,000 --> 00:39:49,000
tamquam primario key quia si eius propositum est in vita est unice identify

718
00:39:49,000 --> 00:39:55,000
ordinibus in mensa tua, ibi 'haud causa uti CCLV bytes maxime

719
00:39:55,000 --> 00:39:58,000
ad unice identify alicuius si vos can adepto tollitur iustus IV bytes

720
00:39:58,000 --> 00:40:00,000
aut XXXII frenum int.

721
00:40:00,000 --> 00:40:03,000
In communi, primaria key debet esse brevis et succincta

722
00:40:03,000 --> 00:40:07,000
et idealiter quasi quaedam integri vel a magnus int, quo contingit esse LXIV scissionibus.

723
00:40:07,000 --> 00:40:11,000
Suspendisse nisi sit singularis et una et liniamenta database

724
00:40:11,000 --> 00:40:14,000
est ad exigendum singularitatem pro me.

725
00:40:14,000 --> 00:40:18,000
Eligendo unique hic iuxta email, quamvis email se

726
00:40:18,000 --> 00:40:21,000
est scrolled off screen, Im ', dicendo ad database

727
00:40:21,000 --> 00:40:23,000
non confidunt me.

728
00:40:23,000 --> 00:40:26,000
Noli me datorum inseres

729
00:40:26,000 --> 00:40:29,000
Suspendisse bis idem etiam stultus sum et non sum

730
00:40:29,000 --> 00:40:32,000
valde bona cum meis ifs et alibi ifs et actualis PHP codice

731
00:40:32,000 --> 00:40:37,000
et ego per accidens Sit user profiteretur cum existente email oratio

732
00:40:37,000 --> 00:40:40,000
database est adhuc alia level defensionis rectitudo

733
00:40:40,000 --> 00:40:44,000
Suspendisse ut quod non cadit in duplicata mensam.

734
00:40:44,000 --> 00:40:49,000
>> Sed contra est quod unum nomen probabiliter non vult

735
00:40:49,000 --> 00:40:51,000
quia tunc nunquam potuit esse II Davids aut II Mike Fabrorum, puta

736
00:40:51,000 --> 00:40:55,000
In datorum, ut unus puteus relinquere.

737
00:40:55,000 --> 00:40:58,000
Nullam ac nisi praecedere Ego bottom,

738
00:40:58,000 --> 00:41:02,000
spectat et omne bonum hic notandum

739
00:41:02,000 --> 00:41:04,000
nunc autem non est pars temporis nimis expendunt

740
00:41:04,000 --> 00:41:07,000
syntax est aliquantulus quod nos facere non tabulis

741
00:41:07,000 --> 00:41:10,000
quod saepe, sed ipsum SQL sermone

742
00:41:10,000 --> 00:41:13,000
Hic ego propter iustitiam syntaxi illustravit.

743
00:41:13,000 --> 00:41:18,000
Quid phpMyAdmin realiter facit, est creat web-substructio GUI pro vobis

744
00:41:18,000 --> 00:41:23,000
quibus vos potest salvare animas tempore et non have ut manually typus de

745
00:41:23,000 --> 00:41:26,000
satis longa SQL query amo ut.

746
00:41:26,000 --> 00:41:29,000
>> Praeterea, si vellet manually hunc mensa,

747
00:41:29,000 --> 00:41:32,000
sive ad quod nigrum et album promptus vel etiam in phpMyAdmin

748
00:41:32,000 --> 00:41:35,000
per usura hac altera tab, hoc SQL tab qua vos can typus in aliquo SQL queries

749
00:41:35,000 --> 00:41:38,000
vis ingenue hoc statim susceperunt me

750
00:41:38,000 --> 00:41:41,000
ut vere recordaberis cuncti syntax, et tum quoque ego forsit haberet

751
00:41:41,000 --> 00:41:45,000
quosdam typos, valet hoc instrumentum huiusmodi ac etiam profutura est.

752
00:41:45,000 --> 00:41:49,000
Vos potest incipere inferre quid syntax est

753
00:41:49,000 --> 00:41:52,000
justos per nice quod color coding qui phpMyAdmin est consummatio

754
00:41:52,000 --> 00:41:54,000
pro nostra visual oportunitas.

755
00:41:54,000 --> 00:41:56,000
Sed videamus iam est scriptor hoc facere instead.

756
00:41:56,000 --> 00:42:00,000
Dimitte me ad interserunt tab ad sursum, et dimittas me et praemittat inserere puta

757
00:42:00,000 --> 00:42:04,000
an ID de Sentiat 'narro-actu non curo.

758
00:42:04,000 --> 00:42:07,000
Auto suus 'iens incrementum. Ego de hoc vt database.

759
00:42:07,000 --> 00:42:11,000
Ego autem erit David, et meus email debet esse malan@harvard.edu.

760
00:42:11,000 --> 00:42:16,000
>> Lets grassor hic et posuit in Mike Smith, sicut alius unum.

761
00:42:16,000 --> 00:42:18,000
Ipse dabo nibh etiam

762
00:42:18,000 --> 00:42:22,000
quod puteus 'illum habeas esse smith@example.com,

763
00:42:22,000 --> 00:42:24,000
et tunc ubi incedo deinde?

764
00:42:24,000 --> 00:42:27,000
Bene, is vultus amo ambulas est puga pyga ut click, et voila.

765
00:42:27,000 --> 00:42:30,000
Animadverto in summitate II ordines inseruntur.

766
00:42:30,000 --> 00:42:32,000
Hoc est actualis SQL querit.

767
00:42:32,000 --> 00:42:36,000
Ut 'phpMyAdmin tool executi pro me,

768
00:42:36,000 --> 00:42:40,000
novissima autem notandum est, si Donec nunc tab

769
00:42:40,000 --> 00:42:43,000
est videre II ordines in hac tabula, valde simile aesthetically

770
00:42:43,000 --> 00:42:46,000
mensæ vidimus maturius in nostra users ex pset VII,

771
00:42:46,000 --> 00:42:51,000
ex quibus Malan David, de quo nunc O. Smith.

772
00:42:51,000 --> 00:42:54,000
Sed manifestum est, non phpMyAdmin usum,

773
00:42:54,000 --> 00:42:56,000
et quidem, vestri 'iens mox scriben codice pro pset VII

774
00:42:56,000 --> 00:43:01,000
qui automates processus of addendo ordines, supprimendi ordines, adaequationis ordines et similia,

775
00:43:01,000 --> 00:43:04,000
Itaque hic potius ite ad tab SQL

776
00:43:04,000 --> 00:43:14,000
et typus in selectis * ex alumni ubi

777
00:43:14,000 --> 00:43:18,000
email = "malan@harvard.edu."

778
00:43:18,000 --> 00:43:21,000
>> Alioquin si tibi hodie

779
00:43:21,000 --> 00:43:26,000
quidam HTML formam, et user species in eorum email oratio, inter alia agros,

780
00:43:26,000 --> 00:43:29,000
, et ad finem nunc est in PHP in dorso finis codice

781
00:43:29,000 --> 00:43:31,000
ut vere suspiciunt qui user scriptor alia details.

782
00:43:31,000 --> 00:43:34,000
Quis est vestri plenus nomen est? Quis est vestri ID numerum?

783
00:43:34,000 --> 00:43:37,000
Vos could scribere SQL query, sicut hic, elige * ex alumni

784
00:43:37,000 --> 00:43:40,000
ubi email = "malan@harvard.edu."

785
00:43:40,000 --> 00:43:46,000
Nullam et ego vadam si videris, mihi vero, ordine ulciscor iustum.

786
00:43:46,000 --> 00:43:50,000
Mike est praetermissa ex hoc eventu occumberet, sicut collectio rows

787
00:43:50,000 --> 00:43:53,000
vulgo vocatur, eo quod non eadem mihi erat volutpat.

788
00:43:53,000 --> 00:43:57,000
>> Nunc, rursus, hic pro pset VII youll uti phpMyAdmin sicut administrativi tool

789
00:43:57,000 --> 00:44:00,000
et paedagogica tool discere viam vestram

790
00:44:00,000 --> 00:44:03,000
SQL circa mundum, sed diei

791
00:44:03,000 --> 00:44:08,000
vestri 'iens ut haec scribens queries inside actualis PHP scripta,

792
00:44:08,000 --> 00:44:11,000
et sic subsisto tuned in Zamyla scriptor walkthrough in particulari

793
00:44:11,000 --> 00:44:14,000
ubi youll 'adepto a spectatum irent distributio codice hoc problema Posueruntque

794
00:44:14,000 --> 00:44:18,000
ubi nos data vobis non solum AESTHETICA pro login page

795
00:44:18,000 --> 00:44:21,000
et compleo parum pudici logo quod dicit quod CS50 Oeconomi, sed nos hic illud etiam datum vobis

796
00:44:21,000 --> 00:44:24,000
fasciculum faciant opera vitae vehicula tellus.

797
00:44:24,000 --> 00:44:27,000
Scriptum pset diximus de vobis

798
00:44:27,000 --> 00:44:32,000
usuarii pars in parte dare consilium sensu repraesentativo

799
00:44:32,000 --> 00:44:36,000
ut etiam utitur controller, puta index.php,

800
00:44:36,000 --> 00:44:40,000
login.php et huiusmodi, et tunc youll videre pset etiam habet templates presul

801
00:44:40,000 --> 00:44:43,000
quod omnes habet quid sentias, omnibus de AESTHETICA.

802
00:44:43,000 --> 00:44:46,000
Et sic altiore Lorem Ipsum in pset VII futurum est qui

803
00:44:46,000 --> 00:44:49,000
vestra users visitant controller via a URL in pasco.

804
00:44:49,000 --> 00:44:53,000
Qui controller continet PHP codice quae scripsisti, et inside of vestri PHP codice

805
00:44:53,000 --> 00:44:57,000
posset aliquot lineas de SQL habitant in inter duplici quotes

806
00:44:57,000 --> 00:45:00,000
et transivit functioni ipsarum scripsimus vocavit query

807
00:45:00,000 --> 00:45:03,000
ut mos succurro vos loqui quasi sine database

808
00:45:03,000 --> 00:45:05,000
administrativi tool quasi phpMyAdmin.

809
00:45:05,000 --> 00:45:08,000
>> Eris scribere possit SQL affirmateque PHP codice

810
00:45:08,000 --> 00:45:11,000
et posside tergum PHP array ex eventu occumberet,

811
00:45:11,000 --> 00:45:14,000
de rows ut etiam aequas, qui querit.

812
00:45:14,000 --> 00:45:18,000
Et similiter poteris facere interserit aut delet

813
00:45:18,000 --> 00:45:22,000
aut updates aut similibus, syntaxum pro qua est modice simile,

814
00:45:22,000 --> 00:45:25,000
quod youll 'animadverto ab aliqua online references, a distributio codice

815
00:45:25,000 --> 00:45:29,000
et ex pset stipant ipsa exacte quomodo circuibunt faciens quod.

816
00:45:29,000 --> 00:45:33,000
Cogita ultimate erant 'vere iustus scalpendi superficies SQL

817
00:45:33,000 --> 00:45:36,000
MySQL et tamen vere est quia liberat te de manu

818
00:45:36,000 --> 00:45:40,000
sis quaestiones solvere intendunt, quibus opus aggredi voluisti

819
00:45:40,000 --> 00:45:43,000
non minus sine cura, vel mane,

820
00:45:43,000 --> 00:45:47,000
circa ubi et quomodo congregem et investigare vestri database,

821
00:45:47,000 --> 00:45:50,000
et hoc est omnino litteram ubi Facebook ipsa accepit satus

822
00:45:50,000 --> 00:45:53,000
usura MySQL et tunc utendum pluribus MySQL servientibus et deinde, MySQL servientibus

823
00:45:53,000 --> 00:45:57,000
ante diu donec tunc haberent ut vere satus ratus durum, qualiter

824
00:45:57,000 --> 00:46:00,000
copia notitia, quomodo congregem ea etiam quae efficacius

825
00:46:00,000 --> 00:46:04,000
ut posito quod quamvis Maximus et singulari sumere termi

826
00:46:04,000 --> 00:46:08,000
Lorem ipsum dolor sit conuersationis et huiusmodi negotium iustum

827
00:46:08,000 --> 00:46:12,000
quod hoc potest omnes eventually ducunt ad, ita animadverto ut erant 'iustus scalpendi superficiem

828
00:46:12,000 --> 00:46:17,000
Quo tandem eventually pro vobis vel vestri exertus, totus efficior aliquantulus of magnus notitia.

829
00:46:17,000 --> 00:46:22,000
>> Cum dixit, hic finis, aperientur oculi vestri et proxima septimana.

830
00:46:28,000 --> 00:46:30,000
[CS50.TV]