18. januar 2006 - 15:58
Der er
7 kommentarer og 1 løsning
loginscript - hente data fra mysgl
hej eksperter. jeg har dette script. jeg vil gerne have det lavet om så det henter login-infoen fra mysgl-database istedet. hvordan sætter man det op? <?php session_start(); // Define your username and password $username = "user"; $password = "pass"; if ($_POST['txtUsername'] != $username || $_POST['txtPassword'] != $password) { ?> <h1>Login</h1> <form name="form" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <p><label for="txtUsername">Username:</label> <br /><input type="text" title="Enter your Username" name="txtUsername" /></p> <p><label for="txtpassword">Password:</label> <br /><input type="password" title="Enter your password" name="txtPassword" /></p> <p><input type="submit" name="Submit" value="Login" /></p> </form> <?php } else { $_SESSION['logged_in'] = true; header("Location: rediger.php"); } ?>
Annonceindlæg tema
Offentlig digitalisering
Fra effektivisering til digital suverænitet. Hvordan skaber det offentlige en digital fremtid med AI, sikkerhed og kontrol i centrum?
18. januar 2006 - 16:05
#1
Noget i denne stil: if(isset($_POST['txtUsername']) && isset($_POST['txtPassword'])) { //Forbind til mysql... $user = mysql_real_escape_string($_POST['txtUsername']); $pass = mysql_real_escape_string($_POST['txtPassword']); $query = mysql_query("SELECT id FROM brugere WHERE user = '".$user."' AND pass = '".$pass."' LIMIT 1"); if(mysql_num_rows($query)>0) { $row = mysql_fetch_assoc($query); $_SESSION['logged_in'] = true; header("Location: " . $_SERVER['HTTP_REFERER']); exit(); } }
18. januar 2006 - 16:18
#2
jeg kan ikke se hvordan jeg forbinder til mysgl
18. januar 2006 - 16:21
#3
18. januar 2006 - 16:33
#4
den er (også) blank... <?php session_start(); // Define your username and password $username = "superchang"; $password = "superchang"; if(isset($_POST['txtUsername']) && isset($_POST['txtPassword'])) { include("./gbog-ting/mysql-funktioner.php"); $user = mysql_real_escape_string($_POST['txtUsername']); $pass = mysql_real_escape_string($_POST['txtPassword']); $query = mysql_query("SELECT id FROM brugere WHERE user = '".$user."' AND pass = '".$pass."' LIMIT 1"); if(mysql_num_rows($query)>0) { $row = mysql_fetch_assoc($query); $_SESSION['logged_in'] = true; header("Location: " . $_SERVER['HTTP_REFERER']); exit(); } } ?> <h1>Login</h1> <form name="form" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <p><label for="txtUsername">Username:</label> <br /><input type="text" title="Enter your Username" name="txtUsername" /></p> <p><label for="txtpassword">Password:</label> <br /><input type="password" title="Enter your password" name="txtPassword" /></p> <p><input type="submit" name="Submit" value="Login" /></p> </form> <?php } else { $_SESSION['logged_in'] = true; header("Location: rediger.php"); } ?>
18. januar 2006 - 17:04
#5
Prøv her: <?php //http://www.eksperten.dk/spm/680648 session_start(); if(isset($_POST['txtUsername']) && isset($_POST['txtPassword'])) { include("./gbog-ting/mysql-funktioner.php"); $user = mysql_real_escape_string($_POST['txtUsername']); $pass = mysql_real_escape_string($_POST['txtPassword']); $query = mysql_query("SELECT id FROM brugere WHERE user = '".$user."' AND pass = '".$pass."' LIMIT 1"); if(mysql_num_rows($query)>0) { $row = mysql_fetch_assoc($query); $_SESSION['logged_in'] = true; header("Location: " . $_SERVER['HTTP_REFERER']); exit(); } } ?> <h1>Login</h1> <form name="form" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <p> <label for="txtUsername">Username:</label> <br /><input type="text" title="Enter your Username" name="txtUsername" /> </p> <p> <label for="txtpassword">Password:</label> <br /><input type="password" title="Enter your password" name="txtPassword" /> </p> <p> <input type="submit" name="Submit" value="Login" /></p> </form>
18. januar 2006 - 17:56
#6
så virkede den også :-) smider du et svar
19. januar 2006 - 07:43
#7
Svar!
19. januar 2006 - 10:41
#8
Takker for point!
Vi tilbyder markedets bedste kurser inden for webudvikling