Revision history for PhpMyEdit


Revision [22960]

Last edited on 2016-05-20 07:38:43 by NilsLindenberg [Replaces old-style internal links with new pipe-split links.]
Additions:
[[PhPMyEditDiscussion | Discussion-page]]>>::c::
PhpMyEdit generates PHP code for displaying/editing MySQL tables in HTML. All you need to do is to write a simple calling program (a utility to do this is included). It includes a huge set of table manipulation functions (record adition, change, view, copy, and remove), table sorting, filtering, table lookups, and more. (quote from the [[http://platon.sk/projects/main_page.php?project_id=5 | phpMyEdit homepage]]).
[[http://wikka.jsnx.com/downloads/phpMyEdit-for-Wikka.version1.tar.gz | phpMyEdit-for-Wikka.version1.tar.gz]]
Where do you go from here? [[http://platon.sk/projects/download.php?id=61 | Download]] and read the phpMyEdit documentation. The action file that was created for you is a starting point. The majority of the configuration can be done by editing the action file, but for advanced functionality read about triggers. You will need to create the trigger files manually.
Deletions:
[[PhPMyEditDiscussion Discussion-page]]>>::c::
PhpMyEdit generates PHP code for displaying/editing MySQL tables in HTML. All you need to do is to write a simple calling program (a utility to do this is included). It includes a huge set of table manipulation functions (record adition, change, view, copy, and remove), table sorting, filtering, table lookups, and more. (quote from the [[http://platon.sk/projects/main_page.php?project_id=5 phpMyEdit homepage]]).
[[http://wikka.jsnx.com/downloads/phpMyEdit-for-Wikka.version1.tar.gz phpMyEdit-for-Wikka.version1.tar.gz]]
Where do you go from here? [[http://platon.sk/projects/download.php?id=61 Download]] and read the phpMyEdit documentation. The action file that was created for you is a starting point. The majority of the configuration can be done by editing the action file, but for advanced functionality read about triggers. You will need to create the trigger files manually.


Revision [18359]

Edited on 2008-01-28 00:11:13 by NilsLindenberg [Modified links pointing to docs server]

No Differences

Revision [7555]

Edited on 2005-04-24 18:40:39 by NilsLindenberg [link to Discussion-page]
Additions:
>>**See also**
[[PhPMyEditDiscussion Discussion-page]]>>::c::


Revision [6947]

Edited on 2005-03-27 04:13:12 by JsnX [initial draft -- pretty much finalized]
Deletions:
http://wikka.jsnx.com/images/phpMyEditInstructions/phpMyEditWikka-setup-finish.gif


Revision [6945]

Edited on 2005-03-27 04:02:54 by JsnX [initial draft -- pretty much finalized]
Additions:
====phpMyEditWikka====
The phpMyEdit package has been modified to work seamlessly from within the Wikka environment. The modified package will be referrered to as phpMyEditWikka. If you are familiar with phpMyEdit, you'll be at home with phpMyEditWikka. The functionality is the same, but there have been some 'tweaks' to make it Wikka friendly (see 'Tech Notes' below for the list of modifications).
==Download==
[[http://wikka.jsnx.com/downloads/phpMyEdit-for-Wikka.version1.tar.gz phpMyEdit-for-Wikka.version1.tar.gz]]
===Usage===
- The phpMyEditWikka package has an expectation about where it is located in the Wikka directory.
- **You must** unzip the package and **place the phpMyEdit directory under 3rdparty/plugins/**.
http://wikka.jsnx.com/images/phpMyEditInstructions/phpMyEditWikka-file-upload.JPG
- After you have uploaded the files to the right folder, run the setup script.
- Using a web browser, go to **""http://yourdomain.com/wikka/3rdparty/plugins/phpMyEdit/phpMyEditSetup.php""**
You should see this...
http://wikka.jsnx.com/images/phpMyEditInstructions/phpMyEditWikka-setup-login.gif
- Enter in the MySQL database info and click Submit.
http://wikka.jsnx.com/images/phpMyEditInstructions/phpMyEditWikka-setup-selectdb.gif
- Select a database and click Submit.
http://wikka.jsnx.com/images/phpMyEditInstructions/phpMyEditWikka-setup-selecttable.gif
- Select a table and click Submit.
http://wikka.jsnx.com/images/phpMyEditInstructions/phpMyEditWikka-setup-selectid.gif
- Select a primary key and click Submit.
http://wikka.jsnx.com/images/phpMyEditInstructions/phpMyEditWikka-setup-selectoptions.gif
- Change the filename if you want and click Submit. This is the name that you use to call the action from within Wikka.
http://wikka.jsnx.com/images/phpMyEditInstructions/phpMyEditWikka-setup-finish.gif
http://wikka.jsnx.com/images/phpMyEditInstructions/phpMyEditWikka-setup-note-filename.gif
http://wikka.jsnx.com/images/phpMyEditInstructions/phpMyEditWikka-page-action.JPG
- Edit a Wikka page and put in a action call using the filename that was generated above.
http://wikka.jsnx.com/images/phpMyEditInstructions/phpMyEditWikka-page-final.JPG
- That's it. You should now have a view of your table.
===In closing...===
Where do you go from here? [[http://platon.sk/projects/download.php?id=61 Download]] and read the phpMyEdit documentation. The action file that was created for you is a starting point. The majority of the configuration can be done by editing the action file, but for advanced functionality read about triggers. You will need to create the trigger files manually.
I've been using phpMyEditWikka for about a month in a small production environment. I'm fairly confident that the bugs have been worked through.
This package has been a useful addition to my Wikka site. I hope you will find it useful too. Best wishes. -- JsnX, 26 March 2005
===Tech Notes: Modifications from the official phpMyEdit distribution===
==Setup file tweaks==
- The default access permissions are customized for Wikka. By default phpMyEdit allows everyone full access to MySQL tables, including deleting records. I find this to be a bit of a security risk. The default access in phpMyEditWikka allows registered Wikka users full access, non-registered users only have read access.
- The suggested filename is modified to remove underscore characters because Wikka actions cannot contain underscores.
- Three options were removed from the setup script because they are unnecessary or problematic within the Wikka environment:
- Page title.
- Page header.
- HTML header and footer.
- The display of the query time has been turned off by default.
- A new option gets added to each field: wikkaformatting. See above for more details. [... to be added ...]
- The default location where the class file is looked for has been modified.
- The location of the generated file was modified to save to the Wikka actions folder.
==Class file tweaks==
- ... to be added ...
Deletions:
====phpMyEdit and Wikka====
coming up....


Revision [6944]

The oldest known version of this page was created on 2005-03-27 01:55:23 by JsnX [initial draft -- pretty much finalized]
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki