hey guys i have a script where im taking images and uploading to an upload
file on my server ( this part works fine in my code ) i also want it to put
the images into my sqlite3 database which has the table images. Im new to
this and cant seem to figure out why they wont show up in the db.
<?php
$success = 0;
$fail = 0;
$uploaddir = '../uploads/';
for ($i=0;$i<5;$i++)
{
if($_FILES['userfile']['name'][$i])
{
$uploadfile = $uploaddir . basename($_FILES['userfile']['name'][$i]);
$ext = strtolower(substr($uploadfile,strlen($uploadfile)-3,3));
if (preg_match("/(jpg|gif|png|bmp)/",$ext))
{
if (move_uploaded_file($_FILES['userfile']['tmp_name'][$i],
$uploadfile))
{
$success++;
$info= $_POST[desc.$i];
$images=$uploadfile;
$url=$_POST[textfield.$i];
//echo $info;
//echo $images;
$db = new PDO('sqlite: database.sqlite3');
$con = sqlite_open('sqlite: database.sqlite3');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$db->query('sqlite: database.sqlite3', $con);
$db->query ("INSERT INTO images (id, images, info, url)
VALUES ('$i', '$images', '$info', '$url')");
$db->query("DELETE FROM images WHERE id='$i'");
}
else
{
echo "Error Uploading the file. Retry after sometime.\n";
$fail++;
}
}
else
{
$fail++;
}
}
}
echo "<br> Number of files Uploaded:".$success;
echo "<br> Number of files Failed:".$fail;
?>
--
View this message in context:
http://old.nabble.com/image-upload-to-db-trouble-tp26325178p26325178.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
