Explore topic-wise InterviewSolutions in .

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.

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.

The generic syntax for GRANT is as following
GRANT [RIGHTS] on [database] TO [username@hostname] IDENTIFIED BY [PASSWORD]

Now rights can be:
a) ALL privilages
B) Combination of CREATE, DROP, SELECT, INSERT, UPDATE and DELETE etc.

We can grant rights on all databse by usingh *.* or some specific database by database.* or a specific table by database.table_name.

The generic syntax for GRANT is as following
GRANT [rights] on [database] TO [username@hostname] IDENTIFIED BY [password]

Now rights can be:
a) ALL privilages
b) Combination of CREATE, DROP, SELECT, INSERT, UPDATE and DELETE etc.

We can grant rights on all databse by usingh *.* or some specific database by database.* or a specific table by database.table_name.

TRY this: /HREF="([^"]*)"/i.

Try this: /href="([^"]*)"/i.

HTML output
PHP, ASP, JSP, Servlet FUNCTION
Script Language output Function
Different TYPE of embedded PACKAGE to output to a browser.

HTML output
PHP, ASP, JSP, Servlet Function
Script Language output Function
Different Type of embedded Package to output to a browser.

SELECT CURDATE();
SELECT CURRENT_DATE();
SELECT CURTIME();
SELECT CURRENT_TIME();

SELECT CURDATE();
SELECT CURRENT_DATE();
SELECT CURTIME();
SELECT CURRENT_TIME();

The DEFAULT SESSION TIME in php is until CLOSING of BROWSER.

The default session time in php is until closing of browser.

Here is how can you find the NUMBER of rows in a RESULT set in PHP:

$result = mysql_query($any_valid_sql, $database_link);
$num_rows = mysql_num_rows($result);
ECHO "$num_rows rows found";

Here is how can you find the number of rows in a result set in PHP:

$result = mysql_query($any_valid_sql, $database_link);
$num_rows = mysql_num_rows($result);
echo "$num_rows rows found";

The major DIFFERENCE is the length of the HASH generated. CRC32 is, EVIDENTLY, 32 bits, while SHA1() returns a 128 bit value, and md5() returns a 160 bit value. This is important when avoiding collisions.

The major difference is the length of the hash generated. CRC32 is, evidently, 32 bits, while sha1() returns a 128 bit value, and md5() returns a 160 bit value. This is important when avoiding collisions.

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 if not
; specified).
upload_tmp_dir = C:\apache2triad\temp
; Maximum allowed SIZE for uploaded files.
upload_max_filesize = 2M

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 if not
; specified).
upload_tmp_dir = C:\apache2triad\temp
; Maximum allowed size for uploaded files.
upload_max_filesize = 2M

USE this for MYSQL
SELECT COUNT(*) FROM table_name;

Use this for MySQL
SELECT COUNT(*) FROM table_name;

DESCRIBE table_name;

DESCRIBE table_name;

MySQL SET FUNCTION can TAKE zero or more VALUES, but at the maximum it can take 64 values.

MySQL SET function can take zero or more values, but at the maximum it can take 64 values.

DATABASE NAME: 64 CHARACTERS
Table name: 64 characters
COLUMN name: 64 characters

Database name: 64 characters
Table name: 64 characters
Column name: 64 characters

At least 3 ways:
1. Put the VARIABLE into session in the first PAGE, and GET it back from session in the next page.
2. Put the variable into COOKIE in the first page, and get it back from the cookie in the next page.
3. Put the variable into a hidden form field, and get it back from the form in the next page.

At least 3 ways:
1. Put the variable into session in the first page, and get it back from session in the next page.
2. Put the variable into cookie in the first page, and get it back from the cookie in the next page.
3. Put the variable into a hidden form field, and get it back from the form in the next page.

Here are the POSSIBLE ways of php page redirection.

1. Using Java script:
'; ECHO 'window.location.href="'.$filename.'";'; echo ''; echo ''; echo ''; echo ''; } }
REDIRECT

2. Using php FUNCTION: HEADER

Here are the possible ways of php page redirection.

1. Using Java script:
'; echo 'window.location.href="'.$filename.'";'; echo ''; echo ''; echo ''; echo ''; } }
redirect

