[cubob]

I have data in a mysql table and I need a system that make it possible to move up and down this data (by means of arrows button (up and down)) rows whenever they are rendered in the browser and the write back or remember this order for the next shows. The submit of the form for every sort operation is not a problem, as the mass of data is small. I just need a good and simple pattern to follow, not the detailed code.
Thank you.

[Jcbones]

Un-tested.

PHP Code:

<?php

if(isset($_GET['sort'])) {
    $sort = $_GET['sort'];
        $file = fopen('sort.txt','w');
        fwrite($file,$sort);
        fclose($file);
}
else {
    $sort = file_get_contents('sort.txt');
}

$sort = (isset($sort)) ? "ORDER BY `$sort`" : NULL;

$sql = "SELECT * FROM `table` $sort";
?>

[Jcbones]

Tested.

PHP Code:

<?php
include('config.php');
$table = ' ';
if(isset($_GET['sort'])) {
    $sort = $_GET['sort'];
        $file = fopen('sort.txt','w');
        fwrite($file,$sort);
        fclose($file);
}
else {
    $sort = file_get_contents('sort.txt');
}

$sort = ($sort != NULL) ? "ORDER BY `$sort`" : NULL;

$sql = "SELECT * FROM `$table` $sort";
                                    
$result = mysql_query($sql);
if(mysql_num_rows($result) > 0) {

    echo '<table border="1">';
    $i = 0;
    while($r = mysql_fetch_assoc($result)) {
        if($i == 0) {
            foreach($r as $k=>$v) {
                echo '<th>' . $k . ' <a href="?sort=' . $k . '">^</a></th>';
                $keys[] = $k;
            }
        }
        $i++;
        echo '<tr>';
            foreach($keys as $v) {
                echo '<td>' . $r[$v] . '</td>';
            }
        echo '</tr>';
        
    }
    
    echo '</table>';
    
}


?>

[End User]

I'd strongly recommend adding this code to help prevent potential naughtiness:

$sort = preg_replace("/[^0-9a-z]/i",'', $_GET['sort']);

[wirehopper]

You might want to use session variables:

PHP Code:

<?php 

session_start();  /* This line must be before any output is sent, including headers */

if (isset($_GET['sort']))  /* If a sort value was sent */

  $sort=preg_replace("/[^0-9a-z]/i",'', $_GET['sort']);  /* As noted by End User */

else

  if (isset($_SESSION['sort']))  /* If there is an existing sort value */

    $sort=$_SESSION['sort'];

  else  /* No sort sent or stored */

    $sort='';

$_SESSION['sort']=$sort;



/* At this point, $sort will be the sort value, and it will be saved in $_SESSION['sort'] for the next access */

[cubob]

Thanks...anyway your response does not seem to help me...read carefully the question

[Jcbones]

I re-read your question, and it is exactly what you ask for. If you need something different, please specify.

I need a system that make it possible to move up and down this data (by means of arrows button (up and down)) rows whenever they are rendered in the browser and the write back or remember this order...not the detailed code.

For sanitation, I would put good strings in an array, then use in_array(). The strings aren't going to change.

[Jcbones]

Originally Posted by wirehopper

You might want to use session variables:

PHP Code:

<?php 

session_start();  /* This line must be before any output is sent, including headers */

if (isset($_GET['sort']))  /* If a sort value was sent */

  $sort=preg_replace("/[^0-9a-z]/i",'', $_GET['sort']);  /* As noted by End User */

else

  if (isset($_SESSION['sort']))  /* If there is an existing sort value */

    $sort=$_SESSION['sort'];

  else  /* No sort sent or stored */

    $sort='';

$_SESSION['sort']=$sort;



/* At this point, $sort will be the sort value, and it will be saved in $_SESSION['sort'] for the next access */

I suggested writing to a file, because I thought he wanted it saved between sessions.

[cubob]

I found some solutions:

PHP ::