displaying php code with a website builder program
Posted: Tue Sep 29, 2009 4:06 pm
Hey Everyone:
big things have happened with my proj since last posts. I'm back again for a quick question.
The php below displays a sample portfolio and the charts related to that port info.
my problem is that I'm using a website builder prog. in the prog i can create the design with geo shapes and add basically everything u can do manually with code, also it allows u to add code. I have been able to add in the php code and have it show online but now I'm having trouble separating the two parts without getting an $end error. i cant seem to find where the two parts (portfolio and display of charts) split in the code, im hoping another set of eyes will do better.
right now it displays them one after another, I'm hoping i can separate them so i can put them in diff parts of the same page
THANKS IN ADVANCE!
big things have happened with my proj since last posts. I'm back again for a quick question.
The php below displays a sample portfolio and the charts related to that port info.
my problem is that I'm using a website builder prog. in the prog i can create the design with geo shapes and add basically everything u can do manually with code, also it allows u to add code. I have been able to add in the php code and have it show online but now I'm having trouble separating the two parts without getting an $end error. i cant seem to find where the two parts (portfolio and display of charts) split in the code, im hoping another set of eyes will do better.
right now it displays them one after another, I'm hoping i can separate them so i can put them in diff parts of the same page
THANKS IN ADVANCE!
Code: Select all
<div id="portfolio">
Sample Portfolio
<?php
// <div id="symbol">
$stockcount=0;
$stockloop=0;
$stock1session1date="";
$stock1session2date="";
$stock1session3date="";
$stock1session4date="";
$stock1session5date="";
$stock1session1=0;
$stock1session2=0;
$stock1session3=0;
$stock1session4=0;
$stock1session5=0;
$stock1name="";
$stock1low=20000;
$stock2session1date="";
$stock2session2date="";
$stock2session3date="";
$stock2session4date="";
$stock2session5date="";
$stock2session1=0;
$stock2session2=0;
$stock2session3=0;
$stock2session4=0;
$stock2session5=0;
$stock2name="";
$stock2low=20000;
$stock3session1date="";
$stock3session2date="";
$stock3session3date="";
$stock3session4date="";
$stock3session5date="";
$stock3session1=0;
$stock3session2=0;
$stock3session3=0;
$stock3session4=0;
$stock3session5=0;
$stock3name="" ;
$stock3low=20000;
$stock4session1date="";
$stock4session2date="";
$stock4session3date="";
$stock4session4date="";
$stock4session5date="";
$stock4session1=0;
$stock4session2=0;
$stock4session3=0;
$stock4session4=0;
$stock4session5=0;
$stock4name="";
$stock4low=20000;
echo '<table>';
echo '<tr><td>Stock</td><td>??|??</td><td>Shares</td><td>??|??</td><td>Price</td><td>??|??</td><td>Gain/Loss</td><td>??|??</td><td>Value</td></tr>';
//get a valid person who is active and has at least 4 stocks
// $ssqlport="select jm_portfolios.personid, count(jm_portfolios.personid), jm_people.peopleid, jm_people.active from jm_portfolios, jm_people where jm_people.peopleid=jm_portfolios.personid and jm_people.active='Y' and count(jm_portfolios.personid)>3";
$ssqlport="select personid, count(personid) as countOfpersonid from jm_portfolios group by jm_portfolios.personid having count(personid)>3";
$resultport=mysql_query($ssqlport,$connection);// or die("Problem getting person with four stocks: " . $ssqlport);
$rowport=mysql_fetch_array($resultport);
$ssql="Select symbol, sum(shares) from jm_portfolios where personid=1 group by symbol order by symbol";
$result=mysql_query($ssql,$connection);
$num_rows = mysql_num_rows($result);
while($row=mysql_fetch_array($result, MYSQL_NUM)) {
$stockloop=0; //stockloop is the past 5 sessions, session5 is the latest
$stockcount=$stockcount + 1; // stockcount is the number of stocks in the sample portfolio - 4 of them
switch ($stockcount) {
case "1";
$ssql2="select close, tradedate from jm_prices where symbol='" . $row[0] . "' order by tradedate desc";
$result2=mysql_query($ssql2,$connection);
while($row2=mysql_fetch_array($result2)) {
$stockloop=$stockloop + 1;
switch ($stockloop) {
case 1:
$stock1session5=$row2['close'];
$stock1session5date=$row2['tradedate'];
$stock1name=$row[0];
if ($row2['close']<$stock1low) { $stock1low=$row2['close']; }
break;
case 2:
$stock1session4=$row2['close'];
$stock1session4date=$row2['tradedate'];
if ($row2['close']<$stock1low) { $stock1low=$row2['close']; }
break;
case 3:
$stock1session3=$row2['close'];
$stock1session3date=$row2['tradedate'];
if ($row2['close']<$stock1low) { $stock1low=$row2['close']; }
break;
case 4:
$stock1session2=$row2['close'];
$stock1session2date=$row2['tradedate'];
if ($row2['close']<$stock1low) { $stock1low=$row2['close']; }
break;
case 5:
$stock1session1=$row2['close'];
$stock1session1date=$row2['tradedate'];
if ($row2['close']<$stock1low) { $stock1low=$row2['close']; }
break;
default:
//
}
}
$value=number_format($row[1] * $stock1session5,2);
// gain or loss?
echo '<tr><td>' . $row[0] . '</td><td>??|??</td><td>' . $row[1] . '</td><td>??|??</td><td>$' . $stock1session5 . '</td><td>??|??</td><td>$';
if ($stock1session5==$stock1session4) { echo 'no change'; } else { echo number_format($stock1session5-$stock1session4,2); }
echo '</td><td>??|??</td><td>$' . $value . '</td></tr>';
break;
case "2";
$ssql2="select close, tradedate from jm_prices where symbol='" . $row[0] . "' order by tradedate desc";
$result2=mysql_query($ssql2,$connection);
while($row2=mysql_fetch_array($result2)) {
$stockloop=$stockloop + 1;
switch ($stockloop) {
case 1:
$stock2session5=$row2['close'];
$stock2session5date=$row2['tradedate'];
$stock2name=$row[0];
if ($row2['close']<$stock2low) { $stock2low=$row2['close']; }
break;
case 2:
$stock2session4=$row2['close'];
$stock2session4date=$row2['tradedate'];
if ($row2['close']<$stock2low) { $stock2low=$row2['close']; }
break;
case 3:
$stock2session3=$row2['close'];
$stock2session3date=$row2['tradedate'];
if ($row2['close']<$stock2low) { $stock2low=$row2['close']; }
break;
case 4:
$stock2session2=$row2['close'];
$stock2session2date=$row2['tradedate'];
if ($row2['close']<$stock2low) { $stock2low=$row2['close']; }
break;
case 5:
$stock2session1=$row2['close'];
$stock2session1date=$row2['tradedate'];
if ($row2['close']<$stock2low) { $stock2low=$row2['close']; }
break;
default:
//
}
}
$value=number_format($row[1] * $stock2session5,2);
// gain or loss?
echo '<tr><td>' . $row[0] . '</td><td>??|??</td><td>' . $row[1] . '</td><td>??|??</td><td>$' . $stock2session5 . '</td><td>??|??</td><td>$';
if ($stock2session5==$stock2session4) { echo 'no change'; } else { echo number_format($stock2session5-$stock2session4,2); }
echo '</td><td>??|??</td><td>$' . $value . '</td></tr>';
break;
case "3";
$ssql2="select close, tradedate from jm_prices where symbol='" . $row[0] . "' order by tradedate desc";
$result2=mysql_query($ssql2,$connection);
while($row2=mysql_fetch_array($result2)) {
$stockloop=$stockloop + 1;
switch ($stockloop) {
case 1:
$stock3session5=$row2['close'];
$stock3session5date=$row2['tradedate'];
$stock3name=$row[0];
if ($row2['close']<$stock3low) { $stock3low=$row2['close']; }
break;
case 2:
$stock3session4=$row2['close'];
$stock3session4date=$row2['tradedate'];
if ($row2['close']<$stock3low) { $stock3low=$row2['close']; }
break;
case 3:
$stock3session3=$row2['close'];
$stock3session3date=$row2['tradedate'];
if ($row2['close']<$stock3low) { $stock3low=$row2['close']; }
break;
case 4:
$stock3session2=$row2['close'];
$stock3session2date=$row2['tradedate'];
if ($row2['close']<$stock3low) { $stock3low=$row2['close']; }
break;
case 5:
$stock3session1=$row2['close'];
$stock3session1date=$row2['tradedate'];
if ($row2['close']<$stock3low) { $stock3low=$row2['close']; }
break;
default:
//
}
}
$value=number_format($row[1] * $stock3session5,2);
// gain or loss?
echo '<tr><td>' . $row[0] . '</td><td>??|??</td><td>' . $row[1] . '</td><td>??|??</td><td>$' . $stock3session5 . '</td><td>??|??</td><td>$';
if ($stock3session5==$stock3session4) { echo 'no change'; } else { echo number_format($stock3session5-$stock3session4,2); }
echo '</td><td>??|??</td><td>$' . $value . '</td></tr>';
break;
case "4";
$ssql2="select close, tradedate from jm_prices where symbol='" . $row[0] . "' order by tradedate desc";
$result2=mysql_query($ssql2,$connection);
while($row2=mysql_fetch_array($result2)) {
$stockloop=$stockloop + 1;
switch ($stockloop) {
case 1:
$stock4session5=$row2['close'];
$stock4name=$row[0];
$stock4session5date=$row2['tradedate'];
if ($row2['close']<$stock4low) { $stock4low=$row2['close']; }
break;
case 2:
$stock4session4=$row2['close'];
$stock4session4date=$row2['tradedate'];
if ($row2['close']<$stock4low) { $stock4low=$row2['close']; }
break;
case 3:
$stock4session3=$row2['close'];
$stock4session3date=$row2['tradedate'];
if ($row2['close']<$stock4low) { $stock4low=$row2['close']; }
break;
case 4:
$stock4session2=$row2['close'];
$stock4session2date=$row2['tradedate'];
if ($row2['close']<$stock4low) { $stock4low=$row2['close']; }
break;
case 5:
$stock4session1=$row2['close'];
$stock4session1date=$row2['tradedate'];
if ($row2['close']<$stock4low) { $stock4low=$row2['close']; }
break;
default:
//
}
}
$value=number_format($row[1] * $stock4session5,2);
// gain or loss?
echo '<tr><td>' . $row[0] . '</td><td>??|??</td><td>' . $row[1] . '</td><td>??|??</td><td>$' . $stock4session5 . '</td><td>??|??</td><td>$';
if ($stock4session5==$stock4session4) { echo 'no change'; } else { echo number_format($stock4session5-$stock4session4,2); }
echo '</td><td>??|??</td><td>$' . $value . '</td></tr>';
break;
default:
//
}
}
echo '</table>';
echo '</div>';
echo '<div class="clear"> </div>';
echo '<div class="hrule">';
echo '<hr />';
echo '</div>';
echo '<div id="charts">';
echo '<img src="linechart.php?lowp=' . $stock1low . '&d1=' . $stock1session1date . '&d2=' . $stock1session2date . '&d3=' . $stock1session3date . '&d4=' . $stock1session4date . '&d5=' . $stock1session5date . '&p1=' . $stock1session1 . '&p2=' . $stock1session2 . '&p3=' . $stock1session3 . '&p4=' . $stock1session4 . '&p5=' . $stock1session5 . '&symbol=' . $stock1name . '" style="border-style:solid;border-width:thin;border-color: #000000">';
echo '??';
echo '<img src="linechart.php?lowp=' . $stock2low . '&d1=' . $stock2session1date . '&d2=' . $stock2session2date . '&d3=' . $stock2session3date . '&d4=' . $stock2session4date . '&d5=' . $stock2session5date . '&p1=' . $stock2session1 . '&p2=' . $stock2session2 . '&p3=' . $stock2session3 . '&p4=' . $stock2session4 . '&p5=' . $stock2session5 . '&symbol=' . $stock2name . '" style="border-style:solid;border-width:thin;border-color: #000000">';
echo '<br />';
echo '<img src="linechart.php?lowp=' . $stock3low . '&d1=' . $stock3session1date . '&d2=' . $stock3session2date . '&d3=' . $stock3session3date . '&d4=' . $stock3session4date . '&d5=' . $stock3session5date . '&p1=' . $stock3session1 . '&p2=' . $stock3session2 . '&p3=' . $stock3session3 . '&p4=' . $stock3session4 . '&p5=' . $stock3session5 . '&symbol=' . $stock3name . '" style="border-style:solid;border-width:thin;border-color: #000000">';
echo '??';
echo '<img src="linechart.php?lowp=' . $stock4low . '&d1=' . $stock4session1date . '&d2=' . $stock4session2date . '&d3=' . $stock4session3date . '&d4=' . $stock4session4date . '&d5=' . $stock4session5date . '&p1=' . $stock4session1 . '&p2=' . $stock4session2 . '&p3=' . $stock4session3 . '&p4=' . $stock4session4 . '&p5=' . $stock4session5 . '&symbol=' . $stock4name . '" style="border-style:solid;border-width:thin;border-color: #000000">';
?>
</DIV>
<DIV style="position:absolute;left:406px;top:332px;width:150px;height:150px;z-index:54" align="left">
echo '<div id="charts">';
echo '<img src="linechart.php?lowp=' . $stock1low . '&d1=' . $stock1session1date . '&d2=' . $stock1session2date . '&d3=' . $stock1session3date . '&d4=' . $stock1session4date . '&d5=' . $stock1session5date . '&p1=' . $stock1session1 . '&p2=' . $stock1session2 . '&p3=' . $stock1session3 . '&p4=' . $stock1session4 . '&p5=' . $stock1session5 . '&symbol=' . $stock1name . '" style="border-style:solid;border-width:thin;border-color: #000000">';
echo '??';
echo '<img src="linechart.php?lowp=' . $stock2low . '&d1=' . $stock2session1date . '&d2=' . $stock2session2date . '&d3=' . $stock2session3date . '&d4=' . $stock2session4date . '&d5=' . $stock2session5date . '&p1=' . $stock2session1 . '&p2=' . $stock2session2 . '&p3=' . $stock2session3 . '&p4=' . $stock2session4 . '&p5=' . $stock2session5 . '&symbol=' . $stock2name . '" style="border-style:solid;border-width:thin;border-color: #000000">';
echo '<br />';
echo '<img src="linechart.php?lowp=' . $stock3low . '&d1=' . $stock3session1date . '&d2=' . $stock3session2date . '&d3=' . $stock3session3date . '&d4=' . $stock3session4date . '&d5=' . $stock3session5date . '&p1=' . $stock3session1 . '&p2=' . $stock3session2 . '&p3=' . $stock3session3 . '&p4=' . $stock3session4 . '&p5=' . $stock3session5 . '&symbol=' . $stock3name . '" style="border-style:solid;border-width:thin;border-color: #000000">';
echo '??';
echo '<img src="linechart.php?lowp=' . $stock4low . '&d1=' . $stock4session1date . '&d2=' . $stock4session2date . '&d3=' . $stock4session3date . '&d4=' . $stock4session4date . '&d5=' . $stock4session5date . '&p1=' . $stock4session1 . '&p2=' . $stock4session2 . '&p3=' . $stock4session3 . '&p4=' . $stock4session4 . '&p5=' . $stock4session5 . '&symbol=' . $stock4name . '" style="border-style:solid;border-width:thin;border-color: #000000">';
?>