23 replies to this topic

[1vannn]

"An error has occured".

[remiX]

Your database needs to have these columns:
id - auto_increment, primary, integer
username - text
password - text

What headings does it have at the moment?

[1vannn]

Oh, that might be a reason why it didn't work. Give me a second to update the database.
Edit: It works! Thanks so much Remix!

[Appleeater]

remiX, on 17 May 2013 - 12:31 AM, said:

Never knew you could do that on webhost /> haha

Registration uses the insert query.
Note: You will need to add some anti-spam method to prevent spam of multiple users being created

LUA:

Spoiler

-- Variables
local server, username, password = "serveraddress.com"

term.clear()
term.setCursorPos(1,1)

write( "Username: ")
username = read()
write( "Password: ")
password = read()

local response = http.post(server, "user=" .. username, "&pass="password)
local content = response.readAll()
response.close()

print(content)

PHP:

Spoiler

<?php
	$sql = array();
	$sql['host'] = '';
	$sql['username'] = '';
	$sql['password'] = '';
	$sql['database'] = '';
	$sql['table'] = '';
	
	if (isset($_POST['user']) & isset($_POST['pass'])) {
		$user = $_POST['user']; // Put the user's variable into a php variable
		$pass = $_POST['pass'];
						$con = mysql_connect($sql['host'],$sql['username'],$sql['password']); // Establish the MYSQL connection
		mysql_select_db($sql['database'], $con); // Select the database
		
		// Create a query to see if the user is already in use
			// the * is so that it selects all column variables
		$query = "select * from ".$sql['table']." where username='$user'";
		$result = mysql_query($query, $con);
		if (!$result || mysql_num_rows($result) == 0) {
			echo 'User already exists.';
			return;
		}
		
		// User does not exist, lets add them
		$query = "insert into ".$sql['table']."(id,username,password) values('','$user','$pass')";
		$result = mysql_query($query, $con);
		echo !$result ? "An error has occured" : "Registered!"; // Ternary operator :P/>/>
	} else {
		// Accessed on a browser or wrong CC information
		echo '<h3>Invalid Access!</h3>';
	}
?>

Shout if there are any errors

Mind if I use this with some of my programs?