phpmyedit-discuss — Discussion of existing and possible future usage/features of PHPMyEdit.

[PHPMyEdit-Discuss] Introduction

[Alex M. <al...@OW...>]

Hi folks,

I've only just started with PHP and phpMyEdit but since I am fairly 
experienced building web applications with perl, Java, and C++ I thought I 
ought to introduce myself and explain my interest in phpMyEdit

I'm finding that companies often want simple database applications which 
they don't want to pay much for.
To satisfy them I need to produce such database applications as swiftly and 
easily as possible.
Since the task of providing a web interface for listing records, creating 
new records, and editing existing ones is rather common and rather boring 
I've been looking for some kind of code generator like phpMyEdit.

Can anyone point me at projects similar to phpMyEdit and tell me why I 
should be using phpMyEdit and not anything else?

There seems to be something called phpMyAccess in SourceForge which has 
zero activity. Is it worth considering?

There doesn't seem to be a lot of traffic on this mailing list? Why isn't 
this project far more popular if it does what it is supposed to do?

Does phpMyEdit cope with complicated data types, enumerated data types such 
as reference datatypes?

Can I easily edit the code which phpMyEdit generates and still have those 
changes if I need to change the database schema?


Cheers

Alex McLintock






Openweb Analysts Ltd, London.
Software For Complex Websites http://www.OWAL.co.uk/
Open Source Software Companies please register here 
http://www.OWAL.co.uk/oss_support/

[PHPMyEdit-Discuss] datemask usage

[Chun <ch...@at...>]

I'm having what might be a small problem, but its getting to me. I' trying
to display the date format to something other than the default mysql
ccyy-mm-dd. What is the proper usage for the datemask option? for example
yy/mm/dd.

Thanks again for everyones help.

Chun

Re: [PHPMyEdit-Discuss] reports extension

[Ondrej J. <ne...@po...>]

                                        Maxim, 03:07:10
                                        24. november 2002 (nedela)
Greetings.

> I saw withing the extension directory of the CVS that there is a reporting
> class. How can I apply this extension or is it ready for implementation?

	If you are able to generate HTML documentation from DocBook SGML 
sources, you can do it and read extension chapter, where is report extension 
well-described.

	If not, don't worry. Just include extension class instead of
phpMyEdit core file. So you will write something like

require_once 'extensions/phpMyEdit-report.class.php';

	Another usage is similar to base phpMyEdit class.

	=Nepto=
____________________________________________________________________________
Ondrej 'Nepto' Jombik, http://www.nepto.sk/              ne...@at...

[PHPMyEdit-Discuss] reports extension

[Chun <ch...@at...>]

I saw withing the extension directory of the CVS that there is a reporting
class. How can I apply this extension or is it ready for implementation?

Re: [PHPMyEdit-Discuss] upload file

[Ondrej J. <ne...@po...>]

> We have gotten a file upload feature to work (for uploading images to a
> server directory - not the DB and adding a link in the DB to the file).
>  I do not have time to explain the code or offer help (my PHP programmer 
> did it for me), but I would be willing to share the code if the core 
> PHPMyEdit developer could review it and integrate it into the next 
> release of PHPMyEdit.

	Great! Feel free to send me the file or patch to my private e-mail 
or mailinglist.

	=Nepto=
____________________________________________________________________________
Ondrej 'Nepto' Jombik, http://www.nepto.sk/              ne...@at...

[PHPMyEdit-Discuss] new install instructions for 5.1

[Dave P. <dav...@sh...>]

Hello All.

I have written a new and more complete set of installation
instructions for use with phpMyEdit 5.1, which I'm including below.
They are intended to replace section 2 of the Readme file.
Let me know if you have any comments/corrections/additions.
Note that these will need to be revised for new phpMyEdit versions.
For example, the CVS version has already fixed the problem with the
"require_once" outlined in step 2.2.9.
In a subsequent email I'll outline some suggestions I have that
should make the install a bit easier.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D
phpMyEdit 5.1
-------------
2. Installation

     Two types of installation are documented - Basic and Custom.
     If you are using phpMyEdit for the first time, it is suggested
     to do a Basic installation. Once you have confirmed that phpMyEd=
it
     is working properly in your environment, you may then wish to
     do a Custom installation. If you do a Custom installation and ha=
ve
     problems getting phpMyEdit to work properly, please do a Basic
     installation first to confirm whether the problem is being cause=
d by
     something you have done in your Custom installation.
     Please read both the Basic and Custom installation documentation
     before asking "why doesn't phpMyEdit work on my system".

     2.1 Basic Installation

         Definitions:
         - local system:
             location where you have downloaded the phpMyEdit distibu=
tion=20
archive
         - server:
             webserver where you wish to install phpMyEdit

         2.1.1  Download the phpMyEdit distribution archive to your l=
ocal=20
system.
         2.1.2  Extract the phpMyEdit distribution archive on your lo=
cal=20
system.
         2.1.3  Copy all the phpMyEdit files/directories to your serv=
