michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2004-01-23 03:03
Back to top
Reply with quote
|
to improve documentation it would be great to have a sample database of 3-4 connected tables to show all possibilities of pme.
every options will be used in this sample db.
what model should this be ?
a classic writer-book-invoices,
a computer room :-)
|
nepto
Joined: 06 Jan 2003
Posts: 381
Location: Phoenix, Arizona (USA)
Posted: 2004-01-23 16:52
Back to top
Reply with quote
|
This is very good idea!
Such schema, and generated phpMyEdit scripts should be also used on the new website, to show users what phpMyEdit can do.
However we have to find an flexible example from life, where all phpMyEdit features can be shown. Ideas are welcome.
My very first idea - an company:
* persons / employees
* departments (every has one chief)
* etc.
_________________
Ondrej Jombik (Nepto)
Visit my
homepage
, review my recent
CV
or
projects
and give me some
feedback
.
|
michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2004-01-25 09:31
Back to top
Reply with quote
|
a very good beginning.
changes i would make:
- less tables (max 6) with better names
- a link from beggining to working samples (it took me a while to find them :-) )
- a looooot of playing with options
- some triggers
- links from sources to documentation and back (is this possible?)
|
hbernard
Joined: 23 Mar 2003
Posts: 159
Location: FRANCE
Posted: 2004-01-25 12:04
Back to top
Reply with quote
|
Just an idea :
Could we write a sample FAQ implementation ?
tables :
-faqentrys : main table,
* ID
* blob text
* title
* date submitted
* date updated
* faqcategories_ID
-faqcategories
* ID
* title
- links
* ID
* title
* URL
* faqentrys_ID
We could use it in real life (I think we need a FAQ)
And make a demo available for sample purpose ?
Maybe just another silly idea ;-)
|
michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2004-01-25 21:35
Back to top
Reply with quote
|
yes, faq would avoid a lot of forum questions :)
if db model:
-faqentrys : main table,
* ID
* * question some char
* * answer some char
(probably question == title and answer == blob)
(is blob searchable/filerable ? i'm not sure of implementation in MySQL)
last updated - via timestamp or a nice sqlw :) ? (i prefer the second one)
FAQ could be located at the top: Main | FAQ | Show bugs | ...
|
hbernard
Joined: 23 Mar 2003
Posts: 159
Location: FRANCE
Posted: 2004-01-25 21:47
Back to top
Reply with quote
|
| michal wrote: |
(probably question == title and answer == blob)
|
yep.
| michal wrote: |
| (is blob searchable/filerable ? i'm not sure of implementation in MySQL) |
Full text search is possible would be possible, but this is not a phpMyEdit feature.
This can be done with additionnal input box and playing directly on $opts['filters'];
| michal wrote: |
last updated - via timestamp or a nice sqlw :) ? (i prefer the second one)
|
Don't know.
We have to add some fields to show 'tab' feature.
We may use locking/unlocking to show some triggers.
Where can we use 'multiple select' ?
Can we write a list of feature we want to show and put our ideas in front ?
|
michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2004-01-25 22:06
Back to top
Reply with quote
|
| hbernard wrote: |
Full text search is possible would be possible, but this is not a phpMyEdit feature.
|
so let's make it a feature ;)
i meant searching for *word*
| hbernard wrote: |
We have to add some fields to show 'tab' feature.
|
since there are only 3 fields, this will be hard...
maybe second tab with some voting on questions (extra buttons in help area)
| hbernard wrote: |
We may use locking/unlocking to show some triggers.
|
of course, for change (answering questions)
| hbernard wrote: |
Where can we use 'multiple select' ?
|
if F to select several faqcategories (it is hard to find a better example)
| hbernard wrote: |
Can we write a list of feature we want to show and put our ideas in front ? |
shall we start a bug report to be able to post config files there ?
and i forgot, something like project_id in all tables (since there are 5 projects on this site)
|
hbernard
Joined: 23 Mar 2003
Posts: 159
Location: FRANCE
Posted: 2004-01-25 22:21
Back to top
Reply with quote
|
| michal wrote: |
| hbernard wrote: |
Full text search is possible would be possible, but this is not a phpMyEdit feature.
|
so let's make it a feature ;)
|
I'm on the way, but this is another story.
| michal wrote: |
i meant searching for *word*
|
filtering works with blob, if this is what you meant.
| michal wrote: |
shall we start a bug report to be able to post config files there ?
|
Nepto will answer to this.
| michal wrote: |
| and i forgot, something like project_id in all tables (since there are 5 projects on this site) |
Keep it simple. We're talking about phpmyedit, not platon.
|
nepto
Joined: 06 Jan 2003
Posts: 381
Location: Phoenix, Arizona (USA)
Posted: 2004-01-26 11:16
Back to top
Reply with quote
|
Well, here are my notes to the topics:
Some time ago, Doug made nice graphics, which I plan to use on the new phpMyEdit website. However due to lack of time, new website was never created.
We really need neew website, because phpMyEdit becomes more and more popular and I think it will be even more pupular when 5.4 stable with nice features will come out.
The new website could be hosted on phpMyEdit.org and maintained via Platon SDG CVS repository. I can give even more persons access to website repository. If there are some volunteers to build phpMyEdit website, just let us know.
It is part of this debate, what should be on that webite. I think at least this:
* introduction page, why is phpMyEdit so useful
* basic configuration, some nice up-to-date screenshots
* working demo (michal's idea above)
* link to download
* link to forum
* link to documentation
* anything else what could be useful
Website design do not need to follow Platon.SK design and I will be really happy if such design will be original in some acpect. However I have no problem if design will be similar to Platon.SK.
_________________
Ondrej Jombik (Nepto)
Visit my
homepage
, review my recent
CV
or
projects
and give me some
feedback
.
|
michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2004-01-26 17:38
Back to top
Reply with quote
|
i would also add:
* faq
* contributed extras (css files, js functions, themes, ...)
next two weeks i will be very busy, so currently i cannot contribute a lot. however you may expect my comments :)
|
hbernard
Joined: 23 Mar 2003
Posts: 159
Location: FRANCE
Posted: 2004-01-26 22:51
Back to top
Reply with quote
|
I would prefer the first one.
Maybe I will give it a try.
|
nepto
Joined: 06 Jan 2003
Posts: 381
Location: Phoenix, Arizona (USA)
Posted: 2004-01-27 15:17
Back to top
Reply with quote
|
First banner is nice.
However I would prefer that
"instant MySQL table editor and code generator"
would become an official phpMyEdit "motto".
But if there are some better ideas...
_________________
Ondrej Jombik (Nepto)
Visit my
homepage
, review my recent
CV
or
projects
and give me some
feedback
.
|
michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2004-02-22 01:48
Back to top
Reply with quote
|
discussed faq is located at http://phpmyedit.org/demo/ , faq link at top-left.
|
nepto
Joined: 06 Jan 2003
Posts: 381
Location: Phoenix, Arizona (USA)
Posted: 2004-04-20 13:09
Back to top
Reply with quote
|
So how we are on this?
If there is someone who want to make set of example scripts, please do so. Try to use as much phpMyEdit features as possible.
We need these scripts at least for testing purposes, to see if nothing major is not broken after fixing/implementing new issue.
_________________
Ondrej Jombik (Nepto)
Visit my
homepage
, review my recent
CV
or
projects
and give me some
feedback
.
|
nepto
Joined: 06 Jan 2003
Posts: 381
Location: Phoenix, Arizona (USA)
Posted: 2004-05-17 11:49
Back to top
Reply with quote
|
It is the same documentation as the one available for download. Platon.SK runs over phpMyEzin (Metafox by new). This content management system has posssibility to run any other PHP application under itself. In fact, it can run also remote applications and simple applications (pure HTML files).
So it basically includes HTML files. The name of these files are according to ID in DocBook SGML files. These IDs can change from time to time, but I suppose they are more or less stable.
Feel free to ask if you have more questions...
_________________
Ondrej Jombik (Nepto)
Visit my
homepage
, review my recent
CV
or
projects
and give me some
feedback
.
|
|
Post new topic
Reply to topic
Goto page 1, 2 Next
|
Login
Registration
Slovak
