Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "localhost";
- $username = "root";
- $password = " ";
- $conn = new mysqli($servername, $username, $password);
- if ($conn->connect_error) {
- die("1: " . $conn->connect_error);
- }
- echo "2";
- ?>
- <?php
- require_once "db.php";
- $t = "CREATE TABLE uyeler (
- id INT(7) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
- isim VARCHAR(16) NOT NULL,
- kullanici_adi VARCHAR(15) NOT NULL,
- sifre VARCHAR(16) NOT NULL,
- email VARCHAR(50) NOT NULL,
- skype VARCHAR(20) NULL,
- uye_tipi enum('Üye','Yönetici','Kurucu') NOT NULL default 'Üye',
- UNIQUE KEY email (email),
- UNIQUE KEY kullanici_adi (kullanici_adi),
- tolpam_indirilme INT(7) NULL,
- aylik_indirilme INT(7) NULL,
- kayit_tarihi TIMESTAMP
- )";
- $querySonucu = mysql_query($t);
- if ($querySonucu === TRUE) {print "Basarili!";} else {print "Hata!";}
- mysql_close();
- ?>
- <?php
- /* Servers configuration */
- $i = 0;
- $cfg['blowfish_secret'] = 'a8b7c6d'; //What you want
- /* Server: localhost [1] */
- $i++;
- $cfg['Servers'][$i]['verbose'] = 'Local Databases';
- $cfg['Servers'][$i]['host'] = '127.0.0.1';
- $cfg['Servers'][$i]['extension'] = 'mysqli';
- $cfg['Servers'][$i]['auth_type'] = 'cookie';
- $cfg['Servers'][$i]['user'] = '';
- $cfg['Servers'][$i]['password'] = '';
- // Hidden databases in PhpMyAdmin left panel
- // $cfg['Servers'][$i]['hide_db'] = '(information_schema|mysql|performance_schema|sys)';
- // Allow connection without password
- $cfg['Servers'][$i]['AllowNoPassword'] = true;
- // Suppress Warning about pmadb tables
- $cfg['PmaNoRelation_DisableWarning'] = true;
- // To have PRIMARY & INDEX in table structure export
- $cfg['Export']['sql_drop_table'] = true;
- $cfg['Export']['sql_if_not_exists'] = true;
- $cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman/5.7/en/';
- /* End of servers configuration */
- ?>
- $password = "";
- $password = " ";
Add Comment
Please, Sign In to add comment