Færdiggjort

Encoding problem with php-MySQL

Hi guys, Christ is risen!

I have some problems with a php script which is supposed to send unicode text into a database.

The most important problem is described in this projects title:

An article's text is being first extracted from a site which is greek, but when it is stored in the database it becomes transliterated to some sort of extended latin. I have tried SET NAMES 'utf8' and SET CHARACTER SET 'utf8', but when I use that, almost all of the text gets truncated.

I'm attaching the script.

And here are some URLs that the script can use as input:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

Now there are three more things I would like to have from this project:

1) The article of the last link contains a photograph. Can the extraction page be used to also extract and store such photographs together with the article?

2) The source code of the original site contains a span tag with the property: class='headline'. Can the enclosed text be retrieved and stored in a new field of the database table as the title of the article?

3) The time-stamp does not need to be stored in the database.

Thanks for looking.

Evner: Ingeniørarbejde, MySQL, PHP, Projekt Ledelse, Software Arkitektur, Software Testning, Web Hosting, Hjemmeside Management, Hjemmeside Testning

Se mere: kathimerini, a.i.m. property management, time property management, greek projects, encoding, together mysql, mysql sort field, mysql sort, php script last, mysql script utf8, store management project php, php property mysql, php encoding, character problem, tag management, news article database, script headline news, table management php, news headline script, script news headline

Om arbejdsgiveren:
( 33 bedømmelser ) Vrilissia, Greece

Projekt ID: #3327738

Tildelt til:

rafaelg

See private message.

$25.5 USD in 14 dage
(14 bedømmelser)
3.8

6 freelancere byder i gennemsnit $65 på dette job

wwwPHP

See private message.

$8.5 USD in 14 dage
(141 bedømmelser)
4.8
vasiliysorokin

See private message.

$127.5 USD in 14 dage
(2 bedømmelser)
2.3
csdllc

See private message.

$17 USD in 14 dage
(0 bedømmelser)
2.4
ahaah1381

See private message.

$42.5 USD in 14 dage
(0 bedømmelser)
0.0
nithvw

See private message.

$170 USD in 14 dage
(2 bedømmelser)
0.2