SQL to check a value exist in one table but not in another.
SELECT t1.name
FROM table1 t1
LEFT JOIN table2 t2 ON t2.name = t1.name
WHERE t2.name IS NULLor this (not tested)
SELECT *
FROM B
WHERE NOT EXISTS (SELECT 1
FROM A
WHERE A.ID = B.ID)Basic git flow
from remote “master”, create a branch “develop”.
pull branch “develop”
branch out branch “feature” or “bug” from local “develop”
commit changes to branch”feature”
push branch”feature” to remote branch”feature”
request merge to remote branch “develop”
after merged, pull branch “develop” to local
Billplz is a malaysian’s payment gateway. It’s free to register, easy to setup and affordable.
If you are using postman to test, add the API Key as username in Authorization tab. Choose “Basic Auth” in Type dropdown. Then enter the URL and params as usual
Some free tools you can use to start your business. The providers normally provide the free tools for basic usage. Some limitation on features and users. But if you are small, it doesn’t matter much. At least you can start with some cool softwares to support your small business
CRM – hubspot
Support Ticket/ Help Desk – freshdesk
Accounting – waveapps – need to pay to use payroll and payments
Version control – GitLab
Some most popular front-end framework
light-weight
for mobile hybrid
To get things done is hard sometimes (or maybe most of the times) especially those things that we don’t like to do
Follow-through is good at converting good intention to action
(from book titled The Power of Get Things Done by Steve Levinson and Chris Cooper)
You can’t rely on motivations or inspirations
You need some force to complete important tasks
You need to stay away from distractions
How to connect to more than one database in codeigniter
Database config
$db[‘default’][‘hostname’] = “localhost”;
$db[‘default’][‘username’] = “root”;
$db[‘default’][‘password’] = “”;
$db[‘default’][‘database’] = “database_name”;
$db[‘default’][‘dbdriver’] = “mysql”;
set another config for 2nd database
$db[‘otherdb’][‘hostname’] = “localhost”;
$db[‘otherdb’][‘username’] = “root”;
$db[‘otherdb’][‘password’] = “”;
$db[‘otherdb’][‘database’] = “other_database_name”;
$db[‘otherdb’][‘dbdriver’] = “mysql”;
Sample to call
//Load another database
$DB2 = $this->load->database(‘another_db’, TRUE);
//Default database query
$this->db->select(‘first_name, last_name’);
$this->db->from(‘users’);
$this->db->where(‘id’, 99);
$query = $this->db->get();
//Another database query
$DB2->select(‘image’);
$DB2->from(‘cdn_images’);
$DB2->where(‘id’, 25);
$query = $DB2->get();
References
codexworld.com/connect-use-multiple-database-codeigniter
Focus is important. To focus is to do only one single task at a given time. But this is very hard to do.
Follow the following steps
1. Remove all distractions – silent and put away the smart phones, disable all notifications (email, messenger etc), stay away from people who love to disturb you etc
2. start small – start with 10 minutes focus time to do one small task and let youurself drawn into the task further without you know. split tough and huge tasks to smaller ones to achieve. Most important is to have PROGRESS
3. take a meaningful break. Focus is tiring. So take a solid and meaningful 10 minutes break everytime you complete a tough task. For example, drink water, stretching, have a meaningful and necessary discussions with colleague, check emails/messenger etc
Some sales ideas that can be implemented
Getting leads
Sales process/pitching/selling
Closing sales