Member Avatar for puvi

Hi,

i have a registration form, where the user enters username, email, designation and organisation. on clicking register button, the data in this form should get saved into database.

The code is as follows, when i executed it for the 1st time, data was saved properly, but when executed next time, the data is not getting stored in the database, but the username appears in the last echo statement. i am not able to figure out what is happening. can anyone help me in finding out where iam going wrong...

Thanks..

//passing the inputs from the form to php
$username = $_POST['username'];
$email =$_POST['email'];
$designation=$_POST['designation'];
$organisation=$_POST['organisation'];

//inserting into database table users
$sql = "INSERT INTO users values('','$username','$email','$designation','$organisation')";
$sqlres = mysql_query($sql);

echo (" data saved into database ".$username);
  • 3 Contributors
  • 7 Replies
  • 136 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by puvi
Member Avatar for puvi

by any chance do we need to use while loop..if so how??

Member Avatar for Dragonbaki

There is no wrong in the above code.. But if you post the actual form code with the above means, i can easily help you...

Member Avatar for puvi 
<?php
ini_set('error_reporting',E_ALL); 
ini_set('display_errors','Off'); 
ini_set('log_errors','Off'); 
?>

<html>
<head>
</head>
<body>
<?php
	if(!isset($_POST['register']))
	{
	?>

	<form method="post" name="myform" action="reg.php" onSubmit="return Validate(this);" />

	 <div style="position:absolute;left:250px;top:60px">
	<p>
	<table>
	<tr>
		<th colspan=2><b>Register</b></td>
	</tr>
	<tr>
		<td>User Name:</td><td> <input type="text" name="username" />*</td>
	</tr>
	
	<tr>
		<td>Email: </td><td><input type="text" name="email"/>*</td>
	</tr>
	<tr>
		<td>Confirm Email: </td><td><input type="text" name="cemail"/>*</td>
	</tr>
	<tr>
		<td>Designation: </td><td><input type="text" name="designation" />*</td>
	</tr>
	<tr>
		<td>Organisation: </td><td><input type="text" name="organisation" /></td>
	</tr>
</table>
	
	</p>
	</div>
</form>
<?php
}
?>
</body>
</html>
<?php 
	
		if($_REQUEST['register'] == "Register")
		{
			$link = mysql_connect("xxx","xxx","xxx");
			mysql_select_db("xxx",$link);
				
			 $username = $_POST['username'];
			 $email =$_POST['email'];
			 $designation=$_POST['designation'];
			 $organisation=$_POST['organisation'];
			 $password = $username;
             
			 $emarketing = $_POST['emarketing'];
			 $vmarketing =$_POST['vmarketing'];
			 
			 $esales=$_POST['esales'];
			 $vsales=$_POST['vsales'];
			 
			 $ebo = $_POST['ebo'];
			 $vbo =$_POST['vbo'];
			 
			 $eadmin=$_POST['eadmin'];
			 $vadmin=$_POST['vadmin'];
			//$subject = "This is your protostar auto generated password";
			
			//$headers = "protostar.com";
			
			
		   $sql = "INSERT INTO users values('','$username','$password','$email','1','','','$designation','$organisation')";
		   $sqlres = mysql_query($sql);
		   
		   /*$sql="SELECT userID FROM users WHERE username='".$username."'";
		   $userid = mysql_query($sql);
		   
		   $sql = "INSERT INTO marketing values('','$userid','$emarketing','$vmarketing')";
		   $sqlres = mysql_query($sql);
		   
		   $sql = "INSERT INTO sales values('','$userid','$esales','$vsales')";
		   $sqlres = mysql_query($sql);
		   
		   $sql = "INSERT INTO business_overview values('','$userid','$ebo','$vbo')";
		   $sqlres = mysql_query($sql);
		   
		   $sql = "INSERT INTO admin values('','$userid','$eadmin','$vadmin')";
		   $sqlres = mysql_query($sql);*/
		   
		   
		   echo (" data saved into database ".$username);
	}


?>
Edited by puvi because: n/a
Member Avatar for puvi

hey dragonbaki..pls go thru the code n proof check for me..thanks

Member Avatar for puvi

hi all..can anyone locate any issue in this code..pls bring to my notice..

Member Avatar for paulrajj

Hi puvi,

It seems there is no issues in your php code. Did u checked that you set AUTO INCREMENT value to the id of your mysql table ?

Member Avatar for puvi

thank u all for ur time..

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.