API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 4th, 2016
99
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 9.10 KB | None | 0 0
raw download clone embed print report
  1. <!DOCTYPE html>
  2. <html lang="en">
  3.   <head>
  4.     <meta charset="utf-8">
  5.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  6.     <meta name="viewport" content="width=device-width, initial-scale=1">
  7.     <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
  8.     <meta name="description" content="">
  9.     <meta name="author" content="">
  10.     <link rel="icon" href="favicon.png">
  11.  
  12.     <title>EndoDB - UKSH</title>
  13.  
  14.     <!-- Bootstrap core CSS -->
  15.     <link href="css/bootstrap.min.css" rel="stylesheet">
  16.  
  17.     <!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
  18.     <link href="css/ie10-viewport-bug-workaround.css" rel="stylesheet">
  19.  
  20.     <!-- Custom styles for this template -->
  21.     <link href="css/dashboard.css" rel="stylesheet">
  22.  
  23.     <!-- Just for debugging purposes. Don't actually copy these 2 lines! -->
  24.     <!--[if lt IE 9]><script src="../../assets/js/ie8-responsive-file-warning.js"></script><![endif]-->
  25.     <script src="js/ie-emulation-modes-warning.js"></script>
  26.  
  27.     <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
  28.     <!--[if lt IE 9]>
  29.       <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  30.       <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
  31.     <![endif]-->
  32.   </head>
  33.  
  34.   <body>
  35.  
  36.     <nav class="navbar navbar-inverse navbar-fixed-top">
  37.       <div class="container-fluid">
  38.         <div class="navbar-header">
  39.           <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
  40.             <span class="sr-only">Toggle navigation</span>
  41.             <span class="icon-bar"></span>
  42.             <span class="icon-bar"></span>
  43.             <span class="icon-bar"></span>
  44.           </button>
  45.           <a class="navbar-brand" href="index.html">Endodatenbank der UKSH</a>
  46.         </div>
  47.         <div id="navbar" class="navbar-collapse collapse">
  48.           <ul class="nav navbar-nav navbar-right">
  49.             <li class="hidden"><a href="#">Dashboard</a></li>
  50.             <li class="hidden"><a href="#">Settings</a></li>
  51.             <li class="hidden"><a href="#">Profile</a></li>
  52.             <li><a href="#">Help</a></li>
  53.           </ul>
  54.           <form class="navbar-form navbar-right">
  55.             <input type="text" class="form-control" placeholder="Search...">
  56.           </form>
  57.         </div>
  58.       </div>
  59.     </nav>
  60.  
  61.     <div class="container-fluid">
  62.       <div class="row">
  63.         <div class="col-sm-3 col-md-2 sidebar">
  64.           <ul class="nav nav-sidebar">
  65.             <li><a href="index.html">Start <span class="sr-only">(current)</span></a></li>
  66.             <li><a href="insert.html">Datenblatt</a></li>
  67.             <li class="active"><a href="stats.html">Statistik</a></li>
  68.             <li><a href="view.html">Fälle</a></li>
  69.           </ul>
  70.         </div>
  71.         <div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">
  72.           <h1 class="page-header">Wurzelkanalbehandlung</h1>
  73.           <!-- INHALT -->
  74.           <?php
  75.             // Only process POST reqeusts.
  76.             // Get the form fields and remove whitespace.
  77.  
  78.             $fullname  = trim($_POST["fullname"]);
  79.             $allg_anamnese = $_POST["allg_anamnese"];
  80.             $schmerz_anamnese = htmlspecialchars($_POST["schmerz_anamnese"]);
  81.             $date = $_POST["date"];
  82.             $birth = $_POST["birth"];
  83.  
  84.             // $endoPatientenname = strip_tags(trim($_POST["endoPatientenname"]));
  85.             // $endoGeburtsdatum =  trim($_POST["endoGeburtsdatum"]);
  86.             // $kuerzel = trim($_POST["kuerzel"]);
  87.             // $endoBehandler = trim($_POST["endoBehandler"]);
  88.             // $endoDatum = trim($_POST["endoDatum"]);
  89.             // $quadranteins = trim($_POST["quadranteins"]);
  90.             // $endoAnamneseAllgemein = $_POST["endoAnamneseAllgemein"];
  91.             // $endoAnamneseSchmerz = $_POST["endoAnamneseSchmerz"];
  92.  
  93.  
  94.             // $farbveraenderung = trim($_POST["farbveraenderung"]);
  95.             // $sensibilitaet = trim($_POST["sensibilitaet"]);
  96.             // $perkussion = trim($_POST["perkussion"]);
  97.             // $weichgewebeschwellung = trim($_POST["weichgewebeschwellung"]);
  98.             // $karies = trim($_POST["karies"]);
  99.             // $restaurationsuff = trim($_POST["restaurationsuff"]);
  100.             // $beweglichkeit = trim($_POST["beweglichkeit"]);
  101.             // $pulpaeroeffnung = trim($_POST["pulpaeroeffnung"]);
  102.             // $schmerzen = trim($_POST["schmerzen"]);
  103.             // $sondierungstiefe = trim($_POST["sondierungstiefe"]);
  104.             // $crack = trim($_POST["crack"]);
  105.             // $furkation = trim($_POST["furkation"]);
  106.  
  107.  
  108.             // $zahnfilm = trim($_POST["zahnfilm"]);
  109.             // $apikaleaufhellung = trim($_POST["apikaleaufhellung"]);
  110.             // $durchmesser = trim($_POST["durchmesser"]);
  111.             // $cariesprofunda = trim($_POST["cariesprofunda"]);
  112.             // $paspalt = trim($_POST["paspalt"]);
  113.             // $paroendo = trim($_POST["paroendo"]);
  114.  
  115.             // //check box? nicht fertig (1)
  116.             // $diagnose = trim($_POST["diagnose"]);
  117.             // $aufklaerung = trim($_POST["aufklaerung"]);
  118.             // $begruendungrev = trim($_POST["begruendungrev"]);
  119.             // $therapie = trim($_POST["therapie"]);
  120.             // $roebefundcheckbox = trim($_POST["roebefundcheckbox"]);
  121.             // $roebefund = trim($_POST["roebefund"]);
  122.  
  123.  
  124.             $servername = "localhost";
  125.             $username = "root";
  126.             $password = "manager";
  127.             $dbname = "endo";
  128.  
  129.             // var_dump($_POST);
  130.  
  131.             // Create connection
  132.             $conn = new mysqli($servername, $username, $password, $dbname);
  133.             // Check connection
  134.             if ($conn->connect_error) {
  135.                 die('<div class="alert alert-danger">Connection failed: ' . $conn->connect_error. '</div>');
  136.             }
  137.             $sql = "INSERT INTO `endo`.`patient` (`id`, `fullname`, `geburtsdatum`, `datum_erstebehandlung`, `allg_anamnese`, `schmerzanamnese`) VALUES (NULL, '".$fullname."', '".$birth."', '".$date."', '".$allg_anamnese."', '".$schmerz_anamnese."')";
  138.             // $sql_endo= "INSERT INTO `endoTabelle` (`patientenname`, `Geburtsdatum`, `BehandlerID`,`BehandlerKürzel`, `Behandler`, `Datum`, `BehandelterZahn`,`AllgemeineAnamnese`, `SchmerzAnamnese`) VALUES ('".$endoPatientenname."', '".$endoGeburtsdatum."', '1','".$kuerzel."','".$endoBehandler."', '".$endoDatum."', '".$quadranteins."', '".$endoAnamneseAllgemein."', '".$endoAnamneseSchmerz."')";
  139.  
  140.             // $sql_spezi = "INSERT INTO `Zahnspezifischer Befund`(`id`, `Farbveränderung`, `Sensibilität`, `Perkussion`, `Weichgewebe Schwellung`, `Karies`, `Zahn erhaltungswürdig`, `Beweglichkeit`, `Pulpaeröffnung`, `Schmerzen`, `Sondierungstiefe`, `Crack`, `Furkation`) VALUES ([value-1],['".$farbveraenderung."','".$sensibilitaet."','".$perkussion."','".$weichgewebeschwellung."','".$karies."','".$restaurationsuff."','".$beweglichkeit."','".$pulpaeroeffnung."','".$schmerzen."','".$sondierungstiefe."','".$crack."','".$furkation."')";
  141.  
  142.             // $sql_radio = "INSERT INTO `Röntgen`(`id`, `Röntgen ZF`, `apikale Aufhellung`, `Durchmesser >5mm`, `caries profunda`, `PA-Spalt verbreitert`, `Paro-Endo-Läsion`) VALUES ('".$zahnfilm."', '".$apikaleaufhellung."', '".$durchmesser."', '".$cariesprofunda."', '".$paspalt."', '".$paroendo."')";
  143.  
  144.             // //nicht fertig wg chebox (1)
  145.             // $sql_block4 = "INSERT INTO `Block 4`(`id`, `Diagnose`, `Datum Aufklärung`, `Therapie`, `Begründung Revision`, `Röntgenkontrolle nach Entfernung der WF`, `Rö-Befund`) VALUES ( ID ?!,'".$diagnose."','".$aufklaerung."','".$therapie."','".$begruendungrev."','".$roebefundcheckbox."','".$roebefund."','".$zahnfilm."',)";
  146.  
  147.             // // SQL statments zusamenfügen
  148.             // $sql = $sql_endo."; ".$sql_spezi."; ".$sql_radio."; ".$sql_radio;
  149.  
  150.  
  151.  
  152.             if ($conn->query($sql) === TRUE) {
  153.                 echo '<div class="alert alert-success">Ihre Daten wurden erfolgreich eingetragen</div>';
  154.             } else {
  155.                 echo '<div class="alert alert-danger">'."<h2> Hopla, hier ist ein Fehler aufgetreten!</h2><h4> MYSQL meldet:</h4> " . $sql . "<br>" . $conn->error . "</div>";
  156.             }
  157.             $conn->close();
  158.           ?>
  159.         </div>
  160.       </div>
  161.     </div>
  162.  
  163.     <!-- Bootstrap core JavaScript
  164.     ================================================== -->
  165.     <!-- Placed at the end of the document so the pages load faster -->
  166.     <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
  167.     <script>window.jQuery || document.write('<script src="../../assets/js/vendor/jquery.min.js"><\/script>')</script>
  168.     <script src="js/bootstrap.min.js"></script>
  169.     <!-- Just to make our placeholder images work. Don't actually copy the next line! -->
  170.     <script src="js/vendor/holder.min.js"></script>
  171.     <!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
  172.     <script src="js/ie10-viewport-bug-workaround.js"></script>
  173.   </body>
  174. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!