hey can anyone here help me with the below code and maybe tell me why its not updating into the database !
PHP Code:<html>
<head>
<style>
TD { text-align: center; }
INPUT { width: 50; border: 1px solid #000000; }
</style>
<title> Update </title>
</head>
<?php
$dbhost = "x";
$dbuname = "x";
$dbpass = "x";
$dbname = "prem";
$dbtable = "englishpremier";
function doform() {
?>
<table width="100%" border="1">
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<td colspan="11">Update</td>
<tr>
<td width="5%">Id</td>
<td width="20%">Name</td>
<td width="5%">Played</td>
<td width="5%">Won</td>
<td width="5%">Drawn</td>
<td width="5%">Lost</td>
<td width="5%">Scored</td>
<td width="5%">Conceded</td>
<td width="5%">Goal Diff</td>
<td width="5%">Points</td>
</tr>
<tr>
<td>1</td>
<td>Arsenal</td>
<td><Input name="id" type="text" value="<?=$played;?>"></td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>2</td>
<td>Aston Villa</td>
<td><Input name="id" type="text" value="<?=$played;?>"></td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>3</td>
<td>Birmingham City</td>
<td><Input name="id" type="text" value="<?=$played;?>"></td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>4</td>
<td>Blackburn Rovers</td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>5</td>
<td>Bolton Wanderers</td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>6</td>
<td>Charlton Athletic</td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>7</td>
<td>Chelsea</td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>8</td>
<td>Everton</td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>9</td>
<td>Fulham</td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>10</td>
<td>Leeds United</td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>11</td>
<td>Liverpool</td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>12</td>
<td>Manchester City</td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>13</td>
<td>Manchester United</td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>14</td>
<td>Middlesbrough</td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>15</td>
<td>Newcastle United</td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>16</td>
<td>Southampton</td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>17</td>
<td>Sunderland</td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>18</td>
<td>Tottenham Hotspur</td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>19</td>
<td>West Bromwich Albion</td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td>20</td>
<td>West Ham United</td>
<td><Input name="won" type="text" value="<?=$won;?>"></td>
<td><Input name="drawn" type="text" value="<?=$drawn;?>"></td>
<td><Input name="lost" type="text" value="<?=$lost;?>"></td>
<td><Input name="scored" type="text" value="<?=$scored;?>"></td>
<td><Input name="conceded" type="text" value="<?=$conceded;?>"></td>
<td><Input name="difference" type="text" value="<?=$difference;?>"></td>
<td><Input name="points" type="text" value="<?=$points;?>"></td>
</tr>
<tr>
<td colspan="10"><input type="submit" value="submit" name="Update"></td>
</tr>
<?php
}
function dbconnect(){
global $dbhost, $dbuname, $dbpass, $dbname;
$conn = @mysql_connect($dbhost, $dbuname, $dbpass);
if (!$conn) {
die ("Unable to connect to the database at this time. Please try again");
}
if (! @mysql_select_db("$dbname") ) {
die( "Unable to locate the site database at this time.Please try again");
}
}
if (!isset($submit)) {
//calling the function doform();
doform();
}
else {
dbconnect();
mysql_query("UPDATE $dbtable (id, name, played, won, drawn, lost, scored, conceded, difference, points) values ('$id', '$name','$played', '$won', '$drawn', '$lost', '$scored', '$conceded', '$difference', '$points')");
}
?>
Bookmarks