Archive for the Category » Development «

SQL Query for SQL server 2000

List of all the user created tables from the sql server database,
SELECT name FROM sysobjects WHERE xtype = ‘U’;

List field names of the database table,
SELECT [name] AS [Column name] FROM syscolumns WHERE id = (SELECT id FROM sysobjects WHERE type = ‘U’ AND [NAME] = ‘your table name’)

 

Select drop down item based on value by Javascript

[select name="select_district" id="select_district"]
[option value="Bogra"]Bogra[/option]
[option value="Dhaka"]Dhaka[/option]
[/select]

[script language="javascript"]document.getElementById(“select_district”).value = ‘<?php echo $district;?>’;[/script]

Refreshing a parent page from a child popup

parent.php
<?php
echo date(“h:m:s”);
?>
[script language="javascript1.2"]
function openPanelManager()
{
mywindow = window.open ["child.php","title is here","location=0,status=0,scrollbars=1,width =525,height=700"];
mywindow.moveTo(0,0);
}
[script]

Your [a href="javascript:openPanelManager();"]Customized Profiles[a]

child.php

[input type="submit" name="Submit" value="Submit" onclick="opener.window.location.reload();self.close();return false;" ]

Part time smart earning by Web Development

You are IT or any other professional and have idle hours daily, interested in programming & part time earning by utilizing your idle time, i think you may choice web development as your helping hand earning.

1. You may start from here
2. you must need some basic understanding of HTML. go here and study the basic concepts.
3. download a quick start resource and try to analyze codes and move forward yourself.
4. but a domain say (www.salimworks.com or anything)
5. start works online. build you own website as you wish. for example, build some features in your website as follows:

  • online voting of different topics time to time
  • sports news collection
  • create a forum for members where people will share their feelings about game or whatever
  • valuable links: maintain some valuable links(simply search in google and index links)
  • find some more features/ideas (whatever it is) by yourself

6. once your website is completed you start bidding online. there are tons of bidding websites in the world (ex: odesk.com, www.freelancefree.com, www.freelancer.com etc). all payments are 100% transparent. so don’t worry about payment. select only 1 bidding site and bid & response to buyer regularly. check your email in every hours. every buyer view your attentiveness/browse in freelancing site. in order to win a bid show your website as a reference. surely you will get minimum earning with maximum efforts. BUT it’s actually your investment. once you have a good portfolio you will get good price works with your minimum effort.
7. Consider this work as part time job not full time. always try to manage some buyers personally. so that you both able to become maximum benefited. if you earn more then current salary consistently at least 6 months you may think for full time if you have enough courage to take challenge.
8. many people earn money smartly, so enjoy programming and start part time smart earning parallel to your current job.

At every stage discuss with them who know a bit more then you. Share your works with them. collect advice and move forward. Always try to ask google.com first. Keep in mind, you may not the first person who facing this problem in this world. So google may help you to answer your question. If google fails post it in Online community which is powerful and helpful teacher for you. don’t hesitate to ask in forums. Post your problems in multiple forums to get your solution quicker.

Enjoy smart earning parallel to your current earning.

How to embed youtube video

Very simple.
1. Open you tube video.
2. Click “Share” button
3. Click “Embed” button
4. Copy the code and paste into your page where you want to display.

All projects backup in a Single PC (including Versioning)

It’s really nighhtmare to maintain all projects backup manually in a single computer when a project is developed by different programmer(s). But it’s really easy if we assign the manual task to any sub versioning sofware like Tortois SVN.

Prerequiresites:

1. Local area network(LAN).

2. Install SVN in all computers including Backup Server ( installation require 5 minutes per computer).  How to install?

3. Backup Server (don’t worry its a general configuration computer just consider as Backup Server). It’s wise to assign company name to backup server. For instance say company

When a project(first_project) starts, do the following task in Server:

1. Create Repository in Server computer. Which mean create a folder named first_project in server pc.
here is your new project in server

2. Open the folder and right click -> TortoisSVN -> Create Repository Here.
attempt to create repository

