Sahil Saggar

XSLT: for loop done through template

Oct 08, 2013

For loop template code:

<xsl:template name=”for.loop”>
<xsl:param name=”i” />
<xsl:param name=”count” />
<xsl:if test=”$i <= $count”>
<div><xsl:value-of select=”$i”/><br/></div>
</xsl:if>
<xsl:if test=”$i <= $count”>
<xsl:call-template name=”for.loop”>
<xsl:with-param name=”i”>
<xsl:value-of select=”$i + 1″/>
</xsl:with-param>
<xsl:with-param name=”count”>
<xsl:value-of select=”$count”/>
</xsl:with-param>
</xsl:call-template>
</xsl:if>
</xsl:template>

<xsl:template name=”for.loop”>

<xsl:param name=”i” />

<xsl:param name=”count” />

<xsl:if test=”$i <= $count”>

</xsl:if>

<xsl:if test=”$i <= $count”>

<xsl:call-template name=”for.loop”>

<xsl:with-param name=”i”>

<xsl:value-of select=”$i + 1″/>

</xsl:with-param>

<xsl:with-param name=”count”>

<xsl:value-of select=”$count”/>

</xsl:with-param>

</xsl:call-template>

</xsl:if>

</xsl:template>

To Call template:

<xsl:call-template name=”for.loop”>
<xsl:with-param name=”i”>1</xsl:with-param>
<xsl:with-param name=”count”>5</xsl:with-param>
</xsl:call-template>

<xsl:call-template name=”for.loop”>

<xsl:with-param name=”i”>1</xsl:with-param>

<xsl:with-param name=”count”>5</xsl:with-param>

</xsl:call-template>

Prepared statement with IN Query clause

Oct 08, 2013

$ids = array(2, 4, 6, 8);
$params = implode(",", array_fill(0, count($ids), "?"));
$sql = "UPDATE MyTable SET LastUpdated = GETDATE() WHERE id IN ($params)";
$stmt = $mysqli->prepare($sql);

call_user_func_array(array($stmt, 'bindparams'), $ids);
$stmt->execute();
$stmt->close();
echo "Updated record IDs: " . implode("," $ids) ."\n";

$ids = array(2, 4, 6, 8);

$params = implode(",", array_fill(0, count($ids), "?"));

$sql = "UPDATE MyTable SET LastUpdated = GETDATE() WHERE id IN ($params)";

$stmt = $mysqli->prepare($sql);

call_user_func_array(array($stmt, 'bindparams'), $ids);

$stmt->execute();

$stmt->close();

echo "Updated record IDs: " . implode("," $ids) ."\n";

MySQL’s SHOW CREATE TABLE for Oracle

Nov 07, 2012

Ever wondered, how to see create table code in Oracle?
as available in MySQL “show create table”

Here is how to do it

SQL> set pages 0
SQL> set long 999999
SQL> select dbms_metadata.get_ddl(‘TABLE’, ‘EMPLOYEES’, ‘EMP’) from dual;

MySQL: dropping all tables of a database with ease

Nov 07, 2012

So there is a need to delete all tables from database?

Possibilities:

Drop database and recreate, what if you don’t want to drop database, could be many reasons.
Fire drop table [tbl_name ...] command on MySQL prompt but then who is going to type all tables names.

Solution:
Run following command from command line

mysqldump -u [USERNAME] -p[PASSWORD] –add-drop-table –no-data [DATABASE] | grep ^DROP | mysql -u [USERNAME] -p[PASSWORD] -D [DATABASE]

Explained:

First one takes dump of all tables of database without any data along with drop table command.
Second part fetches lines starting with Drop from the output of first command.
Third command executes queries fetched by second command which are only drop table commands.

MySQL: Load timezones info in MySQL Server

Nov 07, 2012

Run following command on command line:

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

and to change timezone of the mysql server, add following line in the my.cnf file (/etc/my.cnf)

default_time_zone=Asia/Kolkata

or run following query on MySQL prompt (this will be valid for current session only)

SET time_zone = ‘Asia/Kolkata’;

Run PHP scripts in background on Linux

Nov 07, 2012

To run a PHP script in background from command line and keep it running even if you exit the terminal, use following syntax:

nohup php script.php < /dev/null &

Explained:
‘nohup‘ is a POSIX command to ignore the HUP (hangup) signal, enabling the command to keep running after the user who issues the command has logged out.

In Unix-like operating systems, ‘/dev/null‘ or the null device is a special file that discards all data written to it.

