Advertisement
Ivan_sjc

Inserção

Jan 31st, 2015
345
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.86 KB | None | 0 0
  1. **********************************************************************Arquivo database.php
  2.  
  3. <?php
  4. class Database{
  5.  
  6.     // specify your own database credentials
  7.     private $host = "127.0.0.1";
  8.     private $db_name = "sisim";
  9.     private $username = "root";
  10.     private $password = "";
  11.     public $conn;
  12.  
  13.  
  14.  
  15.  // get the database connection
  16.     public function getConnection(){
  17.  
  18.  
  19.  
  20.         $this->conn = null;
  21.  
  22.         try{
  23.             $this->conn = new PDO("mysql:host=" . $this->host . ";dbname=" . $this->db_name, $this->username, $this->password);
  24.         }catch(PDOException $exception){
  25.             echo "Connection error: " . $exception->getMessage();
  26.         }
  27.  
  28.         return $this->conn;
  29.     }
  30. }
  31. ?>
  32.  
  33. ****************************************************************************************Arquivo Empresa.php
  34. <?php
  35.  
  36. class Empresa
  37. {
  38.  
  39.     //base de dados e nome da tabela
  40.  
  41.     private $conn;
  42.     private $table_name = "cadastro_emp";
  43.  
  44.     //propriendades da Classe
  45.  
  46.     public $razao_social;
  47.     public $cnpj;
  48.     public $inscricao_estadual;
  49.  
  50.  
  51.     public function __construct($db)
  52.     {
  53.         $this->conn = $db;
  54.     }
  55.  
  56.     public function meuPrint(){
  57.    
  58.     echo "Meu Print"
  59.     }
  60.     // create product
  61.     public function create()
  62.     {
  63.         //write query
  64.         $query = "INSERT INTO " . $this->table_name . " (`razao_social`,`cnpj`,`inscricao_estadual`) VALUES (?,?,?)";
  65.  
  66.         $stmt = $this->conn->prepare($query);
  67.  
  68.         $stmt->bindParam(1, $this->razao_social);
  69.         $stmt->bindParam(2, $this->cnpj);
  70.         $stmt->bindParam(3, $this->inscricao_estadual);
  71.  
  72.         if ($stmt->execute()) {
  73.             return true;
  74.         } else {
  75.             return false;
  76.         }
  77.  
  78.     }
  79. }
  80.  
  81.  
  82. ?>
  83.  
  84. *********************************************************************************************************** cadastroEmpresa.php
  85.  
  86. <?php
  87.        
  88.         require_once ('php/database.php');
  89.         require_once ('php/Empresa.php');
  90.  
  91.  
  92.  
  93.        if (isset($_POST['formularioCadastro'])) {
  94.              $database = new Database();
  95.              $empresa = new Empresa($database->getConnection());
  96.              
  97.              $empresa-> razao_social = $_POST['razaosocial'];
  98.              $empresa-> cnpj = $_POST['cnpj'];
  99.                  $empresa-> inscricao_estadual = $_POST['inscricaoestadual'];
  100.    
  101.            
  102.             $empresa->meuPrint();
  103.             $empresa->create();  
  104.              
  105.              if ($empresa->create()) {
  106.             echo "<div class=\"alert alert-success alert-dismissable\">";
  107.             echo "<button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">&times;</button>";
  108.             echo "Empresa Cadastrada.";
  109.             echo "</div>";
  110.             }    
  111.             else {
  112.             echo "<div class=\"alert alert-danger alert-dismissable\">";
  113.             echo "<button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">&times;</button>";
  114.             echo "Erro ao Cadastrar.";
  115.             echo "</div>";
  116.             }
  117.         }
  118.  
  119. ?>
  120.  
  121. <form method='post' name="formularioCadastro" class="form-horizontal localformcademp" >
  122.   <div class="control-group ">
  123.  
  124.     <h3><label class="control-label " for="razaoSocial">Dados da Empresa</label></h3>
  125.     <label class="control-label " for="razaoSocial">Razão Social</label>
  126.     <div class="controls ">
  127.       <input type="text" id="razaosocial" name="razaosocial" class="tamanhocampo" placeholder="">
  128.     </div>
  129.   </div>
  130.   <div class="control-group">
  131.     <label class="control-label" for="Cnpj">Cnpj</label>
  132.     <div class="controls">
  133.       <input type="text" id="cnpj" name="cnpj" class="tamanhocampo" placeholder="">
  134.     </div>
  135.     <div class="control-group">
  136.     <label class="control-label" for="InscricaoEstadual">Inscrição Estadual</label>
  137.     <div class="controls">
  138.       <input type="text" id="inscricaoestadual" name="inscricaoestadual" class="tamanhocampo" placeholder="">
  139.     </div>
  140.  
  141.  </br>
  142.   </br>
  143.       <button type="submit" class="btn">Salvar</button>
  144.    
  145.   </div>
  146. </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement