All pastes #535633 Raw Edit

Someone

public text v1 · immutable
·published 2007-06-04 04:17 UTC
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'];
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.'"';
}
print_r($insert);
foreach($insert as $part_form)

	{
		echo "print_r insert_part: ";
		print_r($insert_part);
//		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>-->