Menu
Ask a question Report

Please Php error Notice: Undefined index: type in [Closed]

Posts
1
Registration date
Sunday September 23, 2018
Status
Member
Last seen
September 23, 2018
 -
Programming Ask a question Report
hello
i have an error that persists when i try to move to a page assign this is the capture of the error if you can help me solve the problem. 




<?php
require_once '../library/config.php';
require_once '../library/functions.php';

checkUser();

$action = isset($_GET['action']) ? $_GET['action'] : '';

switch ($action) {
	
	case 'add' :
		assignUser();
		break;
		
	case 'delete' :
		deleteUser();
		break;

	default :
	    // if action is not defined or unknown
		// move to main user page
		header('Location: index.php');
}


/*
functaion is used to assign Hardware, software to user, lab.
if the given qualtity is greater then available quantity then it shows error message to user.
*/
function assignUser()
{
	$entity = $_POST['entity'];
	$type = $_POST['type'];
	$qty = (int)$_POST['txtQty'];
	$dop = $_POST['txtDp'];
	$dor = $_POST['txtDr'];
	$uid = $_POST['txtUid'];
	
	
	$hsql = "SELECT avbl_qty AS avbl 
	        FROM tbl_hardwares
			WHERE id = $type";
	$ssql = "";
	
	if($entity == 1){
		$res = dbQuery($hsql);
		$avbl_qty;
		while($row = dbFetchAssoc($res)){
			$avbl_qty = $row['avbl'];
			
		}//while
		if($avbl_qty < $qty) {
			header('Location: ../view.php?v=assign&error=' . urlencode('Hardware Quantity is more then available Quantity. Please add less.'));	
		}else {
			//update avbl_qty
			$sql = "UPDATE tbl_hardwares 
					SET avbl_qty = avbl_qty - $qty 
					WHERE id = $type";
			//dbQuery($sql);
			$sql = "INSERT INTO tbl_assignments (entity, type, qty, uid, doa, doe, bdate)
					VALUES($entity, $type, $qty, $uid, '$dop', '$dor', NOW() )";
			dbQuery($sql);
			header('Location: ../assign');				
		}//else
	}else {
		//echo "SW";
		$sql = "INSERT INTO tbl_assignments (entity, type, qty, uid, doa, doe, bdate)
					VALUES($entity, $type, $qty, $uid, '$dop', '$dor', NOW() )";
			dbQuery($sql);
		header('Location: ../assign');				
	}
}

?>
See more 
Ask a question