3. Many folders will create and show a popup confirmation as.
Repository created successfully

 

 

When a project(first_project) starts do the following task in Developer PC:

1. Create a folder in your root with the same name first_project. open the folder and Right click -> SVN Checkout
Make connection with server

 

2. You will get a folder named .svn. Now paste initial folder and files of your project here. After that, right click -> SVN commit. Press ok.
Your playground is ready for you

Every hour or end of the day when developer plan to take off from office, simply right click -> SVN Commit
Files stored in server with success

 

That’s it :) All projects are now under version control. Which mean after 2 month, if you want to revert a module it’s possible. Who developed this module (need some editing) is easy to identify. Enjoy Yourself !!
Hey keep in mind, if your backup server hard drive crash due to power failure i am not responsible for that :D If crashed, don’t worry every developer PC still contain latest version of the project. So lets get START :)

Feature list of upcoming shopno-dinga

Here is a list of features what is under development actually not under development but it’s under consideration. we will finish our finalization task within next 3 year. however, regardless of technology or tools, here are the available features of shopno dinga

  1. bla….
  2. bla…..
  3. bla…..

how is it possible to select list of features without know the proper requirement? Okay sir…. lets analyze our requirements first. to know the requirement we have meet with shopno dinga team but we found them in DEEP SLEEP. So let them sleep ZZZZZZZZZZZZZzzzzzzzzzzzz

analyze ourselves. what we are and what we are looking for in shopon-dinga? we are travelers and we are fond of traveling. so definitely we should love to see any valuable information regarding traveling. what it can be? matter of thinking…….. ah!! it can be a good place to visit, historical place, or a theme park, any natural place where will enjoy maximum. the place should be awesome and attractive also. moreover, we traveler will be happy if we found a way to reach that place. this should be good help for foreign travelers though they don’t have any idea of communication rather then perception. as a result they desire most for communicative information.

so from the above visitors we found two features. i.e

  1. Tourist Place
  2. Medium of Communication

lets move further. some traveler will be happy if they get the route of available transports(boat, bus, launch, train, airplane.. etc et…) along with their time schedule. hey !! why not you include fair? ha ha. no doubt, cut your coat according to your cloth. lets cut according to traveler’s wish. many people can’t travel excellent place due to short cloth of them. so why not shopno-dinga arrange some tours with limited / less amount of money.

there are few other peoples who are really interested of tour but they feel hasty alone. if they get a good group then they will become pleased. surely they have enough right to expect it from shopno dinga.

“Ah man !!! i am extremely busy with works and you can’t imagine how busy i am ” — it’s a common dialog of maximum peoples around us. and to be honest we all are really busy with our own work except shopno-dinga (as though it’s sleeping last few months decades). but these busy peoples are also human being and they have feelings or traveling. so is it possible to build a section for busy guys?

some people hate to browse shopno-dinga daily but love to receive travel related informations. so there should be a section for subscribe of interested traveler’s. very simple email subscription.

Student’s feel crazy!!! why are we excluded? we also have feelings and this can’t be a major reason that, we don’t have much money. instead, we can share many things, like hotel rooms, or launch deck rather then cabin, food and many other luxurious facilities etc etc……………… Hhhhhhhhhmmmmmm they are 100% right. so student must have right to have a section for their traveling. Thrilling is important rather then luxury for students, so more focused on thrill for them.

upto this point from the above visitors we found the following features. these are

  1. Tourist Place
  2. Communication Medium
  3. Transport Fairs
  4. Least Cost Tour
  5. Group Traveling
  6. Vacation Tour
  7. Student Tour
  8. Subscription for tour info

[Oaow!! After a huge response(almost 100 million-10) from the visitors] we come back to think more.

okay… now what else visitor’s expect from shopno dinga? a map of the place(s) surely be helpful for visitors. we can choose google map per country for this purpose. we know google feel proud if they implement here. ha ha ha. traveler are not only traveling but also many of them are fond of foods. local foods, chinese dishes, or italian food may be their good choice. hhhmm so shall we create a section for food? think…. think… think….. No we don’t. the reason is shopno dinga is more valuable then a simple “how to prepare food” site. ton’s of sites already developed with recipes. so let’s ignore it. okay fine… but what else???

