D7PKRzv2

1mysql_query("INSERT INTO testTable VALUES('$ID','".$_SERVER['REMOTE_ADDR']."',NOW(),'Page1','".$_SERVER['HTTP_REFERER']."')"); 
2     
3mysql_query("INSERT INTO testTable VALUES('$ID','".$_SERVER['REMOTE_ADDR']."',NOW(),'Page1')"); 
4     
5CREATE TABLE IF NOT EXISTS `testTable` (
6  `ID` int(11) NOT NULL AUTO_INCREMENT,
7  `ip` varchar(32) DEFAULT NULL,
8  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
9  `Title` varchar(32) NOT NULL,
10  `Ref` varchar(250) NULL default '',
11  PRIMARY KEY (`ID`)
12) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1784 ; 
13     
14$sql = "INSERT INTO testTable(ID, ip, date, Title)
15VALUES('$ID','".$_SERVER['REMOTE_ADDR']."',NOW(),'Page1')"; 
16     
17$sql = "INSERT INTO table (`ip`, `date`, `Title`) VALUES ('".$_SERVER['REMOTE_ADDR']."', NOW(), 'Page 1')"; 
18     
19INSERT INTO table (column1, column2, columns3) VALUES ('$value1', '$value2', '$value3'); 
20     
21insert into testtable values (1,"127.1.1.0",curdate(),"test 1","default"); 
22     
23insert into testtable (id,ip,date,title) values (1,"127.1.1.0",curdate(),"test 1"); 
24     
25insert into testtable (ip,date,title) values ("127.1.1.0",curdate(),"test 1");