=====phpMyEdit===== >>**See also** [[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]]). phpMyEdit is released under the GNU GPL license. ====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-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 ... ---- CategoryUserContributions