Fernando Pais

Eu acho que é mais ou menos isso. Parece que ficou faltando colocar o id_cliente (eu prefiro cliente_id, cartao_id, etc) na tabela cadastro_cartao. O contrário, colocar o cartão_id no cadastro_cliente, seria um erro pois o cliente hoje ou no futuro poderia ter mais de um cartão. Por isso o cartao_id também deveria entrar no histórico. oi kakao, obrigado pela ajuda, so pra finalizar, você acha melhor criar 3 tabelas então ao invés de so 1 com todas as informacoes???? obrigado

Ola pessoal bom dia, estou tentando montar um sisteminha de cadastro de promoção aqui na empresa aonde trabalho. minha duvida e na criação da tabela no mysql. iremos fazer uma promoção com um cartao que distribuimos para nosso clientes, nesse cartao de 5 numeros, irei utilizar eles para identificar cada cliente. junto com esse numero sera amarrado tb o local aonde esse cliente recebeu o cartao ex: n:20345 loja:campinas. no cadastro do cliente irei precisar dos campos nome, rg, cpf, email, endereço, bairro, cidade, estado, bairro e cep. apartir do momento em que a operadora do caixa preencher esse formulario de cadastro com essas informações ela ficar fixa com com aqueles dois campos no inicio que e o numero do cartao e loja que emitiu o cartao. lembrando que o numero do cartao já estara cadastro no banco, so tera um campo para o operador digitar o numero do cartao e trazer as informaçao de qual loja emitiu o cartao. bom ate ai tudo bem. depois disso preciso criar mais 3 campo, valor da compra, data da compra e local da compra. exp. o cliente 20345 vai na loja de campinas e compra 200,00 no dia 10/10/2011 loja campinas. o operador abre a tela de cadastro e digita o numero de cartao, ele ira trazer todo o cadastro do cliente na tela, o operador so ira digitar o valor da compra data e local. fazendo um historico de toda vez que o cliente comprou na loja. a minha duvida e na criação da tabela, devo criar uma tabela, cadastro_cartao para as informações id_cartao e id_loja, uma outra tabela para o cadastro do cliente com todas as informações pessoas do cliente, e outra tabela para o historico de compras, aonde sera armazenada os valores, data e local das compras. por favor me ajudem o que seria melhor e mais seguro. muito obrigado espero que tenha ficado facil de compreender Obrigado

Boa tarde pessoal, preciso de uma ajuda. Tenho uma loja virtual, e preciso colocar o ssl para cadastro e pagamento, minha duvida e como eu especifico que so a pagina EX: cadastro.asp e so pagamento.asp sejam abertas em EX: https://www.meusite.com.br/cadastro.asp tentei e o unico resultado que eu consegui fui de colocar o https:// para todas as paginas do meu site ou seja tudo o site esta em https preciso so do cadastro e pagamento, pois não consegui. conto com a ajuda de todos Muito obrigado

ola pessoal comprei um certificado ssl para meu site, porem preciso de ajuda, como eu faco para chamar duas paginas em https:// exemplo o usuario acessa meu site www.meusite.com.br normalmente quando ele clicar em registro automaticamente ele abre o endereco https://www.meusite.com.br gostaria de especificar somente duas paginas para abrir em https:// bom e isso muito obrigado pela ajuda

ola boa tarde pessoal, goistaria de ajuda de vocês vi diversos scripts para autenticação automatica do speedy business, mas tudo para linux, o meu sistema e windows, sera que vocês poderiam me ajudar a achar um script de autenticação para o speedy business... Obrigado a todos

ok jonathan muito obrigado pela forta T+

ola jonathan desculpe por tantas perguntas, você sabe me dizer se do jeito que esta esse formulario meu, se e possivel enviar ele preenchido por e-mail??? com esse visual html? s ecaso sim, teria algum tutorial que você podssa me indicar??? mais uma vez agradeço a atenção Muito obrigado

ok, você chegou a ler o codigo?? não achou que demorou muito para abrir? teria como deixar ela mais rapida??

