PHP does not use a universal ADODB type structure, so the script you use
would depend on the type  of DB that you  are searching (0racle, DB2, MySQL,
SQLServer etc....).

>So we are talking thousands
> upon thousands of records.

Any of the above DBMS' can handle millions upon millions of records in their
stride. Of interest to me is that in a recent  public benchmark, MySQL
(Licence Fee's 0$) proved to be the fastest of all the mainstream DBMS!

Note that all these different DB's are SQL compliant, so they would probably
use the same SQL statements, and you would only need to adjust the PHP-DB
linking code. Information on this can be found in the PHP manual. For
example for Oracle look at:

http://www.ca.php.net/manual/en/ref.oracle.php

> I know nothing about PHP or SQL...

Unfortunately there is quite a steep learning curve for both of these
languages. Best of Luck :)

Probably NVHIA ! (Not Very Helpful I'm Afraid)

Frank


----- Original Message -----
From: "Brandon Coughlin" <bcoughlin(at)urx.com>
To: "Hwg-Techniques(at)Hwg.Org" <hwg-techniques(at)hwg.org>
Sent: Tuesday, March 19, 2002 7:24 PM
Subject: Re: A Good PHP Script


> In a nutshell, it would be search FCC records.  So we are talking
thousands
> upon thousands of records.  I was thinking too that I would need to write
> something specific for my needs, I highly doubt that I will find anything
> that will work.  But I thought I would go ahead and give it a shot.  But I
> am mainly just looking for a generic database search engine that is close
to
> what I need, that I can "tear apart" and try to build one that is more
> specific.  I know nothing about PHP or SQL.  So I am just winging it.  The
> website I am working on isn't going to generate much (if any) money at
all.
> So I am trying to keep costs to a minimum.  That is why I have chosen not
to
> hire anyone... yet.
>
> Thanks for the suggestions
> Brandon
>
> ----- Original Message -----
> From: "Jami Moore" <jami(at)jamisniche.com>
> To: "Brandon Coughlin" <bcoughlin(at)urx.com>; "Hwg-Techniques(at)Hwg.Org"
> <hwg-techniques(at)hwg.org>
> Sent: Tuesday, March 19, 2002 4:03 PM
> Subject: Re: A Good PHP Script
>
>
> Why not try searching PHPBuilder.com or The PHP Resource Index
> (http://php.resourceindex.com/). PHP Builder offers source code snippets,
> and The Resource offers full scripts for all categories, including
> Databases. HTH.
>
> --
> Jami
> http://www.jamisniche.com/
>
>
> ----- Original Message -----
> From: "Brandon Coughlin" <bcoughlin(at)urx.com>
> To: "Hwg-Techniques(at)Hwg.Org" <hwg-techniques(at)hwg.org>
> Sent: Tuesday, March 19, 2002 4:47 PM
> Subject: A Good PHP Script
>
>
> > I am looking for a stable, easy to use PHP script to search an SQL
> > database - a rather large one at that.  Any suggestions?  Of course,
free
> or
> > cheap is preferred - any suggestions appreciated.
> >
> > Thanks
> > Brandon
> >
> >
> >
>
>
>

• Web Designer Courses
• Off the Shelf Training Courses

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA