Inserting info from text file into database....not working...

[ProgrammerJen]

I've created a function to update the database with the information from the text file...I've already got additional code (not posted here) that displays the orders that have NOT been shipped (and works beautifully). Then when they click the button it should process the text file and update the database (input the tracking number into the database) and change the order status and send an email to the customer, I know I've got something mixed up because it's not working...

 

 

function process_shipping($ordernumber, $status=''){

      $order_updated = false;

   

      $check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased from " . TABLE_ORDERS . " where orders_id = '" . $ordernumber . "'");

  $check_status = tep_db_fetch_array($check_status_query);

 

  $orders_statuses = array();

  $orders_status_array = array();

  $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = 1");

  while ($orders_status = tep_db_fetch_array($orders_status_query)) {

    $orders_statuses[] = array('id' => $orders_status['orders_status_id'],

                              'text' => $orders_status['orders_status_name']);

    $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];

  }

 

  if ($status!==''){   

      if ($check_status['orders_status'] !== $status) {

        tep_db_query("update " . TABLE_ORDERS . " set fedex_track_num = '" . $tracking . "'orders_status = '". $status . "', last_modified = now() where orders_id = '" . $oID . "'");

        $customer_notified = '0';

     

        $notify_comments = '';

          $email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "\n\n" . $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);

          tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, nl2br($email), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

        $customer_notified = '1';

     

      tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values ('" . (int)$oID . "', '" . tep_db_input($status) . "', now(), '" . tep_db_input($customer_notified) . "', '" . tep_db_input($comments)  . "')");

 

        $order_updated = true;

        }

    }

   

  }

 

 

 

if ($_POST['update']=='1') {

echo '<div class="dataTableContent" align="left">';

$arr=file("/home/onest4/public_html/beta/fedex.txt");

$x=1;

 

foreach($arr as $str){

  if (trim($str) != ''){

      if ($x > 3){

        list($tracking,$oID)=explode("  ",$str);

            if(ctype_digit($tracking)){

 

        echo "Order# $oID, <b>$tracking</b> (DATABASE UPDATED)<br>";

      }

 

      }else{

        $x++;

        continue;

      }

}

}

}