oh!! major point still not considered.. a visitor must not come shopno dinga only for view some information. they should be more happy if they can add some. no doubt, they know much and more better places then shopno dinga team. so why not they have power to post some visiting places as well as available transportation?? hhmm very much important consideration for visitors. okay let them have the power to post. in order to do that, shopno-dinga must need an authentication system. which means, registration, login, logout, profile… etc … etc… and most importantly ability to add and edit tourist places. hhmmm another tricky point is: every tourist must like to maintain his/her profile where not only his or her personal informations(name, city, country, etc… etc…) saved but also his/her tour feelings about his/her visited places.

as a summery of discussion these are new features with existing. these are

  1. Tourist Place
  2. Communication Medium
  3. Transport Fairs
  4. Least Cost Tour
  5. Group Traveling
  6. Vacation Tour
  7. Student Tour
  8. Subscription for tour info
  9. Google map shows places by country
  10. Member Registration
  11. Login
  12. Logout
  13. Profile
  14. Add tourist places
  15. Edit own places

all the above considerations don’t have any point of view rather then visitors. but there are huge tourist companies who want to full fill visitors desireness. as well as they generate some revenue’s for that. which means advertisement. attractive packages for visitors one of major offer of them. to give you an idea, AOSI (aim of saint martin island) is a company who have 3 different type of packages. first for students. another one for couple. and third only for luxurious peoples. and they expect some advertisement features from shopno dinga.

oh!! there are many hotels, motels, rest houses and transportation services who desire to place some advertise of their quality services. it’s effective from their point of view (business) and easy to gather valuable informations for visitors. dream reservation??? hhmm idea is nice but not effective right now. instead a contact number can give you the facility of live reservation. let’s skip reservation right now.
which means….. some another features going to be added into feature lists

  1. Tourist Place
  2. Communication Medium
  3. Transport Fairs
  4. Least Cost Tour
  5. Group Traveling
  6. Vacation Tour
  7. Student Tour
  8. Subscription for tour info
  9. Google map shows places by country
  10. Member Registration
  11. Login
  12. Logout
  13. Profile
  14. Add tourist places
  15. Edit own places
  16. Add tourist comapny
  17. Add hotel or motel or resort information

oh!! forget all about number of visitor counting !! although it’s not important to count total visitor or hit per day of shopno-dinga. but it should be a nice to have feature. furthermore, shopdono-dinga will show a list of visitors. it’s dayly, weekly, month visitors. from which country they hit. which country win in the hit. etc… etc… additionally, there should be an FAQ section for visitors and for more query visitor need to contact with shopno-dinga authority. although they are in deep sleep so who will be responsible to reply those query is a question. however, lets count the features.

one further point is that, traveler’s status. by example, traveler Mr. Mofiz start his journey for lalmai hill where no mobile network is available, so you have no way to communicate with him directly rather then pidgin. hey!! don’t think that, shopno-dinga have pidgin service. rater it can provide a status message of every traveler’s profile where from you will notified about his/her present status. furthermore, you are able to know about traveler’s thinking for current days, where he plan to travel. where and with whom him he is right now. if you are not able to understand this feature. then login facebook and give a closer look and you will get a status message for all individuals.

  • visitor tracking
  • show visitor statistics
  • FAQ
  • Contact us
  • Live Status Message

lets consider another different point of view. development and tips. means, how shopno dinga developed and some tips about the critical implementations. this section will contain development style. how to analyze requirement, how to make feature list. which technology will be chosen to develop shopno-dinga. how coding will starts. shall we go for framework? which framework we might choose. how to utilize MVC power. how to prevent conflicts between programmer and designer. everything will be covered in a section named

  • How we developed

Hey!! feature list goes healthy man !!!
What you want to see here? Lets share our feelings.