i took that part out and still nothign writes to the db
Pavel Ivanov-2 wrote:
>
> Why should they show up in database if you're deleting it right after
> inserting?
>
> Pavel
>
> On Thu, Nov 12, 2009 at 2:50 PM, perkinsdp
> <bren...@designpilotonline.com> wrote:
>>
>> 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
>>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://old.nabble.com/image-upload-to-db-trouble-tp26325178p26325889.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
