Re: Hello

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



HI,
Thanks for your response. Here is my query. UserID is auto incrament and UserLastLogin is a current_timestamp.

$query_users = "INSERT INTO users(UserID, Username, UserEmail, UserPassword, UserFirstName, UserLastName, UserCompany, UserAddress, UserAddress2, UserCity, UserState, UserCountry, UserZip, UserPhone, UserFax, UserEmailVerified, UserRegistrationDate, UserVerificationCode, UserIP, UserLastLogin)
	
VALUES('NULL','".$Username."','".$UserEmail."','". $UserPassword."','".$UserFirstName."','".$UserLastName."','". $UserCompany."','".$UserAddress."','".$UserAddress2."','". $UserCity."','".$UserState."','".$UserCountry."','".$UserZip."','". $UserPhone."','".$UserFax."','".$UserEmailVerified."','". $UserRegistrationDate."','".$UserVerificationCode."','".$UserIP."', now())";

This works as far as populating the database, but my results page does not return anything.

Only if the VALUES is set like this:

VALUES('NULL','".$Username=$_POST['Username']."','".$UserEmail=$_POST ['UserEmail']."','".$UserPassword=$_POST['UserPassword']."','". $UserFirstName=$_POST['UserFirstName']."','".$UserLastName=$_POST ['UserLastName']."','".$UserCompany=$_POST[$UserCompany]."','". $UserAddress=$_POST['UserAddress']."','".$UserAddress2=$_POST ['UserAddress2']."','".$UserCity=$_POST['UserCity']."','".$UserState= $_POST['UserState']."','".$UserCountry=$_POST[$UserCountry]."','". $UserZip=$_POST['UserZip']."','".$UserPhone=$_POST['UserPhone']."','". $UserFax=$_POST[$UserFax]."','".$UserEmailVerified=$_POST [$UserEmailVerified]."','".$UserRegistrationDate=$_POST [$UserRegistrationDate]."','".$UserVerificationCode=$_POST ['UserVerificationCode']."','".$UserIP=$_POST[$UserIP]."', now())";

but some do not work with this setup. variables like $UserEmailVerified, $UserRegistrationDate and $UserIP are not created from the form that was submitted.
for example, User IP date is created like this.

$UserIP = md5($_SERVER[REMOTE_ADDR]);

---------------------

Below is a snip of how I retrieve the info on the result page (dont want to clutter with whole code. also $fieldOne etc are MySql wildcards '%' from some dropdown lists that show before this code is executed. The results from adding show up fine there.)

$query_users = "SELECT * FROM users WHERE UserID LIKE '$fieldOne' AND Username LIKE '$fieldTwo' AND UserEmail LIKE '$fieldThree' AND UserPassword LIKE '$fieldFour' AND UserFirstName LIKE '$fieldFive' AND UserLastName LIKE '$fieldSix' AND UserCompany LIKE '$fieldSeven' AND UserAddress LIKE '$fieldEight' AND UserAddress2 LIKE '$fieldNine' AND UserCity LIKE '$fieldTen' AND UserState LIKE '$fieldEleven' AND UserCountry LIKE '$fieldTwelve' AND UserZip LIKE '$fieldThirteen' AND UserPhone LIKE '$fieldFourteen' AND UserFax LIKE '$fieldFifteen' AND UserEmailVerified LIKE '$fieldSixteen' AND UserRegistrationDate LIKE '$fieldSeventeen' AND UserVerificationCode LIKE '$fieldEighteen' AND UserIP LIKE '$fieldNineteen' AND UserLastLogin LIKE '$fieldTwenty' LIMIT $min, $max_results";

$result = mysql_query($query_users) or die(mysql_error());

for($i = 1; $i <= $num_sql; $i++) {
		$r = mysql_fetch_array($result, MYSQL_ASSOC);
		$UserID = $r['UserID'];
        	$Username = $r['Username'];
        	$UserEmail = $r['UserEmail'];
		$UserPassword = $r['UserPassword'];

so I have 3 pages. one adds the users, the next reviews and the last shows the results of what is picked.

Thanks,

Karl


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux