Problem with array database insertion

[johne90]

I am trying to get my upload script for fancyupload to insert file names and sizes into my database, but I have only been able to insert the first file in the queue.

 

The data is organized like this:

$result = array();

$result['time'] = date('r');
$result['addr'] = substr_replace(gethostbyaddr($_SERVER['REMOTE_ADDR']), '******', 0, 6);
$result['agent'] = $_SERVER['HTTP_USER_AGENT'];

if (count($_GET)) {
$result['get'] = $_GET;
}
if (count($_POST)) {
$result['post'] = $_POST;
}
if (count($_FILES)) {
$result['files'] = $_FILES;
}

 

I am trying to insert like this:

$insert = "INSERT INTO images VALUES ('$id', '$title', '".$id."_".$title."', '".$_FILES["Filedata"]["name"]."', '".$_FILES['Filedata']['size']."', '', '', '0', '$timeadded')";
$runit = mysql_query($insert) or die("error");

 

Can someone tell me how to get each file to insert?

[calmchess]

you have to serialize the array first then if you query the array you have to unserialize it to use it ......i think its array_serialize and array_unserialize in the doucmentation

[johne90]

OK, but Im still not sure what to change to get it to insert each image.

[johne90]

I don't think that would work because I need to pull individual values like name and size to insert. Serialize just seems to put all the variables in the array together.

[johne90]

Anyone know a way?