Insert data in multiple tables and rows

Question

Stardemos 0 Junior Poster

11 Years Ago

Hello.
I'm new to php and sql.
I nee to insert data in multiple tables and rows. the problem, in the first table, I just nedd 1 row, and that's fine, in the scond i need to input data in the minimum of 1 row and max of 6 row's. in the second table, no data is inserted, can you help me?? Thanks in advance.

php code ( entrada.php)

<?php


 //conecção ao servidor
$conn = mysql_connect("localhost", "root")or die("sem conecção ao servidor"); 
$db = mysql_select_db("sermail")or die("Base de dados não foi encontrada");
 // VAriaveis  
   //ordem 

    $data = date("dmY");
    $nordem = $_POST['nordem'];
    $guian = $_POST['guian'];
    $ncliente = $_POST['ncliente'];
    $cliente = $_POST['cliente'];
    $fornecedor = $_POST['fornecedor'];       
         // entrada linha1
     $check = $_POST['check'][$i];
    $lote = $_POST['lote'][$i];
    $val = $_POST['val'][$i];
    $designacao = $_POST['designacao'][$i];
    $filtro = $_POST['filtro'][$i];
    $familiamarca = $_POST['familiamarca'][$i];
    $quantguia = $_POST['quantguia'][$i];
    $quantconf = $_POST['quantconf'][$i];
    $atado = $_POST['atado'][$i];
    $posicao = $_POST['posicao'][$i];
    $codprod = $_POST['codprod'][$i];

echo $sql="INSERT INTO ordem(data, nordem, fornecedor, guian, ncliente, cliente)
VALUES( '".$data."', '".$nordem."', '".$fornecedor."', '".$guian."', '".$ncliente."', '".$cliente."')";
echo "</br>";
mysql_query ($sql);
$exec=mysql_query($sql);        

echo $sql = 'INSERT INTO \'entrada\' (\'nordem_n\', \'lote\', \'val\', \'designacao\', \'familiamarca\', \'quantguia\', \'quantconf\', \'atado\', \'posicao\', \'codprod\') VALUES';

for ($i=0; $i<count($_POST['lote']); $i++) {
    $sql .= '(\'' . $_POST['lote'][$i] . '\', \'' . $_POST['val'][$i] . '\', \'' . $_POST['designacao'][$i] . '\', \'' . $_POST['familiamarca'][$i] . '\', \'' . $_POST['quantguia'][$i] . '\', \'' . $_POST['quantconf'][$i] . '\', \'' . $_POST['atado'][$i] . '\', \'' . $_POST['posicao'][$i] . '\', \'' . $_POST['codprod'][$i] . '\')';
    if ($i<count($_POST['lote']) - 1) {
       $sql .= ',';
    }
}







  ?> 
<?php 
mysql_close();
 ?>

html code ( form.html)

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" lang="en">
    <head>

        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <title>Ficha de entrada de material</title>
        <meta name="alex" content="sermail" />
        <link rel="stylesheet" type="text/css" href="styles/styles.css" />
        <script type="text/javascript">
 function printpage()
   {
   window.print()
   }
 </script>
    <script>
      function showMe (it, box) {
       var vis = (box.checked) ? "block" : "none";
      document.getElementById(it).style.display = vis;
      }
     </script>

