Tag Archives: php

November 20, 2012
IT

Replace text in mysql table

Sometimes you need to replace some text in your Mysql database. Whatever it is (a user ID or a user name), this is the SQL query you need to run:

UPDATE `table` SET `field` = REPLACE(`field`, ‘string’, ‘anothervalue’)

September 2, 2012
IT

Update Mysql table

This will update data in a MySQL table whether is empty or not.

UPDATE artists SET city = ‘Los Angeles’ WHERE city=’Sydney’

In this case Sydney will be replaced by Los Angeles.

August 24, 2012
IT

Format 1000 to 1K and trim result to one decimal using PHP

In web design sometimes it’s neccesary to keep things short, so large numbers have to be trimmed for display. The following simple code will format any number > to 1000 to its 1K version and will limit decimals to 2 digits.

$shares = $this->page->shares;
$shares2 = $shares / 1000;
if ($shares < 1000) {
echo ‘$shares’;
}
else {
echo number_format($shares2, 2);
echo ‘k’;
}

With this simple code, a number preserves its format if it’s lower than 1000 (i.e.…

August 22, 2012
IT

Showing conditional divs using php and if/else statements

If you want to show some divs instead of others on a website IF some condition is met you can use the following piece of code:

php if ($artist_id == “1980”) { ?>

Some data

php } else { ?>

Some other data

<? } ?>

The data and the whole layout can be different, as in this case, but it doesn’t have to.…