sim amigo esse foi feito no excell, tentei fazer um em html mas ficou um lixo de uma olhada nesse codigo que eu tentei fazer, gostaria que fosse bem parecido com o da imagem tabela

ola pessoal estou precisando criar um formulario igual a esse que esta na foto, mas não tenho esperiencia nenhuma em html, sera que alguém podeira me ajudar??? Obrigado

tenho um formulario aonde os vendedores digita os pedidos e envia por e-mail para mim. esses dados digitados pelos vendedores, gostaria de gravar em mysql quando ele clicar em enviar automaticamente envia e grava no banco de dados obrigado pela ajuda T+ abaixo a minha tabela <html> <table border="0" cellpadding="4" cellspacing="0"> <tr> <td><b>Nome Completo:</td> <td><input name="Nome" type="text" id="Nome" size="50" maxlength="255"> </td> </tr> <tr> <td>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <b>Endereço:</td> <td><input type="text" name="endereço" size="40" maxlength="2"> &nbsp; &nbsp; <b>Nº : <input type="text" name="numero" maxlength="6" size="10"> &nbsp; &nbsp; </td> </tr> <tr> <td>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <b>Bairro:</td> <td><input type="text" name="bairro" maxlength="30" size="30"> &nbsp; &nbsp; <b>Cidade: <input type="text" name="cidade" maxlength="30" size="20"> &nbsp; &nbsp; <b>Estado: <input type="text" name="estado" maxlength="20" size="20"> &nbsp; &nbsp; </td> </tr> <tr> <td> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <b>Fone:</td> <td><input type="text" name="fone" maxlength="15" size="15"> &nbsp; &nbsp; <b>Condições: <input type="text" name="condicao" maxlength="15" size="15">&nbsp; &nbsp; <b>Prazo de Entrega: <input type="text" name="prazo" maxlength="15" size="15">&nbsp; </td> </tr></td> </tr> <tr> <td>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <b>CNPJ:</td> <td><input type="text" name="cnpj" size="15" maxlength="18">&nbsp; <b>Inscrição: <input type="text" name="inscricao" maxlength="30" size="20"> &nbsp; &nbsp; <b>Cep: <input type="text" name="cep" maxlength="15" size="20"> &nbsp; &nbsp; </td> </tr> </table> <br> <center> <table border="2"> <tr> <th>Qtde.</th> <th>Ordem</th> <th>Un</th> <th>P</th> <th>M</th> <th>G</th> <th>GG</th> <th>XGG</th> <th>1</th> <th>2</th> <th>3</th> <th>4</th> <th>6</th> <th>8</th> <th>10</th> <th>12</th> <th>14</th> <th>16</th> <th>Preço</th> <th>Preço Total</th> </tr> <tr> </center> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> <tr> <td><center><input type="text" name="qtde" id="qtde" value="" size="1" maxlength="5" /></center></td> <td><center><input type="text" name="ordem" id="ordem" value="" size="4" maxlength="8" /></center></td> <td><center><input type="text" name="unico" id="unico" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="p" id="p" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="m" id="m" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="g" id="g" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="gg" id="gg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="xgg" id="xgg" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="1" id="1" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="2" id="2" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="3" id="3" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="4" id="4" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="6" id="6" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="8" id="8" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="10" id="10" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="12" id="12" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="14" id="14" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="16" id="16" value="" size="1" maxlength="3" /></center></td> <td><center><input type="text" name="preço" id="preço" value="" size="5" maxlength="10" /></center></td> <td><center><input type="text" name="preço total" id="preço total" value="" size="6" maxlength="10" /></center></td> </tr> </table> [/codebox]

ok obrigado pela ajuda... vou entrar na secao php obrigado T+

tenho um formulario aonde os vendedores digita os pedidos e envia por e-mail para mim. esses dados digitados pelos vendedores, gostaria de gravar em mysql quando ele clicar em enviar automaticamente envia e grava no banco de dados obrigado pela ajuda T+

