Member Avatar for dhruv_arora

I made two scripts register.php and register1.php, the register.php takes the values and register1.php process them and stores them into a mysql database.

after i fill in the form and press submit, I get an error. I am using mySQL 5.5.8

Register.php

<?php
include("header.html");
include("nav.html");
include("sidebars.html");
?>
<html>
<form action="register1.php" method="post">
<fieldset>
<legend>Form 1</legend>
First Name : <input type="text" name="fname"><br><br>
Last Name  : <input type="text" name="lname"><br><br>
Email      : <input type="text" name="email"><br><br>
Password   : <input type="password" name="pass1"><br><br>
Re-enter pass : <input type="password" name="pass2"><br><br>
<input type="submit" name="submit" value="Register Now">
<input type="hidden" name="submitted" value="TRUE">
</fieldset>
</form>
</html>
<?php
include("footer.html");
?>

Register1.php

<?php
include("header.html");
include("nav.html");
include("sidebars.html");
?>
<?php
$errors=array();
if(isset($_POST['submitted'])){
	if(empty($_POST['fname'])){
		$errors[]="You forgot to enter first name";
	}
	   else{
		   $fn=$_POST['fname'];
	   }
	if(empty($_POST['lname'])){
		$errors[]="You forgot to enter last name";
	}
	   else{
		   $ln=$_POST['lname'];
	   }
	if(empty($_POST['email'])){
		$errors[]="You forgot to enter email";
	}
	  else{
		  $email=$_POST['email'];
	  }
if(!empty($_POST['pass1']))
{
	if(($_POST['pass1'])==($_POST['pass2']))
	{
		$pass=$_POST['pass1'];
	}
	   else
	   {
		   $errors[]="The two passwords do not match";
	   }
}
else
{
	$errors[]="You forgot to enter a password";
}
}
$r="";
if(empty($errors)){
	require_once("connect.php");
	$q='INSERT INTO users VALUES (3,"user3",SHA1("pass"),"$fn","$ln","$email")';
	$r=mysql_query($q,$dbc);
}
if($r){
	echo "You are now a registered user";
}
else{
	echo "You could not be registered beacuse :-"."<br>";
	foreach($errors as $msg){
		echo $msg."<br>";
	}
}
?>
<?php
include("footer.html");
?>

connect.php

<?php
{
	DEFINE ("DB_USER","");
	DEFINE ("DB_PASSWORD","");
	DEFINE ("DB_HOST","localhost");
	DEFINE ("DB_NAME","forums");
	$dbc=mysql_connect(DB_HOST,DB_NAME) OR die("Could not connect to mySQL");
}

?>
  • 5 Contributors
  • 11 Replies
  • 185 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by dhruv_arora
Member Avatar for MrDJK 
$q = 'INSERT INTO `users` VALUES (3, "user3", SHA1("pass"), "'.mysql_real_escape_string($fn).'", "'.mysql_real_escape_string($ln).'", "'.mysql_real_escape_string($email).'")';

Remember to concatenate variables, within single-quote strings.
Also what's the error you recieved?

Edited by MrDJK because: n/a
Member Avatar for karthik_ppts

post the error message that you have received in the output screen.

Member Avatar for rajdevsohail

use The Following Code from line 44 to line 48

if(empty($errors)){
$query="INSERT INTO users VALUES (3,'user3',SHA1('pass'),'$fn','$ln','$email')";
$result=mysql_query($query,$dbc);
}

and use the following line at the starting of the page (after any session) :

require_once("connect.php");
Edited by rajdevsohail because: syntax errors in the code .
Member Avatar for dhruv_arora

I tried everything you said above but no luck, it's not giving an error but it says Could not register the user which means the the var $result (for the mysql query) has been false which means it failed to execute the mysql query.

Member Avatar for pritaeas

DEFINE needs to be define While testing, run your queries like this:

$result = mysql_query($query, $dbc) or die(mysql_error());
Member Avatar for dhruv_arora

DEFINE needs to be define While testing, run your queries like this:

$result = mysql_query($query, $dbc) or die(mysql_error());

Thanks, I did what you said and now I am getting this error :-

No database selected

In my connect.php file I have mentioned forums, I am using XAMPP server and I created a forums database in phpMyAdmin.

This is my connect.php file :-

<?php
{
	define ("DB_USER","");
	define ("DB_PASSWORD","");
	define ("DB_HOST","localhost");
	define ("DB_NAME","forums");
	$dbc=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME) or die("Could not connect to mySQL");
}

?>
Member Avatar for MrDJK 
$dbc = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die('Could not connect');
mysql_select_db(DB_NAME, $dbc) or die('Cannot use database');
Member Avatar for dhruv_arora 
$dbc = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die('Could not connect');
mysql_select_db(DB_NAME, $dbc) or die('Cannot use database');

This worked but now it's saying that "Cannot use database"

Member Avatar for pritaeas 
mysql_select_db(DB_NAME, $dbc) or die(mysql_error());

Chances are your database is misspelled or your user does not have access rights.

Edited by pritaeas because: n/a
Member Avatar for dhruv_arora 
mysql_select_db(DB_NAME, $dbc) or die(mysql_error());

Chances are your database is misspelled or your user does not have access rights.

I am using phpMyAdmin on my windows using XAMPP, how do I get the user and password, and I spelled the the database correctly.

Member Avatar for dhruv_arora

It worked now, the DB_USER was root and I didn't know that.

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.