Enjoy an ad free experience by logging in. Not a member yet?
Register .
PM User | 1
New Coder
Join Date: Oct 2002
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Sorting results by
I am working on a script which shows results a lot like phpmyadmin. It has multiple columns and need a way to sort by each column when the column title is clicked on. How would I go about doing this?
__________________
PM User | 2
New Coder
Join Date: Oct 2002
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Here is what I have so far...
PHP Code:
<?php
include( "inc/config.php" );
"inc/database.php" );
"inc/header.php" );
$default_sort = 'id' ;
$allowed_order = array ( 'id' , 'CompanyName' , 'FirstName' , 'LastName' );
$from = (( $page * $max_results ) - $max_results );
$_GET [ "cmd" ] == "order" ||
in_array ( $_GET [ "cmd" ] == "order" , $allowed_order )) {
$order = $default_sort ;
$order = $_GET [ "cmd" ] == "order" ;
$query = "SELECT * FROM contacts ORDER BY $order LIMIT $from, $max_results" ;
$result = mysql_query ( $query );
$numrows = mysql_num_rows ( $result );
$numrows == 0 ) {
"No data to display!" ;
$row = mysql_fetch_assoc ( $result );
"<tr>\n" ;
$row as $heading => $column ) {
"<td class=\"header\">" ;
in_array ( $heading , $allowed_order )) {
"<a href=\"?cmd=order&by=$heading\">$heading</a>" ;
$heading ;
"</td>\n" ;
"</tr>\n" ;
mysql_data_seek ( $result , 0 );
$row = mysql_fetch_assoc ( $result )) {
"<tr>\n" ;
$row as $column ) {
"<td>$column</td>\n" ;
"</tr>\n" ;
?>
Can't get it to actually sort though. When I try clicking on one of the headings it doesn't do anything but reload the same info.
__________________
Last edited by X-MC; 10-05-2004 at 08:18 PM ..
PM User | 3
New Coder
Join Date: Oct 2002
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Here is the entire script if anyone wants to look at it. The last post was just the part having problems.
PHP Code:
<?php
include( "inc/config.php" );
"inc/database.php" );
"inc/header.php" );
session_start ();
$_Username = "Testuser" ;
$_Password = "Testpass" ;
$_POST [ 'submitted' ] == "True" ) {
$_POST [ 'username' ] == $_Username && $_POST [ 'password' ] == $_Password ) {
$_SESSION [ 'Logged_In' ] = "True" ;
$_SESSION [ 'Username' ] = $_Username ;
$_SESSION [ 'Logged_In' ] != "True" ) {
"<form method=\"post\" action=\"index.php\">
;
$cmd )) {
$result = mysql_query ( "SELECT * FROM contacts" );
$row = mysql_fetch_array ( $result ))
$id = $row [ "id" ];
$_GET [ 'cmd' ] == "logout" ) {
session_start ();
$_SESSION = array();
session_destroy ();
"<meta http-equiv=\"refresh\" content=\"0\"; url=\"index.php\">" ;
$_GET [ "cmd" ] == "export" ) {
$sql = "SELECT * FROM contacts" ;
$result = mysql_query ( $sql ) or die( mysql_error ());
$fields = mysql_num_fields ( $result );
$i = 0 ; $i < $fields ; $i ++) {
$header .= mysql_field_name ( $result , $i ) . "\t" ;
$row = mysql_fetch_row ( $result )) {
$line = '' ;
$row as $value ) {
$value )) OR ( $value == "" )) {
$value = "\t" ;
$value = str_replace ( '"' , '""' , $value );
$value = '"' . $value . '"' . "\t" ;
$line .= $value ;
$data .= trim ( $line ). "\n" ;
$data = str_replace ( "\r" , "" , $data );
$data == "" ) {
$data = "\n(0) Records Found!\n" ;
header ( "Content-type: application/octet-stream" );
header ( "Content-Disposition: attachment; filename=contacts.xls" );
header ( "Pragma: no-cache" );
header ( "Expires: 0" );
"$header\n$data" ;
$_GET [ "cmd" ] == "delete" ) {
$sql = "DELETE FROM contacts WHERE id='$id'" ;
$result = mysql_query ( $sql ) or die( mysql_error ());
"Record Deleted" ;
$_GET [ 'page' ])) {
$page = 1 ;
$page = $_GET [ 'page' ];
$default_sort = 'id' ;
$allowed_order = array( 'id' , 'CompanyName' , 'FirstName' , 'LastName' );
$from = (( $page * $max_results ) - $max_results );
$_GET [ "cmd" ] == "order" &&
in_array ( $_GET [ "by" ], $allowed_order )) {
$order = $_GET [ 'by' ];
$order = $default_order ;
$query = "SELECT * FROM contacts ORDER BY $order LIMIT $from, $max_results" ;
$result = mysql_query ( $query ) or die( $query . ' caused ' . mysql_error ());
$numrows = mysql_num_rows ( $result );
$numrows == 0 ) {
"No data to display!" ;
$_POST [ 'addsubmit' ]) {
$companyname = $_POST [ "companyname" ];
$firstname = $_POST [ "firstname" ];
$lastname = $_POST [ "lastname" ];
$address = $_POST [ "address" ];
$aptno = $_POST [ "aptno" ];
$city = $_POST [ "city" ];
$state = $_POST [ "state" ];
$zip = $_POST [ "zip" ];
$workphone = $_POST [ "workphone" ];
$x = $_POST [ "x" ];
$request = $_POST [ "request" ];
$called = $_POST [ "called" ];
$comments = $_POST [ "comments" ];
$catalog = $_POST [ "catalog" ];
$pricebook = $_POST [ "pricebook" ];
$conpamp = $_POST [ "conpamp" ];
$binder = $_POST [ "binder" ];
$sentrequest = $_POST [ "sentrequest" ];
$motiv = $_POST [ "motiv" ];
$sql = "INSERT INTO contacts (CompanyName, FirstName, LastName, Address, AptNo, City, State, Zip, WorkPhone, X, Request, Called, Comments, Catalog, Pricebook, Conpamp, Binder, SentRequest, Motiv) VALUES ('$companyname', '$firstname', '$lastname', '$address', '$aptno', '$city', '$state', '$zip', '$workphone', '$x', '$request', '$called', '$comments', '$catalog', '$pricebook', '$conpamp', '$binder', '$sentrequest', '$motiv')" ;
$result = mysql_query ( $sql ) or die( mysql_error ());
"Record Added" ;
$_POST [ "cmd" ] == "edit" ) {
$_POST [ "editsubmit" ])) {
$sql = "SELECT * FROM contacts WHERE id=$id" ;
$result = mysql_query ( $sql ) or die( mysql_error ());
$row = mysql_fetch_array ( $result );
$_POST [ "editsubmit" ]) {
$companyname = $_POST [ "companyname" ];
$firstname = $_POST [ "firstname" ];
$lastname = $_POST [ "lastname" ];
$address = $_POST [ "address" ];
$aptno = $_POST [ "aptno" ];
$city = $_POST [ "city" ];
$state = $_POST [ "state" ];
$zip = $_POST [ "zip" ];
$workphone = $_POST [ "workphone" ];
$x = $_POST [ "x" ];
$request = $_POST [ "request" ];
$called = $_POST [ "called" ];
$comments = $_POST [ "comments" ];
$catalog = $_POST [ "catalog" ];
$pricebook = $_POST [ "pricebook" ];
$conpamp = $_POST [ "conpamp" ];
$binder = $_POST [ "binder" ];
$sentrequest = $_POST [ "sentrequest" ];
$motiv = $_POST [ "motiv" ];
$sql = "UPDATE contacts SET CompanyName='$companyname',FirstName='$firstname',LastName='$lastname',Address='$address',AptNo='$aptno',City='$city',State='$state',Zip='$zip',WorkPhone='$workphone',X='$x',Request='$request',Called='$called',Comments='$comments',Catalog='$catalog',Pricebook='$pricebook',Conpamp='$conpamp',Binder='$binder',SentRequest='$sentrequest',Motiv='$motiv' WHERE id='$id'" ;
$result = mysql_query ( $sql ) or die( mysql_error ());
"Record Edited" ;
$sql = mysql_query ( "SELECT * FROM contacts LIMIT $from, $max_results" );
?>
<table border="0" cellspacing="0" cellpadding="3" width="100%" class="tabs">
<?php
= mysql_fetch_assoc ( $result );
"<tr>\n" ;
$row as $heading => $column ) {
"<td class=\"header\">" ;
in_array ( $heading , $allowed_order )) {
"<a href=\"?cmd=order&by=$heading\">$heading</a>" ;
$heading ;
"</td>\n" ;
"</tr>\n" ;
mysql_data_seek ( $result , 0 );
$row = mysql_fetch_assoc ( $result )) {
"<tr>\n" ;
$row as $column ) {
"<td onMouseover=\"changeto(event, '#F2F2F2')\" onMouseout=\"changeback(event, '#DDDDDD')\" class=\"item\">$column</td>\n" ;
"</tr>\n" ;
?>
<tr id="add" class="switchcontent">
<?php
while( $row = mysql_fetch_array ( $sql )){
?>
<tr>
<?=$row [ "id" ] ?> </td>
<?=ucwords ( strtolower ( $row [ "CompanyName" ])); ?> </td>
<?=ucwords ( strtolower ( $row [ "FirstName" ])); ?> </td>
<?=ucwords ( strtolower ( $row [ "LastName" ])); ?> </td>
<?=ucwords ( strtolower ( $row [ "Address" ])); ?> </td>
<?=ucwords ( strtolower ( $row [ "AptNo" ])); ?> </td>
<?=ucwords ( strtolower ( $row [ "City" ])); ?> </td>
<?=strtoupper ( $row [ "State" ]); ?> </td>
<?=$row [ "Zip" ] ?> </td>
<?=$row [ "WorkPhone" ] ?> </td>
<?=$row [ "X" ] ?> </td>
<?=ucwords ( strtolower ( $row [ "Request" ])); ?> </td>
<?=$row [ "Called" ] ?> ></td>
<?=ucwords ( strtolower ( $row [ "Comments" ])); ?> </td>
<?=$row [ "Catalog" ] ?> ></td>
<?=$row [ "Pricebook" ] ?> ></td>
<?=$row [ "Conpamp" ] ?> ></td>
<?=$row [ "Binder" ] ?> ></td>
<?=$row [ "SentRequest" ] ?> ></td>
<?=$row [ "Motiv" ] ?> ></td>
<?=$row [ "id" ] ?> ')" style="cursor:hand; cursor:pointer" alt="Edit"></td>
<?=$row [ "id" ] ?> "><img src="images/button_drop.png" border="0" alt="Delete"></a></td>
<?=$row [ "id" ] ?> " class="switchcontent">
<?=$row [ "id" ] ?> "></td>
<?=$row [ "CompanyName" ] ?> " size="20"></td>
<?=$row [ "FirstName" ] ?> " size="20"></td>
<?=$row [ "LastName" ] ?> " size="20"></td>
<?=$row [ "Address" ] ?> " size="20"></td>
<?=$row [ "AptNo" ] ?> " size="20"></td>
<?=$row [ "City" ] ?> " size="20"></td>
<?=$row [ "State" ] ?> " size="20"></td>
<?=$row [ "Zip" ] ?> " size="20"></td>
<?=$row [ "WorkPhone" ] ?> " size="20"></td>
<?=$row [ "X" ] ?> " size="20"></td>
<?=$row [ "Request" ] ?> " size="20"></td>
<?=$row [ "Called" ] ?> ></td>
<?=$row [ "Comments" ] ?> " size="20"></td>
<?=$row [ "Catalog" ] ?> ></td>
<?=$row [ "Pricebook" ] ?> ></td>
<?=$row [ "Conpamp" ] ?> ></td>
<?=$row [ "Binder" ] ?> ></td>
<?=$row [ "SentRequest" ] ?> ></td>
<?=$row [ "Motiv" ] ?> ></td>
<?php
}
"</table><center>" ;
$total_results = mysql_result ( mysql_query ( "SELECT COUNT(*) AS Num FROM contacts" ), 0 );
$total_pages = ceil ( $total_results / $max_results );
$page > 1 ){
$prev = ( $page - 1 );
"<a href=\"?page=$prev\"><< Previous</a> " ;
$i = 1 ; $i <= $total_pages ; $i ++){
$page ) == $i ){
"$i " ;
"<a href=\"?page=$i\">$i</a> " ;
$page < $total_pages ){
$next = ( $page + 1 );
"<a href=\"?page=$next\">Next >></a>" ;
"</center>" ;
"inc/footer.php" );
?>
__________________
PM User | 4
New Coder
Join Date: Oct 2002
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Really need some help with this
__________________
PM User | 5
Regular Coder
Join Date: Jun 2004
Posts: 565
Thanks: 0
Thanked 18 Times in 18 Posts
PHP Code:
<?php
include( 'inc/config.php' );
'inc/database.php' );
'inc/header.php' );
$default_sort = 'id' ;
$allowed_order = array ( 'id' , 'CompanyName' , 'FirstName' , 'LastName' );
$from = ( $page - 1 ) * $max_results ;
$order = ( $_GET [ 'cmd' ] == 'order' && in_array ( $_GET [ 'by' ], $allowed_order )) ? $_GET [ 'by' ] : $_GET [ 'cmd' ];
$result = mysql_query ( 'SELECT * FROM contacts ORDER BY ' . $order . ' LIMIT ' . $from . ', ' . $max_results ) or die( 'Query failed. Reason: ' . mysql_error ());
mysql_num_rows ( $result )) {
"No data to display!" ;
$row = mysql_fetch_assoc ( $result );
'<tr>' . "\n" ;
$row as $heading => $column ) {
'<td class="header">' ;
in_array ( $heading , $allowed_order ) ? '<a href="?cmd=order&by=' . $heading . '">' . $heading . '</a>' : $heading ;
'</td>' . "\n" ;
'</tr>' . "\n" ;
mysql_data_seek ( $result , 0 );
$row = mysql_fetch_assoc ( $result )) {
'<tr>' . "\n" ;
$row as $column ) {
'<td>' . $column . '</td>' . "\n" ;
'</tr>' . "\n" ;
?>
dumpfi
PM User | 6
New Coder
Join Date: Oct 2002
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Parse error: parse error, unexpected ';' in c:\inetpub\wwwroot\literature\index.php on line 106
__________________
PM User | 7
New Coder
Join Date: Oct 2002
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
I got it working. I replaced part of mine with this:
PHP Code:
$order = ( $_GET [ 'cmd' ] == 'order' && in_array ( $_GET [ 'by' ], $allowed_order )) ? $_GET [ 'by' ] : $default_sort ;
Thanks!
__________________
Jump To Top of Thread
Thread Tools
Rate This Thread
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
All times are GMT +1. The time now is 09:22 AM .
Advertisement
Log in to turn off these ads.
Before you post, read our: 
