|
-
Jan 24th, 2013, 01:04 PM
#3
Thread Starter
Lively Member
Re: $_POST problem
Here is 'select_issue2.php', I've included the whole page, as its just one form, which I believe is posting correctly (bar the issues mentioned above):
<html>
<head>
<title>View Issues</title>
</head>
<body marginheight="0" topmargin="0" marginwidth="0"
leftmargin="0" style="margin:0;padding:0" bgcolor="#B0E0E6">
<h1></h1>
<form action="select_issue3.php" method="post">
<?php
include_once('functions.php');
$issueid=max($_POST['issueid']);
$result_array=get_dataset($server_name, $user_name, $password, $database_name,"call sp_select_issue(".$issueid.")");
?>
<table border="2" style="border:solid black" cellpadding="1" cellspacing="0" width="100%" bgcolor='white'>
<tr>
<td>
<table>
<td>
<input type='submit' id='btnupdate' name='btnupdate' value='Update Bond' >
</td>
<td>
<input type='submit' name='btncancel'id='btncancel' value='Cancel Updates' >
</td>
<td>
<input type='submit' name='btndelete'id='btndelete' value='Delete Bond' >
</td>
</table>
</td>
</tr>
<?php
$irow=0;
foreach ($result_array as $row)
{
$bond_description = $row['description'];
$bond_issue_id = $row['issue_id'];
?>
<td><table width='100%'>
<tr>
<td>
Description
</td>
<td>
<?php echo "<input type='Text' width='100%' id='bond_description' name='bonddescription[]' value='" .$row['description']. "'>";?>
<?php echo "<input type='hidden' id='issue_id' name='issueid[]' value='".$row['issue_id']."'>";?>
</td>
</tr>
<tr>
<td align="left">Notes</td>
<td>
<?php echo "<input type='Text' size='50' id='notes' name='notes[]' value='" .$row['notes']. "'>";?>
</td>
</tr>
</table>
</td>
<td>
<table width='100%'>
<tr>
<td align="left">Currency</td>
<td>
<?php drop_down('currency_id[]','currency_id','currency_id','currency_ticker',$server_name, $user_name, $password, $database_name,"call sp_currency",$row);?>
</td>
</tr>
<tr>
<td align="left">Coupon</td>
<td>
<?php echo "<input type='Text' width='100%' id='coupon' name='coupon[]' value='" .$row['coupon']. "'>";?>
</td>
</tr>
<tr>
<td align="left">Coupon Type</td>
<td>
<?php drop_down('coupon_type_id[]','coupon_type_id','coupon_type_id','coupon_type_name',$server_name, $user_name, $password, $database_name,"call sp_coupon_type",$row);?>
</td>
</tr>
<tr>
<td align="left">Coupon Frequency</td>
<td>
<?php drop_down('coupon_frequency_id[]','coupon_frequency_id','coupon_frequency_id','coupon_frequency_code',$server_name, $user_name, $password, $database_name,"call sp_coupon_frequency",$row);?>
</td>
</tr>
<tr>
<td align="left">Day Count</td>
<td>
<?php drop_down('day_count_id[]','day_count_id','day_count_id','day_count_name',$server_name, $user_name, $password, $database_name,"call sp_day_count",$row);?>
</td>
</tr>
</table>
</td>
<td>
<table width='100%' height='100%'>
<tr>
<td>
Bookrunners
</td>
<td>
Exchanges
</td>
</tr>
<tr>
<td>
<?php drop_down('bookrunnerid[]','institution_id','institution_id','bond_ticker',$server_name, $user_name, $password, $database_name,"call sp_bookrunner_eligible",$row,'3',"call sp_bookrunner(".$bond_issue_id.")",'institution_id');?>
</td>
<td>
<?php drop_down('exchangeid[]','exchange_id','exchange_id','exchange_code',$server_name, $user_name, $password, $database_name,"call sp_exchange(1)",$row,'3',"call sp_exchange_issue(".$bond_issue_id.")",'exchange_id');?>
</td>
</tr>
</table>
</td>
<td>
<table width='100%'>
<tr>
<td align="left">Price To</td>
<td>
<?php drop_down('price_to_id[]','price_to_id','price_to_id','price_to_name',$server_name, $user_name, $password, $database_name,"call sp_price_to",$row);?>
</td>
</tr>
<tr>
<td align="left">Quote Convention</td>
<td>
<?php drop_down('quote_convention_id[]','quote_convention_id', 'quote_convention_id', 'quote_convention_name',$server_name, $user_name, $password, $database_name,"call sp_quote_convention(1)",$row);?>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width='100%'>
<tr>
<td align="left">Issuer</td>
<td>
<?php drop_down('issuer_id[]','issuer_id', 'institution_id', 'institution_name',$server_name, $user_name, $password, $database_name,"call sp_institution",$row);?>
</td>
</tr>
<tr>
<td align="left">Guarantor</td>
<td>
<?php drop_down('guarantor_id[]','guarantor_id', 'institution_id', 'institution_name',$server_name, $user_name, $password, $database_name,"call sp_institution",$row);?>
</td>
</tr>
<tr>
<td align="left">Sub Sector</td>
<td>
<?php drop_down('sub_sector_id[]','sub_sector_id','sub_sector_id','sub_sector_name',$server_name, $user_name, $password, $database_name,"call sp_sub_sector",$row);?>
</td>
</tr>
<tr>
<td align="left">Market</td>
<td>
<?php drop_down('market_id[]','market_id','market_id','market_name',$server_name, $user_name, $password, $database_name,"call sp_market",$row);?>
</td>
</tr>
</table>
</td>
<td>
<table width='100%'>
<tr>
<td align="left">CUSIP</td>
<td>
<?php echo "<input type='Text' width='100%' id='cusip' name='cusip[]' value='" .$row['cusip']. "'>";?>
</td>
</tr>
<tr>
<td align="left">Bloomberg Number</td>
<td>
<?php echo "<input type='Text' width='100%' id='bloomberg_number' name='bloomberg_number[]' value='" .$row['bloomberg_number']. "'>";?>
</td>
</tr>
<tr>
<td align="left">ISIN</td>
<td>
<?php echo "<input type='Text' width='100%' id='isin' name='isin[]' value='" .$row['isin']. "'>";?>
</td>
</tr>
</table>
</td>
<td>
<table width='100%'>
<tr>
<td align="left">Moody</td>
<td>
<?php echo "<input type='Text' width='100%' id='moody' name='moody[]' value='" .$row['moody']. "'>";?>
</td>
</tr>
<tr>
<td align="left">Fitch</td>
<td>
<?php echo "<input type='Text' width='100%' id='fitch' name='fitch[]' value='" .$row['fitch']. "'>";?>
</td>
</tr>
<tr>
<td align="left">S&P</td>
<td>
<?php echo "<input type='Text' width='100%' id='sandp' name='sandp[]' value='" .$row['sandp']. "'>";?>
</td>
</tr>
</table>
</td>
<td>
<table width='100%'>
<td align="left">Capital Type</td>
<td>
<?php drop_down('capital_id[]','capital_id','capital_id','capital_name',$server_name, $user_name, $password, $database_name,"call sp_capital",$row);?>
</td>
</tr>
<tr>
<td align="left">Collateral Type</td>
<td>
<?php drop_down('collateral_type_id[]','collateral_type_id','collateral_type_id','collateral_type_name',$server_name, $user_name, $password, $database_name,"call sp_collateral_type",$row);?>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width='100%'>
<tr>
<td align='right'>Bid ASW</td>
<td align='center'></td>
<td align='left'>Ask ASW</td>
<td align='right'>Bid Sprd</td>
<td align='center'></td>
<td align='left'>Ask Sprd</td>
<td align='right'>Bid Price</td>
<td align='center'></td>
<td align='left'>Ask Price</td>
<td align='right'>Bid YTC</td>
<td align='center'></td>
<td align='left'>Ask YTC</td>
<td align='right'>Bid YTM</td>
<td align='center'></td>
<td align='left'>Ask YTM</td>
<td>Date</td>
<td>Time</td>
<td>Source</td>
</tr>
<?php
$result_array=get_dataset($server_name, $user_name, $password, $database_name,"call sp_last_price(".$bond_issue_id.",5)");
$irow=0;
foreach ($result_array as $row1)
{
?>
<td align='right'>
<?php echo "<input type='Text' size='7' id='bid_asw' name='bid_asw[]' value='" .$row1['bid_asw']. "'>";?>
</td>
<td align='center'>
/
</td>
<td align='left'>
<?php echo "<input type='Text' size='7' id='ask_asw' name='ask_asw[]' value='" .$row1['ask_asw']. "'>";?>
</td>
<td align='right'>
<?php echo "<input type='Text' size='7' id='bid_sprd' name='bid_sprd[]' value='" .$row1['bid_sprd']. "'>";?>
</td>
<td align='center'>
/
</td>
<td align='left'>
<?php echo "<input type='Text' size='7' id='ask_sprd' name='ask_sprd[]' value='" .$row1['ask_sprd']. "'>";?>
</td>
<td align='right'>
<?php echo "<input type='Text' size='7' id='bid_price' name='bid_price[]' value='" .$row1['bid_price']. "'>";?>
</td>
<td align='center'>
/
</td>
<td align='left'>
<?php echo "<input type='Text' size='7' id='ask_price' name='ask_price[]' value='" .$row1['ask_price']. "'>";?>
</td>
<td align='right'>
<?php echo "<input type='Text' size='7' id='bid_ytc' name='bid_ytc[]' value='" .$row1['bid_ytc']. "'>";?>
</td>
<td align='center'>
/
</td>
<td align='left'>
<?php echo "<input type='Text' size='7' id='ask_ytc' name='ask_ytc[]' value='" .$row1['ask_ytc']. "'>";?>
</td>
<td align='right'>
<?php echo "<input type='Text' size='7' id='bid_ytm' name='bid_ytm[]' value='" .$row1['bid_ytm']. "'>";?>
</td>
<td align='center'>
/
</td>
<td align='left'>
<?php echo "<input type='Text' size='7' id='ask_ytm' name='ask_ytm[]' value='" .$row1['ask_ytm']. "'>";?>
</td>
<td>
<?php echo "<input type='Text' size='10' id='price_date' name='price_date[]' value='" .$row1['price_date']. "'>";?>
</td>
<td>
<?php echo "<input type='Text' size='8' id='price_date' name='price_time[]' value='" .$row1['price_time']. "'>";?>
</td>
<td>
<?php drop_down('exchange_code[]','exchange_id','exchange_id','exchange_code',$server_name, $user_name, $password, $database_name,"call sp_exchange(1)",$row1);?>
</td>
</tr>
<?php
$irow++;
}
$db1->close;
?>
</table>
</td>
<td>
<table width='100%'>
<tr>
<td align="left">Issue Benchmark</td>
<td>
<?php drop_down('issue_benchmark_id[]','issue_benchmark_id','issue_id','description',$server_name, $user_name, $password, $database_name,"call sp_benchmark",$row);?>
</td>
</tr>
<tr>
<td align="left">Current Benchmark</td>
<td>
<?php drop_down('current_benchmark_id[]','current_benchmark_id','issue_id','description',$server_name, $user_name, $password, $database_name,"call sp_benchmark",$row);?>
</td>
</tr>
<tr>
<td align="left">Issue Swap Spread</td>
<td>
<?php echo "<input type='Text' width='100%' id='issue_swap_spread' name='issue_swap_spread[]' value='" .$row['issue_swap_spread']. "'>";?>
</td>
</tr>
<tr>
<td align="left">Issue Benchmark Spread</td>
<td>
<?php echo "<input type='Text' width='100%' id='issue_benchmark_spread' name='issue_benchmark_spread[]' value='" .$row['issue_benchmark_spread']. "'>";?>
</td>
</tr>
<tr>
<td align="left">Issue Price</td>
<td>
<?php echo "<input type='Text' width='100%' id='issue_price' name='issue_price[]' value='" .$row['issue_price']. "'>";?>
</td>
</tr>
<tr>
<td align="left">Coupon Step</td>
<td>
<?php echo "<input type='Text' width='100%' id='coupon_step' name='coupon_step[]' value='" .$row['coupon_step']. "'>";?>
</td>
</tr>
</table>
</td>
<td>
<table width='100%'>
<tr>
<td align="left">Announcement Date</td>
<td>
<?php echo "<input type='Text' width='100%' id='announcement_date' name='announcement_date[]' value='" .$row['announcement_date']. "'>";?>
</td>
</tr>
<tr>
<td align="left">Interest Accrual Date</td>
<td>
<?php echo "<input type='Text' width='100%' id='interest_accrual_date' name='interest_accrual_date[]' value='" .$row['interest_accrual_date']. "'>";?>
</td>
</tr>
<tr>
<td align="left">First Settlement Date</td>
<td>
<?php echo "<input type='Text' width='100%' id='first_settle_date' name='first_settle_date[]' value='" .$row['first_settle_date']. "'>";?>
</td>
</tr>
<tr>
<td align="left">First Coupon Date</td>
<td>
<?php echo "<input type='Text' width='100%' id='first_coupon_date' name='first_coupon_date[]' value='" .$row['first_coupon_date']. "'>";?>
</td>
</tr>
<tr>
<td align="left">Maurity Date</td>
<td>
<?php echo "<input type='Text' width='100%' id='maturity_date' name='maturity_date[]' value='" .$row['maturity_date']. "'>";?>
</td>
</tr>
<tr>
<td align="left">Call Date</td>
<td>
<?php echo "<input type='Text' width='100%' id='first_call_date' name='first_call_date[]' value='" .$row['first_call_date']. "'>";?>
</td>
</tr>
</table>
</td>
<td>
<table width='100%'>
<tr>
<td align="left">Amount Issued</td>
<td>
<?php echo "<input type='Text' width='100%' id='amount_issued' name='amount_issued[]' value='" .$row['amount_issued']. "'>";?>
</td>
<td></td>
</tr>
<tr>
<td align="left">Amount Outstanding</td>
<td>
<?php echo "<input type='Text' width='100%' id='amount_outstanding' name='amount_outstanding[]' value='" .$row['amount_outstanding']. "'>";?>
</td>
</tr>
<tr>
<td align="left">Minimum Size</td>
<td>
<?php echo "<input type='Text' width='100%' id='min_size' name='min_size[]' value='" .$row['min_size']. "'>";?>
</td>
</tr>
<tr>
<td align="left">Increment</td>
<td>
<?php echo "<input type='Text' width='100%' id='increment' name='increment[]' value='" .$row['increment']. "'>";?>
</td>
</tr>
<tr>
<td align="left">Par Amount</td>
<td>
<?php echo "<input type='Text' width='100%' id='par_amount' name='par_amount[]' value='" .$row['par_amount']. "'>";?>
</td>
</tr>
</table>
</td>
</tr>
<?php $irow++;
}
$db1->close;
?>
</table>
</form>
</body>
</html>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|