DaniWeb Forum Index > Web Development > PHP

A little problem with a script

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

Last »

•

Join Date: Jan 2008

Posts: 23

Reputation: tedobg is an unknown quantity at this point

Solved Threads: 0

tedobg

Offline

Newbie Poster

A little problem with a script

Mar 9th, 2008

Hi guys.I am new to web development and of course I have been experiensing some problems.Most of them are easy to solve and I usually find my way, but there is some thing that is getting on my nerves for some time now.

I have been trying to make a simple script for registering a user via MySQL.No filtering input, no validating only the part that adds the new user into the MySQL table. But it doesn't work.I have checked my code a couple of times and i can't see the problem.Here it is:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
if(isset($_POST["name"]) && isset($_POST["pass"]) && isset($_POST["email"]))
{
$name=$_POST["name"];
$pass=$_POST["pass"];
$email=$_POST["email"];
$con=mysql_connect('localhost','root','password');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("users", $con);
mysql_query("INSERT INTO members (username,password,email) values ('$name','$pass','$email')") or die('Error');
}
?>
<?php
if(isset($_POST["name"]) && isset($_POST["pass"]) && isset($_POST["email"]))
{
$name=$_POST["name"];
$pass=$_POST["pass"];
$email=$_POST["email"];
$con=mysql_connect('localhost','root','password');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("users", $con);
mysql_query("INSERT INTO members (username,password,email) values ('$name','$pass','$email')") or die('Error');
}
?>

•

Join Date: Jun 2007

Posts: 1,227

Reputation: kkeith29 has a spectacular aura about

Solved Threads: 167

kkeith29

Offline

Nearly a Posting Virtuoso

Re: A little problem with a script

Mar 9th, 2008

try this:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
if(isset($_POST["name"]) && isset($_POST["pass"]) && isset($_POST["email"]))
{
$name=$_POST["name"];
$pass=$_POST["pass"];
$email=$_POST["email"];
$con=mysql_connect('localhost','root','password');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("users", $con);
$sql = "INSERT INTO `members` (username,password,email) VALUES ('" . $name . "','" . $pass . "','" . $email . "')";
$query = mysql_query($sql,$con) or die('Error: ' . mysql_error());
}
?>
<?php
if(isset($_POST["name"]) && isset($_POST["pass"]) && isset($_POST["email"]))
{
$name=$_POST["name"];
$pass=$_POST["pass"];
$email=$_POST["email"];
$con=mysql_connect('localhost','root','password');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("users", $con);
$sql = "INSERT INTO `members` (username,password,email) VALUES ('" . $name . "','" . $pass . "','" . $email . "')";
$query = mysql_query($sql,$con) or die('Error: ' . mysql_error());
}
?>

if this script doesn't fix the problem, post the mysql error message and i will help you from there.

•

Join Date: Jan 2008

Posts: 23

Reputation: tedobg is an unknown quantity at this point

Solved Threads: 0

tedobg

Offline

Newbie Poster

Re: A little problem with a script

Mar 9th, 2008

Hey.Thanks for the quick reply there mate.I am sorry you didn't get the same from me but I was unable to reply sooner.Unfortunatelly the problem remains.The worst part is that a SQL error doesn't even appear.All I get after clicking on "submit" is my page reloading blank. . .

•

Join Date: Jun 2007

Posts: 1,227

Reputation: kkeith29 has a spectacular aura about

Solved Threads: 167

kkeith29

Offline

Nearly a Posting Virtuoso

Re: A little problem with a script

Mar 9th, 2008

post the rest of your code so i can see if there is a problem there.

•

Join Date: Jan 2008

Posts: 23

Reputation: tedobg is an unknown quantity at this point

Solved Threads: 0

tedobg

Offline

Newbie Poster

Re: A little problem with a script

Mar 9th, 2008

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
if(isset($_POST["name"]) && isset($_POST["pass"]) && isset($_POST["email"]))
{
$name=$_POST["name"];
$pass=$_POST["pass"];
$email=$_POST["email"];
$con=mysql_connect('localhost','root','password');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("users", $con);
$sql = "INSERT INTO `members` (username,password,email) VALUES ('" . $name . "','" . $pass . "','" . $email . "')";
$query = mysql_query($sql,$con) or die('Error: ' . mysql_error());
}
?>
 
<html>
<body>
<form action="register.php" method="post">
Username: <input type="text" name="name" /></br>
Password: <input type="password" name="pass" /></br>
Email: <input type="text" name="email" width=40 /></br>
<input type="submit" />
</form>
</body>
</html>
<?php
if(isset($_POST["name"]) && isset($_POST["pass"]) && isset($_POST["email"]))
{
$name=$_POST["name"];
$pass=$_POST["pass"];
$email=$_POST["email"];
$con=mysql_connect('localhost','root','password');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("users", $con);
$sql = "INSERT INTO `members` (username,password,email) VALUES ('" . $name . "','" . $pass . "','" . $email . "')";
$query = mysql_query($sql,$con) or die('Error: ' . mysql_error());
}
?>

