php-windows Digest 8 Apr 2009 20:47:24 -0000 Issue 3599
Topics (messages 29246 through 29253):
Re: Does a spreadsheet-like front end exist for MySQL?
29246 by: Arno Kuhl
29247 by: Niel Archer
29248 by: TG
29249 by: Piotr Pluciennik
29250 by: Bill Mudry
Re: QDBM on Windows
29251 by: Niel Archer
29252 by: Harold Fuchs
About PHP and Apache 1.3.xx
29253 by: Alejandro Esteban Galvez
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 ---
-----Original Message-----
From: Bill Mudry [mailto:billmu...@rogers.com]
Sent: 06 April 2009 04:02 PM
To: php-wind...@lists.php.net
Subject: [PHP-WIN] Does a spreadsheet-like front end exist for MySQL?
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
===================================
I use an old version of MySQL-Front that does what you describe. Very quick
and very easy. It runs on a client-side windows pc (you didn't mention your
OS) and updates the database on remote Windows or Linux servers, or
localhost Windows. I think MySQL-Front has a different name these days. It's
a commercial product. If you can find it I'd suggest d/l a trial and test to
see if it meets your needs.
Arno
--- 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.
If you can connect directly to the database server, use MySQL's Query
Browser[1] or Webyog's SQLyog[2]. MySQL's is free and Webyog has a free
Community version.
If you want a web frontend, I have no ideas for you, sorry.
[1] http://dev.mysql.com/downloads/gui-tools/5.0.html
[2] http://www.webyog.com/en/downloads.php
> Bill Mudry
> Mississauga, Ontario
>
--
Niel Archer
--- End Message ---
--- Begin Message ---
If you don't need a web version, NaviCat for Windows works great. Also,
WinSQL Lite has worked well for me in the past too. Other people have
recommended some things that sound promising as well, but I haven't seen
any web-based system that's too spreadsheet-like. But that would be a
cool project. Something that works like Google Docs' spreadsheet, but
for editing MySQL tables.
-TG
----- Original Message -----
From: Bill Mudry <billmu...@rogers.com>
To: php-wind...@lists.php.net
Date: Mon, 06 Apr 2009 10:01:57 -0400
Subject: [PHP-WIN] Does a spreadsheet-like front end exist for MySQL?
> 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 ---
--- Begin Message ---
Hi,
maybe this tools can help:
MySQL Administrator
MySQL Query Browser
MySQL Migration Toolkit
All are available on mysql site, try
http://dev.mysql.com/downloads/gui-tools/5.0.html
HTH
Piotr
--- On Mon, 4/6/09, Bill Mudry <billmu...@rogers.com> wrote:
From: Bill Mudry <billmu...@rogers.com>
Subject: [PHP-WIN] Does a spreadsheet-like front end exist for MySQL?
To: php-wind...@lists.php.net
Date: Monday, April 6, 2009, 4:01 PM
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 ---
--- Begin Message ---
Thanks Arno :-). I found the home site at:
http://www.mysqlfront.de/
I downloaded it and installed the program. From the time I could spend
now, it certainly seems just like what I was looking for. As requested, it
actually does work in spreadsheet fashion. It also seems to have a
number of other useful functions. I have a number of things I have to
do during business hours now but I certainly will have to delve into it later.
About the only thing I am not sure about is that the site stated that the
cost would be $35 yet it downloaded just fine. I saw no mention of
whether, for instance, there is a trial period or if it can be used without
paying if for personal use. If any of the rest of you try it out, I would love
to hear what your experiences are like.
Much thanks. By chance, if there other front end programs you come
across that operate in spreadsheet manner, do mention them.
Bill Mudry
Mississauga
At 10:27 AM 4/6/2009, you wrote:
-----Original Message-----
From: Bill Mudry [mailto:billmu...@rogers.com]
Sent: 06 April 2009 04:02 PM
To: php-wind...@lists.php.net
Subject: [PHP-WIN] Does a spreadsheet-like front end exist for MySQL?
<cut for brevity>
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
===================================
I use an old version of MySQL-Front that does what you describe. Very quick
and very easy. It runs on a client-side windows pc (you didn't mention your
OS) and updates the database on remote Windows or Linux servers, or
localhost Windows. I think MySQL-Front has a different name these days. It's
a commercial product. If you can find it I'd suggest d/l a trial and test to
see if it meets your needs.
Arno
--- 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.
I'm not sure about this, but I think you have to compile the qdbm
handler into the dba extension. I looked at this briefly myself a
few months ago, in order to transfer the data from an OLD database, but
haven't had time to complete it.
Also not sure, but IIRC the Berkeley handler will open dbm files too. I
don't have any dbm files to test this with though.
> --
> Harold Fuchs
> London, England
> Please do *not* reply to my personal e-mail address.
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
Niel Archer
niel.archer (at) blueyonder.co.uk
--- End Message ---
--- Begin Message ---
Niel Archer" <n...@chance.now> wrote in message
news:20090406181229.b854.a5cb2...@chance.now...
> ""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.
> I'm not sure about this, but I think you have to compile the qdbm
> handler into the dba extension. I looked at this briefly myself a
> few months ago, in order to transfer the data from an OLD database, but
> haven't had time to complete it.
> Also not sure, but IIRC the Berkeley handler will open dbm files too. I
> don't have any dbm files to test this with though.
<snip>
> -
> iel Archer
> iel.archer (at) blueyonder.co.uk
Thanks. I've tried all the handlers available and non works. So this is
going on the "can't be bothered" pile and I'll go back to perl which I know
works. Seems the PHP folk are not very interested in Windows and I very much
doubt there's a port to the iPod Touch ...
--
Harold Fuchs
London, England
Please do *not* reply to my personal e-mail address.
--- End Message ---
--- Begin Message ---
Hi people!
I am new in this of PHP in Windows, and i am interested on known how I can link
PHP4 and Apache 1.3
PD: Don't worry for my english. I speak tittle english, because i am cuban,
bye
--------------------------------------------
Alejandro Esteban Galvez
Administrador de Red IPICHMC Rimed,
Radio-Aficionado CL2AEG
Linux User #472120 - http://i18n.counter.li.org/
Correo: alejan...@infomed.sld.cu
Correo y Jabber: alejan...@ipichmc.rimed.cu
www.ipichmc.rimed.cu
---------------------------------------
Red Telematica de Salud - Cuba
CNICM - Infomed
--- End Message ---
