[es] - Katalog Script ...

balkan7

Član broj: 119255
Poruke: 82
85.30.102.*

Profil

^{30.10.2006. u 13:00 - pre 212 meseci}

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

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 ;

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

Code:
$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 ...

Odgovor na temu

shketuljko
Vedran Martinovic
Institut za javno zdravlje Srbije „Dr
Milan Jovanović Batut”
Beograd

Član broj: 1370
Poruke: 43
212.200.118.*

Sajt: www.besplatnioglasi.rs

Profil

Re: Katalog Script ...

^{30.10.2006. u 13:14 - pre 212 meseci}

Napisi malo konkretnije sta ti treba, prvo sto vidim su dve nezavisne tabele ... iz tvoje price mislim da ti trebaju tabela product i za taj product kategoriju? Ako sam u pravu onda treba da vezes tabelu vezom 1 u vise ...
Drugo cini mi se da ova forma nije cijela i da ti treba dosta popravki na njoj ...
Trece pokusaj da formulises pravo pitanje ...

Vedran Martinovic
www.besplatnioglasi.rs

Odgovor na temu

balkan7

Član broj: 119255
Poruke: 82
85.30.102.*

Profil

Re: Katalog Script ...

^{30.10.2006. u 13:28 - pre 212 meseci}

e ovako znaci treba mi prvo kljuc (KEY) za svaki product, pa naziv producta, opis producta, gde sto je select da izabere broj i taj broj da se prkazuje na pocetnu stranu, zaboravio sam da dodam u sql jos novo, to je checkbox i ako je checked da prikazuje NOVO u pocetnu ako nije checked onda da neprikazuje nista, datum, i da izabere u koju ce se prikazati product, sve to da ode preko MySQL ...

mislim da sam objasnio ...

Odgovor na temu

shketuljko
Vedran Martinovic
Institut za javno zdravlje Srbije „Dr
Milan Jovanović Batut”
Beograd

Član broj: 1370
Poruke: 43
212.200.118.*

Sajt: www.besplatnioglasi.rs

Profil

Re: Katalog Script ...

^{30.10.2006. u 13:50 - pre 212 meseci}

Iskreno, ja te ne razumijem!

Vedran Martinovic
www.besplatnioglasi.rs

Odgovor na temu

balkan7

Član broj: 119255
Poruke: 82
85.30.102.*

Profil

Re: Katalog Script ...

^{30.10.2006. u 14:04 - pre 212 meseci}

evo ti sa slikom

Odgovor na temu

DBELJIC
Dejan Beljic
Ljubovija

Član broj: 14969
Poruke: 36
*.rcub.bg.ac.yu.

Sajt: www.beljic.net

Profil

Re: Katalog Script ...

^{30.10.2006. u 15:04 - pre 212 meseci}

Ako bec imas bazu, probaj PhpMyEdit. PhpMyEdit generise skript za osnovu tabele. Evo linka http://www.phpmyedit.org/

Odgovor na temu

balkan7

Član broj: 119255
Poruke: 82
85.30.102.*

Profil

Re: Katalog Script ...

^{30.10.2006. u 15:12 - pre 212 meseci}

hvala ti za to ali mene treba php kod, mysql vec imam, sve je to ok ali nemogu se snaci sa CHECKBOX kad je CHECKED da prikazuje Novo a ako nije CHECKED ona da neprikazuje nista ali sve to da ide preko MYSQL, isto i za SELECT da izaberes broj i taj broj da se prikazuje na naslovnu, isto tako sve to da ide preko MYSQL ...

sta znaci sve ono sto je
Product Name
Detail
New
Select
Category

sve ove vrijednosti trebaju da se upise u bazi i isto tako treba da se prikazuje ...

Odgovor na temu

balkan7

Član broj: 119255
Poruke: 82
85.30.102.*

Profil

Re: Katalog Script ...

^{30.10.2006. u 16:03 - pre 212 meseci}

napravio sam jedan mali kod ali cudno, mysql zapise samo SIFRA i DATUM, ostale values nezapise u MySQL.
evo kod:

Code:
<?php
include("config.php");
?>

<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title><?php $title; ?></title>
</head>

<body bgcolor="#C0C0C0">