‘&’ is to send the process in the background and return the command line prompt.

Common MySQL Data Types

Nov 07, 2012

Text Data Types
CHAR( ) fixed from 0 to 255 characters long
VARCHAR( ) variable from 0 to 255 characters long
TINYTEXT maximum length of 255 characters
TEXT maximum length of 65535 characters
BLOB maximum length of 65535 characters
MEDIUMTEXT maximum length of 16777215 characters
MEDIUMBLOB maximum length of 16777215 characters
LONGTEXT maximum length of 4294967295 characters
LONGBLOB maximum length of 4294967295 characters

Numeric Data Types
TINYINT( ) -128 to 127 SIGNED or 0 to 255 UNSIGNED
SMALLINT( ) -32768 to 32767 SIGNED or 0 to 65535 UNSIGNED
MEDIUMINT( ) -8388608 to 8388607 SIGNED or 0 to 16777215 UNSIGNED
INT( ) -2147483648 to 2147483647 SIGNED or 0 to 4294967295 UNSIGNED
BIGINT( ) -9223372036854775808 to 9223372036854775807 SIGNED or 0 to 18446744073709551615 UNSIGNED
FLOAT small number with a floating decimal point
DOUBLE( , ) large number with a floating decimal point
DECIMAL( , ) DOUBLE stored as a string , allowing for a fixed decimal point

Date Data Types
DATE YYYY-MM-DD
DATETIME YYYY-MM-DD HH:MM:SS
TIMESTAMP YYYYMMDDHHMMSS
TIME HH:MM:SS

Javascript: Always define variable with ‘var’

Apr 09, 2010

So today, I found one more unseen behavior of Javascript (at least for me).

I wrote a very simple function in Javascript and forgot to add ‘var’ in front of variable definition. This function worked first time but for second time I got JS error saying the function does not exist. I was like what the hell, where did my function go? It just worked as expected for first time and suddenly browser is not able to find it.

It took me 20 minutes to find out the reason of my biggest mistake of tonight. Such a waste of precious 20 minutes at 3:00 AM

Lesson learned, always define variables in Javascript with ‘var’ keyword or else stay up till late night

Install Memcached on Windows 7

Apr 06, 2010

To install Memcached on Windows 7 you need administrative rights. Grab your copy of Memcached for Windows (I got it from here, so I will explain this one). Now follow the steps below:

Download and unzip Memcached binaries.
Press the Win key, type cmd, press Ctrl+Shift+Enter.
Select yes from elevation prompt.
A command window will open with administrative rights.
Go to Memcached folder (mine is c:\memcached\)
Type and run [ c:\>memcached -d install ], this will install Memcached as service.
Now start the service with [ c:\>memcached -d start ]
FIN

Now Memcached is installed and running.

Enjoy!!

Less know JavaScript operator ‘Delete’

Nov 21, 2009

One of the lesser known operators in JavaScript is the ‘delete’ operator. I came to know about while reading John Resig’s blog.

What does it do?
The delete operator deletes an object, an object’s property, or an element at a specified index in an array.

More about it at Mozilla Reference Docs.

Small Example:

</code><blockquote>var array = {<br /> "int": 42,<br /> "float": 12.5,<br /> "string": "hello world",<br /> "foo" : "bar"<br />}<br />for(var arr in array) {<br /> alert(arr + " : " + array[arr]);<br />}<br />delete array['string']; //Removes the 'string' key of the array<br /><br />for(var arr in array) {<br /> alert(arr + " : " + array[arr]); //The 'string' key & its value will be removed<br />}</blockquote><br />

</code><blockquote>var array = { "int": 42, "float": 12.5, "string": "hello world", "foo" : "bar" } for(var arr in array) { alert(arr + " : " + array[arr]); } delete array['string']; //Removes the 'string' key of the array for(var arr in array) { alert(arr + " : " + array[arr]); //The 'string' key & its value will be removed }</blockquote>

1 2 3 … 5 Next Scroll to top

Digging Opensource Deeper

XSLT: for loop done through template

Prepared statement with IN Query clause

MySQL’s SHOW CREATE TABLE for Oracle

MySQL: dropping all tables of a database with ease

MySQL: Load timezones info in MySQL Server

Run PHP scripts in background on Linux

Common MySQL Data Types

Javascript: Always define variable with ‘var’

Install Memcached on Windows 7

Less know JavaScript operator ‘Delete’

Search

Archives

Categories

Search

Archives

Tags

Categories