er,
                maintaining the directory structure.
         2.1.4  Using a browser, run phpMyEditSetup.php, and enter:
                - the name(Hostname) of your MySQL server
                - the MySQL account name(Username) to be used to logi=
n to
                  the MySQl server
                - the password for the MySQL account
                Note that the values supplied for these fields are th=
e default
                values used by the generated table editing program, s=
o the
                default is that the generated program will be using a=
n account
                that has the MySQL user rights associated with this a=
ccount.
         2.1.5  All available databases will be listed. Select the on=
e you
                want by clicking the radio button next to its name, t=
hen
                clicking on the "Submit" button at the bottom of the =
page.
         2.1.6  All tables in the selected databases will be listed. =
Select
                the one you want by clicking the radio button next to=
 its name,
                then clicking on the "Submit" button at the bottom of=
 the page.
         2.1.7  Follow the instructions on the page to select an 'ide=
ntifier'
                field from the table(used for Changes and Deletes).
         2.1.8  Fill in a 'Page Title', which will be used by the gen=
erated
                table editing program.
         2.1.9  Fill in a name(Base Filename) to be used for the gene=
rated
                program's name. Avoid using characters that may cause=
 problems
                in your server's filesystem, such as spaces and punct=
uation.
         2.1.10 After you click on "Submit", the phpMyEditSetup.php s=
cript will
                display a 'results page':
                - the top part of the page shows the name of the file=
 that
                  was used, and whether or not phpMyEditSetup.php was=
 able
                  to write the generated table editing program to tha=
t file
                - the contents of the generated program are listed, w=
hether
                  or not the file creation succeeded
                - if the file creation failed, copy the generated pro=
gram
                  listing into your PHP editor, save it to a file, an=
d then
                  copy it to your server, into the same directory as =
the
                  phpMyEdit.class.php file
         2.1.11 Using a browser, run the generated table editing PHP =
script
                and confirm it is working properly in your server env=
ironment.

     2.2 Custom Installation

         Definitions:
         - local system:
             location where you have downloaded the phpMyEdit distibu=
tion=20
archive
         - server:
             webserver where you wish to install phpMyEdit
         - setupdir:
             directory on the server which will contain phpMyEditSetu=
p.php
         - includedir:
             directory on the server which will be used by PHP to inc=
lude
             phpMyEdit files when scripts use "require" or "include"
         - scriptdir:
             directory on the server which will contain the scripts g=
enerated
             by phpMyEditSetup.php

         Some of the steps listed in this section refer to modificati=
ons to
         the PHP code in some phpMyEdit files. There are additional=
=20
modifications
         that are possible in these files, and in the generated PHP s=
cripts,
         but these are not required for the installation described be=
low.

         2.2.1  Download the phpMyEdit distribution archive to your l=
ocal=20
system.
         2.2.2  Extract the phpMyEdit distribution archive on your lo=
cal=20
system.
         2.2.3  When using phpMyEditSetup.php, to avoid sending the M=
ySQL
                account name and password over the internet, find the=
 following
                lines in phpMyEditSetup.php:
                     $submit =3D $HTTP_POST_VARS['submit'];
                     $hn =3D $HTTP_POST_VARS['hn'];
                     $un =3D $HTTP_POST_VARS['un'];
                     $pw =3D $HTTP_POST_VARS['pw'];
                and change them to specify the vales for your MySQL h=
ost,
                MySQL account name, and account password, and to simu=
late
                having clicked on the "Submit" button. For example:
                     $submit =3D 'submit';
                     $hn =3D 'mysql.mycompany.com';
                     $un =3D 'username';
                     $pw =3D 'password';
                This will cause the script to start at the database s=
election
                page, and prevent sending the username/password over =
the net.
         2.2.4  If you are only going to be using phpMyEdit with the =
tables
                in one database, then in phpMyEditSetup.php you can s=
pecify
                the database:
                     $db =3D 'mydatabase';
                Coupled with 2.2.3, this will cause the script to sta=
rt at
                the table selection page.
         2.2.5  To have phpMyEditSetup.php generate scripts in 'scrip=
tdir'
                rather than in 'setupdir', change the following line:
                     $inclDir =3D '.';
                to something like:
                     $inclDir =3D '../scriptdir';
                Do not include a trailing slash(/).
                Your webserver process will need write permission to =
this
                directory for phpMyEditSetup.php to be able to save t=
he
                generated table editing program to a file.
         2.2.6  Unless you are going to make your own modifications t=
o
                phpMyEditSetup.php, don't bother changing the followi=
ng
                lines, as they are not used in version 5.1:
                     $phpExtension =3D '.phtml';
                     $phpExtension =3D '.php';
                     $destDir =3D '.';
                     $headerFile =3D 'SiteHeader.inc';
                     $footerFile =3D 'SiteFooter.inc';
         2.2.7  It is suggested that you make use of an "include file=
" to
                contain the MySQL hostname, account, and password tha=
t will
                be used by the scripts generated by phpMyEditSetup.ph=
p. Aside
                from issues of site maintainability and security, thi=
