/addEdu.php

https://bitbucket.org/wlynch92/cs336-dbproject · PHP · 80 lines · 76 code · 4 blank · 0 comment · 2 complexity · 43c527e66b9f2cafc0ab70244607a38b MD5 · raw file 

    

  1. <html>
    2. 

  2. 

  3. <head>
    4. 

  4. <title>Account Creation</title>
    5. 

  5. </head>
    6. 

  6. <body>
    7. 

  7. <a href="/"><h1>Music Box</h1></a>
    8. 

  8. A social music site for everyone!
    9. 

  9. <p><center><hr width=100% noshade=noshade></center>
    10. 

  10. 

  11. <?php
    12. 

  12. session_start();
    13. 

  13. 

  14. $con = mysql_connect("cs336-64.rutgers.edu", "csuser", "cs277315");
    15. 

  15. if (!$con) {
    16. 

  16.     die ('cannot connect: '.mysql_error());
    17. 

  17. }
    18. 

  18. mysql_select_db("cs336", $con);
    19. 

  19. $schoollist = mysql_query("SELECT * FROM school");
    20. 

  20. 

  21. ?>
    22. 

  22.     <h2>Account Creation (con't)</h2>
    23. 

  23.     <i>* = required field</i><p>
    24. 

  24. 

  25. 

  26.     <form action="addEdu.php" method="POST">
    27. 

  27.     <b>Education</b><br>
    28. 

  28.     School: <select name="school">
    29. 

  29. <?php
    30. 

  30. while ($school = mysql_fetch_array($schoollist)) {
    31. 

  31.     echo "<option value=\"".$school['sname']."\">".$school['sname']."</option>";
    32. 

  32. }
    33. 

  33. ?>
    34. 

  34.     </select>*<br>
    35. 

  35.     Start date: <input type="date" name="sdate"><br>
    36. 

  36.     End date: <input type="date" name="edate"><br>
    37. 

  37.     Degree: <input type="textbox" name="degree">*<p>
    38. 

  38.     <input type="submit" value="create account!">    
    39. 

  39. </form>
    40. 

  40. </body>
    41. 

  41. </html>
    42. 

  42. 

  43. <?php
    44. 

  44. 

  45. function setval($post) {
    46. 

  46.     if($post) {
    47. 

  47.         return "'".$post."'";
    48. 

  48.     }
    49. 

  49.     else {
    50. 

  50.         return "NULL";
    51. 

  51.     }
    52. 

  52. }
    53. 

  53. 

  54. if ($_POST['school'] && $_POST['degree']) {
    55. 

  55. 

  56.     $uid = $_SESSION['newuid'];
    57. 

  57.     
    58. 

  58.     $sname = setval($_POST['school']);
    59. 

  59.     $srow = mysql_fetch_array(mysql_query("SELECT sid FROM school WHERE sname=$sname"));
    60. 

  60.     $sid = $srow['sid'];
    61. 

  61. 

  62.     $sdate = setval($_POST['sdate']);
    63. 

  63.     $edate = setval($_POST['edate']);
    64. 

  64.     $degree = setval($_POST['degree']);
    65. 

  65. 

  66.     $query = "INSERT INTO attended VALUES ($uid, $sid, $sdate, $edate, $degree)";
    67. 

  67.     $res = mysql_query($query, $con);
    68. 

  68.     if (!$res) {
    69. 

  69.         echo "Error in adding education information, please try again!\n<br>\n";
    70. 

  70.         mysql_close($con);
    71. 

  71.     }
    72. 

  72.     else {
    73. 

  73.         echo "Success! Redirecting back to home page.\n<br>\n";
    74. 

  74.         mysql_close($con);
    75. 

  75.         header("Refresh: 2; URL=/");
    76. 

  76.         exit;
    77. 

  77.     }
    78. 

  78. }
    79. 

  79. 

  80. ?>
    81.