Skip to main content

Posts

Showing posts from July, 2017

view All $_SERVER and globale variable in php.

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 $...

Export Mysql database to csv file

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

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

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">          ...