Category: 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…
-
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…
-
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…
-
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()…
-
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…
