function to update database

[gabemcmillan]

I have this function that I call in my program to update my database. I know the variables are getting set but it is not updating my database at all. I also have included my connection file at the top. Any suggestions?

function update_paypal_ipn_table()
{
$query = "INSERT INTO user_info(username, password, email, first_name,
last_name, city, state, zip)
VALUES ($subscr_id,
(password($password)),
$payer_email,
$first_name,
$last_name,
$address_city,
$address_state,
$address_zipcode)" ;
$result = mysql_query($query) or die(mysql_error());
}

[thekidscareya]

Originally posted by gabemcmillan
I have this function that I call in my program to update my database. I know the variables are getting set but it is not updating my database at all. I also have included my connection file at the top. Any suggestions?


function update_paypal_ipn_table()
{
$query = "INSERT INTO user_info(username, password, email, first_name,
last_name, city, state, zip)
VALUES ($subscr_id,
(password($password)),
$payer_email,
$first_name,
$last_name,
$address_city,
$address_state,
$address_zipcode)" ;
$result = mysql_query($query) or die(mysql_error());
}

what i usually do is perform the same query using phpmyadmin - then after the query is done - it shows the query itself - then i just replace the data i entered with the variables - try that - it mite fix ur problem

[sct1061]

You need to pass the variables to the function for it to know what they are. I would suggest you create an array with all the variables you're going to use, then pass the array to the function, i.e.

$array = array( 
      $password,
      $payer_email,
      $first_name,
      $last_name,
      $address_city,
      $address_state,
      $address_zipcode);

function update_db($array) {
     // your function here
}

[gabemcmillan]

I am trying something different now. I am using my post variables. This should work shouldn't it?

function update_paypal_ipn_table(){

$query = "INSERT INTO user_info(username, password, email, first_name,
   last_name, city, state, zip) 
		 VALUES ('" . $_POST['subscr_id'] .
		  "', (password('" . $_POST['password'] . "')), '" .
    	 		 $_POST['payer_email'] . "', '" .
      		 $_POST['first_name'] . "', '" .
      		 $_POST['last_name'] . "', 
						 '" . $_POST['address_city'] . "',
						 '" .$_POST['address_state'] . "', '" .
      		 $_POST['address_zip'] ."' )" ;
      		 $result = mysql_query($query) or die(mysql_error());

}

[sct1061]

That should work, since $_POST is a superglobal and therefore available within functions.

[gabemcmillan]

Thx