Wednesday 14 December 2011

How to Install Apache, PHP, MySQL and PHPMyAdmin in Ubuntu 11.04

If you are a PHP based web developer, you need all the software running and configured properly. Here I am talking about installing them One by One in your Ubuntu Desktop. We are installing all the applications from terminal.

How to Open Terminal:
So, to fire up the terminal follow any of these steps:

  1. If you are running Unity Desktop, click on the Ubuntu Logo at top left corner and type Terminal in the search application bar. Then click on the terminal icon.

  2. If you are running GNome Desktop, click on Applications->Accessories->Terminal

  3. For shortcut, you can also press Ctrl+Alt+T at once, to open the terminal.


How to install Apache:

1. Make sure you have the internet connection. To install apache execute the following command in the terminal:










1


sudo apt-get install apache2




It takes some time to download and install apache. After the setup completes, type http://localhost/ in your browser window to make sure apache is installed and running properly. If you see the page with It Works!, the setup of apache2 completes successfully.

How to Install PHP:

1. To install PHP 5, type following commands in the terminal one by one:










1

2


sudo apt-get install php5

sudo apt-get install libapache2-mod-php5




The first line installs PHP5 in the computer. The second one provides the PHP5 module for the Apache 2 webserver. If second one is not installed, then Apache cannot parse PHP codes in a web page.

2. After installing PHP5 and PHP module for apache, restart the apache with following code:










1


sudo /etc/init.d/apache2 restart




3. While restarting the apache server, if you see a warning as “Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1 for ServerName”, then you can fix this by creating a file with the Server name. To do this type the following command in the terminal:










1


sudo gedit /etc/apache2/conf.d/fqdn




When the text editor opens, type “ServerName localhost” inside the file and click Save. Then close it. Now restart again with the above code and you will see that the warning message has gone.

4. Now, we have successfully installed php and apache web server. However, still we don’t know if PHP is successfully installed. To check this, create a file inside /var/www/ folder named test.php as:










1


sudo gedit /var/www/test.php




and write following code in it










1


<?php   phpinfo();  ?>




Save the file and type this in browser: http://localhost/test.php

If you see the various information about PHP and installed modules there, then we can confirm that Apache is parsing PHP codes. Hence the installation is successful up to this point.

How to Install MySQL:

1. To install MySQL Server in ubuntu, type following code in terminal window:










1


sudo apt-get install mysql-server libapache2-mod-auth-mysql php5-mysql




This will install latest mysql server and other necessary PHP modules for recognizing mysql functions from PHP code. While installing MySQL server, you may require to enter the password for MySQL root user.

How to Install PHPMyAdmin:

1. To Install PHPMyAdmin, type the following codes in the terminal:










1


sudo apt-get install phpmyadmin




While installing PHPMyAdmin, you may require to select the web server. In such case, tick the Apache2 Server and proceed with the installation. You may also require to input MySQL root user password during installation.

Once the installation completes, type this in your browser window to confirm the successful installation of PHPMyAdmin: http://localhost/phpmyadmin/index.php.

Now, you are finished. Your environment is setup and you can enjoy using all these applications. Next, you can install other applications that may be necessary such as Eclipse, GIMP etc.

Tuesday 29 November 2011

The Right Way to Get a File Extension in PHP

I made a recent search on retrieving file extensions in PHP.

I found out that a lot have been re-inventing the wheel. They have been creating code for functionality that PHP already has. This is one example of re-inventing the wheel

function get_file_extension($file_name)
{
return substr(strrchr($file_name,'.'),1);
}


Another example was this:

function file_extension($filename)
{
return end(explode(".", $filename));
}


PHP already has a function that does the same thing and more.

Welcome, pathinfo.

$file_path = pathinfo('/www/htdocs/your_image.jpg');
echo "$file_path ['dirname']\n";
echo "$file_path ['basename']\n";
echo "$file_path ['extension']\n";
echo "$file_path ['filename']\n"; // only in PHP 5.2+


// Output
/www/htdocs
your_image.jpg
jpg
your_image


A much easier way to use the constants:
[PATHINFO_DIRNAME | PATHINFO_BASENAME | PATHINFO_EXTENSION | PATHINFO_FILENAME]

PATHINFO_DIRNAME - the directory
PATHINFO_BASENAME - the file name
PATHINFO_EXTENSION - the extension
PATHINFO_FILENAME - the filename without the extension

echo pathinfo('/www/htdocs/your_image.jpg', PATHINFO_EXTENSION);

// Output

jpg

Friday 21 October 2011

Building your house

An elderly carpenter was ready to retire. He told his employer-contractor of his plans to leave the house-building business to live a more leisurely life with his wife and enjoy his extended family. He would miss the paycheck each week, but he wanted to retire. They could get by.



The contractor was sorry to see his good worker go & asked if he could build just one more house as a personal favor. The carpenter said yes, but over time it was easy to see that his heart was not in his work. He resorted to shoddy workmanship and used inferior materials. It was an unfortunate way to end a dedicated career.



When the carpenter finished his work, his employer came to inspect the house. Then he handed the front-door key to the carpenter and said, “This is your house…my gift to you.



“The carpenter was shocked!



What a shame! If he had only known he was building his own house, he would have done it all so differently.

So it is with us. We build our lives, a day at a time, often putting less than our best into the building. Then, with a shock, we realize we have to live in the house we have built. If we could do it over, we would do it much differently.



But, you cannot go back. You are the carpenter, and every day you hammer a nail, place a board, or erect a wall. Someone once said, “Life is a do-it-yourself project. “Your attitude, and the choices you make today, help build the “house” you will live in tomorrow. Therefore, build wisely!

2 Monks and a Pretty Lady

Once upon a time a big monk and a little monk were traveling together. They came to the bank of a river and found the bridge was damaged. They had to wade across the river.

There was a pretty lady who was stuck at the damaged bridge and couldn’t cross the river.

The big monk offered to carry her across the river on his back to which the lady accepted.

The little monk was shocked by the move of the big monk and was thinking “How can big brother carry a lady when we are supposed to avoid all intimacy with females?” But he kept quiet.

The big monk carried the lady across the river and the small monk followed unhappily. When they crossed the river, the big monk let the lady down and they parted ways with her.

All along the way for several miles, the little monk was very unhappy with the act of the big monk. He was making up all kinds of accusations about big monk in his head. This got him madder and madder. But he still kept quiet. And the big monk had no inclination to explain his situation.

Finally, at a rest point many hours later, the little monk could not stand it any further, he burst out angrily at the big monk. “How can you claim yourself a devout monk, when you seize the first opportunity to touch a female, especially when she is very pretty?”

All your teachings to me make you a big hypocrite.

The big monk looked surprised and said, “I had put down the pretty lady at the river bank many hours ago, how come you are still carrying her along?”

Moral: This very old Chinese Zen story reflects the thinking of many people today. We encounter many unpleasant things in our life, they irritate us and they make us angry. But like the little monk, we are not willing to let them go away. There is no point in remaining hurt by the unpleasant event after it is over. Learn to move on in life!

Monday 3 October 2011

True Love is an Acceptance

It was a busy morning, about 8:30, when an elderly gentleman in his 80′s arrived to have stitches removed from his thumb. He said he was in a hurry as he had an appointment at 9:00 am.

I took his vital signs and had him take a seat, knowing it would be over an hour before someone would to able to see him. I saw him looking at his watch and decided, since I was not busy with another patient, I would evaluate his wound.

On examining,I saw that it was well healed, so I talked to one of the doctors, got the needed supplies to remove his stitches and redress his wound. While taking care of his wound, I asked him if he had another doctor’s appointment this morning, as he was in such a hurry. The gentleman told me no, that he needed to go to the nursing home to eat breakfast with his wife. I inquired as to her health.

He told me that she had been therefor a while and that she was a victim of Alzheimer’s Disease. As we talked, I asked if she would be upset if he was a bit late. He replied that she no longer knew who he was, that she had not recognized him in five years now. I was surprised, and asked him, “And you still go every morning, even though she doesn’t know who you are?”

He smiled as he patted my hand and said, “She doesn’t know me, but I still know who she is.”

I had to hold back tears as he left, I had goose bumps on my arm, and thought, ‘That is the kind of love I want in my life.’

Moral:

True love is neither physical, nor romantic.

True love is an acceptance of all that is,

has been, will be, and will not be.

Sunday 2 October 2011

Things aren’t Always What They Seem..

Two traveling angels stopped to spend the night in the home of a wealthy family. The family was rude and refused to let the angels stay in the mansion’s guest room. Instead the angels were given a small space in the cold basement. As they made their bed on the hard floor, the older angel saw a hole in the wall and repaired it.

