Databases
StackOverflow2013
Usersdbo
UShalfer
 

Note that there are some explanatory texts on larger screens.

plurals
  1. UShalfer
    primarykey
    data
    text
    <p>I'm a (mainly PHP) software engineer, and would find time to learn Node if it wasn't for all these pesky projects that keep cropping up <code>:)</code>.</p> <h2>Projects</h2> <ul> <li><code>CURRENT</code> I'm working on a crawler-based web app to refresh job data directly from employer sites, and to present it on a searchable map. It's in <a href="http://alpha.jobsite.jondh.me.uk/" rel="nofollow noreferrer">prototype form</a>, but it does work, even if the UX needs a fair bit of improvement.</li> <li><code>CURRENT</code> I have a side-project PHP-based proxy server to record requests passing through. It is highly customisable, and connects together using Docker.</li> <li><code>FINISHED</code> I've written a <a href="http://ilovephp.jondh.me.uk/" rel="nofollow noreferrer">PHP application development tutorial</a> for beginners. Code changes are illustrated in diffs and are explained in the text from first principles. Give it a go, and feel free to <a href="http://blog.jondh.me.uk/2014/08/online-php-beginners-tutorial/" rel="nofollow noreferrer">add feedback</a>.</li> <li><code>FINISHED</code> I have a PHP project to launch a real web server in the background, and to easily integrate that with PhantomJS. This is useful for functional testing an application.</li> <li><code>FINISHED</code> If you have seen a programming tutorial online with serious security issues, let <a href="http://awooga.jondh.me.uk" rel="nofollow noreferrer">Awooga know about it</a> or <a href="https://twitter.com/ilovephp" rel="nofollow noreferrer">tweet it to me</a>. An alpha project to report non-optimal tutorials - there's a lot of 'em. This is on hold, but get in touch if you'd like to help.</li> </ul> <h2>About me</h2> <ul> <li>I have interests in teaching programming, web crawling and P2P technology, as well as <a href="http://blog.jondh.me.uk/category/ideas/" rel="nofollow noreferrer">several other ideas</a>.</li> <li>I've written about <a href="http://blog.jondh.me.uk/2012/09/how-to-use-stack-overflow/" rel="nofollow noreferrer">how to ask questions on StackOverflow</a>. I am an active voter here, and will often down-vote questions that have not been researched, feature unabashed direct requests for solutions, or if some substantial assistance has not been replied to. That said, I do try to be nice to beginners!</li> </ul> <p>If you'd like to get in touch, find the 'About' page of my blog: there's an email address there. In theory I am on Twitter, but in practice I very rarely sign in.</p>
    plurals
    1. POGKSession mode peer: How to automatically connect two peers without any button / confirmation?
      singulars
      1. PTQuestion
    2. POHow to build a Python p2p application?
      singulars
      1. PTQuestion
    3. POWhy is the old mysql password function considered insecure
      singulars
      1. PTQuestion
    1. PO
      singulars
      1. PTAnswer
    2. POAre there any toolsets/techniques to determine if SQL queries are functionally identical?
      singulars
      1. PTQuestion
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCapture initial copy of Propel objects in doSelect
      1. UShalfer
      1. VTBountyStart
    2. VO
      singulars
      1. POValidating SVG file in PHP with XMLReader
      1. UShalfer
      1. VTBountyStart
    3. VO
      singulars
      1. POInkscape inside PHP/Apache doesn't render fonts to PNG
      1. UShalfer
      1. VTBountyStart
    1. CO@azat - you're right, it doesn't work. I just learnt something :-). OP, you can initialise dynamic values ($conf_doclib, $conf_sitelib) in the constructor instead.
      singulars
      1. POUsing static variables in PHP
      1. UShalfer
    2. COYeah, that should work - use self:: as Pekka says. This only won't work with class constants, but public static vars should do it fine.
      singulars
      1. POUsing static variables in PHP
      1. UShalfer
    3. COIncidentally, although I recommend Symfony, I don't intend to suggest that's your only choice. I believe people have got CI to work with both the ORMs I mention, for example.
      singulars
      1. PO
      1. UShalfer
 

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