CJK Characters Displaying Incorrectly

When I tried retrieving something with CJK characters from my database (e.g. こんにちは!), they displayed as ???? characters. But when I checked the actual database, the characters were written as in CJK characters (こんにちは!). I looked for a solution and I found out that I need to add this line below my database connection:

mysql_query("SET NAMES 'utf8'");

So, it would probably look something like this:

$dbconnect = mysql_connect('localhost', 'username', 'password');
if (!$dbconnect) die(mysql_error());
mysql_select_db('dbname');

mysql_query(”SET NAMES ‘utf8′”);

An ultra short summary explanation for this, according to that long article I read, MSQL databases tend to have a latin1 charset set as a default and it needs to be changed to utf8 to make it work.

Another thing is that in your database table’s Collation, you should find a utf8_general_ci instead of a latin1_swedish_ci one.

–

PS: I love you google!

Flash Overlaps CSS DIV

The flash thingy is overlapping my CSS div! TASKETE~!

Solution? In your flash object code, add these parameters:

<param name="quality" value="high" />
<param name="wmode" value="transparent" />

Random Output In a Query

You can randomize your output in a query using the ORDER BY rand()

Example:

SELECT DISTINCT a.f_user_id, c.f_username,
...
AND b.f_bid_transaction_id is not null
ORDER BY rand()
LIMIT 30

WHERE NOT EXISTS

In this godly world of MySQL, there’s exist this thing called WHERE NOT EXISTS who helped the stupid ‘ol me to select the things that weren’t there. Literally. This, all thanks to my guru of a colleague, Drew.

Example:
SELECT DISTINCT a.f_user_id, b.f_username, b.f_firstname,
b.f_lastname, b.f_added,
(SELECT f_raffle_number
FROM t_model_raffle
WHERE f_user_id = a.f_user_id
AND f_date >= '2007-12-10'
AND f_date <= '2007-12-21'
LIMIT 0,1)
AS f_raffle_number,
(SELECT f_date
FROM t_model_raffle
WHERE f_user_id = a.f_user_id limit 0,1)
AS f_date, b.f_birthdate, b.f_sex
FROM t_model_raffle a
INNER JOIN t_user_profile b
ON b.f_user_id = a.f_user_id
WHERE NOT EXISTS
(SELECT b.f_user_id
FROM t_buy_transaction c
WHERE a.f_user_id = c.f_user_id)

3 Tables in 1 Query

You can get data from 3 tables at the same time all in 1 query.

SELECT DISTINCT a.f_user_id, c.f_username, a.f_raffle_number
FROM t_model_raffle a
INNER JOIN t_buy_transaction b
ON b.f_user_id = a.f_user_id
INNER JOIN t_user_profile c
ON c.f_user_id = a.f_user_id
WHERE b.f_status = 'Completed';

Additional Array Field

You can add a new array field in the existing array result of the query using PHP.

Original Array Result:

[0] => Array (
[f_user_id] => 20250
[f_username] => yoshikihayashi
[f_firstname] => Yoshiki
[f_lastname] => Hayashi
[f_added] => 2006-08-25 16:39:00
[f_raffle_number] => 1543833569
[f_date] => 2007-12-18 13:00:59
[f_birthdate] => 1965-11-20
[f_sex] => M
)
[1] => Array (
[f_user_id] => 1026318
[f_username] => gacktcamui
[f_firstname] => Gackt
[f_lastname] => Camui
[f_added] => 2007-12-09 18:16:48
[f_raffle_number] => 1215771422
[f_date] => 2007-12-18 13:00:59
[f_birthdate] => 1968-07-04
[f_sex] => M
)

Procedure:

for($i=0;$i<count($pagevars['winnersbuy']);$i++):
$bday = $pageVars['winnersBuy'][$i]['f_birthdate'];
$age = $this->$birthday("$bday");
$pageVars['winnersBuy'][$i]['f_age'] = "$age";
endfor;

Output:

[0] => Array (
[f_user_id] => 20250
[f_username] => yoshikihayashi
[f_firstname] => Yoshiki
[f_lastname] => Hayashi
[f_added] => 2006-08-25 16:39:00
[f_raffle_number] => 1543833569
[f_date] => 2007-12-18 13:00:59
[f_birthdate] => 1965-11-20
[f_sex] => M
[f_age] => 42
)
[1] => Array (
[f_user_id] => 1026318
[f_username] => gacktcamui
[f_firstname] => Gackt
[f_lastname] => Camui
[f_added] => 2007-12-09 18:16:48
[f_raffle_number] => 1215771422
[f_date] => 2007-12-18 13:00:59
[f_birthdate] => 1968-07-04
[f_sex] => M
[f_age] => 35
)

Opacity

It works on all browsers except IE6. Because IE sucks!

filter:alpha(opacity=25);
-moz-opacity:.25;
opacity:.25;

–
From my codix.

Links In and/or Out of Site

Due to power of CSS3 (yes, no IE6 again, because IE sucks), you can have an specific style for all links that belonged to a specific domain of your choice.

a[href*="http"] {
[code here]
}

Example:

a[href*="www.beyondeternal.com"] {
[code here]
}

--
From my codix.

Truncates Words

This code truncates the sentence into specified number of words.

//-- truncates entries
$entry = "This is where the long entry is placed.";
$words = split(" ",$entry);
$excerpt = join(" ",array_slice($words,0,50));
echo $excerpt;
echo " [more]";

–
From my codix.

Scrollbar (All browser)

Want a vertical scrollbar? Use this:

overflow: -moz-scrollbars-vertical;
overflow-y: scroll;

–
From my codix.