How to Detect Request type in PHP

Question:How to Detect Request type (Get OR Post) in PHP?

$method = $_SERVER['REQUEST_METHOD'];
try {
    switch ($method) {
        case 'GET':
            /** Add your code here **/
            
            /** Add your code here **/
            break;
        case 'POST':
            /** Add your code here **/
            
            /** Add your code here **/
            break;
        case 'PUT':
            /** Add your code here **/
            
            /** Add your code here **/
            break;
        case 'HEAD':
            /** Add your code here **/
            
            /** Add your code here **/
            break;
        case 'DELETE':
            /** Add your code here **/
            
            /** Add your code here **/
            break;
        case 'OPTIONS':
            /** Add your code here **/
            
            /** Add your code here **/
            break;
        default:
            echo "$method method not defined";
            break;
    }
} catch (Exception $e) {
    echo $e->getMessage();
}

Question: How to get all post data in PHP?

$postData = array();
if(!empty($_POST)){
    $postData = $_POST;
}
print_r($postData );

Question: How to get all GET data in PHP?

$getData = array();
if(!empty($_GET)){
    $getData = $_GET;
}
print_r($getData );

Question: How to get Document root path in PHP?

echo $_SERVER['DOCUMENT_ROOT'];

Question: How to get Client Ip-Address in PHP?

echo $_SERVER['REMOTE_ADDR'];

Best Related Posts are Following:

1. What is stdClass? and How to create stdClass class?.
2. How to stop parsing the HTML tags?.
3. Difference between Notice and warning and fatal error.
4. Node Js Interview Questions and Answers for Experienced.
5. Difference between overloading and overriding in php with Example.
6. How can I prevent SQL-injection in PHP [SOLVED].
7. Object Oriented Programming in PHP.
8. Export to CSV File - PHP.
9. CURL Example.
10. What is Zend Engine in PHP.SQL Injection Attack - PHP & MySQL.

How to export mysql query results to csv?

To Learn OR understand the exporting mysql results in CSV.
Lets have below simple example.

1. Step 1: Create a employee table
   

   CREATE TABLE IF NOT EXISTS `employee` (
     `id` int(11) unsigned NOT NULL,
     `first_name` varchar(100) DEFAULT NULL,
     `last_name` varchar(100) DEFAULT NULL,
     `gender` enum('m','f') DEFAULT NULL,
     `status` enum('0','1') NOT NULL COMMENT '0-Inactive, 1-Active',
     `address` varchar(255) DEFAULT NULL,
     `created_at` datetime DEFAULT NULL,
     `modified_at` datetime DEFAULT NULL
   ) ENGINE=InnoDB AUTO_INCREMENT=6;

   
   
2. Add The records in employee table

   INSERT INTO `employee` (`id`, `first_name`, `last_name`, `gender`, `status`, `address`, `created_at`, `modified_at`) VALUES
   (1, 'Sunil', 'Malhotra', 'm', '1', '3020 new town, chandigarh', '2015-09-02 12:38:00', '2015-09-02 12:38:00'),
   (2, 'Anil ', 'Yadav', 'm', '1', '3020 new town, chandigarh', '2015-09-02 12:38:00', '2015-09-02 12:38:00'),
   (3, 'Aman ', 'Verma', 'm', '1', '3020 new town, chandigarh', '2015-09-02 12:38:00', '2015-09-02 12:38:00'),
   (4, 'Ram ', 'Singh', 'm', '1', '3020 new town, chandigarh', '2015-09-02 12:38:00', '2015-09-02 12:38:00'),
   (5, 'Arun', 'Kumar', 'm', '1', '3020 new town, chandigarh', '2015-09-02 12:38:00', '2015-09-02 12:38:00');
   

   
   
3. Create a folder where you are going to export the csv file.
   
4. Execute the Mysql Query.

   SELECT id,first_name,last_name,gender, STATUS, address FROM employee
   INTO OUTFILE 'E:/wamp/www/export/employee3.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"'
   LINES TERMINATED BY '\n';

   
   

Best Related Posts are Following:

1. MySql replace NULL values with empty string without effecting Rowset.
2. How to fix Headers already sent error in PHP?.
3. Twitter login failed leads to Page not found.
4. How to send an email using Email Template in Zend Framework.
5. How do I get wordpress global variable and functions in custom file [SOLVED].
6. How to convert php array into javascript array.
7. How to store array in Cookie and retrieve array from cookie.
8. Synchronous XMLHttpRequest on the main thread is deprecated.
9. Send Email from Gmail SMTP using Zend Framework.
10. HTML formatted email not showing up correctly in mail clients (Gmail-Outlook-Hotmail-Iphone-Android) [SOLVED].
11. How to change the author of a post in Wordpress.
12. How to clear Facebook image cache.
13. Google trends api php - How to get hot trends.
14. How can delete a user without deleting the post and comments in wordpress?.
15. Using mysqli and parameterized statements in PHP with Example.
16. Wordpress redirect https to http with htaccess [SOLVED].
17. Advanced PHP Interview Questions and Answers.
18. PHP Technical Interview Questions and Answers for Fresher and Experienced.
19. How to Add attribute in A-Tag using jQuery.
20. Wordpress Website title repeated two times in browser header [SOLVED].
21. How can I prevent SQL-injection in PHP [SOLVED].
22. Htaccess RewriteRule Flags by Code Example.
23. Multiple column ordering in Zend Framework.
24. Strtolower - Returns string with all alphabetic characters converted to lowercase.
25. Current time zone for a city- Free API.
26. Enabling the openssl in Wamp-Xampp.
27. How do I get a YouTube video thumbnail from the YouTube.
28. How to find day of week in php in a specific timezone.
29. Download Videos from Amazon S3 - PHP.
30. Calculate a Sum of Time using MySQL.
31. Paypal Sandbox do-Directpayment, Authorization, Capture and Mass-payment - Example with Code Snippets.
32. Image not displaying uploaded by CKeditor.
33. Parse XML in PHP By example [Solved].
34. jQuery multi column sorting with jQuery - Live Demo.
35. How to Select / Deselect All Checkboxes using jQuery.