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

Re: [PHPMyEdit-Discuss] per record password protection

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

> I manage the website for a small club.  I want to create an events
> listing which members can update themselves, so they can
> add/change/delete an event record.  They would set a password (for
> that event) when adding an event and give the same password to
> change or delete the event.
> So far, I have added a line to add a password entry field to
> phpMyEdit.class.php after the code to add the delete button to the
> foot of the listing:

I completelly understand what is the problem/requirement. You are right, it
is currently not possible to do such thing with phpMyEdit and it is
uncertain for future.

The solution could be to have phpMyEdit extension for this. Extension will
provide the same functionality as phpMyEdit, but it will also add particular
password check where it is neccessary. The problem is, that currently I do
not have enough time to work on this. I'm glad that I have at least time to
work on 5.3 release.

You should also note, that blocking user before displaying change or delete
page is not complex solution anymore. You have to block particular action -
record deletion and change in addition to blocking these pages. Otherwise
your application will not be secure (since it will contain this ugly
vulnerability).

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  UNIX is user friendly. It's selective about who its friends are!
    '`

[PHPMyEdit-Discuss] per record password protection

[Julian R C B. <J.B...@dc...>]

Dear All,

I manage the website for a small club.  I want to create an events
listing which members can update themselves, so they can
add/change/delete an event record.  They would set a password (for
that event) when adding an event and give the same password to
change or delete the event.

So far, I have added a line to add a password entry field to
phpMyEdit.class.php after the code to add the delete button to the
foot of the listing:

if ($this->delete_enabled()) {
  echo '<input';
  if (! $total_recs) { echo ' disabled'; }
    echo ' type="submit" name="operation" value="'.$this->\
      labels['Delete'].'">&nbsp;';
  } // if else
}
echo ' <input type="password" name="inputpassword" size=12 \
  maxlength=12 value="inputpassword" >';

Now I need to ensure the encrypted inputpassword matches the stored
one for that event before displaying the change or delete pages.

Any ideas how I might do that?

Long term, I'd like such a feature built in to phpMyEdit.

Thanks

Julian

-- 
War on Iraq. Not in my name. www.stopwar.org.uk
Julian Briggs, Director of IT, Department of Computer Science, 
University of Sheffield, Regent Court, 211 Portobello St, Sheffield S1 4DP, UK
Phone +44 (0) 114-222-1851. Fax +44 (0) 114-222-1810
j.b...@sh...  http://www.dcs.shef.ac.uk/~julian

Re: [PHPMyEdit-Discuss] Re: Adding a Drop-Down Box to fields in the EDIT or ADD PAGE -- ANOTHER PROBLEM

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

Hi Julian,

> Thanks. I was able to produce a drop-down box on my edit page BUT now I
> am trying to call another table in the same database for which I have
> created a call program with phpMyEditSetup.php and phpMyEdit.class.php
> (always v. 5.2)  but it taking forever to print on the screen and when
> it does only the field name headings apear but all the data cells of the
> table are EMPTY and I am continually getting these error messages and do
> not understand why - since it worked the first time I tried to run it.
> Do you have any ideas why?  Julian
>     Warning: First argument to array_keys() should be an array in
> /var/www/html/ofmconv/phpMyEdit/phpMyEdit.class.php on line 1717
>     Warning: Wrong datatype in array_flip() call in
> /var/www/html/ofmconv/phpMyEdit/phpMyEdit.class.php on line 1717
> Fatal error: Maximum execution time of 30 seconds exceeded in
> /var/www/html/ofmconv/phpMyEdit/phpMyEdit.class.php on line 1123

This issue looks like some mystrerious bug. It will be great, if you can
submit information into Platon.SK bug-tracking system with uploading your
generated calling script and database table SQL dump as well.

If doing so, please provide also information about your Apache, PHP and
MySQL version. My considerations makes me assume, that this may be related
to old PHP interpreter version. However it should be verified.

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  UNIX is user friendly. It's selective about who its friends are!
    '`

[PHPMyEdit-Discuss] New phpMyEdit project management site

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

Hi phpMyEdit users,

I want to introduce and make proposal of two new fresh matters related to
phpMyEdit product.

1. New website location

