Showing posts with label MySQL. Show all posts
Showing posts with label MySQL. Show all posts

Friday, September 21, 2012

I want a free Domain

Ok, we assume that you have created a website with PHP, MySQL or even with Joomla or pure HTML. You need a domain for example www.sample.com. Usually for having a domain with popular postfix like .com, .net, .org and etc you should pay money for renting these domain for one year or more. If you are going to launch a business website, so you should pay and buy it. Nevertheless, for personal usage or academic usage domain name is not a big deal. When you use from a host service actually that host assign you a free domain name. But these names are not very short and remembering them is difficult for your audiences. For instance www.tobacco.webhostfree.com. So, what is the solution? Fortunately, there are some domain that are free and short. Today I want to introduce one of them to you.

If you are looking for a free and short domain and you want your domain address be just similar to commercial website, you can use Dot TK. With free service of this domain you will have something like this: www.yourwebsite.tk. It is nice, isn't it? The process of membership is very easy and straightforward. Just go to www.dot.tk and register and select a meaningful name for your domain address. You will have this domain at last for one year free. During this time you can be sure if you are successful person in cyber world or not. Do you want to continue your activity here or not? Does it worth to invest on a website or not? 

Do not forget to change the host name of your domain to your host. If you do not do that. Your domain address is not connected to your server and cannot load your website to the browser. Check your host and look for Host name or IP address. Then modify your domain address and change your host name address to something that you have. That is it. Congratulation for your new and nice Domain name. Be successful in cyber world.

If you need Dot TK just click on below banner. Thanks.

Wednesday, September 12, 2012

My Online Card Sorting Is Ready

It is around two weeks which I working to make my online survey. As you knew there is no free option for doing online survey especially with card sorting technique. So, I decided to design it with PHP and MySQL. It was very interesting and enjoyable activity to build it myself. I love DIY.  You can take a look at it and feel how it will be if you make your card sorting survey yourself.


Absolutely, It worth to do it. However, at least you should have some background in HTML, programming and database designing. Another requirements are PHP, Javascript, Jquery, CSS. If you have these capabilities and you want to build your online card sorting website, you can do it quickly and easily.

Now I am looking for free host and domain. If you know a good one which support PHP, Apachi and MySql version 5 and above please let me to know. Thanks a lot.


Sunday, August 26, 2012

Use MySQL with taste of SQL Server

Hello everyone. In these days I am busy to learn PHP and MySQL to design my questionnaire. I have not worked with MySQL around three years and I could not believe in which extend MySQL developed in these years. When I opened PHPmyAdmin I noticed that MySQL developers added some vital features to it that in my opinion have made MySQL the best database option for small and average projects. For instance several years ago which I came to use MySQL I fed up when I discover MySQL does not support triggers, Transactions and even store procedures! That time SQL Server had all of these features and we preferred to use SQL Server. Now, MySQL have all of these options and it was a very good news for me.

Only drawback which I saw in MySQL was its User Interface. PHPMyAdmin is a nice application and does support many basic needs of developers. However, when you make a store procedure in MySQL, you cannot find it! Why? I do not know. It exists and it works but you cannot see it unless you extract it from systems' table with some codes! It is not very handful especially for people who have worked with SQL Server.

Good news is that some third parties have developed some Graphic User Interfaces (GUI) for MySQL to make it more fashionable and easier to use. Nevertheless we have to pay some bucks to use this advantages. But do not disappointed. Still good guys are on the earth. Yes, one of this GUI is completely free and open source and you can enjoy it with empty pocket! However, it is not bad idea if you liked it donate something to these philanthropist people who are behind the scene. This GUI calls HeidiSQL. You can download it on your computer and use it with MySQL. Do not forget this is only GUI so you should install MySQL first and it does not come with MySQL.

I really have fallen in love with HeidiSQL. It is nice, easy to use and very useful. It shows store procedures, functions, triggers distinctly. It makes up everything PHPMyAdmin does not give you. Now you do not miss SQL Sever anymore when you are using MySQL.I was thinking to this sentence that "All the best things in the world are FREE". I hope you can enjoy this nice GUI. For download please refer to its official website here.

Thursday, August 23, 2012

Awful day with WampServer

Today I stayed at home because two days ago Malaysia held Feter Eid or in Malay Hary Raya. This is the celebration of ending Ramadan (fasting month for Muslims). Based on Malaysian calendar they should have two official holidays for Hary Raya. However, unofficially they have around one week holidays. Nice but I really I do not know how they improve?! They have a lot of official and unofficial holiday and each province have some extra holidays also. I am wondering how Malaysia progress?! They are always in holly day :).

Anyway, because of Hary Raya, university is off and finding some food over there is very difficult. Especially when you do not have vehicle. I stayed at home to complete my work here. As I told you I should design a card sorting questionnaire for some IT experts. I am implementing it with PHP and MySQL. Because you need Apache webserver, MySQL and PHP, it is much easier to install Wamp server to have all of them. Actually wamp server compact these three tools for people who need them and you can install them together. You can find WampServer here.

Installation is very easy and fast. I install it at my PC in University lab. Today I stayed at home and I wanted to install it on my laptop too. I installed and its icon become green and it showed that everything is fine. I was happy and ready to write some code. Suddenly, when I wanted to open Phpmyadmin page, nothing happened! Even it could not load localhost! It was only a blank page without any error! WoW, why? I knew that some times it happens because of port conflict with other software like Skype or IIS (Microsoft web server). However, I did not have anyone of my computer. It was strange for me.

I did some search on the Google and I read some suggestion but they did not work at all. For several times I install and uninstall different versions of Wamp server but nothing changed. I checked if my browser use proxy or not! Even I used command prompt: netstat -oaa to see which applications using port 80. The only one was Apache! Maybe around six hours I wasted my time to solve it. Another guy also had my problem and requested help at Wampserver forum but finally no one could help him.

Eventually, I format one of my partition and installed new Windows and it solved. Yeap. the best way of  solving problem is removing the question! It was a joke. Unfortunately I wasted a lot of time and the worst fact was that not only I could not help this problem, but also I did not understand why and when it happens! Some times a small thing can postpone a big project very ridiculously.

If anybody know the solution, please put a comment and teach me. Thanks.