Archive for the ‘mysql’ Category

How to store UTF8 (indian language) data in mysql?

Well, let me put it straight this tutorial also applies to any other native languages like latin, spanish etc. But, since I have tried for Indian languages I am writing exclusive for it. Okay, so before we say code I must tell you this tutorial intends, a thought provoking stuff

mysql query

there are total 3 tables tablenames:                                mdl_course_categories                                      mdl_role_assignments                                  mdl_context fields:                                              id  ,    categoryname                                                userid   ,    contextid                                 id  ,   [...]

Drag & Drop with PHP & jQuery

The ability to drag and drop content on a page and have it save the order can make for a great user interface and is actually relatively easy to execute with a few lines of jQuery. Refere this url:  http://papermashup.com/drag-drop-with-php-jquery/

Php Mysql Chat

Php Mysql Simple Chat Create A database named   “chat_old” In That Database Run These two queries ———————————————————————————– CREATE TABLE IF NOT EXISTS `members` ( `memid` varchar(255) NOT NULL, `memname` varchar(30) NOT NULL, PRIMARY KEY  (`memid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE IF NOT EXISTS `members` (  `memid` varchar(255) NOT NULL,  `memname` varchar(30) NOT NULL,  PRIMARY KEY  (`memid`)) [...]

MYSQL commands

CREATE DATABASE CREATE DATABASE database_name ; Will create a MySQL database. You may have to ensure that the user you used to log in has enough privileges to create databases. Some web hosting companies do not allow their customers to create databases — as they have already created a couple databases for you. In this [...]