كود PHP:
<?php require_once('Connections/students_form.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO teachers (teahcer_id, teacher_name, teacher_idnum, teacher_branch, teacher_classes, teacher_classmaster, teacher_topics, teacher_address, teacher_bdate, teacher_email, teacher_tel, teacher_mob, teacher_username, teacher_password, teacher_startdate, teacher_jobstatus, teacher_higheredu, teacher_higheredu_field, teacher_expyear, teacher_university, teacher_weeklylessons) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['teahcer_id'], "int"),
GetSQLValueString($_POST['teacher_name'], "text"),
GetSQLValueString($_POST['teacher_idnum'], "text"),
GetSQLValueString($_POST['teacher_branch'], "int"),
GetSQLValueString(implode($_POST['teacher_classes'],","), "text"),
GetSQLValueString(isset($_POST['teacher_classmaster']) ? "true" : "", "defined","1","0"),
GetSQLValueString($_POST['teacher_topics'], "text"),
GetSQLValueString($_POST['teacher_address'], "text"),
GetSQLValueString($_POST['teacher_bdate'], "text"),
GetSQLValueString($_POST['teacher_email'], "text"),
GetSQLValueString($_POST['teacher_tel'], "text"),
GetSQLValueString($_POST['teacher_mob'], "text"),
GetSQLValueString($_POST['teacher_username'], "text"),
GetSQLValueString($_POST['teacher_password'], "text"),
GetSQLValueString($_POST['teacher_startdate'], "text"),
GetSQLValueString($_POST['teacher_jobstatus'], "text"),
GetSQLValueString($_POST['teacher_higheredu'], "text"),
GetSQLValueString($_POST['teacher_higheredu_field'], "text"),
GetSQLValueString($_POST['teacher_expyear'], "text"),
GetSQLValueString($_POST['teacher_university'], "text"),
GetSQLValueString($_POST['teacher_weeklylessons'], "int"));
mysql_select_db($database_students_form, $students_form);
$Result1 = mysql_query($insertSQL, $students_form) or die(mysql_error());
$insertGoTo = "teacher_added.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
mysql_select_db($database_students_form, $students_form);
$query_Branch = "SELECT * FROM branch";
$Branch = mysql_query($query_Branch, $students_form) or die(mysql_error());
$row_Branch = mysql_fetch_assoc($Branch);
$totalRows_Branch = mysql_num_rows($Branch);
mysql_select_db($database_students_form, $students_form);
$query_Classes = "SELECT * FROM classes";
$Classes = mysql_query($query_Classes, $students_form) or die(mysql_error());
$row_Classes = mysql_fetch_assoc($Classes);
$totalRows_Classes = mysql_num_rows($Classes);
mysql_select_db($database_students_form, $students_form);
$query_jobstatus = "SELECT * FROM jobstatus";
$jobstatus = mysql_query($query_jobstatus, $students_form) or die(mysql_error());
$row_jobstatus = mysql_fetch_assoc($jobstatus);
$totalRows_jobstatus = mysql_num_rows($jobstatus);
mysql_select_db($database_students_form, $students_form);
$query_teachers = "SELECT * FROM teachers";
$teachers = mysql_query($query_teachers, $students_form) or die(mysql_error());
$row_teachers = mysql_fetch_assoc($teachers);
$totalRows_teachers = mysql_num_rows($teachers);
mysql_select_db($database_students_form, $students_form);
$query_topics = "SELECT * FROM topics";
$topics = mysql_query($query_topics, $students_form) or die(mysql_error());
$row_topics = mysql_fetch_assoc($topics);
$totalRows_topics = mysql_num_rows($topics);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="rtl">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>إضافة معلم جديد</title>
</head>
<body>
<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
<table align="center">
<tr valign="baseline">
<td nowrap="nowrap" align="right">إسم المعلم</td>
<td><input type="text" name="teacher_name" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">رقم بطاقة الهوية</td>
<td><input type="text" name="teacher_idnum" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">فرع المدرسة</td>
<td><input type="text" name="teacher_branch" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">الصفوف التي يعلمها</td>
<td><select name="teacher_classes[]" size="1" multiple="multiple">
<?php
do {
?>
<option value="<?php echo $row_Classes['class_id']?>" ><?php echo $row_Classes['class_name']?></option>
<?php
} while ($row_Classes = mysql_fetch_assoc($Classes));
?>
</select></td>
</tr>
<tr> </tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">مربي صف</td>
<td><input type="checkbox" name="teacher_classmaster" value="" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">المواد التي يتعلمها</td>
<td><select name="teacher_topics">
<?php
do {
?>
<option value="<?php echo $row_topics['topic_id']?>" ><?php echo $row_topics['topic_name']?></option>
<?php
} while ($row_topics = mysql_fetch_assoc($topics));
?>
</select></td>
</tr>
<tr> </tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right" valign="top">عنوان الإقامة</td>
<td><textarea name="teacher_address" cols="50" rows="5"></textarea></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">تاريخ الميلاد</td>
<td><input type="text" name="teacher_bdate" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">البريد الإلكتروني</td>
<td><input type="text" name="teacher_email" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">هاتف البيت</td>
<td><input type="text" name="teacher_tel" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">هاتف متنقل</td>
<td><input type="text" name="teacher_mob" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">إسم المستخدم</td>
<td><input type="text" name="teacher_username" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">كلمة المرور</td>
<td><input type="text" name="teacher_password" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">تاريخ بدء العمل</td>
<td><input type="text" name="teacher_startdate" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">وضع الوظيفة</td>
<td><input type="text" name="teacher_jobstatus" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">أعلى محصل علمي</td>
<td><input type="text" name="teacher_higheredu" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">تخصص</td>
<td><input type="text" name="teacher_higheredu_field" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">عدد سنوات الخبرة</td>
<td><input type="text" name="teacher_expyear" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">مكان التعليم</td>
<td><input type="text" name="teacher_university" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">عدد الحصص الأسبوعية</td>
<td><input type="text" name="teacher_weeklylessons" value="" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td><input type="submit" value="Insert record" /></td>
</tr>
</table>
<input type="hidden" name="teahcer_id" value="" />
<input type="hidden" name="MM_insert" value="form1" />
</form>
<p> </p>
</body>
</html>
<?php
mysql_free_result($Branch);
mysql_free_result($Classes);
mysql_free_result($jobstatus);
mysql_free_result($teachers);
mysql_free_result($topics);
?>