[SOLVED] trouble updating data into table.

[jakebur01]

ok,

 

I have inserted all the customers info into all the necessary tables on the previous page. Also, on the previous page the customer enters in their credit card info..

 

Now on this page I am trying to update the credit card info into the orders table. I am having trouble getting the data to go in.

 

<?php
  include ('book_sc_fns.php');
  // The shopping cart needs sessions, so start one
  session_start();

  do_html_header('Checkout');

  $c_phone = $_POST['c_phone'];
  $c_email = $_POST['c_email'];
  $card_type = $_POST['card_type'];
  $card_number = $_POST['card_number'];
  $card_month = $_POST['card_month'];
  $card_year = $_POST['card_year'];
  $card_name = $_POST['card_name'];
  
  $name = $_SESSION['customer_name'];
  
$address = $_SESSION['customer_address'];


  if($_SESSION['cart']&&$c_phone&&$c_email&&$card_type&&$card_number&&
     $card_month&&$card_year&&$card_name )
  {
    //display cart, not allowing changes and without pictures 
    display_cart($_SESSION['cart'], false, 0);

    display_shipping(calculate_shipping_cost());  

    if(process_card($_POST))
    {
      //empty shopping cart
      session_destroy();
      echo 'Thankyou for shopping with us.  Your order has been placed.';
      display_button('index.php', 'continue-shopping', 'Continue Shopping');  
    }
    else
    {
    echo 'Could not process your card. ';
    echo 'Please contact the card issuer or try again.';
      display_button('purchase.php', 'back', 'Back');
    }
  }
  else
  {
    echo 'You did not fill in all the fields, please try again.<hr />';
    display_button('purchase.php', 'back', 'Back');
  } 

  do_html_footer();
?>

 

And here is the process_card() function.

 

<?php
function process_card($card_details)
{

  extract($card_details);
  
  
$conn = db_connect();

  // insert customer address
  $query = "UPDATE 'orders' SET 'c_phone' = '$c_phone', 'c_email' = '$c_email', 'card_type' = '$card_type', 'card_number' = '$card_number', 'card_month' = '$card_month', 'card_year' = '$card_year', 'card_name' = '$card_name' WHERE 'orders' . 'ship_name' = '$name'";
  
  

  $result = $conn->query($query);
  return true;
}

 

I still have a lot to learn, but I am starting to see things a little more clearly.

 

`Jake

 

[jitesh]

Column name and table name must not have quate (')

Keep ` insted of '

 

$query = "UPDATE 'orders' SET `c_phone` = '$c_phone', `c_email`= '$c_email', `card_type` = '$card_type', `card_number` = '$card_number', `card_month` = '$card_month', `card_year` = '$card_year', `card_name` = '$card_name' WHERE `orders` . `ship_name` = '$name'";

 

 

[jakebur01]

I changed it to this:

 

<?php
function process_card($card_details)
{

  extract($card_details);
  
  
$conn = db_connect();

  // insert customer address
  $query = "UPDATE `orders` SET `c_phone` = '$c_phone', `c_email` = '$c_email', `card_type` = '$card_type', `card_number` = '$card_number', `card_month` = '$card_month', `card_year` = '$card_year', `card_name` = '$card_name' WHERE `orders` . `ship_name` = '$name'";
  
  
///   where  
          //  name = '$name' and address = '$address' 
          //  and city = '$city' and state = '$state' 
           // and zip = '$zip' and country = '$country'";

  $result = $conn->query($query);
  return true;
}

 

still no dice...

 

I don't know what the deal is..

[jitesh]

What are trying to do here

 

WHERE `orders` . `ship_name`(???) = '$name'";

[jakebur01]

orderid 	customerid 	amount 	date 	order_status 	ship_name 	ship_address 	ship_city 	ship_state 	ship_zip 	ship_country 	c_phone 	c_email 	card_type 	card_number 	card_month 	card_year 	card_name
Edit 	Delete 	8 	13 	5.27 	2007-05-25 	PARTIAL 	test 	test 	test 	test 	test 	test 	0 	0 	0 	0 	0 	0 	0

 

I am trying to tell it what row I want it to update to.  ship_name is the name of a column where the customers name is stored,    I was trying to get it to store the data where the customers name that is stored in the session matches the name in that column.

[jitesh]

Try this

 

WHERE orders.ship_name = '$name'";

 

This would be like this

 

WHERE `orders.ship_name` = '$name'";

[jakebur01]

Does this part of my code look ok?

if($_SESSION['cart']&&$c_phone&&$c_email&&$card_type&&$card_number&&
     $card_month&&$card_year&&$card_name )
  {
    //display cart, not allowing changes and without pictures 
    display_cart($_SESSION['cart'], false, 0);

    display_shipping(calculate_shipping_cost());  

    if(process_card($_POST))
    {
      //empty shopping cart
      session_destroy();
      echo 'Thankyou for shopping with us.  Your order has been placed.';
      display_button('index.php', 'continue-shopping', 'Continue Shopping');  
    }

[jitesh]

if(isset($_SESSION['cart']) &&  isset($c_phone) && isset($c_email)  &&  isset($card_type) && isset($card_number) &&

    isset($card_month) && isset($card_year) && isset($card_name))

{

.........

..........

[jakebur01]

The data is inserting perfect on the previous page but is still not updating the credit card info.

 

I appreciate you taking the time to help me though jitesh.

[jitesh]

echo your update query then test in mysql.

[jakebur01]

MySQL said: Documentation

#1054 - Unknown column 'orders.ship_name' in 'where clause'

 

 

Also, I wasn't retrieving my session on this page:

 

function process_card($card_details)

{

 

  $name = $_SESSION['customer_name'];

[jakebur01]

this got it in mysql:

WHERE `orders` . `ship_name` = 'kirby';

[jakebur01]

Man!!! it works now!!

 

Thank you for helping me...

I really appreciate it!

 

`Jake