In this tutorial we are going to see how to implement inline edit of jQGrid using php. This jQGrid table has extra column, which has three button to perform edit, save and cancel actions respectively. when user clicks on particular….. Read More >>>>
Continue Reading »MYSQL
Pagination, Previous, Next, First and Last button using jQGrid, PHP, MySQL, jQuery and Ajax
Web applications realiablity depends on how much user friendliness that application was to the user. Mostly when we display large pile of data to user, we need to give choices to the user how they want to view those data’s….. Read More >>>>
Continue Reading »Quiz application Using PHP, jQuery, Ajax, MySQL and HTML5
Everyone likes to make some hello world application, here is that type application you can make it youself. I am going to make Quiz application using PHP, MySQL, HTML5, jQuery, Ajax and CSS3. Just follow this tutorial to make it….. Read More >>>>
Continue Reading »Autocomplete Using jQuery, Ajax, PHP and MySQL
Please refer my latest Video tutorial on jQuery autocomplete Learn jQuery Autocomplete in 3 Minutes In this tutorial we are going to see autocomplete using jQuery, Ajax,PHP and MySQL. Follow each steps carefully to create this autocomplete function by….. Read More >>>>
Continue Reading »Generate random password in MySQL
It’s very simple to generate random password in MySQL. Here is sample MySQL query to generate random password. SELECT substring(MD5(RAND()) from 1 for 10) AS password To generate random password I’m going use three MySQL functions 1. RAND() 2. MD5()….. Read More >>>>
Continue Reading »Find number of affected rows by MySQL UPDATE query in Java
In java executeUpdate() function of Preparedstatement returns integer which gives numbers of rows affected for particular MySQL updation………. Here is the simple code how to access number of affected rows MySQL UPDATE query in Java……….. statement=connection.prepareStatement(“UPDATE login SET user_name ='”+userName+”‘ WHERE id =”+userID+””); int….. Read More >>>>
Continue Reading »