bom dia tenho uma tabela em html, e gostaria de saber como eu faço para gravar em mysql, se alguém tiver um modelo de codigo etc... agradeço obrigado

bom dia pessoal, gostaria de uma ajuda com esse codigo, gostaria de saber se e possivel amarrar junto com o usuario a pagina que ira abrir ex: usuario: joao pagina:revenda.html usuario: maria pagina:cancelamento.html usuario: tereza pagina:refaturamento.html abaixo vai o codigo obrigado ============================= Crie a tabela a seguir no mysql: CREATE TABLE usuarios ( idus int(11) NOT NULL auto_increment, login varchar(50) NOT NULL, senha varchar(32) NOT NULL, PRIMARY KEY (idus) ); ===================================================== caduser.php <?php include "conexao.php"; // verifica se o os dados foram enviados através do método POST if (getenv("REQUEST_METHOD") == "POST") { // encripta a senha para ser cadastrada na tabela $cod = md5($passen); // insere o registro pegando a senha criptografada no $cod $sql = "INSERT INTO usuarios (login, senha) VALUES ('$login', '$cod')"; mysql_query($sql); ?> &lt;script>alert("Usuário cadastrado com Sucesso!!");</script> <?php } ?> Formulário para cadastrar o usuário <form action="caduser.php" method="post"> Nome: <input type="text" name="login"><br> Senha: <input type="text" name="passen"><br> <input type="submit" value="Enviar"> </form> <br><br><br> ================================================================== lista_user.php: <?php include "conexao.php"; $sql = "SELECT * FROM usuarios"; // seleciona as colonas da tabela usuarios $resultado = mysql_query($sql); // executa a contulta e armazena o resultado em array $num_linhas = mysql_num_rows($resultado); ?> <html> <body> <table border=2> <tr> <td>O Número de Linhas é: <?php echo $num_linhas; ?></td> </tr> </table> <table border=2 bordercolor="#800000" bordercolorlight="#800000"> <tr> <td colspan="3" align="center"><font face="Comic Sans MS" size="3" color="#003399">Usuário</font></td> </tr> <tr> <td>Código</td> <td>Login</td> <td>Senha</td> </tr> <?php //faz um loop ára listar em linhas os usuários cadastrados for ($i = 0; $i < $num_linhas; $i++) { $campos = mysql_fetch_array($resultado); ?> <tr> <td><?php echo $campos["idus"]; ?></td> <td><?php echo $campos["login"]; ?></td> <td><?php echo $campos["senha"]; ?></td> </tr> <?php } //fecha o loop ?> </table> </body> </html> ================================================================ logar.php: <?php include "conexao.php"; if (getenv("REQUEST_METHOD") == "POST") { $cod = md5($passen); // pega o valor passado pelo form e criptografa $resultado = mysql_query("SELECT login, senha FROM usuarios WHERE login='$txtlog' AND senha='$cod'"); if (mysql_num_rows($resultado) > 0) { setcookie("logado", true); setcookie("usuario", $txtlog); // se o usuário existe vai para o arquivo lista_user (neste // lugar você coloca a página para onde o usuario irá se logado com sucesso header("Location: lista_user.php"); } else { ?> &lt;script language="JavaScript"> <!-- window.alert("Usuário Não Identificado"); //--> </script> <?php } } ?> <html> <body> <form action="logar.php" method="post" name="formlog"> <table border="1"> <tr> <td>Login:</td> <td><input type="text" name="txtlog"></td> </tr> <tr> <td>Senha:</td> <td><input type="text" name="passen"></td> </tr> <tr> <td colspan="2"><input type="submit" value="Logar"></td> </tr> </table> </form> </body> </html> ================================================ valida_logar.php: <?php if (!$logado) { // se o usuario não for cadastrado volta para a // página logar.php, não altere este código. header("Location: logar.php"); } ?> =============================================== deslog.php: <?php setcookie("logado"); // aqui você coloca a página para onde o usuario irá depois // de deslogar, geralmente a página inicial do site. header("Location: logar.php"); ?>