Hej! var ett tag sen ja va lite aktiv i forumen men nu har jag en fråga...
Min sida m.playstation-online.net16.net är en mobil sida av min playstation-online.net16.net sida :P
Sidan är tänkt att ses med en iPhone eller en iPod Touch så den ser lite knäpp ut i datorn. Ja installerade ett inloggningssystem på exakt samma sätt som på PC versionen men man kan inte varken logga in eller registrera sig... :( Så här ser mina koder ut:
Conn.php:
<?php
// Byt ut mot dina inloggningsuppgifter och databas
$mysql_host = "mysql11.000webhost.com";
$mysql_database = "a8875503_data";
$mysql_user = "a8875503_user";
$mysql_password = "************";
$conn = mysql_connect($mysql_host, $mysql_user, $mysql_password);
mysql_select_db($mysql_database, $conn);
// En funktion att användas när magic_quotes_gpc inte är satt. För att förhindra SQL-injections, eller i lidrigare fall MySQl-fel.
function db_escape ($post)
{
if (is_string($post)) {
if (get_magic_quotes_gpc()) {
$post = stripslashes($post);
}
return mysql_real_escape_string($post);
}
foreach ($post as $key => $val) {
$post[$key] = db_escape($val);
}
return $post;
}
/*
Se till att det inte finns några dolda tecken, typ radbyte
eller mellanslag, efter den avslutande PHP-taggen !!!
*/
?>
Index.php
<?php
session_start(); // Alltid överst på sidan
include "conn.php"; // Databasanslutningen
// Inloggning
if (isset($_POST['submit'])){
$_POST = db_escape($_POST);
$sql = "SELECT id FROM members
WHERE user='{$_POST['user']}'
AND pass='{$_POST['passwd']}'";
$result = mysql_query($sql);
// Hittades inte användarnamn och lösenord
// skicka till formulär med felmeddelande
if (mysql_num_rows($result) == 0){
header("Location: index.php?badlogin=");
exit;
}
// Sätt sessionen med unikt index
$_SESSION['sess_id'] = mysql_result($result, 0);
$_SESSION['sess_user'] = $_POST['user'];
header("Location: welcome.php");
exit;
}
// Utloggning
if (isset($_GET['logout'])){
$_SESSION = array();
session_destroy();
header("Location: index.php");
exit;
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=iso-8859-1">
<title>Index</title>
</head>
<body><font size="3" face="Georgia, Tahoma" color="black">
<?php
// Om inte inloggad visa formulär, annars logga ut-länk
if (!isset($_SESSION['sess_user'])){
echo "<h3>Login</h3>\n";
// Visa felmeddelande vid felaktig inloggning
if (isset($_GET['badlogin'])){
echo "Wrorng username or password!<br>\n";
echo "Try agian!\n";
}
?>
<form action="index.php" method="post">
Username:<br>
<input type="text" name="user"><br>
Password:<br>
<input type="password" name="passwd"><br>
<input type="submit" name="submit" value="Login">
</form>
Not Member?<br>
<a href="register.php">Register</a>
<?php
} else {
echo "<a href=\"index.php?logout=\">Log out</a>\n";
}
?>
</body>
</html>
// Om inte inloggad visa formulär, annars logga ut-länk
if (!isset($_SESSION['sess_user'])){
echo "<h3>Login</h3>\n";
// Visa felmeddelande vid felaktig inloggning
if (isset($_GET['badlogin'])){
echo "Wrorng username or password!<br>\n";
echo "Try agian!\n";
}
?>
<form action="index.php" method="post">
Username:<br>
<input type="text" name="user"><br>
Password:<br>
<input type="password" name="passwd"><br>
<input type="submit" name="submit" value="Login">
</form>
Not a Member?<br>
<a href="register.php">Register</a>
<?php
} else {
echo "<a href=\"index.php?logout=\">Log out</a>\n";
}
?>
</body>
</html>
Register.php:
<?php
session_start(); // Alltid överst på sidan
include "conn.php"; // Databasanslutningen
if (isset($_POST['submit'])){
$_POST = db_escape($_POST);
// Tag bort eventuella blanksteg i början eller slutet
foreach($_POST as $key => $val){
$_POST[$key] = trim($val);
}
//Kolla efter tomma fält
if (empty($_POST['user']) || empty($_POST['passwd']) ||
empty($_POST['name']) || empty($_POST['email'])) {
$reg_error[] = 0;
}
// Kolla om användarnamnet är upptaget
$sql = "SELECT COUNT(*) FROM members WHERE user='{$_POST['user']}'";
$result = mysql_query($sql);
if (mysql_result($result, 0) > 0) {
$reg_error[] = 1;
}
// Kolla om e-post kan tänkas vara ok
if (!preg_match('/^[-A-Za-z0-9_.]+[@][A-Za-z0-9_-]+([.][A-Za-z0-9_-]+)*[.][A-Za-z]{2,8}$/', $_POST['email'])) {
$reg_error[] = 2;
}
// Kolla om godkänt Terms of Service
if (empty($_POST['terms'])) {
$reg_error[] = 3;
}
// Inga fel? Spara och logga in samt skicka till välkomstsida
if (!isset($reg_error)) {
$sql = "INSERT INTO members(user, pass, name, email)
VALUES('{$_POST['user']}', '{$_POST['passwd']}', '{$_POST['name']}', '{$_POST['email']}')";
mysql_query($sql);
$_SESSION['sess_id'] = mysql_insert_id();
$_SESSION['sess_user'] = $_POST['user'];
header("Location: welcome.php");
exit;
}
} else {
// Sätt variabler för tomt formulär
for ($i=0; $i<4; $i++) {
$back[$i] = "";
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=iso-8859-1">
<title></title>
</head><ul class="pageitem">
<li class="textbox">
<body><body>
<?php
if (isset($reg_error)){
// Felmeddelanden
$error_list[0] = "Type in all fields";
$error_list[1] = "Username is taken";
$error_list[2] = "Invaild Email";
$error_list[2] = "Must Agree Terms of Service";
echo "Someting got wrong:<br>\n";
echo "<ul>\n";
for ($i=0; $i<sizeof($reg_error); $i++) {
echo "<li>{$error_list[$reg_error[$i]]}</li>\n";
}
echo "</ul>\n";
// Sätter returvariabler till formuläret
$back[0] = $_POST['user'];
$back[1] = $_POST['passwd'];
$back[2] = $_POST['name'];
$back[3] = $_POST['email'];
}
?>
<form action="register.php" method="post"
name="frmRegister">
<span class="graytitle"><b>User info</b></span>
<ul class="pageitem">
<li class="form"><input placeholder="Username" type="text" name="user" size="20" value="<?=$back[0] ?>"></li>
<li class="form"><input placeholder="Password" type="password" name="passwd" size="20" value="<?=$back[1] ?>">
<li class="form"><input placeholder="Confirm Password" type="password" name="passwd" size="20" value="<?=$back[1] ?>"></li>
</ul>
<table>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<span class="graytitle"><b>Personal info</b></span>
<ul class="pageitem">
<li class="form"><span class="narrow"><span class="name">First Name:</span><input type="text" name="name" size="20" value="<?=$back[2] ?>">
</span></li>
<li class="form"><span class="narrow"><span class="name">Last name:</span><input type="text" name="name" size="20" value="<?=$back[2] ?>">
</span></li>
<li class="form"><span class="narrow"><span class="name">Email:</span><input type="text" name="email" size="20" value="<?=$back[3] ?>">
</span></li>
</ul>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<span class="graytitle">Gender:</span>
<ul class="pageitem">
<li class="form"><span class="choice"><span class="name">Male</span>
<input name="gender" type="radio" value="male" /></span></li>
<li class="form"><span class="choice"><span class="name">Female</span>
<input name="gender" type="radio" value="female" /></span></li>
</ul>
</tr>
<span class="graytitle">Terms of Service</span>
<ul class="pageitem">
<li class="form"><span class="check"><span class="name">I agree</span><input type="checkbox" name="terms" id="terms" />
</span></li>
<li class="form">
<input name="Submit" type="submit" value="Register" /></li>
<li class="form">
<input name="Reset" type="reset" value="Reset" /></li>
</ul>
</form>
</table>
</body>
</html>
Welcome.php
<?php
session_start(); // Alltid överst på sidan
// Kolla om inloggad = sessionen satt
if (!isset($_SESSION['sess_user'])) {
header("Location: index.php");
exit;
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=iso-8859-1">
<title>Welcome</title>
</head>
<body><body><font size="3" face="Georgia, Tahoma" color="black">
Welcome, you are signed in as <?=$_SESSION['sess_user'] ?><br>
<a href="index.php?logout=">Log Out</a>
</body>
</html>
Login.php
<html>
<body>
<?php
// Om inte inloggad visa formulär, annars logga ut-länk
if (!isset($_SESSION['sess_user'])){
?>
<span class="graytitle">Login</span>
<form action="index.php" method="post">
<ul class="pageitem">
<li class="form"><span class="narrow"><span class="name">Username:</span><input type="text" name="user">
</span></li>
<li class="form"><span class="narrow"><span class="name">Password:</span><input type="password" name="pass">
</span></li>
<li class="form">
<input name="submit" type="submit" value="Login" /></li>
</ul>
</form>
<ul class="pageitem">
<li class="textbox"><span class="header">Not a Member?</span><a href="register.php">Register</a>
<?php
} else {
echo "<a href=\"index.php?logout=\">Log Out</a>\n";
}
?>
</body>
</html>
Hjälp tack! :)