base.sql
CREATE TABLE `products` (
`id` int(5) NOT NULL auto_increment,
`key` varchar(25) NOT NULL default '',
`product` varchar(65) NOT NULL default '',
`desc` longtext NOT NULL,
`select` varchar(65) NOT NULL default '',
`date` varchar(25) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
CREATE TABLE `category` (
`id` int(5) NOT NULL auto_increment,
`name1` varchar(65) NOT NULL default '',
`name2` varchar(65) NOT NULL default '',
`name3` varchar(65) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
index.htm
<input type="hidden" name="key" size="53" />
<input type="text" name="product" size="53" />
<textarea rows="4" cols="45" name="desc"></textarea>
<input type="checkbox" name="new" value="new">
<select size="1" name="select">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
</select>
<select size="1" name="category">
<option value="name1">1</option>
<option value="name2">2</option>
<option value="name3">3</option>
</select>
<form action="add.php" method="post">
<input type="submit" name="submit" value="submit">
<input type="reset" name="submit2" value="Clear">
e sad za key imam kod koji generira sam KEY
$string = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
$key = "";
for($i=0; $i<5; $i++){
$y = rand(0,strlen($string)-1);
$key .= $string[$y]; }
e sad treba mi celosni php kod za vrijednostima i query u data bazi ...
ako moze neko mi pomoci da ovo zavrsim ...