When the younger angel asked why, the older angel replied, “Things aren’t always what they seem.” The next night the pair came to rest at the house of a very poor, but very hospitable farmer and his wife. After sharing what little food they had the couple let the angels sleep in their bed where they could have a good night’s rest.

When the sun came up the next morning the angels found the farmer and his wife in tears. Their only cow, whose milk had been their sole income, lay dead in the field. The younger angel was infuriated and asked the older angel how could you have let this happen? The first man had everything, yet you helped him, she accused. The second family had little but was willing to share everything, and you let the cow die.

“Things aren’t always what they seem,” the older angel replied. “When we stayed in the basement of the mansion, I noticed there was gold stored in that hole in the wall. Since the owner was so obsessed with greed and unwilling to share his good fortune, I sealed the wall so he wouldn’t find it.” “Then last night as we slept in the farmers bed, the angel of death came for his wife. I gave him the cow instead. Things aren’t always what they seem.”

Sometimes that is exactly what happens when things don’t turn out the way they should. If you have faith, you just need to trust that every out come is always to your advantage. You might not know it until some time later…

Attitude, good mood or bad mood....

Jerry was the kind of guy you love to hate. He was always in a good mood and always had something positive to say. When someone would ask him how he was doing, he would reply, ” If I were any better, I would be twins!”

He was a unique manager because he had several waiters who had followed him around from restaurant to restaurant. The reason the waiters followed Jerry was because of his attitude. He was a natural motivator. If an employee was having a bad day, Jerry was there telling the employee how to look on the positive side of the situation.

Seeing this style really made me curious, so one day I went up to Jerry and asked him, “I don’t get it! You can’t be a positive person all of the time. How do you do it?”

Jerry replied, “Each morning I wake up and say to myself, ‘Jerry, you have two choices today. You can choose to be in a good mood or you can choose to be in a bad mood.’ I choose to be in a good mood. Each time something bad happens, I can choose to be a victim or I can choose to learn from it. I choose to learn from it. Every time someone comes to me complaining, I can choose to accept their complaining or I can point out the positive side of life. I choose the positive side of life.”

“Yeah, right, it’s not that easy,” I protested.

“Yes, it is,” Jerry said. “Life is all about choices. When you cut way all the junk, every situation is a choice. You choose how you react to situations. You choose how people will affect your mood. You choose to be in a good mood or bad mood. The bottom line: It’s your choice how you live life.”

I reflected on what Jerry said. Soon thereafter, I left the restaurant industry to start my own business. We lost touch, but I often thought about him when I made a choice about life instead of reacting to it.

Several years later, I heard that Jerry did something you are never supposed to do in a restaurant business: he left the back door open one morning and was held up at gunpoint by three armed robbers. While trying to open the safe, his hand, shaking from nervousness, slipped off the combination. The robbers panicked and shot him. Luckily, Jerry was found relatively quickly and rushed to the local trauma center.

After 18 hours of surgery and weeks of intensive care, Jerry was released from the hospital with fragments of the bullets still in his body.

I saw Jerry about six months after the accident. When I asked him how he was, he replied, ” If I were any better, I’d be twins. Wanna see my scars?”

I declined to see his wounds, but did ask him what had gone through his mind as the robbery took place. “The first thing that went through my mind was that I should have locked the back door,” Jerry replied. “Then, as I lay on the floor, I remembered that I had two choices: I could choose to live, or I could choose to die. I chose to live.”

“Weren’t you scared? Did you lose consciousness?” I asked.

Jerry continued, “The paramedics were great. They kept telling me I was going to be fine. But when they wheeled me into the emergency room and I saw the expressions on the faces of the doctors and nurses, I got really scared. In their eyes, I read, ‘He’s a dead man.’

“I knew I needed to take action.”

“What did you do?” I asked.

“Well, there was a big, burly nurse shouting questions at me,” said Jerry. “She asked if I was allergic to anything. ‘ Yes,’ I replied. The doctors and nurses stopped working as they waited for my reply. I took a deep breathe and yelled, ‘ Bullets!’ Over their laughter, I told them. ‘I am choosing to live. Operate on me as if I am alive, not dead.”

Jerry lived thanks to the skill of his doctors, but also because of his amazing attitude. I learned from him that every day we have the choice to live fully. Attitude, after all, is everything.

******

You have 2 choices now:

1. Crib about your daily life and what are you doing and be unhappy . . .

2. Enjoy every moment of your life & give in your Best . . .

Keep Smiling Always…

Which wolf will win? (A Lesson from the Elders)

Grandfather was an elder Cherokee Native American who had a wrinkled, nut brown face and kind dark eyes. His grandson often came in the evening to sit on his knee and ask the many questions that children ask.

One day the grandson came to his grandfather with a look of anger on his face; the child’s anger turned to quiet tears. “Come sit, tell me what happened today”, grandfather said. “Father and I went to the store today and because I helped him, he bought me a present of a jack-knife. It was small but a good size for me.

Here the boy laid his head against his grandfather’s knee and became silent. The grandfather, softly placed his hand on the boy’s raven hair and said, “And then what happened?”
Without lifting his head, the boy said, “I went outside to wait for father and to admire my new knife in the sunlight. Some town boys came by and saw me, they got all around me and starting saying bad things. They called me dirty and stupid and said that I should not have such a fine knife. The largest of these boys pushed me back and I fell over one of the other boys. I dropped my knife and one of them snached it up and they all ran away laughing.” Here the boy’s anger returned, “I hate them. I hate them all.”

The elder Cherokee, with eyes that have seen too much, lifted his grandson’s face so his eyes looked into the boy’s face. Grandfather said, “Let me tell you a story. I too, at times, have felt a great hate for those who have taken so much with no sorrow for what they do. But hate wears you down and does not hurt your enemy. It is like taking poison and wishing your enemy would die. I have struggled with these feeling many times. It is as if two wolves are inside me…. It is a terrible fight.

One wolf is good and does no harm. He lives in harmony with all around him and does not take offense when no offense was intended. It will only fight when it is right to do so and in the right way. This wolf stands for joy, peace, love, hope, sharing, serenity, humility, kindness, benevolence, friendship, empathy, generosity, truth, compassion and faith.
The other wolf is full of anger. The littlest thing will set him into a fit of a temper. He fights everyone, all the time, for no reason. He cannot think because his anger and hate are so great. It is helpless anger, for his anger will change nothing. This wolf represents fear, envy, greed, arrogance, self-pity, guilt, lies, false pride and superiority.
Sometimes it is hard to live with these two wolves inside me for both of them try to dominate my spirit. This same fight is going on inside you and inside every other person too.
The boy looked intently into his grandfather’s eyes and asked, “Which wolf will win?” The old Cherokee simply replied….

“The one you feed.”

Thursday 29 September 2011

Pair of Old Shoes!

A young man, a student in one of the universities, was one day taking a walk with a professor, who was commonly called the students’ friend for his kindness to those who waited on his instructions.

As they went along, they saw lying in the path a pair of old shoes, which were supposed to belong to a poor man who was working in a field close by, and who had nearly finished his day’s work . . .

Student turned to the professor, saying: “Let us play the man a trick: We will hide his shoes, and hide ourselves behind those bushes, and wait to see his perplexity when he cannot find them …”

“My young friend,” answered the professor, “We should never amuse ourselves at the expense of the poor . . . But you are rich, and may give yourself a much greater pleasure by means of this poor man.

Put a coin in each shoe, and then we will hide ourselves and watch how this affects him..” The student did so and they both placed themselves behind the bushes close by. The poor man soon finished his work, and came across the field to the path where he had left his coat and shoes . . .

While putting on his coat he slipped his foot into one of his shoes, but feeling something hard, he stooped down to feel what it was, and found the coin. Astonishment and wonder were seen upon his
countenance.

He gazed upon the coin, turned it around and looked at it again and again.

He then looked around him on all sides, but no person was to be seen. He now put the money into his pocket, and proceeded to put on the other shoe; but his surprise was doubled on finding the other coin . . .

His feelings overcame him… He fell upon his knees, looked up to heaven and uttered aloud a fervent thanksgiving in which he spoke of his wife, sick and helpless, and his children without bread, whom this timely bounty, from some unknown hand, would save from perishing…

The student stood there deeply affected, and his eyes filled with tears.

“Now,” said the professor, are you not much better pleased than if you had played your intended trick?”
The youth replied, “You have taught me a lesson which I will never forget… I feel now the truth of these words, which I never understood before: “It’s more blessed to give than to receive.”

If you want happiness… .For a lifetime – help someone…

Wednesday 21 September 2011

Are you Joining The ' The 99 CLUB"? -- Nice Story..

