keevitaja

i have resposive webpage layout with masonry. when user resizes the browser below certain viewport width, i destroy masonry. but after user resized back, i can't reinitialize masonry. it just will not arrange the blocks as it should. any ideas how to fix this?

if you use active records, then adding the date should look something like this: $this->db->set('created', 'NOW()', FALSE)->insert('posts', $data); where table field created is mysql datetime. $data does not contain created at all.

i found a solution. i need to convert idn domain to ascii and then use filter_var found one converter from github: https://github.com/aluksidadi/IDN-Validator/blob/master/idna_convert.class.php

how to validate url with preg_match so it wouldn't fail with local specials characters like: http://höme.com/whatever -- please note the o with dots. it is actually valid url

i want to "auto select" some text so user could just hit crtl+c like in goo.gl the url is autoselected

is it possible to select some text with jquery. the result should be the same, when you hold down left mouse button and drag it to copy the selection?

rewrite doesn't work on windows machines...

there are 3 tables campaigns id int cp_contacts id int campaign_id int cp_friends id int cp_contact_id i need to retrieve all rows from campaigns and add how many contacts campaigns has total and how many friends total connected to campaigns thrugh contacts . i can get out the cp_contacts count with left join. can anyone help me?

Hi, i have table with following columns: id, parent_id is possible to count all siblings and print all siblings with out any help from php with recursion? is there a mysql statement for that... or can't i do it without php?

any luck with your balls?

the problem was colorbox module. if it's enabled, it breaks jquery. i had it configured to be disabled on front page. any ideas how to fix it?

hi, i have a strange problem. my jquery script is loaded on every node, but still it works only on the front page. when i use plain javascript in the same file, it works. any ideas?

i would like to change home to a different string and also display the active node at the end. how can i do that?

Exceptions added: http://usesql.keevitaja.com/usesql-version-1-1-download/ It was actually very good idea!

about injection. to avoid it, prepared statement must be used. i can't force escaping every value in insert_row() method.