s is also
                a good idea because by default phpMyEditSetup.php dis=
plays the
                generated script contents on a webpage, which means t=
hat=20
without
                this change, the username/password will be sent over =
the net
                when you run phpMyEditSetup.php.
                In phpMyEditSetup.php find the following lines:
                     /* NOTE: coder is strongly urged to remove the
                             hn, un, pw lines from
                         here and set values in PME_site_defaults.inc
                         require "PME_site_defaults.inc"; */
                     '
                     $opts["hn"] =3D "'.$hn.'";
                     $opts["un"] =3D "'.$un.'";
                     $opts["pw"] =3D "'.$pw.'";
                Change these to read:
                     /* NOTE: coder is strongly urged to remove the
                             hn, un, pw lines from
                         here and set values in PME_site_defaults.inc
                     $opts["hn"] =3D "'.$hn.'";
                     $opts["un"] =3D "'.$un.'";
                     $opts["pw"] =3D "'.$pw.'";
                     */
                     '
                     require "PME_site_defaults.inc";
                Do not remove the single quote on the line by itself.
         2.2.8  If you are going to do step 2.2.7, you will need to c=
reate
                a "PME_site_defaults.inc" file, with the following co=
ntent:
                     $opts['hn'] =3D "mysql.mycompany.com";
                     $opts['un'] =3D "username";
                     $opts['pw'] =3D "password";
         2.2.9  The 5.1 version of the phpMyEdit.class.php file requi=
res there
                to be a "timer.class" file in the same directory. The=
 use=20
of the
                'timer' is controlled by the setting of=20
$opts['display']['time']
                in the generated scripts, and defaults to false. If y=
