Hello everyone!
I'm working on a form that can upload an image on server and add the image name on mysql db. The add page works correctly, the image is uploaded correctly and the image name is inserted on the db. But, the edit page dows not work 🙁 ... When i click on Send option on the edit page and i'm not adding any image, the image db field remains black, and, when i want to upload an image (change the image) via the edit page form, the image is not uploaded and the image db field remains blabk 🙁
Can you help me please?
add page
<?
include('header.php');
include ('includes/uploader.class.php');
$uploader = new uploader();
// Setting properties then Uploading the image
$uploader->destDir = "D:/Program Files/VertrigoServ/www/oldi/imazhet/artikuj/";
$uploader->upload($_FILES['LajmeImg']);
echo '<div class="majtas">';
// Remember any variables incase the form validation finds errors.
$LajmeEmri = $_POST['LajmeEmri'];
$KatLajmeID = $_POST['KatLajmeID']; // Kategoria Lajmeve
$LajmeIntro = $_POST['LajmeIntro'];
$LajmeTxt = $_POST['LajmeTxt'];
$LajmeAktiv = $_POST['LajmeAktiv'];
$LajmeTag = $_POST['LajmeTag'];
$LajmeVideo = $_POST['LajmeVideo'];
//$LajmeImg = $_FILES['LajmeImg']['name']; // Me autoName = False; regjistron ne db emrin real te fotografise
$LajmeImg = $uploader->source['name']; // Me autoName = true; regjistron ne db emrin random te fotografise i gjeneruar ne base64
$LajmeLink = preg_replace("#[^a-z0-9\-_]#i", "",str_replace(' ', '_', $LajmeEmri)); // Ben Url automatikisht nga titulli (LajmeEmri) i lajmit
if(isset($_POST['add_lajme'])) {
$LajmeEmri = $_POST['LajmeEmri'];
$KatLajmeID = $_POST['KatLajmeID']; // Kategoria Lajmeve
$LajmeIntro = $_POST['LajmeIntro'];
$LajmeTxt = $_POST['LajmeTxt'];
$LajmeAktiv = $_POST['LajmeAktiv'];
$LajmeTag = $_POST['LajmeTag'];
$LajmeVideo = $_POST['LajmeVideo'];
//$LajmeImg = $_FILES['LajmeImg']['name']; // Me autoName = False; regjistron ne db emrin real te fotografise
$LajmeImg = $uploader->source['name']; // Me autoName = true; regjistron ne db emrin random te fotografise i gjeneruar ne base64
$LajmeLink = preg_replace("#[^a-z0-9\-_]#i", "",str_replace(' ', '_', $LajmeEmri)); // Ben Url automatikisht nga titulli (LajmeEmri) i lajmit
if(trim($KatLajmeID) == '0') {
$error = '<div class="error_message">Attention! Nuk ke zgjedhur kategorine.</div>';
} else if(trim($LajmeIntro) == '') {
$error = '<div class="error_message">Attention! Nuk ke vene Intro.</div>';
} else if(trim($LajmeEmri) == '') {
$error = '<div class="error_message">Attention! Nuk ke vene emrin.</div>';
}
$count = mysql_num_rows(mysql_query("SELECT * FROM lajme WHERE LajmeLink='".$LajmeLink."'"));
if($count > 0) {
$error = '<div class="error_message">Ky emer/url gjendet ne database.</div>';
}
if($error == '') {
$sql = "INSERT INTO lajme (KatLajmeID, LajmeEmri, LajmeLink, LajmeIntro, LajmeTxt, LajmeAktiv, LajmeTag, LajmeVideo, LajmeImg)
VALUES ('$KatLajmeID', '$LajmeEmri', '$LajmeLink', '$LajmeIntro', '$LajmeTxt', '$LajmeAktiv', '$LajmeTag', '$LajmeVideo', '$LajmeImg')";
$query = mysql_query($sql) or die("Fatal error: ".mysql_error());
echo "<h2>Success!</h2>";
echo "<div class='success_message'>U Shtua me sukses lajmi <b>$LajmeEmri</b> ne kategorine <b>$KatLajmeID</b> .</div>";
echo "<h2>Te Dhenat e Lajmit</h2>";
echo "<ul class='success-reg'>";
echo "<li><span class='success-info'><b>Titulli</b></span>$LajmeEmri</li>";
echo "<li><span class='success-info'><b>Url</b></span>$LajmeLink</li>";
echo "<li><span class='success-info'><b>Kategoria</b></span>$KatLajmeID</li>";
echo "<li><span class='success-info'><b>Aktive</b></span>$LajmeAktiv</li>";
echo "</ul>";
echo "<h2>Cfare deshiron te besh tani?</h2><br />";
echo "Shko tek <a href='lajme_edit.php'>modifikimi i lajmeve</a>.</li>";
}
}
if(!isset($_POST['add_lajme']) || $error != '') {
echo $error;
?>
<h2>Shto Lajme</h2>
<form action="" method="post" enctype="multipart/form-data">
<label style="width: 28%;" for="KatLajmeID">Kategoria</label>
<select id="KatLajmeID" name="KatLajmeID" size="1">
<?php
$query="SELECT * FROM lajme_kategori ";
$result=mysql_query($query);
$num = mysql_num_rows ($result);
mysql_close();
?>
<option selected value="0">Perzgjidh Kategorine</option>
<?
if ($num > 0 ) {
$i=0;
while ($i < $num) {
$LKatID = mysql_result($result,$i,"LKatID");
$LKatEmri = mysql_result($result,$i,"LKatEmri");
$LKatLink = mysql_result($result,$i,"LKatLink");
$LKatAktiv= mysql_result($result,$i,"LKatAktiv");
?>
<option value="<?php echo $LKatID ?>"><?php echo $LKatEmri ?></option>
<?php
++$i; } }
?>
</select>
<script type="text/javascript">
function toggle_LajmeLink(LajmeID) {
if (window.XMLHttpRequest) {
http = new XMLHttpRequest();
} else if (window.ActiveXObject) {
http = new ActiveXObject("Microsoft.XMLHTTP");
}
handle = document.getElementById(LajmeID);
var url = '../ajax.php?';
if(handle.value.length > 0) {
var fullurl = url + 'do=check_LajmeEmri_exists&LajmeEmri=' + encodeURIComponent(handle.value);
http.open("GET", fullurl, true);
http.send(null);
http.onreadystatechange = statechange_LajmeEmri;
}else{
document.getElementById('LajmeEmri').className = '';
}
}
function statechange_LajmeEmri() {
if (http.readyState == 4) {
var xmlObj = http.responseXML;
var html = xmlObj.getElementsByTagName('result').item(0).firstChild.data;
document.getElementById('LajmeEmri').className = html;
}
}
</script>
<label>Titulli</label><input type="text" name="LajmeEmri" value="<?=$LajmeEmri;?>" onchange="toggle_LajmeEmri('LajmeEmri')" width="70%" /><br />
<label>Intro</label><textarea id="LajmeIntro" name="LajmeIntro" value="<?=$LajmeIntro;?>"></textarea>
<script type="text/javascript">
CKEDITOR.replace( 'LajmeIntro',
{
filebrowserBrowseUrl : 'includes/ckfinder/ckfinder.html',
filebrowserImageBrowseUrl : 'includes/ckfinder/ckfinder.html?Type=Images',
filebrowserFlashBrowseUrl : 'includes/ckfinder/ckfinder.html?Type=Flash',
filebrowserUploadUrl : 'includes/ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Files',
filebrowserImageUploadUrl : 'includes/ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Images',
filebrowserFlashUploadUrl : 'includes/ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Flash'
});
</script><br />
<label>Lajmi</label><textarea id="LajmeTxt" name="LajmeTxt" value="<?=$LajmeTxt;?>"></textarea>
<script type="text/javascript">
CKEDITOR.replace( 'LajmeTxt',
{
filebrowserBrowseUrl : 'includes/ckfinder/ckfinder.html',
filebrowserImageBrowseUrl : 'includes/ckfinder/ckfinder.html?Type=Images',
filebrowserFlashBrowseUrl : 'includes/ckfinder/ckfinder.html?Type=Flash',
filebrowserUploadUrl : 'includes/ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Files',
filebrowserImageUploadUrl : 'includes/ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Images',
filebrowserFlashUploadUrl : 'includes/ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Flash'
});
</script><br />
<label>Fotografia</label> <input type="file" size="20" value="<?=$LajmeImg;?>" id="LajmeImg" name="LajmeImg" /><br />
<label>Video</label><textarea id="LajmeVideo" name="LajmeVideo" value="<?=$LajmeVideo;?>" rows="4" wrap="soft" style="width:700px;" /></textarea><br />
<label>Tag</label><input id="LajmeTag" type="text" name="LajmeTag" value="<?=$LajmeTag;?>" /><br />
<label>Aktive</label><input id="LajmeAktiv" name="LajmeAktiv" type="checkbox" value="PO"><br />
<input type="submit" value="Vazhdo" name="add_lajme" />
</form>
<? }
echo '</div>';
include('poshte.php');?>
Continue to next post...
