forked from github/dev
-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathCarro.php
More file actions
39 lines (37 loc) · 1.43 KB
/
Carro.php
File metadata and controls
39 lines (37 loc) · 1.43 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
<?php
include "Conexao.php";
class Carro{
private int $id;
private string $placa;
private int $ano;
private bool $ipvaPago;
private string $ipvaData;
private float $ipvaValor;
public function __construct(string $placa, int $ano, bool $ipvaPago, string $ipvaData, float $ipvaValor){
$this->placa = $placa;
$this->ano = $ano;
$this->ipvaPago = $ipvaPago;
$this->ipvaData = $ipvaData;
$this->ipvaValor = $ipvaValor;
}
public function Cadastrar(){
$conexao = new Conexao();
$sql = "INSERT INTO
Carro(placa, ano, ipvaPago, ipvaData, ipvaValor)
VALUES (:placa, :ano, :ipvaPago, :ipvaData, :ipvaValor)";
$pdo = $conexao->Conectar();
$preparo = $pdo->prepare($sql);
$preparo->bindParam(':ano', $this->ano);
$preparo->bindParam(':placa', $this->placa);
$preparo->bindParam(':ipvaData', $this->ipvaData);
$preparo->bindParam(':ipvaPago', $this->ipvaPago);
$preparo->bindParam(':ipvaValor', $this->ipvaValor);
$preparo->execute();
}
public static function ListarTodos(){
$conexao = new Conexao();
$sql = "SELECT * FROM Carro";
$dados = $conexao->Consultar($sql);
return $dados;
}
}