Style a login form
The look is so important for a form. Unfortunately almost all forms look so boring and standard. Luckily it is pretty easy to style a login form with css. [Read the rest of this entry...]
Our Experience Changing to Wordpress
For a long time this site has been running on a custom written script. It has worked well, but one month ago we decided to migrate to wordpress. Here is our experience and tips for others thinking of making the change. [Read the rest of this entry...]
Optimize MySQL tables simple
Just like you need to defrag and check your file system, it’s important to do the same thing with MySQL tables. If you don’t, you might end up with slow and corrupted database tables. Follow this easy tutorial to set up an automatic optimization for your db.
Speed in MySQL is all about how fast the database can find the information you request. To help MySQL clean up and get all the best possibilities to gather your information, you can perform the command “Optimize” on your tables. [Read the rest of this entry...]
Sub queries
Mysql now offers sub queries/sub selects. They can help you write faster and shorter code. You don’t need to do that much programming in PHP, just let mysql do the work 
A new thing in MySql 5 is the possibility to use something called “sql subqueries”. It can be a very powerful new tool if you have not already tried it. [Read the rest of this entry...]
Basic sql optimization for MySql
It’s important to know how to write your queries fast. And there are also ways to do your queries faster Inside mysql, called Indexes. They help mysql do the work faster, but you need to tell how…
When you start getting large tables you can sometimes end up with slow running queries.
It’s important to optimize your queries and tables from the beginning, so you don’t end up with slow queries one year later when your tables have increased.
Badly created tables and queries is hard to find when you only have limited data in your tables. But there are tools to use to get a hint on if you will have problems later… [Read the rest of this entry...]
Schedule scripts to run
Schedule your daily work like checking logfiles, cleaning up old data in your web systems. Let automated scripts take care of this, learn how to use “Cronjob” for this.
We developed a site where the visitors can sell their used stuff. The add process is made up by three steps, and for some reason some people stop after step 1, and never finish the ad. To keep the database clean and quick, we decided to automaticly delete ads after some days if they are not complete. [Read the rest of this entry...]
Random image with javascript
Show a random image with the help of javascript. Only create the images and copy paste the script.
It’s very important that your web site is “alive” and it looks like something is happening.
One simple thing you can use to give your visitors something new is show them a random image every time they reload your page. There are number of times a function like this can be useful. [Read the rest of this entry...]
Change images with javascript
Change images on mouse over with javascript. Define the images and preload them.
It can sometimes be a nice effect to change images when the mouse is moved over.
For example if you have a file archive function and have directories, then the directory images can “open” when the mouse is moved over. [Read the rest of this entry...]
Show time spent on a site when they leave
Program a function that will show the visitor how long time they have spent on your site. When they leave, we use a javascript onUnload-function to alert the user with the number of seconds.
Javascript can be used for lots of things. I got this idea some minutes ago and thought that I write it down for more people to use. The reason I thought about this, is that I wondered how long time I spent reading an other tutorial [Read the rest of this entry...]
Fill an input field with the current date and time with javascript
Use javascript to fill an input field with the current date/time to save time for your self. A handy function with complete code and html to copy paste.
Save time for your self, and let javascript give you the current time.
We have a customer that enters lots of articles through a form, and one of the fields are a date/time when the auction is to start. To speed up their work I created a handy function that fills the input field with the current date/time. [Read the rest of this entry...]