Maybe this will be a surprise, but I think that more than 90% of the webpages that use MySQL, use it do exactly what you are wondering about..
Not only are the searches a lot easier, but if you do it right you can make a website which won't contain any dead links... (By generating links to other pages from the database.) The basic idea is though to make some kind of template in PHP which contains all the HTML code and that you store all text data in the database.. This text-data is then fitted between te HTML tags when you call the page.. (If you do it right (in my opinion) you will have a database which only consists of data, and PHP pages which only contains PHP code echoing HTML code with record information from the database.. When using BLOBs etc I can't see that you will ever run into limitations unless you are doing something silly.. Try it...! > Out of interest, would it be possible to load a webpage as a record in a > MySQL database, having another field as say a number or a unique name so > that a whole site could be placed in a database with a couple of php files? > Is there a limit on the size of a field in MySQL which would stop you doing > this though and would it be noticeably slower that html / php files? > I was only wondering as it would make full text searches an awful lot > simpler!!!! > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
