<i>When you edit a row in phpMyAdmin and you submit, there is logic that<br>
checks which column has been changed and updates only what is needed.<br></i><br>Is there any example in pma codebase I can use it for reference?<br><br><i>How many settings do you plan to cover?<br></i><br>I plan the cover all the settings that are currently under consideration. As you said, we can include more settings after we have a test prototype.<br>
<br>I was wondering how settings such as PropertiesIconic are applied. I was able to change it manually, so is it directly read from config file each time?<br><br>Also, I was wondering what are your thoughts above moving the link to user prefs interface in navigation.php?<br>
<br>Thanks!<br><br clear="all">--------------------------------------------------<br>Best regards,<br>Zeeshan Mughal<br>Email: <a href="mailto:zeeshanmughal@ieee.org">zeeshanmughal@ieee.org</a><br>Web: <a href="http://www.zixan.info">http://www.zixan.info</a><br>
<br><br><div class="gmail_quote">On Tue, Jul 21, 2009 at 4:19 AM, Marc Delisle <span dir="ltr"><<a href="mailto:marc@infomarc.info">marc@infomarc.info</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Zeeshan M. a écrit :<br>
<div class="im">> Hi,<br>
><br>
> Thanks so much for all the help. :-)<br>
><br>
> - Using PMA_query_as_controluser() gives me "undefined method" error. I<br>
> am using PMA_DBI_fetch_result() instead which seems to work OK.<br>
<br>
</div>Not acceptable, as it won't work when the logged-in user has no access<br>
to the pmadb. There is a reason why it's undefined: you did not include<br>
the library file where this is defined.<br>
<div class="im"><br>
><br>
> - I have created a readme file, which, for now contains dummy data for<br>
> pma_perm_usr_pref table.<br>
><br>
> - I will include the link to usr setting interface in navigation.php,<br>
> and remove it from main homepage later on. For now, I want to focus on<br>
> implementing back-end logic for the form.<br>
><br>
> - I put the custom CSS code I wrote in all three CSS files in<br>
> /themes/original/css/ directory but it did not seem to be working. So,<br>
> I have included back the CSS code into the original file, too.<br>
</div>Maybe it did not work because you did not clear your browser cache.<br>
<div class="im"><br>
><br>
> - All current values of settings are stored in vars in the following<br>
> format: $current_[setting_name] after being extracted from the<br>
> database. I was initially thinking about using JS to select the current<br>
> value by default. My implementation required looking up index of the<br>
> "current value" (extracted from db) in select menu. I hope it it<br>
> possible, but I could not find a away to accomplish it. In an ideal<br>
> case, if I know the index, I can apply 'selected="selected"' attribute<br>
> to that specific option. Any other suggestions, please?<br>
><br>
> - My most recent plan for this project included having a submit for each<br>
> setting along with the submit to update all the settings. I originally<br>
> thought about it as I was thinking it would be a better user interaction<br>
> practice. But now I am thinking it might complicate things for the user<br>
> if he sees multiple submit button. May be having some nifty little<br>
> image next to each setting, and using AJAX to update the setting will do<br>
> justice to users. Well, for now, there is only one submit button that<br>
> would update all settings.<br>
<br>
</div>When you edit a row in phpMyAdmin and you submit, there is logic that<br>
checks which column has been changed and updates only what is needed.<br>
<div class="im">><br>
> I am projecting that I may be able to complete the front-end user<br>
> interface, and back-end logic to fetch and update settings by the end of<br>
> this week. Hopefully, if goals are accomplished, I will move on to<br>
> implementing AJAX for an enhanced user interaction and experience, which<br>
> may take about half of a week.<br>
<br>
</div>How many settings do you plan to cover?<br>
<div class="im"><br>
><br>
> If things go according to plans, hopefully, I may work on the auto table<br>
> update feature for tables in phpmyadmin database you expected me to do.<br>
> I really find this project very interesting, and I think it will be a<br>
> worthwhile learning experience.<br>
><br>
><br>
> I am also attaching the most recent version of patch. There is not much<br>
> development in terms of processing user input. But it might be of some use.<br>
<br>
</div>Please put your patches on phpMyAdmin's patch tracker instead of sending<br>
them on this list.<br>
><br>
><br>
> Thanks!<br>
><br>
> -<br>
<font color="#888888"><br>
--<br>
</font><div><div></div><div class="h5">Marc Delisle<br>
<a href="http://infomarc.info" target="_blank">http://infomarc.info</a><br>
<br>
------------------------------------------------------------------------------<br>
Enter the BlackBerry Developer Challenge<br>
This is your chance to win up to $100,000 in prizes! For a limited time,<br>
vendors submitting new applications to BlackBerry App World(TM) will have<br>
the opportunity to enter the BlackBerry Developer Challenge. See full prize<br>
details at: <a href="http://p.sf.net/sfu/Challenge" target="_blank">http://p.sf.net/sfu/Challenge</a><br>
_______________________________________________<br>
Phpmyadmin-devel mailing list<br>
<a href="mailto:Phpmyadmin-devel@lists.sourceforge.net">Phpmyadmin-devel@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel</a><br>
</div></div></blockquote></div><br>