Location: PHPKode > projects > PortalXP - Teacher Edition > PortalXP/PortalXP/addschool.php
<?php

$email = $HTTP_POST_VARS["email"];
require('admin/config.php');
require('admin/connect.php');
include('admin/outputlib.php');

// Query DB for districts
$sql = "select * from district";
$result = mysql_query($sql);	

// Query DB for schools
$sql2 = "select * from school";
$result2 = mysql_query($sql2);

// Query DB for e-mail addresses
$query = "select * from teacher where email = '$email' ";
$result3 = mysql_query($query);
if (mysql_num_rows($result3) > 0)
{
    echo "This e-mail address is already used.  Use the back button on your browser and use a different e-mail address.\n";
	exit;
}

?>

<HEAD>
<link REL="stylesheet" TYPE="text/css" HREF="portalxp.css">

<STYLE>
A:hover
{
    COLOR: #ff3333;
    TEXT-DECORATION: none
}
</STYLE>
</HEAD>

<div class='topname'>
PortalXP
</div>

<div class='topaddress'>
Linking teachers and students on the web
</div>

<div class='spacer'>
<img src="images/spacer.gif">
</div>

<div style="POSITION: absolute; TOP: 50px; LEFT: 0px; Z-INDEX: 25; WIDTH: 700px">
<table width='700px' BORDER="0" CELLSPACING="0" CELLPADDING="0">
<tr>
	<td colspan=4 bgcolor='#349601'>
	&nbsp;
	</td>
</tr>
<tr>
	<td width='150px' bgcolor='#85BA69' valign='top'>
	<div class='sidelink'>
	<hr>
	Why PortalXP?
	<hr>
	<a href="overview.php">Overview</a>
	<hr>
	Benefits
	<hr>
	Demo Teacher
	<hr>
	<a href="contactxp.php">Contact Us</a>
	<hr>
	<a href="signup.php">Sign-up</a>
	<hr>
	<a href="support.php">Tech Support</a>
	<hr>
	<a href="index.php">Home</a>
	<hr>
	</div>
	</td>
	<td colspan='3' width='350px' valign='top'>
	&nbsp;
	<br>
	<font color='red'>Enter information in all fields below.</font>
	<p>
	<form method="post" action="addschoolwrite.php">
	<table width=500px border=0>
	<tr>
	<td>School Name:
	<td><input type="text" id="text" name="schoolname">
	<tr>
	<td>School Address:
	<td><input type="text" id="text" name="schooladdress">
	<tr>
	<td>School Phone:
	<td><input type="text" id="text" name="schoolphone">
	<tr>
	<td>School E-mail:
	<td><input type="text" id="text" name="schoolemail">
	<tr>
	<td colspan=2>
	<font color="red">By submitting this information, you agree to the <a href="terms.php">terms and contiditions</a> of this website.</font>
	</table>
	<input type="Hidden" name="teacher_id" value="<?php echo $id ?>">
	<input type="Submit" name="submit" value="Enter Information">
	</form>
	</td>
</tr>
<tr>
	<td colspan=4 bgcolor='#349601'>
	&nbsp;
	</td>
</tr>
<tr>
	<td colspan=4>
	<center>
	©2002 Da Who Software - PortalXP Version <?php echo $versionnumber ?>
	</center>
	</td>
</tr>
</table>
</div>

Return current item: PortalXP - Teacher Edition