2. PHPRunner General questions
  3. [SOLVED]   editable lists from mysql views
This topic is locked
[SOLVED]

  editable lists from mysql views

 		5/5/2010 5:38:25 PM
PHPRunner General questions
A
 AlexOZ author

I'm evaluating PHPRunner and seeking some advice. I'm putting together a play app to check my comfort level developing with PHPRunner. I'd like to have a list (from a MySQL view) and then have add/edit page accessible from a button similar to a normal list/edit arrangement that the generator creates. I'd like to use code to pick the appropriate column value as the primary key for the edit web page. I've already created the edit page through the standard generation.
I've tried inserting a button on the list screen and insert PHP code (I'm new to PHP) from combining some help examples, but failed. I'm not sure what goes in the three different parts of the button code - before server, at server, after server.
Appreciate any advice.
Thanks, Alex
Sergey Kornilov admin 5/5/2010

Alex,
could you clarify why standard Edit or Inline Edit procedure doesn't work for you?
A
 		AlexOZ author 5/5/2010



Alex,
could you clarify why standard Edit or Inline Edit procedure doesn't work for you?


Essentially I'm mapping relationships in a small Notemaking database as so:
TopicCategory -< Note -< NoteTag >- Tag where NoteTag represents a many-to-many relationship between Note and Tag. Tags are created in the background whenever a Note is created or updated, as the user types in a group of tags related to a particular note (perhaps space or comma separated). I want to have a list that combines information from TopicCategory, Note, and Tag that enables a user to add and edit Notes (via standard Edit). I'd already created the webpage for editing Notes via the generator. I hoping it would be a simple matter of creating a read-only list from a view and then adding a button to edit the Note (in a separate webpage) using column data from the row chosen.
I hope that claifies my thinking. Alex
J
 		Jane 5/6/2010

Alex,
you can join these tables on the Edit SQL query tab, then update multiple tables on the same page. Here is a sample:

http://xlinesoft.com/phprunner/docs/update_multiple_tables.htm
A
 		AlexOZ author 5/6/2010



Alex,
you can join these tables on the Edit SQL query tab, then update multiple tables on the same page. Here is a sample:

http://xlinesoft.com/phprunner/docs/update_multiple_tables.htm


Thanks I solved the issue. I added columns from related tables in the SQL screen. I was able to display (and search) on the list and the add/edit worked as before which I wanted. A very simple fix.
Alex