Jeevan's Archive

MySql Replace word by SQL Query

This item was filled under [ Tips ]

Do you know that You CAN replace MySql field values by SQL query? it’s pretty simple. Use update Command with “replace” to set value to field:

UPDATE table_name SET table_field = REPLACE(table_field,’replace_string’,'with_this_string’);

Not only this, you can do whole lot of other things without having to write any programes (php, asp etc) to do some trick with [...]

Continue reading...

Tagged with: [ , , , , ]

Batch Renaming Files on Mac OS X

This item was filled under [ Mac OS X ]

I’ve spent hours looking for an easier way to batch renames files with a sequential number at the end. In Microsoft Windows Operating systems, simply select all files and rename one; that will rename rest of the selected files with Name given and add numbers at the end of file name.
There are few Applications available [...]

Continue reading...

PHP : get Request protocol Http or HTTPS

This item was filled under [ PHP ]

How to get Requested protocol Http or HTTPS in PHP?
This function will return True if HTTPS when called…
is_https()
{
return strtolower(substr($_SERVER["SERVER_PROTOCOL"],0,5))==’https’? true : false;
}
is_https()
{
return strtolower(substr($_SERVER["SERVER_PROTOCOL"],0,5))==’https’? true : false;
}

Continue reading...

Tagged with: [ , , ]

Split & Concat Snow Leopard Error : (-2753) The variable thePanel is not defined

This item was filled under [ Mac OS X ]

* New Version of Split & Contact is Now Available for Mac OS X 10.6 (Snow Leopard) http://www.freebyte.com/hjsplit/#mac
Issue: After updating My Leopard (OS X 10.5) to Snow Leopard (OS X 10.6), Split & Contact started to show this error message:

It seems there won’t be an update soon to Fix this problem from Developers… It’s much [...]

Continue reading...

ScreenGrabber for Mac

This item was filled under [ Mac OS X ]

Like many others available in Windows, this is the first one working perfectly (Almost) to capture videos screen shots and create one large image for Preview… and its FREE.
ScreenGrabber 2.0 is a Mac OS X application for grabbing screen shots at even timeintervals from a movie. Very useful for creating previews, and thumbnails.
Download it From: [...]

Continue reading...