Register code or script for 6607

[HeartlessBoiYang]

It is cq but what I put here is just a sample.

Originally Posted by denominator

So the name of your database is database? Not cq, tq or something similar

[denominator]

Ahh okay, why not find another webpage and edit it?

[turk55]

Originally Posted by pintinho12

I bet he can read documentations, which will (must) be easier than setup a website from scratch.

He can also google how to use those functions but that is already too hard.

[bashondegek]

Originally Posted by HeartlessBoiYang

you got it wrong. I mean i got the website everything to work, but then for the register, I can't make it to connect to the database, like after click submit/create account. It wont go into the database, all it appear is username, password. it won't appear actual username and password that you filled in. That's why I'm asking if i did something wrong or code it wrong.

Then try to change this

 $sql = "INSERT INTO `accounts` (`Username`, `Password`) VALUES ('$username', '$pass')";

To

$sql = "INSERT INTO `accounts` (`Username`, `Password`) VALUES ('{$username}', '{$pass}')";

If its just adding plain text values into your database its definitely something with the values you insert in your database.

If this ain’t working, you will need to debug it, we really can’t help you any better then this, php documentations will definitely help you.

[HeartlessBoiYang]

Okay thanks i got it to work on the php side, but then now is a new question.
How do I create a form for HTML and linked it with php. like instead ofhave a new page wit no background on the php side, I want it to be able to just successful registered on the html side.

Also i know there has to be with something like

<form method="post" action='register.php'>
user:
pass:
email:
</form>

Originally Posted by HeartlessBoiYang

Okay thanks i got it to work on the php side, but then now is a new question.
How do I create a form for HTML and linked it with php. like instead ofhave a new page wit no background on the php side, I want it to be able to just successful registered on the html side.

my html file for register page:

 Spoiler

<script src="http://code.jquery.com/jquery-lastest.js"></script>
<script src="js/submit.js"></script>
<font size="5" color="#99cc33"><b>Create an Account </b></font>
<br />
<form id="myForm" method="post">
<br />
Username :<br />
<input name="account" type="text" class="input" id="account" value="" onclick="if (account.value == 'Account Name...') { account.value='' }" onfocus="account.id='focused'" onblur="account.id='unfocused'" style="margin-bottom: 7px;" maxlength="23"/>
<br />
Password :<br />
<input name="password" type="password" class="input" id="password" value="" onclick="if (password.value == 'Password...') { password.value='' }" onfocus="password.id='focused'" onblur="password.id='unfocused'" style="margin-bottom: 7px;" maxlength="23"/>
<br />
Re-type Password :<br />
<input name="passwordchk" type="password" class="input" id="passwordchk" value="" onclick="if (passwordchk.value == 'password...') { passwordchk.value='' }" onfocus="passwordchk.id='focused'" onblur="passwordchk.id='unfocused'" style="margin-bottom: 7px;" maxlength="23"/>
<br />
Email :<br />
<input name="email" type="text" class="input" id="email" value="" onclick="if (email.value == 'Email...') { email.value='' }" onfocus="email.id='focused'" onblur="email.id='unfocused'" style="margin-bottom: 7px;" maxlength="41"/>
<br />
Security Question :<br />
<select name="secquestion" class="input" id="secquestion" style="margin-bottom:7px;">
<option value="" selected="selected">-Select Secret Question-</option>
<option value="What is the first name of your favorite uncle?" >What is the first name of your favorite uncle?</option>
<option value="Where did you meet your spouse?" >Where did you meet your spouse?</option>
<option value="What is your oldest cousins name?" >What is your oldest cousins name?</option>
<option value="What is your youngest childs nickname?" >What is your youngest childs nickname?</option>
<option value="What is your oldest childs nickname?" >What is your oldest childs nickname?</option>
<option value="What is the first name of your oldest niece?" >What is the first name of your oldest niece?</option>
<option value="What is the first name of your oldest nephew?" >What is the first name of your oldest nephew?</option>
<option value="What is the first name of your favorite aunt?" >What is the first name of your favorite aunt?</option>
<option value="Where did you spend your honeymoon?" >Where did you spend your honeymoon?</option>
</select>
<br />
Answer :<br />
<input name="answer" type="text" class="input" id="answer" value="" onclick="if (answer.value == 'Answer...') { answer.value='' }" onfocus="answer.id='focused'" onblur="answer.id='unfocused'" style="margin-bottom: 7px;" maxlength="22"/>
<br />
<input name="register" type="submit" class="enter" id="register" onclick="action()" value="Submit" />
<script>
function action() {
//Your code here
}
</script>
</form>
<div id="result">
</div>

register php code:

 Spoiler

<?php
$hostname_localhost = "localhost";
$database_localhost = "cq";
$username_localhost = "root";
$password_localhost = "123456789";
$localhost = mysql_connect($hostname_localhost, $username_localhost, $password_localhost) or die("MYSQL Cannot Connect");
mysql_select_db($database_localhost) or die("Database doesnt exist");



function isValidEmail($value){
$pattern = "/^([a-zA-Z0-9])+([\.a-zA-Z0-9_-])*@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+/";
return preg_match($pattern, $value);
}
//error_reporting(0);
if(isset($_POST['register']))
{
$acc = mysql_escape_string($_POST['account']);
$pass = mysql_escape_string($_POST['password']);
$passchk = mysql_escape_string($_POST['passwordchk']);
$answer = mysql_escape_string($_POST['answer']);

if(!empty($acc) && !empty($pass) && !empty($_POST['email']) && !empty($_POST['secquestion']) && !empty($answer))
{
if(strlen($acc) < 23 && strlen($acc) > 3 && strlen($pass) < 23 && strlen($pass) > 3 && $pass == $passchk)
{
if(isValidEmail($_POST['email']) && strlen($_POST['email']) < 41)
{
if(strlen($answer) < 22 && $_POST['secquestion'] != '')
{
$check = mysql_query("SELECT * FROM accounts WHERE username = '".$acc."' ") or die("MYSQL Select From Accounts Error");
$rows = mysql_num_rows($check);
if($rows == 0)
{
mysql_query("INSERT INTO accounts (Username, Password, Email, question, answer) VALUES ('".$acc."', '".$pass."', '".$_POST['email']."', '".$_POST['secquestion']."', '".$answer."')");
echo("<br /><center>Username <i>'".$acc."'</i> successfully created</center>");
}
else
{
die("<br /><center>Username <i>'".$acc."'</i> is already registered, please use another name.</center>");
}
}
else
{
die("<br /><center>The answer provided for the question was to long, please try again.</center>");
}
}
else
{
die("<br /><center>Email Address is either to long, or not setup right, please try again.</center>");
}
}
else
{
die("<br /><center>You're Lengths for Username and or Password is to long/short, or failed to pass password check</center>");
}
}
else
{
die("<br /><center>One or more fields missing, please try again.</center>");
}
}
mysql_close($localhost);
?>

and my .ja file, trying to make the submit form without redirect to a new tab(white page said Successfully registered!)

 Spoiler

<script>
$(document).ready(function () {
$('.register').click(function (e) {
e.preventDefault();
var account = $('#account').val();
var password = $('#password').val();
var email = $('#email').val();
var secquestion = $('#secquestion').val();
var answer = $('#answer').val();
({
type: "GET",
url: "register.php",
data: { "account": account, "password": password, "email": email, "secquestion": secquestion, "answer": answer },
success: function (data) {
$('.result').html(data);
$('#myForm')[0].reset();
}
});
});
});
</script>

so please tell me if i did anything wrong here...

[bashondegek]

Originally Posted by HeartlessBoiYang

Okay thanks i got it to work on the php side, but then now is a new question.
How do I create a form for HTML and linked it with php. like instead ofhave a new page wit no background on the php side, I want it to be able to just successful registered on the html side.

