Program Sign Up

Please fill in the Name field.

“;

}

if (empty($phone_number))
{
echo “

Please fill in the Phone Number Field.

“;

}

else
{

$category2 = urldecode($category);
$person2 = urldecode($person);
$parents_name2 = urldecode($parents_name);
$title_signup2 = urldecode($title_signup);

$con = mysql_connect($hostname,$username,$password);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}

$like = mysql_select_db(“meetings”, $con);

$sql=”INSERT INTO signup (sid,category,title_signup,person,age_grade,parents_name,phone_number,phone_txt,email_notification,email,time_stamp,ip)
VALUES

(‘$sid’,’$category2′,’$title_signup2′,’$person2′,’$age_grade’,’$parents_name2′,’$phone_number’,’$phone_txt’,’$email_notification’,’$email’,’time_stamp’,’ip’)”;

if (!mysql_query($sql,$con))
{
die(‘Error: ‘ . mysql_error());
}

$tester2 = urldecode($title_signup);

echo “

$person is now signed up for $tester2

“;
print “

Sign up More for same program.

“;

mysql_close($con);

}
}

//print “id5 $id5
“;

$dbhandle = mysql_connect($hostname, $username, $password)
or die(“Unable to connect to MySQL”);
//echo “Connected to MySQL
“;

//select a database to work with
$selected = mysql_select_db(“meetings”,$dbhandle)
or die(“Could not select bookmarks”);

//execute the SQL query and return records

$result = mysql_query(“SELECT title,status,month,day_meetings,year_meetings,status,max_attendance from meetings where id = ‘$id5’;”);

//fetch tha data from the database
while ($row = mysql_fetch_array($result)) {

$max2 = “”.$row{‘max_attendance’}.””;
$category = “”.$row{‘status’}.””;
$title = “”.$row{‘title’}.””;
$day_meetings = “”.$row{‘day_meetings’}.””;
$year_meetings = “”.$row{‘year_meetings’}.””;
$status = “”.$row{‘status’}.””;

//print “mx1 $max2
“;

}

//print “mx2 $max2
“;

//$dbhandle = mysql_connect($hostname, $username, $password)
// or die(“Unable to connect to MySQL”);
//echo “Connected to MySQL
“;

//select a database to work with
$selected = mysql_select_db(“meetings”,$dbhandle)
or die(“Could not select bookmarks”);
//execute the SQL query and return records

$result = mysql_query(“SELECT sid from signup where sid = ‘$id5’;”);

$count = “0”;

while ($row = mysql_fetch_array($result)) {

$count++;

$max_signup = “”.$row{‘sid’}.””;

}

//print “count $count max_signup $max_signup mx2 ($max2)
“;

//print “

Currently $count signed up, with a maximum of $max2

“;

if ($count >= “$max2”)
{
print “

This program is currently full.
A waiting list is available by signing up below

“;
$title = “WL ” . “$title”;
}
else
{
}

print “

“;
print “
“;//SID: “;
print ““;
print ““;
print “Category:
“;
print “$category“;
print “
“;
print “Title:
$title“;
print “
“;
print “Name:
“;
print “
“;

if ($status == “Main Library Programming” or $status == “Training” or $status == “Computer Classes”)
{
}
else
{
print “Age:

“;
print “
“;
print “Parents Name:
“;
print “
“;
}
print “Phone Number:
“;
print “
“;

if ($status == “Main Library Programming” or $status == “Computer Classes”)
{
print “Barcode:

“;
print “
“;
print “Notes:
“;
print “
“;
}
else
{
print “Receive e-mail notifications of EPL Children’s Programming when updated?
“;
print “
“;
print “Email:
“;
print “
“;
}
print “
“;
print ““;
print ““;
print “

“;
print “

“;

print “

We often take pictures or shoot videos at library events to use in library publicity materials and on our website. If you do not wish us to use a picture or video of you or your child, please tell a library staff member prior to the event.

“;

mysql_close($dbhandle);

?>

ELKHART PUBLIC LIBRARY
300 SOUTH SECOND STREET
ELKHART, IN 46516
(574) 522-5669
ADDITIONAL RESOURCES
ADMINISTRATION
EPL/GPL CONSORTIUM
FRIENDS OF EPL
GIFT PROGRAM
LIBRARY CARDS
LIBRARY FEES & POLICIES
LIBRARY FUNDING
STRATEGIC PLAN