"; if(!strlen($fldsastojci)) $sFormErr .= "The value in field sastojci is required.
"; if(!strlen($fldpriprema)) $sFormErr .= "The value in field priprema is required.
"; if(!strlen($fldkategorija)) $sFormErr .= "The value in field kategorija is required.
"; if(!strlen($fldvegetarijan)) $sFormErr .= "The value in field vegetarijan is required.
"; if(!is_number($fldvegetarijan)) $sFormErr .= "The value in field vegetarijan is incorrect.
"; //------------------------------- // Form Check Event begin // Form Check Event end //------------------------------- if(strlen($sFormErr)) return; } //------------------------------- //------------------------------- // Create SQL statement //------------------------------- switch(strtolower($sAction)) { case "insert": //------------------------------- // Form Insert Event begin // Form Insert Event end //------------------------------- $sSQL = "insert into crokuharica (" . "naziv_recept," . "autor," . "slika," . "opis," . "sastojci," . "priprema," . "napomena," . "kategorija," . "broj_osoba," . "vrijeme_pripreme," . "vegetarijan," . "kalorija," . "datum_kreiranja)" . " values (" . tosql($fldnaziv_recept, "Text") . "," . tosql($fldautor, "Text") . "," . tosql($fldslika, "Text") . "," . tosql($fldopis, "Text") . "," . tosql($fldsastojci, "Text") . "," . tosql($fldpriprema, "Text") . "," . tosql($fldnapomena, "Text") . "," . tosql($fldkategorija, "Text") . "," . tosql($fldbroj_osoba, "Text") . "," . tosql($fldvrijeme_pripreme, "Text") . "," . tosql($fldvegetarijan, "Number") . "," . tosql($fldkalorija, "Text") . "," . tosql($flddatum_kreiranja, "Date") . ")"; break; } //------------------------------- //------------------------------- // Form BeforeExecute Event begin // Form BeforeExecute Event end //------------------------------- //------------------------------- // Execute SQL statement //------------------------------- if(strlen($sFormErr)) return; if($bExecSQL) $db->query($sSQL); header("Location: " . $sActionFileName . $sParams); //------------------------------- // Form Action end //------------------------------- } //=============================== // Display Record Form //------------------------------- function Form_show() { global $db; global $sAction; global $sForm; global $sFileName; global $sFormErr; global $styles; $fldid = ""; $fldnaziv_recept = ""; $fldautor = ""; $fldslika = ""; $fldopis = ""; $fldsastojci = ""; $fldpriprema = ""; $fldnapomena = ""; $fldkategorija = ""; $fldbroj_osoba = ""; $fldvrijeme_pripreme = ""; $fldvegetarijan = ""; $fldkalorija = ""; $flddatum_kreiranja = ""; //------------------------------- // Form Show begin //------------------------------- $sFormTitle = ""; $sWhere = ""; $bPK = true; ?> query($sSQL); $bIsUpdateMode = ($bPK && !($sAction == "insert" && $sForm == "Form") && $db->next_record()); //------------------------------- //------------------------------- // Load all fields into variables from recordset or input parameters //------------------------------- if($bIsUpdateMode) { $flddatum_kreiranja = $db->f("datum_kreiranja"); $fldid = $db->f("id"); $fldslika = $db->f("slika"); //------------------------------- // Load data from recordset when form displayed first time //------------------------------- if($sFormErr == "") { $fldnaziv_recept = $db->f("naziv_recept"); $fldautor = $db->f("autor"); $fldopis = $db->f("opis"); $fldsastojci = $db->f("sastojci"); $fldpriprema = $db->f("priprema"); $fldnapomena = $db->f("napomena"); $fldkategorija = $db->f("kategorija"); $fldbroj_osoba = $db->f("broj_osoba"); $fldvrijeme_pripreme = $db->f("vrijeme_pripreme"); $fldvegetarijan = $db->f("vegetarijan"); $fldkalorija = $db->f("kalorija"); } //------------------------------- // Form ShowEdit Event begin // Form ShowEdit Event end //------------------------------- } else { if($sFormErr == "") { $fldid = tohtml(get_param("id")); $fldvegetarijan= "2"; $flddatum_kreiranja=date("Ymd"); } //------------------------------- // Form ShowInsert Event begin // Form ShowInsert Event end //------------------------------- } //------------------------------- // Form Show Event begin // Form Show Event end //------------------------------- //------------------------------- // Show form field //------------------------------- ?>

naziv_recept
autor
slika	'; // show an upload form to upload and resize an image }else{ echo ' '; } ?>
opis	<?=tohtml($fldopis)?>
sastojci	<?=tohtml($fldsastojci)?>
priprema	<?=tohtml($fldpriprema)?>
napomena	<?=tohtml($fldnapomena)?>
kategorija	$value"; else $option="$value"; echo $option; } } ?>
broj_osoba
vrijeme_pripreme
vegetarijan	".$LOV[$i + 1].""; else $option=" ".$LOV[$i + 1].""; echo $option; } ?>
kalorija