Help

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
jauson
Forum Contributor
Posts: 111
Joined: Wed Oct 05, 2011 12:59 am

Help

Post by jauson »

Hi can you show me whats my wrong in my code. I didnt know why my query = INSERT INTO didnt works. suggestions will be appreciated.

Code: Select all

<?php

include 'conn.php';

if (isset($_POST['firstname'])&&isset($_POST['lastname'])&&isset($_POST['priveledges'])&&isset($_POST['user_input'])&&isset($_POST['pass_input'])&&isset($_POST['repass_input'])){
	$firstname = $_POST['firstname'];
	$lastname = $_POST['lastname'];
	$priveledges = $_POST['priveledges'];
	$username = $_POST['user_input'];
	$password = $_POST['pass_input'];
	$repass_input = $_POST['repass_input'];
	
	if (!empty($firstname)&&!empty($lastname)&&!empty($priveledges)&&!empty($username)&&!empty($password)&&!empty($repass_input)){
		if ($password == $repass_input){
			$query = "SELECT `username` FROM `r_user` WHERE `username`='$username'";
			$query_run = mysql_query($query);
			
			if (mysql_num_rows($query_run)==1){
				echo '<font color="RED" size="2">Username '.$username.' is already exist</font>';
			} else {

			$query = "INSERT INTO `r_user` VALUES `firstname`='".mysql_real_escape_string($firstname)."', `lastname`='".mysql_real_escape_string($lastname)."', `priveledges`='".mysql_real_escape_string($priveledges)."', `username`='".mysql_real_escape_string($username)."', `password`='".mysql_real_escape_string($password)."'";
				
				if ($query_run = mysql_query($query)){
					echo '<font color="Blue" size="2">Success, You can now log-in <a href="index.php"> here </a></font>';
			} else {
				echo '<font color="RED" size="2">Sorry we could\'nt register you at this time</font>';
					}
				}
			} else if ($password != $repass_input) {
			echo '<font color="RED" size="2">Password do not match!</font>';
			}
		} else {
		echo '<font color="RED" size="2"> All fields cannot be empty </font>';
	}	
}


?>
<hr>
<strong>Registration</strong><br><br>
<form action="register.php" method="POST">
First Name:<br><input type="text" name="firstname"><br>
Last Name:<br><input type="text" name="lastname"><br>
Priveledges:<br>
<select name="priveledges">
<option value="Admin">Admin</option>
<option value="Operator">Operator</option></select><br>
Username:<br><input type="text" name="user_input"><br>
Password:<br><input type="password" name="pass_input"><br>
re-type Password:<br><input type="password" name="repass_input"><br><br>
<input type="submit" value="Register">
</form>
Last edited by Benjamin on Wed Oct 19, 2011 10:03 pm, edited 1 time in total.
Reason: Added [syntax=php|sql|css|javascript] and/or [text] tags.
User avatar
twinedev
Forum Regular
Posts: 984
Joined: Tue Sep 28, 2010 11:41 am
Location: Columbus, Ohio

Re: Help

Post by twinedev »

You are not using valid query, and insert is generally one of the three formats:

Code: Select all

INSERT INTO `table` VALUES ('value1','value2','value3')

Code: Select all

INSERT INTO `table` (`field1`,`field2`,`field3`) VALUES ('value1','value2','value3')

Code: Select all

INSERT INTO `table` SET `field1`='value1', `field2`='value2', `field3`='value3'
jauson
Forum Contributor
Posts: 111
Joined: Wed Oct 05, 2011 12:59 am

Re: Help

Post by jauson »

many thank dude I just used format 3
Post Reply