Also i know there has to be with something like

<form method="post" action='register.php'>
user:
pass:
email:
</form>



my html file for register page:

 Spoiler

<script src="http://code.jquery.com/jquery-lastest.js"></script>
<script src="js/submit.js"></script>
<font size="5" color="#99cc33"><b>Create an Account </b></font>
<br />
<form id="myForm" method="post">
<br />
Username :<br />
<input name="account" type="text" class="input" id="account" value="" onclick="if (account.value == 'Account Name...') { account.value='' }" onfocus="account.id='focused'" onblur="account.id='unfocused'" style="margin-bottom: 7px;" maxlength="23"/>
<br />
Password :<br />
<input name="password" type="password" class="input" id="password" value="" onclick="if (password.value == 'Password...') { password.value='' }" onfocus="password.id='focused'" onblur="password.id='unfocused'" style="margin-bottom: 7px;" maxlength="23"/>
<br />
Re-type Password :<br />
<input name="passwordchk" type="password" class="input" id="passwordchk" value="" onclick="if (passwordchk.value == 'password...') { passwordchk.value='' }" onfocus="passwordchk.id='focused'" onblur="passwordchk.id='unfocused'" style="margin-bottom: 7px;" maxlength="23"/>
<br />
Email :<br />
<input name="email" type="text" class="input" id="email" value="" onclick="if (email.value == 'Email...') { email.value='' }" onfocus="email.id='focused'" onblur="email.id='unfocused'" style="margin-bottom: 7px;" maxlength="41"/>
<br />
Security Question :<br />
<select name="secquestion" class="input" id="secquestion" style="margin-bottom:7px;">
<option value="" selected="selected">-Select Secret Question-</option>
<option value="What is the first name of your favorite uncle?" >What is the first name of your favorite uncle?</option>
<option value="Where did you meet your spouse?" >Where did you meet your spouse?</option>
<option value="What is your oldest cousins name?" >What is your oldest cousins name?</option>
<option value="What is your youngest childs nickname?" >What is your youngest childs nickname?</option>
<option value="What is your oldest childs nickname?" >What is your oldest childs nickname?</option>
<option value="What is the first name of your oldest niece?" >What is the first name of your oldest niece?</option>
<option value="What is the first name of your oldest nephew?" >What is the first name of your oldest nephew?</option>
<option value="What is the first name of your favorite aunt?" >What is the first name of your favorite aunt?</option>
<option value="Where did you spend your honeymoon?" >Where did you spend your honeymoon?</option>
</select>
<br />
Answer :<br />
<input name="answer" type="text" class="input" id="answer" value="" onclick="if (answer.value == 'Answer...') { answer.value='' }" onfocus="answer.id='focused'" onblur="answer.id='unfocused'" style="margin-bottom: 7px;" maxlength="22"/>
<br />
<input name="register" type="submit" class="enter" id="register" onclick="action()" value="Submit" />
<script>
function action() {
//Your code here
}
</script>
</form>
<div id="result">
</div>

register php code:

 Spoiler

<?php
$hostname_localhost = "localhost";
$database_localhost = "cq";
$username_localhost = "root";
$password_localhost = "123456789";
$localhost = mysql_connect($hostname_localhost, $username_localhost, $password_localhost) or die("MYSQL Cannot Connect");
mysql_select_db($database_localhost) or die("Database doesnt exist");