2. Using php function: header

2 WAYS:

sizeof($array) - This function is an alias of count().
count($urarray) - This function returns the number of elements in an array. Interestingly if you just pass a simple VAR INSTEAD of an array, count() will return 1.

2 ways:

sizeof($array) - This function is an alias of count().
count($urarray) - This function returns the number of elements in an array. Interestingly if you just pass a simple var instead of an array, count() will return 1.

SORTING functions in PHP:
asort()
ARSORT()
ksort()
krsort()
uksort()
SORT()
natsort()
rsort()

Sorting functions in PHP:
asort()
arsort()
ksort()
krsort()
uksort()
sort()
natsort()
rsort()

void header ( STRING string [, bool REPLACE [, int http_response_code]]).

void header ( string string [, bool replace [, int http_response_code]]).

$BOUNDARY = '--' . MD5( uniqid ( RAND() ) );
$HEADERS = "From: \"Me\"\N";
$headers .= "MIME-Version: 1.0\n";
$headers .= "Content-Type: multipart/mixed; boundary=\"$boundary\"";

$boundary = '--' . md5( uniqid ( rand() ) );
$headers = "From: \"Me\"\n";
$headers .= "MIME-Version: 1.0\n";
$headers .= "Content-Type: multipart/mixed; boundary=\"$boundary\"";

session_unregister() - UNREGISTER a GLOBAL VARIABLE from the current session.

session_unset() - FREE all session variables.

session_unregister() - Unregister a global variable from the current session.

session_unset() - Free all session variables.

Crypto usage in PHP is simple, but that doesn’t mean it’s free. First off, depending on the data that you’re ENCRYPTING, you might have reasons to store a 32-bit value in the database instead of the 160-bit value to SAVE on space. Second, the more secure the crypto is, the longer is the COMPUTATION time to deliver the hash value. A high volume site might be significantly slowed down, if FREQUENT md5() generation is required.

Crypto usage in PHP is simple, but that doesn’t mean it’s free. First off, depending on the data that you’re encrypting, you might have reasons to store a 32-bit value in the database instead of the 160-bit value to save on space. Second, the more secure the crypto is, the longer is the computation time to deliver the hash value. A high volume site might be significantly slowed down, if frequent md5() generation is required.

REPLY-to : Reply-to is where to delivery the reply of the mail.

RETURN-PATH : Return path is when there is a mail delivery FAILURE OCCURS then where to delivery the failure notification.

Reply-to : Reply-to is where to delivery the reply of the mail.

Return-path : Return path is when there is a mail delivery failure occurs then where to delivery the failure notification.

move_uploaded_file ( string FILENAME, string destination)

