Category: MYSQL

  • , , , ,

    Quiz application Using PHP, jQuery, Ajax, MySQL and HTML5

    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

    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

    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

    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…

  • Find Rank of player in MySQL table

    Find Rank of player in MySQL table

    Mostly in games we have a requirement like to find rank’s of the player in the last week or month. In MySQL there is no default MySQL function to find out rank’s of the player from the player table. To…

  • Date condition in between function MySql Query

    Date condition in between function MySql Query

    Mostly in games we have requirement like information of player, those who are played in the last week. Here is the simple mysql query to check players who are played last week. We use simple mysql function to fetch result…