sorting a pipe delim array?

CONphuzed · Aug 9, 2001

I'm a newbie and I can't figure out how to sort this array. My array is a text file (dbase.txt) setup like this:

category|name|type|id|options|price|..|..|..|..|..|..

I have tokenized each element of the array and have it so it lists by category ($categ). But now I want to sort the $name (which happens to be numbers) numerically so it displays in numeric order.

Here is the whole file, (the code I need help on is 2/3rds down):

<? include("vars.php&quot

; ?>
<? include("lib.php&quot

; ?>

<html>
<head>
<title><? echo "$title"; ?></title>
</head>

<? style(); ?>

<body>

<? if (file_exists("header.php&quot

): include("header.php&quot

; endif; ?>

<script language="javascript">
<!--

function addItem(nameInfo, qtyItem) {

if (nameInfo.selectedIndex) {
nameInfoVal = nameInfo[nameInfo.selectedIndex].value;
}
else {
nameInfoVal = nameInfo.value;
}

splitPos = nameInfoVal.indexOf("|&quot

;

nameItem = nameInfoVal.substring(0,splitPos);
priceItem = nameInfoVal.substring(splitPos+1,nameInfoVal.length);

if (qtyItem <= 0) {
alert('Error!\n\nYou must enter a quantity');
return false;
}

if (confirm('Add '+qtyItem+' x '+nameItem+' @ $'+priceItem+' ea. to Shopping')) {
index = document.cookie.indexOf("ShopCart&quot

;
countstart = (document.cookie.indexOf("=", index) + 1);
countend = document.cookie.indexOf(";", index);
if (countend == -1) {
countend = document.cookie.length;
}
document.cookie="ShopCart="+document.cookie.substring(countstart, countend)+"["+nameItem+","+priceItem+"#"+qtyItem+"]";

<?
if ($confirm_type == "view&quot

:
echo "document.location = \"view.php\";";
endif;
?>

}

return true;
}

//-->
</script>

<? dispHeader($categ,$search,$cat); ?>

<p><table width="<? echo "$twidth"; ?>" border="1" cellspacing="0" cellpadding="2" bgcolor="<? echo "$tdbg"; ?>" bordercolor="Black" bordercolorlight="Black" bordercolordark="Black">
<tr>
<td><font color="<? echo "$font1"; ?>"><b>

<? if ($cat == "&quot

: echo "All Products"; else: echo "$cat"; endif; ?>

</b></font></td>
</tr>
</table>

<form name="itemsform">

<?

if ($option == "search&quot

:

exec("grep -i $search dbase.txt",$execAr);

if ($execAr[0] != "&quot

:

while ( list($key,$val) = each( $execAr ) ) {

$tok = strtok($val,"|&quot

;
$categ = $tok;
$tok = strtok("|&quot

;
$name = $tok;
$tok = strtok("|&quot

;
$type = $tok;
$tok = strtok("|&quot

;
$id = $tok;
$tok = strtok("|&quot

;
$options = $tok;
$tok = strtok("|&quot

;
$price = $tok;
$tok = strtok("|&quot

;
$normpr = $tok;
$tok = strtok("|&quot

;
$img = $tok;
$tok = strtok("|&quot

;
$stockop = $tok;
$tok = strtok("|&quot

;
$advdate = $tok;
$tok = strtok("|&quot

;
$details = $tok;
$tok = strtok("|&quot

;
$desc = $tok;

displayProd($categ,$type,$id,$name,$options,$price,$normpr,$img,$stockop,$advdate,$details,$desc);

}

else:

echo "There were no matches for your search query.
<P><br><br><br><br><hr width=\"100%\" size=\"1\" noshade color=\"black\">";

endif;

// below is where I'm having trouble, how do I sort by
// $categ before displaying?

else:

$cartFile = File("dbase.txt&quot

;
$length = sizeof($cartFile);
$i = 1;
while ($i < $length):
$tok = strtok($cartFile[$i],"|&quot

;
$categ = $tok;
$tok = strtok("|&quot

;
$name = $tok;
$tok = strtok("|&quot

;
$type = $tok;
$tok = strtok("|&quot

;
$id = $tok;
$tok = strtok("|&quot

;
$options = $tok;
$tok = strtok("|&quot

;
$price = $tok;
$tok = strtok("|&quot

;
$normpr = $tok;
$tok = strtok("|&quot

;
$img = $tok;
$tok = strtok("|&quot

;
$stockop = $tok;
$tok = strtok("|&quot

;
$advdate = $tok;
$tok = strtok("|&quot

;
$details = $tok;
$tok = strtok("|&quot

;
$desc = $tok;

if ($categ == "$cat" || $cat == "&quot

:

displayProd($categ,$type,$id,$name,$options,$price,$normpr,$img,$stockop,$advdate,$details,$desc);

endif;

$i++;
endwhile;

endif;

?>

</form>

<? dispFooter(); ?>

<? if (file_exists("footer.php&quot

): include("footer.php&quot

; endif; ?>

</body>
</html>

inlandpac · Aug 9, 2001

Here you go. Let me know if you have any problems. I modified your file parsing just a bit.

Keep in mind that if you have a huge number of records in dbase.txt, you may get a memory error because the arrays will get very large and use a large amount of memory.

Code:

    $cartFile = @file(&quot;dbase.txt&quot;);

    $lines = split(&quot;\n&quot;,$cartFile);

    for($a=0;$a<count($lines);$a++) {
        $data = split(&quot;\|&quot;,$lines[$a]);

        $categ[$a] = $data[0];
        $name[$a] = $data[1];
        $type[$a] = $data[2];
        $id[$a] = $data[3];
        $options[$a] = $data[4];
        $price[$a] = $data[5];
        $normpr[$a] = $data[6];
        $img[$a] = $data[7];
        $stockop[$a] = $data[8];
        $advdate[$a] = $data[9];
        $details[$a] = $data[10];
        $desc[$a] = $data[1];    
	}

/*
  SORT_ASC can also be SORT_DESC
  SORT_STRING can also be SORT_REGULAR, SORT_NUMERIC, or SORT_REGULAR 
*/
array_multisort ($categ, SORT_ASC, SORT_STRING, $name, $type, $id, $options, $price, $normpr, $img, $stockop, $advdate, $details, $desc);

Chad. ICQ: 54380631

CONphuzed · Aug 10, 2001

Thanks!! It makes sense, but now I'm getting a parse error on line 158 where endwhile; is. I don't get it?

<? include("vars.php&quot

; ?>
<? include("lib.php&quot

; ?>

<html>
<head>
<title><? echo "$title"; ?></title>
</head>

<? style(); ?>

<body>

<? if (file_exists("header.php&quot

): include("header.php&quot

; endif; ?>

<script language="javascript">
<!--

function addItem(nameInfo, qtyItem) {

if (nameInfo.selectedIndex) {
nameInfoVal = nameInfo[nameInfo.selectedIndex].value;
}
else {
nameInfoVal = nameInfo.value;
}

splitPos = nameInfoVal.indexOf("|&quot

;

nameItem = nameInfoVal.substring(0,splitPos);
priceItem = nameInfoVal.substring(splitPos+1,nameInfoVal.length);

if (qtyItem <= 0) {
alert('Error!\n\nYou must enter a quantity');
return false;
}

if (confirm('Add '+qtyItem+' x '+nameItem+' @ $'+priceItem+' ea. to Shopping')) {
index = document.cookie.indexOf("ShopCart&quot

;
countstart = (document.cookie.indexOf("=", index) + 1);
countend = document.cookie.indexOf(";", index);
if (countend == -1) {
countend = document.cookie.length;
}
document.cookie="ShopCart="+document.cookie.substring(countstart, countend)+"["+nameItem+","+priceItem+"#"+qtyItem+"]";

<?
if ($confirm_type == "view&quot

:
echo "document.location = \"view.php\";";
endif;
?>

}

return true;
}

//-->
</script>

<? dispHeader($categ,$search,$cat); ?>

<p><table width="<? echo "$twidth"; ?>" border="1" cellspacing="0" cellpadding="2" bgcolor="<? echo "$tdbg"; ?>" bordercolor="Black" bordercolorlight="Black" bordercolordark="Black">
<tr>
<td><font color="<? echo "$font1"; ?>"><b>

<? if ($cat == "&quot

: echo "All Products"; else: echo "$cat"; endif; ?>

</b></font></td>
</tr>
</table>

<form name="itemsform">

<?

if ($option == "search&quot

:

exec("grep -i $search dbase.txt",$execAr);

if ($execAr[0] != "&quot

:

while ( list($key,$val) = each( $execAr ) ) {

$tok = strtok($val,"|&quot

;
$categ = $tok;
$tok = strtok("|&quot

;
$name = $tok;
$tok = strtok("|&quot

;
$type = $tok;
$tok = strtok("|&quot

;
$id = $tok;
$tok = strtok("|&quot

;
$options = $tok;
$tok = strtok("|&quot

;
$price = $tok;
$tok = strtok("|&quot

;
$normpr = $tok;
$tok = strtok("|&quot

;
$img = $tok;
$tok = strtok("|&quot

;
$stockop = $tok;
$tok = strtok("|&quot

;
$advdate = $tok;
$tok = strtok("|&quot

;
$details = $tok;
$tok = strtok("|&quot

;
$desc = $tok;

displayProd($categ,$type,$id,$name,$options,$price,$normpr,$img,$stockop,$advdate,$details,$desc);

}

else:

echo "There were no matches for your search query.
<P><br><br><br><br><hr width=\"100%\" size=\"1\" noshade color=\"black\">";

endif;

else:

$cartFile = @file("dbase.txt&quot

;

$lines = split("\n",$cartFile);

for($a=0;$a<count($lines);$a++) {
$data = split("\|",$lines[$a]);

$categ[$a] = $data[0];
$name[$a] = $data[1];
$type[$a] = $data[2];
$id[$a] = $data[3];
$options[$a] = $data[4];
$price[$a] = $data[5];
$normpr[$a] = $data[6];
$img[$a] = $data[7];
$stockop[$a] = $data[8];
$advdate[$a] = $data[9];
$details[$a] = $data[10];
$desc[$a] = $data[1];
}

/*
SORT_ASC can also be SORT_DESC
SORT_STRING can also be SORT_REGULAR, SORT_NUMERIC, or SORT_REGULAR
*/
array_multisort ($categ, SORT_ASC, SORT_STRING, $name, $type, $id, $options, $price, $normpr, $img, $stockop, $advdate, $details, $desc);

if ($categ == "$cat" || $cat == "&quot

:

displayProd($categ,$type,$id,$name,$options,$price,$normpr,$img,$stockop,$advdate,$details,$desc);

endif;

$i++;
endwhile;

endif;

?>

</form>

<? dispFooter(); ?>

<? if (file_exists("footer.php&quot

): include("footer.php&quot

; endif; ?>

</body>
</html>

inlandpac · Aug 10, 2001

Try the code below.

NOTE: newer methods of coding prefer {} style blocks. In if blocks, you can do

Code:

if(my comparison) {
    $myvar=&quot;fdaf&quot;;
}
else {
    $myvar = jklj&quot;;
}

as you can see, this can make your code a little bit easier to work with and future developers to read. Symantics and Syntax is VERY important.

hope this helps.

Code:

<?php include(&quot;vars.php&quot;); ?>
<?php include(&quot;lib.php&quot;); ?>

<html>
<head>
    <title><?php echo &quot;$title&quot;; ?></title>
</head>

<?php style(); ?>

<body>

<?php
     if(file_exists(&quot;header.php&quot;)) {
          include(&quot;header.php&quot;);
     }
?>

<script language=&quot;javascript&quot;>
<!--

function addItem(nameInfo, qtyItem) {

    if (nameInfo.selectedIndex) {
        nameInfoVal = nameInfo[nameInfo.selectedIndex].value;
    }
    else {
        nameInfoVal = nameInfo.value;
    }

    splitPos = nameInfoVal.indexOf(&quot;|&quot;);

    nameItem = nameInfoVal.substring(0,splitPos);
    priceItem = nameInfoVal.substring(splitPos+1,nameInfoVal.length);

    if (qtyItem <= 0) {
        alert('Error!\n\nYou must enter a quantity');
        return false;
    }


    if (confirm('Add '+qtyItem+' x '+nameItem+' @ $'+priceItem+' ea. to Shopping')) {
    index = document.cookie.indexOf(&quot;ShopCart&quot;);
    countstart = (document.cookie.indexOf(&quot;=&quot;, index) + 1);
    countend = document.cookie.indexOf(&quot;;&quot;, index);
        if (countend == -1) {
            countend = document.cookie.length;
        }
    document.cookie=&quot;ShopCart=&quot;+document.cookie.substring(countstart, countend)+&quot;[&quot;+nameItem+&quot;,&quot;+priceItem+&quot;#&quot;+qtyItem+&quot;]&quot;;

    <?php
    if($confirm_type == &quot;view&quot;) {
         echo &quot;document.location = \&quot;view.php\&quot;;&quot;;
    }
    ?>

    }

    return true;
}

//-->
</script>


<?php
     dispHeader($categ,$search,$cat);
?>

<p><table width=&quot;<?php echo $twidth; ?>&quot; border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;2&quot; bgcolor=&quot;<?php echo $tdbg; ?>&quot; bordercolor=&quot;Black&quot; bordercolorlight=&quot;Black&quot; bordercolordark=&quot;Black&quot;>
<tr>
    <td><font color=&quot;<?php echo $font1; ?>&quot;><b>

<?
   if($cat == &quot;&quot;) {
        echo &quot;All Products&quot;;
   }
   else {
        echo $cat;
   }
?>

Chad.

</b></font></td>
</tr>
</table>

<form name=&quot;itemsform&quot;>

<?php

if($option == &quot;search&quot;) {
    exec(&quot;grep -i $search dbase.txt&quot;,$execAr);

    if($execAr[0] != &quot;&quot;) {
        while ( list($key,$val) = each( $execAr ) ) {
	        $tok = strtok($val,&quot;|&quot;);
	        $categ = $tok;
	        $tok = strtok(&quot;|&quot;);
	        $name = $tok;
	        $tok = strtok(&quot;|&quot;);
	        $type = $tok;
	        $tok = strtok(&quot;|&quot;);
	        $id = $tok;
	        $tok = strtok(&quot;|&quot;);
	        $options = $tok;
	        $tok = strtok(&quot;|&quot;);
	        $price = $tok;
	        $tok = strtok(&quot;|&quot;);
	        $normpr = $tok;
	        $tok = strtok(&quot;|&quot;);
	        $img = $tok;
	        $tok = strtok(&quot;|&quot;);
	        $stockop = $tok;
	        $tok = strtok(&quot;|&quot;);
	        $advdate = $tok;
	        $tok = strtok(&quot;|&quot;);
	        $details = $tok;
	        $tok = strtok(&quot;|&quot;);
	        $desc = $tok;
	
	        displayProd($categ,$type,$id,$name,$options,$price,$normpr,$img,$stockop,$advdate,$details,$desc);
        }

    }
	else {
        echo &quot;There were no matches for your search query.
        <P><br><br><br><br><hr width=\&quot;100%\&quot; size=\&quot;1\&quot; noshade color=\&quot;black\&quot;>&quot;;

    }
}
else {
    $cartFile = @file(&quot;dbase.txt&quot;);
    $lines = split(&quot;\n&quot;,$cartFile);

    for($a=0;$a<count($lines);$a++) {
        $data = split(&quot;\|&quot;,$lines[$a]);

        $categ[$a] = $data[0];
        $name[$a] = $data[1];
        $type[$a] = $data[2];
        $id[$a] = $data[3];
        $options[$a] = $data[4];
        $price[$a] = $data[5];
        $normpr[$a] = $data[6];
        $img[$a] = $data[7];
        $stockop[$a] = $data[8];
        $advdate[$a] = $data[9];
        $details[$a] = $data[10];
        $desc[$a] = $data[1];    
    }

    /*
      SORT_ASC can also be SORT_DESC
      SORT_STRING can also be SORT_REGULAR, SORT_NUMERIC, or SORT_REGULAR 
    */
    array_multisort ($categ, SORT_ASC, SORT_STRING, $name, $type, $id, $options, $price, $normpr, $img, $stockop, $advdate, $details, $desc);

    if($categ == $cat || $cat == &quot;&quot;) {
        displayProd($categ,$type,$id,$name,$options,$price,$normpr,$img,$stockop,$advdate,$details,$desc);
    }

}

?>

</form>

<?php dispFooter(); ?>

<?php
if(file_exists(&quot;footer.php&quot;)) {
     include(&quot;footer.php&quot;);
}
?>

</body>
</html>

ICQ: 54380631

CONphuzed · Aug 10, 2001

Thanks again for the help

. It looks a lot cleaner and reads easier with curly brackets.

But, I am still a little lost. I'm not getting a parse error anymore but it is not displaying the products when I select a category. By default it used to display all products but it doesn't display those either and I'm not sure why? Hmmmm. Any ideas?

inlandpac · Aug 11, 2001

Okay, there were a few problems with the sample I provided (general oversite).

First of all, you have file() creates an array. You have to use implode() to join all of the lines into one string.

Secondly, the array_multisort and following if statement needed to be in a loop like such:

Code:

    array_multisort ($categ, SORT_ASC, SORT_STRING, $name, $type, $id, $options, $price, $normpr, $img, $stockop, $advdate, $details, $desc);

    for($b=0;$b<count($categ);$b++) {
        if($categ[$b] == $cat || $cat == &quot;&quot;) {
            displayProd($categ[$b],$type[$b],$id[$b],$name[$b],$options[$b],$price[$b],$normpr[$b],$img[$b],$stockop[$b],$advdate[$b],$details[$b],$desc[$b]);
        }
    }

Here is a test I created on my server which loads the database, sorts it by $categ and then by $name in ascending order.

You can view this sample by going to

http://www.inlandpac.com/clients/misc/multisort.php

Then by going to

http://www.inlandpac.com/clients/misc/multisort.php?cat=computers

(and so on)

Code:

<html>
<head>
	<title>Untitled</title>
</head>

<body>
<?php
    $cartFile = @implode(&quot;&quot;,@file(&quot;/home/ipacdev/inlandpac-[URL unfurl="true"]www/clients/misc/dbase.txt&quot;));[/URL]

    $lines = split(&quot;\n&quot;,$cartFile);

    for($a=0;$a<count($lines);$a++) {
        $data = split(&quot;\|&quot;,$lines[$a]);

        $categ[$a] = $data[0];
        $name[$a] = $data[1];
        $type[$a] = $data[2];
        $id[$a] = $data[3];
        $options[$a] = $data[4];
        $price[$a] = $data[5];
        $normpr[$a] = $data[6];
        $img[$a] = $data[7];
        $stockop[$a] = $data[8];
        $advdate[$a] = $data[9];
        $details[$a] = $data[10];
        $desc[$a] = $data[11];    

    }

    /*
      SORT_ASC can also be SORT_DESC
      SORT_STRING can also be SORT_REGULAR, SORT_NUMERIC, or SORT_REGULAR 
    */
    array_multisort ($categ, SORT_ASC, SORT_STRING, $name, SORT_ASC, SORT_STRING, $type, $id, $options, $price, $normpr, $img, $stockop, $advdate, $details, $desc);


	for($b=0;$b<count($categ);$b++) {
        if((trim($cat) == &quot;&quot;)||($categ[$b] == $cat)) {
            echo &quot;$categ[$b], $name[$b], $type[$b], $id[$b], $options[$b], $price[$b], $normpr[$b], $img[$b], $stockop[$b], $advdate[$b], $details[$b], $desc[$b]<br>\n&quot;;
        }
    }
?>
</body>
</html>

ICQ: 54380631

inlandpac · Aug 11, 2001

oh yeah, also in my sample at the urls provided, you can enter a categor that does not exist (such as ?cat=fdasfds) and you will get a nice little oops error.

This is done by using the in_array() function:

Code:

for($b=0;$b<count($categ);$b++) {
    if((trim($cat) == &quot;&quot;)||($categ[$b] == $cat)) {
        echo &quot;$categ[$b], $name[$b], $type[$b], $id[$b], $options[$b], $price[$b], $normpr[$b], $img[$b], $stockop[$b], $advdate[$b], $details[$b], $desc[$b]<br>\n&quot;;
    }
}
if(!in_array($cat,$categ)) {
    echo &quot;OOPS, CATEGORY $cat NOT FOUND!\n&quot;;
}

ICQ: 54380631

CONphuzed · Aug 11, 2001

Thanks!!! I'll try it today. I really appreciate your help

Its confusing to work out all this stuff as a beginner.

CONphuzed · Aug 11, 2001

Okay, I've tried and now I am getting a parse error? I've pasted the code below.

Also, I noticed that you changed displayProd()to echo "".
Is this necessary? I use this function to display the results of each product. It is in lib.php (see the call for it in the code above) The code for displayProd -not yet cleansed with {}'s is at the bottom of this post.

$cartFile = @implode("",@file("dbase.txt&quot

);
$lines = split("\n",$cartFile);

for($a=0;$a<count($lines);$a++) {
$data = split("\|",$lines[$a]);

$categ[$a] = $data[0];
$name[$a] = $data[1];
$type[$a] = $data[2];
$id[$a] = $data[3];
$options[$a] = $data[4];
$price[$a] = $data[5];
$normpr[$a] = $data[6];
$img[$a] = $data[7];
$stockop[$a] = $data[8];
$advdate[$a] = $data[9];
$details[$a] = $data[10];
$desc[$a] = $data[11];
}

/*
SORT_ASC can also be SORT_DESC
SORT_STRING can also be SORT_REGULAR, SORT_NUMERIC, or SORT_REGULAR
*/
array_multisort ($categ, SORT_ASC, SORT_STRING, $name, SORT_ASC, SORT_STRING, $type, $id, $options, $price, $normpr, $img, $stockop, $advdate, $details, $desc);

for($b=0;$b<count($categ);$b++) {
if((trim($cat) == "&quot

||($categ[$b] == $cat)) {
echo "$categ[$b], $name[$b], $type[$b], $id[$b], $options[$b], $price[$b], $normpr[$b], $img[$b], $stockop[$b], $advdate[$b], $details[$b], $desc[$b]<br>\n";
}
}

?>
</form>

<?php dispFooter(); ?>

<?php
if(file_exists("footer.php&quot

) {
include("footer.php&quot

;
}
?>

</body>
</html>

function displayProd ($categ,$type,$id,$name,$options,$price,$normpr,$img,$stockop,$advdate,$details,$desc) {

include("vars.php&quot

;

echo "<P><table>
<tr>";

if ($img != "&quot

:

echo "<td valign=\"top\"><img src=\"images/$img\" border=\"0\"></td><td width=\"30\"></td>";

if ($details != "&quot

:

echo "<p><font size=\"1\"><center><a href=\"$details\">Click for more details</a>";

endif;

endif;

inlandpac · Aug 11, 2001

Well, from the code above, which looks like there is a lot missing, I will not be able to tell you where the error lies. There error could be in one of your functions that are contained in your includes.

If you feel comfortable with this, you can go ahead and send me the files that are used in this script (all subordinates as well). If you do send them to me, make sure to remove any usernames, passwords, etc. for your protection. This is probably something I can fix in no time.

Chad. ICQ: 54380631

CONphuzed · Aug 11, 2001

No problem, where shall I send it? I looked on your page and I didn't see an e-mail address.

Its actually not that much code, 3 files really index, vars, and lib are what make it run.

inlandpac · Aug 11, 2001

send it to chorton@inlandpac.com ICQ: 54380631

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

sorting a pipe delim array?

CONphuzed

Instructor

inlandpac

Programmer

CONphuzed

Instructor

inlandpac

Programmer

CONphuzed

Instructor

inlandpac

Programmer

inlandpac

Programmer

CONphuzed

Instructor

CONphuzed

Instructor

inlandpac

Programmer

CONphuzed

Instructor

inlandpac

Programmer

Similar threads

Part and Inventory Search

Sponsor