Hi.
I'm looking for a MySQL data extraction > PDF tool. Free would be great,
but cheap would also be acceptable. I'm a webmaster rather than a DB
expert, so please be easy with me - I googled and found lots of stuff,
but it was over my head!


Cheers,
Blago

Blagovest wrote:
> Hi.
> I'm looking for a MySQL data extraction > PDF tool. Free would be great,
> but cheap would also be acceptable. I'm a webmaster rather than a DB
> expert, so please be easy with me - I googled and found lots of stuff,
> but it was over my head!

http://www.fpdf.org/

As each database is designed differently there aren't any general code that
will take the database and push it into a pdf, you need to make your own
little script to fetch the data you need.

--- codeless example ---
/* connect to server and select database */
/* query the data you want and then fetch row by row */
while($row=mysql_fetch_array($resource)) {
/* push the data into the pdf */
}
/* eject the pdf, don't forget to send some header() */
--- eof ---

--

//Aho

J.O. Aho wrote:
> Blagovest wrote:
>> Hi.
>> I'm looking for a MySQL data extraction > PDF tool. Free would be great,
>> but cheap would also be acceptable. I'm a webmaster rather than a DB
>> expert, so please be easy with me - I googled and found lots of stuff,
>> but it was over my head!
>
> http://www.fpdf.org/
>
> As each database is designed differently there aren't any general code that
> will take the database and push it into a pdf, you need to make your own
> little script to fetch the data you need.
>
> --- codeless example ---
> /* connect to server and select database */
> /* query the data you want and then fetch row by row */
> while($row=mysql_fetch_array($resource)) {
> /* push the data into the pdf */
> }
> /* eject the pdf, don't forget to send some header() */
> --- eof ---

Very good, thanks. BUT, is there a program out there that'll help "dummies".

Cheers,
Blago

On Apr 8, 10:56 am, Blagovast <b... [at] ovast.com> wrote:
> J.O. Aho wrote:
> > Blagovest wrote:
> >> Hi.
> >> I'm looking for a MySQL data extraction > PDF tool. Free would be great,
> >> but cheap would also be acceptable. I'm a webmaster rather than a DB
> >> expert, so please be easy with me - I googled and found lots of stuff,
> >> but it was over my head!
>
> >http://www.fpdf.org/
>
> > As each database is designed differently there aren't any general code that
> > will take the database and push it into a pdf, you need to make your own
> > little script to fetch the data you need.
>
> > --- codeless example ---
> > /* connect to server and select database */
> > /* query the data you want and then fetch row by row */
> > while($row=mysql_fetch_array($resource)) {
> > /* push the data into the pdf */
> > }
> > /* eject the pdf, don't forget to send some header() */
> > --- eof ---
>
> Very good, thanks. BUT, is there a program out there that'll help "dummies".
>
> Cheers,
> Blago


Trust me, I'm a dummy. :-)

FPDF really is worth investigating. There's lots of scripts available
on the website, and many of them have good explanations. With a book
for dummies in one hand and the mouse in the other you shouldn't go
too far wrong - but don't sue me!

strawberry wrote:
> On Apr 8, 10:56 am, Blagovast <b... [at] ovast.com> wrote:
>> J.O. Aho wrote:
>>> Blagovest wrote:
>>>> Hi.
>>>> I'm looking for a MySQL data extraction > PDF tool. Free would be great,
>>>> but cheap would also be acceptable. I'm a webmaster rather than a DB
>>>> expert, so please be easy with me - I googled and found lots of stuff,
>>>> but it was over my head!
>>> http://www.fpdf.org/
>>> As each database is designed differently there aren't any general code that
>>> will take the database and push it into a pdf, you need to make your own
>>> little script to fetch the data you need.
>>> --- codeless example ---
>>> /* connect to server and select database */
>>> /* query the data you want and then fetch row by row */
>>> while($row=mysql_fetch_array($resource)) {
>>> /* push the data into the pdf */
>>> }
>>> /* eject the pdf, don't forget to send some header() */
>>> --- eof ---
>> Very good, thanks. BUT, is there a program out there that'll help "dummies".
>>
>> Cheers,
>> Blago
>
>
> Trust me, I'm a dummy. :-)
>
> FPDF really is worth investigating. There's lots of scripts available
> on the website, and many of them have good explanations. With a book
> for dummies in one hand and the mouse in the other you shouldn't go
> too far wrong - but don't sue me!


Cheers! Sounds like I might have a chance with that then.

Blago