Autodesk PHP Most Frequently Asked Latest Interview Questions Answers
What Is The Maximum Length Of A Table Name, A Database Name, Or A Field Name In Mysql?
Database name: 64 characters
Table name: 64 characters
Column name: 64 characters
How Many Values Can The Set Function Of Mysql Take?
MySQL SET function can take zero or more values, but at the maximum it can take 64 values.
What Are The Other Commands To Know The Structure Of A Table Using Mysql Commands Except Explain Command?
DESCRIBE table_name;
How Can We Find The Number Of Rows In A Table Using Mysql?
Use this for MySQL
SELECT COUNT(*) FROM table_name;
What's The Difference Between Htmlentities() And Htmlspecialchars()?
htmlspecialchars only takes care of <, >, single quote ‘, double quote " and ampersand.
htmlentities translates all occurrences of character sequences that have different meaning in HTML.
How To Store The Uploaded File To The Final Location?
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.
What Is The Difference Between Reply-to And Return-path In The Headers Of A Mail Function?
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.
So If Md5() Generates The Most Secure Hash, Why Would You Ever Use The Less Secure Crc32() And Sha1()?
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.
How Can We Destroy The Session, How Can We Unset The Variable Of A Session?
session_unregister() - Unregister a global variable from the current session.
session_unset() - Free all session variables.
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 if not
; specified).
upload_tmp_dir = C:\apache2triad\temp
; Maximum allowed size for uploaded files.
upload_max_filesize = 2M
What's The Difference Between Md5(), Crc32() And Sha1() Crypto On Php?
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.
How Can We Find The Number Of Rows In A Result Set Using Php?
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";
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.
How Many Ways We Can We Find The Current Date Using Mysql?
SELECT CURDATE();
SELECT CURRENT_DATE();
SELECT CURTIME();
SELECT CURRENT_TIME();
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 </font>
What Is Session_register()?
session_register() is old function that registers global variables into the current session. You should stop using session_register() and use array $_SESSION to save values into the current session now.
What Do You Need To Connect Php To Mysql?
If you want to access MySQL database server in your PHP script, you need to make sure that MySQL module is installed and turned on in your PHP engine. Check the PHP configuration file, php.ini, to make sure the extension=php_mysql.dll is not commented out.
The MySQL module offers a number of functions to allow you to work with MySQL server. Some commonly used MySQL functions are:
• mysql_connect -- Open a connection to a MySQL Server
• mysql_close -- Close MySQL connection
• mysql_db_query -- Send a MySQL query
• mysql_fetch_array -- Fetch a result row as an associative array, a numeric array, or both
• mysql_free_result -- Free result memory
• mysql_list_tables -- List tables in a MySQL database
• mysql_list_fields -- List MySQL table fields
How To Connect To Mysql From A Php Script?
If you want access the MySQL server, you must create a connection object first by calling the mysql_connect() function in the following format:
$con = mysql_connect($server, $username, $password);
If you are connecting to a local MySQL server, you don't need to specify username and password. If you are connecting to a MySQL server offered by your Web hosting company, they will provide you the server name, username, and password.
The following script shows you how to connect to a local MySQL server, obtained server information, and closed the connection:
<?php
$con = mysql_connect('localhost');
print(mysql_get_server_info($con)."\n");
print(mysql_get_host_info($con)."\n");
mysql_close($con);
?>
How To Run A Sql Statement?
You can run any types of SQL statements through the mysql_query() function. It takes the SQL statement as a string and returns different types of data depending on the SQL statement type and execution status:
• Returning FALSE, if the execution failed.
• Returning a result set object, if the execution is successful on a SELECT statement or other statement returning multiple rows of data.
• Returning TRUE, if the execution is successful on other statements.
Here is a good example of running a SQL statement with the mysql_query() function:
<?php
include "mysql_connection.php";
$sql = 'SELECT sysdate() FROM dual';
$rs = mysql_query($sql, $con);
$row = mysql_fetch_array($rs);
print("Database current time: ". $row[0] ."\n");
mysql_close($con);
?>
How To Get The Number Of Rows Selected Or Affected By A Sql Statement?
There are two functions you can use the get the number of rows selected or affected by a SQL statement:
mysql_num_rows($rs) - Returns the number of rows selected in a result set object returned from SELECT statement.
mysql_affected_rows() - Returns the number of rows affected by the last INSERT, UPDATE or DELETE statement.
What Is A Result Set Object?
A result set object is a logical representation of data rows returned by mysql_query() function on SELECT statements. Every result set object has an internal pointer used to identify the current row in the result set. Once you get a result set object, you can use the following functions to retrieve detail information:
• mysql_free_result($rs) - Closes this result set object.
• mysql_num_rows($rs) - Returns the number rows in the result set.
• mysql_num_fields($rs) - Returns the number fields in the result set.
• mysql_fetch_row($rs) - Returns an array contains the current row indexed by field position numbers.
• mysql_fetch_assoc($rs) - Returns an array contains the current row indexed by field names.
• mysql_fetch_array($rs) - Returns an array contains the current row with double indexes: field position numbers and filed names.
• mysql_fetch_lengths($rs) - Returns an array contains lengths of all fields in the last row returned.
• mysql_field_name($rs, $i) - Returns the name of the field of the specified index.
What Is File Upload?
File upload is Web page function which allows visitor to specify a file on the browser's system and submit it to the Web server. This is a very useful function for many interactive Web sites. Some examples are:
Web base email systems for users to send attachments.
Forums that allows user to submit pictures.
Web sites file managers for users to build their own Web pages.
Which HTML Tag Allows Users to Specify a File for Uploading?
To present an input field on your Web page to allow users to specify a local file to upload, you need to use the <INPUT TYPE="FILE" ...> tag inside a <FORM ...> tag. The <INPUT TYPE="FILE" ...> will be displayed as a text input field followed by a button called "Browse...". Users can either enter the full path name of a local file, or click Browse button to go through a dialog box to select a file interactively. The following PHP code shows you a good example of the file upload tag:
<?php
print("<html><form>n");
print("<input type=file>n");
print("<input type=submit>n");
print("</form></html>n");
?>
What Is The Difference Between Char And Varchar Data Types?
CHAR is a fixed length data type. CHAR(n) will take n characters of storage even if you enter less than n characters to that column. For example, "Hello!" will be stored as "Hello! " in CHAR(10) column.
VARCHAR is a variable length data type. VARCHAR(n) will take only the required storage for the actual number of characters entered to that column. For example, "Hello!" will be stored as "Hello!" in VARCHAR(10) column.
How Can We Encrypt And Decrypt A Data Present In A Mysql Table Using Mysql?
AES_ENCRYPT() and AES_DECRYPT().
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
or,
ALTER TABLE tableName CHANGE OldName newName.
What Is The Maximum Length Of A Table Name, A Database Name, Or A Field Name In Mysql?
Database name: 64 characters
Table name: 64 characters
Column name: 64 characters
How Many Values Can The Set Function Of Mysql Take?
MySQL SET function can take zero or more values, but at the maximum it can take 64 values.
What Are The Other Commands To Know The Structure Of A Table Using Mysql Commands Except Explain Command?
DESCRIBE table_name;
How Can We Find The Number Of Rows In A Table Using Mysql?
Use this for MySQL
SELECT COUNT(*) FROM table_name;
What's The Difference Between Htmlentities() And Htmlspecialchars()?
htmlspecialchars only takes care of <, >, single quote ‘, double quote " and ampersand.
htmlentities translates all occurrences of character sequences that have different meaning in HTML.
 |
