Flash. Posteet: Store, share and tag your favourite tips, tricks, codes and snippets. S o l u t o i r e . c o m - ajax resources. Creating a Code Search Engine with PHP and MySQL. I'm just a few days away from launching a comprehensive support website for my book, "Beginning PHP and MySQL 5, Second Edition", and among other features, have built a search engine for sifting through the more than 500 code snippets found throughout the book.
This was an interesting exercise because it involves a number of storing a fairly significant amount of text within a MySQL database, using MySQL's full-text search facility, and devising an effective way to extract and display the code in the browser. In this article I'll offer a simplified version of this search engine, introducing you to some compelling PHP and MySQL features along the way. You might adopt what you learn towards building your own search engine, or towards other applications. The Database Schema Just a single table is required for the engine's operation. SiteTimer. About SiteTimer For more generic/non technical information about OctaGate SiteTimer, please see this version of the page.
Technical Details About SiteTimer (it uses AJAX!) Unless you're familiar with AJAX , you might want to read this page about AJAX first. SiteTimer uses JSON instead of XML, because JSON faster and lighter. There are currenly one SiteTimer server, located in Stockholm (Sweden) that performs the actual page downloads.