A little problem with a script

Question

tedobg 0 Newbie Poster

16 Years Ago

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:

<?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

9 Contributors
35 Replies
245 Views
9 Months Discussion Span
Latest Post 15 Years Ago Latest Post by ashafaaiz

somedude3488 228 Nearly a Posting Virtuoso

16 Years Ago

try this:

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

somedude3488 228 Nearly a Posting Virtuoso

16 Years Ago

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

ryan_vietnow 13 Posting Pro

16 Years Ago

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:

$query = mysql_query($sql,$con) or die('Error: ' . mysql_error());

with this:

$query = mysql_query($sql);
if  (!$query) 
{
echo 'Error: ' . mysql_error();
}
else
{
echo 'Inserted correctly.';
}

ryan_vietnow 13 Posting Pro

16 Years Ago

change this line:

if(isset($_POST["name"]) && isset($_POST["pass"]) && isset($_POST["email"]))

to this:

if ($_POST['Submit'])

then add a name in your form button

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

See if that helps.

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

nav33n 472 Purple hazed!

16 Years Ago

Try this..

<?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>

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

tedobg 0 Newbie Poster · Answer 1 · 2008-03-10T00:50:34+00:00

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

tedobg 0 Newbie Poster · Answer 2 · 2008-03-10T01:58:09+00:00

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

tedobg 0 Newbie Poster · Answer 3 · 2008-03-10T12:07:17+00:00

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?

tedobg 0 Newbie Poster · Answer 4 · 2008-03-10T12:40:52+00:00

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.

tedobg 0 Newbie Poster · Answer 5 · 2008-03-10T23:31:18+00:00

Ok guys I am back. nav33n thanks for this man, but unfortunatelly It still doesnt work.The blank page remains and I am am getting no error messages at all. Something stops the scripts from executing but I have no idea what...

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 6 · 2008-03-11T10:29:24+00:00

Umm.. echo statements to check the flow of the code. Check if its entering the loops correctly. Check the form variable names. Put print_r($_POST); on top of the page to see if all the form variables are posted properly.

nonchalant 0 Newbie Poster · Answer 7 · 2008-03-11T10:54:50+00:00

hie

my fujitsu siemens amilo pro v3515 laptop with vista home basic has been displaying windows resuming when i switch it on ..been going on for 2 days...cannot get any of the keys to do anything...can anyone help?????.. thanx

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 8 · 2008-03-11T12:12:51+00:00

hie
my fujitsu siemens amilo pro v3515 laptop with vista home basic has been displaying windows resuming when i switch it on ..been going on for 2 days...cannot get any of the keys to do anything...can anyone help?????.. thanx

You need to post this question in hardware forum.

LeBurt 0 Light Poster · Answer 9 · 2008-03-11T14:18:14+00:00

Since it's the only place left with no error detection, how about trying:

if (!mysql_select_db("users", $con))
die ("Database 'users' not found");

tedobg 0 Newbie Poster · Answer 10 · 2008-03-12T01:18:30+00:00

Ok thanks to all your effort guys we have an improvement.I tried what nav33n said and I put echo statements everywhere. The flow of the code stops right after $con=mysql_connect('localhost','root','password'); . Ok so far so good. What now? Where might be the problem?

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 11 · 2008-03-12T01:22:23+00:00

hmm! instead of $con=mysql_connect('localhost','root','password'); give $con=mysql_connect('localhost','root','password') or die(mysql_error()); I dont think establishing the connection is the problem. If that was the problem, you would have got an error message while executing the script. Anyway, change the connection string line as above and try again !

LeBurt 0 Light Poster · Answer 12 · 2008-03-12T01:26:08+00:00

Try opening a command window and check if you can connect with the root user and 'password' as a password:

> mysql -u root -p
Enter password: password

(make sure the mysql command is in your path or else navigate where it is)

tedobg 0 Newbie Poster · Answer 13 · 2008-03-12T01:50:00+00:00