function isValidEmail($value){
$pattern = "/^([a-zA-Z0-9])+([\.a-zA-Z0-9_-])*@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+/";
return preg_match($pattern, $value);
}
//error_reporting(0);
if(isset($_POST['register']))
{
$acc = mysql_escape_string($_POST['account']);
$pass = mysql_escape_string($_POST['password']);
$passchk = mysql_escape_string($_POST['passwordchk']);
$answer = mysql_escape_string($_POST['answer']);

if(!empty($acc) && !empty($pass) && !empty($_POST['email']) && !empty($_POST['secquestion']) && !empty($answer))
{
if(strlen($acc) < 23 && strlen($acc) > 3 && strlen($pass) < 23 && strlen($pass) > 3 && $pass == $passchk)
{
if(isValidEmail($_POST['email']) && strlen($_POST['email']) < 41)
{
if(strlen($answer) < 22 && $_POST['secquestion'] != '')
{
$check = mysql_query("SELECT * FROM accounts WHERE username = '".$acc."' ") or die("MYSQL Select From Accounts Error");
$rows = mysql_num_rows($check);
if($rows == 0)
{
mysql_query("INSERT INTO accounts (Username, Password, Email, question, answer) VALUES ('".$acc."', '".$pass."', '".$_POST['email']."', '".$_POST['secquestion']."', '".$answer."')");
echo("<br /><center>Username <i>'".$acc."'</i> successfully created</center>");
}
else
{
die("<br /><center>Username <i>'".$acc."'</i> is already registered, please use another name.</center>");
}
}
else
{
die("<br /><center>The answer provided for the question was to long, please try again.</center>");
}
}
else
{
die("<br /><center>Email Address is either to long, or not setup right, please try again.</center>");
}
}
else
{
die("<br /><center>You're Lengths for Username and or Password is to long/short, or failed to pass password check</center>");
}
}
else
{
die("<br /><center>One or more fields missing, please try again.</center>");
}
}
mysql_close($localhost);
?>

and my .ja file, trying to make the submit form without redirect to a new tab(white page said Successfully registered!)

 Spoiler

<script>
$(document).ready(function () {
$('.register').click(function (e) {
e.preventDefault();
var account = $('#account').val();
var password = $('#password').val();
var email = $('#email').val();
var secquestion = $('#secquestion').val();
var answer = $('#answer').val();
({
type: "GET",
url: "register.php",
data: { "account": account, "password": password, "email": email, "secquestion": secquestion, "answer": answer },
success: function (data) {
$('.result').html(data);
$('#myForm')[0].reset();
}
});
});
});
</script>

so please tell me if i did anything wrong here...

Seems like you are using Ajax there.
So you won't have to use the action="blabla.php" in your form.

you just have to catch the button click in your JS and let it go through the ajax file.

Use your browser built in inspector got to console and check what errors there are.



give your button a class or id or something.
so for example;

<button id="btnRegister">register now</button>

And in your JS do something like;

$("#btnRegister").on("click", function(){
 // code of ajax
});

[pintinho12]

Originally Posted by HeartlessBoiYang

Okay thanks i got it to work on the php side, but then now is a new question.
How do I create a form for HTML and linked it with php. like instead ofhave a new page wit no background on the php side, I want it to be able to just successful registered on the html side.

Also i know there has to be with something like

<form method="post" action='register.php'>
user:
pass:
email:
</form>

my html file for register page:

 Spoiler

