Problem :( Annoying

[v2lethal]

ok basicly ive coded 2files do_reg.php & register.php

and ive created my database- created my table - added fields
and when i try submit on the register page nothing happens doesnt insert into DB
All info is below.hope one of you guys can solve this for me 🙂

Heres My Form: http://www.v2lethal.yourownweb.0lx.net/register.php

Heres My Table Below

CREATE TABLE `user` (
`id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(20) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
`ip` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Register.php

<?php
$IP = $_SERVER(REMOTE_ADDR);
?>



<form name=reg action=do_reg.php method=post>
<table border=0 cellspacing=0 cellpadding=2>
<tr><td>
Username <td><input type=text name=username><br>
<tr><td>
Password:<td> <input type=password name=password><br>
<tr><td>
Confirm:<td> <input type=password name=pass_conf><br>
<tr><td>
Email:<td> <input type=text name=email><br>
<tr><td colspan=2>
<input type=hidden name=ip value='<?php echo $IP ?>'>
<input type=submit value='Register'>
</form>
</table>

do_reg.php

<?php
$host = "localhost";
$dbuser = "0lx_2099266_user";
$dbpass= "pass";
$dbname = "0lx_2099266_user";

$connection =mysql_connect($host,$dbuser,$dbpass);

$db = mysql_select_db($dbname,$connection);

//grab data from form
$name = $_post(username);
$pass = $_post(password);
$pass_conf = $_post(pass_conf);
$email = $_post(email);
$ip = $_post(ip);


//if else (else if)
if($name == false || $pass == false || $pass_conf == false || $email == false){
echo "please fill in all the required fields";
}
if($pass != $pass_conf){
echo "Passwords do not match.";
}else {
$db = mysql_select_db($dbname,$connection);
$db = mysql_select_db($dbname,$connection);
$sql = "INSERT INTO user (username,pass,email,ip) VALUES ($name, $password, $email, $ip)";
$result = mysql_query($sql);
echo "";
};

?>  

[HalfaBee]

You have a few syntax errors.
$name = $post(username);
should be
$name = $POST['username'];

and the same for the other values.

Your sql has $password but you set $pass

You shouldn't put $_POST varaibles into sql without using mysql_real_escape_string()
Maybe some other things as well.

[v2lethal]

Updated the code. Still nothing. Erm.. Total Noob here. "obvious"

Little more help maybe?

<?php
$host = sql200.0lx.net
$dbuser = 0lx_2099266
$dbpass= 123456
$dbname = 0lx_2099266_user

$connection =mysql_connect($host,$dbuser,$dbpass);

$db = mysql_select_db($dbname,$connection);

//grab data from form
$username = mysql_real_escape_string($_post[username]);
$password = mysql_real_escape_string($_post[password]);
$pass_conf = mysql_real_escape_string($_post[pass_conf]);
$email = mysql_real_escape_string($_post[email]);
$ip = mysql_real_escape_string($_post[ip]);


//if else (else if)
if($username == false || $password == false || $pass_conf == false || $email == false){
echo "please fill in all the required fields";
}
if($password != $pass_conf){
echo "Passwords do not match.";
}else {
$db = mysql_select_db($dbname,$connection);
$db = mysql_select_db($dbname,$connection);
$sql = "INSERT INTO user (username, password, email, ip) VALUES ($username, $password, $email, $ip)";
$result = mysql_query($sql);
echo "Thank you For Joining";
};

?> 

[HalfaBee]

If things don't work you need to do some debugging.
$result = mysql_query($sql) or die( mysql_error() . "<br>SQL = $sql";

is a good start.

Odd that nothing is being echoed, are you sure you are changing do_reg.php?

[v2lethal]

Added the debug line you suggested

$sql = "INSERT INTO user (username, password, email, ip) VALUES ($username, $password, $email, $ip)";
$result = mysql_query($sql) or die( mysql_error() . "<br>SQL = $sql";
echo "Thank you For Joining";
};

And yes very funny how nothings being echoed. maybe its the server im on ?
Would be grateful if somebody could test on there Server/Hosting. To see if the files act different. maybe its the hosting.

[HalfaBee]

You should also indent your code to make it more readable.

do a print_r( $_POST ) at the start to see if it is being called.

<?php
$host = sql200 . 0lx . net$dbuser = 0lx_2099266$dbpass = 123456$dbname = 0lx_2099266_user$connection = mysql_connect( $host, $dbuser, $dbpass );
$db = mysql_select_db( $dbname, $connection );//grab data from form
$username = $_post[ username ];
$password = $_post[ password ];
$pass_conf = $_post[ pass_conf ];
$email = $_post[ email ];
$ip = $_post[ ip ];//if else (else if)
if( $username == false || $password == false || $pass_conf == false || $email == false )
{
	echo 'please fill in all the required fields';
// you probably need an exit() here
        exit();

}

if( $password != $pass_conf )
{
	echo 'Passwords do not match.';
}
else
{
	$db = mysql_select_db( $dbname, $connection );
	$db = mysql_select_db( $dbname, $connection );
	$sql = "INSERT INTO user (username, password, email, ip) VALUES ($username, $password, $email, $ip)";
	$result = mysql_query( $sql );
	echo 'Thank you For Joining';
}

;
?>

[v2lethal]

do you mean this code at the top of the file
if so ive added this and i still get blank page. mayb a bug in the php version?

<?php
print_r($_POST)
?>

[HalfaBee]

You added that to register.php, not do_reg.php

[v2lethal]

i added to both pages 🙂

<?php
print_r($_POST)
?>

<?php


$host = sql200.0lx.net
$dbuser = 0lx_2099266
$dbpass= 123456
$dbname = 0lx_2099266_user

$connection =mysql_connect($host,$dbuser,$dbpass);

$db = mysql_select_db($dbname,$connection);


//grab data from form
$username = mysql_real_escape_string($_post[username]);
$password = mysql_real_escape_string($_post[password]);
$pass_conf = mysql_real_escape_string($_post[pass_conf]);
$email = mysql_real_escape_string($_post[email]);
$ip = mysql_real_escape_string($_post[ip]);


//if else (else if)
if($username == false || $password == false || $pass_conf == false || $email == false){
echo "please fill in all the required fields";
}
if($password != $pass_conf){
echo "Passwords do not match.";
}else {
$db = mysql_select_db($dbname,$connection);
$db = mysql_select_db($dbname,$connection);
$sql = "INSERT INTO user (username, password, email, ip) VALUES ($username, $password, $email, $ip)";
$result = mysql_query($sql) or die( mysql_error() . "<br>SQL = $sql";
echo "Thank you For Joining";

};

?> 

[HalfaBee]

I can't explain why it is not showing, maybe you need to upload it as a different name to test it.

[v2lethal]

ive uploaded to a new host.and i get a output now

http://v2lethal.x10hosting.com/do_reg.php

a error but least it shows 🙂

its same code as before though humm

<?php
print_r($_POST)
?>

<?php


$host = "localhost";
$dbuser = "v2lethal_users";
$dbpass= "password";
$dbname = "v2lethal_user";

$connection =mysql_connect($host,$dbuser,$dbpass);

$db = mysql_select_db($dbname,$connection);


//grab data from form
$username = mysql_real_escape_string($_post[username]);
$password = mysql_real_escape_string($_post[password]);
$pass_conf = mysql_real_escape_string($_post[pass_conf]);
$email = mysql_real_escape_string($_post[email]);
$ip = mysql_real_escape_string($_post[ip]);


//if else (else if)
if($username == false || $password == false || $pass_conf == false || $email == false){
echo "please fill in all the required fields";
}
if($password != $pass_conf){
echo "Passwords do not match.";
}else {
$db = mysql_select_db($dbname,$connection);
$db = mysql_select_db($dbname,$connection);
$sql = "INSERT INTO user (username, password, email, ip) VALUES ($username, $password, $email, $ip)";
$result = mysql_query($sql) or die( mysql_error() . "<br>SQL = $sql";
echo "Thank you For Joining";

};

?> 

[HalfaBee]

Use $POST not $post

[v2lethal]

done that.still new at this.remembering things as i go 🙂

solved my last syntax error
sorry for noobness.still learning 🙂

[Yourownweb]

Hi im the owner of http://yourownweb.0lx.net i dont think is the server because vbulletin works pretty good and phpbb3.

if some1 finds out its the server let me know to see what can i do.

[illzz]

I noticed that sql200.0lx.net resolves to a private IP address (192.168.0.170)... You might want to make sure that PHP is successfully connecting to the DB.

You can try this...

$connection =mysql_connect($host,$dbuser,$dbpass);
if (!$connection) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';

$db = mysql_select_db($dbname,$connection);
if (!$db) {
    die('Could not select DB: ' . mysql_error());
}
echo 'Changed DB successfully';