Website has moved from http://phpmyedit.sf.net/ to http://phpMyEdit.org/
Nowadays, it is just cleaned old website with tiny improvements. The brand
new website, which will be available on this new address is currently being
prepared. Thanks belong to Doug Hockinson for providing this domain.

2. New project management page

The new project management page provide much more useful bug-tracking
engine, discussion forum for asking support questions or for brainstorming
about new features. There is also documentation browser, where is new HTML
and PDF documentation put online till times when 5.3 release will be out.
Finally, there is also download central, where you can download the latest
release of phpMyEdit, since it is not available from SourceForge anymore.

http://www.platon.sk/projects/main_page.php?project_id=5

Fell free to comment these issues or asking for more information if needed.
I know, that phpMyEdit has considerable userbase. The goal is to build
community, where people can help each other with phpMyEdit usage or provide
another interesting tips and tricks.

Thank you for your attention.

	Ondrej Jombik
	phpMyEdit maintainer
--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  UNIX is user friendly. It's selective about who its friends are!
    '`

[PHPMyEdit-Discuss] Re: Adding a Drop-Down Box to fields in the EDIT or ADD PAGE -- ANOTHER PROBLEM

[PCN-jzambanini <jza...@pc...>]

Thanks. I was able to produce a drop-down box on my edit page BUT now I =
am trying to call another table in the same database for which I have  =
created a call program with phpMyEditSetup.php and phpMyEdit.class.php =
(always v. 5.2)  but it taking forever to print on the screen and when =
it does only the field name headings apear but all the data cells of the =
table are EMPTY and I am continually getting these error messages and do =
not understand why - since it worked the first time I tried to run it. =
Do you have any ideas why?  Julian

    Warning: First argument to array_keys() should be an array in =
/var/www/html/ofmconv/phpMyEdit/phpMyEdit.class.php on line 1717
    =20

    Warning: Wrong datatype in array_flip() call in =
/var/www/html/ofmconv/phpMyEdit/phpMyEdit.class.php on line 1717=20

Fatal error: Maximum execution time of 30 seconds exceeded in =
/var/www/html/ofmconv/phpMyEdit/phpMyEdit.class.php on line 1123

Re: [PHPMyEdit-Discuss] Adding a Drop-Down Box to fields in the EDIT or ADD PAGE

[Jason <ok...@kd...>]

Julian,

    I was able to produce a pulldown box while editing a record with =
this code,

'values'=3D>array('course','coursecd','coursenm'),

just add the above anywhere in the $opts section

$opts['fdd']['COURSECD'] =3D array(
 'name'=3D>'COURSECD',
 'select'=3D>'D',
 'type'=3D>'string',
 'maxlen'=3D>3,
 'nowrap'=3D>false,
    'values'=3D>array('course','coursecd','coursenm'),
 'required'=3D>false,
 'sort'=3D>true
=20
);

I hope this is what you want to happen.  I also deleted the last , on =
'sort'=3D>true

Jason

  ----- Original Message -----=20
  From: PCN-jzambanini=20
  To: php...@li...=20
  Sent: Saturday, February 01, 2003 5:33 AM
  Subject: [PHPMyEdit-Discuss] Adding a Drop-Down Box to fields in the =
EDIT or ADD PAGE


  I just downloaded and installed phpMyEdit v.5.2 and all seems to be =
working well. My question is: Is it possible to add a drop-down box to =
edit or add data while editing a record.=20
  =
-------------------------------------------------------------------------=
---
  When I try the suggestion you gave to Roberto Cohen, I do get a =
drop-down box keyed on a second table (COURSES) but only the fields from =
that point on i.e. where I put the following code (in blue below) are =
displayed and the same is true when I view or edit the field - the =
listing of the fields starts at that point not displaying the 5 or 6 =
fields before this point. The code is the following:=20

  $opts['fdd']['COURSECD'] =3D array(
   'name'=3D>'COURSECD',
   'select'=3D>'D',
   'type'=3D>'string',
   'maxlen'=3D>3,
   'nowrap'=3D>false,
   'required'=3D>false,
   'sort'=3D>true,
  =20
  );

  $fdd['COURSECD']['values']['table'] =3D 'courses';
  $fdd['COURSECD']['values']['column'] =3D 'coursecd';
  $fdd['COURSECD']['values']['description'] =3D 'coursenm';
  $opts['fdd'] =3D $fdd;=20


  =
-------------------------------------------------------------------------=
--------
  I have been able to make the drop-down work on the main listing page =
following the directions at =
http://phymyedit.sourceforge.net/lookups.html and your answer to Roberto =
Cohen on the other Maillist where you wrote:=20

  "Re: curiosity... about values found in the specified column of =
another table=20
  2003-01-14 15:53=20
  > $opts['fdd']['codcity'] =3D array(=20
  > 'name'=3D>'Codcity',=20
  > 'select'=3D>'T',=20
  > 'type'=3D>'int',=20
  > 'maxlen'=3D>6,=20
  > 'nowrap'=3D>false,=20
  > 'required'=3D>true,=20
  > 'default'=3D>'0',=20
  > 'sort'=3D>true=20
  > );=20
  > $fdd['codcity']['values']['table'] =3D 'city';=20
  > $fdd['codcity']['values']['column'] =3D 'code';=20
  > $fdd['codcity']['values']['description'] =3D 'name';=20

  Write=20

  $opts['fdd'] =3D $fdd;=20

  at the end of your field declarations or use $opts['fdd'] instead of =
$fdd=20
  for fields definitions. So in your case it should looks like this:=20

  $opts['fdd']['codcity']['values']['table'] =3D 'city';=20
  $opts['fdd']['codcity']['values']['column'] =3D 'code';=20
  $opts['fdd']['codcity']['values']['description'] =3D 'name';"=20

  but this does not give me a drop-down on the edit page. Is there a way =
to do this.=20
  Thanks for any help you can give.=20
  Julian=20

              =20

[PHPMyEdit-Discuss] Adding a Drop-Down Box to fields in the EDIT or ADD PAGE

[PCN-jzambanini <jza...@pc...>]

I just downloaded and installed phpMyEdit v.5.2 and all seems to be =
working well. My question is: Is it possible to add a drop-down box to =
edit or add data while editing a record.=20
-------------------------------------------------------------------------=
---
When I try the suggestion you gave to Roberto Cohen, I do get a =
drop-down box keyed on a second table (COURSES) but only the fields from =
that point on i.e. where I put the following code (in blue below) are =
displayed and the same is true when I view or edit the field - the =
listing of the fields starts at that point not displaying the 5 or 6 =
fields before this point. The code is the following:=20

$opts['fdd']['COURSECD'] =3D array(
 'name'=3D>'COURSECD',
 'select'=3D>'D',
 'type'=3D>'string',
 'maxlen'=3D>3,
 'nowrap'=3D>false,
 'required'=3D>false,
 'sort'=3D>true,
=20
);

$fdd['COURSECD']['values']['table'] =3D 'courses';
$fdd['COURSECD']['values']['column'] =3D 'coursecd';
$fdd['COURSECD']['values']['description'] =3D 'coursenm';
$opts['fdd'] =3D $fdd;=20


-------------------------------------------------------------------------=
--------
I have been able to make the drop-down work on the main listing page =
following the directions at =
http://phymyedit.sourceforge.net/lookups.html and your answer to Roberto =
Cohen on the other Maillist where you wrote:=20

"Re: curiosity... about values found in the specified column of another =
table=20
2003-01-14 15:53=20
> $opts['fdd']['codcity'] =3D array(=20
> 'name'=3D>'Codcity',=20
> 'select'=3D>'T',=20
> 'type'=3D>'int',=20
> 'maxlen'=3D>6,=20
> 'nowrap'=3D>false,=20
> 'required'=3D>true,=20
> 'default'=3D>'0',=20
> 'sort'=3D>true=20
> );=20
> $fdd['codcity']['values']['table'] =3D 'city';=20
> $fdd['codcity']['values']['column'] =3D 'code';=20
> $fdd['codcity']['values']['description'] =3D 'name';=20

Write=20

$opts['fdd'] =3D $fdd;=20

at the end of your field declarations or use $opts['fdd'] instead of =
$fdd=20
for fields definitions. So in your case it should looks like this:=20

$opts['fdd']['codcity']['values']['table'] =3D 'city';=20
$opts['fdd']['codcity']['values']['column'] =3D 'code';=20
$opts['fdd']['codcity']['values']['description'] =3D 'name';"=20

