How to promote my blog? How to get more traffic? What should I do to get more readers? I am sure that you ask this questions to yourself all the time. Probably it’s the reason why you are reading my post. There are tons of articles about it in the Internet and I have chosen top 10 that are really worth reading.
Tag Archive for 'html'
Here is a demo of my url shortening script. It let your visitors to make short redirections of their very long url’s (for example it is useful for twitter users where they are limited to 140 characters). Script is made to be as simple as possible. HTML is separated from PHP so it may be customized by editing one HTML file without touching any PHP code! It do not need MySQL database – all data is stored in the file system. Users are redirected by .htaccess file to desired shortcut. Additionally there is administrator backend module to manage (edit/add/delete) url shortcuts. Below you may click for demo installed on my dev server.
Frontend demo
Backend demo (Login: admin, Password: demo999)
You may get a copy of this script for $30 (installation included) – contact me if interested.
Update: Free version of this script have been released. Click here for more details.
Today I have had to modify very complex script to change look of html form. It is quite easy to make changes in the form. But sometimes it is a problem to modify not to well written PHP script to receive data from new form.
Continue reading…
If you need to sort varchar data as int, there is one very nice function in MySQL. Problem I had to solve was to sort values as below in a human logical way. Values were similar to this (and I wanted it to be sorted like below):
1; 2; 2a; 3; 4; 5; 5a; 5b; 5c; 6; 7; 11; 14; 14a; 16;
The problem was that if I put this data to MySQL database as varchar and sort by this column, MySQL returned it this way:
1; 11; 14; 14a; 16; 2; 2a; 3; 4; 5; 5a; 5b; 5c; 6; 7;
My second thought was to put is as INTEGER values… It would be sorted as it should but then I would loose values like
2a; 5a; 5b; 5c; 14a;
as it would be converted by MySQL to integer values (2; 5; 14;).
Then I have thought it would be best to put this data to database as a varchar values and sort it as int! After some googling I have found great function that have helped me! The solution was CAST function. To sort it the way I wanted I have just added to my MySQL query this sorting method (pic_number is my field with value to sort):
ORDER BY CAST(`pic_number` AS SIGNED)
and for reverse order
ORDER BY CAST(`pic_number` AS SIGNED) DESC
And it worked like a charm!
Function is as simple to use as:
CAST(expr AS type)
Other possible conversion types you may need are:
- BINARY[(N)]
- CHAR[(N)]
- DATE
- DATETIME
- DECIMAL[(M[,D])]
- SIGNED [INTEGER]
- TIME
- UNSIGNED [INTEGER]
You may read more about this types in MySQL docs here. This function saved me a lot of coding in PHP. I hope it have helped you as much as it helped me!
My name is 
