Recent changes to support-requests

Now on GitHub

2020-10-06T18:16:44.608000Z

A few fixes and example are now available at:
https://github.com/apmuthu/phpMyEdit

set_magic_quotes_runtime() error solved

2013-04-25T12:52:41Z

the set_magic_quotes_runtime() command is not longer supported by PHP since version PHP 5.3. 1. The definition in the PhpMyEdit-Class set_magic_quotes_runtime(0) is not necessary anymore because the default is conform to magic_quotes_runtime switched of. In the attacemet You find the class with the changes to rum PhpMyEdit under PHP 5.3. 1 and over.

ereg_replace error solved

2013-02-27T21:32:49Z

since PHP version 5.3.0. the funktion "ereg_replace" does exist no longer. This causes lots of error-messages in longer text-fields. To solve this problem change in the "phpMyEdit.class.php" the line "$value = ereg_replace("[\r\n\t ]+",' ',$value);" in my editor line number 1440 to "$value = str_replace("[\r\n\t ]+",' ',$value);". This should be considered in further versions.

Subform

2003-02-14T14:22:56Z

Hi there!

Is there any way to implement "subforms"?
For example, if I want to register an order, I'll have just
one client, one shipping adress, but one to many
different products in different quantities...
Of course I could fix one to ten instead of one to many,
but it's heavy to implement for the application I need...

Thanks,

Hugues

phpMyEdit Change Doesn't work with Mozilla

2003-02-10T20:54:21Z

I have a very plain vanilla SQL table and the generated
code from phpMyEdit. Everything seems to work fine
EXCEPT the Change / Save .... In Mozilla (and possibly
other Netscape type browsers) it simply returns as if
it works but nothing actually happened.

I tried the EXACT same script / DB with IE and it
worked like a champ.

#
# Table structure for table `FOS`
#

CREATE TABLE FOS (
id int(4) NOT NULL auto_increment,
District varchar(20) NOT NULL default '',
Area char(1) NOT NULL default '',
goal int(8) NOT NULL default '0',
current int(8) NOT NULL default '0',
PRIMARY KEY (id),
KEY District(District)
) TYPE=MyISAM;

Work with a subset of a table?

2003-02-09T18:48:29Z

Is there a way to have phpMyEdit only work with a
subset of a table. Say for example you have a database
of all of the phone numbers in a company. There is an
office column. You want and editor so that the New
York office only edits New York phone numbers. I know
I can make the query say where office ='New York'.
But when I do that I still need to be able to fill in the
office column when I do an insert. How can I do that?

Change / Update Error (delete works fine)

2003-02-04T11:00:33Z

Sorry for not beeing able to supply an sql dump of what
happens :-(

My Problem is that everything runs fine except that i can
not update entries in the db. Deleting whole entries
works fine, but when I try to update a record nothing
happens, no error is spit out, only one small thing is
reported back when returning to the overview after
applying the changes "-1 record changed"

I have defined an identifier key (which is set to be a
primary index key with auto_increment in the db)

The key works fine, with debug output enabled i can see
that the right key number is passed through the script.

I've tried changing the submit form methods (was
mentioned here in the forum as a possible solution)

Here is some data from the sources:

// Name of field which is the unique key
$opts["key"] = "index";
// Type of key field (int/real/string/date etc)
$opts["key_type"] = "int";

// -> this should be alright

$opts['fdd']['index'] = array(
'name'=>'Id',
'select'=>'T',
'type'=>'int',
'maxlen'=>11,
'nowrap'=>false,
'required'=>false,
'sort'=>false,
'options'=>''
);

// -> this is my definition for the key table, as you can
see it is hidden right now, but changing its options /
unhiding it / setting it to be the first field sorted has
never changed the effect, no updates are written back to
the db

// this is part of the sql table structure
CREATE TABLE tablename (
index int(11) NOT NULL auto_increment,
// stripped here
PRIMARY KEY (index),
KEY index (index)
) TYPE=MyISAM;

Is this correct? I'm not that sql guru i'd like to be ;-)

My Sql Server Version is : 3.23.54
PHP Version is 4.2.3

Sorry for my bad english & missing dumps / logs.

Btw: What about developing phpmyedit as a module for
cms like postnuke or phpnuke? I've overlooked it one
day, and in my opinion this would be a relative simple
task (just put your sources in an empty module,
changed the page_name parameter handling to reflect
the "calling from one single file" design of those cms
and voila, works 95% (some links in the source like for
the filtering still use some sort of "basename
($HTTP_SERVER_VARS['PHP_SELF']);" - which
results always in modules.php (for phpnuke) - changing
this to allow the page name / url for linking from the
script to be passed through to your code could surely be
managed.

Thanks for your time & help
Yoshi Z.
(where did I put my sf login?)

Move to new page after adding record

2003-01-28T11:45:12Z

Hi,

i'm not very gifted at php nor mysql, so forgive my silly
question plz.

I'm using phpMyedit in a slightly different way, than it
might be intended: to present 'users' with a form to fill in
and add that info into the database. To do this i go
through the normal process of creating the code for a
table (say an adresstable). I go to the create page
(adress.php) press submit, and get presented with
the 'normal' defined formfields to fill in.

I copy the source code of this page and name it
address_inpup.php, which i present to a user to add his
adress. This script still calls adress.php (which it
needs).

However (and now for the problem) after a user has
submitted the form, i want to direct them to a new page,
like a 'thank you ur info has been submitted'. And not to
be 'adress.php' table of all address with the option to
submit again.

How can i do this?

I might be using phpMyEdit in a wrong way, but so far,
this is the only way i've managed to create a form that
adds info directly into a database.

Hope i've been able to make it clear.

Yoram

URL not clickable

2003-01-25T19:00:38Z

In de latest version of PHPMyEdit (5.2), the field definition
URL
is not clickable anymore. Furthermore what is lhe
$value
parameter for Mailto: supposed to represent?.
Best Regards
Chris Meeder

I have a problem in my remote server

2003-01-06T17:37:52Z

Everything works fine in localhost, but on my
remote server I only obtain the name of the table in
the page & no errors.
For your information phpMyEditSetup cant´t create
the caller php file in my remote server (it can´t list
the existing dbs), so I copy it from my local with
the proper changes in hn, un, pw, db, etc... and
make available phpMyEdit.class.php
Is there a basic test I could take? This behavior it
happens with all of my dbs. I´ll appreciate any
advice on this issue.

Excuse me if this is too basic, but I´m a beginner
and It´s important for me if I could solve this ASAP
because I have a urgent project already developed
in my local machine, but phpMyEdit is a critical
part and still doesnt´work in my remote Linux
Server.

Thanks for your great work!