How can increase the performance of MySQL
We can use LIMIT to stop MySql for further search in table after we have
received our required no. of records, also we can use LEFT JOIN or RIGHT
JOIN instead of full join in cases we have related data in two or more
How can we change the name of a column of a table?
MySQL query to rename table: RENAME TABLE tbl_name TO new_tbl_name
ALTER TABLE tableName CHANGE OldName newName.
When you want to show some part of a text displayed on an HTML page in
red font color? What different possibilities are there to do this? What
are the advantages/disadvantages of these methods?
There are 2 ways to show some part of a text in red:
1. Using HTML tag <font color="red">
2. Using HTML tag <span style="color: red">
When viewing an HTML page in a Browser, the Browser often keeps this
page in its cache. What can be possible advantages/disadvantages of page
caching? How can you prevent caching of a certain page (please give
several alternate solutions)?
When you use the metatag in the header section at the beginning of an
HTML Web page, the Web page may still be cached in the Temporary
Internet Files folder.
A page that Internet Explorer is browsing is not cached until half of
the 64 KB buffer is filled. Usually, metatags are inserted in the header section
of an HTML document, which appears at the beginning of the document. When the
HTML code is parsed, it is read from top to bottom. When the metatag is read,
Internet Explorer looks for the existence of the page in cache at that exact
moment. If it is there, it is removed. To properly prevent the Web page from
appearing in the cache, place another header section at the end of the HTML
What are the different ways to login to a remote server? Explain the
means, advantages and disadvantages?
There is at least 3 ways to logon to a remote server:
Use ssh or telnet if you concern with security
You can also use rlogin to logon to a remote server.
Please give a regular expression (preferably Perl/PREG style), which can
be used to identify the URL from within a HTML link tag.
Try this: /href="([^"]*)"/i
How can I use the COM components in php?
The COM class provides a framework to integrate (D)COM components into
your PHP scripts.
string COM::COM( string module_name [, string server_name [, int
codepage]]) - COM class constructor.
module_name: name or class-id of the requested component.
server_name: name of the DCOM server from which the component should be
fetched. If NULL, localhost is assumed. To allow DCOM com, allow_dcom
has to be set to TRUE in php.ini.
codepage - specifies the codepage that is used to convert php-strings to
unicode-strings and vice versa. Possible values are CP_ACP, CP_MACCP,
CP_OEMCP, CP_SYMBOL, CP_THREAD_ACP, CP_UTF7 and CP_UTF8.
$word->Visible = 1; //open an empty document
$word->Documents->Add(); //do some weird stuff
$word->Selection->TypeText("This is a testů");
$word->Documents->SaveAs("Useless test.doc"); //closing word
$word->Quit(); //free the object
$word = null;
How many ways we can give the output to a browser?
PHP, ASP, JSP, Servlet Function
Script Language output Function
Different Type of embedded Package to output to a browser
What is the default session time in php and how can I change it?
The default session time in php is until closing of browser
What changes I have to do in php.ini file for file uploading?
Make the following line uncomment like:
; Whether to allow HTTP file uploads.
file_uploads = On
; Temporary directory for HTTP uploaded files (will use system default
upload_tmp_dir = C:\apache2triad\temp
; Maximum allowed size for uploaded files.
upload_max_filesize = 2M
Page Numbers :