invisio v2.0

<?php
	
	include('config.php');
	
	ini_set('post_max_size', '128M');
			ini_set('upload_max_filesize', '128M'); 
	
	$pkgname = $_POST['pkgname'];
	$pkgcode = $_POST['pkgcode'];
	$pkgurl = $_POST['pkgurl'];
	$price = $_POST['price'];
	$country = $_POST['country'];
	$region = $_POST['region'];
	$days = $_POST['days'];
	$nights = $_POST['nights'];
	
	$others = $_POST['others'];
	
	$pkgdescr = $_POST['pkgdescr'];
	
	$result = $js->query('SELECT * FROM `package` ORDER BY `id`');
			$result->execute();
			$count = $result->rowCount();
			if($count == '0')
			{
				$nw=1;
					
			}
			else
			{
				while($row = $result->fetch(PDO::FETCH_ASSOC)) {
					$nw = $row['id']+1;
				}
			}
			if($nw < '10')
			{
			$pkgid = 'TFETLLC200'.$nw;
			}
			else
			{
				$pkgid 	= 'TFETLLC20'.$nw;
			}
	
	for($x=1; $x<=$days;$x++)
	{
		$daytitle = $_POST['daytitle'.$x];
		$daydetails = $_POST['editor'.$x];
		$highlights = $_POST['highlights'.$x];
		
		$sqls = $js->prepare('INSERT INTO `itinerary` (`pkgid`, `daynumber`, `daytitle`, `daydetails`, `highlights`) VALUES (:pkgid, :x, :daytitle, :daydetails, :highlights)');
			$statuss = $sqls->execute(array(':pkgid' => $pkgid,
										':x' => $x, 
										':daytitle' => $daytitle,
										':daydetails' => $daydetails,
										':highlights' => $highlights)); 
										
		 
			
	}
	
	
	$sql = $js->prepare('INSERT INTO `package` (`pkgid`, `pkgname`, `pkgurl`, `country`, `region`, `pkgcode`, `price`, `days`, `nights`, `pkgdescr`, `others`) VALUES (:pkgid, :pkgname, :pkgurl, :country, :region,  
	:pkgcode, :price, :days, :nights, :pkgdescr, :others)');
			$status = $sql->execute(array(':pkgid' => $pkgid,
										':pkgname' => $pkgname,
										':pkgurl' => $pkgurl, 
										':country' => $country,
										':region' => $region, 
										':pkgcode' => $pkgcode, 
										':price' => $price, 
										':days' => $days,
										':nights' => $nights,
										':pkgdescr' => $pkgdescr,
										':others' => $others));
							
	
?>