<html>
<body>
<form action="register.php" method="post">
Username: <input type="text" name="name" /></br>
Password: <input type="password" name="pass" /></br>
Email: <input type="text" name="email" width=40 /></br>
<input type="submit" />
</form>
</body>
</html>

OK.Here it is mate... My code with your corections.I would really appreciate if u find a solution.I have been trying for a few days now.

•

Join Date: Aug 2007

Posts: 561

Reputation: ryan_vietnow is an unknown quantity at this point

Solved Threads: 71

ryan_vietnow ryan_vietnow is offline

Offline

Posting Pro

Re: A little problem with a script

Mar 9th, 2008

Is it inserting the data into the database.Of course,it will display blank because you have not triggered something to display if it is inserted correctly.try to replace this part:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$query = mysql_query($sql,$con) or die('Error: ' . mysql_error());
$query = mysql_query($sql,$con) or die('Error: ' . mysql_error());

with this:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$query = mysql_query($sql);
if  (!$query) 
{
echo 'Error: ' . mysql_error();
}
else
{
echo 'Inserted correctly.';
}
$query = mysql_query($sql);
if  (!$query) 
{
echo 'Error: ' . mysql_error();
}
else
{
echo 'Inserted correctly.';
}

http://www.ryantetek.com/

•

Join Date: Jan 2008

Posts: 23

Reputation: tedobg is an unknown quantity at this point

Solved Threads: 0

tedobg

Offline

Newbie Poster

Re: A little problem with a script

Mar 10th, 2008

Hey ryan. I am sorry to say that it didn't work.I Inserted the statements you proposed, but still I get a blank.No error, no nothing.Oh Isn't the page supposed to display the form again if the insert is correct,because the page is reloading?

•

Join Date: Aug 2007

Posts: 561

Reputation: ryan_vietnow is an unknown quantity at this point

Solved Threads: 71

ryan_vietnow ryan_vietnow is offline

Offline

Posting Pro

Re: A little problem with a script

Mar 10th, 2008

change this line:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
if(isset($_POST["name"]) && isset($_POST["pass"]) && isset($_POST["email"]))
if(isset($_POST["name"]) && isset($_POST["pass"]) && isset($_POST["email"]))

to this:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
if ($_POST['Submit'])
if ($_POST['Submit'])

then add a name in your form button

Help with Code Tags

php Syntax (Toggle Plain Text)

<input type="submit" name="Submit" />

See if that helps.

By the way,is this page the register.php page?

http://www.ryantetek.com/

•

Join Date: Jan 2008

Posts: 23

Reputation: tedobg is an unknown quantity at this point

Solved Threads: 0

tedobg

Offline

Newbie Poster

Re: A little problem with a script

Mar 10th, 2008

Still no work mate. Again blank page.And to you question... yes this is named register.php

By the way I am signing off for now going to school. Again any help is appresiated.

•

Join Date: Nov 2007

Posts: 3,738

Reputation: nav33n is a jewel in the rough

Solved Threads: 330

nav33n

Offline

Senior Poster

Re: A little problem with a script

#10

Mar 10th, 2008

Try this..

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
if(isset($_POST['submit'])){
	if(!empty($_POST["name"]) && !empty($_POST["pass"]) && !empty($_POST["email"]))
	{
		$name=$_POST["name"];
		$pass=$_POST["pass"];
		$email=$_POST["email"];
		$con=mysql_connect('localhost','root','password');
		if (!$con)
		{
			die('Could not connect: ' . mysql_error());
		}
		mysql_select_db("users");
		$sql = "INSERT INTO members (username,password,email) VALUES ('$name','$pass','$email')";
		$query = mysql_query($sql) or die('Error: ' . mysql_error());
		echo "Inserted successfully !";
	} else {
		echo "Fields can't be empty !";
	}
}
?>
<html>
<body>
<form action="register.php" method="post">
Username: <input type="text" name="name" /></br>
Password: <input type="password" name="pass" /></br>
Email: <input type="text" name="email" width=40 /></br>
<input type="submit" name="submit" value="submit" />
</form>
</body>
</html>
<?php
if(isset($_POST['submit'])){
	if(!empty($_POST["name"]) && !empty($_POST["pass"]) && !empty($_POST["email"]))
	{
		$name=$_POST["name"];
		$pass=$_POST["pass"];
		$email=$_POST["email"];
		$con=mysql_connect('localhost','root','password');
		if (!$con)
		{
			die('Could not connect: ' . mysql_error());
		}
		mysql_select_db("users");
		$sql = "INSERT INTO members (username,password,email) VALUES ('$name','$pass','$email')";
		$query = mysql_query($sql) or die('Error: ' . mysql_error());
		echo "Inserted successfully !";
	} else {
		echo "Fields can't be empty !";
	}
}
?>
<html>
<body>
<form action="register.php" method="post">
Username: <input type="text" name="name" /></br>
Password: <input type="password" name="pass" /></br>
Email: <input type="text" name="email" width=40 /></br>
<input type="submit" name="submit" value="submit" />
</form>
</body>
</html>