Bigquery.com

Aloe-Vera joomla template

2010-01-09T16:06:00.005+07:00

Aloe-Vera 1.0
Demo of joomla template 1.5
Download joomla template

Blueblog joomla template

2010-01-09T16:02:00.005+07:00

A blue template perfect for personal blogs and portals
Demo joomla template 1.5
Download joomla template

PHP Encode email for protected spam program suck your email

2008-09-28T00:00:00.001+07:00

Current data is substantial. Those with more than would be in the business or marketing programs, so it is waiting to absorb any email from the web site or forum posts from various sites to be used in a business context. Or even out of our e-mail goes on sale. This will become a spam mail coming into our mail as many Create a nuisance to the owners e-mail. Another method of protection is. Email encryption is broken.

Better get started. I will write in the form of functions PHP. So that you can apply simple.
====================================
<?php
function mailEncode($mailText){
$email = '';
for($i=0; $i$email .= '&#'.ord(substr($mailText,$i,1));
}
return $email;
}

echo mailEncode("bigquery@gmail.com");
?>
====================================

When view source will see bigquery@gmail.com

Encode the e-mail function may be prevented to a certain extent only.

SQL INSERT .. SELECT sql command copy data from table to table

2008-09-27T23:58:00.002+07:00

This SQL command may not use frequently. But I think should be have useful for some people, I'm talking about "INSERT INTO ... SELECT", The SQL Command for insert data to table from another data table

The Syntax of this SQL command is:
INSERT INTO "table1" ("column1", "column2")
SELECT "column3", "column4"
FROM "table2"

THE EXAMPLE
If you want to puts data from "Orders" table which is order purchased in 2007 to keep the other one, can create query like follow this:

INSERT INTO Orders2007(order_id, date_purchased, amount)
SELECT order_id, date_purchased, amount
FROM Orders
WHERE Year(date_purchased) = 2007;

That's it will get data which is order purchased in 2007 to "Order2007" table.
This SQL statement is like a copy to some records into another table.

Flash content displays on top of all DHTML layers

2008-02-11T22:36:00.000+07:00

Issue
A Flash movie in a layer on a DHTML page containing several layers may display above all the layers, regardless of the stacking order ("z-index") of those layers.

Reason
By default, browsers place embedded plug-in content, such as a Flash movie or Java applet, on the topmost layer. In older browsers, attempts to place a DHTML layer on top of a Flash layer would fail. Newer browsers add the ability to layer Flash content with DHTML content and in some cases the ability to use transparent backgrounds in the Flash content (see below).

Solution
Use the WMODE parameter to allow layering of Flash content with DHTML layers. The WMODE parameter can be 'window' (default), 'opaque', or 'transparent'. Using a WMODE value of 'opaque' or 'transparent' will prevent a Flash movie from playing in the topmost layer and allow you to adjust the layering of the movie within other layers of the HTML document.
For details on creating a Flash movie with a transparent background and more information on using the WMODE parameter refer to How to make a Flash movie with a transparent background (TechNote 14201).

Note: The WMODE parameter is supported only on some browser/Flash Player version combinations. If the WMODE parameter is not supported, the Flash movie will always display on top. Refer to TechNote 14201 for details.

RegularExpressionValidator decimal

2008-01-22T10:55:00.000+07:00

User Control RegularExpressionValidator with number and decimal regex
Try this regex -
\d{1,}\.?\d{0,}

put to e.g. ValidationExpression="\d{1,}\.?\d{0,}"
==========================================

<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="txtWeight"

ErrorMessage="Format(X.XX)" ValidationExpression="\d{1,}\.?\d{0,}"></asp:RegularExpressionValidator>

==========================================

Error in my_thread_global_end(): 1 threads didn't exit

2008-01-21T22:41:00.000+07:00

Copy libmysql.dll for http://www.php.net/releases/ select Version 5.2.1 ...Select Windows binary Download and Extract copy libmysql.dll to PHP folder

PHP Warning: PHP Startup: Unable to load dynamic library 'C:\PHP\ext\php_mysqli.dll' - Access is denied

2008-01-21T22:34:00.000+07:00

Hi. I've spent the last 6 hours researching this on the Internet and can't find a solution so I'm hoping someone might be able to help.

Anytime I use new mysqli() or mysqli_connect() I receive this error on my browser:

---------------
PHP Warning: PHP Startup: Unable to load dynamic library 'C:\PHP\ext\php_mysql.dll' - Access is denied. in Unknown on line 0 PHP Warning: PHP Startup:
Unable to load dynamic library 'C:\PHP\ext\php_mysqli.dll' - Access is denied. in Unknown on line 0
---------------

I have PHP 5.1.4 installed on WIN along with MySQL 5.0.22 running on IIS 5.1 (XP Pro). I have correctly updated the php.ini file with these modifications:

extension_dir = C:\PHP\ext
extension=php_mysql.dll (without semi-colon)
extension=php_mysqli.dll (without semi-colon)

I have placed the updated libmysql.dll file that I have downloaded from http://dev.mysql.com/downloads/connector/php/ in the C:\PHP, C:\WINDOWS and C:\WINDOWS\system 32, have restarted everytime and still cannot correct this error.

Does anyone have more information to assist me? If you need any more information from me to help diagnose, I will be glad to provide.

source: http://forums.mysql.com/read.php?11,102233,102233

Rotate text with CSS

2008-01-21T22:28:00.000+07:00

if you wish to rotate text, and if your 'text' is not Chinese/Japanese/Korean ideograph character, then you can simply use a CSS style, e.g. (below example I didn't test because I use Linux)
code:

This text should be rotated vertically

details:http://msdn.microsoft.com/workshop/author/dhtml/reference/properties/writingmode.asp

This is an IE feature, mozilla/opera does not support it (and does not plan to). That's why my above example is not tested. This happens to be the *only* feature that I prefer IE over firefox/mozilla.

source : http://www.ozoneasylum.com/11093