1
urbanspacema
question on module modification

I have created the code that allows me to load a picture in a folder on the server.I would have to insert the name of the picture loaded inside the db. the voice in table where it goes loaded this name is 'release_image'.

the code that use is this but does not work

file submit.php
include("header.php");
include 
'../mainfile.php'
include_once 
XOOPS_ROOT_PATH.'/class/uploader.php';

//aggiunta

$release_image = isset($_POST['upload_file']) ? $_POST['upload_file'] : array();

//Imposto i tipi di file autorizzati 
$allowed_mimetypes = array('image/gif''image/jpeg''image/pjpeg''image/x-png');
// Massimo peso 
$maxfilesize 100000;
//larghezza e lunghezza
$maxfilewidth 150;
$maxfileheight 150;

//Richiamo la classe uploader e gli passo i parametri inizializzati 
//Nota: il primo parametro è il nome della cartella dove verrà salvato il file. In questo caso la cartella è nella stessa dierctory di questo file
$uploader = new XoopsMediaUploader(XOOPS_ROOT_PATH.'/uploads/copertine'$allowed_mimetypes$maxfilesize$maxfilewidth$maxfileheight);
//imposto un prefisso per l'immagine
$uploader->setPrefix('img');
//Upload del file
if ($uploader->fetchMedia($release_image[0])) {
if (!
$uploader->upload()) {
//Errori?
echo $uploader->getErrors();
} else {
//Tutto OK!
echo 'File caricato con successo!';
echo 
'File salvato come: ' $uploader->getSavedFileName() . '';
echo 
'Path completa: ' $uploader->getSavedDestination(). '';
echo 
'Nome del file: ' $uploader->getMediaName(). '';
echo 
'Tipo di file: ' $uploader->getMediaType(). '';
echo 
'Peso: ' $uploader->getMediaSize(). '';
echo 
'Nome file temporaneo: ' $uploader->getMediaTmpName(). '';
echo 
'Directory dove è stato salvato: ' $uploader->getSavedDestination(). '';}
} else {
echo 
$uploader->getErrors();
}


$myts =& MyTextSanitizer::getInstance();

$xoopsOption['show_rblock'] =0;
include(
XOOPS_ROOT_PATH."/header.php");

//Global $xoopsUser, $xoopsConfig;

$op "submit";

if (isset(
$HTTP_GET_VARS)) {
   foreach (
$HTTP_GET_VARS as $k => $v) {
      $
$k $v;
   }
}

if (isset(
$HTTP_POST_VARS)) {
   foreach (
$HTTP_POST_VARS as $k => $v) {
      $
$k $v;
   }
}

if (!empty(
$contents_preview)) {
   
$myts =& MyTextSanitizer::getInstance();
   
   
//OpenTable();
   
   //echo ""._XD_CATEGORY.": ".$category_id;
        
   
$html = empty($review_nohtml) ? 0;
   
$smiley = empty($review_nosmiley) ? 0;
   
$xcode = empty($review_noxcode) ? 0;
   
$p_title $myts->makeTboxData4Preview($review_title);
   
$p_item $myts->makeTboxData4Preview($review_item);
   
$p_label $myts->makeTboxData4Preview($review_label);
   
$p_release $myts->makeTboxData4Preview($release_date);
   
$p_format $myts->makeTboxData4Preview($release_format);
   
$p_contents $myts->makeTareaData4Preview($review_contents$html$smiley$xcode);
   
$p_image $myts->makeTboxData4PreviewInForm($release_image);

   echo
"
   
   
$p_title
   
$p_item
   
$p_label
   
$p_release
   
$p_format
   
$p_image
   
$p_contents";
   
$review_title $myts->makeTboxData4PreviewInForm($review_title);
   
$review_item $myts->makeTboxData4PreviewInForm($review_item);
   
$review_label $myts->makeTboxData4PreviewInForm($review_label);
   
$release_date $myts->makeTboxData4PreviewInForm($release_date);
   
$release_format $myts->makeTboxData4PreviewInForm($release_format);
   
$release_image $myts->makeTboxData4PreviewInForm($release_image);
   
$review_contents $myts->makeTareaData4PreviewInForm($review_contents);
   include(
"contentsform.php");
   
//CloseTable();
   
include (XOOPS_ROOT_PATH."/footer.php");
   
   exit();
}

if (
$op == "submit") {
   
OpenTable();
   
$myts =& MyTextSanitizer::getInstance();
   
//echo ""._XD_ADDCONTENTS."";
   
$review_title "";
   
$review_contents "";
   
$review_item ="";
   
$review_label ="";
   
$release_date ="";
   
$release_format ="";
   
$release_image "";
   
$review_visible 0;
   
$review_nohtml 0;
   
$review_nosmiley 0;
   
$review_noxcode 0;
   
$review_id 0;
   
$category_id 0;
   
$op "addcontentsgo";
   include(
"contentsform.php");
   
CloseTable();
   include (
XOOPS_ROOT_PATH."/footer.php");
   exit();
}

