Archive for the ‘MYSQL’ Category

March 8th, 2013 Database, JavaScript, MYSQL, Oracle, PHP, Programming, Scripts No Comments »

How to delete DIV dynamically using JQuery

To download the code – Click Here

To delete or modify HTML contents we need to use JQuery or any other similar scripting methods.

In this example there are 3 DIV's and it can be deleted dynamically. When we click on the [ X ] button the corresponding DIV was deleted and also it send a POST request to delete.php so we can also delete the corresponding user from the database.

Live Demo

 

Read more »

February 2nd, 2013 Database, JavaScript, MYSQL, Oracle, PHP, Programming, Scripts No Comments »

Auto Complete Text box using AJAX in PHP

 

To download code – Click Here

 
To view the live demo please enter your country name.
 
 

Read more »

December 18th, 2012 Database, MYSQL No Comments »

How to change mysql database or table collation

 

You can use the ALTER TABLE/DATABASE SQL statements to convert your data.
 
To set the default character set for a database, use the following statement.
 
ALTER DATABASE <database_name> CHARACTER SET utf8;
 
This does not affect any existing tables, but any future tables created in this database will use utf8 by default.
 
How to change mysql database- table collation
 
For each table you want to convert to utf8, use the following statement.
 
ALTER TABLE <table_name> CONVERT TO CHARACTER SET utf8;
 
This will automatically convert all text columns to utf8.
 

Read more »

  • Calendar

    October 2024
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    2728293031  

  • Categories

  • Archives

    • ►2020 (1)
    • ►2014 (1)
    • ►2013 (100)
    • ►2012 (83)

  • Login