Mutliple file insert with a single query(loop)

[titusx11_gmail_]

Hi there, could someone please help me, I need to import hundreds pdf's into a mysql database without using a form. I use opendir(), then list all the files in that directory and then try to insert all the files with a single query using a loop I presume?

If someone could please help me it would be greatly appreciated!!

Thanks Graham😕😕

[bradgrafelman]

You mean you actually want to store the binary data inside of the DB? Is there a particular reason you want to do it this way, rather than keeping the files on the filesystem and "indexing" them (or inserting pertinent information such as filename, etc. into the D😎 instead?

[titusx11_gmail_]

Thanks for speedy reply,

Yes, I do want to insert binary data, the pdf's are invoices and statements. There are over a hundred clients and each one gets 2 documents. I use the pdf file name and assign it to the account no which in turn is also the username to log in, that is also how I use the $_SESSION variables to know which pdfs to pull out. If I use the file path in the database, the link displays the actual path at the bottom of the browser window! I don't want that!

Also, how will I be able to send out an email each month for every client with an invoice and statement??

Thank again!!!

[djjjozsi]

path at the bottom of the browser window! I don't want that!

If this is the only reason you store files in a database, then lets get familiar with htaccess folder protection and send the files from you file system by readfile php function.

If you insist that you want to pull down these files from a blob field,
lets say, you creeate 2 links in your profile page after login

<a href="download.php?file=1">Download my attachment 1</a>
<a href="download.php?file=2">Download my attachment 2</a>

In download.php

<?php
session_start();
if ( empty( $_SESSION["userid"] ) )
    die( "You have to log in first..." );
if ( isset( $_GET["file"] ) )
{
    $fieldnames = array( 1 => "pdf_field" , 2 => "DOC_field" );
    if ( in_array( $_GET["file"] , $fieldnames) )
    {
        $f = $fieldnames[$_GET["file"]];
        $sql = sprintf( "select %s FROM tablaname WHERE userid=%d" , $f , $_SESSION["userid"] );
        echo $sql; // test in phpmyadmin
        /*  Here you can fetch the result and make it output to download
		see:  php.net  for  readfile()  mysql_fetch_assoc() mysql_error()  and header()
		*/

} 
else
    die( "invalid field name!" );
} 

?>

in_array()
mysql_fetch_assoc()
readfile()

[titusx11_gmail_]

Ok, .htaccess is not a problem. But exactly how do you propose to do the following: When a client logs-in and goes to their account page, how will I retrieve the correct docs? I know how to access the directory and list all the files inside it. But the the rest is killing me!

[djjjozsi]

if i were you i would make a table called: files
where i save the original_filename , file_type, file_size, and ownerID on upload.

If a user upload a file, file name renamed according to the primary key to prevent file overwrites.

If you need to make the file for download you can easily send a primary key, and could check if the user is the owner of that file.

Also, how will I be able to send out an email each month for every client with an invoice and statement??

Lets say, you have a clients table, where you save the last email_date value.
And then you can track your mailing lists.

[titusx11_gmail_]

Thanks again for the speedy reply, unfortunately there is no upload form, the owner of the business will insert all the files, to do 100's of times with a form upload will be tedious as best. That is why your solution will unfortunately not be that useful.

Any other ideas perhaps??

[djjjozsi]

You should be more specific.
How you can make relations from a couple of files into a client/owner ?

you can list the documents: glob()
and make inserts into the clients table.