Follow along with the video below to see how to install our site as a web app on your home screen.
Бележка: This feature may not be available in some browsers.
}else if($_GET['action']=="edit" && isset($_GET['match'])) {
$matchid = $_GET['match'];
if(!isset($_POST['submit'])) {
$query = 'SELECT * FROM matchove WHERE id='.$matchid;
$result=mysql_query($query) or die("Error: ".mysql_error());
$row=mysql_fetch_array($result);
echo '
<form method="post">
<center><table>
<tr>
<td>Дата</td>
<td>Отбор 1</td>
<td>Отбор 2</td>
<td>Резултат</td>
</tr>
<tr>
<td>
<input type="date" name="data" value="'.$row['data'].'">
</td>
<td>
<select name="team1">';
echo '<option value='.$row['id'].'>'.getName($row['otbor1']).'</option>';
$query2='SELECT * FROM otbori WHERE ime NOT "'.$row['otbor1'].'" ORDER BY ime ASC';
$result2=mysql_query($query);
while($row2=mysql_fetch_array($result2)) {
echo '<option value="'.$row2['id'].'">'.$row2['ime'].'</option>';
}
echo '</select>
</td>
<td><select name="team2">';
echo '<option value='.$row['id'].'>'.getName($row['otbor2']).'</option>';
$query3='SELECT * FROM otbori WHERE ime NOT "'.$row['otbor2'].'" ORDER BY ime ASC';
$result3=mysql_query($query);
while($row3=mysql_fetch_array($result3)) {
echo '<option value="'.$row3['id'].'">'.$row3['ime'].'</option>';
}
echo '</select></td><td colspan="2"><input type="text" name="rezultat1" size="2" value="'.$row['rezultat1'].'">:<input type="text" name="rezultat2" size="2" value="'.$row['rezultat2'].'"></td>
</tr></table>
<input type="submit" name="submit" value="Добави">
</center></form>
';
}else{
$data=$_POST['data'];
$team1 = $_POST['team1'];
$team2 = $_POST['team2'];
$rezultat1 = $_POST['rezultat1'];
$rezultat2 = $_POST['rezultat2'];
$query='UPDATE matchove SET `data`="'.$data.'", `otbor1`="'.$team1.'", `otbor2`="'.$team2.'", `rezultat1`="'.$rezultat1.'", `rezultat2`="'.$rezultat2.'" WHERE `id`='.$matchid;
$result = mysql_query($query) or die("Error: ".mysql_error());
echo 'Мачът беше редактиран успешно!';
}
}