ou do
                not want to use the timer(it displays the time for ea=
ch
                operation at the bottom of the page, like "78.024=
=20
milliseconds"),
                and you do not wish to have the "timer.class" file on=
 your
                server, edit phpMyEdit.class.php and find the followi=
ng line:
                     if (@require_once dirname(__FILE__).'/timer.clas=
s') {
                and change it to:
                     if (@include_once dirname(__FILE__).'/timer.clas=
s') {
                If you do not do this, and you do not have a "timer.c=
lass"
                file, then your generated scripts will fail to produc=
e any
                output, without generating any error messages.
         2.2.10 If it doesn't already exisit on the server, create 's=
etupdir'.
                The minimum permissions needed for the directory are =
those to
                enable you to use your browser to run phpMyEditSetup.=
php.
                If you have not made the change outlined in 2.2.5, th=
en your
                webserver process will need write permission to this =
directory
                for phpMyEditSetup.php to be able to save the generat=
ed program
                to a file.
         2.2.11 If it doesn't already exisit on the server, create=
=20
'includedir'.
                The minimum permissions needed for the directory are =
those to
                enable the webserver process running the generated sc=
ripts to
                be able to include files such as phpMyEdit.class.php =
and
                PME_site_defaults.inc.
         2.2.12 If it doesn't already exisit on the server, create 's=
criptdir'.
                The minimum permissions needed for the directory are =
those to
                enable the webserver process to run the generated scr=
ipts.
                If you have made the change outlined in 2.2.5, then y=
our
                webserver process will need write permission to this =
directory
                for phpMyEditSetup.php to be able to save the generat=
ed program
                to a file.
         2.2.13 Copy the following files from the local system to the=
 server's
                'setupdir':
                     phpMyEditSetup.php
         2.2.14 Copy the following files from the local system to the=
 server's
                'includedir':
                     phpMyEdit.class.php
                     timer.class           (see 2.2.9)
                     PME_site_defaults.inc (see 2.2.7 and 2.2.8)
         2.2.15 In 'includedir' create a subdirectory called 'lang'.
                Copy the following file from the local system to the =
server's
                'includedir/lang' directory:
                     PME.lang.EN-US.inc
                You may wish to also copy the other supplied language=
 files.
                If the phpMyEdit.class.php file cannot include any la=
nguage
                file(the default is PME.lang.EN-US.inc), then the gen=
erated
                table editing scripts will not work(you will get a we=
bpage
                with a table having two columns, "Field" and "Value",=
 and
                no data from the table).
         2.2.16 If you are going to use the "graphic links" navigatio=
n style
                in your table editing scripts(controlled by=20
$opts['navigation']),
                then in 'scriptdir' create a subdirectory called 'ima=
ges', and
                copy the following files from the local system to the=
 server's
                'scriptdir/images' directory:
                     pme-change.png
                     pme-copy.png
                     pme-delete.png
                     pme-view.png
                If using FTP to do the copying, make sure to use 'bin=
ary' mode.
         2.2.17 Using a browser, run phpMyEditSetup.php. If you imple=
mented
                step 2.2.4, go to step 2.2.18.
                If you did not do step 2.2.4 it will start at the pag=
e listing
                the available databases. Select the one you want by=
=20
clicking the
                radio button next to its name, then clicking on the "=
Submit"
                button at the bottom of the page.
         2.2.18 All tables in the selected databases will be listed. =
Select
                the one you want by clicking the radio button next to=
 its name,
                then clicking on the "Submit" button at the bottom of=
 the page.
         2.2.19 Follow the instructions on the page to select an 'ide=
ntifier'
                field from the table(used for Changes and Deletes).
         2.2.20 Fill in a 'Page Title', which will be used by the gen=
erated
                table editing program.
         2.2.21 Fill in a name(Base Filename) to be used for the gene=
rated
                program's name. Avoid using characters that may cause=
 problems
                in your server's filesystem, such as spaces and punct=
uation.
         2.2.22 After you click on "Submit", the phpMyEditSetup.php s=
cript will
                display a 'results page':
                - the top part of the page shows the name of the file=
 that
                  was used, and whether or not phpMyEditSetup.php was=
 able
                  to write the generated table editing program to tha=
t file,
                  which would be in 'scriptdir'
                - the contents of the generated program are listed, w=
hether
                  or not the file creation succeeded
                - if the file creation failed, copy the generated pro=
gram
                  listing into your PHP editor, save it to a file, an=
d then
                  copy it to your server, into the 'scriptdir' direct=
ory
         2.2.23 Using a browser, run the generated table editing PHP =
script
                and confirm it is working properly in your server env=
ironment.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
-----------
Dave Patton
Canadian Coordinator
the Degree Confluence Project
http://www.confluence.org
dp...@co...
49=B016'07"N 123=B009'07"W

Re: [PHPMyEdit-Discuss] upload file

[Ondrej J. <ne...@po...>]

                                        Pauli, 15:12:31
                                        21. november 2002 (stvrtok)
Greetings.

> First time user here, and I just wanted to give props to all of the
> developers for a great work. This is very useful for our departments web
> server.

	Thanks. ;-)

> I would like anyone to tell me if they have been able to implement an
> upload option as of yet. This would be the icing on the cake.

	The problem is, that there are other important things to do (the
most important is CSS policy) and I have not so clear idea how this should
work. Thus file upload functionality is not planed for near future, but it
will be nice to have it in next major 6.0 release. But it is very very long
term.

	Ondrej Jombik
	phpMyEdit maintainer
____________________________________________________________________________
Ondrej 'Nepto' Jombik, http://www.nepto.sk/              ne...@at...

Re: [PHPMyEdit-Discuss] upload file

[Rich H. <rh...@no...>]

Chun,

We have gotten a file upload feature to work (for uploading images to a 
server directory - not the DB and adding a link in the DB to the file). 
 I do not have time to explain the code or offer help (my PHP programmer 
did it for me), but I would be willing to share the code if the core 
PHPMyEdit developer could review it and integrate it into the next 
release of PHPMyEdit.

Rich

Chun wrote:

>First time user here, and I just wanted to give props to all of the
>developers for a great work. This is very useful for our departments web
>server. I would like anyone to tell me if they have been able to implement
>an upload option as of yet. This would be the icing on the cake.
>Unfortunetly i have not been able to do it myself. I am basically trying to
>add a field with a browse directory button that will allow me to upload a
>word document into mySQL and display a link to retrieve from the view
>screen.
>
>Anyone been sucessful at this?
>
>
>
>
>-------------------------------------------------------
>This sf.net email is sponsored by:ThinkGeek
>Welcome to geek heaven.
>http://thinkgeek.com/sf
>_______________________________________________
>Phpmyedit-discuss mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss
>
>
>  
>

-- 
Rich Hunter
Novo Solutions, Inc
(757) 687-6590
(888) 316-4559 (US Toll Free)
http://www.novosolutions.com
http://knowledgebase.novosolutions.com

[PHPMyEdit-Discuss] upload file

[Chun <ch...@at...>]

First time user here, and I just wanted to give props to all of the
developers for a great work. This is very useful for our departments web
server. I would like anyone to tell me if they have been able to implement
an upload option as of yet. This would be the icing on the cake.
Unfortunetly i have not been able to do it myself. I am basically trying to
add a field with a browse directory button that will allow me to upload a
word document into mySQL and display a link to retrieve from the view
screen.

Anyone been sucessful at this?

Re: [PHPMyEdit-Discuss] list activity level, bugs, and features

[Ondrej J. <ne...@po...>]

                                        Pauli, 09:44:28
                                        19. november 2002 (utorok)
Greetings.

> >         This list is archived:
> >1. Follow "List" link at phpMyEdit SourceForge homepage.
> >2. Read "Mailinglist" chapter in doc/README file.
> Well, as of yesterday, November 17th, the sourceforge "Lists" page
> indicated that the list was not archived, and on this page:
> http://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss if I clicked
> on "Phpmyedit-discuss Archives" I received a page telling me that the list
> is not archived. Today, any time I tried to access the "Lists" page, or
> the archive link on the above page, there was no response from the server.

	Maybe the SourceForge.net mailinglist services are temporartily
disabled due to some service revisions. I hope e-mails will appear in few
following days.

> >         There is no FAQ for 5.x created yet. With Doug Hockinson I'm
> >preparing new phpMyEdit DocBook documentation. Any contribution to FAQ is
> >welcomed.
> What's your mechanism for people to contribute to the documentation? I'm
> willing to write a "full" version of the install instructions, because the
> current version(shipped with 5.1) doesn't properly explain "all the
> details" that you need to know if you want to do a 'custom' install.

	Documentation is stored in SGML files in phpMyEdit CVS repository.
We are using DocBook generation tools, thus we will be able to generate
various output formats of phpMyEdit documentation.

	If you are not familiar with DocBook, contribution with classical
chapters/sections writting is also welcomed. Installation instructions are
currently AFAIK well-written, but they may be improved anyway.

	Platon SDG CVS repository instructions are written at
http://www.platon.sk/ website. Use 'phpMyEdit' as a project name.

	=Nepto=
____________________________________________________________________________
"Be conservative in what you do, be liberal in what you accept from others."
(RFC 793: Transmission control protocol; chapter 2.10. Robustness Principle)

Re: [PHPMyEdit-Discuss] list activity level, bugs, and features

[Dave P. <dav...@sh...>]

At 10:04 AM 2002/11/18, Ondrej Jombik wrote:
>                                         Pauli, 19:03:36
>                                         18. november 2002 (pondelok)
>Greetings.
>
> > I just joined the list. Because the list isn't archived, I can't get the
> > answers to some questions without asking them here.
>
>         This list is archived:
>
>1. Follow "List" link at phpMyEdit SourceForge homepage.
>2. Read "Mailinglist" chapter in doc/README file.

Well, as of yesterday, November 17th, the sourceforge "Lists"
page indicated that the list was not archived, and on this page:
http://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss
if I clicked on "Phpmyedit-discuss Archives" I received a page
telling me that the list is not archived.
Today, any time I tried to access the "Lists" page, or the
archive link on the above page, there was no response from the server.

>         There is no FAQ for 5.x created yet. With Doug Hockinson I'm
>preparing new phpMyEdit DocBook documentation. Any contribution to FAQ is
>welcomed.

What's your mechanism for people to contribute to the documentation?
I'm willing to write a "full" version of the install instructions,
because the current version(shipped with 5.1) doesn't properly
explain "all the details" that you need to know if you want to
do a 'custom' install.

-----------
Dave Patton
CIS Canadian Information Systems
Vancouver, B.C.
dav...@sh...

Re: [PHPMyEdit-Discuss] list activity level, bugs, and features

[Ondrej J. <ne...@po...>]

                                        Pauli, 19:03:36
                                        18. november 2002 (pondelok)
Greetings.

> I just joined the list. Because the list isn't archived, I can't get the
> answers to some questions without asking them here.

	This list is archived:

1. Follow "List" link at phpMyEdit SourceForge homepage.
2. Read "Mailinglist" chapter in doc/README file.

> Hopefully they aren't in the "FAQ" category :)

	There is no FAQ for 5.x created yet. With Doug Hockinson I'm
preparing new phpMyEdit DocBook documentation. Any contribution to FAQ is
welcomed. Currently that documentation does not contain this section.

> 1) What's the activity level on this list?

	Few e-mails per week.

> 2) Do people tend to discuss possible bugs on here first, and then they
> get posted on the sourceforge tracker, or is the intent that if you think
> there is a bug you post it first, then refer to that posting if you want
> to discuss in on this list?

	It's up to you. If bug is clear and easy to reproduce, you can just
