Code with saddam

 make sure are created other wise create your table and add some data. for example :   then run this query: SELECT first_name, last_name,  ( CASE             WHEN user_id < 3 THEN "Admin user"            WHEN user_id = 3 THEN "editor user"            ELSE  "suscriber user"  END) as role  FROM users;   the result output is : you can define query as per your requirement.

http://www.spinksindia.com/  http://www.spinksindia.com/about-us.php  http://www.spinksindia.com/advance_search_result.php  http://www.spinksindia.com/alfalfas-workstation-ws.php  http://www.spinksindia.com/automatic-toggle-printing-machine.php  http://www.spinksindia.com/automations--closure--printing.php  http://www.spinksindia.com/automations--closure-printing--2-row-continua.php  http://www.spinksindia.com/automations--closure-printing--4-row-continua.php  http://www.spinksindia.com/automations--hsc.php  http://www.spinksindia.com/concentra-130-4-color-pad-printing-machine.php  http://www.spinksindia.com/concentra-140-4-color-pad-printing-machine.php  http://www.spinksindia.com/concentra-140-6-color-pad-printing-machine.php  http://www.spinksindia.com/concentra-4-color-pad-printing-machines.php  http://www.spinksindia.com/concentra-6-color-pad-printing-machines.php  http://www.spinksindia.com/concentra-60-4-color...

http://markolaser.com/  http://markolaser.com/contactus.php  http://markolaser.com/career.php  http://markolaser.com/terms-condition.php  http://markolaser.com/index.php http://markolaser.com/laser_marking_main.php?category_main_id=1 http://markolaser.com/display_category_product_detail.php?category_id=17 http://markolaser.com/display_category_product_detail.php?category_id=1 http://markolaser.com/display_category_product_detail.php?category_id=6 http://markolaser.com/display_category_product_detail.php?category_id=7 http://markolaser.com/display_category_product_detail.php?category_id=12 http://markolaser.com/display_category_product_detail.php?category_id=10 http://markolaser.com/display_category_product_detail.php?category_id=8 http://markolaser.com/display_category_product_detail.php?category_id=11 http://markolaser.com/laser_marking_main.php?category_main_id=2 http://markolaser.com/micro-minnie-laser-marker.php?category_id=7 http://markolaser.com/display_catego...

<?php echo "<pre>"; $info = apache_lookup_uri('index.php?var=value'); print_r($info); if (file_exists($info->filename)) {     echo 'file exists!'; } ?> output:- stdClass Object ( [status] => 200 [the_request] => GET /php/s/1 HTTP/1.1 [method] => GET [mtime] => 0 [clength] => 0 [chunked] => 0 [content_type] => text/html [handler] => application/x-httpd-php [no_cache] => 0 [no_local_copy] => 1 [unparsed_uri] => /php/s/index.php?var=value [uri] => /php/s/index.php [filename] => C:/xampp/htdocs/php/s/index.php [args] => var=value [allowed] => 0 [sent_bodyct] => 0 [bytes_sent] => 0 [request_time] => 1513669009 ) file exists!

<?php $version = apache_get_version(); echo "$version\n"; ?> //output ;- Apache/2.4.12 (Win32) OpenSSL/1.0.1l PHP/5.6.8

  <?php echo abs(-5.6); // 5.2 (double/float) echo abs(9); // 9 (integer) echo abs(-12); // 12 (integer) ?>

view All $_SERVER  and globale  variable  in php. echo '<table cellpadding="10">' ; foreach ($_SERVER as $arg => $value ) {             echo '<tr><td>$_SERVER["'.$arg.'"] = </td><td>' . $value. '</td></tr>' ;     } echo '</table>' ;                                                            output                                                                              $_SERVER["MIBDIRS"] = C:/xampp/php/extras/mibs $_SERVER["MYSQL_HOME"] = \xampp\mysql\bin $_SERVER["OPENSSL_CONF"] = C:/xampp/apache/bin/openssl.cnf $...

Create  dynamically multiple folders using  php <?php // Desired folder structure $structure = './php/new/class/'; if (!mkdir($structure, 0777, true)) {     die('Failed to create folders...'); }

