Code: Select all
<FORM method="e;post"e; action="e;log_entry.php"e;>
Date:<INPUT type=text name='date' maxlength=10 size=10>
Day:<INPUT type=text name='day_name' maxlength=9 size=10>
Time:<INPUT type=text name='time' maxlength=5 size=10>
Class ID:<INPUT type=text name='class_id' maxlenth=2 size=10><BR>
Attendence:<INPUT type=text name='attendance' maxlength=100 size=30><BR>
Comments:<BR><TEXTAREA name='comments' rows=10 cols=40></TEXTAREA>
<INPUT type=hidden name='os' value='ds'>
<INPUT type=submit value='log it'>
</FORM>Code: Select all
<?php
mysql_connect("localhost", "user", "*******") or die("Couldn't connect to server");
mysql_select_db("blueberries") or die("Couldn't connect to database "blueberries".");
$os = $_GET[os];
if(!(isset($os))){
$os = $_POST[os];
}
if($os==ds){
$query = "INSERT INTO log (date, day_name, time, class_id, attendance, comments) VALUES ".
"('$_POST[date]', '$_POST[day_name]', '$_POST[time]', '$_POST[class_id]', '$_POST[attendance]', '$_POST[comments]')";
$result = mysql_query($query);
if($result){
echo mysql_affected_rows()." rows affected.<BR>";
} else{
echo "Something went wrong.<BR>";
}
}
$query2 = "SELECT * FROM log ORDER BY date, time";
$result2 = mysql_query($query2);
$num = mysql_numrows($result2);
$i=0;
if($num<1){
echo "There are no entries in the database.";
} else{
while($i<$num){
$date = mysql_result($result2, $i, "date");
$day_name = mysql_result($result2, $i, "day_name");
$time = mysql_result($result2, $i, "time");
$class_id = mysql_result($result2, $i, "class_id");
$attendance = mysql_result($result2, $i, "attendance");
$comments = mysql_result($result2, $i, "comments");
echo "<P>$date, $day_name, $time</P>".
"<P>$class_id Attendance: "$attendance"</P>".
"<P>$comments</P>";
$i++;
}
}
mysql_close();
?>