Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php include("includes/config.php"); ?>
- <?php
- if(isset($_POST['editar'])){
- foreach($_POST['mao_obra_id'] as $indice => $valor){
- $detalhe_preco = $_POST['detalhe_preco'.$valor];
- $inserir = "UPDATE detalhe_orcamento1 SET mao_obra_id = '$valor', detalhe_preco = '$detalhe_preco' WHERE id = '$valor'" or die(mysql_error());
- mysql_query($inserir) or die(mysql_error());
- }
- echo'<pre>';
- print_r($_POST);
- echo'</pre>';
- }
- ?>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <title>Untitled Document</title>
- </head>
- <body>
- <?php
- $id = $_GET['id'];
- $seleciona2 = mysql_query("
- SELECT orcamento1.*, orcamento1.data, DATE_FORMAT(data, '%d/%m/%Y') AS data_orc, detalhe_orcamento1.*, mao_obra.* FROM orcamento1
- INNER JOIN detalhe_orcamento1 ON detalhe_orcamento1.orcamento_id = orcamento1.id
- INNER JOIN mao_obra ON mao_obra.id = detalhe_orcamento1.mao_obra_id
- WHERE orcamento1.id = '$id'" ) or die (mysql_error());
- if($seleciona2 == ''){
- echo 'Erro';
- }else{
- $checkboxcheckado = array();
- while ($cp = mysql_fetch_assoc($seleciona2)){
- $checkboxcheckado[] = $cp['mao_obra_id'];
- }
- ?>
- <form id="form1" action="" enctype=" multipart/form-data" method="post">
- <?php
- // consulta do select de Serviços
- $selec = "SELECT * FROM mao_obra";
- $exec = mysql_query($selec) or die(mysql_error());
- while($dados = mysql_fetch_assoc($exec)){
- $valor_id = $dados['id'];
- $valor_mao_obra = $dados['mao_obra'];
- $valor_preco = $dados['preco'];
- ?>
- <table width="700px" border="1" align="center">
- <tr>
- <td><input style="margin-left:30px" name="mao_obra_id[]" <?php echo in_array((int)$valor_id,$checkboxcheckado) ?' checked="checked"':'';?> type="checkbox" value="<?php echo $valor_id ?>"/> <?php echo $valor_mao_obra ?></td>
- <td><input type="hidden" name="detalhe_preco<?php echo $valor_id ?>" value="<?php echo $valor_preco ?>" /> <?php echo $valor_preco ?></td>
- </tr>
- <?php } // END while ?>
- <tr>
- <td colspan="2" align="center"><input type="submit" name="editar" value="Adicionar Orçamento" /></td>
- </tr>
- </form>
- <?php } // END else ?>
- </tr>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement