PHP Source code download for Printing Press Management System

billing.php

<?php
	include("includes/db.php");
	include("includes/functions.php");
	
	if($_REQUEST['command']=='update'){
		$name=$_REQUEST['name'];
		$email=$_REQUEST['email'];
		$address=$_REQUEST['address'];
		$phone=$_REQUEST['phone'];
		
		$result=mysql_query("insert into customers values('','$name','$email','$address','$phone')");
		$customerid=mysql_insert_id();
		$date=date('Y-m-d');
		$result=mysql_query("insert into orders values('','$date','$customerid')");
		$orderid=mysql_insert_id();
		
		$max=count($_SESSION['cart']);
		for($i=0;$i<$max;$i++){
			$pid=$_SESSION['cart'][$i]['productid'];
			$q=$_SESSION['cart'][$i]['qty'];
			$price=get_price($pid);
			mysql_query("insert into order_detail values ($orderid,$pid,$q,$price)");
		}
		die('Thank You! your order has been placed!');
	}
?>
<!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=utf-8" />
<title>Billing Info</title>
<script language="javascript">
	function validate(){
		var f=document.form1;
		if(f.name.value==''){
			alert('Your name is required');
			f.name.focus();
			return false;
		}
		f.command.value='update';
		f.submit();
	}
</script>
</head>


<body>
<form name="form1" onsubmit="return validate()">
    <input type="hidden" name="command" />
	<div align="center">
        <h1 align="center">Billing Info</h1>
        <table border="0" cellpadding="2px">
        	<tr><td>Order Total:</td><td><?php echo get_order_total()?></td></tr>
            <tr><td>Your Name:</td><td><input type="text" name="name" /></td></tr>
            <tr><td>Address:</td><td><input type="text" name="address" /></td></tr>
            <tr><td>Email:</td><td><input type="text" name="email" /></td></tr>
            <tr><td>Phone:</td><td><input type="text" name="phone" /></td></tr>
            <tr><td>&nbsp;</td><td><input type="submit" value="Place Order" /></td></tr>
        </table>
	</div>
</form>
</body>
</html>

<?php

include("includes/db.php");

include("includes/functions.php");

if($_REQUEST['command']=='update'){

$name=$_REQUEST['name'];

$email=$_REQUEST['email'];

$address=$_REQUEST['address'];

$phone=$_REQUEST['phone'];

$result=mysql_query("insert into customers values('','$name','$email','$address','$phone')");

$customerid=mysql_insert_id();

$date=date('Y-m-d');

$result=mysql_query("insert into orders values('','$date','$customerid')");

$orderid=mysql_insert_id();

$max=count($_SESSION['cart']);

for($i=0;$i<$max;$i++){

$pid=$_SESSION['cart'][$i]['productid'];

$q=$_SESSION['cart'][$i]['qty'];

$price=get_price($pid);

mysql_query("insert into order_detail values ($orderid,$pid,$q,$price)");

}

die('Thank You! your order has been placed!');

}

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Billing Info</title>

function validate(){

var f=document.form1;

if(f.name.value==''){

alert('Your name is required');

f.name.focus();

return false;

}

f.command.value='update';

f.submit();

}

</script>

</head>

<body>

<h1 align="center">Billing Info</h1>

<tr><td>Order Total:</td><td><?php echo get_order_total()?></td></tr>

<tr><td>Address:</td><td><input type="text" name="address" /></td></tr>

<tr><td>Email:</td><td><input type="text" name="email" /></td></tr>

<tr><td>Phone:</td><td><input type="text" name="phone" /></td></tr>

</table>

</div>

</form>

</body>

</html>

feedback_process.php

<?php
   include('config.php');

$sql="INSERT INTO contact (Name, Email, Phone, Subject) 
VALUES ('$_POST[name]', '$_POST[email]', '$_POST[phone]', '$_POST[text]')";

if (!mysqli_query($mysqli,$sql))
  {
  die('Error: ' . mysqli_error($mysqli));
  }
  header("location: index.php");
  echo "1 record added";

 mysqli_close($mysqli);
?>

<?php

include('config.php');

$sql="INSERT INTO contact (Name, Email, Phone, Subject)

VALUES ('$_POST[name]', '$_POST[email]', '$_POST[phone]', '$_POST[text]')";

if (!mysqli_query($mysqli,$sql))

{

die('Error: ' . mysqli_error($mysqli));

}

header("location: index.php");

echo "1 record added";

mysqli_close($mysqli);

custUpdate.php

<?php
include 'config.php';

?>

<?php 

if (isset($_POST['submit'])){

echo $fname=$_POST['firstname'];
echo  $uname=$_POST['lastname'];
echo $phone=$_POST['phone'];
echo $email=$_POST['Email'];
echo  $country=$_POST['country'];
echo $city=$_POST['city'];
echo $address=$_POST['address'];
echo  $pcode=$_POST['pcode'];
$id=$_POST['ID'];

echo $query="update customer  set FullName = '$fname', UserName = '$uname', Phone = '$phone',Email = '$email', Country = '$country', City = '$city', Adress = '$address', PostalCode = '$pcode' where Cust_Id = $id";
$rows=mysqli_query($mysqli,$query);
echo "succes full updated ".$rows;
mysqli_close($con);
header("location: profile.php?msg=succes full update one record");
exit();
}

?>

<?php

include 'config.php';

<?php

if (isset($_POST['submit'])){

echo $fname=$_POST['firstname'];

echo $uname=$_POST['lastname'];

echo $phone=$_POST['phone'];

echo $email=$_POST['Email'];

echo $country=$_POST['country'];

echo $city=$_POST['city'];

echo $address=$_POST['address'];

echo $pcode=$_POST['pcode'];

$id=$_POST['ID'];

echo $query="update customer set FullName = '$fname', UserName = '$uname', Phone = '$phone',Email = '$email', Country = '$country', City = '$city', Adress = '$address', PostalCode = '$pcode' where Cust_Id = $id";

$rows=mysqli_query($mysqli,$query);

echo "succes full updated ".$rows;

mysqli_close($con);

header("location: profile.php?msg=succes full update one record");

exit();

}

insertCustomer.php

<?php
   include('config.php');

$sql="INSERT INTO customer (FullName, UserName, Phone, Email, Password, Re_Password, Country, City, Adress, PostalCode) 
VALUES ('$_POST[name]', '$_POST[username]', '$_POST[tell]', '$_POST[email]', '$_POST[password1]', '$_POST[password2]', '$_POST[country]', '$_POST[City]', '$_POST[address]', '$_POST[pcode]')";

if (!mysqli_query($mysqli,$sql))
  {
  die('Error: ' . mysqli_error($mysqli));
  }
  header("location: index.php");
  echo "1 record added";

 mysqli_close($mysqli);
?>

<?php

include('config.php');

$sql="INSERT INTO customer (FullName, UserName, Phone, Email, Password, Re_Password, Country, City, Adress, PostalCode)

VALUES ('$_POST[name]', '$_POST[username]', '$_POST[tell]', '$_POST[email]', '$_POST[password1]', '$_POST[password2]', '$_POST[country]', '$_POST[City]', '$_POST[address]', '$_POST[pcode]')";

if (!mysqli_query($mysqli,$sql))

{

die('Error: ' . mysqli_error($mysqli));

}

header("location: index.php");

echo "1 record added";

mysqli_close($mysqli);

employeeValidate.php

<?php 

//include config.php to connect to the database
	include("config.php"); 
	
	//start session
    session_start();
{
		// Define $myusername and $mypassword
	$magaca=$_POST['magaca'];
	$furaha=$_POST['furaha'];
	
	// To protect MySQL injection
	$magaca= mysqli_real_escape_string( $mysqli,$magaca);
	$furaha = mysqli_real_escape_string( $mysqli, $furaha);

    $fetch=mysqli_query( $mysqli, "select Employee_ID from employee where Username='$magaca' and Password = '$furaha'");
    $count=mysqli_num_rows($fetch);
    if($count!="")
    {
    $_SESSION['login_username']=$magaca;
	 header("location: Admin/index.php");
    }
    else
    {
	   header('Location: Sign In.php');
	}

}
?>

<?php

//include config.php to connect to the database

include("config.php");

//start session

session_start();

{

// Define $myusername and $mypassword

$magaca=$_POST['magaca'];

$furaha=$_POST['furaha'];

// To protect MySQL injection

$magaca= mysqli_real_escape_string( $mysqli,$magaca);

$furaha = mysqli_real_escape_string( $mysqli, $furaha);

$fetch=mysqli_query( $mysqli, "select Employee_ID from employee where Username='$magaca' and Password = '$furaha'");

$count=mysqli_num_rows($fetch);

if($count!="")

{

$_SESSION['login_username']=$magaca;

header("location: Admin/index.php");

}

else

{

header('Location: Sign In.php');

}

PHP Source code download for Printing Press Management System

Download full PHP Source code of Printing Press Management System

More helping material on Printing Press Management System System

Related Posts:

Leave a Comment Cancel Reply