There are a lot of tips 'out there' on how to add a table row to the end of a table, but I found an elegant way of duplicating a table row in the middle of a table...

function addRow(button)
{
btn_row = button.parentNode.parentNode;
x=btn_row.previousSibling;
while (x.nodeType!=1){
x=x.previousSibling;
}
row = x.cloneNode(true);
btn_row.parentNode.insertBefore(row,btn_row);
}
Then you can trigger it from a table cell using:

<input type="button" onclick="addRow(this);" value="+" />


Note the while() loop filters out white space nodes in Firefox (naughty Firefox).



  |  [ 0 trackbacks ]   |  permalink  |  related link  |   ( 2.9 / 55 )

---

I wanted to use url_for() in a controller for a search and replace operation. It turns out the URL helper is a wrapper for a controller function!

sfContext::getInstance()->getController()->genUrl("click here","@route?id_id=".$id);

too easy!
  |  [ 0 trackbacks ]   |  permalink  |  related link  |   ( 3 / 56 )

---

Have a required radio button and want to ensure one option is checked? Here's a one-liner for your troubles...

checked = $$('input:checked[type="radio"][name="reward"]').pluck('value').length

Assuming your radio buttons have the name="reward" attribute you can now do the following:

if (!checked ){
alert('select something!');
}

That's it!

PS: This was working great for me the other day but on another page I am getting an error parsing "input:checked". Also it appears that no version of IE (including 8) supports the checked CSS selector. So here's my cross browser multi-line solution:

checked = false;
try{
radios = $$('input');
radios.each(function(s,i){
if (s.checked){
checked = true;
}
});
}catch(e){}
  |  [ 0 trackbacks ]   |  permalink  |  related link  |   ( 3 / 66 )

---

This took weeks to troubleshoot so maybe I can save you some time by relating the experience...

I have an application that reads files from a FTP drop folder and moves them to a queue folder. If the move is successful, a queue record is put into the database.

Now, you would have thought that is_file() would have been enough to detect if a file was ready (ie: not still being uploaded by a user). As it happens, the FTP server is 'clever' enough to give you read access during the upload, allowing you to see its progress. And so my queue script was copying and unlinking files that were incomplete.

So, I tried is_readable() - same thing.
Then I added is_writeable() - you'd think this would do it. Surely files were locked during an upload? Nope, same problem.
Then I tried doing a filesize() followed by a sleep then another filesize() and compared them. Didn't work. Then I added a filesize() > 0 check. No joy. I also made sure the stat data wasn't being cached by calling clearstatcache() each time. No difference.

Finally, the only thing that seemed to work (and yes I am still uncertain the problem has completely gone away!) is comparing a stat() on the file with a sleep() in between.

Anyway, here's the final moveFile function that appears to be working for now...

protected function moveFile($from, $to){
clearstatcache();
$this->write2log("Called moveFile ".$from. " > ".$to);
$this->write2log("File ".basename($from). " is " . intval(filesize($from)/(1024*1024/100))/100 ."MB");

if (is_file($from)){
if (is_readable($from)){
if (is_writable($from)){
//check for filesize change
$size = filesize($from);
$stat = stat($from);
sleep(5);
clearstatcache();
if ($size == filesize($from) && $size > 0 && $stat == stat($from)){
if (copy($from, $to)){
if (unlink($from)){
$this->write2log("Successfully moved ".$from. " > ".$to);
return true;
}
$this->write2log("FAILED to unlink ".$from);
}
$this->write2log("FAILED to copy ".$from. " > ".$to);
}
$this->write2log("UPLOAD IN PROGRESS ".$from);
}
$this->write2log("NOT WRITABLE ".$from);
}
$this->write2log("NOT READABLE ".$from);
}
$this->write2log("NOT A FILE ".$from);
return false;
}
  |  [ 0 trackbacks ]   |  permalink  |  related link  |   ( 3 / 56 )

---

Nice little app for building MySQL databases under windows...
  |  [ 0 trackbacks ]   |  permalink  |  related link  |   ( 2.8 / 79 )

---

