1)What is the difference between a static and Dynamic Web site?
A static website is one that is written in HTML only. Each page is a separate document and there is no database that it draws on. What this means functionally is that the only way to edit the site is to go into each page and edit the HTML - So you would have to do it yourself using a web page editor such as FrontPage or Dreamweaver, or pay your web developer to make updates for you.
A dynamic website is created by webdevelopers who are strong in ASP.Net, PHP, JAVA and more... This website pages contains data is retrieved from certain database. Each time the viewer entering a page, the contents of that page is retrieved from the database. The administrator can change the content and images from admin panel. This is one that changes or customizes itself frequently and automatically.
2)What is the meaning of Open Source Software?
Open-Source Software (OSS) is computer software that is available in source code form: the source code and certain other rights normally reserved for copyright holders are provided under a software license that permits users to study, change, improve and at times also to distribute the software.Open Source Software means it is a free software and no need to buy, we can use full functionallities from this software with certain Terms & Conditions. This license allows modifications and derived works, and allows us to be distributed under the same terms as the license of the original software.
3)Why was PHP developed, what it is used for, and where can you get it?
PHP developed for less script, time saving, Free Open Source Software and runs on different platforms such as Windows, Linux, Unix, etc. PHP compatible with almost all servers used today such as Apache, IIS, etc.
PHP is free dowload from the offical PHP resource
Download : http://windows.php.net/download/
4)What are the benefits of using PHP and MySQL?
One of the main reasons that businesses choose PHP is its simplicity and ease of use. PHP competes against a number of other web scripting solutions such as Active Server Pages and PERL, but none of these languages are as easy to learn as PHP. Further, some languages require a moderate amount of programming background before a developer can get up to speed in development. With PHP, however, even non-programmers have been able to develop web-based solutions within a matter of days after going through the basic tutorials on PHP. PHP commands are simply embedded into the same web page with HTML commands, and execute on the server to deliver the web pages to the user.
Another big advantage of PHP is its interoperability with multiple operating systems. A company can use PHP with either Linux, Windows or Macs for example. They can also use PHP with the popular open source Apache server. Compare that with Microsoft’s Active Server Pages, by contrast, which is primarily designed for Microsoft-enabled servers. Portability is becoming a chief concern for businesses that use one or more operating systems in their businesses. Businesses save money by using PHP to leverage their existing I.S. resources rather than investing large sums of money to purchase proprietary products.
5)What is PHP?
PHP stand for Hypertext Preprocessor.
PHP is a Server Side Scripting Language.
PHP is a Open Source Software.
PHP free to download and use.
PHP scripts are executed on server.
PHP supports many databases such as MYSQL, Informix, Oracle, Sybase, Solid, PostgreSQL, Generic ODBC, etc.,
PHP development began in 1994 when the Danish/Greenlandic programmerRasmusLerdorf initially created a set of Perl scripts he called "Personal Home Page Tools" to maintain his personal homepage. Marco Tabini is the funder an publisher of PHP|architech.
6)What are the method available in form submitting?
GET and POST.
7)What are the differences between GET and POST methods in form submitting?
On the server side, the main difference between GET and POST is where the submitted is stored. The $_GET array stores data submitted by the GET method. The $_POST array stores data submitted by the POST method.
On the browser side, the difference is that data submitted by the GET method will be displayed in the browser’s address field. Data submitted by the POSTmethod will not be displayed anywhere on the browser.
GET method is mostly used for submitting a small amount and less sensitive data.
POST method is mostly used for submitting a large amount or sensitive data.
8)How can we submit from without a submit button?
9)How can we get the browser properties using php?
10)What Is a Session?
A session is a logical object created by the PHP engine to allow you to preserve data across subsequent HTTP requests. Sessions are commonly used to store temporary data to allow multiple PHP pages to offer a complete functional transaction for the same visitor.
11)How can we register the variables into a session?
12)How do you destroy a particular or all Sessions?
13)How many ways we can pass the variable through the navigation between the pages?
Register the variable into the session
Pass the variable as a cookie
Pass the variable as part of the URL
14)What are the different functions in sorting an array?
15)How can we know the total number of elements of Array?
If we just pass a simple var instead of a an array it will return 1.
16)What type of headers that PHP supports?
17)How can we extract string ‘abc.com’ from a string ‘http://firstname.lastname@example.org’ using regular _expression of php?
We can use the preg_match() function with “/.*@(.*)$/” as the regular expression pattern.
18)How can we create a database using php?
19)Explain include(), include_once, require() and require_once.
The include() function takes all the content in a specified file and includes it in the current file. If an error occurs, the include() function generates a warning, but the script will continue execution.
File will not be included more than once. If we want to include a file once only and further calling of the file will be ignored then we have to use the PHP function include_once().
The require() function is identical to include(), except that it handles errors differently. The require() generates a fatal error, and the script will stop.
The required file is called only once when a page is open and further calling of the file will be ignored.
20)What are the different types of errors in php?
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, as you will see, you can change this default behaviour.
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.
Fatal errors: These are critical errors - for example, instantiating an object of a non-existent class, or calling a non-existent function. These errors cause the immediate termination of the script, and PHP’s default behaviour is to display them to the user when they take place.
If we just pass a simple var instead of a an array it will return 1.
21)What are the Formatting and Printing Strings available in PHP?
printf() Displays a formatted string
sprintf() Saves a formatted string in a variable
fprintf() Prints a formatted string to a file
number_format() Formats numbers as strings
22)How to find a length of a string?
23)What is the functionality of the function strstr and stristr?
strstr() returns part of a given string from the first occurrence of a given substring to the end of the string.
strstr("email@example.com","@") will return "@example.com".
stristr() is idential to strstr() except that it is case insensitive.
24)How can we get second of the current time using date function?
25)What is the difference between the functions unlink and unset?
unlink() deletes the given file from the file system.
unset() makes a variable undefined.
26)What is the difference between ereg_replace() and eregi_replace()?
eregi_replace() function is identical to ereg_replace() except that it ignores case distinction when matching alphabetic characters.
27)What is the difference between characters \023 and \x23?
The first one is octal 23, the second is hex 23.
28)What is the difference between PHP4 and PHP5?
PHP4 cannot support oops concepts and Zend engine 1 is used.
PHP5 supports oops concepts and Zend engine 2 is used. Error supporting is increased in PHP5. XML and SQLLite will is increased in PHP5.
29)What are the differences between mysql_fetch_array(), mysql_fetch_object(), mysql_fetch_row()?
Fetch a result row as an associative array and a numeric array.
Returns an object with properties that correspond to the fetched row and moves the internal data pointer ahead. Returns an object with properties that correspond to the fetched row, or FALSE if there are no more rows.
Fetches one row of data from the result associated with the specified result identifier. The row is returned as an array. Each result column is stored in an array offset, starting at offset 0.
30)In how many ways we can retrieve data in the result set of MYSQL using PHP?
mysql_fetch_array: - Fetch a result row as an associative array, a numeric array, or both.
mysql_fetch_assoc:- Fetch a result row as an associative array.
mysql_fetch_object:- Fetch a result row as an object.
mysql_fetch_row:- Get a result row as an enumerated array.
31)What are encryption functions in PHP?
What are encryption functions in PHP?
32)What is the functionality of the function htmlentities?
htmlentities():- Convert all applicable characters to HTML entities This function is identical to htmlspecialchars() in all ways, except with htmlentities(), all characters which have HTML character entity equivalents are translated into these entities.
33)How can we increase the execution time of a php script?
By the use of void set_time_limit(int seconds) Set the number of seconds a script is allowed to run. If this is reached, the script returns a fatal error. The default limit is 30 seconds or, if it exists, the max_execution_time value defined in the php.ini. If seconds is set to zero, no time limit is imposed. When called,set_time_limit() restarts the timeout counter from zero. In other words, if the timeout is the default 30 seconds, and 25 seconds into script execution a call such as set_time_limit(20) is made, the script will run for a total of 45 seconds before timing out.
34)How to set cookies?
variable - name of the cookie variable
value - value of the cookie variable
time - expiry time
Test - cookie variable name
$i - value of the variable 'Test'
time()+3600 - denotes that the cookie will expire after an one hour
35)How to store the uploaded file to the final location?
move_uploaded_file( string filename, string destination)
36)What type of headers have to be added in the mail function to attach a file?
37)How can we find the number of rows in a result set using php?
38)How can we know the number of days between two given dates using php?
39)How to open a file?
40)How many open modes available when a file open in PHP?
r , r+ , w , w+ , a , a+ , x , x+
41)Explain the types of string comparision function in PHP.
1. strcmp() Compares two strings (case sensitive)
2. strcasecmp() Compares two strings (not case sensitive)
3. strnatcmp(str1, str2); Compares two strings in ASCII order, but any numbers are compared numerically
4. strnatcasecmp(str1, str2); Compares two strings in ASCII order, case insensitive, numbers as numbers
5. strncasecomp() Compares two strings (not case sensitive) and allows you to specify how many characters to compare
6. strspn() Compares a string against characters represented by a mask
7. strcspn() Compares a string that contains characters not in the mask
42)Explain the types of functions for Splitting String?
split() Splits a string into an array by using a regular expression as the delimiter.
spliti() Splits a string into an array by a regular expression and is case insensitive.
str_split() Converts a string into an array where the size of the elements can be specified
preg_split() Splits up a string by a Perl compatible regular expression and returns an array of substrings
explode() Splits up a string by another string (not a regular expression) and returns an array
implode() Joins array elements together by a string and returns a string
43)Explain Whitespace Characters.
Whitespace Character ASCII Value(Decimal/Hex) Descriptions
" " 32 (0x20)) An ordinary space
"\t" 9(0x0) A tab.
"\n" 10(0x0A) A newline (line feed).
"\r" 13(0x0D)) A carriage return.
"\0" 0(0x00)) The NULL-byte.
"\x0B" 11(0x0B)) A vertical tab.
44)What do you mean range()?
Starting from a low value and going to a high value, the range() function creates an array of consecutive integer or character values. It takes up to three arguments: a starting value, an ending value, and an increment value. If only two arguments are given, the increment value defaults to 1.
45)Explain Creating and Naming an Array.
1. array() Creates an array
2. array_combine() Creates an array by using one array for keys and another for its values
3. array_fill() Fills an array with values
4. array_pad() Pads an array to the specified length with a value
5. compact() Creates array containing variables and their values
6. range() Creates an array containing a range of elements
46)How to read and display a HTML source from the website url?
47)How to display your correct URL of the current web page?
48)Explain $_FILES Superglobal Array.
$_FILES['userfile']['name'] The original name of the file on the client machine.
$_FILES['userfile']['type'] The MIME type of the file, if the browser provided this information. An example would be "image/gif".
$_FILES['userfile']['size'] The size, in bytes, of the uploaded file.
$_FILES['userfile']['tmp_name'] The temporary filename of the file in which the uploaded file was stored on the server.
$_FILES['userfile']['error'] The error code associated with this file upload.
The mysql_error() message will tell us what was wrong with our query, similar to the message we would receive at the MySQL console.
50)What types of MYSQL function available in PHP?
Database Function Descriptions
mysql_connect() Opens a connection to a MySQL server.
mysql_pconnect() Opens a persistent connection.
mysql_selectdb() Selects the default database.
mysql_change_user() Changes the identity of the user logged on.
mysql_list_dbs Lists databases for this MySQL server.
mysql_list_tables Lists tables in the database.
51)How to get no. of rows using MYSQL function?
Database Function Descriptions
mysql_fetch_assoc() Returns one result row, as an associative array.
mysql_fetch_row() Returns one result row, as an array.
mysql_affected_rows() Returns number of rows affected by query.
mysql_num_rows() Returns number of rows selected.
mysql_list_dbs Lists databases for this MySQL server.
mysql_fetch_object() Returns a result row, as an object.
Returns the numerical value of the error message from previous MySQL operation.
53)What types of MYSQL function available for affecting columns
mysql_fetch_field() Gets column information from a result and returns as an object.
mysql_field_name() Gets the name of the specified field in a result.
mysql_list_fields() Sets result pointer to a specified field offset.
mysql_num_fields() Gets number of fields in a result.
mysql_field_seek() Sets result pointer to a specified field offset.
mysql_field_type() Gets the type of the specified field in a result.
mysql_field_len() Returns the length of the specified field.
mysql_field_table() Gets name of the table the specified field is in.
mysql_tablename() Gets table name of field.