· 10 years ago · May 20, 2016, 01:06 AM
1Array ( [nome] => Clayton ) Array ( [nome] => Clayton [email] => infogyba@ymail.com ) Array ( [nome] => Clayton [email] => infogyba@ymail.com [telefone] => (21)2481-4242 ) Array ( [nome] => Clayton [email] => infogyba@ymail.com [telefone] => (21)2481-4242 [servico] => 41106 ) Array ( [nome] => Clayton [email] => infogyba@ymail.com [telefone] => (21)2481-4242 [servico] => 41106 [sCepDestino] => 21215430 ) Array ( [nome] => Clayton [email] => infogyba@ymail.com [telefone] => (21)2481-4242 [servico] => 41106 [sCepDestino] => 21215430 [num] => ) Array ( [nome] => Clayton [email] => infogyba@ymail.com [telefone] => (21)2481-4242 [servico] => 41106 [sCepDestino] => 21215430 [num] => [comp] => )
2
3$conn = conecta();
4$lista = array();
5foreach($_POST as $dados => $value) {
6 $valores = explode('_', $value);
7 $lista[$dados] = $valores[0];
8 $binds = str_repeat('?,', 12) .'?';
9 print_r($lista).'<br />';
10}
11
12CREATE TABLE IF NOT EXISTS `clientes` (
13 `nome` varchar(60) NOT NULL,
14 `email` varchar(60) NOT NULL,
15 `telefone` int(8) DEFAULT NULL,
16 `servico` varchar(50) NOT NULL,
17 `cep` varchar(20) NOT NULL,
18 `tipo_logradouro` varchar(70) NOT NULL,
19 `logradouro` varchar(20) NOT NULL,
20 `numero` varchar(20) NOT NULL,
21 `complemento` varchar(100) NOT NULL,
22 `bairro` varchar(20) NOT NULL,
23 `cidade` varchar(20) NOT NULL,
24 `estado` varchar(12) NOT NULL,
25 PRIMARY KEY (`nome`)
26 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;