CODING
-
Sort array of objects by property value
Sort by predefined order:
-
Add column to table in Laravel
Create migration in console: Use Schema::table() to access existing table (instead of Schema::create() for creating new tables) Then run migrations:
-
Allow Composer to connect to http/https
If you have problems with Composer not allowing to update to http-connections add this to composer.json (not recommended to keep in production)
-
(WordPress) Generate post title from custom field
I had a custom post type that only used custom fields, so I needed to generate a post title from there. Here’s one way. You can if course chain as many if else as you want to check other types. functions.php [php] function custom_post_type_title($post_id) { global $wpdb; if (get_post_type($post_id) == ‘staff’) { $name = get_post_custom_values(‘name’);…
-
Laravel helpful plugins
Generate Seed from Databasehttps://github.com/orangehill/iseed Generate Migrations from Database:https://github.com/Xethron/migrations-generator
-
(JS) Newline to br
Replaces newline characters with <br> tags in the same style as the php nl2br function
-
(Ruby) Ruby on Rails doodles
Create new Ruby-on-Rails project. By default RoR comes with SQLite support, unless you state otherwise (-d mysql). [ruby] // Create project. With mysql support rails new my_project -d mysql [/ruby]
-
(MySQL) MySQL doodles
[sql] — Replace a word or string in a column UPDATE my_table SET my_column = REPLACE(my_column, ‘Old string’, ‘New string’); — [/sql]
-
Get a list of run database queries in Laravel
This is great if you want to see what queries are actually run when using Eloquent.
-
Log Laravel execution time to console
Put this in app/start/global.php to get Laravels execution time to the browser console log. L4 This works with L5:
-
Convert CSV to SQL
This tool is fantastic! It saved me many hours of work, when I had complex CSV files I needed to turn into SQL tables http://www.convertcsv.com/csv-to-sql.htm