| Autodesk PHP Most Frequently Asked Latest Interview Questions Answers |
How To Store The Uploaded File To The Final Location?
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.
What Is The Difference Between Reply-to And Return-path In The Headers Of A Mail Function?
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.
So If Md5() Generates The Most Secure Hash, Why Would You Ever Use The Less Secure Crc32() And Sha1()?
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.
How Can We Destroy The Session, How Can We Unset The Variable Of A Session?
session_unregister() - Unregister a global variable from the current session.
session_unset() - Free all session variables.
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 if not
; specified).
upload_tmp_dir = C:\apache2triad\temp
; Maximum allowed size for uploaded files.
upload_max_filesize = 2M
What's The Difference Between Md5(), Crc32() And Sha1() Crypto On Php?
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.
How Can We Find The Number Of Rows In A Result Set Using Php?
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";
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.
How Many Ways We Can We Find The Current Date Using Mysql?
SELECT CURDATE();
SELECT CURRENT_DATE();
SELECT CURTIME();
SELECT CURRENT_TIME();
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 </font>
What Is Session_register()?
session_register() is old function that registers global variables into the current session. You should stop using session_register() and use array $_SESSION to save values into the current session now.
What Do You Need To Connect Php To Mysql?
If you want to access MySQL database server in your PHP script, you need to make sure that MySQL module is installed and turned on in your PHP engine. Check the PHP configuration file, php.ini, to make sure the extension=php_mysql.dll is not commented out.
The MySQL module offers a number of functions to allow you to work with MySQL server. Some commonly used MySQL functions are:
• mysql_connect -- Open a connection to a MySQL Server
• mysql_close -- Close MySQL connection
• mysql_db_query -- Send a MySQL query
• mysql_fetch_array -- Fetch a result row as an associative array, a numeric array, or both
• mysql_free_result -- Free result memory
• mysql_list_tables -- List tables in a MySQL database
• mysql_list_fields -- List MySQL table fields
How To Connect To Mysql From A Php Script?
If you want access the MySQL server, you must create a connection object first by calling the mysql_connect() function in the following format:
$con = mysql_connect($server, $username, $password);
If you are connecting to a local MySQL server, you don't need to specify username and password. If you are connecting to a MySQL server offered by your Web hosting company, they will provide you the server name, username, and password.
The following script shows you how to connect to a local MySQL server, obtained server information, and closed the connection:
<?php
$con = mysql_connect('localhost');
print(mysql_get_server_info($con)."\n");
print(mysql_get_host_info($con)."\n");
mysql_close($con);
?>
How To Run A Sql Statement?
You can run any types of SQL statements through the mysql_query() function. It takes the SQL statement as a string and returns different types of data depending on the SQL statement type and execution status:
• Returning FALSE, if the execution failed.
• Returning a result set object, if the execution is successful on a SELECT statement or other statement returning multiple rows of data.
• Returning TRUE, if the execution is successful on other statements.
Here is a good example of running a SQL statement with the mysql_query() function:
<?php
include "mysql_connection.php";
$sql = 'SELECT sysdate() FROM dual';
$rs = mysql_query($sql, $con);
$row = mysql_fetch_array($rs);
print("Database current time: ". $row[0] ."\n");
mysql_close($con);
?>
How To Get The Number Of Rows Selected Or Affected By A Sql Statement?
There are two functions you can use the get the number of rows selected or affected by a SQL statement:
mysql_num_rows($rs) - Returns the number of rows selected in a result set object returned from SELECT statement.
mysql_affected_rows() - Returns the number of rows affected by the last INSERT, UPDATE or DELETE statement.
What Is A Result Set Object?
A result set object is a logical representation of data rows returned by mysql_query() function on SELECT statements. Every result set object has an internal pointer used to identify the current row in the result set. Once you get a result set object, you can use the following functions to retrieve detail information:
• mysql_free_result($rs) - Closes this result set object.
• mysql_num_rows($rs) - Returns the number rows in the result set.
• mysql_num_fields($rs) - Returns the number fields in the result set.
• mysql_fetch_row($rs) - Returns an array contains the current row indexed by field position numbers.
• mysql_fetch_assoc($rs) - Returns an array contains the current row indexed by field names.
• mysql_fetch_array($rs) - Returns an array contains the current row with double indexes: field position numbers and filed names.
• mysql_fetch_lengths($rs) - Returns an array contains lengths of all fields in the last row returned.
• mysql_field_name($rs, $i) - Returns the name of the field of the specified index.
What Is File Upload?
File upload is Web page function which allows visitor to specify a file on the browser's system and submit it to the Web server. This is a very useful function for many interactive Web sites. Some examples are:
Web base email systems for users to send attachments.
Forums that allows user to submit pictures.
Web sites file managers for users to build their own Web pages.
Which HTML Tag Allows Users to Specify a File for Uploading?
To present an input field on your Web page to allow users to specify a local file to upload, you need to use the <INPUT TYPE="FILE" ...> tag inside a <FORM ...> tag. The <INPUT TYPE="FILE" ...> will be displayed as a text input field followed by a button called "Browse...". Users can either enter the full path name of a local file, or click Browse button to go through a dialog box to select a file interactively. The following PHP code shows you a good example of the file upload tag:
<?php
print("<html><form>n");
print("<input type=file>n");
print("<input type=submit>n");
print("</form></html>n");
?>
What Is The Difference Between Char And Varchar Data Types?
CHAR is a fixed length data type. CHAR(n) will take n characters of storage even if you enter less than n characters to that column. For example, "Hello!" will be stored as "Hello! " in CHAR(10) column.
VARCHAR is a variable length data type. VARCHAR(n) will take only the required storage for the actual number of characters entered to that column. For example, "Hello!" will be stored as "Hello!" in VARCHAR(10) column.
How Can We Encrypt And Decrypt A Data Present In A Mysql Table Using Mysql?
AES_ENCRYPT() and AES_DECRYPT().
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
or,
ALTER TABLE tableName CHANGE OldName newName.
https://mytecbooks.blogspot.com/2018/10/autodesk-php-most-frequently-asked.html