submit it on SF.net. If it is more sophisticated, we can talk about it here.

3) Same as #2, but for feature requests.

	I prefer for consulting "Feature request" on this list, thus more
points of view can be presented for one issue.

> I took a 'quick look' at phpMyEdit earlier this year, but didn't end up
> using it. Now I'm taking another look, using 5.1.

	Well, there are still few bug, also in current CVS version. You can
check CVS version, maybe you bugs have been fixed. Or wait for 5.2. I want
to release it in few following days, although I wanted to have CSS policy
implemented till this release. Does not matter, CSS will appear in 5.3.

	Ondrej Jombik
	phpMyEdit maintainer
____________________________________________________________________________
Ondrej 'Nepto' Jombik, http://www.nepto.sk/              ne...@at...

[PHPMyEdit-Discuss] list activity level, bugs, and features

[Dave P. <dav...@sh...>]

Hello.

I just joined the list.
Because the list isn't archived, I can't get the
answers to some questions without asking them here.
Hopefully they aren't in the "FAQ" category :)

1)
What's the activity level on this list?
2)
Do people tend to discuss possible bugs on here
first, and then they get posted on the sourceforge
tracker, or is the intent that if you think there
is a bug you post it first, then refer to that
posting if you want to discuss in on this list?
3)
Same as #2, but for feature requests.

I took a 'quick look' at phpMyEdit earlier this
year, but didn't end up using it. Now I'm taking
another look, using 5.1.
So far I've found 1 major bug, 1 minor bug, and
a couple of possible bugs. There are also some
features relating to installation/configuration
issues that I think should be added.
I may be able to help out with the development.
-----------
Dave Patton
CIS Canadian Information Systems
Vancouver, B.C.
dav...@sh...

