Databases
StackOverflow2013
Usersdbo
USsimonrjones
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USsimonrjones
    primarykey
    data
    text
    plurals
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POUse Zend Framework to create a flexible base application
      1. USsimonrjones
      1. VTFavorite
    2. VO
      singulars
      1. POHow to design a product table for many kinds of product where each product has many parameters
      1. USsimonrjones
      1. VTFavorite
    1. COit's good practise to filter incoming data just to make sure it is what you expect it to be. You are right though, in this example if you're just matching IDs it should return nothing. It's more important in examples such as posting comments where you'd want to strip tags to avoid things like JavaScript. I wrote the above over a year ago, so I presume that was my line of thinking at the time!
      singulars
      1. PO
      1. USsimonrjones
    2. COIf you're worried about updates, just add a fake GET parameter to your CSS file, for example: <link rel="stylesheet" href="/assets/css/reset.css?v=5" type="text/css" media="all" /> This will then force a reload and you get to keep the original filename. You'd have to do some tests with 1000s of requests to see what the exact time difference is between @import vs readfile() but generally speaking PHP will always have an overhead that static files will not have. And one combined static file will always be faster than multiple files or PHP.
      singulars
      1. PO
      1. USsimonrjones
    3. COAJAX basically works by sending asynchronous HTTP requests to the server (i.e. PHP) via JavaScript. PHP then returns something (usually a string or JSON which is a bit more flexible) and your JavaScript then does something with that (i.e. updates the HTML of the page). You can read a tutorial on how to get started with jQuery which includes a section on using AJAX with PHP at http://docs.jquery.com/Tutorials:Getting_Started_with_jQuery#Rate_me:_Using_Ajax
      singulars
      1. PO
      1. USsimonrjones
 

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