[es] - comment form i mysql

bantu

Član broj: 38670
Poruke: 305
87.250.105.*

+27 Profil

^{30.09.2013. u 15:00 - pre 128 meseci}

Za početak ovdje ima više grešaka nego linija koda, nadam se da si svjestan toga.

ime nije jednako Ime, mislim da ti je u tome probelmm i mislim da će ti se svaki put insertovati i po jedan prazan slog kada se prvi put učita stranica.

Odgovor na temu

CORSA
vlado vuči9nić
eco,viličar
Hrvatska

Član broj: 284929
Poruke: 68
*.adsl.net.t-com.hr.

+9 Profil

Re: comment form i mysql

^{30.09.2013. u 15:32 - pre 128 meseci}

Citat:

bantu:
<html>
<head>
<title>Test komentari</title>
</head>
<body>
<?php
$mysqli = new mysqli("localhost", "root", "pass", "komentari");

if ($mysqli->connect_errno) {
printf("Connect failed: %s\n", $mysqli->connect_error);
exit();
}

if (isset($_POST['komentar'])) {
if ($stmt = $mysqli->prepare("INSERT INTO komentari (komentar, ime, vrijeme) VALUES (?, ?, NOW())")) {

$stmt->bind_param("ss", $_POST['komentar'], $_POST['ime']);
$stmt->execute();

$stmt->close();
}
}
?>
<form action="index.php" method="POST">
<input type="text" name="ime" /><br/>
<textarea name="komentar" rows="10"></textarea>
<br/>
<input type="submit" name="Submit" value="Send" />
</form>
<br/>
<br/>
<?php
if ($result = $mysqli->query("SELECT komentar, DATE_FORMAT(vrijeme, ime,'%d.%m.%Y %H:%i:%S') AS tacno FROM komentari ORDER BY vrijeme DESC")) {
while ($row = $result->fetch_assoc()) {
?>
<hr style="clear: both"/>
<p style="float: left"><?=$row['komentar']?><p/>
<p style="float: right">Vaše ime: <?=$row['ime']?><br/><?=$row['tacno']?><p/><?php

}

$result->free();
}

$mysqli->close();
?>
</body>
</html>

evo,ovako bi to trebalo biti izmjenjeno,no sad se komentar nigdje ne ispisuje. ?!?

Odgovor na temu

bantu

Član broj: 38670
Poruke: 305
..able.dyn.broadband.blic.net.

+27 Profil

Re: comment form i mysql

^{30.09.2013. u 15:45 - pre 128 meseci}

Napravio sam gresku u select-u:

Code:
<!DOCTYPE html>
<html>
    <head>
        <title>Test komentari</title>
        <style type="text/css">
            body {
                background: gray;
            }
        </style>
    </head>
    <body>
<?php

    $mysqli = new mysqli("localhost", "username", "password", "komentari");

    if ($mysqli->connect_errno) {
        printf("Connect failed: %s\n", $mysqli->connect_error);
        exit();
    }

    if (isset($_POST['komentar'])) {
        if ($stmt = $mysqli->prepare("INSERT INTO komentari (komentar, ime, vrijeme) VALUES (?, ?, NOW())")) {

            $stmt->bind_param("ss", $_POST['komentar'], $_POST['ime']);
            $stmt->execute();

            $stmt->close();
        }
    }
?>
        <form action="index.php" method="POST">
            <input type="text" name="ime" /><br/>
            <textarea name="komentar" rows="10"></textarea>
            <br/>
            <input type="submit" name="Submit" value="Send" />
        </form>
        <br/>
        <br/>
<?php
if ($result = $mysqli->query("SELECT komentar, ime, DATE_FORMAT(vrijeme, '%d.%m.%Y %H:%i:%S') AS tacno FROM komentari ORDER BY vrijeme DESC")) {

        while ($row = $result->fetch_assoc()) {
            if ($row['komentar']) {
?>
        <hr style="clear: both"/>
        <p style="float: left"><?=$row['komentar']?><p/>
        <p style="float: right">Vaše ime: <?=$row['ime']?><br/><?=$row['tacno']?><p/>
<?php
            }

        }

    $result->free();
}

    $mysqli->close();
?>
    </body>
</html>

Odgovor na temu