<div align="center">
    <table border="1" width="90%" style="border-left-style: solid; border-left-width: 2px; border-right: 2px solid #FFFFFF; border-top-style: solid; border-top-width: 2px; border-bottom: 2px solid #FFFFFF" cellpadding="0">
        <tr>
            <td bordercolor="#808080"> <p> </p>
            <p> </td>
        </tr>
    </table>
    <table border="1" width="90%" cellpadding="0" style="border-left-style: solid; border-left-width: 2px; border-right: 2px solid #FFFFFF; border-top-style: solid; border-top-width: 2px; border-bottom: 2px solid #FFFFFF">
        <tr>
            <td bordercolor="#808080"> </td>
        </tr>
    </table>
    <table border="0" width="90%" style="border-left-style: solid; border-left-width: 2px; border-right: 2px solid #FFFFFF; border-top-style: solid; border-top-width: 2px; border-bottom: 2px solid #FFFFFF" cellpadding="0">
        <tr>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080" bgcolor="#FF6600" colspan="2">
            <p align="center"><?php echo $add; ?></td>
        </tr>
        <tr>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
            <?php echo $key1; ?></td>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
             <input type="text" name="sifra" size="20" /></td>
        </tr>
        <tr>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
            <?php echo $product1; ?></td>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
             <input type="text" name="program" size="53" /></td>
        </tr>
        <tr>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
            <?php echo $detail1; ?></td>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
 <textarea rows="4" cols="45" name="opis"></textarea></td>
        </tr>
        <tr>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
            <?php echo $new1; ?></td>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
            <input type="checkbox" name="novo"></td>
        </tr>
        <tr>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
            <?php echo $select1; ?></td>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
             <select size="1" name="cd">
            <option value="cd1">1</option>
      <option value="cd3">2</option>
            <option value="cd2">3</option>
            </select></td>
        </tr>
        <tr>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
            <?php echo $category1; ?></td>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
             <select size="1" name="kategorija">
            <option value="1">Name 1</option>
            <option value="2">Name 2</option>
            <option value="3">Name 3</option>
            </select></td>
        </tr>
        <tr>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
            <?php echo $date1; ?></td>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
             <?php echo $datum; ?></td>
        </tr>
        </table>
    <table border="1" width="90%" cellpadding="0" style="border: 2px solid #FFFFFF">
        <tr>
            <td bordercolor="#808080">
            <p align="center"><br>
<form action="add.php" method="post">
<input type="hidden" name="dodaj" value="1">
<input type="submit" name="submit" value="submit">    
<input type="reset" name="submit2" value="Clear"><br>
 </td>
<tr>
<td width="70%" align=right>  <div align="center">
<?php

if(isset($_POST["dodaj"]) == "1") {

$db = mysql_connect("$dbhost", "$dbuser", "$dbpassword")or die("cannot connect server ");
mysql_select_db("$dbname")or die("cannot select DB");

$string = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
$sifra = "";
for($i=0; $i<5; $i++){
    $y = rand(0,strlen($string)-1);
    $sifra .= $string[$y];
}
$program = $_POST["program"];
$opis = $_POST['opis'];
$cd = $_POST['cd'];
$datum = date("d/m/y");
$novo = $_POST['novo'];
$novo = $_POST['kategorija'];

            $query = "INSERT INTO `products` (`id`, `sifra`, `program`, `opis`, `cd`, `datum`, `novo`, `kategorija`) VALUES ('', '$sifra', '$program', '$opis', '$cd', '$datum', '$novo', '$kategorija')" or die('insert into is wrong');
            $result = mysql_query($query,$db);
            print "Product Added Successfull.";
}
?>
 </div></td>

        </tr>
    </table>
</div>

</body>

</html>

Odgovor na temu

Zeljko Mitrovic

Član broj: 3197
Poruke: 81
*.cmbrmaor.covad.net.

+1 Profil

Re: Katalog Script ...

^{30.10.2006. u 16:35 - pre 212 meseci}

Evo ti ispravljeni deo oko unosa samih podataka u bazu, posto si se potrudio da vecinu koda sam napises.

Code:

