- Why the size of array is always 1? What's wrong?
- How to hide the form after submit while call itself? I tested, my code doesn't work, so i comment it.
Many thanks!!!
<? $dbhost = "localhost";
$dbuser = "admin";
$dbpass = "pass";
$dbname = "webDB";
$connect = mysql_connect($dbhost,$dbuser,$dbpass)or die ("Could not connect to database");
mysql_select_db($dbname,$connect)or die ("Could not select database");
static $i;
if (isset($_POST['addstock'])){
echo ("symbol: ".$_POST['symbol']);
$query = mysql_query("SELECT * FROM stocks WHERE symbol='".$_POST['symbol']."'",$connect);
if (!$rec = mysql_fetch_array($query)){
echo("Sorry, no such symbol found!");
}
else {
$mystocks[$i]=$_POST['symbol'];
$i++;
}
/*echo("<form>
<input type=\"hidden\" name=\"symbol\" value=\"$symbol\">
<input type=\"hidden\" name=\"addstock\">
<input type=\"hidden\" name=\"removestock\">
</form>"); */
}
echo("<BR>size of mystocks is: ".sizeof($mystocks));
if (sizeof($mystocks)!=0){
foreach ($mystocks as $mysymbol){
$query = mysql_query("SELECT * FROM stocks WHERE symbol='".$mysymbol."'",$connect);
while ($rec = mysql_fetch_array($query)){
echo("<BR>Symbol: ".$rec["symbol"]." Company: ".$rec["company"]." Ask: ".$rec["ask"]);
}
}
}
echo("<form action=\"".$_SERVER['$PHP_SELF']."\" method=\"post\">
Symbol:
<input type=\"text\" name=\"symbol\">
<input type=\"submit\" name=\"addstock\" value=\"Add Stock\">
<input type=\"submit\" name=\"removestock\" value=\"Remove Stock\">
</form>");
?>