Katalog Script ...
30.10.2006. u 13:00 · pre 243 meseci
#1
Treba mi katalog skripta, tako da ja sam nov sa php i pokusao sam par puta da to napravim sam ali eto nemogu, ako moze neko da mi pomogne sa PHP - kodom, e ovako treba mi, KEY - PRODUCT - OPIS - NOVO - IZABERI - KATEGORIJA - DATUM, evo prezentaciju u html kod:
base.sql
index.htm
base.sql
Code:
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 ;
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
Code:
<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
e sad treba mi celosni php kod za vrijednostima i query u data bazi ...
ako moze neko mi pomoci da ovo zavrsim ...
<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
Code:
$string = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
$key = "";
for($i=0; $i<5; $i++){
$y = rand(0,strlen($string)-1);
$key .= $string[$y]; }
$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 ...
Re: Katalog Script ...