We have already explained about form validation using same technologies. Now, the same can be done by using Ajax, In this blog post we will tell you how it can be done. We have created an HTML form with four…
The required attribute is a boolean attribute. When present, it specifies that an input field must be filled out before submitting the form to create dynamic required attribute to see below example. Note: The required attribute works with the following…
I have been using some JavaScript techniques in the past to find the maximum number in an array. I recently stumbled upon a real fast and simple solution to find the max number in an array and thought of sharing…
Ajax makes your application more flexible, you don’t need to reload or refresh the whole body for small changes, you can made changes in any part without loading page. var xhr; function request_call(url,mydata) { if(xhr && xhr.readyState != 4){ xhr.abort();…
You can use multiple tables in your single SQL query. The act of joining in MySQL refers to smashing two or more tables into a single table. Assume we have two or more tables in TUTORIALS. Now take a look…
The SQL LEFT JOIN (specified with the keywords LEFT JOIN and ON) joins two table or more tables and fetches all matching rows of two table or more tables for which the SQL-expression is true, plus rows from the frist…
The UNION query is used to combine the result-set of two or more SELECT statements. Unions combine the results from multiple SELECT queries into a consolidated result set. First you can need database connection in php Code $sql = “SELECT…
The SUM() function returns the total sum of a numeric column. To understand SUM function, consider an products table, which is having the following query. First you can need database connection in php Code $sql = “SELECT SUM(price) FROM Products”;…
The AVG() function returns the average value of a numeric column. To understand AVG function, consider an products table, which is having following query First you can need database connection in php Code $sql = “SELECT AVG(price) FROM Products”; $result…
The COUNT() function returns the number of records in a select query. To understand COUNT function, consider an products table, which is having following query First you can need database connection in php Code $sql = “SELECT COUNT(id) FROM Products”;…