Jump to content

Creating a database or... (CAR/TYRE guys take a look)


IamSuchANoob

Recommended Posts

Hello!

 

So, I have a .pdf file which contains information on car tyre parameters (which tyre fits where).

The mission is to have that data to show up on a website for the user to be able to search/view it.

There is around 30 000 entries and before I go and start copying them one by one into my HTML tables or database I would like to know if you guys got any ideas if I can somehow fasten that process (or do it in another way?).

Even better, if you know any kind of API or something that I can just add to website ( example : http://www.michelin.co.uk/ ) that would be great.

I don't want to iframe-lame it.

 

Thank you & have an awesome day!

Link to comment
Share on other sites

Thank you for the answer. I have never done this (PDF->XLSX->CSV). Could you tell me, if this output can be used before I am going to figure out how?

;;;;;;;;;;Rehvide valiku tabel;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
Mark;;Mudel;;;Mootor;;;;;;;Laius Kõrgus ZR;;"R """;;LI;SI;XL e4txc4;;;;;;;;;;;;;;;;;;;;;;;;
Link to comment
Share on other sites

to process a single line like that you can

$str = 'Mark;;Mudel;;;Mootor;;;;;;;Laius Kõrgus ZR;;"R """;;LI;SI;XL e4txc4;;;;;;;;;;;;;;;;;;;;;;;;';
$data = array_filter(str_getcsv($str,';'));  // ignore empty values 
echo '<pre>',print_r($data, true),'</pre>';  // view the data array

which gives

Array
(
    [0] => Mark
    [2] => Mudel
    [5] => Mootor
    [12] => Laius Kõrgus ZR
    [14] => R "
    [16] => LI
    [17] => SI
    [18] => XL e4txc4
)

To process the whole file you use fgetcsv, which is similar.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.