Gør dit valg via et link (firmanavn)
Jeg har lavet dette script. Jeg vil gerne have ændret det således at jeg i stedet for at skrive et navn i input feltet kan klikke på "firma"navnet og dermed vælge det. Det skal herefter gemmes i min database.Script:
<?
// START PHP CODES. THIS PART MUST ON THE TOP OF THIS PAGE.
// Connect database.
include ("login_reg.php");
$username = $_COOKIE['ID_my_site'];
// ***** This part will process when you Click on "Submit" button *****
// Check, if you clicked "Submit" button
if($_POST['Submit']){
// Get parameters from form.
$id=$_POST['ID'];
$ejer_firma=$_POST['ejer_firma'];
$antal=$_POST['antal'];
$username=$_POST['username'];
$kob=$_POST['antal']*($_POST['kurs']/100);
$saldo_gl=$_POST['saldo'];
$saldo=$saldo_gl-$kob;
// Do update statement.
mysql_query("update users set ejer_firma='$ejer_firma', antal='$antal', saldo='$saldo' where username='$username'");
// Re-direct this page to select.php.
header("location:index.php");
exit;
}
// ************* End update part *************
?>
<?php
include ("login_reg.php");
// Make a MySQL Connection
// Construct our join query
$query = "SELECT users.ejer_firma, users.saldo, firmaer.kurs, firmaer.firmanavn ".
"FROM users, firmaer ".
"WHERE users.ejer_firma = firmaer.firmanavn AND username = '$username'";
$result = mysql_query($query) or die(mysql_error());
// Print out the contents of each row into a table
while($row = mysql_fetch_array($result)){
?>
<table border="0">
<tr>
<td><? echo $username; ?></td>
<td><? echo $row['saldo'];
$saldo_gl=$row['saldo'];
$kurs=$row['kurs'];
?></td>
<td><? echo $row['firmanavn']; ?></td>
<td><? echo $row['kurs']; ?></td>
</tr>
</table>
<?php } ?>
<? echo $saldo_gl; ?>
<? echo $kurs; ?>
<!-- <? echo $saldo=$saldo_gl+10; ?>
<? echo $saldo; ?> -->
<!-- END OF PHP CODES AND START HTML TAGS -->
<html>
<body>
<!-- set this form to POST method and target this form to itself ($PHP_SELF;)-->
<form id="form1" name="form1" method="post" action="<? echo $PHP_SELF; ?>">
<p>Firma navn:
<!-- name of this text field is "name" -->
<input name="ejer_firma" type="text" id="ejer_firma" value="<? echo $row['ejerfirma']; ?>"/>
<br />
Antal :
<!-- name of this text field is "email" -->
<input name="antal" type="text" id="antal" value="<? echo $row['antal']; ?>"/>
<br />
<!-- name of this text field is "email" -->
<input name="username" type="hidden" id="username" value="<? echo $username; ?>"/>
<input name="saldo" type="hidden" id="saldo" value="<? echo $saldo; ?>"/>
<input name="kurs" type="hidden" id="kurs" value="<? echo $kurs; ?>"/>
<p>
<input type="submit" name="Submit" value="Submit" />
</p>
</form>
</body>
</html>
