PDF to mysql

[ulrich]

hello,

i have a customer, who wants his clients to put data online into a pdf-form and then save this data to the database.

getting the data out of mysql and putting it into an pdf isn´t a problem, but i´m not really finding any info on how to submit the strings from the pdf-form to a php that stores it in a database.

are there any solutions? any gnu-stuff available or just licenses for some software???

thanks - ulrich

[[deleted]]

"i have a customer, who wants his clients to put data online into a pdf-form and then save this data to the database."

There are some very sick people on this planet...

"but i´m not really finding any info on how to submit the strings from the pdf-form to a php that stores it in a database."

Did you check out the pfd-lib website?

[Anon]

j'ai besoin d'un scripte qui me donne la possibilite de metre un cours sur un site web sont extention (pdf) est de donne la possibilite a un utilisateur de la telecharger sous cette forme.
merci j'aime bien recevoir la reponce sur mon adresse email qui est la suivante : [e-mail]

ulrich wrote:

hello,

i have a customer, who wants his clients to put data online into a pdf-form and then save this data to the database.

getting the data out of mysql and putting it into an pdf isn´t a problem, but i´m not really finding any info on how to submit the strings from the pdf-form to a php that stores it in a database.

are there any solutions? any gnu-stuff available or just licenses for some software???

thanks - ulrich

[shastry]

Hi,
I had the same stuff as yours.
First I converted that pdf file into html file using a third party tool( I downloaded .pdf2html).once again I converted that html file into text file(i.e Tab Del)which is of tab delimited & contains the fields that are going to stored in Table.

Here is code which I wrote for this stuff..

<?php

if(!$userfile && !$submit)
{
print "<TABLE>
<TH>PPC File Upload</TH>
<TR>
<TD>Select PDF File</TD>
</TR>
<TR><TD>
<FORM enctype=multipart/form-data action=\"$PHP_SELF \" method=\"post\">
<INPUT type=file name=userfile>
<INPUT type=hidden name=MAX_FILE_SIZE value=125000><BR>
</TD>
</TR>

   <TR>
       <TD>
       <INPUT TYPE=\"SUBMIT\" NAME=\"submit\" VALUE=\"SUBMIT\"></TD>      
        </FORM>     
   </TR>

</TABLE>";

}
//submiting data
if($submit)
{
$command="c:/PDFTOHTML/pdftohtml $userfile c:/HTML-TEXT/one.html";
passthru($command);
$Datafile="c:/HTML-TEXT/ones.html";

$command1="c:/TEXT-MYSQL/ext $Datafile";
passthru($command1);

sleep(3);
$Myquery= "LOAD DATA  infile 'c:/progra~1/apache~1/apache/htdocs/jobtracking/data.txt' INTO TABLE ppc_report FIELDS TERMINATED BY '\t' IGNORE 1 LINES";
$Myquery = stripSlashes($Myquery) ;
$Myquery=trim($Myquery);
if(!mysql_query($Myquery)) 
       die("Sorry");          

}
?>

---

-Shastry

[ulrich]

thanks shastry,

great point to start.

u.