if (
$op == "addcontentsgo") {
   
OpenTable();
   
$myts =& MyTextSanitizer::getInstance();
   
$title $myts->makeTboxData4Save($review_title);
   
$item $myts->makeTboxData4Save($review_item);
   
$label $myts->makeTboxData4Save($review_label);
   
$release $myts->makeTboxData4Save($release_date);
   
$format $myts->makeTboxData4Save($release_format);
   
$image $myts->makeTboxData4Save($release_image);
   
$contents $myts->makeTareaData4Save($review_contents);   
   
/*
   $result = $xoopsDB->query("SELECT category_id, category_title FROM ".$xoopsDB->prefix("lykos_reviews_categories")."");
   while(list($cat,$cat_title) = $xoopsDB->fetchRow($result)) {
      if($category_id==$cat_title) {
         $category_id=$cat;
      }
   }
   */
   
 
 

   
$category_id $myts->makeTareaData4Save($category_id);   
   if(
$xoopsUser->uid()) {
      
$submitter $xoopsUser->uid();
   } else {
      
$submitter 0;
   }
   
   
$newid $xoopsDB->genId($xoopsDB->prefix("lykos_reviews_contents")."_review_id_seq");
   
$sql "INSERT INTO ".$xoopsDB->prefix("lykos_reviews_contents")." (review_id, category_id, review_title, review_item, review_label, release_date, release_format, release_image, review_contents, review_uid, review_time,  review_visible, review_nohtml, review_nosmiley, review_noxcode) VALUES (".$newid.", ".$category_id.", '".$title."', '".$item."', '".$label."', '".$release."',  '".$format."', '".$image."', '".$contents."', '".$submitter."',".time().",  ".intval($review_visible).", ".intval($review_nohtml).", ".intval($review_nosmiley).", ".intval($review_noxcode).")";
   if (!
$xoopsDB->query($sql)) {
      echo 
"Impossibile aggiungere contenuti";
      
CloseTable();
      include (
XOOPS_ROOT_PATH."/footer.php");
   } else {
      
redirect_header("index.php",1,_XD_DBSUCCESS);
   }
   exit();
}


?>


the file with the form:contentsform.php

echo "";
echo 
"";
echo 
"";
echo 
""._XD_QUESTION.$review_title' size='31' maxlength='255' />";

echo 
""._XD_CATEGORY."category_id">";
$a=0;
$result $xoopsDB->query("SELECT category_id, category_title FROM ".$xoopsDB->prefix("lykos_reviews_categories")."");
while(list(
$cat_id,$cat_title) = $xoopsDB->fetchRow($result)) {
   if(
$cat_id==$category_id) {
      echo 
"$cat_id" selected>$cat_titlen";   
      
$a=1;
   }
   else {
      echo 
"$cat_id">$cat_titlen";
   }
}
if(
$a==1) {
   echo
"[Choose Category]";
}
echo 
"";


echo 
""._XD_ITEM.$review_item' size='31' maxlength='255' />";
echo 
""._XD_LABEL.$review_label' size='31' maxlength='255' />";
echo 
""._XD_RELEASE.$release_date' size='31' maxlength='255' />";
echo 
""._XD_FORMAT.$release_format' size='31' maxlength='255' />";

echo 
"";
echo 
""._XD_IMAGE."$release_image' size='31' maxlength='255' />";
echo 
"";
//oldfield 
echo ".$release_image."' size='31' maxlength='255' />";

echo 
""._XD_AMAZN..$review_amazon."' size='31' maxlength='255' />";
$checked = ($review_visible == 1) ? " checked='checked'" "";
echo 
""._XD_DISPLAY.$checked />";
echo 
""._XD_ANSWER.";

include_once(
XOOPS_ROOT_PATH."/include/xoopscodes.php");

xoopsCodeTarea("review_contents"3920);
xoopsSmilies("review_contents");
$checked = ($review_nohtml == 1) ? " checked='checked'" "";

echo 
"$checked />"._XD_NOHTML."";

$checked = ($review_nosmiley == 1) ? " checked='checked'" "";

echo 
"$checked />"._XD_NOSMILEY."";

$checked = ($review_noxcode == 1) ? " checked='checked'" "";

echo 
"$checked />"._XD_NOXCODE."";
echo 
" .$review_id."' />$op' />._PREVIEW."' /> ._SUBMIT."' />";
echo 
"";
include(
"image_uploader.php");
?>



all the contents of the form come send to db except the name of the picture. Opening the sql file of the database to the place of the name I obtain only an empty space: "" in place of “picture.jpg”. where is the error? Thanks

2
urbanspacema
Re: question on module modification

nothing?

Login

Who's Online

173 user(s) are online (101 user(s) are browsing Support Forums)


Members: 0


Guests: 173


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits