em_product_change_access.php

This is example for E-Market to use sequential file instead of database.

<?php
	session_start();

	$filename = '../Database/' . $_SESSION['system'] .  '/product.txt';
   if (!$handle = fopen($filename, 'r')) {
		echo "Cannot open file ($filename)";
      exit;
   }
	$contents = fread($handle, filesize($filename));
	$productlist = split('~',$contents) ;
	fclose($handle);

   if (!$handle = fopen($filename, 'w')) {
		echo "Cannot open file ($filename)";
      exit;
   }

	$c = "";
	foreach ($productlist as $value) {
		$data = explode(",",$value) ;
		$productcode2 = $data[0];
		$productname2 = $data[1];
		$price2 = $data[2];
		$unitname2 = $data[3];
		$qoh2 = $data[4];
		if ($productcode2 == $productcode) {
			$productname2 = $productname;
			$price2 = $price;
			$unitname2 = $unitname;
			$qoh2 = $qoh;
			$value = $productcode2 . ',' . $productname2 . ',' . $price2 . ',' . $unitname2 . ',' . $qoh2 ;
		}
		if ($c=='') {
			$c = $value ;
		} else {
			$c = $c . '~' . $value ;
		}
	}
	fwrite($handle, $c) ;
	fclose($handle) ;

	$insertGoTo = "EM_product.php";
	header(sprintf("Location: %s", $insertGoTo));

?>