Uploading images to MySQL

Hello all,

I'm having a problem inserting photos into my MySQL database.

I have the following form to submit the photos:

===============

<form method="post" action="insertar_casa.php3" enctype="multipart/form-data">
<input type="text" name="text_foto[]" size="25" maxlength="25">
<input type="file" name="foto[]">
<input type="text" name="text_foto[]" size="25" maxlength="25">
<input type="file" name="foto[]">
<input type="text" name="text_foto[]" size="25" maxlength="25">
<input type="file" name="foto[]">
<input type="text" name="text_foto[]" size="25" maxlength="25">
<input type="file" name="foto[]">
<input type="submit" name="Submit" value="Ingresar Datos">
</form>

===============

I'm using the following code for the php processing file "insertar_casa.php3":

===========================================================
<?php

/* Set database variables */

$dbName = "mydatabase";
$pass = "mypassword";

/* Get the amount of photos submitted */

$foto_cuantity = 0;

for ($j=0; $j < 12; $j++) {

if ($foto_size[$j] != 0){
$foto_cuantity++;
print "The name of file number $j is $foto_name[$j].<p>";
}
}

print "The amount of photos you submitted is $foto_cuantity.<p>";

/* Insert each photo and corresponding text into the MySQL Database */

for ($i=0; $i < $foto_cuantity; $i++) {

$PSize = $foto_size[$i];
$mysqlphoto = addslashes(fread(fopen($foto[$i], "r"), $PSize));
mysql_connect("localhost","$dbName","$pass") or die("Unable to connect to MySQL server");
@mysql_select_db($dbName) or die("Unable to select database");
mysql_query("INSERT INTO imagenes (prop_num,titulo,file) VALUES($prop_num,'$text_foto[$i]',$mysqlphoto)");
}
?>

===================================================

But I always get the output "The amount of photos you submitted is O."

Does anyone have any idea why the second script doesn't recognize the uploaded files?

I'm pulling out my already spare amount of hair over this one. Can anybody see any mistakes I've made?

Thanks a million!
Bryan

------------------

One problem that I see with your transfer of the variables is that you are using the variables of $text_foto[] and $foto[] in the first form but then you use $foto_size[] and $foto_name[] without designating those variables from the data from the previous form. Your second page looks correct other than the fact that variables that it is using do not have values for them so the answer would be correct that the amount of photos is "0".

You need to call $text_foto[] and $foto[] in the second page and format them into $foto_size[] and $foto_name[] for use later in the page.

Hope this helps,

Maven

[This message has been edited by mavenman (edited June 05, 2000).]