
Έχω ένα πρόβλημα με τους παρακάτω κώδικες. Δεν γίνεται update στη βάση δεδομένων.
forma2.php
Κώδικας: Επιλογή όλων
<?php
include "config.php";
$query = "SELECT * FROM nametable";
$result = mysql_query($query, $db);
while($myrow=mysql_fetch_row($result)){
if($myrow[12]==$_POST[username]){
if($myrow[13]==$_POST[pass]){
$_SESSION['views']=1;
?>
<html>
<head>
<meta content="text/html; charset=utf-8" />
<title>Ωρολόγιο Πρόγραμμα</title>
</head>
<body bgcolor="black">
<form action="forma3.php" method="post" />
<p align="center"><font color="white"><h3 align="center">Καλωσήρθατε <? echo $myrow[1]; ?></h3></font></p>
<br><br><br><br>
<table border="1" align="center" width="40%" height="20%" bgcolor="white">
<caption><font color="white"><h3 align="center">Πότε είστε διαθέσιμος/η;</h3></font></caption>
<tr>
<td> </td>
<td>Δευτέρα</td>
<td>Τρίτη</td>
<td>Τετάρτη</td>
<td>Πέμπτη</td>
<td>Παρασκευή</td>
</tr>
<tr>
<td>Πρωί</td>
<td>
<? if($myrow[2]==1){ ?>
<input type="checkbox" name="monday_a" checked="yes"">
<? }else echo "<input type=\"checkbox\" name=\"monday_a\">"; ?>
</td>
<td>
<? if($myrow[4]==1){ ?>
<input type="checkbox" name="tuesday_a" checked="yes">
<? }else echo "<input type=\"checkbox\" name=\"tuesday_a\">"; ?>
</td>
<td>
<? if($myrow[6]==1){?>
<input type="checkbox" name="wednesday_a" checked="yes">
<? }else echo "<input type=\"checkbox\" name=\"wednesday_a\">";?>
</td>
<td>
<? if($myrow[8]==1){?>
<input type="checkbox" name="thursday_a" checked="yes">
<? }else echo "<input type=\"checkbox\" name=\"thursday_a\">";?>
</td>
<td>
<? if($myrow[10]==1){?>
<input type="checkbox" name="friday_a" checked="yes">
<? }else echo "<input type=\"checkbox\" name=\"friday_a\">";?>
</td>
</tr>
<tr>
<td>Απόγευμα</td>
<td>
<? if($myrow[3]==1){?>
<input type="checkbox" name="monday_p" checked="yes">
<? }else echo "<input type=\"checkbox\" name=\"monday_p\">";?>
</td>
<td>
<? if($myrow[5]==1){?>
<input type="checkbox" name="tuesday_p" checked="yes">
<? }else echo "<input type=\"checkbox\" name=\"tuesday_p\">";?>
</td>
<td>
<? if($myrow[7]==1){?>
<input type="checkbox" name="wednesday_p" checked="yes">
<? }else echo "<input type=\"checkbox\" name=\"wednesday_p\">";?>
</td>
<td>
<? if($myrow[9]==1){?>
<input type="checkbox" name="thursday_p" checked="yes">
<? }else echo "<input type=\"checkbox\" name=\"thursday_p\">";?>
</td>
<td>
<? if($myrow[11]==1){?>
<input type="checkbox" name="friday_p" checked="yes">
<? }else echo "<input type=\"checkbox\" name=\"friday_p\">";?>
</td>
</tr>
</table>
<br><br><br>
<p align="center"><input type="submit" value="Αποστολή"></p>
<?php print("</form>"); ?>
</body>
</html>
<?
}else echo "Λάθος Κωδικός Πρόσβασης";
}
}
?>
Κώδικας: Επιλογή όλων
<? include "config.php";?>
<html>
<head>
<meta content="text/html; charset=utf-8" />
<title>Ωρολόγιο Πρόγραμμα</title>
</head>
<body bgcolor="black" text="white">
<?php
if($_POST[monday_a]==on){
$_POST[monday_a]=1;
}else $_POST[monday_a]=0;
if($_POST[monday_p]==on){
$_POST[monday_p]=1;
}else $_POST[monday_p]=0;
if($_POST[tuesday_a]==on){
$_POST[tuesday_a]=1;
}else $_POST[tuesday_a]=0;
if($_POST[tuesday_p]==on){
$_POST[tuesday_p]=1;
}else $_POST[tuesday_p]=0;
if($_POST[wednesday_a]==on){
$_POST[wednesday_a]=1;
}else $_POST[wednesday_a]=0;
if($_POST[wednesday_p]==on){
$_POST[wednesday_p]=1;
}else $_POST[wednesday_p]=0;
if($_POST[thursday_a]==on){
$_POST[thursday_a]=1;
}else $_POST[thursday_a]=0;
if($_POST[thursday_p]==on){
$_POST[thursday_p]=1;
}else $_POST[thursday_p]=0;
if($_POST[friday_a]==on){
$_POST[friday_a]=1;
}else $_POST[friday_a]=0;
if($_POST[friday_p]==on){
$_POST[friday_p]=1;
}else $_POST[friday_p]=0;
$sql="UPDATE nametable SET monday_a='$_POST[monday_a]', monday_p='$_POST[monday_p]', tuesday_a='$_POST
[tuesday_a]', tuesday_p='$_POST[tuesday_p]', wednesday_a='$_POST[wednesday_a]', wednesday_p='$_POST
[wednesday_p]', thursday_a='$_POST[thursday_a]', thursday_p='$_POST[thursday_p]', friday_a='$_POST[friday_a]',
friday_p='$_POST[friday_p]' WHERE lastname='$_POST[lastname]' ";
$result=mysql_query($sql) or die(mysql_error());
//echo $result;
//echo $_POST[tuesday_a];
echo "<br><p align=\"center\"><h3 align=\"center\">Ευχαριστούμε για την καταχώρηση σας </h3></p>";
?>
</body>
</html>