MYSQL Archive

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 this appliaction youself. At the end of this tutorial

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 yourself. Step 1: create this below table using the below query. [crayon-519e53413a8b7/] Step 2: Create index.php file and add the following html codes to

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() 3. SUBSTRING() where RAND() function generates random numbers between

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……….. [crayon-519e534146bff/] Here is full source……… [crayon-519e53414930a/]      

In multi player gaming development there is requirement like custom user registration and custom user login which is some what tricky in smartfoxserver 2x or smartfoxserver pro.   In smartfoxserver 2x for  custom user registration and login, we need two zones for registration and login. One zone for user registration and another one

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 find rank of the player we need dummy column

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 from the mysql table. MySql functions are 1.NOW() 2.DATE_SUB()