Re: [PHPMyEdit-Discuss] PHPMyEdit ideas

[Andreas U. <ma...@da...>]

On Tue, Jul 31, 2001 at 09:51:29AM -0600, jim kraai wrote:
> I should be releasing a new major version of PME in two 
> weeks with a bunch of new features.

Great news.
 
> Can I make some guesses as to how the interface would look?
> 
> Jump:  Select box with page numbers

That sounds good.

> For the callback, how would you do it?  I've thought it'd be 
> wise to emulate SQL triggers and use include files as stored 
> procedures, so an array like this in the code generated by 
> SETUP.PHP:
> 
> $triggers['ins']['pre'] = something;
> $triggers['ins']['post'] = something;
> $triggers['upd']['pre'] = something;
> $triggers['upd']['post'] = something;
> $triggers['del']['pre'] = something;
> $triggers['del']['post'] = something;
> 
> where something is either a filename or an unevaluated code 
> fragment passed to eval() later on.  I'd prefer the include 
> file, myself, due to issues with quoting and with eval().

'something' should be a function name. You can just
call the function using $triggers['ins']['pre']($parameters);

See manual/functions.variable-functions.html in the PHP manual.

> In the PME.inc file, do conditional includes or evals on 
> these somethings.  Any thoughts on the fact that MySQL 
> doesn't have native transactions?

I'm not too familiar with transactions so I can't comment on that.

On a unrelated note, if there's a 'description' set for the column,
PHPMyEdit fails to display the record if there's no matching entry
in the references table. I'd rather prefer if would display <null> or
something similiar, instead of supressing the whole record.

- Andreas
-- 
Check out my 3d lightcycle game GLtron at http://www.gltron.org/
More than 200'000 downloads of the latest version (0.61)