Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <blockquote> <p>Good reference material on how to code an event-driven application</p> </blockquote> <p>You can either do this with <a href="http://php.net/manual/en/language.pseudo-types.php">"dumb" callbacks</a> (<a href="http://codepad.viper-7.com/bJJNif">Demo</a>):</p> <pre><code>class Hooks { private $hooks; public function __construct() { $this-&gt;hooks = array(); } public function add($name, $callback) { // callback parameters must be at least syntactically // correct when added. if (!is_callable($callback, true)) { throw new InvalidArgumentException(sprintf('Invalid callback: %s.', print_r($callback, true))); } $this-&gt;hooks[$name][] = $callback; } public function getCallbacks($name) { return isset($this-&gt;hooks[$name]) ? $this-&gt;hooks[$name] : array(); } public function fire($name) { foreach($this-&gt;getCallbacks($name) as $callback) { // prevent fatal errors, do your own warning or // exception here as you need it. if (!is_callable($callback)) continue; call_user_func($callback); } } } $hooks = new Hooks; $hooks-&gt;add('event', function() {echo 'morally disputed.';}); $hooks-&gt;add('event', function() {echo 'explicitly called.';}); $hooks-&gt;fire('event'); </code></pre> <p>Or implementing a pattern often used in event-driven applications: <a href="http://en.wikipedia.org/wiki/Observer_pattern"><em>Observer Pattern</em></a>.</p> <blockquote> <p>Code snippet(s) showing how to put a "hook" in a function in PHP</p> </blockquote> <p>The manual link above (callbacks can be stored into a variable) and some <a href="http://en.wikipedia.org/wiki/Observer_pattern#PHP">PHP code examples for the Observer Pattern</a>.</p>
    singulars
    1. This table or related slice is empty.
    1. POEvent-driven architecture and hooks in PHP
      singulars
      1. PTQuestion
    1. PTAnswer
    1. UShakre
    1. UShakre
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POEvent-driven architecture and hooks in PHP
      singulars
      1. PTQuestion
    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. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAwesome. This is more or less what I was thinking of regarding hook implementation but wanted to make sure I wasn't missing something. Also, very cool site for the PHP demo.
      singulars
      1. PO
      1. USMoarCodePlz
    2. CO@MoarCodePlz: This implementation lacks of events/hook contexts. You can for example encapsulate events into classes of it's own as well so they can be fired (interface them). This would add another layer however. Another useful function is [`is_callable`](http://php.net/manual/en/function.is-callable.php) in this context.
      singulars
      1. PO
      1. UShakre
    3. CO@MoarCodePlz: Added some sanitization to the class to show that. You might need some extension to remove callbacks again (de-registration).
      singulars
      1. PO
      1. UShakre
 

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