povezivanje, recordset i insert record sama radio pomocu dw posto nisam bas neki strucnja a i lakse mi bio da to uradi dw umesto da ja kucam...
Problem je sedeci napravio sam formu u kojoj imam unosim 5 podataka(naziv, aparat, slika, datum, status), preko insert record,
u dw, sam povezao polja ali kada potvrdim unos dobijem poruku "Column 'slika' cannot be null "... ok to je uredu i ne treba da bude prazno
To je verovatno problem jer sam ja na kod koji je generisao dw
<form action="<?php echo $editFormAction; ?>" method="POST" enctype="multipart/form-data" name="form1" id="form1">
dodao
<form action="<?php move_uploaded_file($_FILES["slikauneta"]["tmp_name"],"img/" . $_FILES["slikauneta"]['name']);echo $editFormAction; ?>" method="POST" enctype="multipart/form-data" name="form1" id="form1">
da bi upload-ovao sliku.
Takodje me zanima kako da ,umesto putanje sa hdd-a, za sliku stavim putanju na mesto uploada
evo i php-a koji generise dw. Kako da u njemu ispravim gore nevedene greske i da stavim ovu putanju za sliku ...
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $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 unos (naziv, aparat, datum, status) VALUES (%s, %s, %s, %s)",
GetSQLValueString($_POST['naziv'], "text"),
GetSQLValueString($_POST['aparat'], "text"),
GetSQLValueString($_POST['datum'], "date"),
GetSQLValueString(isset($_POST['radiobutton']) ? "true" : "", "defined","1","0"));
mysql_select_db($database_foto, $foto);
$Result1 = mysql_query($insertSQL, $foto) or die(mysql_error());
}
mysql_select_db($database_foto, $foto);
$query_Recordset1 = "SELECT * FROM unos";
$Recordset1 = mysql_query($query_Recordset1, $foto) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
Mozda je bolje da radim skolskim putem???
<?php
$slika = $_FILES["slika"]["name"]
$con = mysql_connect("localhost","foto","****");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}mysql_select_db("my_db", $con);$sql="INSERT INTO person (naziv, aparat, slika...)
VALUES
('$_POST[naziv]','$_POST[apatat]','$_POST[$slika]'........)";if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "Podatci su uneti u bazu";mysql_close($con)
?>