Bhupal Sapkota Computer Programmer Unraveling art, science, and commerce behind technology. Passionate about web/mobile programming, writing, and growing an online business.

My Private Mailing List

If you want early access and opportunities that I don’t post publicly, get on my private email list.


🚀 Technology Blog

Small things I found userful while working on different projects.

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 […]

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:

OKTA API Call with PHP Curl

Tagged with:

What the UX ?

  Picture worth a college education.

Tagged with:

Met Robert Scoble at Google I/O 2014

Starting this post I’m going to share some of the moments captured through my camera. Will be using the label #fotosoto so share similar posts. If you know the persons in the picture, feel free to add an awesome comment which will delight both of us : ) The person in this photo is an […]

Tagged with:

Met the social media personality #fotosoto

Starting this post i’m going to share some of the moments captured through my camera. Will be using the label #fotosoto so share similar posts. If you know the persons in picture, feel free to add an awesome comment which will delight both of us : ) The person in this photo is a internet […]

Tagged with:

Social Network Status Updates – Database Schema

Here’s a simple database schema which can be used in cases where you want to take user status input. The entities available are users, updates, comments & likes. Additional entities can be added as required. Also, for simple user registration and status updates it will be more than enough.  Schema derived by studying popular social […]

Tagged with:

Online Shopping System–Database Design

Database design of Online Shopping System. Schema represents minimal information required to store information of a shop and products to sell. Cart information can be stored in session or if wishlist / watchlist is needed, the schema can be simply extended. Enjoy. Entities: users – shop admin, owner and customers products – products to sell […]

Tagged with:

Quiz System–Database Schema Design

MySQL Database Schema design for quiz system. Schema Diagram: MySQL Create Script: — phpMyAdmin SQL Dump — version — — — Host: localhost — Generation Time: Apr 01, 2013 at 08:27 PM — Server version: 5.1.37 — PHP Version: 5.3.0 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @[email protected]@CHARACTER_SET_CLIENT */; /*!40101 SET @[email protected]@CHARACTER_SET_RESULTS */; /*!40101 SET @[email protected]@COLLATION_CONNECTION […]

Tagged with:

Photo Video Gallery–Database Design

Database design for photo video gallery website / app. Enjoy. Schema Diagram: MySQL Create script: — phpMyAdmin SQL Dump — version — — — Host: localhost — Generation Time: Apr 03, 2013 at 10:25 PM — Server version: 5.1.37 — PHP Version: 5.3.0 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @[email protected]@CHARACTER_SET_CLIENT */; /*!40101 SET @[email protected]@CHARACTER_SET_RESULTS */; […]

Tagged with:

Marksheet Generation System–Database Design

Schema for Marksheet Generation System useful for school, colleges and institutes to store student’s information, exam marks etc. Extend at your will. Schema Diagram: MySQL Create Script phpMyAdminDump: — phpMyAdmin SQL Dump — version — — — Host: localhost — Generation Time: Apr 02, 2013 at 07:28 PM — Server version: 5.1.37 — […]

Tagged with:

Simple CMS (Content Management System) – database design

Schema design of simple content management system. Schema and tables itself speak about the type of information indented to be stored by the system. Schema Diagram: MySQL Create Script phpMyAdmin dump: — phpMyAdmin SQL Dump — version — — — Host: localhost — Generation Time: Mar 30, 2013 at 10:20 PM — Server […]

Tagged with:

Online Vehicle Ticketing System Database Design Sample

Online Bus/Vehicle Ticketing System Database Design Sample – MySQL. With minor modifications or further generalization this database schema can be used to implement any kind of ticket booking system. eg. movie ticket booking system, events/show ticket booking etc.  Entities: users – user details user_type – type of users in system vendors – providers’ information, in […]

Tagged with:

2012 MW

A geek is that someguy or somegirl who enjoys sitting in front of a computer all day/eve to find out about what’s happening in the Information Technology world, to solve computation problems, or to build apps or websites for fun or for their clients. Everyone else, including your in-laws or your neighbor who sit in […]

PyroCMS Themes, Widgets and Modules – for reference.

Themes : PyroCMS v1.3.2 Theming Guide for beginners: PyroCMS Tag Cheat Sheet Widgets PyroCMS v1.3.2 Widget creation guide for beginners Modules: Hello World Module Old 0.9.9.x Forum module upgraded to v1.3.2 PyroCMS v1.3.2 & v0.9.9.7 Module Creation guide for beginners:

Tagged with:

नेपाली ब्लगरहरुलाई छोटो मीठो सल्लाह

Quick SEO tip for Nepali (Unicode) Bloggers Here goes, one quick SEO (Search Engine Optimization) tip for Nepali Bloggers who use to publish their content written in Nepali Unicode. What I’m talking about ? Say: your blog post title is “मेरो नेपाल” You publish it. Now blogger gives you one random “url/permalink” to your […]

Tagged with:

