Marketo Most Frequently Asked PHP 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 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.
 |
| Marketo Most Frequently Asked PHP 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>.
https://mytecbooks.blogspot.com/2019/06/marketo-most-frequently-asked-php.html