This function checks to ensure that the file designated by filename is a valid upload file (MEANING that it was uploaded via PHP's HTTP POST upload mechanism). If the file is valid, it will be moved to the filename given by destination.

If filename is not a valid upload file, then no action will occur, and move_uploaded_file() will RETURN FALSE.

If filename is a valid upload file, but cannot be moved for some REASON, no action will occur, and move_uploaded_file() will return FALSE. Additionally, a warning will be issued.

move_uploaded_file ( string filename, string destination)

This function checks to ensure that the file designated by filename is a valid upload file (meaning that it was uploaded via PHP's HTTP POST upload mechanism). If the file is valid, it will be moved to the filename given by destination.

If filename is not a valid upload file, then no action will occur, and move_uploaded_file() will return FALSE.

If filename is a valid upload file, but cannot be moved for some reason, no action will occur, and move_uploaded_file() will return FALSE. Additionally, a warning will be issued.

htmlspecialchars only takes care of <, >, SINGLE quote ‘, double quote " and ampersand.
HTMLENTITIES translates all occurrences of character sequences that have DIFFERENT meaning in HTML.

htmlspecialchars only takes care of <, >, single quote ‘, double quote " and ampersand.
htmlentities translates all occurrences of character sequences that have different meaning in HTML.

Expression PRECEDING the ? is evaluated, if it’s TRUE, then the expression preceding the : is EXECUTED, OTHERWISE, the expression following : is executed.

Expression preceding the ? is evaluated, if it’s true, then the expression preceding the : is executed, otherwise, the expression following : is executed.

It’s how they HANDLE failures. If the file is not found by require(), it will cause a FATAL ERROR and halt the execution of the script. If the file is not found by include(), a WARNING will be issued, but execution will CONTINUE.

It’s how they handle failures. If the file is not found by require(), it will cause a fatal error and halt the execution of the script. If the file is not found by include(), a warning will be issued, but execution will continue.

Yes.

Yes.

session_id() RETURNS the SESSION ID for the CURRENT session.

session_id() returns the session id for the current session.

As individual objects so SINGLE RECORD or as a SET or arrays.

As individual objects so single record or as a set or arrays.

We can CREATE MYSQL DATABASE with the USE of mysql_create_db($DATABASENAME) to create a database.

We can create MySQL database with the use of mysql_create_db($databaseName) to create a database.

We can USE a simple JavaScript code linked to an event trigger of any form FIELD. In the JavaScript code, we can call the document.form.submit() FUNCTION to submit the form. For EXAMPLE: <input type=button VALUE="Save" onClick="document.form.submit()">.

We can use a simple JavaScript code linked to an event trigger of any form field. In the JavaScript code, we can call the document.form.submit() function to submit the form. For example: <input type=button value="Save" onClick="document.form.submit()">.

The FIRST ONE is OCTAL 23, the second is hex 23.

The first one is octal 23, the second is hex 23.

session_register($session_var);
$_SESSION['var'] = 'value';

session_register($session_var);
$_SESSION['var'] = 'value';

Any time you have an array with more than ONE dimension, complex PARSING syntax is required. print "CONTENTS: {$arr[1][2]}" WOULD’ve worked.

Any time you have an array with more than one dimension, complex parsing syntax is required. print "Contents: {$arr[1][2]}" would’ve worked.

Since the DATA inside the single-quoted string is not PARSED for variable substitution, it’s always a BETTER idea speed-wise to initialize a string with single QUOTES, unless you specifically NEED variable substitution.

Since the data inside the single-quoted string is not parsed for variable substitution, it’s always a better idea speed-wise to initialize a string with single quotes, unless you specifically need variable substitution.

If you don't want to use the Submit BUTTON to submit a FORM, you can use normal hyper LINKS to submit a form. But you need to use some JAVASCRIPT code in the URL of the link. For example:
&LT;a href="javascript: document.myform.submit();">Submit Me</a>.

If you don't want to use the Submit button to submit a form, you can use normal hyper links to submit a form. But you need to use some JavaScript code in the URL of the link. For example:
<a href="javascript: document.myform.submit();">Submit Me</a>.

__sleep RETURNS the array of all the variables than need to be saved, while __wakeup RETRIEVES them.

__sleep returns the array of all the variables than need to be saved, while __wakeup retrieves them.

Here are three basic TYPES of runtime errors in PHP:

1. Notices: These are trivial, non-critical errors that PHP encounters while EXECUTING a script - for example, accessing a variable that has not yet been DEFINED. By default, such errors are not displayed to the user at all - although you can change this default behavior.
2. Warnings: These are more serious errors - for example, attempting to include() a file which does not exist. By default, these errors are displayed to the user, but they do not result in script termination.
3. Fatal errors: These are critical errors - for example, instantiating an object of a NONEXISTENT class, or calling a non-existent function. These errors cause the immediate termination of the script, and PHP's default behavior is to display them to the user when they take place.

Internally, these variations are represented by TWELVE different error types.

Here are three basic types of runtime errors in PHP:

Internally, these variations are represented by twelve different error types.

PARENT::CONSTRUCTOR($VALUE).

parent::constructor($value).

When you want to send short or small data, not containing ASCII characters, then you can use GET” Method. But for LONG data sending, SAY more then 100 character you can use POST method.

Once most important difference is when you are sending the form with GET method. You can see the output which you are sending in the address bar. Whereas if you send the form with POST” method then user can not see that information.

When you want to send short or small data, not containing ASCII characters, then you can use GET” Method. But for long data sending, say more then 100 character you can use POST method.

Once most important difference is when you are sending the form with GET method. You can see the output which you are sending in the address bar. Whereas if you send the form with POST” method then user can not see that information.

DROP TABLE table_name - This will DELETE the table and its DATA.

TRUNCATE TABLE table_name - This will delete the data of the table, but not the table DEFINITION.

DROP TABLE table_name - This will delete the table and its data.

TRUNCATE TABLE table_name - This will delete the data of the table, but not the table definition.

EVERYTHING is PASSED by VALUE.

Everything is passed by value.

If you want to include SPECIAL characters like spaces in the query string, you need to protect them by applying the urlencode() translation function. The SCRIPT below shows how to use urlencode():

<?php
print("<html>");
print("<p>Please click the LINKS below"
." to submit comments about FYICenter.com:</p>");
$comment = 'I want to SAY: "It\'s a good site! :->"';
$comment = urlencode($comment);
print("<p>"
."<a href=\"processing_forms.php?name=Guest&comment=$comment\">"
."It's an excellent site!</a></p>");
$comment = 'This VISITOR said: "It\'s an average site! :-("';
$comment = urlencode($comment);
print("<p>"
.'<a href="processing_forms.php?'.$comment.'">'
."It's an average site.</a></p>");
print("</html>");
?>

If you want to include special characters like spaces in the query string, you need to protect them by applying the urlencode() translation function. The script below shows how to use urlencode():

<?php
print("<html>");
print("<p>Please click the links below"
." to submit comments about FYICenter.com:</p>");
$comment = 'I want to say: "It\'s a good site! :->"';
$comment = urlencode($comment);
print("<p>"
."<a href=\"processing_forms.php?name=Guest&comment=$comment\">"
."It's an excellent site!</a></p>");
$comment = 'This visitor said: "It\'s an average site! :-("';
$comment = urlencode($comment);
print("<p>"
.'<a href="processing_forms.php?'.$comment.'">'
."It's an average site.</a></p>");
print("</html>");
?>

5, it’s a REFERENCE to EXISTING VARIABLE.

5, it’s a reference to existing variable.

In MySQL, the DEFAULT table type is MyISAM.
Each MyISAM table is stored on DISK in three files. The files have names that begin with
the table name and have an extension to indicate the file type.

The '.frm' file stores the table DEFINITION.
The DATA file has a '.MYD' (MYData) extension.
The INDEX file has a '.MYI' (MYIndex) extension.

In MySQL, the default table type is MyISAM.
Each MyISAM table is stored on disk in three files. The files have names that begin with
the table name and have an extension to indicate the file type.

The '.frm' file stores the table definition.
The data file has a '.MYD' (MYData) extension.
The index file has a '.MYI' (MYIndex) extension.

func_num_args() FUNCTION RETURNS the NUMBER of PARAMETERS PASSED in.

func_num_args() function returns the number of parameters passed in.

eregi_replace() FUNCTION is identical to ereg_replace() except that it ignores CASE distinction when MATCHING alphabetic characters.

eregi_replace() function is identical to ereg_replace() except that it ignores case distinction when matching alphabetic characters.

strstr() returns PART of a given string from the first OCCURRENCE of a given substring to the END of the string. For EXAMPLE: strstr("user@example.com","@") will return "@example.com".
stristr() is idential to strstr() except that it is case insensitive.

strstr() returns part of a given string from the first occurrence of a given substring to the end of the string. For example: strstr("user@example.com","@") will return "@example.com".
stristr() is idential to strstr() except that it is case insensitive.

No. There is no way to send emails directly using JavaScript.
But you can use JavaScript to EXECUTE a client SIDE email program send the email using the "MAILTO" code. Here is an example:
function myfunction(form)
{
tdata=document.myform.tbox1.value;
location="mailto:mailid@domain.com?SUBJECT=...";
return TRUE;
}

No. There is no way to send emails directly using JavaScript.
But you can use JavaScript to execute a client side email program send the email using the "mailto" code. Here is an example:
function myfunction(form)
{
tdata=document.myform.tbox1.value;
location="mailto:mailid@domain.com?subject=...";
return true;
}

When the original if was followed by : and then the CODE BLOCK without BRACES.

When the original if was followed by : and then the code block without braces.