Web development “real” life cycle

Few guys known as manager, designer, software engineer, tester are feeling pressure in what we call Semicolon Valley here, because few other guys known as information architecture, user interface designer, user experience designer, database designers left Nepal thinking there is no work for them here. They never bothered to try creating work here. The smart […]

Android SDK and AVD Manager slow download problem

I was Installing the Android SDK ( on my Windows XP box. Problem : Slow download of android SDK platforms ~5kb/s Android SDK and AVD Manager Stalling During Download : Google Groups Android sdk download/update failing : Stack Overflow How to speed up Android SDK platform download ? 1. Allow download over http : check […]

Tagged with:

PHP Short Tag : Avoid Them

PHP Short Tag:  it  look like this: <?   ?> <?= $var ?> obvious ones: <?php  ?> <?php echo $var ?>. I downloaded an open source php script, thinking to work it out for my own purpose – but what sucks is – the project uses short tag that my host doesn’t *seems* to provide support […]

Tagged with:

WordPress Themes / Templates – Useful Codes

Here are few fairly basic but handy wordpress codes that a wordpress theme or template developer/designers could use as reference. i personally use these a lot while working with wordpress.   WordPress Site Name: <?php bloginfo(‘name’); ?>   WordPress Site Description: <?php bloginfo(‘description’); ?>   Wordopress: Home Page Link: <a href="<?php get_option(‘home’); ?>">Home</a></p> or <a […]

Tagged with:

Hello World – Ruby on Rails

None of tutorials i found around web helped me get straight to the Ruby on Rails development environment in Windows. that’s why i thought would sum up how i setup rails in my Windows XP Professional box. Yet, this was amusing (from Ruby on Rails Getting Started Guide) If you’re working on Windows, you should […]

Tagged with:

7th National ICT Student & Youth Conference – My Paper Abstract

Event 7th National ICT Student & Youth Conference Date: 15th January 2011, (Saturday) Venue: Local Development training Center, Jawlakhel, Lalitpur Time: 9:00 A.M – 4:00 pm Organized By: Information technology Society, Nepal (ITSN) Conference Theme: Youths on collaborative development Conference Tracks: Recent Trends in IT for Rural Developments Smart Data Policy IT Security Electronic Document […]

Tagged with:

7+1 Twitter tips, my experience!

1. What is on the twitter profile picture link? When we go on someone’s twitter profile we see – small profile pic, twitter username, numbers of following & followers, profile bio,  indication of you following the user or not and their tweets. Have you ever clicked on that small profile image? try clicking it and […]

Tagged with:

Hello World – PyroCMS Module

/*———————————————————————————————Update 10/16/2011: This tutorial has been here for older version (< 1.0.x) of PyroCMS. Latest Stable PyroCMS release is v1.3.2Please download and use following tutorial files which are for PyroCMS 1.3.2: PyroCMS Hello World Module tutorial pdf for v1.3.2Download Sample Hello World Module PyroCMS 1.3.2 Pyro docs have been significantly improved over the year. You […]

Tagged with:

Lorem Ipsum को कथा

Do you design, be it graphics or web design? or any other form of design type settings? Have you ever used Lorem Ipsum? What is your experience using Lorem Ipsum when designing for Nepali Unicode content?   "Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. […]

Tagged with:

Nepal In – PHP Arrays

What is Nepal in PHP Arrays – Project ?   Are you a PHP developer in Nepal ? or do you use MySQL in your projects. How many of you have easier access to the places & cities of Nepal in simpler arrays, that can be taken for reference and used. I am currently involved […]

Tagged with:

Few Nepalese websites and the possibilities

I have been wondering about some Nepalese products that exists online, created by Nepalese and Serving us. The list may go longer but i have selected few site that i noticed are mention worthy. I personally feel that popular sites like Google, Facebook (which killed the hi5 commity of Nepal and of the world altogether) […]

Tagged with:

Why you should Twitter ?

It’s been a year since i joined Twitter. Tweeting what i found useful out there surfing, thinking that might interest some one else out there too and tweeting my days as i am living. First day at twitter was hell. No idea about the interface. Most interesting,  sharing something would be called tweeting! I wondered, […]

Tagged with:

CodeIgniter Helpers – How to write your own?

Find yourself again and again doing CI or are you just getting started in to your next big project ? Get this book by Rob Foster. This is an easy-to-follow guide consisting of a number of projects that enable you to develop full-featured applications at a fast pace. CodeIgniter Web Application Blueprints What is here:         […]

Tagged with:

Hello World – CodeIgniter Model – A Simple Bookmark Manager

Continued from Hello World – CodeIgniter! I’ve been a bit busy with my development works. Talking about codeigniter,i will discuss today on how we can use it to access MySql database, insert data into tables, retrieve and display them, at times delete them. We’ll create a very simple Bookmark Manager App (just for the sake […]

Tagged with:

Social Network Database Design Sample – MySQL

what?—— sample database for a social network project – a mysql database schema Database Engine: InnoDB (edit the mwb file if you need to change it to MyISAM or any other.) the aspects of a social network i tried to cover in this database:– user profile – friends– friends list – status updates– thumbs up/down […]

Tagged with:

Design or develop, which to do first?

Don’t expect “you should do this first” kind of solution to this question, i am asking question here. I’d like to limit the discussion to the web development context. Before going further, i would like to clear two things, by design i would mean requirements analysis, design prototyping & designing the actual ‘web interface’ (technology […]

It’s Official now – Google is Coming to Nepal on June 2010

Google is ready to announce it official launch in Nepal. With Google’s planned analysis of Nepalese internet traffic monitoring they will decide to finally land up in Nepalese market. This will be a great opportunity to Nepalese Developers. Localization has always been Google’s top priority. Google already has support for many of the Nepalese Language […]

Blogger Post & Comment Feed URLs

Recent Posts RSS feed url Recent Comments RSS feed url Label Specific Feed url Replace -> yourBlogAddress with your actual blogger address. Replace -> labelname with your label Hope That Helps.

Tagged with:

Hello World – CodeIgniter!

So you decided to learn CodeIgniter PHP MVC Framework. I am too starting with it and planning to post a series of introductory tutorials on it. Here i go with – Hello World example in CodeIgniter. Install Code Igniter Download CodeIgniter copy form the above site. The version i am using is 1.7.2I assume […]

Tagged with:

Protect your Gmail from spams – use mail aliases

There’s no argument that Gmail is the best free email service. Notable features include – Maximum Storage (~8GB ), POP3 Mail Support, Mail Labels, Mail Alias, Filters, Theme Support/Customization. Now the Social Google BUZZ is also integrated in Gmail. Taking in account of all these features and sudden exposure of your Gmail ID as your […]

Tagged with:

Congratulations : Google Nepal

What is Google ? Google Inc. is an American multinational public corporation invested in Internet search, cloud computing, and advertising technologies. Google hosts and develops a number of Internet-based services and products, and generates profit primarily from advertising through its AdWords program. The company was founded by Larry Page and Sergey Brin, often dubbed the […]

Tagged with:


INFORMATION ON BATCH FILES BATCH FILE ABCs Batch files are programs that allow MS-DOS and Windows users to create a file to perform a long tasks fast. Such as opening certain programs ran frequently, deleting or managing files, etc. Simple batch files do not require any special programming skills and usually can be done by […]

Tagged with:

Remove Autorun Virus : Simple Approach

Make following FILES in your Desktop, be sure of the extensions. Now when you insert your removable drive. Just don’t open it. Select these all files -> Right Click -> Send To -> Removable Drive Letter. Replace Files ? Dialog May Appear if your removable drive is infected by virus. autorun.batautorun.binAutorun.exeAutorun.icoAUTORUN.INFAutorun.iniautorun.regautorun.srmautorun.txtautorun.vbsautorun.wshautorun.zipAutorun.~exbittorrent.exeMFC32DLL.dll.vbsms32.dll.vbsMS32DLL.dll.vbsmsvcr71.dllRavMon.exesal.xls.exe The virus files would […]

Tagged with:

How Autorun Virus works in Windows Xp?

How to make AUTORUN Viruses:————————— ——The pendrive viruses generally follow Autorun procedure of Windows OS.When you plug your PENDRIVE or any removable storage device to USB Port,the PLUG AND PLAY feature of Windows Xp first looks for the file AUTORUN.INFand anyname following AUTORUN.* convention. Generally following files will be present in the list: Autorun.inf // […]

Tagged with:

Social Networks – As if they cared..

We used to swim in the pool. Now, we swim on the internet. With every person clicking a mouse button on the internet – there comes a “piece of information”. With so many “lead by business motive” social networks – we forget the boundaries of our actual social connection and push things – without a […]

Tagged with:

Windows XP Run Commands

            WINDOWS XP RUN COMMANDS RUN SHORTCUTS —————————————— StartMenu -> RUN -> Type “Run Command” the press Ok (MOUSE) or WinKey + R -> RUN -> Type “Run Command from list below” -> Press Enter (Keyboard) [SOME MOSTLY USED SYSTEM FOLDERS] All Users Profile %allusersprofile% Desktop Folder(Current User) desktop Favourites […]

Tagged with:

Qbasic – FAQs

Qbasic – FAQs 1.0.0 What is BASIC? 1.1.0 What is Qbasic? 1.1.1 Why QBasic? 1.1.2 Where can I find it? 1.1.3 Qbasic’s limits and capabilities. 1.2.0 How does Qbasic differ from Quick Basic? 1.2.1 From GW-Basic? 1.2.2 From Basica? 1.3.0 What is an “interpreter”? 1.4.0 What is a “compiler”? 1.5.0 Compiling your basic programs. 1.6.0 […]

Tagged with: