Forums

PHP

This topic is locked

timestamp or autodate in PHP forms???

benis arapobi

Posted 24 Dec 2008 14:23:43

has voted

Vote

24 Dec 2008 14:23:43 benis arapobi posted:

Hi,

I have form developed trought wizard in application panel of Dreamweaver. Everything is fine, data are collecting but I need to instert automatic date when is recorded in database. How to do this? I'm setup new field in database called "date" and put field name "timestamp" but when I insert new record field data stay empty.
Can anyone help me or give me some suggestion to automatic insert current date in database?

Here is code...

<pre id=code><font face=courier size=2 id=code><?php require_once('Connections/zap.php'); ?>
<?php
if (!function_exists("GetSQLValueString"

) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""

{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

$theValue = function_exists("mysql_real_escape_string"

? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != ""

? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != ""

? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != ""

? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1"

) {
$insertSQL = sprintf("INSERT INTO radnici (grad_za_koji__konkurisete, radno_mjesto, ime, prezime, spol, adresa, datum_rodzenja, mjesto_rodz, bracno_stanje, telefon, email, stepen_SS, skole_S_skole, naziv_fakulteta, struka, dodatno_skolovanje, dodatne_vjestine, windows_xp, ms_office, internet, ostalo_kompjuter, engleski, njemacki, ostalo_jezik, vozacka_DA, vozacka_NE, vozacka_NE2,radno_iskustvo, preporuke, hobi, nagrade, krivicno_kaznjavani, ukratko_o_sebi) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,%s)",
GetSQLValueString($_POST['grad_za_koji__konkurisete'], "text"

,
GetSQLValueString($_POST['radno_mjesto'], "text"

,
GetSQLValueString($_POST['ime'], "text"

,
GetSQLValueString($_POST['prezime'], "text"

,
GetSQLValueString($_POST['spol'], "text"

,
GetSQLValueString($_POST['adresa'], "text"

,
GetSQLValueString($_POST['datum_rodzenja'], "date"

,
GetSQLValueString($_POST['mjesto_rodz'], "text"

,
GetSQLValueString($_POST['bracno_stanje'], "text"

,
GetSQLValueString($_POST['telefon'], "text"

,
GetSQLValueString($_POST['email'], "text"

,
GetSQLValueString($_POST['stepen_SS'], "text"

,
GetSQLValueString($_POST['skole_S_skole'], "text"

,
GetSQLValueString($_POST['naziv_fakulteta'], "text"

,
GetSQLValueString($_POST['struka'], "text"

,
GetSQLValueString($_POST['dodatno_skolovanje'], "text"

,
GetSQLValueString($_POST['dodatne_vjestine'], "text"

,
GetSQLValueString($_POST['windows_xp'], "text"

,
GetSQLValueString($_POST['ms_office'], "text"

,
GetSQLValueString($_POST['internet'], "text"

,
GetSQLValueString($_POST['ostalo_kompjuter'], "text"

,
GetSQLValueString($_POST['engleski'], "text"

,
GetSQLValueString($_POST['njemacki'], "text"

,
GetSQLValueString($_POST['ostalo_jezik'], "text"

,
GetSQLValueString($_POST['vozacka_DA'], "text"

,
GetSQLValueString($_POST['vozacka_NE'], "text"

,
GetSQLValueString($_POST['vozacka_NE2'], "text"

,
GetSQLValueString($_POST['radno_iskustvo'], "text"

,
GetSQLValueString($_POST['preporuke'], "text"

,
GetSQLValueString($_POST['hobi'], "text"

,
GetSQLValueString($_POST['nagrade'], "text"

,
GetSQLValueString(isset($_POST['krivicno_kaznjavani']) ? "true" : "", "defined","'Y'","'N'"

,
GetSQLValueString($_POST['ukratko_o_sebi'], "text"

);

mysql_select_db($database_zap, $zap);
$Result1 = mysql_query($insertSQL, $zap) or die(mysql_error());

$insertGoTo = "zaposlenje2.html";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}

$colname_Recordset1 = "-1";
if (isset($_GET['adresa'])) {
$colname_Recordset1 = $_GET['adresa'];
}
mysql_select_db($database_zap, $zap);
$query_Recordset1 = sprintf("SELECT grad_za_koji__konkurisete, radno_mjesto, ime, prezime, spol, adresa, datum_rodzenja, mjesto_rodz, bracno_stanje, telefon, email, stepen_SS, skole_S_skole, naziv_fakulteta, struka, dodatno_skolovanje, dodatne_vjestine, windows_xp, ms_office, internet, ostalo_kompjuter, engleski, njemacki, ostalo_jezik, vozacka_DA, vozacka_NE,vozacka_NE2, radno_iskustvo, preporuke, hobi, nagrade, krivicno_kaznjavani, ukratko_o_sebi FROM radnici WHERE adresa = %s", GetSQLValueString($colname_Recordset1, "text"

);
$Recordset1 = mysql_query($query_Recordset1, $zap) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>MOBILMEDIA </title>
<meta name="keywords" content="mobilmedia, sarajevo, hi-fi, hifi, centar, bih, bosna, prodaja, shop, web, elektronika, proizvodi, sony, magnat, quadro, fot, izrada, fotografija, fotografije, slika, print, dimenzije, digitalna, foto oprema, olympus, fotostudio, studio, cijene, najniže, zaposlenje, posao, zarada, jeftino, besplatno, free, katalog, popust, akcija, download, program, video, audio, dvd, tv, lcd, tft, monitor, kompjuter, laptop, pc, naruči, narudzba, tehnika, vodić, kupovina, kupi, klima, bijela tehnika, aparat, panasonic, dell, ibm, nokia, lenovo, distributer, zastupnik, mac audio, auto akustika, pioneer, kamera, nikon, canon, windows, microsoft, hp, halid beslic, kredit, kreditiranje, rate, dostava, kucna" />
<style type="text/css">
td img {display: block;}
.linija_naslov {
border-bottom-width: 1px;
border-bottom-style: solid;
border-bottom-color: #E94F19;
}
</style>
<link href="css.css" rel="stylesheet" type="text/css" />
</head>

<body>
<table border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="left"><a href="index.php"><img name="mm_frontpage_v2_r1_c2" src="img/images/mm_frontpage_v2_r1_c2.gif" width="242" height="97" border="0" id="mm_frontpage_v2_r1_c2" alt="" /></a></div></td>
<td><div align="right"><a href="licesanaslovnice.html"><img src="img/.mm_banner_licesanaslovnice.jpg" width="468" height="60" /></a></div></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="img/images/mm_frontpage_v2_r2_c2.gif" width="713" height="37" border="0" usemap="#Map" />
<map name="Map" id="Map2">
<area shape="rect" coords="8,5,123,35" href="proizvodi.html" />
<area shape="rect" coords="122,12,239,32" href="katalog.html" />
<area shape="rect" coords="240,1,318,36" href="novosti.html" />
<area shape="rect" coords="615,5,707,36" href="kontakt.html" />
<area shape="rect" coords="494,6,614,36" href="foto/index.html" />
<area shape="rect" coords="406,8,496,33" href="zap.php" />
<area shape="rect" coords="327,4,396,34" href="interview.html" />
</map></td>
<td><img src="img/images/mm_frontpage_v2_r2_c5.gif" width="294" height="37" /></td>
</tr>
</table> </td>
</tr>
<tr>
<td colspan="2"><img name="mm_frontpage_v2_r3_c2" src="img/images/mm_frontpage_v2_r3_c2.gif" width="1007" height="6" border="0" id="mm_frontpage_v2_r3_c2" alt="" /></td>
</tr>
<tr>
<td colspan="2"><img name="mm_frontpage_v2_r4_c2" src="img/images/mm_frontpage_v2_r4_c2.gif" width="1007" height="18" border="0" id="mm_frontpage_v2_r4_c2" alt="" /></td>
</tr>
<tr>
<td width="812" valign="top">
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><span class="naslovvv"><br />
Zaposlenje</span></td>
</tr>
<tr>
<td><img src="img/images/mm_frontpage_v2_r9_c2_r9_c2.gif" width="805" height="6" align="left" /></td>
</tr>
<tr>
<td><p> </p>

<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
<input type="hidden" name="date" value="<?php echo $date ?>" />
<table width="475" align="center">
<tr valign="baseline">
<td colspan="3" align="right" valign="top" nowrap="nowrap"><table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td colspan="2" bgcolor="#C5CFD8"><img src="img/images/spacer.gif" width="1" height="5" /></td>
</tr>
<tr>
<td width="70%" height="22" bgcolor="#000000" class="text" style="color: #C5CFD8; font-weight: bold"><div align="left">Mjesto i radno mjesto za koje ste zainteresirani</div></td>
<td width="30%" bgcolor="#C5CFD8"> </td>
</tr>
</table></td>
</tr>
<tr valign="baseline">
<td width="146" align="right" valign="top" nowrap="nowrap"><div align="right">Grad za koji konkurišete:</div></td>
<td colspan="2" valign="top"><div align="left">
<select name="grad_za_koji__konkurisete">
<option value="-" <?php if (!(strcmp("-", ""

)) {echo "SELECTED";} ?>>Izaberi</option>
<option value="sarajevo" <?php if (!(strcmp("sarajevo", ""

)) {echo "SELECTED";} ?>>Sarajevo</option>
<option value="mostar" <?php if (!(strcmp("mostar", ""

)) {echo "SELECTED";} ?>>Mostar</option>
<option value="tuzla" <?php if (!(strcmp("tuzla", ""

)) {echo "SELECTED";} ?>>Tuzla</option>
<option value="zenica" <?php if (!(strcmp("zenica", ""

)) {echo "SELECTED";} ?>>Zenica</option>
<option value="brcko" <?php if (!(strcmp("brcko", ""

)) {echo "SELECTED";} ?>>Brcko</option>
<option value="bijeljina" <?php if (!(strcmp("bijeljina", ""

)) {echo "SELECTED";} ?>>Bijeljina</option>
<option value="capljina" <?php if (!(strcmp("capljina", ""

)) {echo "SELECTED";} ?>>Čapljina</option>
</select>
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Radno mjesto</div></td>
<td colspan="2" valign="top"><div align="left">
<select name="radno_mjesto">
<option value="-" <?php if (!(strcmp("-", ""

)) {echo "SELECTED";} ?>>Izaberi</option>
<option value="trgovac" <?php if (!(strcmp("trgovac", ""

)) {echo "SELECTED";} ?>>Trgovac</option>
<option value="voditelj_poslovnice" <?php if (!(strcmp("voditelj_poslovnice", ""

)) {echo "SELECTED";} ?>>Voditelj poslovnice</option>
<option value="vozac" <?php if (!(strcmp("vozac", ""

)) {echo "SELECTED";} ?>>Vozac</option>
<option value="sikladistar" <?php if (!(strcmp("sikladistar", ""

)) {echo "SELECTED";} ?>>Skladistar</option>
<option value="kreditni_sluzbenik" <?php if (!(strcmp("kreditni_sluzbenik", ""

)) {echo "SELECTED";} ?>>Kreditni sluzbenik</option>
<option value="graficki_dizajner" <?php if (!(strcmp("kreditni_sluzbenik", ""

)) {echo "SELECTED";} ?>>Graficki dizajner</option>
<option value="brand_manager" <?php if (!(strcmp("kreditni_sluzbenik", ""

)) {echo "SELECTED";} ?>>Brand manager</option>
</select>
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"> </td>
<td colspan="2" valign="top"> </td>
</tr>
<tr valign="baseline">
<td colspan="3" align="right" valign="top" nowrap="nowrap"><table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td colspan="2" bgcolor="#C5CFD8"><img src="img/images/spacer.gif" width="1" height="5" /></td>
</tr>
<tr>
<td width="42%" height="22" bgcolor="#000000" class="text" style="color: #C5CFD8; font-weight: bold"><div align="left">Lični podaci</div></td>
<td width="58%" bgcolor="#C5CFD8"> </td>
</tr>
</table></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Ime</div></td>
<td colspan="2" valign="top"><div align="left">
<input type="text" name="ime" value="" size="32" />
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Prezime:</div></td>
<td colspan="2" valign="top"><div align="left">
<input type="text" name="prezime" value="" size="32" />
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Spol:</div></td>
<td colspan="2" valign="top"><div align="left">
<table>
<tr>
<td><input type="radio" name="spol" value="muski" />
muški</td>
</tr>
<tr>
<td><input type="radio" name="spol" value="zenski" />
ženski</td>
</tr>
</table>
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Adresa:</div></td>
<td colspan="2" valign="top"><div align="left">
<input type="text" name="adresa" value="" size="32" />
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Datum rođenja:</div></td>
<td colspan="2" valign="top"><div align="left">
<select name="datum_rodzenjaa" id="datum_rodzenjaa">
<option value="-" <?php if (!(strcmp("-", ""

)) {echo "SELECTED";} ?>>Izaberi</option>
<option value="1992" <?php if (!(strcmp("1992", ""

)) {echo "SELECTED";} ?>>1992</option>
<option value="1991" <?php if (!(strcmp("1991", ""

)) {echo "SELECTED";} ?>>1991</option>
<option value="1990" <?php if (!(strcmp("1990", ""

)) {echo "SELECTED";} ?>>1990</option>
<option value="1989" <?php if (!(strcmp("1989", ""

)) {echo "SELECTED";} ?>>1989</option>
<option value="1988" <?php if (!(strcmp("1988", ""

)) {echo "SELECTED";} ?>>1988</option>

<option value="1987" <?php if (!(strcmp("1987", ""

)) {echo "SELECTED";} ?>>1987</option>
<option value="1986" <?php if (!(strcmp("1986", ""

)) {echo "SELECTED";} ?>>1986</option>
<option value="1985" <?php if (!(strcmp("1985", ""

)) {echo "SELECTED";} ?>>1985</option>
<option value="1984" <?php if (!(strcmp("1984", ""

)) {echo "SELECTED";} ?>>1984</option>
<option value="1983" <?php if (!(strcmp("1983", ""

)) {echo "SELECTED";} ?>>1983</option>
<option value="1982" <?php if (!(strcmp("1982", ""

)) {echo "SELECTED";} ?>>1982</option>
<option value="1981" <?php if (!(strcmp("1981", ""

)) {echo "SELECTED";} ?>>1981</option>
<option value="1980" <?php if (!(strcmp("1980", ""

)) {echo "SELECTED";} ?>>1980</option>
<option value="1979" <?php if (!(strcmp("1979", ""

)) {echo "SELECTED";} ?>>1979</option>
<option value="1978" <?php if (!(strcmp("1978", ""

)) {echo "SELECTED";} ?>>1978</option>
<option value="1977" <?php if (!(strcmp("1977", ""

)) {echo "SELECTED";} ?>>1977</option>
<option value="1976" <?php if (!(strcmp("1976", ""

)) {echo "SELECTED";} ?>>1976</option>
<option value="1975" <?php if (!(strcmp("1975", ""

)) {echo "SELECTED";} ?>>1975</option>
<option value="1974" <?php if (!(strcmp("1974", ""

)) {echo "SELECTED";} ?>>1974</option>
<option value="1973" <?php if (!(strcmp("1973", ""

)) {echo "SELECTED";} ?>>1973</option>
<option value="1972" <?php if (!(strcmp("1972", ""

)) {echo "SELECTED";} ?>>1972</option>
<option value="1971" <?php if (!(strcmp("1971", ""

)) {echo "SELECTED";} ?>>1971</option>
<option value="1970" <?php if (!(strcmp("1970", ""

)) {echo "SELECTED";} ?>>1970</option>
<option value="1969" <?php if (!(strcmp("1969", ""

)) {echo "SELECTED";} ?>>1969</option>
<option value="1968" <?php if (!(strcmp("1968", ""

)) {echo "SELECTED";} ?>>1968</option>
<option value="1967" <?php if (!(strcmp("1967", ""

)) {echo "SELECTED";} ?>>1967</option>
<option value="1966" <?php if (!(strcmp("1966", ""

)) {echo "SELECTED";} ?>>1966</option>
<option value="1965" <?php if (!(strcmp("1965", ""

)) {echo "SELECTED";} ?>>1965</option>
<option value="1964" <?php if (!(strcmp("1964", ""

)) {echo "SELECTED";} ?>>1964</option>
<option value="1963" <?php if (!(strcmp("1963", ""

)) {echo "SELECTED";} ?>>1963</option>
<option value="1962" <?php if (!(strcmp("1962", ""

)) {echo "SELECTED";} ?>>1962</option>
<option value="1961" <?php if (!(strcmp("1961", ""

)) {echo "SELECTED";} ?>>1961</option>
<option value="1960" <?php if (!(strcmp("1960", ""

)) {echo "SELECTED";} ?>>1960</option>
</select>
<br />
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Mjesto rođenja:</div></td>
<td colspan="2" valign="top"><div align="left">
<input type="text" name="mjesto_rodz" value="" size="32" />
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Bračno stanje:</div></td>
<td colspan="2" valign="top"><div align="left">
<table>
<tr>
<td><input type="radio" name="bracno_stanje" value="ozenjen_udata" />
Oženjen/udata</td>
</tr>
<tr>
<td><input type="radio" name="bracno_stanje" value="neozenjen_neudata" />
Neoženjen/neudata</td>
</tr>
</table>
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Telefon:</div></td>
<td colspan="2" valign="top"><div align="left">
<input type="text" name="telefon" value="" size="32" />
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Email:</div></td>
<td colspan="2" valign="top"><div align="left">
<input type="text" name="email" value="" size="32" />
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"> </td>
<td colspan="2" valign="top"> </td>
</tr>
<tr valign="baseline">
<td colspan="3" align="right" valign="top" nowrap="nowrap"><table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td colspan="2" bgcolor="#C5CFD8"><img src="img/images/spacer.gif" width="1" height="5" /></td>
</tr>
<tr>
<td width="42%" height="22" bgcolor="#000000" class="text" style="color: #C5CFD8; font-weight: bold"><div align="left">Podaci o obrazovanju</div></td>
<td width="58%" bgcolor="#C5CFD8"> </td>
</tr>
</table></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Stepen stručne spreme:</div></td>
<td colspan="2" valign="top"><div align="left">
<select name="stepen_SS">
<option value="-" <?php if (!(strcmp("-", ""

)) {echo "SELECTED";} ?>>Izaberi</option>
<option value="stepen_IV" <?php if (!(strcmp("stepen_IV", ""

)) {echo "SELECTED";} ?>>Stepen IV</option>
<option value="stepen_v" <?php if (!(strcmp("stepen_v", ""

)) {echo "SELECTED";} ?>>Stepen V</option>
<option value="stepen_vi" <?php if (!(strcmp("stepen_vi", ""

)) {echo "SELECTED";} ?>>Stepen VI</option>
<option value="stepen_vii" <?php if (!(strcmp("stepen_vii", ""

)) {echo "SELECTED";} ?>>Stepen VII</option>
<option value="stepen_viii" <?php if (!(strcmp("stepen_viii", ""

)) {echo "SELECTED";} ?>>Stepen VIII</option>
</select>
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Naziv srednje škole:</div></td>
<td colspan="2" valign="top"><div align="left">
<input type="text" name="skole_S_skole" value="" size="32" />
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Naziv fakulteta</div></td>
<td colspan="2" valign="top"><div align="left">
<input type="text" name="naziv_fakulteta" value="" size="32" />
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Struka:</div></td>
<td colspan="2" valign="top"><div align="left">
<input type="text" name="struka" value="" size="32" />
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Dodatno školovanje:</div></td>
<td colspan="2" valign="top"><div align="left">
<input type="text" name="dodatno_skolovanje" value="" size="32" />
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Dodatne vještine:</div></td>
<td colspan="2" valign="top"><div align="left">
<input type="text" name="dodatne_vjestine" value="" size="32" />
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"> </td>
<td colspan="2" valign="top"> </td>
</tr>
<tr valign="baseline">
<td colspan="3" align="right" valign="top" nowrap="nowrap"><table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td colspan="2" bgcolor="#C5CFD8"><img src="img/images/spacer.gif" width="1" height="5" /></td>
</tr>
<tr>
<td width="49%" height="22" bgcolor="#000000" class="text" style="color: #C5CFD8; font-weight: bold"><div align="left">Poznavanje rada na računaru</div></td>
<td width="51%" bgcolor="#C5CFD8"> </td>
</tr>
</table></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Windows XP:</div></td>
<td colspan="2" valign="top"><div align="left">
<table>
<tr>
<td><input type="radio" name="windows_xp" value="lose" />
Loše</td>
</tr>
<tr>
<td><input type="radio" name="windows_xp" value="dobro" />
Dobro</td>
</tr>
<tr>
<td><input type="radio" name="windows_xp" value="odlicno" />
Odlično</td>
</tr>
</table>
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Ms Office:</div></td>
<td colspan="2" valign="top"><div align="left">
<table>
<tr>
<td><input type="radio" name="ms_office" value="lose" />
Lose</td>
</tr>
<tr>
<td><input type="radio" name="ms_office" value="dobro" />
Dobro</td>
</tr>
<tr>
<td><input type="radio" name="ms_office" value="odlicno" />
Odlično</td>
</tr>
</table>
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Internet:</div></td>
<td colspan="2" valign="top"><div align="left">
<table>
<tr>
<td><input type="radio" name="internet" value="lose" />
Lose</td>
</tr>
<tr>
<td><input type="radio" name="internet" value="dobro" />
Dobro</td>
</tr>
<tr>
<td><input type="radio" name="internet" value="odlicno" />
Odlično</td>
</tr>
</table>
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Ostalo:</div></td>
<td colspan="2" valign="top"><div align="left">
<input type="text" name="ostalo_kompjuter" value="" size="32" />
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"> </td>
<td colspan="2" valign="top"> </td>
</tr>
<tr valign="baseline">
<td colspan="3" align="right" valign="top" nowrap="nowrap"><table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td colspan="2" bgcolor="#C5CFD8" style="color: #333333"><img src="img/images/spacer.gif" width="1" height="5" /></td>
</tr>
<tr>
<td width="42%" height="22" bgcolor="#000000" class="text" style="color: #333333; font-weight: bold"><div align="left" style="color: #C5CFD8">Poznavanje stranih jezika</div></td>
<td width="58%" bgcolor="#C5CFD8" style="color: #333333"> </td>
</tr>
</table></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Engleski:</div></td>
<td colspan="2" valign="top"><div align="left">
<table>
<tr>
<td><input type="radio" name="engleski" value="lose" />
Loše</td>
</tr>
<tr>
<td><input type="radio" name="engleski" value="dobro" />
Dobro</td>
</tr>
<tr>
<td><input type="radio" name="engleski" value="odlicno" />
Odlično</td>
</tr>
</table>
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Njemački:</div></td>
<td colspan="2" valign="top"><div align="left">
<table>
<tr>
<td><input type="radio" name="njemacki" value="lose" />
Loše</td>
</tr>
<tr>
<td><input type="radio" name="njemacki" value="dobro" />
Dobro</td>
</tr>
<tr>
<td><input type="radio" name="njemacki" value="odlicno" />
Odlično</td>
</tr>
</table>
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Ostali jezici:</div></td>
<td colspan="2" valign="top"><div align="left">
<input type="text" name="ostalo_jezik" value="" size="32" />
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"> </td>
<td colspan="2" valign="top"> </td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"> </td>
<td colspan="2" valign="top"> </td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Vozačka dozvola:</div></td>
<td colspan="2" valign="top"><div align="left">
<select name="vozacka_DA">
<option value="-" <?php if (!(strcmp("-", ""

)) {echo "SELECTED";} ?>>Izaberi</option>
<option value="" >A</option>
<option value="b" <?php if (!(strcmp("b", ""

)) {echo "SELECTED";} ?>>B</option>
<option value="c" <?php if (!(strcmp("c", ""

)) {echo "SELECTED";} ?>>C</option>
<option value="d" <?php if (!(strcmp("d", ""

)) {echo "SELECTED";} ?>>D</option>
<option value="e" <?php if (!(strcmp("e", ""

)) {echo "SELECTED";} ?>>E</option>
</select>
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><div align="right">Nemam vozačku:</div></td>
<td colspan="2" valign="top"><div align="left">
<input type="checkbox" name="vozacka_NE" value="" />
</div></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right" valign="top"> </td>
<td colspan="2" valign="top"> </td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right" valign="top"> </td>
<td colspan="2" valign="top"> </td>
</tr>
<tr valign="baseline">
<td colspan="3" align="right" valign="top" nowrap="nowrap"><table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td colspan="2" bgcolor="#C5CFD8"><img src="img/images/spacer.gif" width="1" height="5" /></td>
</tr>
<tr>
<td width="42%" height="22" bgcolor="#000000" class="text" style="color: #C5CFD8; font-weight: bold"><div align="left">Radno iskustvo</div></td>
<td width="58%" bgcolor="#C5CFD8"> </td>
</tr>
</table></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right" valign="top"><div align="right">Radno iskustvo:</div></td>
<td colspan="2" valign="top"><div align="left">
<textarea name="radno_iskustvo" cols="50" rows="5"></textarea>
</div></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right" valign="top"><div align="right">Preporuke:</div></td>
<td colspan="2" valign="top"><div align="left">
<textarea name="preporuke" cols="50" rows="5"></textarea>
</div></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right" valign="top"><div align="right">Hobi:</div></td>
<td colspan="2" valign="top"><div align="left">
<textarea name="hobi" cols="50" rows="5"></textarea>
</div></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right" valign="top"><div align="right">Nagrade:</div></td>
<td colspan="2" valign="top"><div align="left">
<textarea name="nagrade" cols="50" rows="5"></textarea>
</div></td>
</tr>
<tr valign="baseline">
<td align="right" valign="top" nowrap="nowrap"><p align="right">Krivično kažnjavani:</p></td>
<td colspan="2" valign="top"><div align="left">
<table>
<tr>
<td><input type="radio" name="krivicno_kaznjavani" value="ne" />
Ne</td>
</tr>
<tr>
<td><input type="radio" name="krivicno_kaznjavani" value="da" />
Da</td>
</tr>
</table>
</div></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right" valign="top"> </td>
<td colspan="2" valign="top"> </td>
</tr>
<tr valign="baseline">
<td colspan="3" align="right" valign="top" nowrap="nowrap"><table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td colspan="2" bgcolor="#C5CFD8"><img src="img/images/spacer.gif" width="1" height="5" /></td>
</tr>
<tr>
<td width="42%" height="22" bgcolor="#000000" class="text" style="color: #C5CFD8; font-weight: bold"><div align="left">Ukratko o sebi</div></td>
<td width="58%" bgcolor="#C5CFD8"> </td>
</tr>
</table></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right" valign="top"><div align="right">Ukratko o sebi:</div></td>
<td colspan="2" valign="top"><div align="left">
<textarea name="ukratko_o_sebi" cols="50" rows="5"></textarea>
</div></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"><label>
<input type="reset" name="Reset" id="button" value="Poništi" />
     </label></td>
<td colspan="2"><input type="submit" value="Pošalji podatke" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td colspan="2"> </td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td width="20"><div align="left">
<input name="vozacka_NE2" type="checkbox" value="" checked="checked" />
</div></td>
<td width="295"><p style="font-style: italic; font-size: 9px; color: #999999">slažem se da periodično dobijam obavještenja o dešavanjima u MobilMediji.</p> </td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1" />
</form>
<p> </p>
<p> </p></td>
</tr>
</table>
<br /></td>
<td width="195" valign="top"><a href="www.mobilmedia.ba/download/Magazin06_mobilmedia.pdf" target="_blank"><img src="img/images/mm_frontpage_v2_r5_c7.jpg" alt="" name="mm_frontpage_v2_r5_c7" width="195" height="543" border="0" align="right" id="mm_frontpage_v2_r5_c7" /></a> </td>
</tr>

<tr>
<td colspan="2" valign="top"><h3 align="left"><img src="img/images/mm_frontpage_v2_r9_c2_r9_c2.gif" width="805" height="6" align="left" /></h3></td>
</tr>
<tr>
<td colspan="2" valign="top"><p><br />
  Hi-Fi Centar d.o.o. Sarajevo,Hifzi Bjelavca 82/2; 71210 Ilidža - Sarajevo<br />
 Tel: 033/770-250; Fax:033/770-254; e-mail: <a href="mailto: "> </a></p>
<p> </p>
<p> </p></td>
</tr>
</table>

<map name="Map" id="Map">
<area shape="rect" coords="337,8,432,33" href="zap.php" /><area shape="rect" coords="437,6,545,36" href="foto/index.html" />
<area shape="rect" coords="554,5,637,36" href="kontakt.html" />
<area shape="rect" coords="257,2,327,37" href="novosti.html" />
<area shape="rect" coords="128,11,234,31" href="katalog.html" />
<area shape="rect" coords="12,7,116,37" href="proizvodi.html" />
</map>
</body>
<script src="www.google-analytics.com/urchin.js" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "UA-4370086-1";
urchinTracker();
</script>
</html>
<?php
mysql_free_result($Recordset1);
?>
</font id=code></pre id=code>

Replies

Alan C

Replied 26 Dec 2008 19:06:33

26 Dec 2008 19:06:33 Alan C replied:

there are a couple of ways that may be of interest - one is now() that gives you the current time/date, you can add that to the database, or if you check out the documentation for mysql you will find that you can set a field to be automatically updated to the current time every time the record is updated.

Sowmiyya Kandasamy

Replied 21 Jan 2009 13:49:44

21 Jan 2009 13:49:44 Sowmiyya Kandasamy replied:

Hi,
wen the form is submitted ,the records ll be inserted into particular table right, on tht time u give the filed name and corresponding values u give this date function,date('Y-m-d'). then the current date ll be automatically inserted in the db... Y we have given like this bcoz, in db the dates are taken into this format only...

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi,

I have form developed trought wizard in application panel of Dreamweaver. Everything is fine, data are collecting but I need to instert automatic date when is recorded in database. How to do this? I'm setup new field in database called "date" and put field name "timestamp" but when I insert new record field data stay empty.
Can anyone help me or give me some suggestion to automatic insert current date in database?

Here is code...

<pre id=code><font face=courier size=2 id=code><?php require_once('Connections/zap.php'); ?>
<?php
if (!function_exists("GetSQLValueString"

) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = ""

{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

$theValue = function_exists("mysql_real_escape_string"

? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != ""

? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != ""

? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != ""

? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != ""

,
GetSQLValueString($_POST['radno_mjesto'], "text"

,
GetSQLValueString($_POST['ime'], "text"

,
GetSQLValueString($_POST['prezime'], "text"

,
GetSQLValueString($_POST['spol'], "text"

,
GetSQLValueString($_POST['adresa'], "text"

,
GetSQLValueString($_POST['datum_rodzenja'], "date"

,
GetSQLValueString($_POST['mjesto_rodz'], "text"

,
GetSQLValueString($_POST['bracno_stanje'], "text"

,
GetSQLValueString($_POST['telefon'], "text"

,
GetSQLValueString($_POST['email'], "text"

,
GetSQLValueString($_POST['stepen_SS'], "text"

,
GetSQLValueString($_POST['skole_S_skole'], "text"

,
GetSQLValueString($_POST['naziv_fakulteta'], "text"

,
GetSQLValueString($_POST['struka'], "text"

,
GetSQLValueString($_POST['dodatno_skolovanje'], "text"

,
GetSQLValueString($_POST['dodatne_vjestine'], "text"

,
GetSQLValueString($_POST['windows_xp'], "text"

,
GetSQLValueString($_POST['ms_office'], "text"

,
GetSQLValueString($_POST['internet'], "text"

,
GetSQLValueString($_POST['ostalo_kompjuter'], "text"

,
GetSQLValueString($_POST['engleski'], "text"

,
GetSQLValueString($_POST['njemacki'], "text"

,
GetSQLValueString($_POST['ostalo_jezik'], "text"

,
GetSQLValueString($_POST['vozacka_DA'], "text"

,
GetSQLValueString($_POST['vozacka_NE'], "text"

,
GetSQLValueString($_POST['vozacka_NE2'], "text"

,
GetSQLValueString($_POST['radno_iskustvo'], "text"

,
GetSQLValueString($_POST['preporuke'], "text"

,
GetSQLValueString($_POST['hobi'], "text"

,
GetSQLValueString($_POST['nagrade'], "text"

,
GetSQLValueString(isset($_POST['krivicno_kaznjavani']) ? "true" : "", "defined","'Y'","'N'"

,
GetSQLValueString($_POST['ukratko_o_sebi'], "text"

);
$Recordset1 = mysql_query($query_Recordset1, $zap) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>MOBILMEDIA </title>
<meta name="keywords" content="mobilmedia, sarajevo, hi-fi, hifi, centar, bih, bosna, prodaja, shop, web, elektronika, proizvodi, sony, magnat, quadro, fot, izrada, fotografija, fotografije, slika, print, dimenzije, digitalna, foto oprema, olympus, fotostudio, studio, cijene, najniže, zaposlenje, posao, zarada, jeftino, besplatno, free, katalog, popust, akcija, download, program, video, audio, dvd, tv, lcd, tft, monitor, kompjuter, laptop, pc, naruči, narudzba, tehnika, vodić, kupovina, kupi, klima, bijela tehnika, aparat, panasonic, dell, ibm, nokia, lenovo, distributer, zastupnik, mac audio, auto akustika, pioneer, kamera, nikon, canon, windows, microsoft, hp, halid beslic, kredit, kreditiranje, rate, dostava, kucna" />
<style type="text/css">
td img {display: block;}
.linija_naslov {
border-bottom-width: 1px;
border-bottom-style: solid;
border-bottom-color: #E94F19;
}
</style>
<link href="css.css" rel="stylesheet" type="text/css" />
</head>

<body>
<table border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="left"><a href="index.php"><img name="mm_frontpage_v2_r1_c2" src="img/images/mm_frontpage_v2_r1_c2.gif" width="242" height="97" border="0" id="mm_frontpage_v2_r1_c2" alt="" /></a></div></td>
<td><div align="right"><a href="licesanaslovnice.html"><img src="img/.mm_banner_licesanaslovnice.jpg" width="468" height="60" /></a></div></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="img/images/mm_frontpage_v2_r2_c2.gif" width="713" height="37" border="0" usemap="#Map" />
<map name="Map" id="Map2">
<area shape="rect" coords="8,5,123,35" href="proizvodi.html" />
<area shape="rect" coords="122,12,239,32" href="katalog.html" />
<area shape="rect" coords="240,1,318,36" href="novosti.html" />
<area shape="rect" coords="615,5,707,36" href="kontakt.html" />
<area shape="rect" coords="494,6,614,36" href="foto/index.html" />
<area shape="rect" coords="406,8,496,33" href="zap.php" />
<area shape="rect" coords="327,4,396,34" href="interview.html" />
</map></td>
<td><img src="img/images/mm_frontpage_v2_r2_c5.gif" width="294" height="37" /></td>
</tr>
</table> </td>
</tr>
<tr>
<td colspan="2"><img name="mm_frontpage_v2_r3_c2" src="img/images/mm_frontpage_v2_r3_c2.gif" width="1007" height="6" border="0" id="mm_frontpage_v2_r3_c2" alt="" /></td>
</tr>
<tr>
<td colspan="2"><img name="mm_frontpage_v2_r4_c2" src="img/images/mm_frontpage_v2_r4_c2.gif" width="1007" height="18" border="0" id="mm_frontpage_v2_r4_c2" alt="" /></td>
</tr>
<tr>
<td width="812" valign="top">
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><span class="naslovvv"><br />
Zaposlenje</span></td>
</tr>
<tr>
<td><img src="img/images/mm_frontpage_v2_r9_c2_r9_c2.gif" width="805" height="6" align="left" /></td>
</tr>
<tr>
<td><p> </p>

<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
<input type="hidden" name="date" value="<?php echo $date ?>" />
<table width="475" align="center">
<tr valign="baseline">
<td colspan="3" align="right" valign="top" nowrap="nowrap"><table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td colspan="2" bgcolor="#C5CFD8"><img src="img/images/spacer.gif" width="1" height="5" /></td>
</tr>
<tr>
<td width="70%" height="22" bgcolor="#000000" class="text" style="color: #C5CFD8; font-weight: bold"><div align="left">Mjesto i radno mjesto za koje ste zainteresirani</div></td>
<td width="30%" bgcolor="#C5CFD8"> </td>
</tr>
</table></td>
</tr>
<tr valign="baseline">
<td width="146" align="right" valign="top" nowrap="nowrap"><div align="right">Grad za koji konkurišete:</div></td>
<td colspan="2" valign="top"><div align="left">
<select name="grad_za_koji__konkurisete">
<option value="-" <?php if (!(strcmp("-", ""