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
Cloud & AI
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
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