<script src="http://code.jquery.com/jquery-lastest.js"></script>
<script src="js/submit.js"></script>
<font size="5" color="#99cc33"><b>Create an Account </b></font>
<br />
<form id="myForm" method="post">
<br />
Username :<br />
<input name="account" type="text" class="input" id="account" value="" onclick="if (account.value == 'Account Name...') { account.value='' }" onfocus="account.id='focused'" onblur="account.id='unfocused'" style="margin-bottom: 7px;" maxlength="23"/>
<br />
Password :<br />
<input name="password" type="password" class="input" id="password" value="" onclick="if (password.value == 'Password...') { password.value='' }" onfocus="password.id='focused'" onblur="password.id='unfocused'" style="margin-bottom: 7px;" maxlength="23"/>
<br />
Re-type Password :<br />
<input name="passwordchk" type="password" class="input" id="passwordchk" value="" onclick="if (passwordchk.value == 'password...') { passwordchk.value='' }" onfocus="passwordchk.id='focused'" onblur="passwordchk.id='unfocused'" style="margin-bottom: 7px;" maxlength="23"/>
<br />
Email :<br />
<input name="email" type="text" class="input" id="email" value="" onclick="if (email.value == 'Email...') { email.value='' }" onfocus="email.id='focused'" onblur="email.id='unfocused'" style="margin-bottom: 7px;" maxlength="41"/>
<br />
Security Question :<br />
<select name="secquestion" class="input" id="secquestion" style="margin-bottom:7px;">
<option value="" selected="selected">-Select Secret Question-</option>
<option value="What is the first name of your favorite uncle?" >What is the first name of your favorite uncle?</option>
<option value="Where did you meet your spouse?" >Where did you meet your spouse?</option>
<option value="What is your oldest cousins name?" >What is your oldest cousins name?</option>
<option value="What is your youngest childs nickname?" >What is your youngest childs nickname?</option>
<option value="What is your oldest childs nickname?" >What is your oldest childs nickname?</option>
<option value="What is the first name of your oldest niece?" >What is the first name of your oldest niece?</option>
<option value="What is the first name of your oldest nephew?" >What is the first name of your oldest nephew?</option>
<option value="What is the first name of your favorite aunt?" >What is the first name of your favorite aunt?</option>
<option value="Where did you spend your honeymoon?" >Where did you spend your honeymoon?</option>
</select>
<br />
Answer :<br />
<input name="answer" type="text" class="input" id="answer" value="" onclick="if (answer.value == 'Answer...') { answer.value='' }" onfocus="answer.id='focused'" onblur="answer.id='unfocused'" style="margin-bottom: 7px;" maxlength="22"/>
<br />
<input name="register" type="submit" class="enter" id="register" onclick="action()" value="Submit" />
<script>
function action() {
//Your code here
}
</script>
</form>
<div id="result">
</div>

register php code:

 Spoiler

<?php
$hostname_localhost = "localhost";
$database_localhost = "cq";
$username_localhost = "root";
$password_localhost = "123456789";
$localhost = mysql_connect($hostname_localhost, $username_localhost, $password_localhost) or die("MYSQL Cannot Connect");
mysql_select_db($database_localhost) or die("Database doesnt exist");



function isValidEmail($value){
$pattern = "/^([a-zA-Z0-9])+([\.a-zA-Z0-9_-])*@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+/";
return preg_match($pattern, $value);
}
//error_reporting(0);
if(isset($_POST['register']))
{
$acc = mysql_escape_string($_POST['account']);
$pass = mysql_escape_string($_POST['password']);
$passchk = mysql_escape_string($_POST['passwordchk']);
$answer = mysql_escape_string($_POST['answer']);

if(!empty($acc) && !empty($pass) && !empty($_POST['email']) && !empty($_POST['secquestion']) && !empty($answer))
{
if(strlen($acc) < 23 && strlen($acc) > 3 && strlen($pass) < 23 && strlen($pass) > 3 && $pass == $passchk)
{
if(isValidEmail($_POST['email']) && strlen($_POST['email']) < 41)
{
if(strlen($answer) < 22 && $_POST['secquestion'] != '')
{
$check = mysql_query("SELECT * FROM accounts WHERE username = '".$acc."' ") or die("MYSQL Select From Accounts Error");
$rows = mysql_num_rows($check);
if($rows == 0)
{
mysql_query("INSERT INTO accounts (Username, Password, Email, question, answer) VALUES ('".$acc."', '".$pass."', '".$_POST['email']."', '".$_POST['secquestion']."', '".$answer."')");
echo("<br /><center>Username <i>'".$acc."'</i> successfully created</center>");
}
else
{
die("<br /><center>Username <i>'".$acc."'</i> is already registered, please use another name.</center>");
}
}
else
{
die("<br /><center>The answer provided for the question was to long, please try again.</center>");
}
}
else
{
die("<br /><center>Email Address is either to long, or not setup right, please try again.</center>");
}
}
else
{
die("<br /><center>You're Lengths for Username and or Password is to long/short, or failed to pass password check</center>");
}
}
else
{
die("<br /><center>One or more fields missing, please try again.</center>");
}
}
mysql_close($localhost);
?>