but this does not give me a drop-down on the edit page. Is there a way =
to do this.=20
Thanks for any help you can give.=20
Julian=20

            =20

[PHPMyEdit-Discuss] Re: phpMyEdit.class.php on line 2398

[Jason <ok...@kd...>]

Hello,

    I figured it out.  I had the primary key, in the database named Key, I
changed the name to id, and the updates work.  Key must be a reserved word
in phpmyedit.

Thanks
Jason

----- Original Message -----
From: "Jason" <ok...@kd...>
To: <php...@li...>
Sent: Monday, January 27, 2003 4:59 PM
Subject: phpMyEdit.class.php on line 2398


> Hello,
>
>  I am running FreeBSD 4.7 / Mysql and have installed version phpmyedit 5.1
>
>  I am able to add new records to a generated webpage/database, just not
> change a record, I keep getting this error
>
> Warning: Supplied argument is not a valid MySQL result resource in
> /usr/local/www/phpmyedit/phpMyEdit.class.php on line 2398
>
> I produce the same results on a few computers with different versions of
> phpmyedit
>
> There are seven varchar(25) fields in the mysql table and one
auto_increment
> key field
>
> I have made no changes to the default generated phpmyedit php file.
>
>  I must copy and paste the generated php page to the root phpmyedit
folder,
> the permissions are unable to write to. not sure why.
>
> When I re-download the phpmyedit tar ball and extract it with ark, it
> defaults to a user 502 and group 100, how come?
>
> Thank you for your time and help,
>
>  Jason
>
> Sorry for the dup post
>
>

Re: [PHPMyEdit-Discuss] ['required'] = true will generate javascript to prevent null entries by users

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

> > Yes, I like the idea. Please post me a JavaScript "trim()" function
> Here is.
> I didn't study the core code of PHPMYEDIT.
> I think is better for us :o)
> I tested this  in IE 6.0 and Netscape 7.0 and is running OK to warning
> about "only spaces in form field".

Implemented in CVS. During testing I realized, that MySQL removes all
trailing spaces from the inserted string to database. I did not found any
information about this in manual? Has someone explanation for this?

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  UNIX is user friendly. It's selective about who its friends are!
    '`

[PHPMyEdit-Discuss] phpMyEdit.class.php on line 2398

[Jason <ok...@kd...>]

Hello,

 I am running FreeBSD 4.7 / Mysql and have installed version phpmyedit 5.1

 I am able to add new records to a generated webpage/database, just not
change a record, I keep getting this error

Warning: Supplied argument is not a valid MySQL result resource in
/usr/local/www/phpmyedit/phpMyEdit.class.php on line 2398

I produce the same results on a few computers with different versions of
phpmyedit

There are seven varchar(25) fields in the mysql table and one auto_increment
key field

I have made no changes to the default generated phpmyedit php file.

 I must copy and paste the generated php page to the root phpmyedit folder,
the permissions are unable to write to. not sure why.

When I re-download the phpmyedit tar ball and extract it with ark, it
defaults to a user 502 and group 100, how come?

Thank you for your time and help,

 Jason

Sorry for the dup post

Re: [PHPMyEdit-Discuss] new install instructions for 5.1

[Jason <ok...@kd...>]

Hello,

I am running FreeBSD 4.7 / Mysql and have installed version phpmyedit 5.1

I am able to add new records to a generated webpage/database, just not
change a record, I keep getting this error

Warning: Supplied argument is not a valid MySQL result resource in
/usr/local/www/phpmyedit/phpMyEdit.class.php on line 2398

I produce the same results on a few computers with different versions of
phpmyedit

There are seven varchar(25) fields in the mysql table and one auto_increment
key field

I have made no changes to the default generated phpmyedit php file.

I must copy and paste the generated php page to the root phpmyedit folder,
the permissions are unable to write to. not sure why.

When I re-download the phpmyedit tar ball and extract it with ark, it
defaults to a user 502 and group 100, how come?

Thank you for your time and help,

Jason

Re: [PHPMyEdit-Discuss] ['required'] = true will generate javascript to prevent null entries by users

[Roberto C. - S. S. <rob...@fi...>]

