Tricks 4 Developer

Retrieve the ip address with php

2010-01-28T21:44:00.003+01:00

Sometimes is usefull to know the ip address of our website users, to do this we can use php.
To retrieve the ip address using php is necessary the specific environment variable.

The $_SERVER variable.

//this is the variable
$_SERVER['REMOTE_ADDR']

Inside this special variable there is the ip address of the user that open the page.

For example if we want print this variable this is the correct syntax:

//this print my ip address
echo $_SERVER['REMOTE_ADDR'];

Easy!!

Count the number of rows in a MySQL query, the COUNT function

2010-01-25T22:40:00.002+01:00

Many times it'snecessary to count the result lines of a query. There are two ways to do this, php (mysql_num_rows) and MySQL with the COUNT. In this post I show the MySQL COUNT function.

This is a normal SELECT queries:

SELECT * FROM table WHERE field='value'

The result of this query is compose by all rows that respect the WHERE clause (field='value'). But if I want to retrieve only the number of rows but not its value I can use the mydql count function. At the follow a example:

SELECT COUNT(*) FROM table WHERE  field='value'

Now the result is the number of rows that respect the WHERE clause. This function can also be applied on a table field in this way:

SELECT COUNT(field) FROM table WHERE  field='value'

In this way the query is faster the the other with the all value (*).

Close a window in one click

2010-01-23T18:48:00.013+01:00

With Javascript it's possible close a window in one click, to do this is necessary a link or a button and only one line of code!

The close function do the right thing:

window.close();

Now two examples that shows how use the close function.

<!--On a link-->
<a href="#" onclick="window.close();return false;">

<!--On a button--> 
<input type="button" name="Bottone" value="Chiudi" Onclick="window.close();">

Example:

Click this link to open a popup window

Click this link to close the popup

Digital Signage solutions and visual communication

2009-11-09T17:41:00.000+01:00

AVstore in cooperation with its partners (SpinetiX, LG, Keesquare and 3M) will hold a technical training day on digital signage and visual communication.

During the day will give the most innovative AVstore's products with live demonstrations and practical exercises

At the following link you can find all necessary information about the training day.