itlivewire dev blogJust another web development blog…

Demonstrate responsive web design using jamus http://jamus.co.uk/demos/rwd-demonstrations/

We always encounter them on our JavaScript apps, the dynamic elements, most of the time they are in the form of new rows in the table <tr><td></td></tr> or a new list <li> from a <ul>.

So sometimes we need to capture an event to these newly loaded dynamic elements, and the solution in jquery is to use the live function.

Alternatively we can also use the covered by the parent technique, so if the parent of the dynamic element is loaded manually, we can just capture the event by this code.

$('ul').on('click','li',function(){
    alert('Has been clicked.. Do something next');
})

With the code on top we have eliminated the use of making this line

$('li').live('click',function(){
    alert('Has been clicked.. Do something next');
});

because the event for <li> has been covered by the parent <ul>.

To display the executed query using the codeigniter database class
insert the line of code below

echo $this->db->last_query();

$this->db->last_query(); //returns the last executed query
————————————————————————————————-
So if your code is like this

$this->db->select('*');
$this->db->from('sales');
$query = $this->db->get();
echo $this->db->last_query();

// Adding echo $this->db->last_query(); will output the query on the page like this

// SELECT * FROM sales;

mysqldump -u username -p Password database_name | gzip > database_backup.sql.gz

When we backup we want to add a date on the filename to know when the file was created

Try this line

tar -zcvf database_backup_$(date +%m-%d-%Y).tar.gz /DB/data

Example errors:

“Duplicate entry ’123711155′ for key ‘PRIMARY’” or “Duplicate entry ’14676163′ for key ’1′”

Most likely this happens for tables with more than 5 million records

THE FIX

The fix is to use repair table

REPAIR TABLE <TABLE_NAME>;

Note: Sometimes the duplicate error is also caused by your field type having the maximum value already, for example in tinyint which has the maximum value of 127 so it better to use bigint for your auto ids, if this is not the case you can try the solution above.

1. Go to your titanium project folder

then

2. Run this command

python titanium.py run --platform=android --android=/path/to/android-sdk

3. It’s Done

Note: Your titanium project folder should have the ff:

build build.log LICENSE manifest README Resources tiapp.xml

Most likely this is caused by a closed svn port on your svn server

Login to your svn server then do the following

1. Check first if svn is running
ps aux | grep svnserve

2. If it is not running restart the svn service
svnserve -d -r path_of_svn

Delete an android virtual device a.k.a AVD

Type this on the terminal

android delete avd -n name_of_device

Hide the android window title bar on Titanium mobile

var win_home = Titanium.UI.createWindow({navBarHidden:true});