Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ******************************************************************************Arquivo conexão.class.php
- <?php
- <?php
- class Database
- {
- // specify your own database credentials
- private $host = "127.0.0.1";
- private $db_name = "sisim";
- private $username = "root";
- private $password = "";
- public $conn;
- // get the database connection
- public function getConnection()
- {
- $this->conn = null;
- try {
- $this->conn = new PDO("mysql:host=" . $this->host . ";dbname=" . $this->db_name, $this->username, $this->password);
- } catch (PDOException $exception) {
- echo "Connection error: " . $exception->getMessage();
- }
- return $this->conn;
- }
- }
- ?>
- ************************************************************************************************Arquivo.class.php
- <?php
- class EmpresaDAO{
- private $conn;
- private $table
- private $table_name = "cadastro_emp";
- public function __construct($db)
- {
- $this->conn = $db;
- }
- public function createEmpresa($razao_social,$cnpj,$inscricao_estadual)[{
- {
- //write query
- $query = "INSERT INTO " . $this->table_name . " (`razao_social`,`cnpj`,`inscricao_estadual`) VALUES (?,?,?)";
- echo "$query";
- $stmt = $this->conn->prepare($query);
- $stmt->bindParam(1,($razao_social);
- $stmt->bindParam(2, $this->$cnpj);
- $stmt->bindParam(3, $this-$inscricao_estadual);
- if ($stmt->execute()) {
- return true;
- } else {
- return false;
- }
- }
- }
- ?>
- ************************************************************************************************ arquivo EmpresaController.php
- <?php
- if ($_SERVER['REQUEST_METHOD']=='POST'){
- $database = new Database();
- $empresaDAO = new EmpresaDAO($database->getConnection());
- $empresa = new Empresa();
- $empresa.razao_social -> $_POST['razaosocial'];
- $empresa.cpf -> $_POST['cpf'];
- $empresa.inscricao_estadual-> $_POST['inscricao_estadual'];
- $empresaDAO->createEmpresa($empresa.razao_social,empresa.cpf,empresa.inscricao_estadual);
- }
- ?>
- e meu forme do html que nao vejo necessidade de colocar se nao só vai ocupar espaço o meu form ta enviar os dados pro controller :)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement