At last, i made my portfolio site. I started to realize the need of a portfolio site from the very beginning of my freelancing career. There most of the clients look for good number of reviews and 'portfolio' site link. Day by day, i mad a number of feed backs(made half century recently :) ). Then, came the idea for the portfolio site. I took hosting/domain support from godaddy.
It was under development for last several days, was hard to manage time to complete it :)
Now, it has become to a stage that i can show to my clients. Although there are a lot of things still need to do there, but its in a stage now. I will upgrade it day by day with my growing experience/knowledge as much as possible.
Hope, from now on, clients will have some much better impact than before and thus i can get more good quality projects :)
Please visit my portfolio site here. Its open for al of yours comments, feedbacks, inquery, quotes..
i2dev.com
0
Sometimes, auto increment doesn't meet our expectation. we want to insert the next highest id than the latest one exist on table. However auto increment will always increment whether the data with that id exists or deleted. So, many unused ids could be there those are deleted after insertions. To achieve this, we have to identify the current maximum id in the table and then insert the next highest id. To achieve this we may have to execute two sql statement in normal sense. One is to identify the max id and then the insert query that will insert data.
This can be much simpler and can be done in a single sql query. The query will be as follows:
INSERT into tblname(id,name) Select (isnull(MAX(id),0)+1),'test' from tblname
/*Edited the query to test whether id is null or not(set result to 1 if so) after getting feedback from one visitor*/
It will execute much faster than the individual sql queries. This is actuall a modified version of a select and insert type queries where data are selected from a table and inserted to another table.
This can be much simpler and can be done in a single sql query. The query will be as follows:
INSERT into tblname(id,name) Select (isnull(MAX(id),0)+1),'test' from tblname
/*Edited the query to test whether id is null or not(set result to 1 if so) after getting feedback from one visitor*/
It will execute much faster than the individual sql queries. This is actuall a modified version of a select and insert type queries where data are selected from a table and inserted to another table.
I was making a small effect of sliding up and sliding down. It will toggle on every click to a single link/button. I was first planning to make the toggle code myself and taking help of slideUp() and slideDown() functions of jquery. But, Very soon, i came to know about the new function of jquery slideToggle() that actually do my requirements automatically. As a result i got my job done in a single line of code:
$("#linkId").click(function(){
$("#divId").slideToggle().
});
There are details documentation and options on jquery's main documentation site. Find reference of this funciton here:
jquery toggle slide
Moreover what i liked about this function, its works and shows a div automatically if its hidden initially(i needed that as on page loading a div is shown until script execution).
$("#linkId").click(function(){
$("#divId").slideToggle().
});
There are details documentation and options on jquery's main documentation site. Find reference of this funciton here:
jquery toggle slide
Moreover what i liked about this function, its works and shows a div automatically if its hidden initially(i needed that as on page loading a div is shown until script execution).
I just reached a small milestone in getting ratings/reviews as a freelancer service provider on freelancer.com. Its a half century. Currently, total number of ratings are 51. Check my ratings here, http://www.bit.ly/freelance_web_developer
I am enjoying working on freelancer.com. As I already have a full time job, and doing freelancing part time besides the job, its hard to gather reviews/rating that much quickly or work on many freelance sites. That's why, till now, I am only working with freelancer.com and no other sites yet although i have accounts on several sites.
The only things that i didn't like about freelancer.com till now, is that it has increased its golden membership fees from $12 to $20. All others are considerably satisfactory.This site is comparatively new among the freelance websites, but it has already taken its own place. Its upgrading itself day by day with exclusive new features.
I want to go much more ahead in this site. Wish me good luck :)
I am enjoying working on freelancer.com. As I already have a full time job, and doing freelancing part time besides the job, its hard to gather reviews/rating that much quickly or work on many freelance sites. That's why, till now, I am only working with freelancer.com and no other sites yet although i have accounts on several sites.
The only things that i didn't like about freelancer.com till now, is that it has increased its golden membership fees from $12 to $20. All others are considerably satisfactory.This site is comparatively new among the freelance websites, but it has already taken its own place. Its upgrading itself day by day with exclusive new features.
I want to go much more ahead in this site. Wish me good luck :)
Database Normalization:
The main goal of Database Normalization is to restructure the logical data model of a database to:
* Eliminate redundancy
* Organize data efficiently
* Reduce the potential for data anomalies.
Data Anomalies:
Data anomalies are inconsistencies in the data stored in a database as a result of an operation such as update, insertion, and/or deletion.Such inconsistencies may arise when have a particular record stored in multiple locations and not all of the copies are updated.
We can prevent such anomalies by implementing 7 different level of normalization called Normal Forms (NF), first 3 of them are mostly used.
1st Normal Form:
The requirements to satisfy the 1st NF:
* Each table has a primary key: minimal set of attributes which can uniquely identify a record.
* The values in each column of a table are atomic (No multi-value attributes allowed).
* There are no repeating groups: two columns do not store similar information in the same table.
2nd Normal Form:
The requirements to satisfy the 2nd NF:
* All requirements for 1st NF must be met.
* Redundant data across multiple rows of a table must be moved to a separate table.
* The resulting tables must be related to each other by use of foreign key.
3rd Normal Form:
The requirements to satisfy the 3rd NF:
* All requirements for 2nd NF must be met.
* Eliminate fields that do not depend on the primary key;
* That is, any field that is dependent not only on the primary key but also on another field must be moved to another table.
The main goal of Database Normalization is to restructure the logical data model of a database to:
* Eliminate redundancy
* Organize data efficiently
* Reduce the potential for data anomalies.
Data Anomalies:
Data anomalies are inconsistencies in the data stored in a database as a result of an operation such as update, insertion, and/or deletion.Such inconsistencies may arise when have a particular record stored in multiple locations and not all of the copies are updated.
We can prevent such anomalies by implementing 7 different level of normalization called Normal Forms (NF), first 3 of them are mostly used.
1st Normal Form:
The requirements to satisfy the 1st NF:
* Each table has a primary key: minimal set of attributes which can uniquely identify a record.
* The values in each column of a table are atomic (No multi-value attributes allowed).
* There are no repeating groups: two columns do not store similar information in the same table.
2nd Normal Form:
The requirements to satisfy the 2nd NF:
* All requirements for 1st NF must be met.
* Redundant data across multiple rows of a table must be moved to a separate table.
* The resulting tables must be related to each other by use of foreign key.
3rd Normal Form:
The requirements to satisfy the 3rd NF:
* All requirements for 2nd NF must be met.
* Eliminate fields that do not depend on the primary key;
* That is, any field that is dependent not only on the primary key but also on another field must be moved to another table.
Last week, on 4rth april, I have lost my father. This death caused by a sudden heart stroke. I listened the news of stroke while on office work. Very quickly, after a while, i came to listen the news of his death. This is the ever most tragedy in my life till now. I just can't even believe sometimes, how was happened. I am here thereby beg all the readers to pray at least once for a few moments for my father. May allah keep him in peace. I will try to follow my fathers all good advises throughout my life...
Subscribe to:
Posts (Atom)
