MySQL PHP Table Viewer with Pagination and Sorting

Basic PHP MySQL table viewer. Just tell it the table you want to view and it does all the rest! Automatically lists all your fields and values for specified table; providing ASC and DESC sorting for each. Also has prevnext and number paging.

Options include:

  • Nice fields (on/off) – “field_name” gets changed to “Field Name”
  • Page numbers (on/off)
  • Prev / Next (on/off)
  • Limit per page

Demo / Download:
http://blog.drale.com/tableview/

GitHub:
http://github.com/drale/DBTableViewer

Screenshot:
screenshot

Import NetStumbler Data To MySQL Database

Wrote a little program that imports your NetStumbler text file export into a MySQL database. Very simple program that runs automatically using the data file uploaded into same directory. No fancy file uploading nor does it include viewing and sorting or doing anything with the data, yet. It also does not check against previous entries, so you’ll have to dump your MySQL before importing again.. The newest release checks for duplicates using MAC on import. That is up to you what you need it in a database for.

(excuse my poor versioning, etc, first time really trying to keep up with version numbers, details of improvements and GPL)

ns2db-v1.1b-with-viewer.zip – bug fix for lat/long field (thanks pixel), checks against MAC to prevent duplicates on import

ns2db-v1.1b.zip – added table view of data

ns2db-v1.0.zip

NetBeans PHP Project on Dreamhost Advanced Setup

This guide will show you how to setup a PHP project in NetBeans covering a complicated situation, such as files behind public root. PHP support is new in NetBeans so hopefully this guide will help some new comers to NetBeans that want to use it for PHP websites.

What some may experience when first using an IDE such as NetBeans or Dreamweaver is the native tendency for these programs to guess what is best for you when it comes to your project paths and live site paths. One may be fustrated that when running their project off the IDE it will point them to someting like http://www.domain.com/www.domain.com/testfile.html or upload their files to a similar wrong location in FTP. Especially when trying to mirror the directory structures and names locally and on the server. With the proper setup this can be avoided.

Continue reading NetBeans PHP Project on Dreamhost Advanced Setup

You don’t have permission to access /php/php-cgi.exe/index.php on this server. PHP 5 on Apache 2.2

Did you get this on your fresh install of PHP5 on Windows?

Forbidden
You don’t have permission to access /php/php-cgi.exe/index.php on this server.

You might encounter this with a default installation of Apache 2.2 (I used the exe installer) and a manual install of PHP5 as cgi on Windows. I placed this in my httpd.conf and followed other steps according to the PHP5 on Apache 2.2 instructions by using in httpd.conf:

#load php5 as cgi
ScriptAlias /php/ “c:/php/”
AddType application/x-httpd-php .php
Action application/x-httpd-php “/php/php-cgi.exe”

In order to fix the forbidden error I had to change this line:

<Directory “C:/Program Files/Apache Software Foundation/Apache2.2/cgi-bin/”>
AllowOverride None
Options None
Order allow,deny
Allow from all
</Directory>

to this:

<Directory “c:/php”>
AllowOverride None
Options None
Order allow,deny
Allow from all
</Directory>

EDIT: Looking back now, I see this solution at the bottom of the comments from 2006 on the Apache instructions. I probably didn’t find it because this error wasn’t mentioned. I had a feeling that replacing the line probably wasn’t a good thing and that you should add it additionally. That’s what the comment says so I also suggest that approach.