Guten Tag,
ich hoffe das jemand mir bei meinem Script helfen kann.
Die Query wird nicht ord*nungs*ge*mäß ausgeführt.
Mfg.Mindfreak
ich hoffe das jemand mir bei meinem Script helfen kann.
Die Query wird nicht ord*nungs*ge*mäß ausgeführt.
PHP Code:
<div id="content_top" >Registartion</div>
<div id="content_main">
<?php
/**
* This User will have functions that hadles user registeration,
* login and forget password functionality
* @author XXXXXX
* @copyright XXXXXXXX
*/
if(isset($_POST['senden']))
{
$login = mysqli_escape_string($_POST['login']); // Username
$email = mysqli_escape_string($_POST['email']); // Email
$upass = mysqli_escape_string(md5($_POST['pass'])); // Password
$social_id = 111111; //Deletecode
$coins = 0; // Coins
$jcoins = 0; // Dragoncoins
/**
* Insert Table Informations
*/
$sqlCMD = "INSERT INTO account.account(login,email,password,social_id,coins,jcoins) VALUES('$login','$email','$upass','$social_id','$coins', '$jcoins')"
/**
* Check
*/
if(mysqli_query($sqlCMD))
echo "You Could Not Register Because Of An Unexpected Error.";
else
echo "Succesfull! Acoount has ben created.";
elseif (strlen($login)>8)
echo "Username must be 8 or more Characters.";
elseif (strlen($upass)>16)
echo "Password must be 16 or more Characters.";
elseif(strlen($login) == ($upass))
echo "Username and Password can not be the same.";
}
?>
<form method="post">
<table align="center" width="30%" border="0">
<tr>
<td>
<input type="text" name="login" placeholder="Username" required />
</td>
</tr>
<tr>
<td>
<input type="email" name="email" placeholder="Email" required />
</td>
</tr>
<tr>
<td>
<input type="password" name="upass" placeholder="Passwort" required />
</td>
</tr>
</tr>
<td>
<script src='https://www.google.com/recaptcha/api.js'></script>
<div class="g-recaptcha" data-sitekey="6LcObgcTAAAAAL_mKqU3MVaEzxD62wyvCLRoQkrD"></div>
</td>
</tr>
<tr>
<td>
<input class="btn" name="senden" value="login" type="submit">
</td>
</tr>
</table>
</form>
</div>
<div id="content_footer"></div><br/>
