PHP -> ASP
Er der nogle der gider lave nedenstående PHP script om til ASP?<? require("connect.mysql"); ?>
<?
if($slet){
mysql_query("delete from regnskab where id='$slet'");
}
if($typen){
mysql_query("insert into regnskab (tekst, stk, stkpris, kunde, freelance, comment, typen) values ('$tekst', '$stk', '$stkpris', '$kunde', '$freelance', '$kommentar', '$typen')");
}
$indresult = mysql_query("select id, tekst, stkpris, stk, kunde, comment, freelance from regnskab where typen='ind'");
$udresult = mysql_query("select id, tekst, stkpris, stk, kunde, comment, freelance from regnskab where typen='ud'");
$indnumber = mysql_num_rows($indresult);
$udnumber = mysql_num_rows($udresult);
$indtotal = 0;
$udtotal = 0;
?>
<table border=1>
<tr><td>Indtægt:</td><td>Udgifter:</td></tr>
<tr><td><table border=0>
<tr><td>Stk.</td><td>Tekst</td><td>Kunde</td><td>Stk pris.</td><td>Freelancer med:</td><td>Bemærkninger:</td><td>Slet</td></tr>
<?
if($indnumber>0){
while($ind = mysql_fetch_array($indresult)){
echo "<tr><td>$ind[stk]</td><td>$ind[tekst]</td><td>$ind[kunde]</td><td>$ind[stkpris]</td><td>$ind[freelance]</td><td>$ind[comment]</td><td><a href=\"index.php?slet=$ind[id]\"><font color=\"red\">X</font></a></td></tr>";
$indtotal = $indtotal+($ind[stk]*$ind[stkpris]);
}
}
echo "</table></td>";
echo "<td><table border=0>"
?>
<tr><td>Stk.</td><td>Tekst</td><td>Kunde</td><td>Stk pris.</td><td>Freelancer med:</td><td>Bemærkninger:</td><td>Slet</td></tr>
<?
if($udnumber>0){
while($ud = mysql_fetch_array($udresult)){
echo "<tr><td>$ud[stk]</td><td>$ud[tekst]</td><td>$ud[kunde]</td><td>$ud[stkpris]</td><td>$ud[freelance]</td><td>$ud[comment]</td><td><a href=\"index.php?slet=$ud[id]\"><font color=\"red\">X</font></a></td></tr>";
$udtotal = $udtotal+($ud[stk]*$ud[stkpris]);
}
}
echo "</table></td>";
echo "</tr></table><br><br>";
$balance = $indtotal-$udtotal;
if($balance>0){
$fontt = "blue";
}else{
$fontt = "red";
}
echo "Balance: <font color=\"$fontt\">$balance</font><hr><br>";
?>
<h2>Opret ny post</h2><br><br>
<form action="index.php" method="post"><table border=0>
<tr><td>Tekst:</td><td><input type="text" name="tekst"></td></tr>
<tr><td>Stk:</td><td><input type="text" name="stk"></td></tr>
<tr><td>Stk pris:</td><td><input type="text" name="stkpris"></td></tr>
<tr><td>Kunde:</td><td><input type="text" name="kunde"></td></tr>
<tr><td>Freelancer:</td><td><input type="text" name="freelance"></td></tr>
<tr><td>Kommentar:</td><td><input type="text" name="kommentar"></td></tr>
<tr><td>Type:</td><td><select name="typen"><option value="ind" selected>Indtægt</option><option value="ud">Udgift</option></select></td></tr>
<tr><td><input type="submit" value="Opret"></td><td><input type="reset" value="Rens"></td></tr></table></form>
