My PHP , Wordpress and Linux Lab

A couple of users thankfully pointed out the issues with the paths, as i am stuck with windows as a development platform,  case sensitive directory names mess things up on Linux. So very minor updates to a few files.

Also PLEASE read the README file provided in the zip for the instructions on how to set up the application.  PHP Viz needs a database for storing the configurations and settings, so that must be created by using the SCHEMA.sql provided.

Download PHP Viz 0.2.1

Full text searches have been the one part which would always worry me in any project which will hold a reasonable amount of data with a decent traffic.  Not anymore!

I have been using Sphinx for a while and i have been really impressed. Easy deployment, easy integration and its pretty flexible as well. I cant say that i have explored everything it has to offer but whatever I needed it to do, it surely did for me.

Among other features you can use it to rank , filter ,  group , sort and query to targeted columns. It even supports “Sounds like” searches ….. wonderful! .  With several different matching and ranking modes , ones got to be right for you.

The PHP Client is a pure PHP implementation, so no deployment headaches. The PHP client API is included in the download package, hook it up with your DB wrapper and you are ready to battle with those Full Text Searches. What it would do is .. it would return to you the ranked record IDs, along with weights and then you can bring the full record of that ID directly from MySQL. Response times from Sphinx are amazing, So far I haven’t seen it take more than 0.7 seconds to return the resultset. Best of all, you can scale as much as you need, without any problems.

Here are the key features taken from their site directly:

• high indexing speed (upto 10 MB/sec on modern CPUs)
• high search speed (avg query is under 0.1 sec on 2-4 GB text collections)
• high scalability (upto 100 GB of text, upto 100 M documents on a single CPU)
• supports distributed searching (since v.0.9.6)
• supports MySQL natively (MyISAM and InnoDB tables are both supported)
• supports phrase searching
• supports phrase proximity ranking, providing good relevance
• supports English and Russian stemming
• supports any number of document fields (weights can be changed on the fly)
• supports document groups
• supports stopwords
• supports different search modes (“match all”, “match phrase” and “match any” as of v.0.9.5)
• generic XML interface which greatly simplifies custom integration
• pure-PHP (ie. NO module compiling etc) search client API

Amazing stuff! So if you are in the business of developing high volume traffic and/or data sites … you have to check it out for sure! Its available for both Linux and Windows platforms!

2 Thumbs Up for these guys!

It brings me tremendous pleasure to announce the first public release of PHP Viz.

PHP Viz is an open source PHP code generator , which is also written in PHP 5 , released under the GPL license. It allows you to create MySQL based sites rather than just pages. The resulting sites follow a very simplified MVC pattern, which allows re-usability and partitioning of code.

The best feature PHP Viz provides is the linking of Primary keys to Foreign keys and allows you to display records from linked tables. You can create modules for adding , editing , deleting and viewing data. Once you have created your modules, you can create pages which hold one or more of your modules. Reusing these modules in custom code is pretty easy as well and allows you create independant entities which can be plugged into any page.

The application is in a very early stage of development and I am hoping to get alot of feedback, based on which I will prioritize the features that need to go in there.  Soon I will make available an online demo version as well for quick viewing of all the features.

Please read the README file found in the zip to find the install instructions.

Please feel free to put in any comments and feedback in the comments area.

Download PHP Viz 0.2

Update : Sorry guys the link was broken earlier , thanks to some nifty logic in WordPress , should be working now!

Some screenshots below:

Main Screen

Site Modules And Pages

Module Settings

Generated Site Login Screen

Generated Site View Data Screen

UPDATE: Please turn on “short open tags” in php.ini .. i will try to remove all the short tags in the next release.  My apologies for this oversight.

I have been so busy over the past 2 years that I almost forgot about this code generator that I started to write. But recently i resumed work on this and created a new version from scratch.  and I am very happy with the results so far

PHP Viz is written in PHP and lets you create MySQL driven PHP sites. A prime feature it provides is the support to link up multiple tables (based on foreign and primary keys) and create views from them.

The application lets you create “sites” rather than simple pages. You can even have Login protection on your site if you have a users table in there somewhere in your database. All the basic functions are there , you can create tabular views, single record view , add and edit view. The generated code is very clean , simple and based on a very very simplified MVC architecture. This allows for expansion and code re-usability with ease.

The application code itself  is very rough at this point and i just want to see some feedback from the community to make sure that i am heading in the right direction. I am hoping to add some more advanced level features down the line and hoping to make this an every day tool for the PHP developer.

PHP Viz 0.2 should be publicly available within the next week. I am hoping that the next Site Admin you make is built by PHP Viz