thanks..
i really have a ginormous error..
( ! ) SCREAM: Error suppression ignored for
( ! ) Notice: Use of undefined constant username - assumed 'username' in C:\wamp\www\sermail db\entrada.php on line 3
Call Stack
Time Memory Function Location
1 0.0005 170280 {main}( ) ..\entrada.php:0
( ! ) SCREAM: Error suppression ignored for
( ! ) Notice: Undefined index: username in C:\wamp\www\sermail db\entrada.php on line 3
Call Stack
Time Memory Function Location
1 0.0005 170280 {main}( ) ..\entrada.php:0
( ! ) SCREAM: Error suppression ignored for
( ! ) Notice: Undefined index: username in C:\wamp\www\sermail db\entrada.php on line 17
Call Stack
Time Memory Function Location
1 0.0005 170280 {main}( ) ..\entrada.php:0
<?php
session_start();
$_SESSION[username];
//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'];
$nordem_n = $_POST['nordem'];
$obs= $_POST['obs'];
$username= $_POST['username'];
//$query= "select nordem from ordem where nordem='".$nordem."'";
// $query1=mysql_query($query);
// if ($_POST['nordem'] == $query1) include("common.php");
// $msg = "Nº. ordem já inserido!";
// confirm($msg);;
$sql="INSERT INTO ordem(data, nordem, fornecedor, guian, ncliente, cliente, obs, username)
VALUES( '".$data."', '".$nordem."', '".$fornecedor."', '".$guian."', '".$ncliente."', '".$cliente."', '".$obs."', '".$username."')";
echo "</br>";
mysql_query ($sql) or die(mysql_error());
$sql2a = 'INSERT INTO entrada ( nordem_n, lote, val, designacao,filtro, familiamarca, quantguia, quantconf, atado, posicao, codprod) VALUES';
for ($i=0; $i<count($_POST['check']); $i++) {
if ($_POST['check'][$i] == 0) continue;
$sql2a .= '('.$nordem.',\'' . $_POST['lote'][$i] . '\', \'' . $_POST['val'][$i] . '\', \'' . $_POST['designacao'][$i] . '\', \'' . $_POST['filtro'][$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) or die(mysql_error());
// pagina inicial, Furmolario.html
Echo "<a href='formulario.html'>Nova ficha de entrada</a>";
?>
<?php
mysql_close();
?>
is the code correct? anyway, I will read the code until find the error....