If you reverse engineer your Symfony schema.yml from a database and you use the symfony plugins like sfGuard, chances are you've come across this error:

Duplicate table found: propel

The reason why this occurs is that your schema.yml will include the other plugin tables - which are now duplicated from the plugin schema.yml

The quick solution is to open your project database.yml and remove the plugin table definitions after running propel-build-schema and before running propel-build-model

If you make a lot of database changes you might want to either empty/remove the plugin schema.yml file (it's only needed for the initial installation anyway) or write a wrapper class for propel... :)
  |  [ 0 trackbacks ]   |  permalink  |  related link  |   ( 3 / 60 )

---

Ever wanted to load a PDF file inline? Maybe in a lightbox window? Well now you can. Michael J.I. Jackson's "thrilling" shadowbox loads all your media files, HTML pages etc with lovely effects sourced from prototype, scriptaculous, yahoo, mootools or your other AJAX library of choice. It does it using adapters and it is the slickest GUI enhancer I've seen yet.

But lo and behold it doesn't support acrobat PDF documents!
Well, it does if you make one very tiny change to the source code:

Add " pdf" to the iframe array like so...

iframe:["pdf","asp","aspx","cgi","cfm","htm","html","pl",
"php","php3","php4","php5","phtml","rb","rhtml","shtml","txt",
"vbs"]

Now it loads PDF files just like your HTML pages in an IFRAME with all the benefits of the lightbox transitions, loading animation, navigation, captions etc
  |  [ 0 trackbacks ]   |  permalink  |  related link  |   ( 3 / 64 )

---

It's a typical scenario - I have a search module that returns a bunch of objects that have related objects (and some of these have related objects as well).

Ordinarily, you'd use a doSelectJoinAll and let propel magically hydrate all your results - but that only works for parent objects, not child objects.

So, rather than looping over each object and running separate queries to get each objects child objects, I wanted to do the equivalent of a doSelectJoinAll() but fully hydrate all the results with a minimum number of queries. Here's how I did it...

Query 1 retrieves all the IDs of the matching records.

Each of these search results has a location
Each location has a category

Query 2 gets all the locations using Criteria::IN on all result IDs.
Query 3 gets all the categories using Criteria::IN on all location IDs.

Then I loop over the results of queries 2 and 3 and build the collections of results like so:

foreach ($results as $r) { $rs[$r->getResultId()]->addCollItem("ResultLocations",$r->getLocation());
}

This nifty bit of code calls the following class function:

function addCollItem($type,$item)
{
$init = "init".$type;
$property = "coll".$type;
if (!method_exists($this,$init)){
$this->$property = array();
}else{
$this->$init();
}

$class_property = $this->$property;
$class_property[] = $item;
}

Whammo! You get to feed related objects into the master object's protected collections :)
  |  [ 0 trackbacks ]   |  permalink  |  related link  |   ( 3 / 55 )

---

I thought I'd seen it all until today. JavaScript is so "intelligent" that if you try to ParseInt() on "08" you get 0. Why? Because it thinks you're speaking in octal (base 8 numbers) instead of decimal (base 10).

The solution is to either use parseFloat() or to force the use of decimal by passing 10 as the second parameter to parseInt().
  |  [ 0 trackbacks ]   |  permalink  |  related link  |   ( 3 / 64 )

---

Took me a day to work out why my fread() file transfers were failing - at almost exactly half way. It got me thinking - perhaps the output was being compressed. I turned off mod_deflate. Same problem. Then I started looking at the PHP buffer because I was doing something like this:

while(!feof($handle)){
set_time_limit(0);
print(fread($handle,1024*8));
ob_flush();
flush();
}

Then I checked the output handler and realised there was some multibyte encoding taking place, which was the key. This has to be turned off for binary data like so:

mb_http_output("pass");

Seems strange noone has mentioned this on the PHP site under fread() - so I did.

  |  [ 0 trackbacks ]   |  permalink  |  related link  |   ( 2.9 / 63 )

---

Back Next

BugFeatures is FREE! - Page Generated in 0.1141 seconds