Once upon a time, there lived a King who, despite his luxurious lifestyle, was neither happy nor content.

One day, the King came upon a servant who was singing happily while he worked. This fascinated the King. Why was he, the Supreme Ruler of the Land, unhappy and gloomy, while a lowly servant had so much joy? The King asked the servant, “Why are you so happy?” The man replied, “Your Majesty, I am nothing but a servant, but my family and I don’t need too much – just a roof over our heads and warm food to fill our tummies.” The king was not satisfied with that reply. Later in the day, he sought the advice of his most trusted advisor. After hearing the King’s woes and the servant’s story, the advisor said, “Your Majesty, I believe that the servant has not been made part of The 99 Club.” “The 99 Club? And what exactly is that?” the King inquired. The advisor replied, “Your Majesty, to truly know what The 99 Club is, place 99 Gold coins in a bag and leave it at this servant’s doorstep.”

When the servant saw the bag, he took it into his house. When he opened the bag, he let out a great shout of joy… So many gold coins! He began to count them. After several counts, he was at last convinced that there were 99 coins. He wondered, “What could’ve happened to that last gold coin? Surely, no one would leave 99 coins!” He looked everywhere he could, but that final coin was elusive. Finally, exhausted, he decided that he was going to have to work harder than ever to earn that gold coin and complete his collection. From that day, the servant’s life was changed. He was overworked, horribly grumpy, and castigated his family for not helping him make that 100th gold coin. He stopped singing while he worked. Witnessing this drastic transformation, the King was puzzled. When he sought his advisor’s help, the advisor said, “Your Majesty, the servant has now officially joined The 99 Club.” He continued, “The 99 Club is a name given to those people ho have enough to be happy but are never content, because they’re always yearning and striving for that extra 1 telling to themselves: “Let me get that one final thing and then I will be happy for life.” We can be happy, even with very little in our lives, but the minute we’re given something bigger and better, we want even more! We lose our sleep, our happiness, we hurt the people around us, all these as a price for our growing needs and desires.

That’s what is called joining The 99 Club!

Eye - Opening Story -- Must Read

A boat docked in a tiny Mexican village. An American tourist complimented

the Mexican fisherman on the quality of his fish and asked how long it took

him to catch them.

“Not very long , ” answered the Mexican.

“But then , why didn’t you stay out longer and catch more?” asked the

American.

The Mexican explained that his small catch was sufficient to meet his needs

and those of his family.

The American asked , “But what do you do with the rest of your time?”

“I sleep late , fish a little , play with my children , and take a siesta with

my wife. In the evenings , I go into the village to see my friends , play the

guitar , and sing a few songs… I have a full life.”

The American interrupted , “I have an MBA from Harvard , and I can help you!

You should start by fishing longer every day. You can then sell the extra

fish you catch. With the extra revenue , you can buy a bigger boat.”

“And after that?” asked the Mexican.

“With the extra money the larger boat will bring , you can buy a second one

and a third one and so on until you have an entire fleet of trawlers.

Instead of selling your fish to a middle man , you can then negotiate

directly with the processing plants and maybe even open your own plant. You

can then leave this little village and move to Mexico City , Los Angeles , or

even New York City ! From there you can direct your huge new enterprise.”

“How long would that take?” asked the Mexican.

“Twenty , perhaps twenty-five years , ” replied the American.

“And after that?”

“Afterwards? Well my Friend , That’s when it gets really interesting , ”

answered the American , laughing. “When your business gets really big , you

can start selling stocks and make millions!”

“Millions? Really? And after that?” said the Mexican.

“After that you’ll be able to retire , live in a tiny village near the

coast , sleep late , play with your children , catch a few fish , take a siesta

with your wife and spend your evenings doing what you like and enjoying

your friends.”

“With all due respect sir , but that’s exactly what I am doing now. So

what’s the point wasting twenty-five years?” asked the Mexican.

And the moral is:

Know where you’re going in life… you may already be there…! Be Content..! Be Happy with what you have..!

Check My Performance -- Nice Story...

A little boy went into a drug store, reached for a soda carton and pulled it over to the telephone.
He climbed onto the carton so that he could reach the buttons on the phone and proceeded to punch in seven digits.

The store-owner observed and listened to the conversation:

The boy asked,” Lady, Can you give me the job of cutting your lawn?

The woman replied, “I already have someone to cut my lawn.”

Lady, I will cut your lawn for half the price of the person who cuts your lawn now.” replied boy.

The woman responded that she was very satisfied with the person who was presently cutting her lawn.

The little boy found more perseverance and offered,” Lady, I’ll even sweep your curb and your sidewalk, so on Sunday you will have the prettiest lawn in all of North Palm beach, Florida.”

Again the woman answered in the negative. With a smile on his face, the little boy replaced the receiver.

The store-owner, who was listening to all, this, walked over to the boy and said,” Son… I like your attitude; I like that positive spirit and, would like to offer you a job.”

The little boy replied, “No thanks, I was just checking my performance with the job I already have. I am the one who is working for that lady, I was talking to!”

Thursday 25 August 2011

Normalization Basics – 1NF 2NF and 3NF

Description of Normalization


Normalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency.


Redundant data wastes disk space and creates maintenance problems. If data that exists in more than one place must be changed, the data must be changed in exactly the same way in all locations. A customer address change is much easier to implement if that data is stored only in the Customers table and nowhere else in the database.


What is an “inconsistent dependency”? While it is intuitive for a user to look in the Customers table for the address of a particular customer, it may not make sense to look there for the salary of the employee who calls on that customer. The employee’s salary is related to, or dependent on, the employee and thus should be moved to the Employees table. Inconsistent dependencies can make data difficult to access because the path to find the data may be missing or broken.


There are a few rules for database normalization. Each rule is called a “normal form.” If the first rule is observed, the database is said to be in “first normal form.” If the first three rules are observed, the database is considered to be in “third normal form.” Although other levels of normalization are possible, third normal form is considered the highest level necessary for most applications.


As with many formal rules and specifications, real world scenarios do not always allow for perfect compliance. In general, normalization requires additional tables and some customers find this cumbersome. If you decide to violate one of the first three rules of normalization, make sure that your application anticipates any problems that could occur, such as redundant data and inconsistent dependencies.


The following descriptions include examples.


First Normal Form


















Eliminate repeating groups in individual tables.
Create a separate table for each set of related data.
Identify each set of related data with a primary key.

Do not use multiple fields in a single table to store similar data. For example, to track an inventory item that may come from two possible sources, an inventory record may contain fields for Vendor Code 1 and Vendor Code 2.


What happens when you add a third vendor? Adding a field is not the answer; it requires program and table modifications and does not smoothly accommodate a dynamic number of vendors. Instead, place all vendor information in a separate table called Vendors, then link inventory to vendors with an item number key, or vendors to inventory with a vendor code key.


Second Normal Form














Create separate tables for sets of values that apply to multiple records.
Relate these tables with a foreign key.

Records should not depend on anything other than a table’s primary key (a compound key, if necessary). For example, consider a customer’s address in an accounting system. The address is needed by the Customers table, but also by the Orders, Shipping, Invoices, Accounts Receivable, and Collections tables. Instead of storing the customer’s address as a separate entry in each of these tables, store it in one place, either in the Customers table or in a separate Addresses table.


Third Normal Form










Eliminate fields that do not depend on the key.

Values in a record that are not part of that record’s key do not belong in the table. In general, any time the contents of a group of fields may apply to more than a single record in the table, consider placing those fields in a separate table.


For example, in an Employee Recruitment table, a candidate’s university name and address may be included. But you need a complete list of universities for group mailings. If university information is stored in the Candidates table, there is no way to list universities with no current candidates. Create a separate Universities table and link it to the Candidates table with a university code key.


EXCEPTION: Adhering to the third normal form, while theoretically desirable, is not always practical. If you have a Customers table and you want to eliminate all possible interfield dependencies, you must create separate tables for cities, ZIP codes, sales representatives, customer classes, and any other factor that may be duplicated in multiple records. In theory, normalization is worth pursing. However, many small tables may degrade performance or exceed open file and memory capacities.


It may be more feasible to apply third normal form only to data that changes frequently. If some dependent fields remain, design your application to require the user to verify all related fields when any one is changed.


Normalizing an Example Table


loadTOCNode(2, ‘moreinformation’); These steps demonstrate the process of normalizing a fictitious student table.





















1. Unnormalized table:





























Student# Advisor Adv-Room Class1 Class2 Class3
1022 Jones 412 101-07 143-01 159-02
4123 Smith 216 201-01 211-02 214-01

2. First Normal Form: No Repeating Groups