----- Original Message -----
From: "Ondrej Jombik" <ne...@po...>
To: "Roberto Cohen - SIAL Software" <rob...@fi...>
Cc: <php...@li...>
Sent: Wednesday, January 15, 2003 11:34 AM
Subject: Re: [PHPMyEdit-Discuss] ['required'] = true will generate
javascript to prevent null entries by users


> Yes, I like the idea. Please post me a JavaScript "trim()" function
implementation, I can add it in phpMyEdit. I suppose we can simple
remove  the current implementation by adding this feature, since
probably nobody  willl need ['required'] for spaces and/or other white
characters.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Here is.

I didn't study the core code of PHPMYEDIT.

I think is better for us :o)

I tested this  in IE 6.0 and Netscape 7.0 and is running OK to warning
about "only spaces in form field".



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
<SCRIPT LANGUAGE="JavaScript">

function Trim(trimInputString) {
  while(trimInputString.charAt(0)==" ")
  trimInputString=trimInputString.substring(1,trimInputString.length);

  while(trimInputString.charAt(trimInputString.length-1)==" ")

trimInputString=trimInputString.substring(0,trimInputString.length-1);

  return (trimInputString);
}


function page(){
   if (Trim(document.form1.name.value) == 0){
    alert("Please, fill information in name.")
    document.form1.name.focus();
    return false}

}

</SCRIPT>
</HEAD>

<BODY>

<FORM METHOD=post  NAME="form1" onSubmit="return page()">
your name: <input  name="name" size="30" >
<input type="submit" value="submit">
</TR>

</form>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


Regards.


Cordialmente

Roberto Cohen
Come to South Brazil
Porto Alegre - World Social Forum
http://www.forumsocialmundial.org.br

Re: [PHPMyEdit-Discuss] password()-function

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

> I've a table with a password-row where the
> password should be encrypted with the password()-
> function from mysql. I added "WC" to the options

The aim of password field is to have HTML password inputs present, not to
store entered data encrypted by MySQL's password(). Maybe we could consider
another flag for this job, but there are many things that need to be solved
before, for example how it should behave on "Change" page, etc.

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  UNIX is user friendly. It's selective about who its friends are!
    '`

Re: [PHPMyEdit-Discuss] multiple lookup colums(values)

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

> however when trying to have multiple colums and using below .... does not work
> reporting invalid sql query
> $opts['fdd']['act_con_idx']['values']['table']='contact';
> $opts['fdd']['act_con_idx']['values']['description']['columns']['1']='profile';
> $opts['fdd']['act_con_idx']['values']['description']['divs']['1']   ='-';
> $opts['fdd']['act_con_idx']['values']['description']['columns']['2']='phone_1';

This should work. Maybe is something broken. I will make a look at the issue
before 5.3 realease.

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  Nech operacia X na mnozine G tvori grupu, potom plati...  rundu!
    '`

[PHPMyEdit-Discuss] password()-function

[Thomas K. <kro...@we...>]

Hello,

I've a table with a password-row where the
password should be encrypted with the password()-
function from mysql. I added "WC" to the options

$opts['fdd']['passwd'] = array(
         'name'=>'Passwd',
         'select'=>'T',
         'type'=>'string',
         'maxlen'=>30,
         'nowrap'=>false,
         'required'=>true,
         'options'=>'WC',
         'sort'=>true
);

but the password is written in clear text into the DB.
Any hints?

Regards,
Thomas.

[PHPMyEdit-Discuss] datemask

[Ross J. <rj...@fi...>]

 ['datemask'] a string that is used by date() to format date fields

Does this option work...
I cannot seem to implement it
Could we have an example please

[PHPMyEdit-Discuss] multiple lookup colums(values)

[Ross J. <rj...@fi...>]

Compliments on a great scipt... I am using extensively..

Need help to write correct syntax

This definition works fine...

$opts['fdd']['act_con_idx'] =3D array(
 'name'=3D>'Contact',
 'select'=3D>'D',
 'type'=3D>'string',
 'maxlen'=3D>5,
 'nowrap'=3D>false,
 'sort'=3D>true,
 'values'=3D>array(
 'db'=3D>'xxxx_mgmt',
 'table'=3D>'contact',
 'orderby'=3D>'profile',
 'column'=3D>'con_idx',
 'description'=3D>'profile')
);

however when trying to have multiple colums and using below .... does =
not work
reporting invalid sql query

