Guest User

Untitled

a guest
Sep 7th, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.99 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "root";
  4. $password = " ";
  5.  
  6. $conn = new mysqli($servername, $username, $password);
  7.  
  8. if ($conn->connect_error) {
  9. die("1: " . $conn->connect_error);
  10. }
  11. echo "2";
  12. ?>
  13.  
  14. <?php
  15. require_once "db.php";
  16. $t = "CREATE TABLE uyeler (
  17. id INT(7) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  18. isim VARCHAR(16) NOT NULL,
  19. kullanici_adi VARCHAR(15) NOT NULL,
  20. sifre VARCHAR(16) NOT NULL,
  21. email VARCHAR(50) NOT NULL,
  22. skype VARCHAR(20) NULL,
  23. uye_tipi enum('Üye','Yönetici','Kurucu') NOT NULL default 'Üye',
  24. UNIQUE KEY email (email),
  25. UNIQUE KEY kullanici_adi (kullanici_adi),
  26. tolpam_indirilme INT(7) NULL,
  27. aylik_indirilme INT(7) NULL,
  28. kayit_tarihi TIMESTAMP
  29. )";
  30.  
  31. $querySonucu = mysql_query($t);
  32.  
  33. if ($querySonucu === TRUE) {print "Basarili!";} else {print "Hata!";}
  34. mysql_close();
  35. ?>
  36.  
  37. <?php
  38. /* Servers configuration */
  39. $i = 0;
  40.  
  41. $cfg['blowfish_secret'] = 'a8b7c6d'; //What you want
  42.  
  43. /* Server: localhost [1] */
  44. $i++;
  45. $cfg['Servers'][$i]['verbose'] = 'Local Databases';
  46. $cfg['Servers'][$i]['host'] = '127.0.0.1';
  47. $cfg['Servers'][$i]['extension'] = 'mysqli';
  48. $cfg['Servers'][$i]['auth_type'] = 'cookie';
  49. $cfg['Servers'][$i]['user'] = '';
  50. $cfg['Servers'][$i]['password'] = '';
  51.  
  52. // Hidden databases in PhpMyAdmin left panel
  53. // $cfg['Servers'][$i]['hide_db'] = '(information_schema|mysql|performance_schema|sys)';
  54.  
  55. // Allow connection without password
  56. $cfg['Servers'][$i]['AllowNoPassword'] = true;
  57.  
  58. // Suppress Warning about pmadb tables
  59. $cfg['PmaNoRelation_DisableWarning'] = true;
  60.  
  61. // To have PRIMARY & INDEX in table structure export
  62. $cfg['Export']['sql_drop_table'] = true;
  63. $cfg['Export']['sql_if_not_exists'] = true;
  64.  
  65. $cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman/5.7/en/';
  66. /* End of servers configuration */
  67. ?>
  68.  
  69. $password = "";
  70.  
  71. $password = " ";
Add Comment
Please, Sign In to add comment