im using a db file, I have one sqlite3 file that i use and edit with sqlite
manager on firefox, the only code i have is what i posted, im sorry if im
misunderstanding but im completely new at using this as of now.
Keith Roberts-4 wrote:
>
> On Thu, 12 Nov 2009, perkinsdp wrote:
>
>> To: sqlite-users@sqlite.org
>> From: perkinsdp <bren...@designpilotonline.com>
>> Subject: [sqlite] image upload to db trouble
>>
>>
>> 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;
>> ?>
>> --
>
> Do you have the create statemnt for your DB please?
>
> Kind Regards,
>
> Keith Roberts
>
> -----------------------------------------------------------------
> Websites:
> http://www.php-debuggers.net
> http://www.karsites.net
> http://www.raised-from-the-dead.org.uk
>
> All email addresses are challenge-response protected with
> TMDA [http://tmda.net]
> -----------------------------------------------------------------
> _______________________________________________
> 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-tp26325178p26325679.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
