Databases
StackOverflow2013
Usersdbo
USHalf Crazed
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USHalf Crazed
    primarykey
    data
    text
    <p>Developing while learning and helping others.</p> <p><strong>Top PHP issues I see on SO and my suggestions:</strong></p> <ol> <li><a href="http://stackoverflow.com/a/14110189/788192">Stop using <code>mysql_*</code> functions. They are deprecated.</a> Instead, look into using <code>PDO</code> along with binding values. <a href="http://stackoverflow.com/questions/1179874/what-is-the-difference-between-bindparam-and-bindvalue">Be aware that <code>bindValue</code> and <code>bindParam</code> work differently.</a></li> <li><a href="http://stackoverflow.com/a/31943849/788192">Stop using time stamps. Use the <code>DateTime</code> object instead.</a> Convert all of your time stamps in tables to the <code>DATETIME</code> type as well. You'll no longer have to worry about which PHP architecture you're on and you'll have a plethora of functionality readily available instead of writing your own.</li> <li><p><a href="http://stackoverflow.com/a/17497184/788192">You can pass external variables into a closure's scope</a>, along with the ability to modify it (if passed by reference using <code>&amp;</code>), by using the <code>use</code> keyword. Example: </p> <p><code>$externalVar = 10; print_r(array_map(function($value) use (&amp;$externalVar) { $externalVar++; return $value * $externalVar; }, range(1, 10)));</code></p></li> <li><p>Use CSRF tokens in your forms! And clear them after single use! <a href="http://stackoverflow.com/a/17244070/788192">Old laravel example</a></p></li> <li>If Google PageSpeed docks your score for analytics, then <a href="http://stackoverflow.com/a/41065130/788192">cheat back</a>!</li> <li><a href="http://stackoverflow.com/questions/1732348/regex-match-open-tags-except-xhtml-self-contained-tags">You can't parse [X]HTML with regex. Because HTML can't be parsed by regex. Regex is not a tool that can be used to correctly parse HTML.</a></li> </ol>
    plurals
    1. POphp codeigniter select results from foreach and save into an array
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. POMySQL SHA() doesn't work
      singulars
      1. PTQuestion
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PORegEx match open tags except XHTML self-contained tags
      1. USHalf Crazed
      1. VTFavorite
    2. VO
      singulars
      1. POWhy is it faster to process a sorted array than an unsorted array?
      1. USHalf Crazed
      1. VTFavorite
    3. VO
      singulars
      1. POLaravel 4 Cascading Soft Deletes
      1. USHalf Crazed
      1. VTFavorite
    1. COCheck your Eloquent relationship models (hasOne, hasMany, belognsTo, Etc).
      singulars
      1. POEloquent querying with relation ship
      1. USHalf Crazed
    2. COWhat's your encryption method for the registration process? Whatever it is, it should be the same thing for the login process. Don't append strings that change (such as browsers)... otherwise users will be forced to use X browser to login.
      singulars
      1. POLog In and Registration Form Password
      1. USHalf Crazed
    3. COSometimes you have to dig into the API, unfortunately.
      singulars
      1. POLaravel Saving A Model And Relationships
      1. USHalf Crazed
 

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