Re: [PHPMyEdit-Discuss] Help for participating in phpMyEdit project

[Ondrej J. <ne...@po...>]

                                        Maxim, 21:46:06
                                        15. november 2002 (piatok)
Greetings.

> I would like to propose some improvements to phpMyEdit program but I have
> never participated in such a project. How can I get the source and commit
> them. I installed WinCVS 1.3 on my machine but don't see how to configure
> it to access the project.
> I already corrected the French language file and would like to commit it
> (I join it to this mail).

	Are you sure you CVS client is working properly? Current CVS version 
of Franch language file is

/* $Platon: phpMyEdit/lang/PME.lang.FR.inc,v 1.8 2002/11/14 11:40:33 nepto 
Exp $ */

	You have posted file with version 1.4 what is a little bit old.  It
was changed 4 times since that time. Try to checkout sources from CVS again.
It should give you 1.8 version of French language file.

	Once you will be more familiar with using CVS client and still
interested in phpMyEdit development, I can give you write access into
phpMyEdit repository.

	If you do not know where to start, just try to fix some from many
bug submitted in Sourceforge bug-tracking system. There is not need for
exact code implementation, ideas and thoughts why and when particular bug
occurs are greatly appreciated. Of courese, new features are also welcomed.

	=Nepto=
____________________________________________________________________________
Ondrej 'Nepto' Jombik, http://www.nepto.sk/              ne...@at...

[PHPMyEdit-Discuss] Help for participating in phpMyEdit project

[Laurent G. <lau...@li...>]

Hello,

I would like to propose some improvements to phpMyEdit program but I have
never participated in such a project. How can I get the source and commit
them. I installed WinCVS 1.3 on my machine but don't see how to configure it
to access the project.

I already corrected the French language file and would like to commit it (I
join it to this mail).

Could someone tell me the steps to follow, please. I use Windows 2000.

Laurent

Re: [PHPMyEdit-Discuss] Can't add or update records

[Ondrej J. <ne...@po...>]

                                        Maxim, 10:11:57
                                        14. november 2002 (stvrtok)
Greetings.

> CREATE TABLE `pme1` (
> `id` INT( 3 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
> `test` VARCHAR( 15 ) NOT NULL
> );

	I created the same table and went phpMyEdit setup using current CVS
version 5.1.11. It works well for me, since register_globals were turned On.
Than I turned them Off, but I'm still unable to reproduce the problem.

	Please send generated file with SQL dump as well. Versions of 
Apache, PHP interpreter and MySQL backend are also required.

> I CAN copy and delete. I can get it to work in version 4. Maybe it has
> something to do with the column types or idexes or where / what type the
> primary key is? I even tried CVS code and on two different systems - still
> no luck. Any ideas?

	I tried to fix the issue, but as I told once - I was unable to
reproduce problem. But I have made more cleaner code by removing unnecerary
get_http_*() methods used for CGI variables manipulation. Now is only
get_cgi_var() used. I also implemented "Apply" functionality into change
page.

	Enjoy! ;-)

	=Nepto=
____________________________________________________________________________
Ondrej 'Nepto' Jombik, http://www.nepto.sk/              ne...@at...

[PHPMyEdit-Discuss] Can't add or update records

[Richard T. <rt...@my...>]

Why can't I add or update records in version 5.0 or 5.1?

To make sure it wasn't a problem with my table I used
phpMyAdmin to create a simple test mysql table with 2
columns, making sure I have a primary key:

CREATE TABLE `pme1` (
`id` INT( 3 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`test` VARCHAR( 15 ) NOT NULL
);

Then I use phpMyAdmin to insert two records. I run
phpMyEditSetup.php:
Hostname: localhost
Username: root
Password: password

click Submit on my test database, Submit on my pme1
table, and Submit to accept the defaults showing "id"
as the identifier (it shows not_null primary_key
auto_increment). It says content file written
successfully so I go to ./pme1.php where it shows me my
table. I click Add, provide dummy values (including
setting the id of 3 - the next auto_incrementing
number) and it returns me to my table with no errors,
but it did not add a record. If I select a record and
click Change, modify the varchar field contents and
click Save, it does not update the record.

I CAN copy and delete. I can get it to work in version
4. Maybe it has something to do with the column types or idexes or where / =
what type the primary key is? I even tried CVS code and on two different =
systems - still no luck. Any ideas?

[PHPMyEdit-Discuss] Hello scrolling table body

[<sha...@so...>]

Sorry I posted this in support then found the mailing list=) 

