Using MySQL SELECT statement you can fetch combination of columns and rows from tables or views, known as a result set. This is the one of the most commonly used queries in MySQL to get data from the MySQL database. You can add or use one or more tables i.e. separated by comma for including various […]
Want to store IP addresses in database and still using VARCHAR(15)? You can actually store IP addresses as integer values because using INT you go down to 4 bytes of space and have a fixed size field. As the range of a IP Addresses are 32 bit unsigned integer you can use your column as […]
If you want to analyze the columns structures of a MySQL table and want to view the actual data in your table with certain suggestion then you can get help from PROCEDURE ANALYSE(). For example, if any data present in your table and plays a big role in any decision making then this is very […]
Php 5.3 has a solution for ignoring for(), foreach() cycles that will reduce the average number of iteration structures you need to write i.e. array_map. This function in PHP sends each value of an array to a user defined function, and then returns an array with new values that is given by the user defined […]
Ajax is Asynchronous JavaScript and XML for for asynchronous web applications. Using ajax data from a server asynchronously retrieved and display without reloading the page. So JSON with Ajax is no exception. JSON stands for JavaScript Object Notation. So, in simple terms JSON is a way of formatting the data. For, e.g., transmitting it over […]
URLs or Uniform Resource Locator is location of html document web. It consists of three parts i.e. Protocol, Domain and Resource path. For e.g. http://www.namasteui.com/index.php where http is protocol, www.namasteui.com is domain and index.php is resource path. It also has a query string i.e. http://www.namasteui.com/index.php?value=1&page=3 So the query string for the above url is: ?value=1&page=3 […]
To read the data from the server AngularJS uses $http control to get the desired results from Ajax. It requires data as a JSON format. Example of Ajax: <script> var ngApp = angular.module(“ngApp”, []); ngApp.controller(‘nameController’, function($scope) { var url=”ajaxmaster.php”; $http.get(url).success( function(data) { $scope.response = data; }); }); </script>
In HTML you can not include files like HTML into another HTML pages. To achieve this functionality you had to choose either Ajax call or server side includes like php, jsp. But using AngularJS you can embed HTML page within a HTML page using ng-include directive. By default, for same domain and protocol as a […]