and my .ja file, trying to make the submit form without redirect to a new tab(white page said Successfully registered!)

 Spoiler

<script>
$(document).ready(function () {
$('.register').click(function (e) {
e.preventDefault();
var account = $('#account').val();
var password = $('#password').val();
var email = $('#email').val();
var secquestion = $('#secquestion').val();
var answer = $('#answer').val();
({
type: "GET",
url: "register.php",
data: { "account": account, "password": password, "email": email, "secquestion": secquestion, "answer": answer },
success: function (data) {
$('.result').html(data);
$('#myForm')[0].reset();
}
});
});
});
</script>

so please tell me if i did anything wrong here...

Dude, trust me. You're sharing vulnerable code that you want to use on production. Learn how to use mysqli and prepared statements so at least lammers wont mysql inject your website.

[turk55]

Originally Posted by bashondegek

Seems like you are using Ajax there.
So you won't have to use the action="blabla.php" in your form.

You can, I personally do. That way I don't have URLs hardcoded in my scripts (if it's not a SPA app).

Originally Posted by bashondegek

give your button a class or id or something.
so for example;

<button id="btnRegister">register now</button>

And in your JS do something like;

$("#btnRegister").on("click", function(){
 // code of ajax
});

I would personally add the submit on the form.

document.querySelector("#registerForm").addEventListener('submit', (e) =>{
  e.preventDefault();
  const submitUrl = e.currentTarget.getAttribute("action");
 // AJAX postcall here
});

This way you can re-use your JS without having to have it specific.

[bashondegek]

Originally Posted by turk55

You can, I personally do. That way I don't have URLs hardcoded in my scripts (if it's not a SPA app).



I would personally add the submit on the form.

document.querySelector("#registerForm").addEventListener('submit', (e) =>{
  e.preventDefault();
  const submitUrl = e.currentTarget.getAttribute("action");
 // AJAX postcall here
});

This way you can re-use your JS without having to have it specific.

Sure i won’t even do it like this myself since i’m using frameworks, most of it is already built in and its a fast way to set up secure websites if you know how it works..

Anyway i guess thats a bit to hard for him as he is not even able to make this basic register form working 😅. Just trying to help him out a little bit instead of making it harder for him to understand.

[HeartlessBoiYang]

Well yeah, but I did make it work, just that it pop up a new window with no background etc. So now I need it to just stay in the same page. Hopefully u get what I mean. And yes, im still learning, better than not learning xD

Originally Posted by bashondegek

Sure i won’t even do it like this myself since i’m using frameworks, most of it is already built in and its a fast way to set up secure websites if you know how it works..

Anyway i guess thats a bit to hard for him as he is not even able to make this basic register form working 😅. Just trying to help him out a little bit instead of making it harder for him to understand.

[bashondegek]

Originally Posted by HeartlessBoiYang

Well yeah, but I did make it work, just that it pop up a new window with no background etc. So now I need it to just stay in the same page. Hopefully u get what I mean. And yes, im still learning, better than not learning xD

I understand that, but what Turk and Pitinho are saying is true.
The code that i shared i just basic, it will work, but there are really better ways.

Anyway, it can stay in the same page using Ajax.

If you use the Code turk shared and put that in your JS, and change your button to something like this;

<button type="submit">Register now</button>

you are already doing a bit better.

Do you have any other problems? Or did you make it to work?

[pintinho12]

crappy but not so much

[turk55]

Originally Posted by pintinho12

crappy but not so much

+

[HeartlessBoiYang]

Thanks so much for helping me everyone, very appreciates. Sorry for being a noob(which I am, lol) and an idiots who know nothing but trying hardest to learn xD. I figured I just need to change from .html to .php, since in some way my website work either .html or .php .