Bhupal Sapkota Software Consultant Helping founders build
and launch their ideas with code & AI

Bhupal's Newsletter

I send out occassional email with programming resources, summaries of my readings on art, science, and commerce behind technology, my writings on growing an online business etc. Feel free to subscribe, no spam!

Home

🚀 Technology Blog

Things I found userful while working on different projects.

Building Dynamic Queries in PHP MySQL PDO

1. When you need a dynamic Search Query where variable parameters are presents you can use the following approach: $sql = “SELECT * FROM users WHERE “; $where = array(“dist_id = :dist_id”); $params = array(‘:dist_id’ => $distID); if (isset($p->username) && !empty($p->username)) { array_push($where, “username LIKE :username”); $params[‘:username’] = “%{$p->username}%”; } if (isset($p->firstname) && !empty($p->firstname)) { […]

Tagged with: •

Artificial Intelligence 101 – Resources

What is AI? AI (Artificial Intelligence) is a machine’s ability to perform cognitive functions like humans, such as perceiving, learning, reasoning, and solving problems. AI is a computer system that can perform tasks that normally require human intelligence. It includes recognizing objects, understanding natural language, and making decisions. It is a powerful tool that helps […]

Tagged with:

Help Me Help You Nepal

We talked a lot about pay-it-forward culture in the past (2010-2015) as a local entrepreneurs group in Kathmandu called Help Me Help You NP. But, we forgot to thank one another ourselves. Lately, I have realized that gratitude is not everyone’s cup of tea. People don’t realize how they got where they got until something […]

Tagged with:

Why I became skeptical about Google in Nepal

I worked with Google for more than 5 years when I was leading Google Developers Communities in Nepal and I had a huge respect for the company. But recently, I have become skeptical about Google and its intentions when it shut down its Google Input IME tool for Microsoft Windows (the software isn’t available for […]

Tagged with: • •

Content Creation Foundations

I recently read a Case Study on Affiliate Marketing Commission by Adam Dukes, a digital content creator from Las Vegas. I follow him wholeheartedly and consider him one of my mentors, even though I’ve never hired him directly to help me. Below I’m sharing a section from his Case Study on how to create great […]

Tagged with:

11 Soft Skills for Leaders

Soft skills refer to a person’s interpersonal skills and character traits that affect their relationships with others. They are typically viewed as a complement to hard skills, which pertain to a person’s occupational knowledge and abilities in the workplace. The term “soft skills” refers to a person’s emotional intelligence quotient (EQ) rather than their intelligence […]

The Interview I loved

When I was in San Francisco Bay area around 2016 I received an invite to attend an interview for a possible contract role as an Android developer consultant. For an instance I paused. I was worried the interview might end up as a coding nightmare trying to solve Leetcode-style puzzles but to my surprise, the […]

Tagged with:

My feelings on Crypto ban in Nepal by NRB

Bitcoin is amazing. NFTs are the coolest. The crypto space is booming. Blockchain and Web3 are changing the ways people operate. Being a developer myself I was investing my spare time learning to build development skills in blockchain technology. However, since I am in Kathmandu there is a voice inside my head that repels me […]

Tagged with:

Why I hate computer monitoring software (desktop monitoring)?

Computer monitoring or surveillance software is any tool that helps businesses keep tabs on their employees within the office premises or through remote access. Employee monitoring software is used to supervise employees’ performance, prevent illegal activities, avoid confidential info leakage, and catch insider threats. Nowadays employee monitoring software is widely used in technology companies. A […]

Tagged with: •

Run php script as daemon process with Systemd (AWS EC2)

To run PHP script as a  daemon service under Linux using Systemd do as below. Best way to make a shell script daemon? With new systemd you can create a service. You must create a file or a symlink in /etc/systemd/system/, eg. myservice.service and place content like this one, myservice will be the name of […]

Tagged with:

Preserving feature branch commit history on git merge

Git really changed the way developers think of merging and branching. From the classic CVS/Subversion world I came from, merging/branching has always been considered a bit scary (“beware of merge conflicts, they bite you!”) and something you only do every once in a while. As a consequence of its simplicity and repetitive nature, branching and […]

Tagged with:

« Older Entries  » Newer Entries