Imaju dva file-a. Prvi je formular:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Dodaj SMS Poruku</title>
<link href="css_php.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.input {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 8pt;
border: 1px solid #000000;
background-color: #9C9C9C
}
.text_naslov {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
font-weight: bold;
color: #000000;
}
-->
</style>
</head>
<body>
<form name="form1" method="post" action="add_sms1.php">
<table width="468" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr>
<td><table border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td class="text_naslov">.: Ime i Prezime (ili nick): </td>
</tr>
<tr>
<td><input name="ime_nick" type="text" class="input" id="ime_nick" value="" size="20">
</td>
</tr>
<tr>
<td class="text_naslov">.: E-Mail:</td>
</tr>
<tr>
<td><input name="email" type="text" class="input" id="email" size="25"></td>
</tr>
<tr>
<td class="text_naslov">.: SMS Poruka:</td>
</tr>
<tr>
<td><textarea name="sms_pruka" cols="50" rows="6" class="input" id="sms_pruka"></textarea></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="2" cellpadding="0">
<tr>
<td width="100%"><div align="center">
<input name="Submit" type="submit" class="input" value="Submit">
<input name="Reset" type="reset" class="input" value="Reset">
</div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</form>
</body>
</html>
i php file:
<?php
# Provjerava jesu li sva polja popunjena
if (empty($_POST['ime_nick']))
{
echo "Morate unijeti Ime ili Nick !!!<\BR>";
exit;
}
else
{}
if (empty($_POST['email']))
{
echo "Morate unijeti E - mail !!!<\BR>";
exit;
}
else
{}
if (empty($_POST['sms_poruka']))
{
echo "Morate unijeti SMS Poruku !!!<\BR>";
exit;
}
else
{}
# Konektuje se na DB
$veza = @mysql_connect("localhost","root","db_password");
# Provjerava je li konektovanje uspjelo
if (!$veza)
{
echo "Nije moguce uspostaviti vezu sa MySQL bazom podataka !!!";
exit;
}
else
{
echo "Veza sa bazom je uspostavljena !!!<BR>";
}
# Selektuje DB
$select_db = mysql_select_db("root");
# Provjerava je li uspjelo selektovanje DB-a
if (!$select_db)
{
echo "Nije moguce selektovati bazu $db_name !!!<BR>";
}
else
{
echo "Baza root je uspjesno selektovana !!!<BR>";
}
# Upisuje podatke u DB
$dodaj_sms = "INSERT INTO mk_sms_poruke SET" .
"ime_nick='$ime_nick'," .
"email='$email'," .
"sms_poruka='$sms_poruka'," .
"datum=CURDATE()";
# Provjerava jesu li podatci upisani u DB
if (!$dodaj_sms)
{
echo "Podatci nisu upisani u bazu !!!<BR>";
}
else
{
echo "Podatci su uspjesno upisani u bazu<BR>";
}
# Diskonektuje se sa DB
mysql_close ($veza);
?>
Ako neko moze da pogleda malo i da mi kaze gresku.