Monthly Archives: May 2009

javascript: escape()

Posted on May 22, 2009 by dreamluverz

ShareProblem: Getting error on ajax when passing url with “&” on it. Solution: escape() Definition and Usage The escape() function encodes a string, so it can be read on all computers. Syntax escape(string) Parameter Description string Required. The string to … Continue reading →

More Galleries | Leave a comment

javascript: test()

Posted on May 22, 2009 by dreamluverz

ShareDefinition and Usage The test() method is used to search for a match of a regular expression in a string. This method returns true if a match is found, and false if not. Syntax RegExpObject.test(string) Parameter Description RegExpObject Required. The … Continue reading →

Posted in javascript | Tagged , , | Leave a comment

How to change charset of database

Posted on May 22, 2009 by dreamluverz

SharePROBLEM: How to modify or change the database’s charset SOLUTION; charset of dbase – to change this ALTER DATABASE

Posted in mysql | Tagged , , , , | Leave a comment

optimizing mysql database

Posted on May 22, 2009 by dreamluverz

ShareWhat are Indexes? Indexes are organized versions of specific columns in your tables. MySQL uses indexes to facilitate quick retrieval of records. With indexes, MySQL can jump directly to the records you want. Without any indexes, MySQL has to read … Continue reading →

Posted in mysql | Tagged , , | Leave a comment

UNIX_TIMESTAMP

Posted on May 22, 2009 by dreamluverz

ShareUNIX_TIMESTAMP(), UNIX_TIMESTAMP(date) If called with no argument, returns a Unix timestamp (seconds since ’1970-01-01 00:00:00′ UTC) as an unsigned integer. If UNIX_TIMESTAMP() is called with a date argument, it returns the value of the argument as seconds since ’1970-01-01 00:00:00′ … Continue reading →

Posted in mysql | Tagged , , , , | Leave a comment