I would like to set up the table generated by PME so when you scroll left or 
right, you can still see the left most column, and when
you scroll down you can still see the titles of the
columns. I only run linux, so I don't use netscape or
MSIE. Mozilla supports scrollable table body
(http://htmlhelp.com/test/tbody.html) but I am not sure
how to get the left column to stay fixed (honestly I
havnt gotten the titles to stay fixed in the file
generated by PME), if one were to scroll right. The
only other Idea I had was to use a javascript and link
frames so that they would scroll together. but I think
that would cause other complications. I would much
prefer to use konqueror if at all possible.
Thanks
Shane

Re: [PHPMyEdit-Discuss] First time user problem

[Ondrej J. <ne...@po...>]

                                        Maxim, 16:45:54
                                        02. november 2002 (sobota)
Greetings.

> I have installed phpMyEdit 5.1 (I've tried an older version too for 
> good measure) and I get repeated errors all of the same sort (see 
> Notice: Undefined index: pageTitle in 
> c:\inetpub\wwwroot\CDP_Test_Site\phpMyEdit-
> 5.1\phpMyEditSetup.php on line 45

	These messages are not errors, but warnings only. phpMyEdit should
works well also with them, but anyway they was fixed today in CVS. Wait for
official 5.2 release, or checkout 5.1.8 or higher from CVS.

	Thanks for notice.

	=Nepto=
____________________________________________________________________________
Ondrej 'Nepto' Jombik, Open Source software developer, http://www.platon.sk/

[PHPMyEdit-Discuss] First time user problem

[Chris P. <cp...@wa...>]

With any luck everyone can say I'm being stupid but I have a 
problem.

I have installed phpMyEdit 5.1 (I've tried an older version too for 
good measure) and I get repeated errors all of the same sort (see 
end of message) - the whole process still works but is plagued by 
these messages. I am using the correct versions of PHP & mySql 
(also IE and IIS on W2k for my sins). I have installed the entire 
phpMyEdit directory as a subdirectory of my localhost drive.

I'm new to PHP so I'm lost as to whether I am missing something, 
doing something wrong or I just need a pointer to fix something. 


Thanks for any help.


ChrisP

Notice: Undefined index: pageTitle in 
c:\inetpub\wwwroot\CDP_Test_Site\phpMyEdit-
5.1\phpMyEditSetup.php on line 45

Notice: Undefined index: baseFilename in 
c:\inetpub\wwwroot\CDP_Test_Site\phpMyEdit-
5.1\phpMyEditSetup.php on line 46

Notice: Undefined index: submit in 
c:\inetpub\wwwroot\CDP_Test_Site\phpMyEdit-
5.1\phpMyEditSetup.php on line 47

Notice: Undefined index: hn in 
c:\inetpub\wwwroot\CDP_Test_Site\phpMyEdit-
5.1\phpMyEditSetup.php on line 48

Notice: Undefined index: un in 
c:\inetpub\wwwroot\CDP_Test_Site\phpMyEdit-
5.1\phpMyEditSetup.php on line 49

Re: [PHPMyEdit-Discuss] CSS generation policy

[Ondrej J. <ne...@po...>]

                                        Maxim, 12:21:26
                                        30. oktober 2002 (streda)
Greetings!

> On the proposal of Ondrej Jombik, I would like to begin a "brainstorming"
> about the setup of a CSS classes generation policy for PHPMyEdit.

	Yesterday, late night I made long think about the issue and here are
my rough notes:

1. Basic CSS configuration will be using $opts['css'] array/hash.

2. We have at least following suboptions:
	['prefix'] - default value is "pme_"
	['dividor'] - well this should have better name, but it says how 
	              many list table rows should have own number before 
	              starting counting from 0; value of -1 means every row
	              has its own number
	['buttons_pos'] - if the buttons should get their class name 
	                  according to possition on page name
	                  (ie. pme_button_down)
	['buttons_type'] - if the buttons should get their class name 
	                   according to type (ie. pme_button_search)
	['buttons_func'] - similary functionality (pme_button_next)

	If more from buttons_* option is turned on, the result class name
will be joined in one string. Example: pme_button_down_change.

3. Similar booleans (they should not be letter flags?) must have other 
   elements, such as <hr>, so ['hr_pos'] = true -> pme_hr_up, pme_hr_down

4. There are two types of screen: table listing and one record display.

5. There are three types of buttons:
	- table list action buttons:
		next, prev, add, view, delete, copy, change
	- record display action buttons:
		save, more, cancel, delete, [apply]
	- search buttons:
		search, hide, cancel, query

6. Every column can have new option ['css'] ($opts['fdd']['col']['css']).

7. Column ['css'] has:
	['postfix'] - what to add to all classes that are connected with 
	              this column (so its TH class will get this postfix, 
	              also its filter input field, also its TDs); this will 
	              allow us to have for example one col hightlighted with 
	              different color what other cols; rather cool, isn't it?

	This covers only part of whole problematic. Please feel free to
write your notes to described issue and/or some new ideas. They are welcome
and appreciated!

	=Nepto=
____________________________________________________________________________
Ondrej 'Nepto' Jombik, Open Source software developer, http://www.platon.sk/

Re: [PHPMyEdit-Discuss] Changing the layout of the table

[Ondrej J. <ne...@po...>]

                                        Maxim, 08:15:55
                                        30. oktober 2002 (streda)
Greetings!

> My table is too wide though and I would like to be able to display the
> headings vertically showing one record at a time.  From reading the setup
> file I know how to show one record at a time and I know how to set the
> Database so that it only allows the user to view the data. What I do not
> know is what coding changes are necessary change the layout from
> horizontal to vertical.

	Well, till this morning I suppose, that it is impossible to do
something like this. But than I made up my mind, and found the way how to do
it. Basic principle is simple.

	You can force phpMyEdit to show only view page with "Change" button 
enabled. Another operation that will be possible is "Change". After record 
save, record view page will be displayed again. We should now only somelike 
to solve page navigiation on record view page to display prev/next record 
(because as you know there are only "Change" and "Cancel" buttons).

	It will be really strange to hardcode this particular and specific
functionality into core phpMyEdit class, so I'm coming with such new
phpMyEdit usability idea - extension. Extension is phpMyEdit_<something>
class, which extends core phpMyEdit class, but it also adds some new
functionality. Functionality described in paragraph before, will be for
example in class called phpMyEdit_slide (file phpMyEdit-slide.class.php).

	I will add some extensions into CVS under extensions/ subdirectory.  
There will be at least three: mentioned phpMyEdit_slide, phpMyEdit_report
for powerful table records reporting (already used) and phpMyEdit_tree for
tree data structure displaying (well, I use this in one CMS to handle
article messages, but it must be improved anyway). Although phpMyEdit
extensions will in CVS repository, they will not became official part of
distribution earlier than 6.0 release.

	So anyone interested in this should checkout phpMyEdit_slide
extension from CVS repository (instructions are at http://www.platon.sk/
website) and test it.

	=Nepto=
____________________________________________________________________________
Ondrej 'Nepto' Jombik, http://www.nepto.sk/              ne...@at...

Re: [PHPMyEdit-Discuss] Internationalization of PhpMyEdit ?

[Ondrej J. <ne...@po...>]

                                        Maxim, 10:56:42
                                        30. oktober 2002 (streda)
Greetings.

> What do you think about separating the displayed string like "Add",
> "Update",... in an external file ? That would bring the possibility to
> translate that file (a kind of language file), and so, to have the
> PhpMyEdit project translated into a large set of languages !

	Well, I'm quite unsure about the version of phpMyEdit you use.  
Multilanguage support was added by John McCreesh in 3.5 release and it
remains till this day (current are 5.1 stable and 5.1.7 development).

> I am volunteer to translate this file to French ! :-)  (I can also
> translate the http://phpmyedit.sourceforge.net website in french).

	French translation of phpMyEdit was already done by unknown author,
but anyway you are welcome with improving it and translating untrasnlated
expressions. Check lang/ subdirectory in distribution and/or CVS repository.

	=Nepto=
____________________________________________________________________________
Ondrej 'Nepto' Jombik, http://www.nepto.sk/              ne...@at...

Re: [PHPMyEdit-Discuss] Re : RE : How to join the development team ? (2 things I want adding in the phpmyedit project)

[Ondrej J. <ne...@po...>]

                                        Maxim, 11:04:10
                                        30. oktober 2002 (streda)
Greetings.

> > > - The possibility to have the details appearing in a popup box.
> > Please, if it is possible, be more descriptive about 
> > this issue. I completely do not understant an issue.
> When the generated file display a listing of the tuples from one table, it
> don't always display ALL the fields. We should add a "detail" button that
> display ALL the fields of one selected tuple inside a "popup" (one little
> HTML page) instead of displaying the details in the same window.

	None from my english dictionaries contain word "tuple". But I
suppose, that it is something like "record".

> In other terms, to give the possibility for the user to display the
> details of one tuple in a popup, and to keep the listing in the main
> windows. So, we have a new little window that appears with the details of
> the selected tuple.
> Am I clear enought ?  :-)

	Well, more clear. But what is the difference between this and view
functionality? You can turn on action icons (use $opts['navigation']) on
page. By clicking on view picture with opening in new window you will get
the same functionality as you have described.

> > You can join development by using this mailinglist. 
> > Send patches of files, or publish them on website. I will add them
> > and they will appear in further phpMyEdit distributions.
> Ok, can I send attachment files in the mailinglist or do I have to paste
> the code inside the message ?

	Small patches can be sent into mailinglist, bigger should be
published on website or they can be sent to me directly. ;-)

	=Nepto=
____________________________________________________________________________
Ondrej 'Nepto' Jombik, perl -le '$_=1;(1x$_)!~/^(11+)\1+$/&&print while$_++'

RE: [PHPMyEdit-Discuss] Internationalization of PhpMyEdit ?

[Hugues B. <hug...@sy...>]

I think this is a very good idea!!
:-)

Hugues-from-France.

> 
> What do you think about separating the displayed string like "Add",
> "Update",... in an external file ? That would bring the possibility to
> translate that file (a kind of language file), and so, to have the
> PhpMyEdit project translated into a large set of languages !
> 
> I am volunteer to translate this file to French ! :-)  (I can also
> translate the http://phpmyedit.sourceforge.net website in french).
> 
> What do you think about that ?
>