nav33n mate I tried with the die statement and there is no error but the code still stops after the attempt to connect. And LeBurt there is no problem connecting to mysql the way you said.
I have double checked everything I input but it still doesn't work.What could be the problem?

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 14 · 2008-03-12T01:58:04+00:00

Thats strange. Put the connection string as 1st line of your code. Is it entering all the other conditions ?

LeBurt 0 Light Poster · Answer 15 · 2008-03-12T02:26:56+00:00

I remember having connection problems when I started which I resolved by appending the mysql socket address to the host.

mysql_connect (host:socket, username, password)

I can't remember however if I got connection errors or not, but hey, it's worth the try. On my system:

$con = mysql_connect ('localhost:/var/mysql/mysql.sock', 'root', 'password');

Note that the location of the socket might be different on your system (I'm on OS X) but just locate the mysql.sock file and use the resulting path.

Designer_101 -2 Posting Whiz · Answer 16 · 2008-03-12T02:32:51+00:00

Hi

This works perfectly on my wampserver:

if(isset($_POST["name"]) && isset($_POST["pass"]) && isset($_POST["email"]))
{
$name=$_POST["name"];
$pass=$_POST["pass"];
$email=$_POST["email"];
$con=mysql_connect('localhost','user1','11424028');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("rand", $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 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>

The form action was redirecting the page before the mysql statement was sent,
So i simply just took it out :D

If this doesnt work, i would suggest going over your database and making sure the fields and table names are exactly right

anyway, hope the above works m8.

Reece

Designer_101 -2 Posting Whiz · Answer 17 · 2008-03-12T02:34:14+00:00

sorry ignore the red above its with my database details .... heres the version with yours .....

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

hope it helps
reece

tedobg 0 Newbie Poster · Answer 18 · 2008-03-12T02:43:26+00:00

The result when I put the connection line 1st in my script is a blank page. Not even the form is displayed. I though It might be my mistake mispelling something but unless I am turning blind everything looks well.LeBurt and Desiner_101 I will try your suggestions in a minute and see if something works..

By the way thanks for all the help guys

Designer_101 -2 Posting Whiz · Answer 19 · 2008-03-12T02:45:45+00:00

Designer_101 -2 Posting Whiz

16 Years Ago

oki
good luck

tedobg 0 Newbie Poster · Answer 20 · 2008-03-12T02:52:30+00:00

Designer_101 I tried what you said to see if it works.Well I dont know why but it doesn't. But when I read LeBurt's post I am striked by an idea. Is MySQL database supposed to be installed in the same directory as Apache Server or PHP. And if it is could that be causing the problem?And LeBurt If MySQL is in X:/Program Files/MySQL and my Apache is well X:/Program Files/Apache how do I select MySQL directory via localhost?

Designer_101 -2 Posting Whiz · Answer 21 · 2008-03-12T03:00:15+00:00

hi
I think now the problem isnt your code, perhaps like you said a direcory issue.

Theres a peice of free software called
Wampserver 2.0

i highly recomend it, it is
-apache
-php
-mySQL
-phpMyADMIN

all in one and is so much easier to use.

download it from here

http://www.wampserver.com/en/download.php

just
download
install
and start designing

hope this helps

LeBurt 0 Light Poster · Answer 22 · 2008-03-12T03:04:11+00:00

Actually, mysql is connect to PHP, not to Apache and no, they don't have to be in the same directory. The php.ini file on your system must have a line like this:

extension=mysql.so (or mysql.dll on windows)

(make you remove the semicolon to uncomment the line)

Otherwise, using the socket address should do it if there are still connection problems like on OS X...

tedobg 0 Newbie Poster · Answer 23 · 2008-03-12T03:08:06+00:00

So its a package instal and it instals everything without any hard to do properties and adjustments. Because once I tried to instal my admin and it was a nightmare. Anyway I will try it tomorrow.I am really tired today. Thanks a lot guys. After I try this tomorrow I will post to say if the problem remains.

Thanks again.

Designer_101 -2 Posting Whiz · Answer 24 · 2008-03-12T03:17:15+00:00

ok il pop on tomorow to see you.
Np
night night