Guest User

Untitled

a guest
Dec 13th, 2012
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <html>
  2. <head>
  3.     <meta http-equiv="Content-Type"     content="text/html; charset=UTF-8" />
  4. </head>
  5. <body>
  6. <?php
  7.     $MM_cnnMySQL_HOSTNAME = 'localhost';
  8.     $MM_cnnMySQL_DATABASE = '00siteler_bumakine';
  9.     $MM_cnnMySQL_USERNAME = 'root';
  10.     $MM_cnnMySQL_PASSWORD = '';
  11.    
  12.     $MySQL    = mysql_connect($MM_cnnMySQL_HOSTNAME, $MM_cnnMySQL_USERNAME, $MM_cnnMySQL_PASSWORD) or die("hata oluştu...");
  13.     $MySQL_DB = mysql_select_db($MM_cnnMySQL_DATABASE) or die("hata oluştu...");
  14.    
  15.     $SQL = "SELECT DISTINCT kat.kat_adi as ADI FROM kat order by kat.kat_adi collate utf8_turkish_ci";
  16.     $SQL1= "SELECT DISTINCT firma_adi as ADI FROM urunler order by firma_adi collate utf8_turkish_ci";
  17.            
  18.     //mysql_query("set names utf8");
  19.     //mysql_query("SET default-character-set = 'utf8'");
  20.     //mysql_query("SET default-collation     = 'utf8_turkish_ci'");
  21.     //mysql_query("SET collation_connection  = 'utf8_turkish_ci' ");
  22.     //mysql_query("SET collation_database    = 'utf8_turkish_ci' ");
  23.     //mysql_query("SET collation_server      = 'utf8_turkish_ci' ");
  24.     //mysql_query("SET character_set_client    ='utf8' ");
  25.     //mysql_query("SET character_set_connection='utf8' ");
  26.     //mysql_query("SET character_set_results   ='utf8' ");
  27.     //mysql_query("SET character_set_database  ='utf8' ")  
  28.            
  29.     $Rows  = mysql_query($SQL, $MySQL) or die("hata oluştu...");
  30.     $RowsCount = mysql_num_rows($Rows);
  31.     while ( $Row = mysql_fetch_assoc($Rows) ) {
  32.         echo $Row["ADI"] . "<br>";
  33.     }
  34. ?>
  35.  
  36. </body>
  37. </html>
Advertisement
Add Comment
Please, Sign In to add comment