Ehm... posso continuare qui anche se non è per le categorie? Più o meno è la stessa cosa, invece delle categorie è per la gestione delle immagini...

Cooomunque... devo poter caricare delle immagini alle quali assegnare categoria e autore (gestione categoria e autori già fatta e funzionante).

newimage.php
codice:
 <?php
include("include/database.php");

if (isset($_POST['immagine'])): 

  $aid = $_POST['aid'];
  $immagine = $_POST['immagine'];
  $cats = $_POST['cats'];

  if ($aid == '') {
    exit('

You must choose an author for this image. Click "Back" and try again.</p>');
  }

  $sql = "INSERT INTO immagini SET
      immagine='$immagine',
      authorid='$aid'";
  if (mysql_query($sql)) {
    echo '

New image added</p>';
  } else {
    exit('

Error adding new image: ' . mysql_error() . '</p>');
  }

  $jid = mysql_insert_id();

  if (isset($_POST['cats'])) {
    $cats = $_POST['cats'];
  } else {
    $cats = array();
  }

  $numCats = 0;
  foreach ($cats as $catID) {
    $sql = "INSERT IGNORE INTO photocategory
            SET imgid=$jid, categoryid=$catID";
    $ok = mysql_query($sql);
    if ($ok) {
      $numCats = $numCats + 1;
    } else {
      echo "

Error inserting image into category $catID: " .
          mysql_error() . '</p>';
    }
  }
?>



Image was added to <?php echo $numCats; ?> categories.</p>



Add another image</p>


Return to image search</p>

<?php
else: // Allow the user to enter a new image

  $authors = mysql_query('SELECT id, name FROM author');
  if (!$authors) {
    exit('

Unable to obtain author list from the database.</p>');
  }

  $cats = mysql_query('SELECT id, name FROM category');
  if (!$cats) {
    exit('

Unable to obtain category list from the database.</p>');
  }
?>

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">


Enter the new image:

<form enctype="multipart/form-data" action="".$_SERVER['PHP_SELF']."" method="post">
<input type="hidden" name="MAX_FILE_SIZE" value="300000" />
<input type="file" name="immagine" size="40" />




Author:
<select name="aid" size="1">
  <option selected value="">Select One</option>
  <option value="">---------</option>
<?php
  while ($author = mysql_fetch_array($authors)) {
    $aid = $author['id'];
    $aname = htmlspecialchars($author['name']);
    echo "<option value='$aid'>$aname</option>\n";
  }
?>
</select></p>


Place in categories:

<?php
  while ($cat = mysql_fetch_array($cats)) {
    $cid = $cat['id'];
    $cname = htmlspecialchars($cat['name']);
    echo "<label><input type='checkbox' name='cats[]' value='$cid' />$cname</label>
\n";
  }
?>
</p>
<input type="submit" value="SUBMIT" />
</form>
<?php endif; ?>
imglist.php
codice:
<?php
include("include/database.php");

// The basic SELECT statement
$select = 'SELECT DISTINCT id, immagine';
$from   = ' FROM immagini';
$where  = ' WHERE 1=1';

$aid = $_POST['aid'];  line 21
if ($aid != '') { // An author is selected
  $where .= " AND authorid='$aid'";
}

$cid = $_POST['cid']; line 26
if ($cid != '') { // A category is selected
  $from  .= ', photocategory';
  $where .= " AND id=imgid AND categoryid='$cid'";
}
?>



Immagini:
<?php
$imms = mysql_query($select . $from . $where);
if (!$imms) {
  echo '</p>';
  exit('

Error retrieving images from database!
'.
      'Error: ' . mysql_error() . '</p>');
}

while ($imm = mysql_fetch_array($imms)) {
  echo "</p>\n";
  $id = $imm['id'];
  echo "$imm";
  echo "Edit | " .
      "Delete";
  echo "</p>\n";
}
?>
</p>


New search</p>
imgsearch.php
codice:

Insert New Image</p>
<?php
include("include/database.php");

$authors = @mysql_query('SELECT id, name FROM author');
if (!$authors) {
  exit('

Unable to obtain author list from the database.</p>');
}

$cats = @mysql_query('SELECT id, name FROM category');
if (!$cats) {
  exit('

Unable to obtain category list from the database.</p>');
}
?>

<form action="imglist.php" method="post">


View images satisfying the following criteria:</p>
<label>By author:
<select name="aid" size="1">
  <option selected value="">Any Author</option>
<?php
while ($author = mysql_fetch_array($authors)) {
  $aid = $author['id'];
  $aname = htmlspecialchars($author['name']);
  echo "<option value='$aid'>$aname</option>\n"; 
}
?>
</select></label>

<label>By category:
<select name="cid" size="1">
  <option selected value="">Any Category</option>
<?php
while ($cat = mysql_fetch_array($cats)) {
  $cid = $cat['id'];
  $cname = htmlspecialchars($cat['name']);
  echo "<option value='$cid'>$cname</option>\n"; 
}
?>
</select></label>

<input type="submit" value="Search" />
</form>


Return to home page</p>
Allora, gli errori sono:

Notice: undefined index: aid in imglist.php on line 21
Notice: undefined index: cid in imglist.php on line 26

e poi quando eseguo la pagina imglist.php mi da la lista delle immagini ma NON stampa l'immagine, scrive:

Array Edit | Delete

Sicuramente ci sono degli errori perchè era un codice per dei files di testo e io l'ho riadattato per le immagini... ma non so davvero cos'altro fare!