|
-
Jan 24th, 2013, 02:34 PM
#5
Thread Starter
Lively Member
Re: $_POST problem
Hmm, that doesn't appear to work.
I'm not sure if it will help, but here is the initial page:
<head>
<title>Issues- Reduced View</title>
</head>
<body marginheight="0" topmargin="0" marginwidth="0"
leftmargin="0" style="margin:0;padding:0" bgcolor="#B0E0E6">
<h1></h1>
<form action="reduced_view_issues.php" method="post">
<?php
include_once('functions.php');
if(is_numeric($_POST['ddsub_sector_id'])) {$subsectorid=$_POST['ddsub_sector_id'];} else {$subsectorid='1';}
if(empty($_POST['tbtickersearch'])) {$bondticker="'%'";} else {$bondticker="'".$_POST['tbtickersearch']."%'";}
if(is_numeric($_POST['ddcurrency_id'])) {$currencyid=$_POST['ddcurrency_id'];} else {$currencyid='NULL';}
if(is_numeric($_POST['ddcountry_id'])) {$countryid=$_POST['ddcountry_id'];} else {$countryid='NULL';}
if(empty($_POST['tbenterticker'])) {$enterticker='NULL';} else {$enterticker="'".$_POST['tbenterticker']."'";}
if(empty($_POST['tbenterlevel'])) {$enterlevel='NULL';} else {$enterlevel="'".$_POST['tbenterlevel']."'";}
if(is_numeric($_POST['ddquote_convention_id'])) {$quoteconventionid=$_POST['ddquote_convention_id'];} else {$quoteconventionid='NULL';}
if(is_numeric($_POST['ddbenchmark_id'])) {$benchmarkid=$_POST['ddbenchmark_id'];} else {$benchmarkid='NULL';}
if(empty($_POST['tbentermaturity'])) {$entermaturity='NULL';} else {$entermaturity="'".$_POST['tbentermaturity']."'";}
$result=get_dataset($server_name, $user_name, $password, $database_name,"call sp_filter_issues_reduced_view(".$subsectorid.",".$bondticker.",".$currencyid.",".$countryid.")");
?>
<table border="0"; style="border-collapse:collapse; border:solid 1px black"; bgcolor='#C0C0C0' width=100%>
<tr bgcolor='#C0C0C0' width=100%>
<td align='center'>
<table style="border-collapse:collapse; border:solid 1px #C0C0C0"; bgcolor='#C0C0C0'>
<tr bgcolor='#C0C0C0' width=100%>
<td style="width: auto">
Select Sub Sector
<?php simple_drop_down('ddsub_sector_id','sub_sector_id','sub_sector_name',$server_name, $user_name, $password, $database_name,"call sp_sub_sector",0,$subsectorid); ?>
</td>
<td >
</td>
<td style="width: auto">
Enter Description
<?php echo "<input type='text' name='tbtickersearch' value='".$_POST['tbtickersearch']."'/>"; ?>
</td>
<td style="width: auto">
Select Currency
<?php simple_drop_down('ddcurrency_id','currency_id','currency_ticker',$server_name, $user_name, $password, $database_name,"call sp_currency",1,$currencyid);?>
</td>
<td style="width: auto">
Select Country
<?php simple_drop_down('ddcountry_id','country_id','country_code',$server_name, $user_name, $password, $database_name,"call sp_country",1,$countryid);?>
</td>
<td style="width: auto">
<input type='submit' name='btnsearch' value='Search' style="width: auto">
</td>
</tr>
</table>
</td>
<td align='center'>
<table style="border-collapse:collapse; border:solid 1px #C0C0C0"; bgcolor='#C0C0C0'>
<tr bgcolor='#C0C0C0' width=100%>
<td style="width: auto">
Enter Description
<?php echo "<input type='text' name='tbenterticker' value='".$_POST['tbenterticker']."'/>"; ?>
</td>
<td style="width: auto">
Enter Level
<?php echo "<input type='text' name='tbenterlevel' value='".$_POST['tbenterlevel']."'/>"; ?>
</td>
<td style="width: auto">
Select Quote Convention
<?php simple_drop_down('ddquote_convention_id','quote_convention_id','quote_convention_name',$server_name, $user_name, $password, $database_name,"call sp_all_quote_convention",1,$quoteconventionid);?>
</td>
<td style="width: auto">
Select Benchmark
<?php simple_drop_down('ddbenchmark_id','issue_id','description',$server_name, $user_name, $password, $database_name,"call sp_benchmark",1,$benchmarkid);?>
</td>
<td style="width: auto">
Enter Call/Maturity
<?php echo "<input type='text' name='tbentermaturity' value='".$_POST['tbentermaturity']."'/>"; ?>
</td>
<td style="width: auto">
<input type='submit' name='btncurve' value='View Curve' style="width: auto">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<table border="1"; style="border-collapse:collapse; border:solid 1px black"; bgcolor='white'>
<tr bgcolor='#C0C0C0'>
<td align='center' style="border-collapse:collapse; border:solid 1px black; width: auto";>Description</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Currency</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Call Date</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Maurity Date</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>ISIN</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Moody</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Fitch</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>S&P</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Capital Type</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Bid ASW</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";></td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Ask ASW</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Bid Sprd</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";></td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Ask Sprd</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Bid Price</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";></td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Ask Price</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Bid YTC</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";></td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Ask YTC</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Bid YTM</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";></td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Ask YTM</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Date</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Time</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Source</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Change on Day</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Change from Issue</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Quote Convention</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Price To</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Current Benchmark</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Issue Swap Spread</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Issue Benchmark Spread</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Issue Price</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Coupon Step</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Amt Issued</td>
<td align='center' style="border-collapse:collapse; border:solid 1px black";>Amt Outstanding</td>
</tr>
<?php
$irow=0;
foreach ($result as $row)
{
if ($irow % 2 != 0) # An odd row
$colour = "6699FF";
else # An even row
$colour = "white";
echo "<form action='select_issue3.php' method='post'>";
if (max($_POST['issueid'])==$row['issue_id'])
$colour="yellow";
echo "<tr bgcolor=".$colour.">";
echo "<td style='white-space: nowrap; width: auto; border-collapse:collapse; border:solid 1px black';>";
echo "<input type='submit' style='width: auto' id='bonddescription' name='bonddescription[]' value='" .$row['description']. "'><input type='hidden' id='issueid' name='issueid[]' value='".$row['issue_id']."'>";
echo "</td>";
?>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['currency_ticker'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['first_call_date'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['maturity_date'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['isin'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['moody'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['fitch'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['sandp'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['capital_name'];?>
</td>
<td align='right' style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['bid_asw'];?>
</td>
<td align='center' style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
/
</td>
<td align='left' style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['ask_asw'];?>
</td>
<td align='right' style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['bid_sprd'];?>
</td>
<td align='center' style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
/
</td>
<td align='left' style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['ask_sprd'];?>
</td>
<td align='right' style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['bid_price'];?>
</td>
<td align='center' style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
/
</td>
<td align='left' style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['ask_price'];?>
</td>
<td align='right' style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['bid_ytc'];?>
</td>
<td align='center' style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
/
</td>
<td align='left' style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['ask_ytc'];?>
<td align='right' style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['bid_ytm'];?>
</td>
<td align='center' style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
/
<td align='left' style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['ask_ytm'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['price_date'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['price_time'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['source_code'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo number_format($row['cod'],3);?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo number_format($row['change_from_issue'],3);?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['quote_convention_name'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['price_to_name'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['current_benchmark_description'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['issue_swap_spread'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['issue_benchmark_spread'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['issue_price'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['coupon_step'];?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['amount_issued']/1000000;?>
</td>
<td style='white-space: nowrap; border-collapse:collapse; border:solid 1px black';>
<?php echo $row['amount_outstanding']/1000000;?>
</td>
</tr>
<?php
echo "</form>";
$irow++;
}
?>
</table>
</tr>
<tr>
<td>
<?php //include_once('select_issue2.php'); ?>
</td>
</tr>
</table>
</form>
</body>
</html>
I'm just wondering, as this is the common page in all the statements, whether the issue is here somehow...
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
|