There are 91 posts filed in Tech (this is page 8 of 19).
NB: This is a really really old post. See a newer better one about inserting and updating with random string.
Adding a new column to a table which needs to contain a different random hash for each row?
Mysql can easily generate md5 strings and update all rows in the table for you
UPDATE thetable
SET thecolumn = MD5(RAND())
WHERE thecolumn IS NULL
This technique produces something similar to the wiggle you get on an iPhone when deleting items.
Be aware that keyframe animation is still very poor in Chrome and cases freezing and jumping if multiple items are animated at once.
The animation css below results in a hovered element rotating back and forth around it’s centre point. You can update the number of degrees and length of animation to change the appearance.
Just add this css and give your element the class ‘wiggler’ to implement
/* safari and chrome */
@-webkit-keyframes wiggle {
0% {-webkit-transform:rotate(4deg);}
50% {-webkit-transform:rotate(-4deg);}
100% {-webkit-transform:rotate(4deg);}
}
/* firefox */
@-moz-keyframes wiggle {
0% {-moz-transform:rotate(4deg);}
50% {-moz-transform:rotate(-4deg);}
100% {-moz-transform:rotate(4deg);}
}
/* anyone brave enough to implement the ideal method */
@keyframes wiggle {
0% {transform:rotate(4deg);}
50% {transform:rotate(-4deg);}
100% {transform:rotate(4deg);}
}
.wiggler:hover {
-webkit-animation: wiggle 0.5s infinite;
-moz-animation: wiggle 0.5s infinite;
animation: wiggle 0.5s infinite;
}
Twitter’s bootstrap css currently doesn’t support tabs on the right hand side or floated right. We’ll here is the css to allow it.
We’ll stick to existing naming. Twitter use secondary-nav within topbar so let’s use that…
.tabs .secondary-nav {
float:right;
margin-left:10px;
margin-right:0;
}
The the html for the tab you want to float right you need:
The outcome is most tabs on the left and any with the new class positioned over to the right.
If you own a Mac and you haven’t heard of Alfred App then you’ve likely been living in a bunker for a while.
At very least Alfred allows you to quickly start applications. If you choose to delve deeper you can use it to search and open files, run applescripts, quick jump to webpage searches, send emails, control iTunes and 999 other clever tricks.
When you first get your Mac you will likely have heard of Spotlight, a built in application that can be used to search applications and files. It’s hotkey is cmd-space. It isn’t as flexible as Alfred App but it has the best hotkey combination going.
Before we start if you’ve turned off Alfred’s menu bar icon, turn it back on in Alfred appearance preferences. It’s makes for the easiest method of opening during hotkey move.
Here is how to move Alfred App to use cmd-space and Spotlight to use ctrl-space:
System Preferences -> Keyboard -> Keyboard Shortcuts
1) In the left column click Spotlight.
2) In the right column click the current key combination for spotlight of ⌘Space (cmd-space) and input your replacement key combination. I recommend ^Space (ctrl-space) although some other applications occasionally reserve it (such as Things App). At this point if you can see it you could also switch the second hotkey combination over to ⌥^Space (alt-ctrl-space).
3) Don’t worry about remembering the old hotkeys. If you change your mind later as you can click Restore Defaults to undo your changes.
You can close system preferences now.
So we’ve moved Spotlight, but now we need to move Alfred to ⌘Space (cmd-space).
Click on Alfred’s top hat menu bar icon and select preferences. (you may need to restart Alfred at this point for it to recognise that you’ve moved Spotlight to a new hotkey.
Choose General and you should see a large box Alfred Hotkey box. Click it and press our new hotkey for Alfred App.
⌘Space (cmd-space)
And that’s it. You should now see Spotlight when you hit ^Space (ctrl-space) and Alfred when you click ⌘Space (cmd-space).
A few Yii 2 updateAll examples:
Updating a single column:
$rows = Comment::updateAll(['status' => 1], 'type_id = 1 AND status = 0');
Updating multiple columns:
$rows = Comment::updateAll(['status' => 1, 'updated' => '2011-08-25 09:33:23'], 'type_id = 1 AND status = 0' );
Some simple Yii 1.1 examples of how to use updateAll():
In this example we want to set status = 1 WHERE type_id = 1 AND status = 0
Note this is a simple example where we are only updating one column and using a string for our condition. There are more complex options available.
$rows = Comment::model()->updateAll(array( 'status' => 1 ), 'type_id = 1 AND status = 0' );
So as you can see first comes an array of column => new_value pairs, then a condition string which is pretty much used as the WHERE clause.
An example of updating more than one column:
$rows = Comment::model()->updateAll(array( 'status' => 1, 'updated' => '2011-08-25 09:33:23' ), 'type_id = 1 AND status = 0 ' );