<style type="text/css" media="print">
   .printbutton {
   visibility: hidden;
   display: none;
   }
   .validado {
   visibility: hidden;
   display: none;
   }
    .background{ color: #0000;}
    .page landscape {size: landscape;}
    .page
    { bgcolor: #0000; }
    .h1{color: #000;
    font-family: Times New Roman, sans-serif;
    font-size: 18px;
    font-weight: bold;
    text-align: left;}
    .h2{color: #000;
    font-weight: normal;
    text-align: center;
    font-family: Times New Roman, sans-serif;
    font-size: 16px;}

</style>


    </head>
    <body bgcolor= #00814B>
    <div class="body">
        <div class="content">
        <br><br><br><br><br>
<form action="entrada.php" method="post">
 <table width="1000px"> <tr><td width="600px"><h1>

 N.º Ordem: <input type="text" size="6" name="nordem" />
 Fornecedor: <input type="text" size="10" name="fornecedor"/><br>
 Guia n.º: <input type="text" size="6" name="guian"/>
 N.º Cliente: <input type="text" size="8"name="ncliente" />
 Cliente: <input type="text" size="15"name="cliente"  /></h1></td><td width="250px"</td><td><img src="imas/sermaillogo.png"></td></tr>





 <table border="1" id="produtos" width="900px"  >
 <tr ><td></td>
 <td width="80px"><h2>Cód. <br/>Produto </h2></td>
 <td width="80px"><h2>Cód. Cliente 1<br>Lote</h2></td>
 <td width="80px"><h2>Cód. Cliente 2<br>validade</h2></td>
 <td width="80px"><h2>Designação</h2></td>
 <td width="80px"><h2>Filtro 1 <br> Unidade de negócio</h2></td>
 <td width="80px"><h2>Familia/Marca</h2></td>
 <td width="80px"><h2>Quant. Guia</h2></td>
 <td width="80px"><h2>Quant. Conferida</h2></td>
 <td width="80px"><h2>Atado</h2></td>
 <td width="80px"><h2>Posição</h2></td>
   </tr>


<tr><td><input type="hidden" name="check[]"  value="0"  /><input type="checkbox" name="check[]"  value="1"  /></td>
 <td width="80px"><input type="text" size="8"name="codprod[]" /></td>
 <td width="80px"><input type="text" size="8"name="lote[]" /></td>
 <td width="80px"><input type="text" size="10"name="val[]" /></td>
 <td width="80px"><input type="text" size="30"name="designacao[]"  /></td>
 <td width="80px"><input type="text" size="10"name="filtro[]"  /></td>
 <td width="80px"><input type="text" size="15"name="familiamarca[]"/></td>
 <td width="80px"><input type="text" size="6"name="quantguia[]" /></td>
 <td width="80px"><input type="text" size="6"name="quantconf[]"  /></td>
 <td width="80px"><input type="text" size="6"name="atado[]"  /></td>
 <td width="80px"><input type="text" size="6"name="posicao[]" /></td>
 </tr>

<tr><td><input type="hidden" name="check[]"  value="0"  /><input type="checkbox" name="check[]"  value="1"  /></td>
 <td width="80px"><input type="text" size="8"name="codprod[]" /></td>
 <td width="80px"><input type="text" size="8"name="lote[]" /></td>
 <td width="80px"><input type="text" size="10"name="val[]" /></td>
 <td width="80px"><input type="text" size="30"name="designacao[]"  /></td>
 <td width="80px"><input type="text" size="10"name="filtro[]"  /></td>
 <td width="80px"><input type="text" size="15"name="familiamarca[]"/></td>
 <td width="80px"><input type="text" size="6"name="quantguia[]" /></td>
 <td width="80px"><input type="text" size="6"name="quantconf[]"  /></td>
 <td width="80px"><input type="text" size="6"name="atado[]"  /></td>
 <td width="80px"><input type="text" size="6"name="posicao[]" /></td>
 </tr>
<tr><td><input type="hidden" name="check[]"  value="0"  /><input type="checkbox" name="check[]"  value="1"  /></td>
 <td width="80px"><input type="text" size="8"name="codprod[]" /></td>
 <td width="80px"><input type="text" size="8"name="lote[]" /></td>
 <td width="80px"><input type="text" size="10"name="val[]" /></td>
 <td width="80px"><input type="text" size="30"name="designacao[]"  /></td>
 <td width="80px"><input type="text" size="10"name="filtro[]"  /></td>
 <td width="80px"><input type="text" size="15"name="familiamarca[]"/></td>
 <td width="80px"><input type="text" size="6"name="quantguia[]" /></td>
 <td width="80px"><input type="text" size="6"name="quantconf[]"  /></td>
 <td width="80px"><input type="text" size="6"name="atado[]"  /></td>
 <td width="80px"><input type="text" size="6"name="posicao[]" /></td>
 </tr>
<tr><td><input type="hidden" name="check[]"  value="0"  /><input type="checkbox" name="check[]"  value="1"  /></td>
 <td width="80px"><input type="text" size="8"name="codprod[]" /></td>
 <td width="80px"><input type="text" size="8"name="lote[]" /></td>
 <td width="80px"><input type="text" size="10"name="val[]" /></td>
 <td width="80px"><input type="text" size="30"name="designacao[]"  /></td>
 <td width="80px"><input type="text" size="10"name="filtro[]"  /></td>
 <td width="80px"><input type="text" size="15"name="familiamarca[]"/></td>
 <td width="80px"><input type="text" size="6"name="quantguia[]" /></td>
 <td width="80px"><input type="text" size="6"name="quantconf[]"  /></td>
 <td width="80px"><input type="text" size="6"name="atado[]"  /></td>
 <td width="80px"><input type="text" size="6"name="posicao[]" /></td>
 </tr>
<tr><td><input type="hidden" name="check[]"  value="0"  /><input type="checkbox" name="check[]"  value="1"  /></td>
 <td width="80px"><input type="text" size="8"name="codprod[]" /></td>
 <td width="80px"><input type="text" size="8"name="lote[]" /></td>
 <td width="80px"><input type="text" size="10"name="val[]" /></td>
 <td width="80px"><input type="text" size="30"name="designacao[]"  /></td>
 <td width="80px"><input type="text" size="10"name="filtro[]"  /></td>
 <td width="80px"><input type="text" size="15"name="familiamarca[]"/></td>
 <td width="80px"><input type="text" size="6"name="quantguia[]" /></td>
 <td width="80px"><input type="text" size="6"name="quantconf[]"  /></td>
 <td width="80px"><input type="text" size="6"name="atado[]"  /></td>
 <td width="80px"><input type="text" size="6"name="posicao[]" /></td>
 </tr>
<tr><td><input type="checkbox" name="check[]"  value="1"  /></td>
 <td width="80px"><input type="text" size="8"name="codprod[]" /></td>
 <td width="80px"><input type="text" size="8"name="lote[]" /></td>
 <td width="80px"><input type="text" size="10"name="val[]" /></td>
 <td width="80px"><input type="text" size="30"name="designacao[]"  /></td>
 <td width="80px"><input type="text" size="10"name="filtro[]"  /></td>
 <td width="80px"><input type="text" size="15"name="familiamarca[]"/></td>
 <td width="80px"><input type="text" size="6"name="quantguia[]" /></td>
 <td width="80px"><input type="text" size="6"name="quantconf[]"  /></td>
 <td width="80px"><input type="text" size="6"name="atado[]"  /></td>
 <td width="80px"><input type="text" size="6"name="posicao[]" /></td>
 </tr>

 </table>

 <input type="submit"/ class="printbutton" value="Inserir entrada"><br/>
 <input type="button"class= "validado" value="Imprimir" onclick="printpage()" />

<INPUT type="button" value="Fechar" onClick="window.close()">
</form>



</div>
</div>
    </body>
</html>

mysql

3 Contributors
71 Replies
787 Views
2 Days Discussion Span
Latest Post 11 Years Ago Latest Post by Stardemos

All 71 Replies

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 1 · 2012-07-31T14:00:44+00:00

pritaeas 2,194 ¯\_(ツ)_/¯

11 Years Ago

If that is all code, the second query is never executed.

Stardemos 0 Junior Poster · Answer 2 · 2012-07-31T14:20:17+00:00

why? pleaze help me undersant what am I doing wrong!
what's the solution?

Stardemos 0 Junior Poster · Answer 3 · 2012-07-31T14:36:20+00:00

ok same var for 2 difernt query's, one mistake, corrected it, but still don't add any row to the table... HELP PLEASE

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 4 · 2012-07-31T14:42:23+00:00

pritaeas 2,194 ¯\_(ツ)_/¯

11 Years Ago

Show your corrected PHP code.

Stardemos 0 Junior Poster · Answer 5 · 2012-07-31T14:57:15+00:00

  <?php
    //conecção ao servidor
    $conn = mysql_connect("localhost", "root")or die("sem conecção ao servidor");
    $db = mysql_select_db("sermail")or die("Base de dados não foi encontrada");
    // VAr
    //table ordem
    $data = date("dmY");
    $nordem = $_POST['nordem'];
    $guian = $_POST['guian'];
    $ncliente = $_POST['ncliente'];
    $cliente = $_POST['cliente'];
    $fornecedor = $_POST['fornecedor'];
    // table entrada 
    $check = $_POST['check'][$i];
    $lote = $_POST['lote'][$i];
    $val = $_POST['val'][$i];
    $designacao = $_POST['designacao'][$i];
    $filtro = $_POST['filtro'][$i];
    $familiamarca = $_POST['familiamarca'][$i];
    $quantguia = $_POST['quantguia'][$i];
    $quantconf = $_POST['quantconf'][$i];
    $atado = $_POST['atado'][$i];
    $posicao = $_POST['posicao'][$i];
    $codprod = $_POST['codprod'][$i];

    //insert data table ordem
    echo $sql="INSERT INTO ordem(data, nordem, fornecedor, guian, ncliente, cliente)
    VALUES( '".$data."', '".$nordem."', '".$fornecedor."', '".$guian."', '".$ncliente."', '".$cliente."')";
    echo "</br>";
    mysql_query ($sql);
    $exec=mysql_query($sql);

    //insert data table entrada
    echo $sql2 = 'INSERT INTO \'entrada\' (\'nordem_n\', \'lote\', \'val\', \'designacao\', \'familiamarca\', \'quantguia\', \'quantconf\', \'atado\', \'posicao\', \'codprod\') VALUES';
    for ($i=0; $i<count($_POST['check']); $i++) {
    $sql2a= '(\'' . $_POST['lote'][$i] . '\', \'' . $_POST['val'][$i] . '\', \'' . $_POST['designacao'][$i] . '\', \'' . $_POST['familiamarca'][$i] . '\', \'' . $_POST['quantguia'][$i] . '\', \'' . $_POST['quantconf'][$i] . '\', \'' . $_POST['atado'][$i] . '\', \'' . $_POST['posicao'][$i] . '\', \'' . $_POST['codprod'][$i] . '\')';
    if ($i<count($_POST['check']) - 1) {
    $sql2a= ',';
    }
    }
    ?>
    <?php
    mysql_close();
    ?>

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 6 · 2012-07-31T15:02:20+00:00

Remove line 31, it does the same as 30.
Line 34: Change $sql2 to $sql2a
Line 36: Change = to .=
Line 38: Change = to .=
Before line 43, add mysql_query ($sql2a);

Stardemos 0 Junior Poster · Answer 7 · 2012-07-31T15:12:07+00:00

$sql2 = array(); 
foreach( $data as $row ) {
    $sql[] = '("'.mysql_real_escape_string($row['text']).'", '.$row['category_id'].')';
}
mysql_query('INSERT INTO table (text, category) VALUES '.implode(',', $sql));

this query, echoes the values correctly but does not insert them in the table, i don't understand why.

I'm trying to put it to work for days's, i need help. thanks

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 8 · 2012-07-31T15:16:35+00:00

Now you are using double quotes around your text. MySQL needs single quotes.

Always use this when developing:

mysql_query(...) or die(mysql_error());

So you can see if there are errors in your sql.

Stardemos 0 Junior Poster · Answer 9 · 2012-07-31T15:18:37+00:00

sorry, the last code i've pasted isn't mine.. the code i wanted to past was:

> //insert data table entrada
> echo $sql2 = 'INSERT INTO \'entrada\' (\'nordem_n\', \'lote\', \'val\', \'designacao\', \'familiamarca\', \'quantguia\', \'quantconf\', \'atado\', \'posicao\', \'codprod\') VALUES';
> for ($i=0; $i<count($_POST['check']); $i++) {
> $sql2a= '(\'' . $_POST['lote'][$i] . '\', \'' . $_POST['val'][$i] . '\', \'' . $_POST['designacao'][$i] . '\', \'' . $_POST['familiamarca'][$i] . '\', \'' . $_POST['quantguia'][$i] . '\', \'' . $_POST['quantconf'][$i] . '\', \'' . $_POST['atado'][$i] . '\', \'' . $_POST['posicao'][$i] . '\', \'' . $_POST['codprod'][$i] . '\')';
> if ($i<count($_POST['check']) - 1) {
> $sql2a= ',';
> }
> }

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 10 · 2012-07-31T15:24:53+00:00

pritaeas 2,194 ¯\_(ツ)_/¯

11 Years Ago

My previous points still apply.

Stardemos 0 Junior Poster · Answer 11 · 2012-07-31T15:29:46+00:00

doble quotes? where? help me please, i can't see them.
and is this the best way to make it?

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 12 · 2012-07-31T15:31:30+00:00

pritaeas 2,194 ¯\_(ツ)_/¯

11 Years Ago

No. My reply with the 5 points...

Stardemos 0 Junior Poster · Answer 13 · 2012-07-31T15:38:48+00:00

ok, done that 5 points, still the same. mysql guives me notices in all variables, and the echoes of the query's are:

INSERT INTO ordem(data, nordem, fornecedor, guian, ncliente, cliente) VALUES( '31072012', '12', '23', '1', '2', '2')
INSERT INTO 'entrada' ('nordem_n', 'lote', 'val', 'designacao', 'familiamarca', 'quantguia', 'quantconf', 'atado', 'posicao', 'codprod') VALUES

as we can see the second query, don't have any value. the worst of all the table entrada is empty

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 14 · 2012-07-31T15:39:55+00:00

pritaeas 2,194 ¯\_(ツ)_/¯

11 Years Ago

Show your new code...

Stardemos 0 Junior Poster · Answer 15 · 2012-07-31T15:40:44+00:00

     <?php
    //conecção ao servidor
    $conn = mysql_connect("localhost", "root")or die("sem conecção ao servidor");
    $db = mysql_select_db("sermail")or die("Base de dados não foi encontrada");
    // VAr
    //table ordem
    $data = date("dmY");
    $nordem = $_POST['nordem'];
    $guian = $_POST['guian'];
    $ncliente = $_POST['ncliente'];
    $cliente = $_POST['cliente'];
    $fornecedor = $_POST['fornecedor'];
    // table entrada
    $check = $_POST['check'][$i];
    $lote = $_POST['lote'][$i];
    $val = $_POST['val'][$i];
    $designacao = $_POST['designacao'][$i];
    $filtro = $_POST['filtro'][$i];
    $familiamarca = $_POST['familiamarca'][$i];
    $quantguia = $_POST['quantguia'][$i];
    $quantconf = $_POST['quantconf'][$i];
    $atado = $_POST['atado'][$i];
    $posicao = $_POST['posicao'][$i];
    $codprod = $_POST['codprod'][$i];
    //insert data table ordem
    echo $sql="INSERT INTO ordem(data, nordem, fornecedor, guian, ncliente, cliente)
    VALUES( '".$data."', '".$nordem."', '".$fornecedor."', '".$guian."', '".$ncliente."', '".$cliente."')";
    echo "</br>";
    mysql_query ($sql);


    //insert data table entrada
    echo $sql2a = 'INSERT INTO \'entrada\' (\'nordem_n\', \'lote\', \'val\', \'designacao\', \'familiamarca\', \'quantguia\', \'quantconf\', \'atado\', \'posicao\', \'codprod\') VALUES';
    for ($i=0; $i<count($_POST['check']); $i++) {
    $sql2a .= '(\'' . $_POST['lote'][$i] . '\', \'' . $_POST['val'][$i] . '\', \'' . $_POST['designacao'][$i] . '\', \'' . $_POST['familiamarca'][$i] . '\', \'' . $_POST['quantguia'][$i] . '\', \'' . $_POST['quantconf'][$i] . '\', \'' . $_POST['atado'][$i] . '\', \'' . $_POST['posicao'][$i] . '\', \'' . $_POST['codprod'][$i] . '\')';
    if ($i<count($_POST['check']) - 1) {
    $sql2a .= ',';
    }
    }
    ?>
    <?php
    mysql_close();
    ?>

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 16 · 2012-07-31T15:43:04+00:00

Before line 43, add mysql_query ($sql2a);

You still didn't do what I told you to, as quoted above. You don't execute the query...

The echo doesn't show the values, because they are added after your echo.

Stardemos 0 Junior Poster · Answer 17 · 2012-07-31T15:48:45+00:00

does not work... tryed in line 42 and 40.. same result, the notification refers to $i which is supossed to be the row var.. i believe that i must solve it first in order to proced, but there, i'm really stuck.

<?php
    //conecção ao servidor
    $conn = mysql_connect("localhost", "root")or die("sem conecção ao servidor");
    $db = mysql_select_db("sermail")or die("Base de dados não foi encontrada");
    // VAr
    //table ordem
    $data = date("dmY");
    $nordem = $_POST['nordem'];
    $guian = $_POST['guian'];
    $ncliente = $_POST['ncliente'];
    $cliente = $_POST['cliente'];
    $fornecedor = $_POST['fornecedor'];
    // table entrada
    $check = $_POST['check'][$i];
    $lote = $_POST['lote'][$i];
    $val = $_POST['val'][$i];
    $designacao = $_POST['designacao'][$i];
    $filtro = $_POST['filtro'][$i];
    $familiamarca = $_POST['familiamarca'][$i];
    $quantguia = $_POST['quantguia'][$i];
    $quantconf = $_POST['quantconf'][$i];
    $atado = $_POST['atado'][$i];
    $posicao = $_POST['posicao'][$i];
    $codprod = $_POST['codprod'][$i];
    //insert data table ordem
    echo $sql="INSERT INTO ordem(data, nordem, fornecedor, guian, ncliente, cliente)
    VALUES( '".$data."', '".$nordem."', '".$fornecedor."', '".$guian."', '".$ncliente."', '".$cliente."')";
    echo "</br>";
    mysql_query ($sql);


    //insert data table entrada
    echo $sql2a = 'INSERT INTO \'entrada\' (\'nordem_n\', \'lote\', \'val\', \'designacao\', \'familiamarca\', \'quantguia\', \'quantconf\', \'atado\', \'posicao\', \'codprod\') VALUES';
    for ($i=0; $i<count($_POST['check']); $i++) {
    $sql2a .= '(\'' . $_POST['lote'][$i] . '\', \'' . $_POST['val'][$i] . '\', \'' . $_POST['designacao'][$i] . '\', \'' . $_POST['familiamarca'][$i] . '\', \'' . $_POST['quantguia'][$i] . '\', \'' . $_POST['quantconf'][$i] . '\', \'' . $_POST['atado'][$i] . '\', \'' . $_POST['posicao'][$i] . '\', \'' . $_POST['codprod'][$i] . '\')';
    if ($i<count($_POST['check']) - 1) {
    $sql2a .= ',';
    }
    }
    mysql_query ($sql2a);
    ?>
    <?php
    mysql_close();

    ?>

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 18 · 2012-07-31T15:53:08+00:00

You did not include any error/warning message (so do that next time too). But if it refers to $i, it probably refers to line 14-24. You use $i there, but it has no value at that point.

Stardemos 0 Junior Poster · Answer 19 · 2012-07-31T15:56:33+00:00

that's right, the lines betwen 14 and 24 gave me 2 notification, one in "i and the other he don't tell me where.

if the $i is the $row what shoud be is value? that's one thing i don't understand.

Stardemos 0 Junior Poster · Answer 20 · 2012-07-31T16:00:03+00:00

whell... i tried to give a value to $i=0. notification goes away, no data inserted anyway.

Why? in my mind the code makes sense, you corrected it, it should be good wright?

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 21 · 2012-07-31T16:01:06+00:00

I think lines 14 - 24 can be safely removed, as those variables are never used.

Stardemos 0 Junior Poster · Answer 22 · 2012-07-31T16:05:07+00:00

it works(the same way) anyway.
no data inserted in table entrada......

forget to put info about the tables..

table ordem
data, fornecedor, guian, ncliente, cliente, nordem=> primary
nordem_n, lote, val, designacao, familiamarca, quantguia, quantconf, atado, posicao, codprod, id=> primary auto increase

maybe is beter to tell my idea.

once checked a line must be inserted in the table, i can check between 1 and 6 lines of the form table.
other idea, is to only isert data in ordem table only if one line of the entrada table is checked.

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 23 · 2012-07-31T16:19:14+00:00

mysql_query ($sql2a);

Change that line to two lines:

echo $sql2a . '<br/>';
mysql_query($sql2a) or die(mysql_error());

And show the output.

Stardemos 0 Junior Poster · Answer 24 · 2012-07-31T16:21:46+00:00

the worst error i can get....

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''entrada' ('nordem_n', 'lote', 'val', 'designacao', 'familiamarca', 'quantguia',' at line 1

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 25 · 2012-07-31T16:27:02+00:00

pritaeas 2,194 ¯\_(ツ)_/¯

11 Years Ago

INSERT INTO \'entrada\'

Should be:

INSERT INTO entrada

Stardemos 0 Junior Poster · Answer 26 · 2012-07-31T16:27:47+00:00

quotes removed. new error

INSERT INTO ordem(data, nordem, fornecedor, guian, ncliente, cliente) VALUES( '31072012', '13', '23', '1', '2', '2')
INSERT INTO entrada (nordem_n, lote, val, designacao, familiamarca, quantguia, quantconf, atado, posicao, codprod) VALUES('1', '1', '4', '7', '41', '2', '22', '2', '1'),('21', '21', '34546', '6', '45', '646', '1', '', '1')
Column count doesn't match value count at row 1

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 27 · 2012-07-31T16:29:00+00:00

pritaeas 2,194 ¯\_(ツ)_/¯

11 Years Ago

You specify 10 columns, yet provide only 9 values.

Stardemos 0 Junior Poster · Answer 28 · 2012-07-31T16:32:17+00:00

acidently erased the first value.. new/old error, i cannot understand what is wrong now.

Notice: Undefined index: check in C:\wamp\www\sermail db\entrada.php on line 36
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

     <?php
    //conecção ao servidor
    $conn = mysql_connect("localhost", "root")or die("sem conecção ao servidor");
    $db = mysql_select_db("sermail")or die("Base de dados não foi encontrada");
    // VAr
    //table ordem
    $data = date("dmY");
    $nordem = $_POST['nordem'];
    $guian = $_POST['guian'];
    $ncliente = $_POST['ncliente'];
    $cliente = $_POST['cliente'];
    $fornecedor = $_POST['fornecedor'];

    //insert data table ordem
    echo $sql="INSERT INTO ordem(data, nordem, fornecedor, guian, ncliente, cliente)
    VALUES( '".$data."', '".$nordem."', '".$fornecedor."', '".$guian."', '".$ncliente."', '".$cliente."')";
    echo "</br>";
    mysql_query ($sql);

    //insert data table entrada
    $sql2a = 'INSERT INTO entrada (nordem_n, lote, val, designacao, familiamarca, quantguia, quantconf, atado, posicao, codprod) VALUES';
    for ($i=0; $i<count($_POST['check']); $i++) {
    $sql2a .= '(\'' . $_POST['nordem_n'][$i] . '\',\'' . $_POST['lote'][$i] . '\', \'' . $_POST['val'][$i] . '\', \'' . $_POST['designacao'][$i] . '\', \'' . $_POST['familiamarca'][$i] . '\', \'' . $_POST['quantguia'][$i] . '\', \'' . $_POST['quantconf'][$i] . '\', \'' . $_POST['atado'][$i] . '\', \'' . $_POST['posicao'][$i] . '\', \'' . $_POST['codprod'][$i] . '\')';
    if ($i<count($_POST['check']) - 1) {
    $sql2a .= ',';
    } 
    } 
        echo $sql2a . '<br/>';
    mysql_query($sql2a) or die(mysql_error());


    ?>
    <?php
    mysql_close();

    ?>

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 29 · 2012-07-31T16:36:38+00:00

Forgot to check any checkboxes... That's when you can get that error. Basically if nothing is checked you shouldn't execute the second query.

Insert data in multiple tables and rows

Recommended Answers Collapse Answers

All 71 Replies

Recommended Answers