|
|
Initial Public Offers (IPO)
|
|
|
error_reporting(E_ALL ^ E_NOTICE);
$connect=mysql_connect("niksun.makeursite.com","indiaipo","stock2005");
mysql_select_db("indiaipo",$connect)or die(mysql_error());
$nextwf=date('d-m-Y', strtotime('-7 days'));
$lastwf=date('d-m-Y', strtotime('+7 days'));
$nextm=date('d-m-Y', strtotime('-3 months'));
$lastwf=explode("-",$lastwf);
$lastw=$lastwf[2] . "-" . $lastwf[1] . "-" . $lastwf[0];
$today=date("Y-m-j");
$nextm=explode("-",$nextm);
$nextmf=$nextm[2] . "-" . $nextm[1] . "-" . $nextm[0];
$nextwf=explode("-",$nextwf);
$nextw=$nextwf[2] . "-" . $nextwf[1] . "-" . $nextwf[0];
?>
Issue Open Now |
Issue Name |
Close Date |
Min. Rate |
Max. Rate |
Type |
$get_value = " SELECT issue.id,issue.type_issue,issue.issue,DATE_FORMAT(issue.issue_open,'%d-%m-%Y') as date1, " ;
$get_value .= " DATE_FORMAT(issue.issue_close,'%d-%m-%Y') as date2, issue.issue_size," ;
$get_value .= " issue.lower_price, issue.upper_price,issue.qib, issue.non_instition, " ;
$get_value .= " issue.retail, issue.issue_dec,issue.recommon, " ;
$get_value .= " issue.Total_Size, issue.registrar_issue,issue.fundings,issue.market,issue.company_name,issue.shares,issue.application , " ;
$get_value .= " company_name.company_name FROM issue,company_name " ;
$get_value .= " WHERE company_name.id=issue.company_name and ((issue.issue_open>'$nextw' and issue.issue_close<='$lastw') or (issue.issue_open<='$lastw' and issue.issue_open>'$nextw')) and (issue.issue_close>='$today') order by issue.issue_open DESC";
$exec_value =mysql_query($get_value);
$maxrows=mysql_num_rows($exec_value);
$mycolor1=1;
if($maxrows > 0)
{
while($row2=mysql_fetch_assoc($exec_value))
{
$mytype=$row2['issue'];
if($mytype=='')
{
$mytype="N/A";
}
?>
|
|
Rs. /- |
Rs. /- |
|
}
}
else
{
?>
----This Folder is Empty---- |
} ?>
|
ForthComing Issue |
Issue Name |
Prospectus |
Date of filing with SEBI |
$get_value1="SELECT issue.id,issue.company_name,date_format(issue.issue_open,'%d-%m-%y') as date1,
issue.issue,date_format(issue.issue_close,'%d-%m-%y') as date2,
issue.fundings,issue.market,issue.upper_price,issue.lower_price,issue.prospectus,date_format(issue.sebi,'%d-%m-%y') as sebi,company_name.company_name FROM `issue`,`company_name`
WHERE company_name.id=issue.company_name and issue.issue_open='0000-00-00' and issue.issue_close='0000-00-00' order by issue.sebi DESC";
$exec_value1 = mysql_query($get_value1);
$maxrows1=mysql_num_rows($exec_value1);
if($maxrows1>0)
{
$mycount=1;
$mycolor2=1;
while($row=mysql_fetch_assoc($exec_value1))
{
if($mycount<=8)
{
?>
|
if($row['prospectus']<>'')
{
?>
echo "Download";?>
}
else
{
?>
N/A
}
?> |
if($row['sebi']<>'')
{
?>
}
else
{
?>
N/A
}
?> |
}
if($mycount==9)
{
?>
}
$mycount=$mycount+1;
}
}
else
{
?>
----This Folder is Empty---- |
}
?>
|
New Listing |
Company Name |
Opens On |
Closes On |
Price |
BSE Price |
NSE Price |
List |
Close |
List |
Close |
$get_value="SELECT company_name.company_name, date_format(iporates.issue_open,'%d-%m-%y') as opendate, date_format(iporates.issue_close,'%d-%m-%y') as closedate, iporates.issue_price,
iporates.bse_list_price, iporates.bse_high, iporates.bse_low, iporates.bse_close,
iporates.nse_list_price, iporates.nse_high, iporates.nse_low, iporates.nse_close from company_name,iporates where iporates.company_id=company_name.id order by iporates.issue_close DESC LIMIT 0, 4";
$exec_value =mysql_query($get_value);
$res=mysql_num_rows($exec_value);
while($row2=mysql_fetch_assoc($exec_value))
{
if($res > '0')
{
?>
echo ucwords(strtolower($row2['company_name']));?> |
=$row2['opendate']?>
|
=$row2['closedate']?>
|
if($row2['issue_price']=='0')
echo "N/A";
else
echo $row2['issue_price'];
?> |
if($row2['bse_list_price']=='0')
echo "N/A";
else
echo $row2['bse_list_price'];
?> |
if($row2['bse_close']=='0')
echo "N/A";
else
echo $row2['bse_close'];
?> |
if($row2['nse_list_price']=='0')
echo "N/A";
else
echo $row2['nse_list_price'];
?> |
if($row2['nse_close']=='0')
echo "N/A";
else
echo $row2['nse_close'];
?> |
}
}
?>
|
Recent Issue |
Name |
Opening Date |
Price |
Closing Date |
|
|
|
function issue_detail()
{
$lastwf=date('d-m-Y', strtotime('+7 days'));
$nextwf=date('d-m-Y', strtotime('-7 days'));
$lastwf=explode("-",$lastwf);
$lastw=$lastwf[2] . "-" . $lastwf[1] . "-" . $lastwf[0];
$nextwf=explode("-",$nextwf);
$nextw=$nextwf[2] . "-" . $nextwf[1] . "-" . $nextwf[0];
?>
error_reporting(E_ALL ^ E_NOTICE);
$connect=mysql_connect("niksun.makeursite.com","indiaipo","stock2005");
mysql_select_db("indiaipo",$connect)or die(mysql_error());
$nextwf=date('d-m-Y', strtotime('-7 days'));
$lastwf=date('d-m-Y', strtotime('+7 days'));
$nextm=date('d-m-Y', strtotime('-3 months'));
$lastwf=explode("-",$lastwf);
$lastw=$lastwf[2] . "-" . $lastwf[1] . "-" . $lastwf[0];
$today=date("Y-m-j");
$nextm=explode("-",$nextm);
$nextmf=$nextm[2] . "-" . $nextm[1] . "-" . $nextm[0];
$nextwf=explode("-",$nextwf);
$nextw=$nextwf[2] . "-" . $nextwf[1] . "-" . $nextwf[0];
?>
}
?>
|
|
|