$opts['fdd']['act_con_idx'] =3D array(
 'name'=3D>'Contact',
 'select'=3D>'D',
 'type'=3D>'string',
 'maxlen'=3D>5,
 'nowrap'=3D>false,
 'sort'=3D>true
);
$opts['fdd']['act_con_idx']['values']['db']=3D'xxxx_mgmt';
$opts['fdd']['act_con_idx']['values']['table']=3D'contact';
$opts['fdd']['act_con_idx']['values']['orderby']=3D'profile';
$opts['fdd']['act_con_idx']['values']['column']=3D'con_idx';
$opts['fdd']['act_con_idx']['values']['table']=3D'contact';       =
$opts['fdd']['act_con_idx']['values']['description']['columns']['1']=3D'p=
rofile';
$opts['fdd']['act_con_idx']['values']['description']['divs']['1']   =
=3D'-';
$opts['fdd']['act_con_idx']['values']['description']['columns']['2']=3D'p=
hone_1';

 please help

Re: [PHPMyEdit-Discuss] how do I...

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

> So the User get's signed on. Selects 10 different flowers from the
> MasterFlowerTable and then those id's are put into the UserFlowerTable.
> 
> Is there a way to have checkbox's on the MasterFlowerTable display so that
> the user can select a number of flowers?
> Is there a way when updating the masterflower table to show the Weed as a
> radio button (*) Yes () No?

The thing you wanted from phpMyEdit is called M:N database binding and is
planned on long term TODO list for version 6.0. It is currently impossible
to do such thing, however you can create in example 10 flower ID fields in
your user table and for every create simple 1:M database bind.

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  Nech operacia X na mnozine G tvori grupu, potom plati...  rundu!
    '`

[PHPMyEdit-Discuss] how do I...

[cryst <cr...@go...>]

I'm sure there is a simple answer but I'm going cross eyed looking at the
code.

What I want to do is have a user list, where a user can select from a master
list of items to put into a table...

eg.

user_table
UserID            int
UserName
password

MasterFlowerTable
FlowerID            int
Weed                boolean
FlowerName
FlowerColor
etc.


UserFlowerTable
UserID        int (maps to user_table UserID)
FlowerID    int (maps to MasterFlowerTable FlowerID).

So the User get's signed on. Selects 10 different flowers from the
MasterFlowerTable and then those id's are put into the UserFlowerTable.

Is there a way to have checkbox's on the MasterFlowerTable display so that
the user can select a number of flowers?
Is there a way when updating the masterflower table to show the Weed as a
radio button (*) Yes () No?

Or am I expecting (hoping) for too much out of this software?

Chris Bruner

Re: [PHPMyEdit-Discuss] PT-BR... updated...

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

> Ondrej, is your account ne...@po... closed?
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> "<ne...@po...>: host smtp.pobox.sk[212.5.216.21] said: 550
> Administraively  closed, contact pos...@u2..."
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I do not know what is the matter. Maybe some administration time.

> I do not understand why are many expressions without capital
> letter...
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> I'm sorry.
> This is a personnal preference.
> It's going now a standard file to international distribution (if you
> desire) with correct presentation.

I already commited file yesterday with your changes, however capital letters
were not removed. Hope it is OK now.

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  UNIX is user friendly. It's selective about who its friends are!
    '`

Re: [PHPMyEdit-Discuss] ['required'] = true will generate javascript to prevent null entries by users

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

> Suggestion, if possible, for next versions:
> Situation: adding a record with required = yes...
> Some customers may type spaces in the form field and then click ADD.
> How about applicate, in next versions, a TRIM operation inside the
> javascript function?
> There are a lot of similar routines (TRIM simulation to javascript) in
> www.google.com that runs well.

Yes, I like the idea. Please post me a JavaScript "trim()" function
implementation, I can add it in phpMyEdit. I suppose we can simple remove
the current implementation by adding this feature, since probably nobody
willl need ['required'] for spaces and/or other white characters.

Concerning to my last CVS update, the possibility of ['required'] for
selects and multiple selects were implemented. However the detection is not
provided different way as in text input boxes case. Another problem was,
that multiple selects havetheir names like this[], thus cannot be simply
used in JavaScript code (theForm.multiple_select[].something causes syntax
error).

