Jag har gjort ett PHP script som ska registrera informationen som anges i databasen... först fungerade det perfekt, men inte nu längre :(
Dessutom så vill jag att det där meddelandet som visas när man registrerar sig ska vara felfritt (alltså att man kan använda php där också)..
Hjälp? Varför fungerar det inte?
Jag hoppas att ni förstår vad jag menar med scriptet och så...
Ett stycke php-kod:
<?php
// DB CONNECTION
mysql_connect("localhost", "root", "ascent") or die(mysql_error());
mysql_select_db("users") or die(mysql_error());
//SUBMIT
if (isset($_POST['submit'])) {
//NO BLANK FIELDS
if (!$_POST['username'] | !$_POST['pass'] | !$_POST['pass2'] | !$_POST['email'] | !$_POST['domain'] ) {
die('You did not complete all of the required fields');
}
// NAME ALREADY USED
if (!get_magic_quotes_gpc()) {
$_POST['username'] = addslashes($_POST['username']);
}
$usercheck = $_POST['username'];
$check = mysql_query("SELECT username FROM users WHERE username = '$usercheck'")
or die(mysql_error());
$check2 = mysql_num_rows($check);
// NAME ERROR
if ($check2 != 0) {
die('Sorry, the username '.$_POST['username'].' is already in use.');
}
// PASSWORD CHECK
if ($_POST['pass'] != $_POST['pass2']) {
die('Your passwords did not match. ');
}
// DB INSERT
$insert = "INSERT INTO users (username, password, email, domain)
VALUES ('".$_POST['username']."', '".$_POST['pass']."', '".$_POST['email']."', '".$_POST['domain']."')";
$add_member = mysql_query($insert);
?>
<h1>Complete!</h1>
<p>Thank you, we will send you a email with information as soon as we have accepted your recuest! <br/>
Save this information:</a>.</p><br />
Date:
// Prints something like: Monday 8th of August 2005 03:12:46 PM
echo date('l jS of F Y h:i:s A');
Name:
//NAME OF USER
echo ($_POST['username']);
<?php
}
else
{
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<table border="0">
<tr><td>Name:</td><td>
<input type="text" name="username" maxlength="60">
</td></tr>
<tr><td>Password:</td><td>
<input type="password" name="pass" maxlength="10">
</td></tr>
<tr><td>Confirm Password:</td><td>
<input type="password" name="pass2" maxlength="10">
</td></tr>
<tr><td>Domain:</td><td>
<input type="text" name="domain" maxlength="50">
</td></tr>
<tr><td>Email</td><td>
<input type="text" name="email" maxlength="30">
</td></tr>
<tr><th colspan=2><input type="submit" name="submit" value="Register"></th></tr> </table>
</form>
<?php
}
?>
Tillägg av Gurrewe 2009-12-04 16:50
Här används scriptet:
http://justice.no-ip.org/a/login2/register.php
Här används scriptet:
http://justice.no-ip.org/a/login2/register.php
Tillägg av Gurrewe 2009-12-06 20:12
Nu har jag uppdaterat scriptet lite, och det ser ut såhär:
Men, det fungerar inte... HJÄLP!
Nu har jag uppdaterat scriptet lite, och det ser ut såhär:
Ett stycke php-kod:
<?php
// DB CONNECTION
mysql_connect("localhost", "root", "ascent") or die(mysql_error());
mysql_select_db("users") or die(mysql_error());
//SUBMIT
if (isset($_POST['submit'])) {
//NO BLANK FIELDS
if (!$_POST['username'] | !$_POST['pass'] | !$_POST['pass2'] | !$_POST['email'] | !$_POST['domain'] | !$_POST['phone'] | !$_POST['address'] | !$_POST['city'] | !$_POST['state'] | !$_POST['state'] | !$_POST['zipcode'] | !$_POST['country'] | !$_POST['paypal'] ) {
die('You did not complete all of the required fields');
}
// NAME ALREADY USED
if (!get_magic_quotes_gpc()) {
$_POST['username'] = addslashes($_POST['username']);
}
$usercheck = $_POST['username'];
$check = mysql_query("SELECT username FROM users WHERE username = '$usercheck'")
or die(mysql_error());
$check2 = mysql_num_rows($check);
// NAME ERROR
if ($check2 != 0) {
die('Sorry, the username '.$_POST['username'].' is already in use.');
}
// PASSWORD CHECK
if ($_POST['pass'] != $_POST['pass2']) {
die('Your passwords did not match. ');
}
// DB INSERT
$insert = "INSERT INTO users (username, firstname, lastname, password, email, domain, phone, address, city, state, zipcode, contry, paypal)
VALUES ('".$_POST['username']."', '".$_POST['firstname']."', '".$_POST['pass']."', '".$_POST['email']."', '".$_POST['domain']."' '".$_POST['phone']."', '".$_POST['address']."', '".$_POST['city']."', '".$_POST['state']."', '".$_POST['zupcode']."', '".$_POST['country']."', '".$_POST['paypal']."',)";
$add_member = mysql_query($insert);
?>
<h1>Complete!</h1>
<p>Thank you, we will send you a email with information as soon as we have accepted your recuest! <br/>
Save this information:</a>.</p><br /><br /><br /><br />
Date:<br />
<?php echo date('l jS \of F Y h:i:s A'); ?>
<br /><br />
Name:<br />
<?php echo ($_POST['username']); ?>
<br /><br />
Email:<br />
<?php echo ($_POST['email']); ?>
<br /><br />
Domain:<br />
<?php echo ($_POST['domain']); ?>
<br /><br />
<?php
}
else
{
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<table border="0">
<tr><td>First Name:</td><td>
<input type="text" name="firstname" maxlength="60">
</td></tr>
<tr><td>Last Name:</td><td>
<input type="text" name="lastname" maxlength="60">
</td></tr>
<tr><td>Alias:</td><td>
<input type="text" name="username" maxlength="60">
</td></tr>
<tr><td>Phone:</td><td>
<input type="text" name="phone" maxlength="60">
</td></tr>
<tr><td>Address:</td><td>
<input type="text" name="address" maxlength="60">
</td></tr>
<tr><td>City:</td><td>
<input type="text" name="city" maxlength="60">
</td></tr>
<tr><td>State / Prov:</td><td>
<input type="text" name="state" maxlength="60">
</td></tr>
<tr><td>ZipCode:</td><td>
<input type="text" name="zipcode" maxlength="60">
</td></tr>
<tr><td>Country:</td><td>
<input type="text" name="country" maxlength="60">
</td></tr>
<tr><td>PayPal Email Adress:</td><td>
<input type="text" name="paypal" maxlength="60">
</td></tr>
<tr><td>Password:</td><td>
<input type="password" name="pass" maxlength="10">
</td></tr>
<tr><td>Confirm Password:</td><td>
<input type="password" name="pass2" maxlength="10">
</td></tr>
<tr><td>Domain:</td><td>
<input type="text" name="domain" maxlength="50">
</td></tr>
<tr><td>Email</td><td>
<input type="text" name="email" maxlength="30">
</td></tr>
<tr><th colspan=2><input type="submit" name="submit" value="Order"></th></tr> </table>
</form>
<?php
}
?>
Men, det fungerar inte... HJÄLP!
/party
