Perishable Press described a good way of preloading images with CSS - and only CSS.
Just use the CSS-background-property and hover-styles to preload images, this will work with all browser supporting the background-property.
Just look at this blog entry for a more detailed description
Determination of equal sounding strings in MySQL is difficult.
The function soundex() for example will not work with number-only strings
select soundex(”2008″)
will result in an empty string. And this both operations will result in the same soundex-strings:
select soundex(”Windows 2008″), soundex(”Windows 2003″)
both times it returns W532 for me - but in reality these two sounds doesn’t sound equal!
Also sounds like will return 1 (true) for these two example strings:
select “Windows 2008″ sounds like “Windows 2003″
So what I am searching for? I want to check if two strings are equal, independent from any spaces, so a sql-call should come up with these results:
Still searching for a solution (without checking the soundex word by word)…
If you have a table with columns like this:
Now you want to search by a concatenated string of manufacturer and model you can not do it like this:
select concat(manufacturer+’ ‘+model) as name, price from table where name = ‘Manu1 Testmodel’
You have to concat the columns within the where-area again. But MySQL (and MS-SQL also) supports derived tables, you can use a select as a “table” within the from and filter by the resulted columns, so the solution is:
select * from (select concat(manufacturer+’ ‘+model) as name, price from table) as tbl where name = ‘Manu1 Testmodel’
Just one important thing: Each derived table has to get an own alias.
Today I had to test if a string entered by the user is a octal number.
So first I remembered: PHP will detect octal numbers by a leading zero, if there is a non-octal digit within this number, all following digits will be removed from the converted number. So I tried:
$test = intval(’0′.$entered);
But the result wasn’t an octal - next idea: Use sprintf:
$test = sprintf(”%o”, ‘0′.$entered);
But with %o the number will be treated as decimal integer - so your number will be handled as decimal, that will result in a other octal number.
So finally I just test it now with a simple regular expression:
if(preg_match(’/[0-7]+/’, $entered)>0)
// is octal …
Seems to be the only way to detect octal numbers…
Some days ago i mentioned a problem with the IE7: When you open a new window with JavaScript (window.open) to just download a file from a server the Internet Explorer won’t download the file - under certain circumstances.
Problem example
So what happens? Just assume the following download.php-script on the server:
<?php
header(”Content-Type: application/pdf”);
header(”Content-Disposition: attachment; filename=AuthorityAlliances.pdf”);
header(”Cache-Control: must-revalidate, post-check=0, pre-check=0″, true);
header(”Expires: 0″);
readfile(”AuthorityAlliances.pdf”);
?>
Now put the following code within a html-file:
<html>
<head>
<script>
<!–
function go(jump){
window.open(jump);
}
–>
</script>
</head>
<body>
<form name=”Downloads”> ‘
<select name=”Downloads” size=”1″ onchange=”if (this.form.Downloads.options.selectedIndex != 0) {go(this.value);}”>
<option selected value=”">Select</option>
<option value=”http://yourserver/download.php”>PDF</option>
</select>
</form>
</body>
</html>
With the default Internet Explorer 7 installation selecting the entry in the combobox will work fine, if you test it locally - but if you upload these files to a server it will fail. The IE7 will open a new window for one second and close it again, without asking for a download folder nor starting the download.
You have to mention one thing: It will work with the onclick-event, but not with any other event like onchange, onmouseout, onmouseover, ….
But a onclick-event at a select-element is not really realistic, the onclick would occurr also if you just click the dropdown-button when nothing is selected. Also manipulating the download-script will not work: Integrating a sleep(2)-call before the download starts is no resolution.
Cause
If you change the JavaScript-part of the html-file to
function go(jump){
var x = window.open(”");
x.document.location = jump;
}
you will get a hint: The IE will show up a notification automatic downloading was disabled due to security reaons.
And thats the cause: In default the option called “Automatic prompting for file downloads” is disabled. While this is the case IE7 won’t allow such initiated downloads - and there seems to be now way to by-pass this restriction. Or does anyone know a solution?