";
mysql_query("update users set picname = '$name' where id = '$id'");
} else {
echo "There was an error uploading the file, please try again!
";
}
$email= $_POST['email'];
$distance = $_POST['distance'];
$highway = $_POST['highway'];
$zip = $_POST['zip'];
$sql = mysql_query("update users set email = '$email', proximity = '$distance', zip = '$zip' , highway = '$highway' where id = '$id'");
}
$id = $_SESSION['id'];
$date = $_GET['date'];
$sql = mysql_query("select name from users where id = '$id'");
$row = mysql_fetch_row($sql);
$name = $row[0];
echo "Welcome $name
Choose from the links below what you would like to do today
";
//schedule control
//edit profile
//car control (seating)
//picture control
//possible messaging
//check current carpools
//remove capabilities
//current carpool proposals
?>
Add/Edit My Schedule
Add/Edit My Profile
Propose
";
$row = mysql_fetch_array($sql);
$email = $row[email];
$proximity = $row[proximity];
$zip = $row[zip];
$highway = $row[highway];
echo "Upload your pic:
";
echo "Email:
";
?>
Proximity
Closest Highway
Zip Code:
";
}
if ($schedule == 'yes')
{
if ($date != "")
{
mysql_query("update schedule set $date = 'no' where userid = '$id'");
}
if ($_POST['insertid'] != "")
{
$day = $_POST['day'];
$period = $_POST['period'];
$insertid = $_POST['insertid'];
$field = "$day$period";
mysql_query("update schedule set $field = 'yes' where userid = '$insertid'");
}
$sql = mysql_query("select * from schedule where userid = '$id'");
if (mysql_num_rows($sql) > 0)
{
$row = mysql_fetch_array($sql);
$quarter = $row[1];
echo "Here is your schedule for $quarter
";
for ($i=3;$i<19;$i++)
{
if ($row[$i]== 'yes')
{
//style current schedule here
$class = mysql_field_name($sql,$i);
$day = substr($class,0,3);
$time = substr($class,3,1);
if (ereg(mon,$class)) $word = "Monday";
if (ereg(tue,$class)) $word = "Tuesday";
if (ereg(wed,$class)) $word = "Wednesday";
if (ereg(thu,$class)) $word = "Thursday";
if (ereg(fri,$class)) $word = "Friday";
if (ereg(sat,$class)) $word = "Saturday";
if ($time == 1) $time = "8am - 12pm";
if ($time == 2) $time = "1pm - 5pm";
if ($time == 3) $time = "6pm - 10pm";
echo "$word $time Delete Class";
echo "
";
}
}
}
echo "Enter your schedule below
";
?>