Hello
I am wondering how I can get help on using PHPMyAdmin? I tried searching the forum but couldn't find an answer.
I am not a programmer and am generally clueless on how this all works!!
Anyway, my database is collecting customer information - there are a 8 data fields per customer record.
When I do a CSV export of the data, each data item is on it's own line. So one customer record is 8 lines of export.
I want to export to CSV so each customer record is one line and the data items are separated by commas (i.e. 1 line will contain the 8 data items per customer separated by a comma)
Can you direct me to someone who can help me in PHPMyAdmin?
Thanks so much.
Marcy
Hi,
I was going to start writing UTs for libraries/properties*. I was wondering if its okay to include all tests for libraries/properties/options/items* into one file as they all have just one function. Or should I create a single test class for each of the classes in that folder?
Thanks!
--
Ayush Chaudhary
Error reports are submitted individually and are stored individually
in the database. however I am not sure of the usage statistics of
phpmyadmin however exceptions happen and an automated report system is
bound to send a huge amount of error reports.
The system should be able to mark a report as related to another
report either manually or hopefully automatically with some degree of
effectiveness. When a developer views an error report should I display
only the information in that error report or should I show the info in
related error reports as well. for example if this specific report
came from a chrome 23.7.5.253 browser and just provide links at the
bottom to related reports or I can show the browser versions in
related error reports as well.
The good thing about showing the related info in the same report is
that the developer may be able to see patterns to help diagnose the
problem however the problems is that it would clutter the interface
and there may be alot of differences in the reports that every report
is different and there may be a 1000 different browser versions
affected in the related reports if for example it has nothing to do
with browser versions.
Hi devs,
According to my research I couldn't find any place where the variable
$selected is set which is used in sql.php. Also this variable is used to
check indexes if indexes should be checked in sql.lib.php. I am not sure
about what is meant by checking an index. But since $selected seems to be
not initialized this code will never run. I would like to know your opinion
on this issue.
regards supun.
Hi, I just took a bug report/suggested fix from "an anonymous IRC user"
who doesn't have a SourceForge or github account. The thing is, I can't
reproduce it. Does anyone have any comment on this?
I 'm running latest 4.0.4.1 and wanted to change a server variable, but
every time I clicked on one I got a token mismatch. Turns out, line 128
of server_variables.php does:
$url = htmlspecialchars('server_variables.php?' .
PMA_generate_common_url());
The html special chars converts an '&' to & where it shouldn't. This
effectively makes it impossible to change any server variables via
phpMyAdmin. Changing it to:
$url = ('server_variables.php?' . PMA_generate_common_url());
(kill the htmlspecialchars())
works. But I'm not certain this would be the correct fix.
Hi,
I have been writing Unit Tests for classes and libraries under libraries/config/*. For isolation between different libraries, its preferred to mock certain functions. Since some of the code is functional, I tried to convert (for a start) libraries/config/validate.lib.php into a class with static methods.
However, the issue here is that mocking static methods is not really possible with PHPUnit and there are a few workarounds I came across and would like to know which one should we go for, or if there is anything better that can be done.
So, while the writer of PHPUnit specifies how to mock static methods here[0], its only possible if the static calls are to the same class.
For example, for testing FormDisplay::_validate, I need to mock PMA_config_validate. After I convert validate.lib.php to a class, say, PMA_Validator, I will have to mock PMA_Validator::config_validate, but the above solution won't work here (since PMA_Validator cannot be mocked). A workaround for this could be to pass the mocked static class as mentioned in [0] to the FormDisplay.class.php and make all static calls via that class.
For this, we could have something of this sort in the constructor of FormDisplay:
if (defined('TESTSUITE'))
$this->validator = $GLOBALS['dummyValidator'] or $this->validator = <mockedClassPassedInTheArgument>
else
$this->validator = 'PMA_Validator'
and the calls can be made like:
$caller = $this->validator; // $this->validator::config_validate won't work
$caller:config_validate();
Another solution could be what is mentioned in a blog here[1]. The problem with this solution is that the file, FormDisplay.class.php would include and hence declare the PMA_Validator class before our test suite tries to (re)declare it by extending MockProxy class.
In either case, it looks like some sort of modification would be needed to test these classes.
Please advice.
[0] http://sebastian-bergmann.de/archives/883-Stubbing-and-Mocking-Static-Metho…
[1] http://www.deanspot.org/content/mocking-static-method-calls-phpunit
--
Ayush Chaudhary
Hi devs,
I am facing a difficulty in setting up the goals for the week 5. I think I
have considerably refactored the sql.php using extract method. I would like
to hear from you whether I should consider further refactoring using
extract method or any other suggestions to work on during the next week.
Regards Supun
Hi Kasun,
I may be missing it, but in your recent work[1] is there a way to see
which users are in a usergroup?
Perhaps an additional link from the Action column of the User groups
area of the Users page with the text "View users" or something????
Copying the phpmyadmin-devel list to see if others think this would be
useful and get input on the location/label of the link.
1 - https://github.com/phpmyadmin/phpmyadmin/pull/484