Advertisement
Guest User

Untitled

a guest
May 3rd, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.05 KB | None | 0 0
  1. L�gg till Ant�lld:
  2. <?php
  3. $con = mysql_connect("localhost","root"); //connecta till servern
  4. if (!$con)
  5. {
  6. die('Could not connect: ' . mysql_error());
  7. }
  8.  
  9. mysql_select_db("test", $con); //connecta till databasen
  10.  
  11. $sql="INSERT INTO inloggning (Username, Password, Kundnr, Kontaktperson, Orgnr, Telenr, mail)
  12. VALUES
  13. ('md5($_POST[us])','md5($_POST[fn])','md5($_POST[en])','md5($_POST[pw])','md5($_POST[ad])','md5($_POST[tn])','md5($_POST[ul])','md5($_POST[pn])')"; //l�gger till det du har skrivit i tabellen
  14.  
  15. if (!mysql_query($sql,$con)) //kollar om allt st�mmer
  16. {
  17. die('Error: ' . mysql_error());
  18. }
  19. echo "1 added"; //den visar att en har lagts till
  20.  
  21. mysql_close($con) //avslutar sql-satsen
  22. ?>
  23.  
  24.  
  25. L�gg till kund:
  26.  
  27. <?php
  28. $con = mysql_connect("localhost","root"); //connecta till servern
  29. if (!$con)
  30. {
  31. die('Could not connect: ' . mysql_error());
  32. }
  33.  
  34. mysql_select_db("test", $con); //connecta till databasen
  35.  
  36. $sql="INSERT INTO inloggning (Username, Password, Kundnr, Kontaktperson, Orgnr, Telenr, mail)
  37. VALUES
  38. ('md5($_POST[us])','md5($_POST[pw])','md5($_POST[kp])','md5($_POST[on])','md5($_POST[tr])','md5($_POST[ml])')"; //l�gger till det du har skrivit i tabellen
  39.  
  40. if (!mysql_query($sql,$con)) //kollar om allt st�mmer
  41. {
  42. die('Error: ' . mysql_error());
  43. }
  44. echo "1 added"; //den visar att en har lagts till
  45.  
  46. mysql_close($con) //avslutar sql-satsen
  47. ?>
  48.  
  49.  
  50.  
  51. Inloggning (anst�lld):
  52.  
  53. <?php
  54. $_SESSION['views'] = $_POST[us];
  55. $l�nk = mysql_connect("localhost", "root")
  56. or die ("kunde inte anslutas");
  57. $databas = mysql_select_db("test", $l�nk);
  58. $sql= ("SELECT * FROM inloggning") or die ("kunde inte hitta tabellen");
  59. $result=mysql_query("$sql");
  60. while($rad= mysql_fetch_array($result)){
  61. if(md5($rad['Username']) === md5($_POST[us]) && md5($rad['Password']) === md5($_POST[pw])){
  62. include "index.html"; //tex
  63. }
  64. }
  65. ?>
  66.  
  67.  
  68.  
  69.  
  70.  
  71.  
  72.  
  73. L�gga till kund
  74. <form action="inlogKund.php" method="post">
  75. Username: <input type="text" name="us" />
  76. Password: <INPUT TYPE=PASSWORD NAME="pw">
  77. Kontaktperson: <input type="text" name="kp" />
  78. Orgnr: <input type="text" name="on" />
  79. Telenr: <input type="text" name="tr" />
  80. Mail: <input type="text" name="ml" />
  81. <input type="submit" />
  82. </form>
  83.  
  84. L�gga till anst�lld
  85. <form action="inlogAnst�lld.php" method="post">
  86. Username: <input type="text" name="us" />
  87. Fnamn: <input type="text" name="fn" />
  88. Enamn: <input type="text" name="en" />
  89. Password: <INPUT TYPE=PASSWORD NAME="pw">
  90. Adress: <input type="text" name="ad" />
  91. Telefonnummer: <input type="text" name="tn" />
  92. Userlvl: <INPUT TYPE=PASSWORD NAME="ul">
  93. Personnummer: <INPUT TYPE=PASSWORD NAME="pn">
  94. <input type="submit" />
  95. </form>
  96.  
  97.  
  98.  
  99.  
  100. Logga in
  101. <form action="inloggning.php" method="post">
  102. Username: <input type="text" name="us" />
  103. Password: <INPUT TYPE=PASSWORD NAME="pw">
  104. <input type="submit" />
  105. </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement