Add New WordPress User using only database

INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`)
VALUES ('newadmin', MD5('pass123'), 'firstname lastname', 'email@example.com', '0');

INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) 
VALUES (NULL, (Select max(id) FROM wp_users), 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');

INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) 
VALUES (NULL, (Select max(id) FROM wp_users), 'wp_user_level', '10');

How to Add an Admin account in WordPress via MySQL

Laravel Stuff

Architecture Concepts (Laravel Docs)

Architecture of Laravel Applications

LARAVEL BOILERPLATE Documentation

ajax post security in laravel? (Stack Exchange)

Multiple DB Connections in Laravel

How to use multiple database in Laravel

Multiple database connections in the same Laravel project

Laravel 5 multiple database connection.

Changing Eloquent models database connection at runtime

Specifying DB Connections on Laravel

Raw Queries in Laravel w/ parameters

Select with DB::raw() – make your database work

How to bind parameters to a raw DB query in Laravel that’s used on a model?

Stats Programming Practice Gameplan

The goal is to be able to define and solve statistical problems without having to spend much time to reference or relearn theory and code for every situation.
We want to have an inventory of code snippets and scripts that we can re-use based on the current project or issue, as well as, have all theory and general knowledge understood and easily accessible on the fly.

The practice approach is heavily based on brain based learning ideas like chunking, revising, engagement and coherence – as described in Teaching with the Brain in Mind by Eric Jensen.

We want to be able to regularly practice stats programming in an effective way without having to expend too much energy or stress (bcs we have a lot to do each day besides stats stuff). Stats is such a big topic, it’s easy to wear yourself out.

Process:

1. Review source materials and place topics and problems into relevant sub-topic sheets that are only relevant to that particular subject or topic, and most importantly, that make sense to you individually as to how you understand it.

2. Break topic sheets down into particular micro-questions and highlights that represent the “core intention” or value of the different parts of that topic. The objective is to be able to re-visit each question and work on it without having to review any background information. We want to create small chunks within each topic.
Make sure each question is completely self-contained, meaning that you don’t need to reference any other topic or question to solve that current question.
Also find other materials and examples independent of the original source material that describe and demonstrate the particular point and list them in the micro-question.

3. Re-visit each chunk’d question, answer or state the solution, and create code snippets in R that solve the problems. Alternate only trying to answer or state the objective of the theory and actually trying to do the coding. Skip around to different topics and questions – don’t require yourself to do it in a linear sequential fashion.

Do each of these steps in their own study session. For example if you have 1 hour to study – only spend that time reviewing source materials and organize topics into small study sheets, and don’t worry about coding or building sub-topics or micro-questions. In another session only focus on coding out a question solution that you’ve reviewed a couple times in the past and are already really familiar with. And so on… This way you won’t waste too much brain energy reloading background knowledge and details necessary for each study step, or trying to hold too much info in your head at once. You can stay in the groove for each activity which is more fun and encouraging as you complete each small item.