renancunha33

Criando um banco SQL em PHP

Apr 13th, 2015
298
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.87 KB | None | 0 0
  1. <?php
  2.  
  3.  
  4. $conexao = mysql_connect("Localhost", "root", "") or die (mysql_error());
  5.  
  6. mysql_query('CREATE DATABASE IF NOT EXISTS BANCO') or die (mysql_error());
  7.  
  8.  
  9. mysql_query('USE BANCO') or die (mysql_error());
  10.  
  11. mysql_query('CREATE TABLE IF NOT EXISTS `DAODS` (
  12.  `ds_nome` varchar(50) NOT NULL,
  13.  `ds_telefone` varchar(15) NOT NULL,
  14.  `cd_login` varchar(30) NOT NULL,
  15.  KEY `cd_login` (`cd_login`)
  16. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  17. ') or die (mysql_error());
  18.  
  19. mysql_query('CREATE TABLE IF NOT EXISTS `LOGIN` (
  20.  `cd_login` varchar(20) NOT NULL,
  21.  `ds_senha` varchar(20) NOT NULL,
  22.  PRIMARY KEY (`cd_login`)
  23. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  24. ') or die (mysql_error());
  25.  
  26.  
  27. mysql_query("ALTER TABLE `DAODS`
  28.  ADD CONSTRAINT `DAODS_ibfk_1` FOREIGN KEY (`cd_login`) REFERENCES `LOGIN` (`cd_login`);") or die (mysql_error());
  29.  
  30. echo "<br>banco criado";
  31. ?>
Advertisement
Add Comment
Please, Sign In to add comment