if (isset($_POST["dodaj"])
{
    $string = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
    $sifra = "";
    for ($i=0; $i<5; $i++) {
        $y = rand(0,strlen($string)-1);
        $sifra .= $string[$y];
    }

    $program = addslashes($_POST['program']);
    $opis = addslashes($_POST['opis']);
    $cd = addslashes($_POST['cd']);
    $datum = date("d/m/y");
    $novo = addslashes($_POST['novo']);
    $kategorija = addslashes($_POST['kategorija']);

    $sql = "INSERT INTO products SET program='".$program."' , opis='".$opis."' , cd='".$cd."' , datum='".$datum."' , novo='".$novo."' , kategorija='".$kategorija."'";
    if (!($result = @mysql_query($sql))) {
        print "Could not run query ($sql) : " . mysql_error();
    } else {
        echo "Product Added Successfull.";
    }
}

Odgovor na temu

balkan7

Član broj: 119255
Poruke: 82
85.30.102.*

Profil

Re: Katalog Script ...

^{30.10.2006. u 16:48 - pre 212 meseci}

ups zaboravio si za konkciju u data bazi:

Code:
$db = mysql_connect("$dbhost", "$dbuser", "$dbpassword")or die("cannot connect server ");
mysql_select_db("$dbname")or die("cannot select DB");

zasto kaze error na { kad je ona dobro postavljena. ?
Parse error: syntax error, unexpected '{' in /home/prerodba/public_html/test/add.php on line 98

Code:
<?php
include("config.php");
?>

<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title><?php $title; ?></title>
</head>

<body bgcolor="#C0C0C0">

<div align="center">
    <table border="1" width="90%" style="border-left-style: solid; border-left-width: 2px; border-right: 2px solid #FFFFFF; border-top-style: solid; border-top-width: 2px; border-bottom: 2px solid #FFFFFF" cellpadding="0">
        <tr>
            <td bordercolor="#808080"> <p> </p>
            <p> </td>
        </tr>
    </table>
    <table border="1" width="90%" cellpadding="0" style="border-left-style: solid; border-left-width: 2px; border-right: 2px solid #FFFFFF; border-top-style: solid; border-top-width: 2px; border-bottom: 2px solid #FFFFFF">
        <tr>
            <td bordercolor="#808080"> </td>
        </tr>
    </table>
    <table border="0" width="90%" style="border-left-style: solid; border-left-width: 2px; border-right: 2px solid #FFFFFF; border-top-style: solid; border-top-width: 2px; border-bottom: 2px solid #FFFFFF" cellpadding="0">
        <tr>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080" bgcolor="#FF6600" colspan="2">
            <p align="center"><?php echo $add; ?></td>
        </tr>
        <tr>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
            <?php echo $key1; ?></td>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
             <input type="text" name="sifra" size="20" /></td>
        </tr>
        <tr>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
            <?php echo $product1; ?></td>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
             <input type="text" name="program" size="53" /></td>
        </tr>
        <tr>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
            <?php echo $detail1; ?></td>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
 <textarea rows="4" cols="45" name="opis"></textarea></td>
        </tr>
        <tr>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
            <?php echo $new1; ?></td>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
            <input type="checkbox" name="novo"></td>
        </tr>
        <tr>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
            <?php echo $select1; ?></td>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
             <select size="1" name="cd">
            <option value="cd1">1</option>
      <option value="cd3">2</option>
            <option value="cd2">3</option>
            </select></td>
        </tr>
        <tr>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
            <?php echo $category1; ?></td>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
             <select size="1" name="kategorija">
            <option value="1">Name 1</option>
            <option value="2">Name 2</option>
            <option value="3">Name 3</option>
            </select></td>
        </tr>
        <tr>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
            <?php echo $date1; ?></td>
            <td style="border-style: solid; border-width: 1px" bordercolor="#808080">
             <?php echo $datum; ?></td>
        </tr>
        </table>
    <table border="1" width="90%" cellpadding="0" style="border: 2px solid #FFFFFF">
        <tr>
            <td bordercolor="#808080">
            <p align="center"><br>
<form action="add.php" method="post">
<input type="hidden" name="dodaj" value="1">
<input type="submit" name="submit" value="submit">    
<input type="reset" name="submit2" value="Clear"><br>
 </td>
<tr>
<td width="70%" align=right>  <div align="center">
<?php
if (isset($_POST["dodaj"])
{
    $string = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
    $sifra = "";
    for ($i=0; $i<5; $i++) {
        $y = rand(0,strlen($string)-1);
        $sifra .= $string[$y];
    }

    $program = addslashes($_POST['program']);
    $opis = addslashes($_POST['opis']);
    $cd = addslashes($_POST['cd']);
    $datum = date("d/m/y");
    $novo = addslashes($_POST['novo']);
    $kategorija = addslashes($_POST['kategorija']);

    $sql = "INSERT INTO products SET program='".$program."' , opis='".$opis."' , cd='".$cd."' , datum='".$datum."' , novo='".$novo."' , kategorija='".$kategorija."'";
    if (!($result = @mysql_query($sql))) {
        print "Could not run query ($sql) : " . mysql_error();
    } else {
        echo "Product Added Successfull.";
    }
}

?>
 </div></td>

        </tr>
    </table>
</div>

</body>

</html>

_{[Ovu poruku je menjao balkan7 dana 30.10.2006. u 18:01 GMT+1]}

Odgovor na temu