xhadowzit 0 Posted January 20, 2014 A pagina tá a aparecer em branco, podem passar revisão ao codigo para ver se tá tudo correcto pff? <?php include('config.php'); if(isset($_POST['submit']) && $_POST['submit'] == 'Registrar') { $login = mysql_real_escape_string($_POST['login']); $password = mysql_real_escape_string($_POST['password']); $social_id = mysql_real_escape_string($_POST['social_id']); $real_name = mysql_real_escape_string($_POST['real_name']); $email = mysql_real_escape_string($_POST['email']); $sql = "INSERT INTO account SET login = '".$login."', password = PASSWORD('".$password."'), social_id = '".$social_id."', real_name = '".$real_name."', email = '".$email."'"; $result = mysql_query($sql); if($login, $password, $social_id, $real_name, $email) {echo include('Por favor preencha todos os campos!'); } if($result) { echo 'Conta criada com sucesso!'; } else { echo 'Conta sem sucesso, tente novamente!'; } }?>Obrigado a todos dês de já :D Share this post Link to post Share on other sites
morfo2 4,680 Posted January 20, 2014 <?php include('config.php'); if(isset($_POST['submit']) && $_POST['submit'] == 'Registrar') { $login = mysql_real_escape_string($_POST['login']); $password = mysql_real_escape_string($_POST['password']); $social_id = mysql_real_escape_string($_POST['social_id']); $real_name = mysql_real_escape_string($_POST['real_name']); $email = mysql_real_escape_string($_POST['email']); $sql = "INSERT INTO account SET login = '".$login."', password = PASSWORD('".$password."'), social_id = '".$social_id."', real_name = '".$real_name."', email = '".$email."'"; $result = mysql_query($sql); if($login, $password, $social_id, $real_name, $email) { echo 'Conta criada com sucesso!'; } else { echo 'Por favor preencha todos os campos!'; } }?> 1 xhadowzit reacted to this Share this post Link to post Share on other sites
xhadowzit 0 Posted January 20, 2014 Obrigado mano pela ajuda... Mais uma coisa mano, como fasso para fazer verificação se a conta já existe ou não? Se não for pedir muito claro.... Share this post Link to post Share on other sites
morfo2 4,680 Posted January 20, 2014 Isso já não me lembro, lamento. Share this post Link to post Share on other sites
xhadowzit 0 Posted January 20, 2014 tem algum erro mano, a pagina continua em branco :S Share this post Link to post Share on other sites
morfo2 4,680 Posted January 20, 2014 tem algum erro mano, a pagina continua em branco :SA lógica do código seria essa porque tens de restringir as variáveis que queres como obrigatórias, agora o código correcto para esse caso especifico de sql é que já não sei bem. Share this post Link to post Share on other sites
xhadowzit 0 Posted January 20, 2014 Olha aqui o codigo completo: <?php include('config.php'); if(isset($_POST['submit']) && $_POST['submit'] == 'Registrar') { $login = mysql_real_escape_string($_POST['login']); $password = mysql_real_escape_string($_POST['password']); $social_id = mysql_real_escape_string($_POST['social_id']); $real_name = mysql_real_escape_string($_POST['real_name']); $email = mysql_real_escape_string($_POST['email']); $sql = "INSERT INTO account SET login = '".$login."', password = PASSWORD('".$password."'), social_id = '".$social_id."', real_name = '".$real_name."', email = '".$email."'"; $result = mysql_query($sql); if($result, $login, $password, $social_id, $real_name, $email) { echo 'Conta criada com sucesso!'; } else { echo 'Por favor preencha todos os campos!'; } }?><!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'><html xmlns='http://www.w3.org/1999/xhtml'><head><title>Administração Horen2</title><meta http-equiv='content-type' content='text/html; charset=iso-8859-1' /><meta name='description' content='Registro' /><meta name='keywords' content='some, keywords, comes, later' /><meta name='language' content='en' /><meta name='robots' content='index,follow' /><meta name='revisit-After' content='5 days' /><meta name='distribution' content='local' /><style type='text/css'><!--body { padding:0px; margin:0px; background:url(http://4.bp.blogspot.com/-Sc9z5sOPynQ/T93ED-LmH2I/AAAAAAAAJGI/7h3QrCeQw9I/s1600/RV2.jpg) no-repeat #000000 scroll center top; font-family: Arial, Helvetica, sans-serif; font-size:20px; color:white;}p.first { margin:20px auto; color: blue; font:bold 30pt Arial; }p.second { color: blue; font:bold 20pt Impact; }#container { margin:60px auto; width:750px; overflow:hidden; }#text { padding:15px; }#text ul { padding:0px; margin-left:15px; }#text li { display:block; }#left { float:left; }#right { float:right; margin-right:15px; }!--></style><script type='text/javascript'>if (top.frames.length != 0) top.location=self.location;</script></head><center><p class='first'>Horen2</ p></center><body> <center> <div id='container'> <div id='text'> <form action='index.php' method='post'> <ul> <li>ID:</li> <li><input type='text' maxlength='16' name='login' size='70' /> <li> </li> <li>Password:</li> <li><input type='password' maxlength='16' name='password' size='70' /></li> <li> </li> <li>Password de Apagar Personagem:</li> <li><input type='text' maxlength='7' name='social_id' size='70' /></li> <li> </li> <li>Nome Real:</li> <li><input type='text' maxlength='30' name='real_name' size='70' /></li> <li> </li> <li>E-Mail:</li> <li><input type='text' maxlength='60' name='email' size='70' /></li> <li> </li> <li><input type='submit' name='submit' value='Registrar' /> | <input type="reset" name="limpar" value="Limpar" /></li> </ul> </form> </div> </div> </center></body><center><p class='second'>Horen2 - Todos os direitos reservados...</ p></center></html> Share this post Link to post Share on other sites
morfo2 4,680 Posted January 20, 2014 Podes meter no código html, type='required' em vez do type='text' ou então com class='required' Share this post Link to post Share on other sites
xhadowzit 0 Posted January 20, 2014 Tá na mesma ele regista a conta sem nada nos campos <?php include('config.php'); if(isset($_POST['submit']) && $_POST['submit'] == 'Registrar') { $login = mysql_real_escape_string($_POST['login']); $password = mysql_real_escape_string($_POST['password']); $social_id = mysql_real_escape_string($_POST['social_id']); $real_name = mysql_real_escape_string($_POST['real_name']); $email = mysql_real_escape_string($_POST['email']); $sql = "INSERT INTO account SET login = '".$login."', password = PASSWORD('".$password."'), social_id = '".$social_id."', real_name = '".$real_name."', email = '".$email."'"; $result = mysql_query($sql); if($result) { echo 'Conta criada com sucesso!'; } else { echo 'Por favor preencha todos os campos!'; } }?><!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'><html xmlns='http://www.w3.org/1999/xhtml'><head><title>Administração Horen2</title><meta http-equiv='content-type' content='text/html; charset=iso-8859-1' /><meta name='description' content='Registro' /><meta name='keywords' content='some, keywords, comes, later' /><meta name='language' content='en' /><meta name='robots' content='index,follow' /><meta name='author' content='S3cr3t' /><meta name='revisit-After' content='5 days' /><meta name='distribution' content='local' /><style type='text/css'><!--body { padding:0px; margin:0px; background:url(http://4.bp.blogspot.com/-Sc9z5sOPynQ/T93ED-LmH2I/AAAAAAAAJGI/7h3QrCeQw9I/s1600/RV2.jpg) no-repeat #000000 scroll center top; font-family: Arial, Helvetica, sans-serif; font-size:20px; color:white;}p.first { margin:20px auto; color: blue; font:bold 30pt Arial; }p.second { color: blue; font:bold 20pt Impact; }#container { margin:60px auto; width:750px; overflow:hidden; }#text { padding:15px; }#text ul { padding:0px; margin-left:15px; }#text li { display:block; }#left { float:left; }#right { float:right; margin-right:15px; }!--></style><script type='text/javascript'>if (top.frames.length != 0) top.location=self.location;</script></head><center><p class='first'>Horen2</ p></center><body> <center> <div id='container'> <div id='text'> <form action='index.php' method='post'> <ul> <li>ID:</li> <li><input type='text' class='required' maxlength='16' name='login' size='70' /> <li> </li> <li>Password:</li> <li><input type='password' class='required' maxlength='16' name='password' size='70' /></li> <li> </li> <li>Password de Apagar Personagem:</li> <li><input type='text' class='required' maxlength='7' name='social_id' size='70' /></li> <li> </li> <li>Nome Real:</li> <li><input type='text' class='required' maxlength='30' name='real_name' size='70' /></li> <li> </li> <li>E-Mail:</li> <li><input type='text' class='required' maxlength='60' name='email' size='70' /></li> <li> </li> <li><input type='submit' name='submit' value='Registrar' /> | <input type="reset" name="limpar" value="Limpar" /></li> </ul> </form> </div> </div> </center></body><center><p class='second'>Horen2 - Todos os direitos reservados...</ p></center></html> Share this post Link to post Share on other sites
Ƭiαgѳ ઽαทƬѳઽ 188 Posted January 21, 2014 Código completo com verificação: <?php include('config.php'); if(isset($_POST['submit']) && $_POST['submit'] == 'Registrar') { $login = mysql_real_escape_string($_POST['login']); $password = mysql_real_escape_string($_POST['password']); $social_id = mysql_real_escape_string($_POST['social_id']); $real_name = mysql_real_escape_string($_POST['real_name']); $email = mysql_real_escape_string($_POST['email']); $querySearchLogin = mysql_query("SELECT * FROM `account` WHERE (`account` = '".$login."')"); if(mysql_num_rows($querySearchLogin) > 0) { echo("Esta conta já existe."); } else { $sql = "INSERT INTO account SET login = '".$login."', password = PASSWORD('".$password."'), social_id = '".$social_id."', real_name = '".$real_name."', email = '".$email."'"; $result = mysql_query($sql); if($login, $password, $social_id, $real_name, $email) { echo 'Conta criada com sucesso!'; } else { echo 'Por favor preencha todos os campos!'; } } }?> 1 morfo2 reacted to this Share this post Link to post Share on other sites