Register code or script for 6607

[HeartlessBoiYang]

Can anyone help me with a register code or script. I need it for my website register page, but I can't seems to get it link to the database in mysql. Please help and thank you!

[pintinho12]

If you need help you'd better provide us some info on what you're getting trouble. Otherwise it seems like you want to pay someone to make it for you.

[CipherXS]

......

[denominator]

To be fair register page should be simple, there are plenty of examples online

[HeartlessBoiYang]

I have a php script but this doesn't seem to be working, it wont connect to mysql database.

 Spoiler

<?php
$conn = mysql_connect("localhost", "root", "password");
$db = mysql_select_db("database");

if(isset($_POST['submit']))
{
if(isset($_POST['username']) && $_POST['pass'] != "")
{
if($_POST['pass'] == $_POST['pass2'])
{
if(strlen($_POST['pass']) > 3 && strlen($_POST['pass']) < 32)
{
$sql = "INSERT INTO `accounts` (`Username`, `Password`) VALUES ('$username', '$pass')";
$sql = mysql_query($sql);
echo "Registered Successfully";
} else {
die("Your password must be between 3 and 32 characters.");
}
} else {
die("Your passwords do not match.");
}
} else {
die("Please enter in a password.");
}
}
?>

Originally Posted by pintinho12

If you need help you'd better provide us some info on what you're getting trouble. Otherwise it seems like you want to pay someone to make it for you.

[bashondegek]

Originally Posted by HeartlessBoiYang

I have a php script but this doesn't seem to be working, it wont connect to mysql database.

 Spoiler

<?php
$conn = mysql_connect("localhost", "root", "password");
$db = mysql_select_db("database");

if(isset($_POST['submit']))
{
if(isset($_POST['username']) && $_POST['pass'] != "")
{
if($_POST['pass'] == $_POST['pass2'])
{
if(strlen($_POST['pass']) > 3 && strlen($_POST['pass']) < 32)
{
$sql = "INSERT INTO `accounts` (`Username`, `Password`) VALUES ('$username', '$pass')";
$sql = mysql_query($sql);
echo "Registered Successfully";
} else {
die("Your password must be between 3 and 32 characters.");
}
} else {
die("Your passwords do not match.");
}
} else {
die("Please enter in a password.");
}
}
?>

Depends on the PHP version you are using.
MySQL is deprecated, so you should use MySQLi.

[HeartlessBoiYang]

I used Navicat version 8.2.13 enterprise

Originally Posted by bashondegek

Depends on the PHP version you are using.
MySQL is deprecated, so you should use MySQLi.

[bashondegek]

Originally Posted by HeartlessBoiYang

I used Navicat version 8.2.13 enterprise

You first need a webserver like XAMPP, WAMP or AppServ or something like that.

Navicat is just a database client.

So, set up a local webserver and then check the PHP version you've installed.
But still you will need to use MySQLi in your PHP instead of MySQL, since thats not supported anymore in the newer versions of PHP.

[HeartlessBoiYang]

Sorry to ask this dumb question but how do i download php and myqli version?
I do have appserv.

Originally Posted by bashondegek

You first need a webserver like XAMPP, WAMP or AppServ or something like that.

Navicat is just a database client.

So, set up a local webserver and then check the PHP version you've installed.
But still you will need to use MySQLi in your PHP instead of MySQL, since thats not supported anymore in the newer versions of PHP.

[Envy\Craft]

I agree with Turk.
If you can't even do this, which is just basic IT, not even programming, you are only wasting your time as well as anyone else who supports/helps you

[pintinho12]

Originally Posted by HeartlessBoiYang

Sorry to ask this dumb question but how do i download php and myqli version?
I do have appserv.

First you should stop using AppServ.

You can use Wamp which is less worse and you can choose if you're going to use it's own MariaDB or install it yourself (and disable Wampserver MariaDB).

With WampServer you'll find out a lot of insecure code already since it will not let your website run because of all obsolete could it must have.

Then you can write an wrapper for using mysqli or PDO for MySQL, both are good.

Or since you're clearly not good with PHP you can download a framework like Laravel that already have most things built-in.

[turk55]

Originally Posted by pintinho12

First you should stop using AppServ.

You can use Wamp which is less worse and you can choose if you're going to use it's own MariaDB or install it yourself (and disable Wampserver MariaDB).

With WampServer you'll find out a lot of insecure code already since it will not let your website run because of all obsolete could it must have.

Then you can write an wrapper for using mysqli or PDO for MySQL, both are good.

Or since you're clearly not good with PHP you can download a framework like Laravel that already have most things built-in.

You are asking him to use a complete framework while the person doesn't even know how to enable an extension.

[pintinho12]

Originally Posted by turk55

You are asking him to use a complete framework while the person doesn't even know how to enable an extension.

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

[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.

[denominator]

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