Jump to content

sort by date

muddy004

By muddy004
in PHP Coding Help

 Share

Recommended Posts

muddy004 Newbie

muddy004

Posted
Posted
Dear Freaks,

I have a very simple php page (that I've inherited) that grabs 3 sets of data from the database using a drop down menu and a go button:

The drop down shows these 3 choices:

Show New Records
Show Processed Orders
Show All Records


What do I have to do to the page below to make the "Show Processed Orders" display the records sorted by date?

Thanks a million!



[code]<?php echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?".">"; ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Secure Data Retrieval</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>
<?php
  $dbh = mysql_pconnect('localhost', 'username', 'password') or die('Could not connect with the database');
  mysql_select_db('3pr', $dbh);
 
  //CHECK FOR SET POST_VARS
  foreach($_POST as $Key => $Value) {
    if(preg_match('/^FV_Delete_Me_*./', $Key)) {
  $Delete_Match .= "$Value," ;
}
if(preg_match('/^FV_Process_Me_*./', $Key)) {
  $Process_Match .= "$Value," ;
    }
  }
 
  //DELETE RECORDS
  if(isset($Delete_Match)) {
    $Delete_Customer = "DELETE
      FROM Customer
      WHERE c_id in ( ";
    $Delete_Customer_Order = "DELETE
    FROM Customer_Order
    WHERE co_c_id in ( ";
    $Delete_Customer .= "$Delete_Match 0)";
$Delete_Customer_Order .= "$Delete_Match 0)";
mysql_query($Delete_Customer, $dbh);
mysql_query($Delete_Customer_Order, $dbh);
  }

  //PROCESS RECORDS
  if(isset($Process_Match)) {
    $Process_Customer = "UPDATE Customer
        SET c_processed = '1',
    c_card_number = ''
    WHERE c_id in (";
    $Process_Customer .= "$Process_Match 0)";
mysql_query($Process_Customer, $dbh);
  }
 
  $Get_Data = "SELECT Customer.c_id,
  DATE_FORMAT(Customer.c_date_created, '%m/%d/%Y at %h:%m%p') 'c_date_created',
  Customer.c_processed,
  Customer.c_first_name,
  Customer.c_last_name,
  Customer.c_street_address,
  Customer.c_city,
  Customer.c_state,
  Customer.c_zip,
  Customer.c_phone,
  Customer.c_email,
  Customer.c_card_type,
  Customer.c_card_number,
  Customer.c_expiration,
  Customer.c_item_ordered,
  Customer_Order.co_id,
  Customer_Order.co_date_created,
  Customer_Order.co_date_modified,
  Customer_Order.co_first_name,
  Customer_Order.co_last_name,
  Customer_Order.co_street_address,
  Customer_Order.co_city,
  Customer_Order.co_state,
  Customer_Order.co_zip,
  Customer_Order.co_phone,
  Customer_Order.co_email,
  Customer_Order.co_comments
FROM Customer, Customer_Order
WHERE Customer.c_id = Customer_Order.co_c_id";

  if(!$_POST['FV_Action_Select'] || $_POST['FV_Action_Select'] == 1) {
    $Get_Data .= " AND Customer.c_processed is NULL";
  }
  elseif($_POST['FV_Action_Select'] == 2) {
    $Get_Data .= " AND Customer.c_processed IS NOT NULL";
  }

  $Get_Data_Result = mysql_query($Get_Data, $dbh);
?>
<body>
<table width="700" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="700" height="100" valign="top">
  <form name="Interface_frm" id="Interface_frm" method="post" action="secure_data.php">
        <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <!--DWLayoutTable-->
          <tr>
            <td height="50" colspan="2" align="center">Threepenny Review Secure Data Retrieval</td>
          </tr>
          <tr>
            <td width="350" height="50" align="center">
  <select name="FV_Action_Select" id="FV_Action_Select">
    <option value="1" <?php if(!$_POST['FV_Action_Select'] || $_POST['FV_Action_Select'] == 1) {echo 'selected="selected"';} ?> >Show New Records</option>
<option value="2" <?php if($_POST['FV_Action_Select'] == 2) {echo 'selected="selected"';} ?> >Show Processed Records</option>
<option value="3" <?php if($_POST['FV_Action_Select'] == 3) {echo 'selected="selected"';} ?> >Show All Records</option>
              </select>
</td>
            <td width="350" align="center"> <input type="submit" name="Go" value="Go" />
            </td>
          </tr>
        </table>
</td>
  </tr>
  <tr>
    <td height="223" valign="top">
<?php
  while($Row = mysql_fetch_assoc($Get_Data_Result)) {
    foreach($Row as $Field_Name => $Field_Value) {
  $$Field_Name = $Field_Value;
}
$Delete_Name = 'FV_Delete_Me_';
$Delete_Name .= $c_id;
$Process_Name = 'FV_Process_Me_';
$Process_Name .= $c_id;
if($c_processed == 1) {
  $Processed = 'checked="checked"';
}
else {
  $Processed = '';
}

    print <<< END
<table width="100%" border="0" cellpadding="0" cellspacing="0">
        <!--DWLayoutTable-->
<tr>
    <td width="700" colspan="4" bgcolor="#FFFF00">$c_item_ordered</td>
</tr>
        <tr>
          <td height="21" colspan="2" align="center" bgcolor="#00CCFF">Billing Information</td>
          <td colspan="2" align="center" bgcolor="#66CC99">Shipping Information</td>
        </tr>
        <tr>
          <td height="5" colspan="2" valign="top"><img src="../images/spacer.gif" width="1" height="1" /></td>
          <td colspan="2" valign="top"><img src="../images/spacer.gif" width="1" height="1" /></td>
        </tr>
        <tr>
          <td width="56" height="21" valign="top">Name:</td>
  <td width="292" valign="top">$c_first_name $c_last_name</td>
          <td width="56" valign="top">Name:</td>
          <td width="296" valign="top">$co_first_name $co_last_name</td>
        </tr>
        <tr>
          <td height="21" valign="top">Address:</td> 
          <td valign="top">
    $c_street_address<br />
$c_city, $c_state $c_zip<br />
  </td>
          <td valign="top">Address:</td> 
          <td valign="top">
    $co_street_address<br />
$co_city, $co_state $co_zip<br />
  </td>
        </tr>
        <tr>
          <td height="21" valign="top">Phone:</td> 
          <td valign="top">$c_phone</td>
          <td valign="top">Phone:</td> 
          <td valign="top">$co_phone</td>
        </tr>
        <tr>
          <td height="21" valign="top">Email:</td> 
          <td valign="top">$c_email</td>
          <td valign="top">Email:</td> 
          <td valign="top">$co_email</td>
        </tr>
        <tr>
          <td height="5" colspan="2" valign="top"><img src="../images/spacer.gif" width="1" height="1" /></td>
          <td colspan="2" valign="top"><img src="../images/spacer.gif" width="1" height="1" /></td>
        </tr>
        <tr>
          <td height="21" colspan="2" align="center" valign="top" bgcolor="#FF0000">Credit Card Information</td>
          <td colspan="2" align="center" valign="top">Comments</td>
        </tr>
        <tr>
          <td height="5" colspan="2" valign="top"><img src="../images/spacer.gif" width="1" height="1" /></td>
          <td colspan="2" valign="top"><img src="../images/spacer.gif" width="1" height="1" /></td>
        </tr>
        <tr>
          <td height="21" valign="top">Type:</td> 
            <td valign="top">$c_card_type</td>
            <td colspan="2" rowspan="3" valign="top">$co_comments</td>
        </tr>
        <tr>
          <td height="21" valign="top">Number:</td>
            <td valign="top">$c_card_number</td>
        </tr>
        <tr>
          <td height="21" valign="top">Exp:</td>
            <td valign="top">$c_expiration</td>
        </tr>
        <tr>
          <td height="19" colspan="2" valign="top">
    Processed: <input type="checkbox" name="$Process_Name" id="$Process_Name" value="$c_id" $Processed/>
            Delete: <input type="checkbox" name="$Delete_Name" id="$Delete_Name"; value="$c_id"/> </td>
          <td valign="top">Date:</td>
          <td valign="top">$c_date_created</td>
        </tr>
<tr>
  <td height="10" colspan="4" valign="top"><img src="../images/spacer.gif" width="1" height="1" /></td>
</tr>
      </table>
END;
}
mysql_close($dbh);
?>
</form>
  </td>
  </tr>
</table>
</body>
</html>[/code]
Link to comment
https://forums.phpfreaks.com/topic/15172-sort-by-date/
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.