UNOS.HTML
Code:
<html>
<head>
<body>
<form action="unos.php" method="post">
Ime:<input type="text" name="vlasnik"><br>
e-mail: <input type="text" name="email">
<br>
<input type="Submit" value="Unos">
</form>
</body>
</head>
</html>
<html>
<head>
<body>
<form action="unos.php" method="post">
Ime:<input type="text" name="vlasnik"><br>
e-mail: <input type="text" name="email">
<br>
<input type="Submit" value="Unos">
</form>
</body>
</head>
</html>
UNOS.PHP
Code:
<?php
$vlasnik=$_POST['vlasnik'];
$con=odbc_connect('lista','','');
$sql="INSERT INTO adresar (vlasnik) VALUES ('$vlasnik')";
$exc=odbc_exec($con,$sql);
$email=$_POST['email'];
$con=odbc_connect('lista','','');
$sql="INSERT INTO adresar (email) VALUES ('$email')";
$exc=odbc_exec($con,$sql);
if($exc) {print "Informacija je uspešno uneta u bazu.";}
else {print "Greska prilikom unosa.";};
odbc_close($con);
echo "<p><a href=index.html> Povratak </a>";
?>
<?php
$vlasnik=$_POST['vlasnik'];
$con=odbc_connect('lista','','');
$sql="INSERT INTO adresar (vlasnik) VALUES ('$vlasnik')";
$exc=odbc_exec($con,$sql);
$email=$_POST['email'];
$con=odbc_connect('lista','','');
$sql="INSERT INTO adresar (email) VALUES ('$email')";
$exc=odbc_exec($con,$sql);
if($exc) {print "Informacija je uspešno uneta u bazu.";}
else {print "Greska prilikom unosa.";};
odbc_close($con);
echo "<p><a href=index.html> Povratak </a>";
?>
PRIKAZ.HTML
Code:
<html>
<head>
<body>
<form action="prikaz.php" method="get">
<input type="Submit" value="prikazi sve">
</form>
</body>
</head>
</html>
<html>
<head>
<body>
<form action="prikaz.php" method="get">
<input type="Submit" value="prikazi sve">
</form>
</body>
</head>
</html>
PRIKAZ.PHP
Code:
<?php
$con=odbc_connect('lista','','');
$sql="SELECT vlasnik FROM adresar";
$sql="SELECT email FROM adresar";
$exc=odbc_exec($con,$sql);
echo "<table border=1> <tr>
<td>ime</td>
<td>email</td>
</tr>\n";
$nbrow=0;
while(odbc_fetch_row($exc))
{
$nbrow++;
$mail = odbc_result($exc,1);
echo "<tr>
<td>$vlasnik></td>
<td><a href=mailto:$mail>$mail</a></td>
</tr>\n";
}
echo "<tr>
<td>ukupno: $nbrow unosa</td>
</tr>
</table>";
odbc_close($con);
echo "<p><a href=primer1.html> Unos nove adrese </a>";
?>
<?php
$con=odbc_connect('lista','','');
$sql="SELECT vlasnik FROM adresar";
$sql="SELECT email FROM adresar";
$exc=odbc_exec($con,$sql);
echo "<table border=1> <tr>
<td>ime</td>
<td>email</td>
</tr>\n";
$nbrow=0;
while(odbc_fetch_row($exc))
{
$nbrow++;
$mail = odbc_result($exc,1);
echo "<tr>
<td>$vlasnik></td>
<td><a href=mailto:$mail>$mail</a></td>
</tr>\n";
}
echo "<tr>
<td>ukupno: $nbrow unosa</td>
</tr>
</table>";
odbc_close($con);
echo "<p><a href=primer1.html> Unos nove adrese </a>";
?>