1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
|
<!--startcut BEGIN header ==============================================-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML><HEAD>
<title>Developing Web Applications at Home - Part 1 LG #47</title>
</HEAD>
<BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#0000AF"
ALINK="#FF0000">
<!--endcut ============================================================-->
<H4>
"Linux Gazette...<I>making Linux just a little more fun!</I>"
</H4>
<P> <HR> <P>
<!--===================================================================-->
<center>
<H1><font color="maroon">Developing Web Applications at Home - Part 1</font></H1>
<H4>By <a href="mailto:afsilva@liberty.edu">Anderson Silva</a></H4>
</center>
<P> <HR> <P>
<!-- END header -->
<P ALIGN=LEFT STYLE="margin-bottom: 0in"> One of my favorite things
about linux is that it allows me to have a full-featured server at
home for a very small price. I have a 3 computer network at home, and
my router is a simple Intel Pentium 133 w/ 32 MB RAM and 1.7 Gb HD.</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"> That machine which run on
Red Hat 6.0 is my router, dns server, firewall/proxy server, samba
server, and my web server, and it runs great. I must tell you that
the only reason that I shut that server off is when there are
thunderstorm warning in my city, but other than that the machine runs
flawless.</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"> And the reason for this
article is to allow you to run your own web applications of your
computer, even if your machine is a small Pentium 133 like mine. I
normally, write articles that are aimed for the newbies simply
because I think they need much more support than the "older"
guys do, and this article is no different.</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"> I would like to introduce
to you a scripting language called PHP. And for you that prefer
another language such as PERL, ASP or Cold Fusion, all I can say is
"don't get mad at me just because I did not choose your
favorite language".</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"> PHP is a server dependent
scripting language that can be embedded on HTML, and according to its
documentation it was created "sometime in the fall of 1994".
If you decide to play around with PHP you will notice that its syntax
is very similar to C, so if you have any programming experience with
C, C++ or even Java, programing on PHP should be a breeze.
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"> The greatest thing about
PHP is that it allows you to make web sites that will interface with
several types of databases. A few examples are:</P>
<UL>
<UL>
<UL>
<UL>
<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in">Oracle</P>
<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in">Sybase</P>
<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in">mSQL</P>
<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in">MySQL</P>
<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in">ODBC</P>
<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in">dBase</P>
<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in">and many others...</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"></P>
</UL>
</UL>
</UL>
</UL>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"> This article will show you
how to install PHP version 3 (PHP3) on a RedHat System that is using
MySQL as its database. <B>Note:</B><SPAN STYLE="font-weight: medium">
RedHat's full install will install PHP3 all ready to work with
PostgreSQL database.</SPAN></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
</P>
<OL TYPE=I>
<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT SIZE=4><SPAN STYLE="font-weight: medium">Installing
MySQL:</SPAN></FONT></P>
<OL>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"></P>
</OL>
</OL>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"> You
can download MySQL from:</P>
<OL TYPE=I>
<OL>
<OL>
<OL>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"><A HREF="http://www.mysql.com/download_3.22.html"><SPAN STYLE="font-weight: medium">http://www.mysql.com/download_3.22.html</SPAN></A></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"></P>
</OL>
</OL>
</OL>
</OL>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"><SPAN STYLE="font-weight: medium"> If
you are running Red Hat, I would recommend to you to download the
RPMs for the database. Download:</SPAN></P>
<OL>
<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium">
The Server - MySQL-3.22.27-1.i386.rpm</P>
<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium">
The Client - MySQL-client-3.22.27-1.i386.rpm</P>
<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium">
The Development Libraries - MySQL-devel-3.22.27-1.i386.rpm</P>
</OL>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"> <B>Note:</B>
MySQL 3.22.27 is the most recent-stable version as of the day this
article was written.</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"> Once
you have downloaded all three files, run the following command as
root:</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"> <B>rpm
-ihv MySQL-*</B></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"><B> </B><SPAN STYLE="font-weight: medium">This
should install all of the MySQL packages you have downloaded.</SPAN></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<OL TYPE=I START=2>
<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=4>Learning
MySQL:</FONT></P>
</OL>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=4> <FONT SIZE=3>Learning
the basics of MySQL should not be a challenge because of two main
reasons:</FONT></FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<OL>
<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium">
<FONT SIZE=3>Online Documentation is very well organized, and
helpful.</FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>It can
be found at: <A HREF="http://www.mysql.com/doc.html">http://www.mysql.com/doc.html</A></FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"></P>
<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium">
<FONT SIZE=3>Graphical User Interfaces that are available on
the web to make MySQL administration much easier. </FONT>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>You
can find a whole list of GUI Clients for MySQL at:
<A HREF="http://www.mysql.com/Contrib/">http://www.mysql.com/Contrib/</A></FONT></P>
</OL>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<OL TYPE=I START=3>
<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=4>Installing
PHP3:</FONT></P>
</OL>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=4> <FONT SIZE=3>As
I said in the beginning of this article RedHat already comes with the
RPM for the installation of PHP3, but by default it is setup to
support PostgreSQL. And to make this RPM work with MySQL is not hard
at all, thanks to great F.A.Q. whic can be found at the PHP official
web site (http://www.php.net). </FONT></FONT>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3> To
solve this problem I quote the F.A.Q. section from the PHP web site.</FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium">
</P>
<BLOCKQUOTE>
<P> 3.3 I installed PHP using RPMS, but it doesn't compile with the
database support I need! What's going on here?</P>
<P> Due to the way PHP
is currently built, it is not easy to build a complete flexible PHP
RPM. This issue will be addressed in PHP4. For PHP, we currently
suggest you use the mechanism described in the INSTALL.REDHAT file in
the PHP distribution. If you insist on using an RPM version of PHP,
read on...
<P> Currently the RPM packagers are setting up the RPMS to install
without database support to simplify installations AND because RPMS use
/usr/ instead of the standard /usr/local/ directory for files. You need
to tell the RPM spec file which databases to support and the location
of the top-level of your database server.</P>
<P>This example will explain the process of adding support for the
popular MySQL database server, using the mod installation for
Apache.</P>
<P>Of course all of this information can be adjusted for any database
server that PHP supports. I will assume you installed MySQL and
Apache completely with RPMS for this example as well. </P>
<P>First remove mod_php3
<P> rpm -e mod_php3
<P> Then get the source rpm and INSTALL it, NOT --rebuild
<P> rpm -Uvh mod_php3-3.0.5-2.src.rpm
<P> Then edit the /usr/src/redhat/SPECS/mod_php3.spec file
<P> In the %build section add the database support you want, and the
path.
<P> For MySQL you would add --with-mysql=/usr \
<P> The %build section will look something like this:
<P> ./configure --prefix=/usr \
<P> --with-apxs=/usr/sbin/apxs \
<P> --with-config-file-path=/usr/lib \
<P> --enable-debug=no \
<P> --enable-safe-mode \
<P> --with-exec-dir=/usr/bin \
<P> --with-mysql=/usr \
<P> --with-system-regex
<P> Once this modification is made then build the binary rpm as
follows:
<P> rpm -bb /usr/src/redhat/SPECS/mod_php3.spec
<P> Then install the rpm
<P> rpm -ivh /usr/src/redhat/RPMS/i386/mod_php3-3.0.5-2.i386.rpm
<P> Make sure you restart Apache, and you now have PHP with MySQL
support using RPM's. Note that it is probably much easier to just
build from the distribution tarball of PHP and follow the instructions
in INSTALL.REDHAT found in that distribution.
</BLOCKQUOTE>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3> Another
problem is that some distributions (including RedHat) that also come
with PHP3 installed, don't have PHP3 activated on Apache's
configuration file. To solve this problem again we count on the PHP3
F.A.Q. session.</FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="helvetica, sans-serif"><FONT SIZE=2><B> </B></FONT></FONT></P>
<BLOCKQUOTE>
I installed PHP using RPMS, but Apache isn't processing the PHP
pages! What's going on here? Assuming you installed Apache PHP
completely with RPMS, you need to uncomment or add some or all
of the following lines in your http.conf file:
<PRE>
# Extra Modules
AddModule mod_php.c
AddModule mod_php3.c
AddModule mod_perl.c
# Extra Modules
LoadModule php_module modules/mod_php.so
LoadModule php3_module modules/libphp3.so
LoadModule perl_module modules/libperl.so
</PRE>
<P> And add:<BR>
<TT>AddType application/x-httpd-php3 .php3</TT><BR>
To the global properties, or to the properties of the VirtualDomain
you want to have PHP support added to.
</BLOCKQUOTE>
<P> If you have successfully installed MySQL, re-installed PHP3, and
activated PHP3 in you Apache configuration you should be all set to
start using PHP3.</FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3> <B>Note:
Once you are done changing the Apache configuration make sure you
restart it.</B></FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT SIZE=3><B> Quick Test:</B></FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3> This
is a quick test for you to try, and see if php3 is running correctly
in your system:</FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3> Go
to your web root directly (RH systems at: /home/httpd/html), and
create the following file and name it <B>phptest.php3</B>.</FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3> <?</FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3> echo
"<HTML>\n";</FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3> echo
"<HEAD><TITLE>Hello World!</TITLE></HEAD>\n";</FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>
echo "Testing PHP3 with Hello World!\n";</FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>
?></FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3> And
the open you web browser, and you should get just the formatted web
site. If you do get that, you should be all set to start using PHP3.
If you have not been able to get the right results, I would suggest
you to check out PHP's web site at: <A HREF="http://www.php.net/">http://www.php.net</A></FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3> Next
month, I will send in a couple of more complex examples with some
data entry on a MySQL database.</FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3> </FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>The
texts that are found inside a table were extracted from the PHP3 Web
Site.</FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<DL>
<DD>
<TABLE WIDTH=413 BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
<COL WIDTH=403>
<THEAD>
<TR>
<TD WIDTH=403 VALIGN=TOP>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>PERMISSION
NOTICE:
</FONT>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>Javascript/PHP
code used with permission of the PHP </FONT>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>Development
Team.
</FONT>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>Copyright
1998. All rights reserved.
</FONT>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>
</FONT>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>For
more information on the PHP Development Team and
</FONT>
</P>
<P ALIGN=LEFT STYLE="font-weight: medium"><FONT SIZE=3>the PHP
project, please see <http://www.php.net>. </FONT>
</P>
</TD>
</TR>
</THEAD>
</TABLE>
</DL>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>
</FONT>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3> </FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3> </FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"> </P>
<OL TYPE=I>
<OL>
<OL>
<OL>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"></P>
</OL>
</OL>
</OL>
</OL>
<P ALIGN=CENTER STYLE="margin-bottom: 0in"><BR>
</P>
</BODY>
</HTML
<!-- BEGIN copyright ==================================================-->
<P> <hr> <P>
<H5 ALIGN=center>
Copyright © 1999, Anderson Silva<BR>
Published in Issue 47 of <i>Linux Gazette</i>, November 1999</H5>
<!-- END copyright ===================================================-->
<!--startcut footer ===================================================-->
<P> <hr> <P>
<A HREF="index.html"><IMG ALIGN=BOTTOM SRC="../gx/indexnew.gif"
ALT="[ TABLE OF CONTENTS ]"></A>
<A HREF="../index.html"><IMG ALIGN=BOTTOM SRC="../gx/homenew.gif"
ALT="[ FRONT PAGE ]"></A>
<A HREF="reid.html"><IMG SRC="../gx/back2.gif"
ALT=" Back "></A>
<A HREF="../faq/index.html"
><IMG SRC="./../gx/dennis/faq.gif"
ALT="[ Linux Gazette FAQ ]"></A>
<A HREF="slambo.html"><IMG SRC="../gx/fwd.gif" ALT=" Next "></A>
<P> <hr> <P>
</BODY></HTML>
<!--endcut ============================================================-->
|
