|
|
Here are the answers of few of the questions
1. We need "commit" to save changes permanently in any transaction in database.
2. If data were not inserted properly in any transaction in database then we can "rollback" transaction to undo all the changes made by query in transaction.
3. Triggers are fired on some event in database, while stored procedures are the functions that can be called whenever we require them.
4. destructors are used to destroy an object of the class, to free memory used by that object.
5. we should care about the following points while creating any framework.
- it should be easily portable - framework should be easily portable so, that it can be used anywhere without need of any changes in it's coding.
- it should provide all the general features required by programmer
- it should have a clean working model, means, files should be managed properly and directory structure should be good, so that any one can understand and work on it easily.
- Data abstraction layer should be available there.
and many more..........
6. variables passed using GET method are visible in address bar in browser and in POST method they are not.
7. methods of passing variables from one php script to another
- POST method
- GET method
- Using sessions
- Using file's
- Using cookies
8. Microsoft Internet Explorer has a maximum uniform resource locator (URL) length of 2,083 characters. Internet Explorer also has a maximum path length of 2,048 characters. This limit applies to both POST request and GET request URLs.
If you are using the GET method, you are limited to a maximum of 2,048 characters, minus the number of characters in the actual path.
However, the POST method is not limited by the size of the URL for submitting name/value pairs. These pairs are transferred in the header and not in the URL.
RFC 2616, "Hypertext Transfer Protocol -- HTTP/1.1," does not specify any requirement for URL length.
9. we can export data from database to a file directly using " load " query
10. php config file resides in php directory on windows and
usr/local/bin or /etc/ on linux plateform
thanks.
enjoy..
|