inlog script

[fonville]

hallo ik heb een inlog scrip maar daar heb ik een form maar die linkt naar checklogin.php. is er een mogenlijkheid om die samen te voegen en ja zo hoe?

 

[ScorpionX]

als je ze beide even hier kan neerzetten kunnen we je vast helpen.

 

[fonville]

srry was verkeert

 

[fonville]

checklogin.php
<?php
mysql hier

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// username and password sent from form
$username=$_POST['username'];
$password=$_POST['password'];

// To protect MySQL injection (more detail about MySQL injection)
$username = stripslashes($username);
$password = stripslashes($password);
$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);

$sql="SELECT * FROM $tbl_name WHERE username='$username' and password='$password'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "ingelogt.php"
session_register("username");
session_register("password");
header("location:index.php?p=ingelogt");
}
else {
echo "Wrong Username or Password";

}

?>

inloggen.php:
<form action="checklogin.php"accept-charset="UNKNOWN" enctype="application/x-www-form-urlencoded" method="post">
<td>&nbsp;</td>
&nbsp; &nbsp;
<table border="0" cellspacing="1" cellpadding="3" width="100%" bgcolor="#000000">
<tbody>
<tr>
<td colspan="3"><strong> </strong></td>
</tr>
<tr>
<td>gebruikersnaam</td>
<td>:</td>
<td><input id="username" name="username" type="text" /></td>
</tr>
<tr>
<td>wachtwoord</td>
<td>:</td>
<td><input id="password" name="password" type="password" /></td>
<tr>
</tr>
<td><input name="Submit" type="submit" value="Login" /></td>
<tr>
</tr>
</tbody>
</table>
</form>

 

[ScorpionX]

haal even snel je gegevens weg!

 

[fonville]

gedaan

 

[ScorpionX]

Dit zou moeten werken. Wat ik heb gedaan is checken of de post variabele 'username' is geset. Zo ja, dan formulier niet weergeven, zo nee, dan wel. action mag je leeg laten/de eigenbestandsnaam als hij moet posten naar dezelfde pagina. vergeet niet je gegevens weer in te vullen.

<?php

if(!isset($_POST['username'])){
?>

<form action="" accept-charset="UNKNOWN" enctype="application/x-www-form-urlencoded" method="post">
<td>&nbsp;</td>
&nbsp; &nbsp; 
<table border="0" cellspacing="1" cellpadding="3" width="100%" bgcolor="#000000">
<tbody>
<tr>
<td colspan="3"><strong> </strong></td>
</tr>
<tr>
<td>gebruikersnaam</td>
<td>:</td>
<td><input id="username" name="username" type="text" /></td>
</tr>
<tr>
<td>wachtwoord</td>
<td>:</td>
<td><input id="password" name="password" type="password" /></td>
<tr>
</tr>
<td><input name="Submit" type="submit" value="Login" /></td>
<tr>
</tr>
</tbody>
</table>
</form> 
<?php
}else{


	$host="@@@@@@@@@@"; // Host name 
	$username="@@@@@@@@@@"; // Mysql username 
	$password="@@@@@@@@@@"; // Mysql password 
	$db_name="@@@@@@@@@@"; // Database name 
	$tbl_name="members"; // Table name 

	// Connect to server and select databse.
	mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
	mysql_select_db("$db_name")or die("cannot select DB");

	// username and password sent from form 
	$username=$_POST['username']; 
	$password=$_POST['password']; 

	// To protect MySQL injection (more detail about MySQL injection)
	$username = stripslashes($username);
	$password = stripslashes($password);
	$username = mysql_real_escape_string($username);
	$password = mysql_real_escape_string($password);

	$sql="SELECT * FROM $tbl_name WHERE username='$username' and password='$password'";
	$result=mysql_query($sql);

	// Mysql_num_row is counting table row
	$count=mysql_num_rows($result);
	// If result matched $myusername and $mypassword, table row must be 1 row

	if($count==1){
	// Register $myusername, $mypassword and redirect to file "ingelogt.php"
	session_register("username");
	session_register("password"); 
	header("location:index.php?p=ingelogt");
	}
	else {
	echo "Wrong Username or Password";

	}
}
?>

 

[fonville]

ik zal het proberen

 

[fonville]

als ik nu fout inlog staat er alleen worg ussername/password.
maar kan dat boven het inlog form

 

[ScorpionX]

dan word het zo:

<?php

if(!isset($_POST['username'])){

$formulier = '
<form action="" accept-charset="UNKNOWN" enctype="application/x-www-form-urlencoded" method="post">
<td>&nbsp;</td>
&nbsp; &nbsp; 
<table border="0" cellspacing="1" cellpadding="3" width="100%" bgcolor="#000000">
<tbody>
<tr>
<td colspan="3"><strong> </strong></td>
</tr>
<tr>
<td>gebruikersnaam</td>
<td>:</td>
<td><input id="username" name="username" type="text" /></td>
</tr>
<tr>
<td>wachtwoord</td>
<td>:</td>
<td><input id="password" name="password" type="password" /></td>
<tr>
</tr>
<td><input name="Submit" type="submit" value="Login" /></td>
<tr>
</tr>
</tbody>
</table>
</form>';

echo $formulier;
}else{


	$host="@@@@@@@@@@"; // Host name 
	$username="@@@@@@@@@@"; // Mysql username 
	$password="@@@@@@@@@@"; // Mysql password 
	$db_name="@@@@@@@@@@"; // Database name 
	$tbl_name="members"; // Table name 

	// Connect to server and select databse.
	mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
	mysql_select_db("$db_name")or die("cannot select DB");

	// username and password sent from form 
	$username=$_POST['username']; 
	$password=$_POST['password']; 

	// To protect MySQL injection (more detail about MySQL injection)
	$username = stripslashes($username);
	$password = stripslashes($password);
	$username = mysql_real_escape_string($username);
	$password = mysql_real_escape_string($password);

	$sql="SELECT * FROM $tbl_name WHERE username='$username' and password='$password'";
	$result=mysql_query($sql);

	// Mysql_num_row is counting table row
	$count=mysql_num_rows($result);
	// If result matched $myusername and $mypassword, table row must be 1 row

	if($count==1){
	// Register $myusername, $mypassword and redirect to file "ingelogt.php"
	session_register("username");
	session_register("password"); 
	header("location:index.php?p=ingelogt");
	}
	else {
	echo "Wrong Username or Password";
	echo $formulier;
	}
}
?>

 

