Web Hosting Support Forum

[W9FZ]

Curious if anyone has a data entry/edit frontend (php or otherwise) that they like to use to interact with their database tables. Sure, last year I wrote a site that accepted online registrations entering them into a database from which I was able to generate a bunch of reports. So I "could" write it myself--but would rather find a package or set of scripts.

Ultimately, I'll be writing some webpages (php) that automate pulling data from my database and put it in a displayed format that I like. But between now and then, I have a lot of data entry ahead of me. Sure I can write pages that do that, but it would be easier if there was a package or set of scripts that I can include in my webspace so that I can access them from the road and do input and editing.

Heidi SQL looks good but it looks like remote access to the db from many different locations would be difficult or problematic. A package or set of scripts that remains IN my webspace and then has localhost access to the db would be better.

phpmyadmin is fine for setting up the db, but it didn't seem that good at data entry. Thoughts? Am I missing something?


Bruce W9FZ

[W9FZ]

I'm trying Bear SQL http://bearsql.org/ and it looks promising. Only thing is I'm getting a bunch of errors:

Sorry the Query failed: Select * from w9fz_scoutpatches.grant where ( IS NULL || ='')
Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IS NULL || ='')' at line 1PHP version: 5.2.8
Sorry the Query failed: SHOW COLUMNS FROM grant
Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grant' at line 1

I've tried to grant proper priveleges to the "user" I'm using. But there's some incompatibility between the BearSQL scripts and my database tables.

Right now I'm looking at making a form in Excel and put all my data in an EXCEL .xls and then make a CSV from it and import it to my table in myphpadmin.

Any other thoughts or suggestions.
Bruce (in SFO)

[ka9fox]

Hi Bruce.

The support forum here at QTH.com is probably not the best place to get advice on this type of thing. Your problme isn't really specific to QTH.com and there isn't enough traffic on this forum to really gain you a lot of expertise. Probably best to find and use a forum that is more specific to using MySQL and/or PHP.

That said, I showed your postings to a couple friends that use MySQL and PHP on a daily basis, and here are there comments... I hope they help.

FRIEND 1

[W9FZ]

Hi Scott:

You are correct, I kinda knew it was a limited audience here. But thank you so much for running my comments by your friends. They are a start.

Yes, I'm on a PHP forum--I'll look there harder than I have so far :-).

Thanks again
Bruce W9FZ