I was able to deal with all of these problems, so enjoy null entries
preventing in mutiple selects. But anyway, coding in JavaScript is not the
think I anyhow like. :-)

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  Nech operacia X na mnozine G tvori grupu, potom plati...  rundu!
    '`

[PHPMyEdit-Discuss] ['required'] = true will generate javascript to prevent null entries by users

[Roberto C. - S. S. <rob...@fi...>]

Suggestion, if possible, for next versions:

Situation: adding a record with required = yes...

Some customers may type spaces in the form field and then click ADD.

How about applicate, in next versions, a TRIM operation inside the
javascript function?

There are a lot of similar routines (TRIM simulation to javascript) in
www.google.com that runs well.

Regards.

Roberto Cohen
Diretor Geral - SIAL Software
Fone: +55-51 3321.2566  ramal 215

Re: [PHPMyEdit-Discuss] curiosity... about values found in the specified column of another table

[Roberto C. - S. S. <rob...@fi...>]

----- Original Message -----
From: "Ondrej Jombik" <ne...@po...>
To: "Roberto Cohen - SIAL Software" <rob...@fi...>
Cc: <php...@li...>
Sent: Tuesday, January 14, 2003 7:46 PM
Subject: Re: [PHPMyEdit-Discuss] curiosity... about values found in
the specified column of another table



> Write
>
> $opts['fdd'] = $fdd;
>
> at the end of your field declarations or use $opts['fdd'] instead of
$fdd
> for fields definitions. So in your case it should looks like this:
>
> $opts['fdd']['codcity']['values']['table'] = 'city';
> $opts['fdd']['codcity']['values']['column'] = 'code';
> $opts['fdd']['codcity']['values']['description'] = 'name';
>
> Let me know, if that helps you.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Yes, very nice.

Thanks a lot.

Come to my city (site in english too):

http://www.portoalegre2003.org/

http://www.forumsocialmundial.org.br/


Cordialmente

Roberto Cohen
Diretor Geral - SIAL Software
Fone: +55-51 3321.2566  ramal 215

[PHPMyEdit-Discuss] PT-BR... updated...

[Roberto C. - S. S. <rob...@fi...>]

Ondrej, is your account ne...@po... closed?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"<ne...@po...>: host smtp.pobox.sk[212.5.216.21] said: 550
Administraively  closed, contact pos...@u2..."
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Please, read the follow message.

:o)

Thanks

Cohen


----- Original Message -----
From: "Ondrej Jombik" <ne...@po...>
To: "Roberto Cohen - SIAL Software" <rob...@fi...>
Sent: Tuesday, January 14, 2003 7:54 PM
Subject: Re: [PHPMyEdit-Discuss] PT-BR... updated...


Here is my translating for new options for our language file.

I do not understand why are many expressions without capital
letter...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I'm sorry.

This is a personnal preference.

It's going now a standard file to international distribution (if you
desire) with correct presentation.

See you in Brazil.


Cordialmente

Roberto Cohen
Diretor Geral - SIAL Software
Fone: +55-51 3321.2566  ramal 215

Re: [PHPMyEdit-Discuss] curiosity... about values found in the specified column of another table

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

> $opts['fdd']['codcity'] = array(
>  'name'=>'Codcity',
>  'select'=>'T',
>  'type'=>'int',
>  'maxlen'=>6,
>  'nowrap'=>false,
>  'required'=>true,
>  'default'=>'0',
>  'sort'=>true
> );
> $fdd['codcity']['values']['table'] = 'city';
> $fdd['codcity']['values']['column'] = 'code';
> $fdd['codcity']['values']['description'] = 'name';

Write

$opts['fdd'] = $fdd;

at the end of your field declarations or use $opts['fdd'] instead of $fdd
for fields definitions. So in your case it should looks like this:

$opts['fdd']['codcity']['values']['table'] = 'city';
$opts['fdd']['codcity']['values']['column'] = 'code';
$opts['fdd']['codcity']['values']['description'] = 'name';

Let me know, if that helps you.

--
  _/|   Ondrej Jombik - ne...@ph... - http://www.nepto.sk - OJ812-RIPE
 <_  \  Platon SDG - open source software development - http://platon.sk
   `\|  UNIX is user friendly. It's selective about who its friends are!
    '`