Tables should have only two dimensions. Since one student has several classes, these classes should be listed in a separate table. Fields Class1, Class2, and Class3 in the above records are indications of design trouble.


Spreadsheets often use the third dimension, but tables should not. Another way to look at this problem is with a one-to-many relationship, do not put the one side and the many side in the same table. Instead, create another table in first normal form by eliminating the repeating group (Class#), as shown below:















































Student# Advisor Adv-Room Class#
1022 Jones 412 101-07
1022 Jones 412 143-01
1022 Jones 412 159-02
4123 Smith 216 201-01
4123 Smith 216 211-02
4123 Smith 216 214-01

3. Second Normal Form: Eliminate Redundant Data


Note the multiple Class# values for each Student# value in the above table. Class# is not functionally dependent on Student# (primary key), so this relationship is not in second normal form.


The following two tables demonstrate second normal form:


Students:




















Student# Advisor Adv-Room
1022 Jones 412
4123 Smith 216

Registration:

































Student# Class#
1022 101-07
1022 143-01
1022 159-02
4123 201-01
4123 211-02
4123 214-01

4.

In the last example, Adv-Room (the advisor’s office number) is functionally dependent on the Advisor attribute. The solution is to move that attribute from the Students table to the Faculty table, as shown below:


Students:

















Student# Advisor
1022 Jones
4123 Smith

Faculty:




















Name Room Dept
Jones 412 42
Smith 216 42

Wednesday 24 August 2011

Difference between require, require_once, include and include_once

All these functions require, require_once, include and include_once are used to include the files in the php page but there is slight difference between these functions.

Difference between require, require_once, include, include_once
Difference between require and include is that if the file you want to include is not found then include function give you warning and executes the remaining code in of php page where you write the include function. While require gives you fatal error if the file you want to include is not found and the remaining code of the php page will not execute.

If you have many functions in the php page then you may use require_once or include_once. There functions only includes the file only once in the php page. If you use include or require then may be you accidentally add two times include file so it is good to use require_once or include_once which will include your file only once in php page. Difference between require_once and include_onceis same as the difference between require and include.

Different types of errors in PHP

Here are three basic types of runtime errors in PHP:

1. Notices: These are trivial, non-critical errors that PHP encounters while executing a script – for example, accessing a variable that has not yet been defined. By default, such errors are not displayed to the user at all – although you can change this default behavior.

2. Warnings: These are more serious errors – for example, attempting to include() a file which does not exist. By default, these errors are displayed to the user, but they do not result in script termination.

3. Fatal errors: These are critical errors – for example, instantiating an object of a non-existent class, or calling a non-existent function. These errors cause the immediate termination of the script, and PHP’s default behavior is to display them to the user when they take place.

Difference between mysql_connect() and mysql_pconnect()

mysql_connect() and mysql_pconnect() both are working for database connection but with little difference. In mysql_pconnect(), ‘p’ stands for persistance connection.

When we are using mysql_connect() function, every time it is opening and closing the database connection, depending on the request .

But in case of mysql_pconnect() function,
First, when connecting, the function would try to find a (persistent) connection that’s already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection.
Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the connection will remain open for future use (mysql_close() will not close connection established by mysql_pconnect()).

mysql_pconncet() is useful when you have a lot of traffice on your site. At that time for every request it will not open a connection but will take it from the pool. This will increase the efficiency of your site. But for general use mysql_connect() is best.

I think this is a very imp concept in case of Database Connectivity.

MySQL interview questions

1. What is DDL, DML and DCL? - If you look at the large variety of SQL commands, they can be divided into three large subgroups. Data Definition Language deals with database schemas and descriptions of how the data should reside in the database, therefore language statements like CREATE TABLE or ALTER TABLE belong to DDL. DML deals with data manipulation, and therefore includes most common SQL statements such SELECT, INSERT, etc. Data Control Language includes commands such as GRANT, and mostly concerns with rights, permissions and other controls of the database system.

2. How do you get the number of rows affected by query? - SELECT COUNT (user_id) FROM users would only return the number of user_id’s.


3. If the value in the column is repeatable, how do you find out the unique values? - Use DISTINCT in the query, such as SELECT DISTINCT user_firstname FROM users; You can also ask for a number of distinct values by saying SELECT COUNT (DISTINCT user_firstname) FROM users;

4. How do you return the a hundred books starting from 25th? - SELECT book_title FROM books LIMIT 25, 100. The first number in LIMIT is the offset, the second is the number.

5. You wrote a search engine that should retrieve 10 results at a time, but at the same time you’d like to know how many rows there’re total. How do you display that to the user? - SELECT SQL_CALC_FOUND_ROWS page_title FROM web_pages LIMIT 1,10; SELECT FOUND_ROWS(); The second query (not that COUNT() is never used) will tell you how many results there’re total, so you can display a phrase "Found 13,450,600 results, displaying 1-10". Note that FOUND_ROWS does not pay attention to the LIMITs you specified and always returns the total number of rows affected by query.

6. How would you write a query to select all teams that won either 2, 4, 6 or 8 games? - SELECT team_name FROM teams WHERE team_won IN (2, 4, 6, 8 )

7. How would you select all the users, whose phone number is null? - SELECT user_name FROM users WHERE ISNULL(user_phonenumber);

8. What does this query mean: SELECT user_name, user_isp FROM users LEFT JOIN isps USING (user_id) - It’s equivalent to saying SELECT user_name, user_isp FROM users LEFT JOIN isps WHERE users.user_id=isps.user_id

9. How do you find out which auto increment was assigned on the last insert? - SELECT LAST_INSERT_ID() will return the last value assigned by the auto_increment function. Note that you don’t have to specify the table name.

10. What does –i-am-a-dummy flag to do when starting MySQL? - Makes the MySQL engine refuse UPDATE and DELETE commands where the WHERE clause is not present.

11. On executing the DELETE statement I keep getting the error about foreign key constraint failing. What do I do? - What it means is that so of the data that you’re trying to delete is still alive in another table. Like if you have a table for universities and a table for students, which contains the ID of the university they go to, running a delete on a university table will fail if the students table still contains people enrolled at that university. Proper way to do it would be to delete the offending data first, and then delete the university in question. Quick way would involve running SET foreign_key_checks=0 before the DELETE command, and setting the parameter back to 1 after the DELETE is done. If your foreign key was formulated with ON DELETE CASCADE, the data in dependent tables will be removed automatically.

12. When would you use ORDER BY in DELETE statement? - When you’re not deleting by row ID. Such as in DELETE FROM techinterviews_com_questions ORDER BY timestamp LIMIT 1. This will delete the most recently posted question in the table techinterviews_com_questions.

13. How can you see all indexes defined for a table? - SHOW INDEX FROM techinterviews_questions;

14. How would you change a column from VARCHAR(10) to VARCHAR(50)? - ALTER TABLE techinterviews_questions CHANGE techinterviews_content techinterviews_CONTENT VARCHAR(50).

15. How would you delete a column? - ALTER TABLE techinterviews_answers DROP answer_user_id.

16. How would you change a table to InnoDB? - ALTER TABLE techinterviews_questions ENGINE innodb;

17. When you create a table, and then run SHOW CREATE TABLE on it, you occasionally get different results than what you typed in. What does MySQL modify in your newly created tables? -
1. VARCHARs with length less than 4 become CHARs
2. CHARs with length more than 3 become VARCHARs.
3. NOT NULL gets added to the columns declared as PRIMARY KEYs
4. Default values such as NULL are specified for each column

18. How do I find out all databases starting with ‘tech’ to which I have access to? - SHOW DATABASES LIKE ‘tech%’;

19. How do you concatenate strings in MySQL? - CONCAT (string1, string2, string3)

20. How do you get a portion of a string? - SELECT SUBSTR(title, 1, 10) from techinterviews_questions;

21. What’s the difference between CHAR_LENGTH and LENGTH? - The first is, naturally, the character count. The second is byte count. For the Latin characters the numbers are the same, but they’re not the same for Unicode and other encodings.

22. How do you convert a string to UTF-8? - SELECT (techinterviews_question USING utf8);

23. What do % and _ mean inside LIKE statement? - % corresponds to 0 or more characters, _ is exactly one character.

24. What does + mean in REGEXP? - At least one character. Appendix G. Regular Expressions from MySQL manual is worth perusing before the interview.

25. How do you get the month from a timestamp? - SELECT MONTH(techinterviews_timestamp) from techinterviews_questions;

26. How do you offload the time/date handling to MySQL? - SELECT DATE_FORMAT(techinterviews_timestamp, ‘%Y-%m-%d’) from techinterviews_questions; A similar TIME_FORMAT function deals with time.

27. How do you add three minutes to a date? - ADDDATE(techinterviews_publication_date, INTERVAL 3 MINUTE)

28. What’s the difference between Unix timestamps and MySQL timestamps? - Internally Unix timestamps are stored as 32-bit integers, while MySQL timestamps are stored in a similar manner, but represented in readable YYYY-MM-DD HH:MM:SS format.

29. How do you convert between Unix timestamps and MySQL timestamps? - UNIX_TIMESTAMP converts from MySQL timestamp to Unix timestamp, FROM_UNIXTIME converts from Unix timestamp to MySQL timestamp.

30. What are ENUMs used for in MySQL? - You can limit the possible values that go into the table. CREATE TABLE months (month ENUM ‘January’, ‘February’, ‘March’,…); INSERT months VALUES (’April’);

31. How are ENUMs and SETs represented internally? - As unique integers representing the powers of two, due to storage optimizations.

What’s the difference between LEFT, RIGHT, INNER, OUTER, JOIN?

What’s the difference between LEFT, RIGHT, INNER, OUTER, JOIN?

The difference is in the way tables are joined if there are no common records.
JOIN is same as INNER JOIN and means to only show records common to both tables. Whether the records are common is determined by the fields in join clause. For example:

FROM t1
JOIN t2 on t1.ID = t2.ID

means show only records where the same ID value exists in both tables.
LEFT JOIN is same as LEFT OUTER JOIN and means to show all records from left table (i.e. the one that precedes in SQL statement) regardless of the existance of matching records in the right table.
RIGHT JOIN is same as RIGHT OUTER JOIN and means opposite of LEFT JOIN, i.e. shows all records from the second (right) table and only matching records from first (left) table.

Friday 19 August 2011

Affirmations: Why Are They So Powerful?

[caption id="attachment_285" align="alignleft" width="300" caption="Life"]Leave Life Like King Size[/caption]An affirmation is defined as something declared to be true; a positive statement or judgment.

Affirmations affirm what is going on inside your mind and your heart.

The garden of our life is developed through the planting of seeds that flow from our mouth on a daily basis.

If you respond to the state of your health, wealth and love life with negative phrases you will end up with a weedy patch for a life.

The good book reveals to us clearly that ‘life and death are in the power of the tongue.’

So to ensure that life is springing up in your garden (life), begin to speak the following phrases about:

* Your health
* Your wealth
* Your love

Here are those that I speak, and I trust that they will add great value to your life as you participate.
My Health Affirmations

* Health is my portion.
* I am energetic and enthusiastic.
* My body heals fast.
* Peace is my portion.
* No matter what has been suffered by my parents health wise, I am healthy, whole and terrific.
* Good health is mine to possess.
* My mind is brimming with healthy thoughts.
* I have a sound mind and body.
* I am well and have ‘well’ days.
* I treat my body as my temple.
* I move freely and forward.
* I treat my body with respect by feeding it healthy food, drinking healthy fluids, and exercising it regularly.

My Wealth Affirmations

* I deserve to have money in the bank.
* My income increases.
* I have an excellent credit rating.
* I am a wise spender.
* I have as much money as I can receive.
* I prosper financially.
* Bills are met with joy as I pay them on time.
* I save and invest out of every dollar I earn.
* I give at least 10% of everything I earn as my way of saying thank you for the 100% received.
* My income is without limit.
* I am creative when it comes to handling money.
* I am financially literate.

My Love Affirmations

* I love me and am secure with who I am.
* Love is forever.
* Love liberates me.
* To be in love is to be safe.
* My lover is my equal.
* By taking care of myself I take care of our love.
* I overcome jealousy by developing my own self-esteem.
* People love me for who I am.
* I deserve to be loved.
* I will develop my own love pattern, not the one set by my parents or my peers.
* Loving both others and myself gets better every day.
* The more I open myself up to loving and being loved the safer I feel.
* My lover and I respect each other and the decisions we make.
* My loving relationships are long lasting.

So go forth and speak these affirmations each and every day. Be prepared for a miracle.

Tuesday 16 August 2011

11 Must Read Life Lessons From John Lennon

“For those of you in the cheap seats I’d like ya to clap your hands to this one; the rest of you can just rattle your jewelery!” John Lennon

I remember hearing ‘Hey Jude’ blaring from the speakers at school when I was a young boy. I was as much caught up in Beatle-mania as the next person. The ‘Fab Four’ totally turned the music world upside down with their vast array of melodies, clever lyrics and singable tunes.

They were dynamic, controversial, trendsetters, radicals, confrontational plus a whole lot more.

But even though I love the cheekiness – as represented in the above quote – of John Lennon, there is so much more that he shared with the world apart from his music. Therein lies a depth of wisdom that I would like to expand upon.

So let us explore together yet another side of the man that encouraged us all to ‘Imagine’.

1.”Life is what happens to you while you’re busy making other plans.”


It has been written that if you fail to plan, you plan to fail. Blink and twenty years will pass you by. Life is never a direct route. It weaves. It twists. It turns. But if you have a goal, a dream or a plan in place, it acts as a compass that keeps you on track, no matter what detours need to be taken along the way.

2. “Time you enjoy wasting, was not wasted.”


Nothing is ever wasted. I experienced nearly 26 years in my life that I call the ‘lost years’, and yet, even though my true identity was lost during that period, the lessons learnt were invaluable. Those years have supplied me with stories that I can now tell to help others to enjoy and prosper from their uniqueness.

3. “It doesn’t matter how long my hair is or what colour my skin is or whether I’m a woman or a man.”


Success is not restricted to culture, gender or heritage. Successful people rise up from every conceivable starting point. So we can never use our state of being as an excuse for never achieving great things. One person with a dream, and a willingness to do whatever it takes to achieve that dream, makes it a level playing field.

4. “A dream you dream alone is only a dream. A dream you dream together is reality.”


Dreams are no fun if you keep them to yourself. Dreams are to be shared. Dreams fulfilled are to be enjoyed by all. Whenever I succeed I celebrate it with my family and my friends. I get the greatest satisfaction from the spin-off of my successes and how they positively impact those whom I love.

5. “Reality leaves a lot to the imagination.”


Reality plus a sprinkle of imagination turns that which seems impossible into something that is possible. If you can imagine it, and you can believe it, you can achieve it. Dare to be as a child once again and imagine by asking yourself the question, ‘What if?’ Then go do.

6. “If someone thinks that love and peace is a cliché that must have been left behind in the Sixties, that’s his problem. Love and peace are eternal.”


To love and to be loved would have to be the greatest thing that I have ever experienced. In my darkest hours it has been the love shown to me that has sustained me and strengthened my resolve to press on.

And then there is peace. Solitude and the practice of solitude have constantly filled me with peace. It is the eye in the storm. It is the rock that stands firm. Peace has sustained me and refreshed me. And it is in this place that definitive and life changing decisions have been made to move me forward in life.

7. “I get by with a little help from my friends.”


Not one of us can do it alone. Without friends, and the support of friends, we live in a desert. For friends are the oases. Friends are the refreshing. Friends lift us up when we are down. Friends believe in us when no-one else does. Friends are there in fair weather, and there when storms rage. Friends know when to speak and when to keep silent. Friends for life.

8. “You don’t need anybody to tell you who you are or what you are. You are what you are!”


Stop listening to what others say you are. You are what you are, and the older you get the more knowledgeable you need to become of who you really are. This is your road of self discovery. This is the unveiling of your uniqueness. This is the birth of self-pride – a healthy pride that is proud of what you have been created to be and to do. Listen to your inner voice and stand up tall knowing who you are.

9. “Count your age by friends, not years. Count your life by smiles, not tears.”


Joy. Happiness. Companionship. Define your life by the company that you keep and by the goodness that you can deposit into the lives of those around you. How do you measure the effectiveness of your life? Make it much more than what you can acquire. Measure it by what you can give.

10. “There’s nowhere you can be that isn’t where you’re meant to be…”


Nothing happens by accident. There is an eternal plan for each of us, and even what appears to be the greatest mistake will in retrospect be the perfect piece of stitching embroidered into the fabric of your life. Someone once showed me the back of an embroidered piece of cloth. On the back it appeared as a tangled mess. But by turning it over a beautiful piece of handiwork was revealed. So too our lives.

11. “One thing you can’t hide – is when you’re crippled inside.”


Angry people are angry with themselves. Unfriendly people don’t like themselves. How people act clearly reveals what is going on in the inside of their minds and hearts. People who love themselves have no difficulty in loving others. People who have no problem in forgiving others have forgiven themselves. As a man or woman thinks so he or she will speak. So turn to the cripple within your life and command – ‘Take up your bed and walk!’ Begin to live as the human that was created for greatness. You were never created to be an invalid. Healing is your portion and success is your right.

And for one final word from John Lennon, who was cut down in the prime of his life – “I’m not afraid of death because I don’t believe in it. It’s just getting out of one car, and into another.” 

 

How To Become A Great Finisher

The road to hell may or may not be paved with good intentions, but the road to failure surely is. Take a good look at the people you work with, and you’ll find lots of Good Starters — individuals who want to succeed, and have promising ideas for how to make that happen. They begin each new pursuit with enthusiasm, or at the very least, a commitment to getting the job done.

And then something happens. Somewhere along the way, they lose steam. They get bogged down with other projects. They start procrastinating and miss deadlines. Their projects take forever to finish, if they get finished at all.

Does all this sound familiar? Maybe a little too familiar? If you are guilty of being a Good Starter, but a lousy finisher — at work or in your personal life — you have a very common problem. After all, David Allen’s Getting Things Done wouldn’t be a huge bestseller if people could easily figure out how to get things done on their own.

More than anything else, becoming a Great Finisher is about staying motivated from a project’s beginning to its end. Recent research has uncovered the reason why that can be so difficult, and a simple and effective strategy you can use to keep motivation high.

In their studies, University of Chicago psychologists Minjung Koo and Ayelet Fishbach examined how people pursuing goals were affected by focusing on either how far they had already come (to-date thinking) or what was left to be accomplished (to-go thinking). People routinely use both kinds of thinking to motivate themselves. A marathon runner may choose to think about the miles already traveled or the ones that lie ahead. A dieter who wants to lose 30 pounds may try to fight temptation by reminding themselves of the 20 pounds already lost, or the 10 left to go.

Intuitively, both approaches have their appeal. But too much to-date thinking, focusing on what you’ve accomplished so far, will actually undermine your motivation to finish rather than sustain it.

Koo and Fishbach’s studies consistently show that when we are pursuing a goal and consider how far we’ve already come, we feel a premature sense of accomplishment and begin to slack off. For instance, in one study, college students studying for an exam in an important course were significantly more motivated to study after being told that they had 52% of the material left to cover, compared to being told that they had already completed 48%.

When we focus on progress made, we’re also more likely to try to achieve a sense of “balance” by making progress on other important goals. This is classic Good Starter behavior — lots of pots on the stove, but nothing is ever ready to eat.

If, instead, we focus on how far we have left to go (to-go thinking), motivation is not only sustained, it’s heightened. Fundamentally, this has to do with the way our brains are wired. To-go thinking helps us tune in to the presence of a discrepancy between where we are now and where we want to be. When the human brain detects a discrepancy, it reacts by throwing resources at it: attention, effort, deeper processing of information, and willpower.

In fact, it’s the discrepancy that signals that an action is needed — to-date thinking masks that signal. You might feel good about the ground you’ve covered, but you probably won’t cover much more.

Great Finishers force themselves to stay focused on the goal, and never congratulate themselves on a job half-done. Great managers create Great Finishers by reminding their employees to keep their eyes on the prize, and are careful to avoid giving effusive praise or rewards for hitting milestones “along the way.” Encouragement is important, but to keep your team motivated, save the accolades for a job well — and completely — done.

Nine Ways to use LinkedIn to Advance your Career





Image representing LinkedIn as depicted in Cru...A new member joins LinkedIn every second. Since I first started writing about how to use LinkedIn as a job search tool, the professional social networking site has grown in reach and strength. According to spokeswoman Krista Canfield, LinkedIn now has more than 100 million users, with a new member joining every second. Its job postings have bulged to more than 62,000. When the company went public May 19, its shares surged above $100 before sliding below $70, but just today, a story in The New York Times reports that its lead underwriter, Morgan Stanley raised its price target to $88, saying LinkedIn could become a “standard utility for HR recruiters.” I’m now convinced that an active LinkedIn profile is essential for almost anyone who wants to cultivate a career. Even if you are satisfied in your job, LinkedIn can bring you unexpected opportunities. Canfield herself says she was sending a LinkedIn message to an old public relations client, asking for advice about travel to London and Paris, when the contact responded with the tip that LinkedIn was hiring. Canfield wound up getting the job. That’s the way traditional networking operates, but since it’s digital and nearly instantaneous, LinkedIn can be startlingly efficient.



1. Include more than your current job

If you are setting up your profile quickly and only want to include the bare bones, be sure to list as many of your past positions as possible. If you’ve been in your job only a few months, and that’s all you include, you will look like you are just starting your career. Canfield says that recruiters routinely search according to years of experience.

2. Add a photo
Canfield says LinkedIn has found that profiles with photos are seven times more likely to be viewed. Also, if you’re reaching out to old contacts, they may be more likely to remember your face than your name. If you’ve married and changed your name, a photo can clear up the confusion.

3. Connect to at least 50 people
LinkedIn has settled on 50 as the “magic number” that will increase your networking chances. Career coach Hellmann recommends 70 connections.

4. Connect with people you know.
Career coach Hellmann advises a do-unto-others rule when deciding whether to connect with other LinkedIn users. “If they’re total strangers, they’re not going to help you and you’re not going to help them,” he observes. Would you be willing to correspond with this person, and/or send an email on the contact’s behalf? Then you should connect. One caveat: Some people use LinkedIn to promote products, in which case they want a sprawling network, including strangers. But if you’re using LinkedIn as a job search tool, make sure you know your contacts well enough to want to network with them.

5. Personalize your communications
This is a pet peeve of mine. When you send a request to connect with someone, always take a moment to alter the default message, even if just to say something like, “Hey Jack, Let’s connect.” Think of how you feel when you receive a form letter. I feel alienated, and less inclined to respond.

6. Use the job postings
I frequently caution that job seekers should limit their time perusing online ads, but LinkedIn’s listings are worth reviewing. Click on a job and you will instantly see the contacts in your network who are connected to the company. In addition, coach Hellmann says he’s found that far fewer of them are false leads or listings by recruiters for positions that have already been filled. LinkedIn charges $295 for a 30-day posting.

7. Use the site’s “skills” link to help you find key words to include in your profile.
This is a new feature. Go to this link and brainstorm about your skills, typing them into the search box. On the left hand side of the page, you will get a list of related skills, each highlighted in blue. For those of us stumped about how to describe our talents in the form of crisp, web-search-friendly terms, this can help. Take the relevant phrases and words and plug them into the “Skills” section of your profile. Both Hellmann and Canfield say that hiring managers and recruiters frequently search for key words. Example: I plugged in “headline writing,” and I got “line editing and “news judgment,” both terms that hadn’t crossed my mind. The page also shows a bar graph that indicates how much a particular skill is growing. (Sadly, both headline writing and news judgment show only 1% hiring growth.) Hellmann also recommends scanning job ads in your field and noting the key words used.

8. For students: new jobs portal
Another new LinkedIn feature: a job portal designed for students and recent graduates. Companies do not pay to list these entry level jobs. Since it’s new, the listings are limited, but given how easy it is to use, it’s worth taking a look here for entry level jobs.

9. Try LinkedIn Today
LinkedIn is beefing up its editorial feature, which includes stories shared by contacts in your network. It now appears near the top of the “home” tab when you sign into LinkedIn. I’m agnostic about its utility, given all the other ways to search for industry news, but would say it’s worth a glance once a day.

Wednesday 10 August 2011

Nine things successful people do differently

Why have you been so successful in reaching some of your goals, but not others? If you aren’t sure, you are far from alone in your confusion. It turns out that even brilliant, highly accomplished people are pretty lousy when it comes to understanding why they succeed or fail. The intuitive answer — that you are born predisposed to certain talents and lacking in others — is really just one small piece of the puzzle. In fact, decades of research on achievement suggests that successful people reach their goals not simply because of who they are, but more often because of what they do.

1. Get specific.

When you set yourself a goal, try to be as specific as possible. “Lose 5 pounds” is a better goal than “lose some weight,” because it gives you a clear idea of what success looks like. Knowing exactly what you want to achieve keeps you motivated until you get there. Also, think about the specific actions that need to be taken to reach your goal. Just promising you’ll “eat less” or “sleep more” is too vague — be clear and precise. “I’ll be in bed by 10pm on weeknights” leaves no room for doubt about what you need to do, and whether or not you’ve actually done it.

2. Seize the moment to act on your goals.

Given how busy most of us are, and how many goals we are juggling at once, it’s not surprising that we routinely miss opportunities to act on a goal because we simply fail to notice them. Did you really have no time to work out today? No chance at any point to return that phone call? Achieving your goal means grabbing hold of these opportunities before they slip through your fingers.

To seize the moment, decide when and where you will take each action you want to take, in advance. Again, be as specific as possible (e.g., “If it’s Monday, Wednesday, or Friday, I’ll work out for 30 minutes before work.”) Studies show that this kind of planning will help your brain to detect and seize the opportunity when it arises, increasing your chances of success by roughly 300%.

3. Know exactly how far you have left to go.

Achieving any goal also requires honest and regular monitoring of your progress — if not by others, then by you yourself. If you don’t know how well you are doing, you can’t adjust your behavior or your strategies accordingly. Check your progress frequently — weekly, or even daily, depending on the goal.

4. Be a realistic optimist.

When you are setting a goal, by all means engage in lots of positive thinking about how likely you are to achieve it. Believing in your ability to succeed is enormously helpful for creating and sustaining your motivation. But whatever you do, don’t underestimate how difficult it will be to reach your goal. Most goals worth achieving require time, planning, effort, and persistence. Studies show that thinking things will come to you easily and effortlessly leaves you ill-prepared for the journey ahead, and significantly increases the odds of failure.

5. Focus on getting better, rather than being good.

Believing you have the ability to reach your goals is important, but so is believing you can get the ability. Many of us believe that our intelligence, our personality, and our physical aptitudes are fixed — that no matter what we do, we won’t improve. As a result, we focus on goals that are all about proving ourselves, rather than developing and acquiring new skills.

Fortunately, decades of research suggest that the belief in fixed ability is completely wrong — abilities of all kinds are profoundly malleable. Embracing the fact that you can change will allow you to make better choices, and reach your fullest potential. People whose goals are about getting better, rather than being good, take difficulty in stride, and appreciate the journey as much as the destination.

6. Have grit.

Grit is a willingness to commit to long-term goals, and to persist in the face of difficulty. Studies show that gritty people obtain more education in their lifetime, and earn higher college GPAs. Grit predicts which cadets will stick out their first grueling year at West Point. In fact, grit even predicts which round contestants will make it to at the Scripps National Spelling Bee.

The good news is, if you aren’t particularly gritty now, there is something you can do about it. People who lack grit more often than not believe that they just don’t have the innate abilities successful people have. If that describes your own thinking …. well, there’s no way to put this nicely: you are wrong. As I mentioned earlier, effort, planning, persistence, and good strategies are what it really takes to succeed. Embracing this knowledge will not only help you see yourself and your goals more accurately, but also do wonders for your grit.

7. Build your willpower muscle.

Your self-control “muscle” is just like the other muscles in your body — when it doesn’t get much exercise, it becomes weaker over time. But when you give it regular workouts by putting it to good use, it will grow stronger and stronger, and better able to help you successfully reach your goals.

To build willpower, take on a challenge that requires you to do something you’d honestly rather not do. Give up high-fat snacks, do 100 sit-ups a day, stand up straight when you catch yourself slouching, try to learn a new skill. When you find yourself wanting to give in, give up, or just not bother — don’t. Start with just one activity, and make a plan for how you will deal with troubles when they occur (“If I have a craving for a snack, I will eat one piece of fresh or three pieces of dried fruit.”) It will be hard in the beginning, but it will get easier, and that’s the whole point. As your strength grows, you can take on more challenges and step-up your self-control workout.

8. Don’t tempt fate.

No matter how strong your willpower muscle becomes, it’s important to always respect the fact that it is limited, and if you overtax it you will temporarily run out of steam. Don’t try to take on two challenging tasks at once, if you can help it (like quitting smoking and dieting at the same time). And don’t put yourself in harm’s way — many people are overly-confident in their ability to resist temptation, and as a result they put themselves in situations where temptations abound. Successful people know not to make reaching a goal harder than it already is.

9. Focus on what you will do, not what you won’t do.

Do you want to successfully lose weight, quit smoking, or put a lid on your bad temper? Then plan how you will replace bad habits with good ones, rather than focusing only on the bad habits themselves. Research on thought suppression (e.g., “Don’t think about white bears!”) has shown that trying to avoid a thought makes it even more active in your mind. The same holds true when it comes to behavior — by trying not to engage in a bad habit, our habits get strengthened rather than broken.
If you want change your ways, ask yourself, What will I do instead? For example, if you are trying to gain control of your temper and stop flying off the handle, you might make a plan like “If I am starting to feel angry, then I will take three deep breaths to calm down.” By using deep breathing as a replacement for giving in to your anger, your bad habit will get worn away over time until it disappears completely.

It is my hope that, after reading about the nine things successful people do differently, you have gained some insight into all the things you have been doing right all along. Even more important, I hope are able to identify the mistakes that have derailed you, and use that knowledge to your advantage from now on. Remember, you don’t need to become a different person to become a more successful one. It’s never what you are, but what you do.

Wednesday 3 August 2011

3 Ways That You Can Make A Real Difference

[caption id="attachment_259" align="alignleft" width="259" caption="You Make The Difference"]You Make The Difference[/caption]‘You’re significant, you’re meaningful, you matter, and you can make a difference.’ Carlos Santana

Never underestimate the power of being you. You are someone of incredible value.

You see things that others fail to see. You understand things that others fail to comprehend. You have a view of the world that is visible only to you. You have a voice that speaks truths and asks questions that arouse discussion that leads to the attainment of greater knowledge.

You are of incredible value – and here are just three things you need to know that are the currency that adds up to such a precious life.

1. Know That You’re Significant

You are not irrelevant. You are not irrational. You are not insignificant. You were born with a mission. And it is your commission to discover that mission and to fulfill that mission.

You were never formed to simply take up space and suck up the oxygen that could have been used by someone else with greater talent than yourself. Who said anything about talent? If you look at others and compare yourself with those around you, you will always come up short.

You are significant. Your actions are of vital significance. Your words are of essential significance. You being you is significant. You are significant, and without you bringing that significance to bear on our world we would be left holding insignificance in our hands. Our lives are transformed significantly by those who accept and embrace their significance, and believe and act as a significant one.

2. Know That You’re Meaningful

To be meaningful is to have a meaning or a purpose. It is to live a meaningful life. For a life lived with purpose will be lived on purpose. It has direction. It has focus. It has attached to it actionable steps that will lead towards an end, a dream, or a goal. It does not meander aimlessly. It does not wake up in wonder – wondering what to do next. It is a life lived under the direction of a compass that guides its path – no matter the terrain, no matter the weather, no matter the impossibilities of the forces that resist its progress forward.

A meaningful life pursues purpose with every footstep taken, every word uttered, every plan made, and every detour explored. For each meaningful thought is another brick added to the foundations of a life destined to be the sound architectural construction that it was destined to become.

3. Know That You Matter

To be needed is one of the most powerful concepts to drive away self-centerdness. And to know that your contribution, your involvement, your leadership, and your being is of vital importance, drives deep the pylons of ‘you can make a real difference’ into the fiber of your being.

Scientifically, matter is what makes our world a reality. Spiritually, matter is the unseen part of you that impacts the physical world that we live in.

For centuries mankind has debated as to the consistency of matter – but all arguments aside – no matter what others think or say – you matter – and it is because of that undeniable fact that you can make a real difference to your life, your families lives, and to the world that benefits greatly from your presence in it.

You, yes you, can make a real difference. So go and make a difference.

The Top Most Inspirational Quotes About Life

Inspirational quotes are the oxygen that has breathed fresh invigoration into my life throughout the years. When facing personal challenges, a quote has often popped into my head and inspired me to press on. When I’ve needed to encourage someone else, often a quote will raise its head up and I find myself sharing it with them.

Quotes appear on Twitter with a vengeance, and are often the most liked and shared expressions found on a range of social media.

People love quotes. Why? They inspire. They motivate. They ignite. They put the gas in our empty tank.

Because they are bite-sized, they are easily digestible, and of course the greatest value is that they are memorable.

So allow me to share with you, in my opinion, the top most inspirational quotes ever uttered.





1. ‘Insist On Yourself: Never Imitate.’ Ralph Waldo Emerson


2. ‘What ever the mind of man can conceive and believe, it can achieve.’ Napoleon Hill




3. ‘Change your thoughts and you change your world.’ Norman Vincent Peale






4. ‘Tough times never last, but tough people do.’ Robert H. Schuller






5. ‘The three things that are most essential to achievement are common sense, hard work and stick-to-it-iv-ness.’ Thomas Edison






6. ‘Forgiveness is the fragrance that the violet sheds on the heel that has crushed it.’ Mark Twain






7. ‘Well done is better than well said.’ Benjamin Franklin






8. ‘The quality of a person’s life is in direct proportion to their commitment to excellence, regardless of their chosen field of endeavor.’ Vince Lombardi


Tuesday 2 August 2011

MySQL RIGHT JOIN

[caption id="attachment_249" align="alignleft" width="160" caption="MySql Right Join"]MySql Right Join[/caption]Here you find information about writing RIGHT JOINs (also referred to as RIGHT OUTER JOINs). This introduction into right joins includes a detailed description, syntax information and right outer join example statements. The Venn diagram on the left represents a result set that a statement with a right join produces. refer to the syntax examples below for an example.

Right Join syntax
First of all, some syntax examples for the impatient:

-- right join with USING-clause
SELECT *
FROM RIGHT JOIN
USING(id)

-- right join with ON-clause
SELECT *
FROM a RIGHT JOIN b
ON a.name = b.authorName

As you can see, a join condition can be written with the keyword ON or the keyword USING. The difference is that the ON keyword is used when each relationship column has a different name and USING when a column with the same name exists in both tables.
Reference table, left and right table?

When we join two tables, there is always a left and a right table (take a look at our syntax examples):

  • The left table is listed on the left side of the OUTER JOIN keywords


  • The right table is listed on the right side of the OUTER JOIN keywords




The outer join which is used decides which table is treated as the reference table. A left join treats the left- and a right join the right table as the reference table. Do you recognize the reference table in the syntax examples? Alright, fasten your seat belts. We’re ready to take off.
Right Outer Joins vs Inner joins

A right outer join is a specialized outer join. Like an inner join, an outer join combines (joins) matching rows that are stored in two different tables. In addition, an outer join also adds unmatched rows from a reference table to the result set. In case of a right outer join this means that when there is a row in the right table which can’t be combined with any row in the left table (according to the join condition), MySQL…

  • takes all selected values from the right table

  • combines them with the column names from the left table.

  • sets the value of every column from the left table to NULL




This is the important difference, because an inner join is not able to select records from a reference table that have no related data in another.

MySQL LEFT JOIN

[caption id="attachment_245" align="alignleft" width="160" caption="MySql Left Join"]MySql Left Join[/caption]Here you find information about writing LEFT JOINs (also referred to as LEFT OUTER JOINs). This introduction into left joins includes a description, syntax information and example statements that use left outer joins. The Venn diagram on the left represents a result set that a statement with a left join produces. Please refer to the syntax examples below for an example. Links to additional information resources can be found at the end of this article.

Left Join syntax

First of all, some syntax examples for the impatient:

-- left join with USING-clause
SELECT *
FROM LEFT JOIN
USING(id)

-- left join with ON-clause
SELECT *
FROM a LEFT JOIN b
ON a.name = b.authorName

As you can see, a join condition can be written with the keyword ON or the keyword USING. The difference is that the ON keyword is used when each relationship column has a different name and USING when a column with the same name exists in both tables.

Reference table, left and right table?
When we join two tables, there is always a left and a right table (take a look at syntax examples):


  • The left table is listed on the left side of the OUTER JOIN keywords



  • The right table is listed on the right side of the OUTER JOIN keywords






The outer join which is used decides which table is treated as the reference table. A left join treats the left- and a right join the right table as the reference table. Do you recognize the reference table in the syntax examples?

Left Outer Joins vs Inner joins


A left outer join is a specialized outer join. Like an inner join, an outer join combines (joins) matching rows that are stored in two different tables. In addition, an outer join also adds unmatched rows from a reference table to the result set. In case of a left outer join this means that when there is a row in the left table which can’t be combined with any row in the right table (according to the join condition), MySQL…


  • takes all selected values from the left table

  • combines them with the column names from the right table.

  • sets the value of every column from the right table to NULL


This is the important difference, because an inner join is not able to select records from a reference table that have no related data in another.

MySQL INNER JOIN With comma operator

My Sql Inner JoinHere you find information about writing inner joins with the comma operator. It’s the most basic way to combine (join) two tables. There is an alternative syntax that can be used, because in MySQL you can write inner joins in two different ways. Another popular way is it to use the INNER JOIN command or synonymous keywords like CROSS JOIN and JOIN.

Syntax

The following examples are equivalent to the INNER JOIN examples, to make it easy to compare them. The first example builds the Cartesian product of two tables: Every row in the left table is combined with every row in the right table. In ANSI SQL, this is called a cross join. MySQL however doesn’t distinguish between inner joins and cross joins.

-- inner join without a condition: a cross join
SELECT *
FROM a, b

- inner join with WHERE-clause
SELECT *
FROM a, b
WHERE a. = b.

When you write inner joins using the comma operator, there is only one way to specify the join condition: with a WHERE-clause.

Basics

An inner join combines all matching rows from two related tables. Two rows match if they are related, for example because they share a common column. When you write an inner join with the comma operator, the join condition which reflects a relationship between tables is added as a WHERE clause. You can use inner joins to SELECT, UPDATE or DELETE data that is stored within MySQL tables. Here are two more examples which are equivalent to the INNER JOIN examples:

SELECT *
FROM tableA a, tableB b
WHERE a.someColumn = b.otherColumn

Further information
You have seen how to write inner joins with the comma operator. From My point of view, it’s “OK” to use this feature. However, using the alternative syntax makes it easier to read your joins. It’s considered as a good behavior to write statements where you can directly see if it’s an INNER JOIN or a CROSS JOIN (the Cartesian product of two tables).

MySQL INNER JOIN

[caption id="attachment_236" align="alignleft" width="160" caption="My SQL Inner Join Example"]My SQL Inner Join Example[/caption]This Article shows you how to write inner joins with the INNER JOIN keywords.

Please note: In MySQL the join keywords JOIN and CROSS JOIN are synonymous with INNER JOIN which means: All example statements found in this article work fine when you use JOIN or CROSS JOIN instead of INNER JOIN.

Syntax
Here are syntax examples for the impatient. A join condition can be specified in two different ways. Take a look at the following join examples:

-- inner join with USING clause

SELECT *
FROM a INNER JOIN b
USING()

-- inner join with ON clause

SELECT *
FROM a INNER JOIN b
ON a. = b.

Now we should take a closer look at inner joins and what they really do.

Basics

The most common join operation MySQL supports is an inner join. It identifies and combines only matching rows which are stored in two related tables. A join condition which indicates how the tables are related, is added with the keywords ON or USING :

ON is used when the relationship column has a different name
USING is used when the relationship column has the same name in both tables
Take a look at the examples:

-- INNER JOIN with ON clause
SELECT *
FROM tableA a
INNER JOIN tableB b
ON  a.someColumn = b.otherColumn

-- INNER JOIN with USING clause
SELECT *
FROM tableA a
INNER JOIN tableB b
USING(columnName)

Inner Join vs Cross Join

In MySQL, the keywords CROSS JOIN and INNER JOIN are synonymous. ANSI SQL defines a CROSS JOIN as a join without a condition which builds the Cartesian product of two tables. In that case, MySQL combines every row in the left table with every row in the right table and returns the result set.

-- inner join without a condition: cross join
SELECT *
FROM CROSS JOIN

When you have to build the Cartesian product of two tables, use the CROSS JOIN keywords to indicate your intensions. It makes it easy to read your statement and of course, keeps your code more portable.

Inner Join vs Outer Join
The major dhifference between outer joins and inner joins is: an outer join is able to identify rows that were not matched by any row in the joined table.
More than one join
It’s also not uncommon to add more than one join to a single statement. There is no additional syntax required. You only have to write a second (a third, and so on) join:

-- more than one inner join
SELECT *
FROM tableA a
INNER JOIN tableB b
ON a.someColumn = b.otherColumn
INNER JOIN tableC c
ON b.anotherColumn = c.nextColumn

How do you connect to multiple MySQL databases on a single webpage?

You can make multiple calls to mysql_connect(), but if the parameters are the same you need to pass true for the '$new_link' (fourth) parameter, otherwise the same connection is reused.

so then you have

$dbh1 = mysql_connect($hostname, $username, $password);
$dbh2 = mysql_connect($hostname, $username, $password, true);

mysql_select_db('database1', $dbh1);
mysql_select_db('database2', $dbh2);

Then to query database 1, do

mysql_query('select * from tablename', $dbh1);

and for database 2

mysql_query('select * from tablename', $dbh2);

Alternatively, if the mysql user has access to both databases and they are on the same host (i.e. both DBs are accessible from the same MySQL connection) you could:

Example :

$migglecon = mysql_connect("localhost","root","123");
mysql_select_db("thefarmyard",$migglecon)or die(mysql_error());


$drupalcon= mysql_connect($localhost,$root,$123,true);
mysql_select_db("miggle",$drupalcon)or die(mysql_error());