Saturday, August 29, 2015
sample tbluser in mysql
--
-- Table structure for table `tbluser`
--
CREATE TABLE IF NOT EXISTS `tbluser` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;
Monday, August 10, 2015
Sunday, August 9, 2015
Form Validation in JavaScript with HTML
Client side form validation usually done with javascript. For the majority of your users, JavaScript form validation will save a lot of time up front, but double-checking the data on the server remains necessary, in case the user has turned JavaScript off.
Form data that typically are checked by a JavaScript could be:
Saturday, August 8, 2015
Sample Select and Edit form in MySQL using PHP
Directory Structure :
1. Create database name registration1 and table tblstudent as code below :
--
-- Table structure for table `tblstudent`
--
drop database if exists registration1;
create database registration1;
use registration1;
DROP TABLE IF EXISTS `tblstudent`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tblstudent` (
`StudentID` int(5) NOT NULL default '0',
`FirstName` varchar(20) character set utf8 default NULL,
`LastName` varchar(20) character set utf8 default NULL,
`Sex` varchar(5) default NULL,
`Email` varchar(50) character set utf8 default NULL,
`Address` varchar(100) character set utf8 default NULL,
`Subject` varchar(50) default NULL,
`Sport` varchar(50) default NULL,
`Fruit` varchar(50) character set utf8 default NULL,
PRIMARY KEY (`StudentID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--------------------------
1. Create database name registration1 and table tblstudent as code below :
--
-- Table structure for table `tblstudent`
--
drop database if exists registration1;
create database registration1;
use registration1;
DROP TABLE IF EXISTS `tblstudent`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tblstudent` (
`StudentID` int(5) NOT NULL default '0',
`FirstName` varchar(20) character set utf8 default NULL,
`LastName` varchar(20) character set utf8 default NULL,
`Sex` varchar(5) default NULL,
`Email` varchar(50) character set utf8 default NULL,
`Address` varchar(100) character set utf8 default NULL,
`Subject` varchar(50) default NULL,
`Sport` varchar(50) default NULL,
`Fruit` varchar(50) character set utf8 default NULL,
PRIMARY KEY (`StudentID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--------------------------
Thursday, August 6, 2015
How to set Label Gaget as Category
-
Labels are a way to easily categorize your posts. When you're writing a post, click Labelson the side and enter the labels you like, separating them with commas. Labels you've used before will show up below, and you can just click them to add them to the post.
- To set label go to layout -> Edit sidebar add Gadget -> Labels
Subscribe to:
Posts (Atom)