Export php  array  into  csv file using  php  <?php $list = array (     array('id', 'name' ),     array('01', 'saddam hussain'),     array('02', 'sam saifi') ); $fp = fopen('file.csv', 'w'); foreach ($list as $fields) {     fputcsv($fp, $fields); } fclose($fp); ?>

Export Mysql database to  csv file       $connect = mysqli_connect("localhost", "root", "", "test");       header('Content-Type: text/csv; charset=utf-8');       header('Content-Disposition: attachment; filename=data.csv');       $output = fopen("php://output", "w");       fputcsv($output, array('ID', 'Page Title', 'Page Url'));       $query = "SELECT * FROM `page`";       $result = mysqli_query($connect, $query);       while($row = mysqli_fetch_assoc($result))       {            fputcsv($output, $row);       }       fclose($output);  

Create  dynamic sitemap  from MySQL database with php   -- -- Database: `test` -- -- -------------------------------------------------------- -- -- Table structure for table `page` -- CREATE TABLE IF NOT EXISTS `page` (   `page_id` int(11) NOT NULL,   `page_title` text NOT NULL,   `page_url` text NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; -- -- Dumping data for table `page` -- INSERT INTO `page` (`page_id`, `page_title`, `page_url`) VALUES (1, 'JSON - Dynamic Dependent Dropdown List using Jquery and Ajax', 'json-dynamic-dependent-dropdown-list-using-jquery-and-ajax'), (2, 'Live Table Data Edit Delete using Tabledit Plugin in PHP', 'live-table-data-edit-delete-using-tabledit-plugin-in-php'), (3, 'Create Treeview with Bootstrap Treeview Ajax JQuery in PHP\r\n', 'create-treeview-with-bootstrap-treeview-ajax-jquery-in-php'), (4, 'Bootstrap Multiselect Dropdown with Checkboxes using Jquery in PHP\r\n', 'boo...

Create Json code  from MySQL database with php   -- -- Database: `test` -- -- -------------------------------------------------------- -- -- Table structure for table `page` -- CREATE TABLE IF NOT EXISTS `page` (   `page_id` int(11) NOT NULL,   `page_title` text NOT NULL,   `page_url` text NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; -- -- Dumping data for table `page` -- INSERT INTO `page` (`page_id`, `page_title`, `page_url`) VALUES (1, 'JSON - Dynamic Dependent Dropdown List using Jquery and Ajax', 'json-dynamic-dependent-dropdown-list-using-jquery-and-ajax'), (2, 'Live Table Data Edit Delete using Tabledit Plugin in PHP', 'live-table-data-edit-delete-using-tabledit-plugin-in-php'), (3, 'Create Treeview with Bootstrap Treeview Ajax JQuery in PHP\r\n', 'create-treeview-with-bootstrap-treeview-ajax-jquery-in-php'), (4, 'Bootstrap Multiselect Dropdown with Checkboxes using Jquery in PH...

CRUD Using  Php with  Ajax (index.php) <?php  include('row.php');?> <!DOCTYPE html> <html lang="en"> <head>   <title>Bootstrap Example</title>   <meta charset="utf-8">   <meta name="viewport" content="width=device-width, initial-scale=1">   <link rel="stylesheet" href="asset/bootstrap.min.css">   <script src="asset/jquery.min.js"></script>   <script src="asset/bootstrap.min.js"></script> </head> <body> <div class="container">     <div class="row">        <div class="alert" role="alert">                  </div>               <div class="col-md-10 col-md-offset-1">             <div class="panel panel-default panel-table">          ...

<?php /* Plugin Name: My form */ $my_option= get_option('myformSetting'); function my_admin_theme_style() {     wp_enqueue_style('my-admin-theme', plugins_url('wp-admin.css', __FILE__)); } add_action('admin_enqueue_scripts', 'my_admin_theme_style'); add_action('login_enqueue_scripts', 'my_admin_theme_style'); add_action('admin_menu', 'my_menu_pages'); function my_menu_pages(){     add_menu_page('My Page Title', 'My Menu Title', 'manage_options', 'my-menu', 'my_menu_output' );     add_submenu_page('my-menu', 'Submenu Page Title', 'Whatever You Want', 'manage_options', 'my_menu','my_menu' );     add_submenu_page('my-menu', 'Submenu Page Title2', 'Whatever You Want2', 'manage_options', 'my_menu2','my_menu2' ); } function register_mysettings() { // whitelist opti...