Databases
StackOverflow2013
Usersdbo
USDejv
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USDejv
    primarykey
    data
    text
    <p>If some logic needs to be defined I use PHP. That's PSR-2 for coding style, PSR-4 for autoloading, Composer for 3rd party libraries, Box for Phars and all that wrapped around PHP 7. To keep the code clean I use DI. If there is a lot of logic I throw in DIC. I try to use pragmatic approach when applying design patterns in software solutions. I consider overabstraction to be an antipattern as it usually makes code less readable, so don't expect me to create an implementation of some interface in a form of proxy class that substitudes some adapter class that is created by some factory and all that is part of some builder.</p> <p>I use PHPUnit for unit and integration testing and Selenium WebDriver for functional testing if necessary. In this order. We always try to make a pyramid, not a cone, right?</p> <p>I develop applications in Docker containers that are orchestrated by Docker compose.</p> <p>Sometimes I have to deal with errors thrown by platform applications that are 10+ years old. In combination with PHPStorm's integration of Xdebug, debugging of this spaghetti code became an easy game, making var_dump a deprecated feature. This method proved useful not only for development but also to provide interactive evidence to sysadmins that this deployed application really can't connect to that service because it uses these bad credentials which are by mistake loaded from this environment variable on this server.</p> <p>If application is slow, let me check bandwidth using iotop, server workload using htop and database slow queries using mytop. Then let me grab some Xdebug, profile the request and look at it using Webgrind. After that eliminating bottlenecks is usually easy.</p> <p>Lately part of my job has also been maintanance of CI &amp; CD processes for business applications that my division of company takes care of. I've been in close touch with both developers and sysadmin in order to resolve potential problems during code builds and deployment to testing, staging and production environment.</p>
    plurals
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COThank you for this :) ... Let me just note that there is no need to use global variables (initiated using "var") in this context.
      singulars
      1. PO
      1. USDejv
    2. COI'm not quite sure, if I take your code and insert it into fiddle accessible throw link you provided and I make a change that I suggested everything works perfect as well. ... It might be necessary to provide me with full code so I can better test it.
      singulars
      1. PO
      1. USDejv
    3. COThis is basic knowledge of PHP programming. You should probably study some more, go through some PHP tutorials etc. Just to get you started though, here is an explanation: This code prints [HTML link tag](http://www.w3schools.com/tags/tag_a.asp) that redirects to file 'product.php' which is PHP script that should be able to process GET request that contains variable 'product_id' with variable value (this value is defined in this script and is taken from variable `$product_id`)
      singulars
      1. POPhp passing variable names
      1. USDejv
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload