Website can not be completed without any style. So you apply CSS. When a browser reads a CSS style sheet, this formats the HTML document according to the information in the CSS style sheet. With 3 basic ways you can add CSS in your web pages:- 1) Link your webpage with an external file: <link […]
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 […]
MyISAM vs Innodb – both are commonly used engines on MySQL servers and they both have their unique advantages and disadvantages against each other. MyISAM is the default storage engine type for MySQL 5.0 but the Cloud Sites environment defaults the storage engine to Innodb. MyISAM vs Innodb: MyISAM: Table level locking. Innodb: Row level […]
It is relational database concept in which multiple tables shares consistent relationship based on the data stored on tables. For example, a school X has 2 tables, a student table, and a student fee table. In the student table we have 2 columns – the student ID and the student name. In the student fee […]
For improving the speed of operation in a table we use MySQL INDEX. We can create more than one field as a index field in a table. This is basically use for searching process so that it can lookup records very fast. As it fetches record very fast from the database, during insert and update […]
Few Mysql queries that will help you develop websites and resolve complex codes. Here are few Mysql Query tips: Finding 2nd highest salary in employee table SELECT MAX(`salary`) from tbl where `salary` < (select MAX(`salary`) from tbl); Mysql order by FIELD SELECT * FROM tbl ORDER BY FIELD(first_name,’John’) desc, FIELD(last_name,’Doe′) ASC; Show category-parent category SELECT […]
Sometimes we need to add demo text in a website for checking whether it working fine or somewhere we test website with demo text. So on this case unwanted text inserted into database and you need to remove it. So, we can update fields with random sentence in this case. For example the fields value […]
As you have been writing css for several years day by day you are getting new things that you have never used previously. Each and every well trained front-end developer feature-tests before using any features which a browser may not have. This feature testing has always done with scripting, and most of the people use […]
Using template is very easy to incorporate into website. For a duplication you don’t need to write over and over again just call them repetitively. Parameters: Following properties can be sent as a parameter-value: name, nodes, data, if, foreach, as, afterAdd, afterRender, beforeRemove. Lets see an example of Templating: <!DOCTYPE html> <head> <title>KnockoutJS – Templating</title> […]
Using a single object called dependency tracker i.e. ko.dependencyDetection you can determine when the value get updated. When you declare a computed observable, KO immediately gets its initial value and updated computed observable. Lets see an example for Dependency Tracking: <!DOCTYPE html> <html> <head> <title>Dependency Tracking – KnockoutJS</title> <script src=”http://ajax.aspnetcdn.com/ajax/knockout/knockout-3.1.0.js” type=”text/javascript”></script> </head> <body> <div> <form […]