Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- L�gg till Ant�lld:
- <?php
- $con = mysql_connect("localhost","root"); //connecta till servern
- if (!$con)
- {
- die('Could not connect: ' . mysql_error());
- }
- mysql_select_db("test", $con); //connecta till databasen
- $sql="INSERT INTO inloggning (Username, Password, Kundnr, Kontaktperson, Orgnr, Telenr, mail)
- VALUES
- ('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
- if (!mysql_query($sql,$con)) //kollar om allt st�mmer
- {
- die('Error: ' . mysql_error());
- }
- echo "1 added"; //den visar att en har lagts till
- mysql_close($con) //avslutar sql-satsen
- ?>
- L�gg till kund:
- <?php
- $con = mysql_connect("localhost","root"); //connecta till servern
- if (!$con)
- {
- die('Could not connect: ' . mysql_error());
- }
- mysql_select_db("test", $con); //connecta till databasen
- $sql="INSERT INTO inloggning (Username, Password, Kundnr, Kontaktperson, Orgnr, Telenr, mail)
- VALUES
- ('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
- if (!mysql_query($sql,$con)) //kollar om allt st�mmer
- {
- die('Error: ' . mysql_error());
- }
- echo "1 added"; //den visar att en har lagts till
- mysql_close($con) //avslutar sql-satsen
- ?>
- Inloggning (anst�lld):
- <?php
- $_SESSION['views'] = $_POST[us];
- $l�nk = mysql_connect("localhost", "root")
- or die ("kunde inte anslutas");
- $databas = mysql_select_db("test", $l�nk);
- $sql= ("SELECT * FROM inloggning") or die ("kunde inte hitta tabellen");
- $result=mysql_query("$sql");
- while($rad= mysql_fetch_array($result)){
- if(md5($rad['Username']) === md5($_POST[us]) && md5($rad['Password']) === md5($_POST[pw])){
- include "index.html"; //tex
- }
- }
- ?>
- L�gga till kund
- <form action="inlogKund.php" method="post">
- Username: <input type="text" name="us" />
- Password: <INPUT TYPE=PASSWORD NAME="pw">
- Kontaktperson: <input type="text" name="kp" />
- Orgnr: <input type="text" name="on" />
- Telenr: <input type="text" name="tr" />
- Mail: <input type="text" name="ml" />
- <input type="submit" />
- </form>
- L�gga till anst�lld
- <form action="inlogAnst�lld.php" method="post">
- Username: <input type="text" name="us" />
- Fnamn: <input type="text" name="fn" />
- Enamn: <input type="text" name="en" />
- Password: <INPUT TYPE=PASSWORD NAME="pw">
- Adress: <input type="text" name="ad" />
- Telefonnummer: <input type="text" name="tn" />
- Userlvl: <INPUT TYPE=PASSWORD NAME="ul">
- Personnummer: <INPUT TYPE=PASSWORD NAME="pn">
- <input type="submit" />
- </form>
- Logga in
- <form action="inloggning.php" method="post">
- Username: <input type="text" name="us" />
- Password: <INPUT TYPE=PASSWORD NAME="pw">
- <input type="submit" />
- </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement