You must save the page how test.php
PHP Code:
<?php
$server = '127.0.0.1, 1433'; //IP, Port
$username="username"; // Mssql username
$password="password"; // Mssql password
$db_name="TGLOBAL_GSP"; //database
$connection = mssql_connect($server, $username, $password);
mssql_select_db($db_name,$connection);
?>
<div><form method="post" action="test.php">
<div align="center">
<?php echo "Name Account" ?>
<input type="text" style="color:black" name="name"/>
<br>
<?php echo "Amount Moonstone" ?>
<input type="text" style="color:black" name="amount"/>
<br>
<br>
</div>
<br><br>
<center>
<b><span style=\"color: red; font-size: 20pt\"><input style="color:black" type="submit" name="submit" value="start" width=”78″ height=”38″ /></span></b>
</center>
</form></div>
<?php
if(isset($_POST['submit'])){
$user = $_POST['name'];
$stone = $_POST['amount'];
?>
<?php
$var1 = mssql_query("SELECT dwUserID FROM TACCOUNT WHERE szUserID = '$user'");
while ($row10 = mssql_fetch_array($var1)){
$var3 = $row10['dwUserID'];
}
if(mssql_num_rows($var1) == 1){
$var2 = mssql_query("UPDATE TCASHTESTTABLE SET dwCash = $stone WHERE dwUserID = '$var3'");
echo "I put the stones correctly";
}else{
echo "Account don't found";
}
}
?>
