Electronic Books

The address must begin with
http:// for this to work.
2 Type a letter or two and click GO.
3 The PHP page should show the results.
4 Go back to the form, and
repeat Steps 2 and 3 until your
heart??™s content.
96 creating a search
extra bits
add the form p. 91
??? In this example, I suggest that
users only enter a couple of letters
because the database only
has 20 records in it. With the
employees entered in Chapter 1,
???creating the database,??? Gr will
return two records but Gre only
one. If your database had more
names in it, entering longer values
would be appropriate.
??? The GET method is normally used
with searches. The next time you
use Google or some other search
engine, notice that the search
terms are passed along in the
URL.
query the database p. 93
??? This is the most complicated
query in the book. It performs
a JOIN across two tables:
employees and departments,
which are linked through the
department_id columns. The
search feature is possible thanks
to a LIKE clause, asking for
records where the employee??™s
last name begins with whatever
letters were entered in the form.


Pages:
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