[fonville]

het werkt niet. als ik fout inlog bijft het het zelfde geen inlog-form. maar wel worg username/password
en een vraag tussen door hoe die je dat met die code is een ding zetten met scrollbar

 

[ScorpionX]

o ja, mijn fout. ik heb het declareren van de formulier variabele in de if statement gezet. nu gaat hij het doen. druk op reageer op vraag en zoek dan het icoontje met "php" er in boven het tekstveld.

<?php

$formulier = '
<form action="" accept-charset="UNKNOWN" enctype="application/x-www-form-urlencoded" method="post">
<td>&nbsp;</td>
&nbsp; &nbsp; 
<table border="0" cellspacing="1" cellpadding="3" width="100%" bgcolor="#000000">
<tbody>
<tr>
<td colspan="3"><strong> </strong></td>
</tr>
<tr>
<td>gebruikersnaam</td>
<td>:</td>
<td><input id="username" name="username" type="text" /></td>
</tr>
<tr>
<td>wachtwoord</td>
<td>:</td>
<td><input id="password" name="password" type="password" /></td>
<tr>
</tr>
<td><input name="Submit" type="submit" value="Login" /></td>
<tr>
</tr>
</tbody>
</table>
</form>';

if(!isset($_POST['username'])){
	
	echo $formulier;

	}else{


	$host="@@@@@@@@@@"; // Host name 
	$username="@@@@@@@@@@"; // Mysql username 
	$password="@@@@@@@@@@"; // Mysql password 
	$db_name="@@@@@@@@@@"; // Database name 
	$tbl_name="members"; // Table name 

	// Connect to server and select databse.
	mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
	mysql_select_db("$db_name")or die("cannot select DB");

	// username and password sent from form 
	$username=$_POST['username']; 
	$password=$_POST['password']; 

	// To protect MySQL injection (more detail about MySQL injection)
	$username = stripslashes($username);
	$password = stripslashes($password);
	$username = mysql_real_escape_string($username);
	$password = mysql_real_escape_string($password);

	$sql="SELECT * FROM $tbl_name WHERE username='$username' and password='$password'";
	$result=mysql_query($sql);

	// Mysql_num_row is counting table row
	$count=mysql_num_rows($result);
	// If result matched $myusername and $mypassword, table row must be 1 row

	if($count==1){
	// Register $myusername, $mypassword and redirect to file "ingelogt.php"
	session_register("username");
	session_register("password"); 
	header("location:index.php?p=ingelogt");
	}
	else {
	echo "Wrong Username or Password";
	echo $formulier;
	}
}
?>

 

[fonville]

gelukt

ik heb zelf ook wat dingen aan het script ge edit

<?php
 
if(!isset($_POST['username'])){
echo "hier inloggen";
}else{
 
 
$host="@@@@@@@@"; // Host name 
$username="@@@@@@@@"; // Mysql username 
$password="@@@@@@@"; // Mysql password 
$db_name="@@@@@@@"; // Database name 
$tbl_name="@@@@@@@"; // Table name 
 
    // Connect to server and select databse.
    mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
    mysql_select_db("$db_name")or die("cannot select DB");
 
    // username and password sent from form 
    $username=$_POST['username']; 
    $password=$_POST['password']; 
 
    // To protect MySQL injection (more detail about MySQL injection)
    $username = stripslashes($username);
    $password = stripslashes($password);
    $username = mysql_real_escape_string($username);
    $password = mysql_real_escape_string($password);
 
    $sql="SELECT * FROM $tbl_name WHERE username='$username' and password='$password'";
    $result=mysql_query($sql);
 
    // Mysql_num_row is counting table row
    $count=mysql_num_rows($result);
    // If result matched $myusername and $mypassword, table row must be 1 row
 
    if($count==1){
    // Register $myusername, $mypassword and redirect to file "ingelogt.php"
    session_register("username");
    session_register("password"); 
    header("location:index.php?p=ingelogt");
    }
    else {
    echo "Wrong Username or Password";  
    }
}
?> 
<?
$formulier = '
<form action="" accept-charset="UNKNOWN" enctype="application/x-www-form-urlencoded" method="post">
<td>&nbsp;</td>
&nbsp; &nbsp; 
<table border="0" cellspacing="1" cellpadding="3" width="100%" bgcolor="#000000">
<tbody>
<tr>
<td colspan="3"><strong> </strong></td>
</tr>
<tr>
<td>gebruikersnaam</td>
<td>:</td>
<td><input id="username" name="username" type="text" /></td>
</tr>
<tr>
<td>wachtwoord</td>
<td>:</td>
<td><input id="password" name="password" type="password" /></td>
<tr>
</tr>
<td><input name="Submit" type="submit" value="Login" /></td>
<tr>
</tr>
</tbody>
</table>
</form>';
echo $formulier;
?>

ik zal die andere code ook even uitproberen

 

[fonville]

ik gebruik uw code die is wat mooier
hartelijk bedank voor de code en snelle reactie

 

[ScorpionX]

geen probleem! suc6 ermee!