public function paypalpost() { /* $package_data = $db->getRows('SELECT * FROM packages WHERE id IN ('.implode(",",$array_pack_id).')'); print_r($package_data); foreach ($package_data as $package_data) { $query = "INSERT INTO orders (user_id,order_id,order_data,order_total) VALUES ('".$_SESSION['agent']['user_id']."','".$_POST['txn_id']."','".$package_data['title']."','".$package_data['price']."')"; mysql_query($query); } */ /* $name= Input::get("name"); $sql="INSERT INTO test (name) VALUES ('".$name."')"; $status= DB::INSERT(DB::raw($sql)); if ($status=1) return "Records insterted successfully". $status; else return "problem inserting records in DB"; */ $agent_id = Input::get('agent_id'); $package_id = Input::get('package_id'); $txn_id = Input::get("txn_id"); $purchasedPacks = null; $values = explode(',', $package_id); $packages = packages::whereIn('id', $values)->get(); foreach ($packages as $pack) { $purchasedPacks = $purchasedPacks . $pack['package'] . "<BR>"; } return 'Agent_id is ' . $agent_id . ' Packages Bought are <BR>' . $purchasedPacks . ' based on Transaction_id ' . $txn_id; //AFTER RETREIVING VALUES NOW YOU NEED SEARCH CORRECT PACKAGE TITLE AND PRICE AND INSERT INTO ORDERS TABLE WITH //CORRECT TXN_IDS AND AGENT_ID //User will pass $array_pack_id, $_SESSION['agent']['user_id'],$_POST['txn_id'],$package_data['title'],$package_data['price'] }