Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>a) the <strong>manual</strong> -- extremely comprehensive, up-to-date and just a huge source for inspiration while problem-solving - stuck? browse/search the manual, it'll come to you</p> <p>b) <strong>arrays</strong> - they're plastic, they're associatively indexed, they can be easily nested (!) to make up some wild data structures, and there's a multitude of functions just for array operations alone. Oh, and did I mention treating separate variables as an array of values?</p> <p>c) <strong>eval()</strong> and similar constructs (like dynamic variable and function names) which allow for much greater flexibility (and are still relatively safe provided you know what you're doing) - nothing beats a program that basically defines its own process flow (or even specific execution) on the fly</p> <p>d) most probably the easiest thing to overlook: as almost everything in the ZEND engine is a <strong>zVal</strong> (which in essence is a collection of pointer references), the ability to return about anything as a function return value</p> <p><br> Also, I'd like to point out one great feature, but one which is related more to PHP source than the language (and so - listed separately):</p> <p>e) the ease of writing <strong>C extensions</strong> (mostly interfaces for other objects like OpenAL or SDL) - great source code structure and about as many powerfull tools on the 'inside' as there are on the 'outside' - if you ever need to expand the functionality just that little bit further.</p>
    singulars
    1. This table or related slice is empty.
    1. POHidden Features of PHP?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USz-boss
    1. USEgon_Freeman
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI've been writing PHP full time for 5 years now, and haven't encountered a single situation in which I legitimately needed to use eval() or variable variables.
      singulars
      1. PO
      1. USFrank Farmer
    2. COReadability of eval()-using programs is ... ungood. Worse than "goto" imho, but just like "goto", might have legitimate uses.
      singulars
      1. PO
      1. USIvan Vučica
    3. CO@Frank: extremely useful when coding with someone doing extreme GET operations (near the URI length limit). Declare a table and drive through it with automatic sanitization of inputs. Wasn't extremely needed, but it made my life that much easier. @Ivan: I will agree, it's horrible. On the other hand, there are cases where similar - and yet different - functions need to center around a common core. At one point it was much easier for me to just generate these at runtime, since the accepted standard was to declare PHP functions as external commands used by the interface. Lots of time saved.
      singulars
      1. PO
      1. USEgon_Freeman
 

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