Results 1 to 12 of 12

Thread: MySQL

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    read-only jordan17772's Avatar
    Join Date: May:2008
    Location:
    Posts: 3,197

    MySQL

    , , . . . MySql
    default-character-set=cp1251. phpmyadmin cp1251_generali_cp.

    - .

    index.php ->

    <?php
    include ("blocks/bd.php"); /* */

    $result = mysql_query("SELECT title,meta_d,meta_k,text FROM settings WHERE page='index'",$db);

    $myrow = mysql_fetch_array($result);

    ?>



    bd.php->

    <?php
    $db = mysql_connect ("localhost","php","11111");
    mysql_select_db("phpsite01",$db);

    ?>

    text ( )



    index.php , windows-1251 (cp1251) , .

    ... !

    PHP - php.ini default_charset = "windows-1251" , :\

    //edit : , !
    Last edited by jordan17772; 9th August 2008 at 15:16.
    AMD Phenom II X4 980 Black @4GHz with 1.425v |GA-MA790FX-UD5P| Prolimatech Megahalems + Noctua NF-S12B-FLX |EVGA GeForce GTX 1060 SSC 6GB ACX 3.0 | 42GB G.Skill F2-8000CL5D-4GBPQ | 1TB + 640GB WD Black | Seasonic X750 Gold | CM 690 II Advanced Black | Logitech Wave Pro | Edifier R1850DB

  2. #2
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    , View->Character Encoding, Windows1251, .

    bd.php
    mysql_query("SET NAMES 'cp1251'", $db);
    .

  3. #3
    read-only jordan17772's Avatar
    Join Date: May:2008
    Location:
    Posts: 3,197
    tedych !

    Last edited by jordan17772; 9th August 2008 at 15:06.
    AMD Phenom II X4 980 Black @4GHz with 1.425v |GA-MA790FX-UD5P| Prolimatech Megahalems + Noctua NF-S12B-FLX |EVGA GeForce GTX 1060 SSC 6GB ACX 3.0 | 42GB G.Skill F2-8000CL5D-4GBPQ | 1TB + 640GB WD Black | Seasonic X750 Gold | CM 690 II Advanced Black | Logitech Wave Pro | Edifier R1850DB

  4. #4
    White awesomeness z0ne's Avatar
    Join Date: Feb:2002
    Location: o
    Posts: 13,331
    . tedych, , - , , . "@", , . . "`" , .

    :

    PHP Code:
    $_my_row = @mysql_fetch_array(@mysql_query("SELECT `title`, `meta_d`, `meta_k`, `text` FROM `settings` WHERE `page` = 'index'")); 
    .. "" MySQL. meta title.- , - , - : Diablo 3, JOIN- - Diablo 3 - - { }, , {} .

  5. #5
    Bombera's Avatar
    Join Date: Jul:2001
    Location: 4EVA
    Posts: 13,833
    . . / , . , , . (, , , , , ) , , /. MySQL, . . - .
    Last edited by Bombera; 9th August 2008 at 16:16. Reason:
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|

  6. #6
    read-only jordan17772's Avatar
    Join Date: May:2008
    Location:
    Posts: 3,197
    ,

    <meta name="description" content="<?php echo $myrow['meta_d']; ?>">
    <meta name="keywords" content="<?php echo $myrow['meta_k']; ?>">
    <title><?php echo $myrow['title']; ?></title>

    , . ... . .



    Last edited by jordan17772; 9th August 2008 at 16:24.
    AMD Phenom II X4 980 Black @4GHz with 1.425v |GA-MA790FX-UD5P| Prolimatech Megahalems + Noctua NF-S12B-FLX |EVGA GeForce GTX 1060 SSC 6GB ACX 3.0 | 42GB G.Skill F2-8000CL5D-4GBPQ | 1TB + 640GB WD Black | Seasonic X750 Gold | CM 690 II Advanced Black | Logitech Wave Pro | Edifier R1850DB

  7. #7
    White awesomeness z0ne's Avatar
    Join Date: Feb:2002
    Location: o
    Posts: 13,331
    Quote Originally Posted by jordan17772 View Post
    , ..
    , , - -.

    Quote Originally Posted by jordan17772 View Post
    ... . .
    .

  8. #8
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    .
    , AppSettings, include. , . () , .. , (name,value,cachetime) . serialize() . , . cron jobs .
    , ( ), , 10- .

    title, meta_x, .., , , , , - - .

  9. #9
    's Avatar
    Join Date: Feb:2005
    Location: Sofia
    Posts: 72
    utf8 cp1251

  10. #10
    read-only jordan17772's Avatar
    Join Date: May:2008
    Location:
    Posts: 3,197
    Quote Originally Posted by View Post
    utf8 cp1251
    . utf8 . mysql 1251cp_general_ci. , ..4 ...
    AMD Phenom II X4 980 Black @4GHz with 1.425v |GA-MA790FX-UD5P| Prolimatech Megahalems + Noctua NF-S12B-FLX |EVGA GeForce GTX 1060 SSC 6GB ACX 3.0 | 42GB G.Skill F2-8000CL5D-4GBPQ | 1TB + 640GB WD Black | Seasonic X750 Gold | CM 690 II Advanced Black | Logitech Wave Pro | Edifier R1850DB

  11. #11
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    .
    - , , - PHP5 Unicode. , .

  12. #12
    's Avatar
    Join Date: Feb:2005
    Location: Sofia
    Posts: 72

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |