rendered paste body<?php
session_start();
//clears all session data - debugging only
//unset($_SESSION['part_form']);
if(!isset($_POST["ecn_create"]))
{
//insert data into db
//initiate connection to mysql
include 'inc/config.php';
include 'inc/opendb.php';
//we need to create the ecn_notes entry first to produce an ECN number
echo "Loading ECN data...<br />";
$add_ecn=$_SESSION['add_ecn']['ecn_data'];
print_r($add_ecn);
echo "Filtering for query...<br />";
$insert = array();
//keys which we dont want to add
foreach($add_ecn as $key => $value)
{
if($key == 'planning'
OR $key == 'nextstep')
continue;
$insert[] = $key.' = "'.$value.'"';
}
echo "Inserting ECN data to mysql...<br />";
//print_r($insert);
// mysql_query("INSERT INTO `Ecn_Notes` SET ".implode(',',$insert));
// $add_code = "FLUSH PRIVILEGES";
// mysql_query($add_code) or die('Error, insert query failed');
//
// $ecn_no = mysql_insert_id();
// echo "<br />ECN created with ID number: $ecn_no <br />";
echo "<br />Adding parts...<br />";
$parts=$_SESSION['part_form'];
echo "<br />Parts array before key filter:<br />";
print_r($parts);
$insert=array();
echo "<br /><br />";
//keys which we dont want to add
foreach($parts as $key => $value)
{
if($key == 'part_restart'
OR $key == 'part_add'
OR $key == 'part_finished')
continue;
$insert[] = $key.' = "'.$value.'"';
}
echo "<br />Parts array after key filter:<br />";
print_r($insert);
foreach($insert as $part_form)
{
// mysql_query("INSERT INTO `Ecn_Notes` SET ".implode(',',$part_form));
// $part_form = "FLUSH PRIVILEGES";
// mysql_query($part_form) or die('Error, insert query failed');
//
//// print('<br /><strong>Part number:</strong> '.$part_form['txtSearch'].'<br />');
//// print('<strong>Part quanitity:</strong> '.$part_form['part_qty'].'<br />');
//// print('<strong>Part action:</strong> '.$part_form['part_num_action'].'<br />');
//// mysql_query("INSERT INTO `Parts` SET $ecn_no,".implode(',',$insert));
}
echo "<br />Closing connection...<br />";
include 'inc/closedb.php';
}
?>
<!--<!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=iso-8859-1" />
<title>ECN Confirmation</title>
<script language="JavaScript" type="text/javascript" src="ajax_search.js"></script>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form action="<?php //echo $_SERVER['PHP_SELF']; ?>" method="post" name="confirmation"><input name="ecn_create" type="submit" value="Create ECN" />
</form>
</body>
</html>-->