Gde gresim?Upisivanje u sql preko formeNapisao sam kod koji bi trebalo da prihvati podatke iz forme i upise u tabelu ali nesto nece da radi
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="description" content="" />
<meta name="keywords" content="" />
<meta name="author" content="" />
<link rel="stylesheet" type="text/css" href="style.css" media="screen" />
<title>1stWebDesigner PHP Template About Page</title>
</head>
<body>
<div id="wrapper">
<?php include('includes/header.php'); ?>
<?php include('includes/nav.php'); ?>
<div id="content">
<?php
if (isset($_POST['submit'])) {
$con = mysql_connect("upisano ispravno","upisano ispravno","upisano ispravno");
// insert into table
mysql_select_db("upisano ispravno", $con);
$sql = "INSERT INTO vlasnici (vlasnikID, Ime, Prezime, Mesto, fixtel, mobtel, brojgrla)
VALUES (NULL, '$_POST[ime]', '$_POST[prezime]', '$_POST[mesto]', '$_POST[fixtel]', '$_POST[mobtel]', '$_POST[brojgrla]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "Uspesno ste upisali korisnika u bazu podataka.";
echo "Upisite novog korisnika";
mysql_close($con);
}
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<p>Ime: <input type="text" name="ime"/></p>
<p>Prezime: <input type="text" name="prezime"/></p>
<p>Mesto: <input type="text" name="mesto"/></p>
<p>Fiksni telefon: <input type="text" name="fixtel"/></p>
<p>Mobilni telefon: <input type="text" name="mobtel"/></p>
<p>Broj grla: <input type="text" name="brojgrla"/></p>
<p><input type="submit" name="submit" value="Upisi"/></p>
</form>
</div> <!-- end #content -->
<?php include('includes/sidebar.php'); ?>
<?php include('includes/footer.php'); ?>
</div> <!-- End #wrapper -->
</body>
</html>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="description" content="" />
<meta name="keywords" content="" />
<meta name="author" content="" />
<link rel="stylesheet" type="text/css" href="style.css" media="screen" />
<title>1stWebDesigner PHP Template About Page</title>
</head>
<body>
<div id="wrapper">
<?php include('includes/header.php'); ?>
<?php include('includes/nav.php'); ?>
<div id="content">
<?php
if (isset($_POST['submit'])) {
$con = mysql_connect("upisano ispravno","upisano ispravno","upisano ispravno");
// insert into table
mysql_select_db("upisano ispravno", $con);
$sql = "INSERT INTO vlasnici (vlasnikID, Ime, Prezime, Mesto, fixtel, mobtel, brojgrla)
VALUES (NULL, '$_POST[ime]', '$_POST[prezime]', '$_POST[mesto]', '$_POST[fixtel]', '$_POST[mobtel]', '$_POST[brojgrla]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "Uspesno ste upisali korisnika u bazu podataka.";
echo "Upisite novog korisnika";
mysql_close($con);
}
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<p>Ime: <input type="text" name="ime"/></p>
<p>Prezime: <input type="text" name="prezime"/></p>
<p>Mesto: <input type="text" name="mesto"/></p>
<p>Fiksni telefon: <input type="text" name="fixtel"/></p>
<p>Mobilni telefon: <input type="text" name="mobtel"/></p>
<p>Broj grla: <input type="text" name="brojgrla"/></p>
<p><input type="submit" name="submit" value="Upisi"/></p>
</form>
</div> <!-- end #content -->
<?php include('includes/sidebar.php'); ?>
<?php include('includes/footer.php'); ?>
</div> <!-- End #wrapper -->
</body>
</html>
To nece da funkcionise ali kad odvojim php kod od forme sve radi. Gde gresim?
Re: Gde gresim?Upisivanje u sql preko forme
