Shop-Script и знаки вопроса при импорте базы MySQL

17.06.2009, рубрики: Мелочи | Теги: , , , | 7 022 комментария »

На днях позвонил человек, попросил помочь с кодировкой сайта. Сайт сделан на Shop-Script (интернет магазин). Ситуация такова, сайт хостился у одного хостинг-провайдера, теперь на другом. Был создан дамп базы данных MySQL и импортиран с той же кодировкой сравнения. Итог: вместо латинских букв, знаки вопроса. Игры с кодировками при экспорте базы и импорте успехов не принесли. Оставалось последнее действие, я был полон надежды, что оно поможет. И так, начнем.

В файле: /includes/database/mysql.php находим блок:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
function db_query($s) //database query
{
$res = array();
$res["resource"] = mysql_query($s) or die( db_error()." SQL query : ".$s);
$select_keyword_index    = strpos(strtoupper($s), "SELECT");
$from_keyword_index        = strpos(strtoupper($s), "FROM");
$columns=substr( $s, $select_keyword_index + strlen("SELECT"),
$from_keyword_index - 1 - ( $select_keyword_index + strlen("SELECT") ) + 1 );
$res["columns"]=array();
$column_index = 0;
$columnArray = explode(",", $columns);
foreach($columnArray as $value)
{
if ($asIndex = strpos(strtoupper($value), "AS "))
$columnName=trim(substr($value, $asIndex+2));
else
$columnName=trim($value);
$res["columns"][$columnName] = $column_index;
$column_index++;
}
return $res;
}
[/sourcecode]

И приводим его к такому виду:

[sourcecode language='php']
function db_query($s) //database query
{
$res = array();
$res["resource"] = mysql_query($s) or die( db_error()." SQL query : ".$s);
mysql_query("SET character_set_client=cp1251");
mysql_query("SET character_set_connection=cp1251");
mysql_query("SET character_set_results=cp1251");
$select_keyword_index    = strpos(strtoupper($s), "SELECT");
$from_keyword_index        = strpos(strtoupper($s), "FROM");
$columns=substr( $s, $select_keyword_index + strlen("SELECT"),
$from_keyword_index - 1 - ( $select_keyword_index + strlen("SELECT") ) + 1 );
$res["columns"]=array();
$column_index = 0;
$columnArray = explode(",", $columns);
foreach($columnArray as $value)
{
if ($asIndex = strpos(strtoupper($value), "AS "))
$columnName=trim(substr($value, $asIndex+2));
else
$columnName=trim($value);
$res["columns"][$columnName] = $column_index;
$column_index++;
}
return $res;
}

Ура, получилось. Знаки вопросов пропали, буквы отображаются как нужно.


7 022 комментария на запись “Shop-Script и знаки вопроса при импорте базы MySQL”

  1. 1 EvaHycle сказала в 1:57, 18.03.2021:

    viagra usa prescription

  2. 2 WanceLeawsdape сказала в 3:00, 18.03.2021:

    good credit score range free credit credit score check my credit score credit karma

  3. 3 JaneHycle сказала в 4:19, 18.03.2021:

    cheap kamagra uk

  4. 4 Random Assignments сказала в 6:08, 18.03.2021:

    examination essay writing

  5. 5 spearmaoveria сказала в 6:09, 18.03.2021:

    freecreditscore creditreportgetstats.com — credit score chart boost credit score free annual credit report official site

  6. 6 equaBly сказала в 6:29, 18.03.2021:

    vsdoxycyclinev.com — buy cheap doxycycline

  7. 7 WanceLeawsdape сказала в 6:38, 18.03.2021:

    best credit score how to read credit report annual credit score free business credit report

  8. 8 adotaccuthfaf сказала в 7:13, 18.03.2021:

    free credit report government creditreportuss.com — unfreeze credit report how to increase credit score myfreecreditreport

  9. 9 spearmaoveria сказала в 7:31, 18.03.2021:

    military payday loan paydayadvancetwin.com — payday loans near me defaulted payday loan mypaydayloan relief

  10. 10 WanceLeawsdape сказала в 9:15, 18.03.2021:

    check credit rating highest credit score possible credit score definition credit score check free

  11. 11 adotaccuthfaf сказала в 11:12, 18.03.2021:

    payday loan services payday loan fast payday loan online instantly online loans

  12. 12 beiplyabalse сказала в 11:18, 18.03.2021:

    free credit score online credit report freecreditreportww.com — credit score chart view my credit report truly free credit scores

  13. 13 karthik сказала в 11:21, 18.03.2021:

    The digital workplace is a central working environment that employees can access from anywhere and at any time – whether they’re on the train, in their home office or at the beach. AMAZING POSTAll data is stored in one location and can be accessed quickly and easily. Your employees are freer to determine when and how they work and therefore more efficient. Discover the digital workplace for your company.

  14. 14 KimHycle сказала в 11:21, 18.03.2021:

    dexamethasone 1.5 mg

  15. 15 Situs Togel сказала в 13:50, 18.03.2021:

    Thanks for sharing your info. I really appreciate your efforts and I will be waiting for your further write

    ups thanks once again.

  16. 16 WanceLeawsdape сказала в 14:36, 18.03.2021:

    fast payday loan paydayadvancetwin.com — payday loan lenders online guaranteed payday loan emergency payday loans

  17. 17 equaBly сказала в 16:07, 18.03.2021:

    hcialischeapc.com — viagra and cialis online

  18. 18 AAAAAgmailcom сказала в 17:15, 18.03.2021:

    izpivfuuyyooplv

    webboard.auto.sanook.com/...;ID_MSG=29583274

    maroliver.com/en/452f-iv/...39#comment-78102

    unraveled.net/phpbb/viewt...=6&t=1907992

    amygibbs.co.uk/print-quot...nonce=4c295fa729

    www.rebels-softair.it/for...f=3&t=126014

    naturalbodybuilding.ru/ru...6#comment-261051

    www.bluemountainsfood.com.../topic/vekfvgek/

    www.web-movimento.it/en/v...d=229292#p229292

    naturalbodybuilding.ru/ru...1#comment-261053

    jewelant.wordpress.com/?c...nonce=08a9475524

    unraveled.net/phpbb/viewt...=6&t=1907993

    www.businessinf.com/ro/fo.../73991-cwnkjmcg/

    treasurehuntspokane.com/e...#comment-2046297

    suppliertynews.com/contac...nonce=f2abb83ccb

    spear1340.com/linux/syste...01#comment-72276

    q8mazad.com/vb/showthread...ed=1#post2870452

    webboard.home.sanook.com/...;ID_MSG=29583280

    forum.btcpbrand.com/viewt...f=4&t=896060

    naturalbodybuilding.ru/ru...6#comment-261050

    www.petercolumns.com/detr...b#comment-116131

    johnboyko.com/bio/comment...nonce=ea8d91cc5c

    adminclub.org/showthread...420535#pid420535

    www.game-train.de/index.p...k=view&id=38

    www.game-train.de/index.p...=view&id=543

    forum.fragoria.com/showth...93977#post493977

    spinbotstudio.fr/forum/vi...f=8&t=677639

    xn--n1abdbeg.xn--p1ai/for...086.html#p140086

    xn--l1adgmc.xn--80aaeowim...p=127933#p127933

    xn--l1adgmc.xn--80aaeowim...p=127934#p127934

    www.tmbv.info/vip/index.p...c=660335.new#new

    intersavegame.co.uk/phpBB...=3&t=1716240

    lasertrace.nl/forum/viewt...f=6&t=706378

    forum.moroe.eu/viewtopic.php?f=4&t=54113

    melevistas.com/viewtopic...=4&t=1227124

    oleksy-bau.de/index.php/f...3726—2021#763357

    forkom-ppi.petra.ac.id/fo...f=2&t=188560

    mywork2.ru/speak/viewtopi...f=2&t=158458

    blenderturkiye.com/viewto...=13&t=694964

    www.blenderturkiye.com/vi...=13&t=694932

    www.unraveled.net/phpbb/v...=6&t=1810705

    ffexodus.com/clanforums/v...?f=3&t=78825

    www.blenderturkiye.com/vi...=13&t=694987

    www.tmbv.info/vip/index.p...c=660328.new#new

    adminclub.org/Thread-%D0%...1%82%D1%8C%D1%8E

    protee.guru/viewtopic.php?f=8&t=1448298

    share1s.net/viewtopic.php?f=21&t=1182038

    israelidebate.com/opinion...f=3&t=230211

    onlineblackfriday.net/sho...ad.php?tid=77175

    calvarychapeljoco.com/new...2021-720p#872004

    rsdiva.com/guestbook-sign...01c0152157708531

    share1s.net/viewtopic.php?f=21&t=1182040

    forum.1one.blue/viewtopic...=14&t=135204

    forum.1one.blue/viewtopic...=14&t=135267

    vilia.it/index.php/forum/...720p-1080p#53159

    www.blenderturkiye.com/vi...=13&t=694905

    fourm.erw.app/viewtopic.php?f=4&t=130073

    www.adeat-onlus.org/index...Itemid=178#63275

    www.blenderturkiye.com/vi...=13&t=694947

    www.blenderturkiye.com/vi...=13&t=694941

    www.blenderturkiye.com/vi...=13&t=694931

    ahpwelds.com/forum/viewto...f=10&t=42237

    forum.prasinoi.eu/viewtop...=19&t=566998

    www.blenderturkiye.com/vi...=13&t=694981

    www.wivo-webdesign.nl/for...?p=548567#548567

    ca.gopinball.com/forum/vi...f=6&t=252070

    protee.guru/viewtopic.php?f=8&t=1448299

    share1s.net/viewtopic.php?f=21&t=1182041

    rsdiva.com/guestbook-sign...3423cf0fb123cbff

    www.traffic-funnel.websit...d.php?tid=153270

    apisphera.ru/forum/vopros...sskom-yazyke-21/

    Ваш комментарий ожидает проверки модератора.

  19. 19 KimHycle сказала в 18:29, 18.03.2021:

    where to buy female viagra us

  20. 20 JaneHycle сказала в 19:37, 18.03.2021:

    flomax 0.4 mg tablet

  21. 21 spearmaoveria сказала в 21:04, 18.03.2021:

    credit reporting agency free equifax credit report request how to raise your credit score fast freecreditscore

  22. 22 beiplyabalse сказала в 21:26, 18.03.2021:

    how to get credit report creditreportadvanced.com — free credit score how to check my credit score get free credit score

  23. 23 Roberthiero сказала в 22:28, 18.03.2021:

    «Nice post. I learn something totally new and challenging on sites I stumbleupon on a daily basis. It will always be helpful to read articles from other writers and use a little something from other websites.»

    דירות דיסקרטיות בחיפה

  24. 24 EvaHycle сказала в 4:46, 19.03.2021:

    buy viagra online

  25. 25 spearmaoveria сказала в 5:51, 19.03.2021:

    online credit score credit check what is a good credit score number what is a good credit score number

  26. 26 beiplyabalse сказала в 6:25, 19.03.2021:

    check credit score for free creditscorecheckresults.com — credit score calculator trans union corporation free credit report mint credit score

  27. 27 adotaccuthfaf сказала в 6:43, 19.03.2021:

    ace payday loan payday loan online instantly payday loans payday loan online

  28. 28 WanceLeawsdape сказала в 8:08, 19.03.2021:

    free credit report instant free credit report uk experian credit report free

  29. 29 WanceLeawsdape сказала в 9:10, 19.03.2021:

    unfreeze credit report credit report companies credit score online credit score calculator

  30. 30 spearmaoveria сказала в 11:45, 19.03.2021:

    how do i check my credit score free credit score report how to get free credit report transunion credit report phone number

  31. 31 adotaccuthfaf сказала в 12:21, 19.03.2021:

    get credit report — free credit report fastcheckcreditscores.com — online credit report experian credit get free credit report

  32. 32 spearmaoveria сказала в 14:17, 19.03.2021:

    credit karma com free credit score freecreditscoreses.com — credit score scale free credit report government free credit scores

  33. 33 ionipsy сказала в 14:54, 19.03.2021:

    ponlinecialisk.com — buy cialis cheap

  34. 34 beiplyabalse сказала в 15:59, 19.03.2021:

    intuit credit score how to check my credit score annualcreditreport how to get a free credit report

  35. 35 KegoKibStodeneK сказала в 17:28, 19.03.2021:

    credit scoring national credit report credit report monitor

  36. 36 spearmaoveria сказала в 18:14, 19.03.2021:

    experian business credit report credit karma credit report free annual credit report complaints

  37. 37 beiplyabalse сказала в 18:32, 19.03.2021:

    instant cash payday loan paydaylendersww.com — military payday loan payday loan services cash advance

  38. 38 spearmaoveria сказала в 18:32, 19.03.2021:

    payday loan fast payday loan laws california easy payday loans online online payday

  39. 39 Caydetora сказала в 18:56, 19.03.2021:

    пергидроль для бассейна

  40. 40 spearmaoveria сказала в 21:26, 19.03.2021:

    what is my credit score free credit report gov credit score range

  41. 41 GaoBreeldVen сказала в 0:46, 20.03.2021:

    cialis or kamagra reviews

  42. 42 EvaHycle сказала в 2:54, 20.03.2021:

    best prices for viagra in canada

  43. 43 WanceLeawsdape сказала в 6:30, 20.03.2021:

    what is my credit score creditreportsps.com — credit reporting agency how to improve your credit score free credit score free credit reports

  44. 44 AMN082 сказала в 8:18, 20.03.2021:

    Wonderful goods from you, man. I have understand your stuff previous to and you're just extremely great.

    I really like what you've acquired here, certainly like what you're saying and the way

    in which you say it. You make it entertaining and you still take care of

    to keep it wise. I can not wait to read far more from you.

    This is really a tremendous website.

  45. 45 JaneHycle сказала в 9:16, 20.03.2021:

    buy zentiva hydroxychloroquine

  46. 46 WanceLeawsdape сказала в 9:39, 20.03.2021:

    credit karma credit score free free credit report gov free credit credit score

  47. 47 spearmaoveria сказала в 9:57, 20.03.2021:

    free annual credit report free credit karma uk free annual credit report free what is good credit score

  48. 48 beiplyabalse сказала в 10:51, 20.03.2021:

    turbo credit score free experian credit report how to ck your credit score

  49. 49 Jasondom сказала в 13:15, 20.03.2021:

    как купить на гидре

    зайти на гидру

  50. 50 KegoKibStodeneK сказала в 13:39, 20.03.2021:

    my free credit score what is considered a good credit score myfreecreditreport


Оставить комментарий


  • девять − = три