Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- if($_POST['submit'])
- {
- $studNo = $_POST["stud_no"];
- $fname = $_POST["fname"];
- $mname = $_POST["mname"];
- $lname = $_POST["lname"];
- $mon = $_POST["mon"];
- $day = $_POST["day"];
- $yrs = $_POST["yr"];
- $bday = $mon."-".$day."-".$yrs;
- $age = $_POST["ages"];
- $year = $_POST["year"];
- $active = $_POST["active"];
- $course = $_POST["course"];
- $scho = $_POST["scho"];
- $username = $_POST["username"];
- $password = md5($_POST["password"]);
- $utype = $_POST["u_type"];
- $addStud = mysql_query("INSERT INTO student_info (student_id, student_firstname, student_middlename, student_lastname, student_bday, student_age, student_year, student_active, course_code, student_scholar) VALUES ('$studNo', '$fname', '$mname', '$lname', '$bday', '$age', '$_POST[studentyear]', '$active', '$course', '$scho')");
- $addUser = mysql_query("INSERT INTO users (user_username, user_password, student_id, user_type, user_login, user_logs) VALUES ('$username', '$password', $studNo, '$utype', '00-00-0000 00:00:00', '0')");
- if(($addStud) && ($addUser))
- {
- $_SESSION['success_msg'] = "User Record was successfully added in the database!";
- echo "<META http-equiv='refresh' content='0;URL=index.php?mod=user&add=success'>";
- echo "<div id='success_message'>Please wait while updating database...</div>";
- $cUser = $_SESSION["username"];
- $msg = $cUser." has added a record in Users Collection";
- $stat = mysql_query("INSERT INTO table_updates(update_event) VALUES ('$msg')");
- }
- else
- {
- $_SESSION['error_msg'] = "User Record was not successfully added in the database!".mysql_error();
- echo "<META http-equiv='refresh' content='0;URL=index.php?mod=user&add=failed'>";
- echo "<div id='success_message'>Please wait while updating database...</div>";
- }
- }
- ?>
- <script src="contents/control_panel/SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
- <link href="contents/control_panel/SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
- <script src="contents/control_panel/SpryAssets/SpryValidationSelect.js" type="text/javascript"></script>
- <script src="contents/control_panel/SpryAssets/SpryValidationPassword.js" type="text/javascript"></script>
- <script src="contents/control_panel/SpryAssets/SpryValidationConfirm.js" type="text/javascript"></script>
- <link href="contents/control_panel/SpryAssets/SpryValidationSelect.css" rel="stylesheet" type="text/css" />
- <link href="contents/control_panel/SpryAssets/SpryValidationPassword.css" rel="stylesheet" type="text/css" />
- <link href="contents/control_panel/SpryAssets/SpryValidationConfirm.css" rel="stylesheet" type="text/css" />
- <p id="headings">USER MANAGER</p>
- <form id="form1s" name="form1" method="post" action="">
- <table width="60%" border="0" align="center" cellspacing="3">
- <tr>
- <td width="20%" align="right"><strong>User Number:</strong></td>
- <td width="80%"><span id="sprytextfield1">
- <input name="stud_no" type="text" id="stud_no" maxlength="9" />
- <span class="textfieldRequiredMsg"> A value is required. </span></span></td>
- </tr>
- <tr>
- <td align="right"><strong>First Name:</strong></td>
- <td><span id="sprytextfield2">
- <input type="text" name="fname" id="fname" style="width: 60%" />
- <span class="textfieldRequiredMsg"> A value is required/ No spaces. </span></span></td>
- </tr>
- <tr>
- <td align="right"><strong>Middle Name:</strong></td>
- <td><span id="sprytextfield3">
- <input name="mname" type="text" id="mname" style="width: 60%" />
- <span class="textfieldRequiredMsg"> A value is required. </span></span></td>
- </tr>
- <tr>
- <td align="right"><strong>Last Name:</strong></td>
- <td><span id="sprytextfield5">
- <input type="text" name="lname" id="lname" style="width: 60%" />
- <span class="textfieldRequiredMsg"> A value is required. </span></span></td>
- </tr>
- <tr>
- <td align="right"><strong>Birthday:</strong></td>
- <td><span id="spryselect1">
- </span>
- <span id="spryselect3">
- <select name="mon" id="mon">
- <option value="">Month</option>
- <?
- for($ctr=1; $ctr<=12; $ctr++)
- {
- if($ctr<=9) { $ctr = "0".$ctr; }
- echo "<option value='$ctr'>$ctr</option>";
- }
- ?>
- </select>
- <span class="selectRequiredMsg"> Please select an item. </span></span> -
- <span id="spryselect4">
- <select name="day" id="day">
- <option value="" >Day</option>
- <?
- for($ctr=1; $ctr<=31; $ctr++)
- {
- if($ctr<=9) { $ctr = "0".$ctr; }
- echo "<option value='$ctr'>$ctr</option>";
- }
- ?>
- </select>
- <span class="selectRequiredMsg"> Please select an item. </span></span> -
- <span id="spryselect5">
- <select name="yr" id="year" onchange="yeahba();">
- <option value="">Year</option>
- <?
- for($ctr=1980; $ctr<=2006; $ctr++) { echo "<option value='$ctr'>$ctr</option>"; }
- ?>
- </select>
- <span class="selectRequiredMsg"> Please select an item. </span></span> FORMAT: MM-DD-YYYY</td>
- </tr>
- <tr>
- <td align="right"><strong>Age:</strong></td>
- <td><span id="sprytextfield4">
- <input name="ages" type="text" id="age" readonly />
- <span class="textfieldRequiredMsg"> A value is required. </span></span></td>
- </tr>
- <script type="text/javascript">
- function yeahba() {
- var x = document.form1.yr.selectedIndex;
- var y =document.form1.yr.options[x].value;
- //var x =2010;
- //var y= form1.yr.selectedindex.value;
- //alert (y);
- //alert("tae");
- document.getElementById("age").value = 2010 - y;
- //alert(form1.yr.selectedindex.value);
- }
- </script>
- <!-- <tr>
- <td align="right"><strong>Year:</strong></td>
- <td><span id="spryselect2">
- <select name="year" id="year" style="width:150px">
- <option value="" >Please select an item</option>
- <option value="1">First Year</option>
- <option value="2">Second Year</option>
- <option value="3">Third Year</option>
- <option value="4">Fourth Year</option>
- <option value="5">TERMINAL</option>
- </select>
- <span class="selectRequiredMsg"> Please select an item. </span></span></td>
- </tr>
- -->
- <tr>
- <td align="right"><strong>Status:</strong></td>
- <td><span id="spryselect6">
- <select name="active" id="active" style="width:150px">
- <option value="" >Status</option>
- <option value="1">Active</option>
- <option value="0">Inactive</option>
- </select>
- <span class="selectRequiredMsg"> Please select an item. </span></span></td>
- </tr>
- <tr>
- <td align="right"><strong>Course:</strong></td>
- <td><span id="spryselect7">
- <select name="course" id="course" style="width: 60%">
- <option value="">Select Course</option>
- <?
- $openCourses = mysql_query("SELECT * from course_collection");
- while($row = mysql_fetch_array($openCourses))
- {
- $itemCode = $row["course_code"];
- $itemDesc = $row["course_desc"];
- $itemActive = $row["course_active"];
- if($itemActive == 1)
- echo "<option value='$itemCode'>$itemDesc</option>";
- }
- $openUsers = mysql_query("SELECT * from users WHERE student_id = '$get_user'");
- $row = mysql_fetch_array($openUsers);
- $username = $row["user_username"];
- $password = $row["user_password"];
- $utype = $row["user_type"];
- $u = $utype;
- if($u == 1) { $u = "Administrator"; }
- else if($u == 2) { $u = "Faculty"; }
- else if($u == 3) { $u = "Student"; }
- $ulogs = $row["user_logs"];
- if($ulogs == 1) { $ulogs = "ONLINE"; }
- else { $ulogs = "OFFLINE"; }
- $last = $row["user_login"];
- ?>
- </select>
- <span class="selectRequiredMsg"> Please select an item. </span></span></td>
- </tr>
- <tr>
- <td align="right"><strong>Scholarship:</strong></td>
- <td><select name="scho" id="scho">
- <option value="0" selected="selected">None</option>
- <option value="50">50% Scholarship Grant</option>
- <option value="75">75% Scholarship Grant</option>
- <option value="100">100% Scholarship Grant</option>
- </select></td>
- </tr>
- <tr>
- <td align="right"><strong>Student year:</strong></td>
- <td><select name="studentyear" id="schos">
- <option value="first">First</option>
- <option value="second">Second</option>
- <option value="third">Third</option>
- <option value="fourth">Fourth</option>
- <option value="fifth">Fifth</option>
- </select></td>
- </tr>
- <tr>
- <td align="right"> </td>
- <td> </td>
- </tr>
- <tr>
- <td align="right"><strong>Username:</strong></td>
- <td><span id="sprytextfield6">
- <input name="username" type="text" id="username" style="width: 60%" />
- <span class="textfieldRequiredMsg"> A value is required. </span></span></td>
- </tr>
- <tr>
- <td align="right"><strong>New Password:</strong></td>
- <td><span id="sprypassword1">
- <input name="password" type="password" id="password1" style="width: 60%" value="" />
- <span class="passwordRequiredMsg"> A value is required. </span></span></td>
- </tr>
- <tr>
- <td align="right"><strong>Confirm Password:</strong></td>
- <td><span id="spryconfirm1">
- <input name="password2" type="password" id="password2" style="width: 60%" value="" />
- <span class="confirmRequiredMsg">A value is required.</span><span class="confirmInvalidMsg"> The values don't match. </span></span></td>
- </tr>
- <tr>
- <td align="right"><strong>User Type:</strong></td>
- <td><span id="spryselect8">
- <select name="u_type" id="u_type" style="width: 60%">
- <option value="">Select User Type</option>
- ";
- <option value="1">Administrator</option>
- <option value="2">Faculty</option>
- <option value="3">Student</option>
- </select>
- <span class="selectRequiredMsg"> Please select an item. </span></span></td>
- </tr>
- <tr>
- <td align="right"> </td>
- <td> </td>
- </tr>
- <tr>
- <td align="right"> </td>
- <td align="left"><input type="submit" name="submit" id="submit" value="SUBMIT" onclick="return val();" />
- <a href="index.php?mod=user"><input type="button" name="button2" id="button2" value="CANCEL" /></a></td>
- </tr>
- </table>
- </form>
- <p> </p>
- <script type="text/javascript">
- function validateNoSpaces(value) {
- return /^[a-zA-Z]+$/.test(value)
- }
- <!--
- var sprytextfield2 = new Spry.Widget.ValidationTextField("sprytextfield2", "custom", { validation:validateNoSpaces, validateOn:["blur", "change"]});
- var sprytextfield3 = new Spry.Widget.ValidationTextField("sprytextfield3", "custom", { validation:validateNoSpaces, validateOn:["blur", "change"]});
- var sprytextfield5 = new Spry.Widget.ValidationTextField("sprytextfield5", "custom", { validation:validateNoSpaces, validateOn:["blur", "change"]});
- var sprytextfield1 = new Spry.Widget.ValidationTextField("sprytextfield1");
- //var sprytextfield2 = new Spry.Widget.ValidationTextField("sprytextfield2");
- //var sprytextfield3 = new Spry.Widget.ValidationTextField("sprytextfield3");
- var spryselect1 = new Spry.Widget.ValidationSelect("spryselect1");
- var sprytextfield4 = new Spry.Widget.ValidationTextField("sprytextfield4");
- var sprytextfield6 = new Spry.Widget.ValidationTextField("sprytextfield6");
- var sprypassword1 = new Spry.Widget.ValidationPassword("sprypassword1");
- //var sprytextfield5 = new Spry.Widget.ValidationTextField("sprytextfield5");
- var spryselect2 = new Spry.Widget.ValidationSelect("spryselect2");
- var spryselect3 = new Spry.Widget.ValidationSelect("spryselect3");
- var spryselect4 = new Spry.Widget.ValidationSelect("spryselect4");
- var spryselect5 = new Spry.Widget.ValidationSelect("spryselect5");
- var spryselect6 = new Spry.Widget.ValidationSelect("spryselect6");
- var spryselect7 = new Spry.Widget.ValidationSelect("spryselect7");
- var spryconfirm1 = new Spry.Widget.ValidationConfirm("spryconfirm1", "password1");
- var spryselect8 = new Spry.Widget.ValidationSelect("spryselect8");
- //-->
- </script>
- <script type="text/javascript">
- function val()
- {
- var err = "";
- var ctr = 0;
- var sID = document.getElementById("stud_no").value;
- var lname = document.getElementById("lname").value;
- var mname = document.getElementById("mname").value;
- var fname = document.getElementById("fname").value;
- if(lname==" ") {
- err += "No spaces pls\n";
- ctr++;
- }
- if(fname==" ") {
- err += "No spaces pls\n";
- ctr++;
- }
- if(mname==" ") {
- err += "No spaces pls\n";
- ctr++;
- }
- if(isNaN(sID))
- {
- err += "Please enter integer for User Number!\n";
- ctr++;
- }
- if(!isNaN(lname))
- {
- err += "Please enter only alphabet for the Lastname!\n";
- ctr++;
- }
- if(!isNaN(mname))
- {
- err += "Please enter only alphabet for the Middlename!\n";
- ctr++;
- }
- if(!isNaN(fname))
- {
- err += "Please enter only alphabet for the Firstname!\n";
- ctr++;
- }
- if(ctr > 0)
- {
- alert(err);
- }
- }
- </script>
- <? mysql_close(); ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement