Sorry guys – I have found a kickstarter clone script I can modify for my needs so this request is closed.
Thanks. As one of the links you provided says:
The big downside of this method is that you need to modify the query if a category is added. This can be solved though by dynamically creating the query in a PHP script.
That’s what I’m looking for…
Yes…Pentaho is one of the 3rd party open source report writers that do crosstabs. The paid for PHP Report Maker even generates the php code for you. I’m just looking for a php script specifically for crosstabs rather than a whole report writing tool.
I think you’ve misunderstood what I’m looking for. I can already generate crosstabs in sql without the use of navicat or any other tool other than sql itself.
I’m looking for a php script that can generate and display crosstabs based on setting a handful of parameters in the code. Lots of report writers, Excel etc. can generate crosstabs directly from a database but I’m after a php script to do this so I can integrate it into a site without the need for a 3rd party tool, exporting to Excel etc.
Looking to pay for for a simple parameter driven crosstab generator in php that cross tabulates data across two mysql tables with a FK relation e.g
product down the side (ROW) location across the top (COL) SUM (e.g. amount) OR COUNT (e.g. matches) in the intersection (CELL)
So there’s a product table (for xtab row names) and a sales table with a product_id (FK) column (for the xtab join) and a location column (for the xtab columns – that may be a foreign key to a location table) and an amount column (for the xtab SUM )
If you’re familiar with crosstabs you’ll know what I mean…
Widgets are starting to appear for integration with Twitter Bootstrap. I would like a new marketplace to buy them from.
I have created a number of basic google charts for my php pages that display data extracted from a mysql db. Looking for a google chart api savvy dev to rev my charts and get me over some roadblocks.
Looking for XML savvy dev to help with creating a php import script to import an XML file and shred it into a mysql database.
That’s a nice UI – you’re not using Adminica off Codecanyon by any chance?
cfoinfo saidYes, for example: http://codecanyon.net/item/sql-document-generator/full_screen_preview/120985 . Let me know if you want to cooperate.
I’m also interested in finding someone who can do this kind of work i.e. PDF export of data stored in mysql tables. So Quanticalabs also let me know if this is something you’ve done before. I have hired someone to do this before myself using fpdf and it worked fine.
QL – my memory is going…I actually bought your script and commented on it. So should have remembered you have some experience with this… I would be looking for help to compile a more complex PDF from multiple tables that simply printing out a table to a PDF file.