php-windows Digest 6 Apr 2009 14:03:48 -0000 Issue 3598
Topics (messages 29243 through 29245):
QDBM on Windows
29243 by: Harold Fuchs
29244 by: Harold Fuchs
Does a spreadsheet-like front end exist for MySQL?
29245 by: Bill Mudry
Administrivia:
To subscribe to the digest, e-mail:
php-windows-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-windows-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-wind...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
I'm running Win XP Pro/SP3, Apache 2.2.11 and PHP 5.2.9.1.
I have a database built by a Perl program using its "dbm" database system
that binds a file to an associative array.
I have discovered via Google etc. that there's a PHP extension that can
read/write this type of database. It is called "qdbm".
I have followed the instructions in the PHP manual at
http://uk3.php.net/manual/en/dba.requirements.php and related pages but
nothing works. When I try to run Example 1 at
http://uk3.php.net/manual/en/function.dba-handlers.php which calls
dba_handlers I get an "undefined function" error.
I have found the Windows binaries qdbm-1.8.75-win32.zip on SourceForge by
following the instructions at
http://uk.php.net/manual/en/dba.installation.php which say "Note: This was
added in PHP 5.0.0. The qdbm library can be loaded from »
http://qdbm.sourceforge.net. " but this .zip has many files which I don't
know what to do with.
Can someone please help? Step by step please. I've used Perl a lot but am
completely new to PHP.
--
Harold Fuchs
London, England
Please do *not* reply to my personal e-mail address.
--- End Message ---
--- Begin Message ---
""Harold Fuchs"" <rincew...@wolfeden.demon.co.uk> wrote in message
news:0a.05.02528.725b9...@pb1.pair.com...
> I'm running Win XP Pro/SP3, Apache 2.2.11 and PHP 5.2.9.1.
>
> I have a database built by a Perl program using its "dbm" database system
> that binds a file to an associative array.
>
> I have discovered via Google etc. that there's a PHP extension that can
> read/write this type of database. It is called "qdbm".
>
> I have followed the instructions in the PHP manual at
> http://uk3.php.net/manual/en/dba.requirements.php and related pages but
> nothing works. When I try to run Example 1 at
> http://uk3.php.net/manual/en/function.dba-handlers.php which calls
> dba_handlers I get an "undefined function" error.
>
> I have found the Windows binaries qdbm-1.8.75-win32.zip on SourceForge by
> following the instructions at
> http://uk.php.net/manual/en/dba.installation.php which say "Note: This was
> added in PHP 5.0.0. The qdbm library can be loaded from »
> http://qdbm.sourceforge.net. " but this .zip has many files which I don't
> know what to do with.
>
> Can someone please help? Step by step please. I've used Perl a lot but am
> completely new to PHP.
>
One step further. I re-installed PHP choosing the DBA extension. Now when I
run the "dba_handlers.php " script mentioned above, I get
Available DBA handlers:
- cdb: 0.75, Revision: 1.10.2.1.2.5
- cdb_make: 0.75, Revision: 1.9.2.1.2.3
- db3: Sleepycat Software: Berkeley DB 3.3.11: (July 12, 2001)
- inifile: 1.0, Revision: 1.14.2.1.2.6
- flatfile: 1.0, Revision: 1.14.2.1.2.3
So, how do I get qdbm? Please.
--
Harold Fuchs
London, England
Please do *not* reply to my personal e-mail address.
--- End Message ---
--- Begin Message ---
I use phpmyadmin a lot. It lacks one feature that I wish existed. You
can edit only
one record at a time, and when you are editing a lot of data
manually, the amount
of time it takes to open up each record and the time for so many saves can add
up noticeably.
I remember using a front end for MySQL a few years ago that worked much like
a spreadsheet. You could hop around putting data into a page full of records at
will, just like you can with a spreadsheet. You then save at any frequency you
wish. I found this so efficient. It also gave a convenient overview of a whole
screenful of records.
I have and will have for some time to come a need to do a lot of manual data
input. The usual method of a form opening for editing only one record at a
time I find far slower and less efficient than this spreadsheet-like front end.
It was being used by a group of programmers in Albany, N.Y. and I have
no idea where they got it from.
I should mention ---- this was *not* simply a spreadsheet in which
you added data
and then had to import into MySQL each time. The action of saving would update
the database in use every time (--- ie. really simple to use). I seem
to remember
that you could even scroll through data. You could easily add, delete
or change.
You didn't have to declare which one of these actions either.
Do any of you know of such a front end (to MySQL) that exists? Is there a
cost or is there an open systems free program that fits?
I imagine to create one would be fairly complicated since the whole sheet of
records is always present as you add data. You simply plopped in data in
cells randomly as you wish and saved once in a while. Any idea what it would
take to code such a program?
<fingers crossed> I hope there is such a program already instead.
Bill Mudry
Mississauga, Ontario
--- End Message ---
