排序关联数组

This has been asked before but the examples given have not worked for me.

I have an array with two keys

$miarray = array(
    array('factor' => $textof[1],    'valor' => $i1),
    array('factor' => $textof[2],    'valor' => $i2),
    array('factor' => $textof[3],    'valor' => $i3),
    array('factor' => $textof[4],    'valor' => $i4),
    array('factor' => $textof[5],    'valor' => $i5),
    array('factor' => $textof[6],    'valor' => $i6),
    array('factor' => $textof[7],    'valor' => $i7),
    array('factor' => $textof[8],    'valor' => $i8),
    array('factor' => $textof[9],    'valor' => $i9),
    array('factor' => $textof[10],    'valor' => $i10),
);

And if I go through the array I get the output in the original order

foreach ($miarray as $optionArray){ 
$pr .= "$optionArray[factor] - $optionArray[valor]<br>";
}

I need them to be sorted ascending according to the key 'valor' so i tried using usort

usort($miarray, 'sort_valor');

with the following function I found in the examples given.

function sort_valor($a, $b)
{
    $a = $a['valor'];
    $b = $b['valor'];

    if ($a == $b) return 0;
    return ($a < $b) ? -1 : 1;
}

but I get the following error

[20-Nov-2018 19:12:08 UTC] PHP Warning: usort() expects parameter 2 to be a valid callback, function 'sort_valor' not found or invalid function name in xxxxxxxxxxx

the following two files i use

<?php include("config.php"); ?>
<!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" dir="ltr" lang="en-US">

<head profile="http://gmpg.org/xfn/11">
<meta http-equiv="Content-Type" content="text/html; charset="iso-8859-1" />

<title>::: Clima :::</title>

<link rel="stylesheet" href="style2.css" type="text/css" media="screen" />
<link rel="stylesheet" type="text/css" href="hsd-flotr2.css" />

<link rel="icon" href="images/favicon.ico" />
<link rel="shortcut icon" href="images/favicon.ico" />

<script type="text/javascript" src="jquery-1.7.1.js"></script>
<script type="text/javascript" src="jquery.form.js"></script>

<script type="text/javascript" >
$(document).ready(function() {
        $('#encuesta').ajaxForm({
            target: '#preview',
            success: function() {
            $('#preview').fadeIn('slow');
            }
        });
        $("#encuesta").submit();
    });

function sort_valor($a, $b)
{
    $a = $a['valor'];
    $b = $b['valor'];

    if ($a == $b) return 0;
    return ($a < $b) ? -1 : 1;
}
</script>

</head>
<body>

<?php


include("header.php");
include("footer.php");

$db = mysql_connect($server,$user,$pass);
mysql_select_db($dbname,$db);


echo"<div id='page' class='clearfloat'>";
echo"<div id='sidebar'></div>";

echo"<div id='content' class='Absolute-Center'>";


//_______________________________resultados

echo"<div id='preview' style='margin-left:50px; height:530px;overflow:auto; float:left;'></div>";

//_______________________________formulario
echo"<div STYLE='float:left;'>";
echo"<form id='encuesta' method='post' action='analizar_3.php'>";
//_______________________________filtros

$f=1;
echo"<table>";
$result_3=mysql_query("SELECT DISTINCT tipo1 FROM filtros;");
while($row_3 = mysql_fetch_array($result_3)) {
echo"<tr><td>$row_3[0]</td></tr><tr><td><select id=f$f name=f$f>";

echo"<option value='0'>Todos</option>";

$result_4=mysql_query("SELECT id_filtros,tipo2 FROM filtros WHERE tipo1 = '$row_3[0]';");
while($row_4 = mysql_fetch_array($result_4)) {
$tt = substr($row_4[1],0,40);
echo"<option value='$row_4[0]'>$tt</option>";
}
echo"</select></td></tr>";
$f++;
}
echo"</table>";
//_______________________________filtros

echo"<input type=submit id='submit' value='Enviar'>";

echo"</form></div>";

echo"</div>";
echo"</div>";

mysql_close($db);
?>
</body>
</html>

and

<?php include("config.php"); ?>
<?php include("Includes/FusionCharts.php"); ?>
<?php


$db = mysql_connect($server,$user,$pass);
mysql_select_db($dbname,$db);

$pr = "";

$result_11=mysql_query("SELECT DISTINCT tipo1 FROM filtros;");
$za=1;
while($row_11 = mysql_fetch_array($result_11)) {
$filtro[$za] = $row_11[0];
$za++;
}

$result_1=mysql_query("SELECT DISTINCT tipo1 FROM filtros;");
$row_1 = mysql_num_rows($result_1);

for ($x=1; $x<=$row_1; $x++)
{
$aa = 'f'.$x;
$f[$x] = $_POST[$aa];

$total = $total + $f[$x];
}

$sql2 = "";

for ($x=1; $x<=$row_1; $x++)
{
$xx = $x + 1;
if ($f[$x] > 0) {$sql2 .= "AND $filtro[$x] = $f[$x] ";}

}

//____________________________________________________limite de afirmaciones por factor

$a=0;
$b=0;
$i=1;

$result_2=mysql_query("SELECT DISTINCT tipo1 FROM encuesta;");
while($row_2 = mysql_fetch_array($result_2)) {

$result_3=mysql_query("SELECT count(*) FROM encuesta WHERE tipo1 = '$row_2[0]';");
$row_3 = mysql_fetch_array($result_3);
$a = $b + 1;
$b = $a + $row_3[0] - 1;

$lim1[$i] = $a;
$lim2[$i] = $b;
$i++;
}

//____________________________________________________suma por pregunta

$result_4=mysql_query("SELECT DISTINCT hash FROM resultados2 WHERE id_resultados2 > 0 $sql2;");
$row_4 = mysql_num_rows($result_4);

$result_5=mysql_query("SELECT DISTINCT id_encuesta FROM encuesta;");
while($row_5 = mysql_fetch_array($result_5)) {

$j = $row_5[0];
$k ='a';
$kj = $k.$j;

$result_6=mysql_query("SELECT sum($kj) FROM resultados2 WHERE $kj != 6 $sql2;");

$row_6 = mysql_fetch_array($result_6);
$p[$j] = $row_6[0];

$result_7=mysql_query("SELECT count($kj) FROM resultados2 WHERE $kj = 6 $sql2;");
$row_7 = mysql_fetch_array($result_7);

$dif = $row_4 - $row_7[0];
if($dif == 0) {$dif = 1;}

$valafi[$j] = $p[$j] / $dif;

}

//____________________________________________________suma por factor


$result_11=mysql_query("SELECT DISTINCT tipo1 FROM encuesta;");
$row_11 = mysql_num_rows($result_11);

for ($x=1; $x<=$row_11; $x++)
{

for ($y=$lim1[$x]; $y<=$lim2[$x]; $y++)
{
$valfactor[$x] = $valfactor[$x] + $valafi[$y];
}

$valfactor[$x] = $valfactor[$x] / ($lim2[$x] - $lim1[$x] + 1);
}

//____________________________________________________indicador general

for ($x=1; $x<=$row_11; $x++)
{
$ind = $ind + $valfactor[$x];
}
if ($ind > 0) {$ind = $ind / 10; $ind = round($ind,2);}

//____________________________________________________grafico resumen

$result_10=mysql_query("SELECT * FROM factores;");
while($row_10 = mysql_fetch_array($result_10)) {
$f=$row_10[0];
$textof[$f] = $row_10[1];
}

$result_20 = mysql_query("SELECT * FROM resultados3 WHERE id_resultados3 > 0 $sql2;");
while($row_20 = mysql_fetch_array($result_20)) {

$multi = 100/10;
$startwert = 11;

$i1 = $i1 + (($startwert - $row_20[9]) * $multi);
$i2 = $i2 + (($startwert - $row_20[10]) * $multi);
$i3 = $i3 + (($startwert - $row_20[11]) * $multi);
$i4 = $i4 + (($startwert - $row_20[12]) * $multi);
$i5 = $i5 + (($startwert - $row_20[13]) * $multi);
$i6 = $i6 + (($startwert - $row_20[14]) * $multi);
$i7 = $i7 + (($startwert - $row_20[15]) * $multi);
$i8 = $i8 + (($startwert - $row_20[16]) * $multi);
$i9 = $i9 + (($startwert - $row_20[17]) * $multi);
$i10 = $i10 + (($startwert - $row_20[18]) * $multi);

}

$result_21 = mysql_query("SELECT * FROM resultados3 WHERE id_resultados3 > 0 $sql2;");
$row_21 = mysql_num_rows($result_21);

$i1 = $i1 / $row_21;
$i2 = $i2 / $row_21;
$i3 = $i3 / $row_21;
$i4 = $i4 / $row_21;
$i5 = $i5 / $row_21;
$i6 = $i6 / $row_21;
$i7 = $i7 / $row_21;
$i8 = $i8 / $row_21;
$i9 = $i9 / $row_21;
$i10 = $i10 / $row_21;

$i1 = round($i1,2);
$i2 = round($i2,2);
$i3 = round($i3,2);
$i4 = round($i4,2);
$i5 = round($i5,2);
$i6 = round($i6,2);
$i7 = round($i7,2);
$i8 = round($i8,2);
$i9 = round($i9,2);
$i10 = round($i10,2);

$miarray = array(
    array('factor' => $textof[1],    'valor' => $i1),
    array('factor' => $textof[2],    'valor' => $i2),
    array('factor' => $textof[3],    'valor' => $i3),
    array('factor' => $textof[4],    'valor' => $i4),
    array('factor' => $textof[5],    'valor' => $i5),
    array('factor' => $textof[6],    'valor' => $i6),
    array('factor' => $textof[7],    'valor' => $i7),
    array('factor' => $textof[8],    'valor' => $i8),
    array('factor' => $textof[9],    'valor' => $i9),
    array('factor' => $textof[10],    'valor' => $i10),
);

usort($miarray, 'sort_valor');

foreach ($miarray as $optionArray){ 
$pr .= "$optionArray[factor] - $optionArray[valor]<br>";
}

$pr .= "<a name='subir'></a><table><tr><td><label STYLE='font-size:24px;'>Resultados por Factores</label></td><tr>";
$pr .= "<tr><td>Número de encuestados afectos: $row_4</td></tr>";
if($row_4 >= 5) { 
$strXML  = "";
$strXML .= "<graph xAxisName='Factores' yAxisName='Evaluacion de los Factores' decimalPrecision='2' formatNumberScale='0' canvasBorderThickness='1' canvasBorderColor='114B78' showBarShadow='1' yAxisMaxValue='100' chartRightMargin='10' >";

for ($x=1; $x<=$row_11; $x++)
{
if($valfactor[$x] <= 60) {$colorf[$x] = "FF3100";} else {$colorf[$x] = "0031FF";}

$strXML .= "<set link='#ancla$x' name='$textof[$x]' value='$valfactor[$x]' color='$colorf[$x]' />";

}


$strXML .= "</graph>";
$pr .= "<tr><td>";
$pr .= renderChartHTML("FusionCharts/FCF_Bar2D.swf", "", $strXML, "myNext", 850, 420);
$pr .= "</td></tr>";

$pr .="<tr><td><div STYLE='width: 100%;height: 47px;border-bottom: 1px solid black;'></div></td></tr>";

$pr .="<tr><td><table>";
$pr .= "<tr><td><label STYLE='font-size:24px;'>El indicador de clima laboral es $ind</label></td></tr>";
$pr .= "<tr><td><br><br></td></tr>";

$pr .="</table></td></tr>";

//____________________________________________________Importancia
$pr .="<tr><td><div STYLE='width: 100%;height: 47px;border-bottom: 1px solid black;'></div></td></tr>";

$pr .= "<tr><td><table>";
$pr .= "<tr><td><label STYLE='font-size:24px;'>Importancia de los factores</label></td></tr>";
$pr .= "<tr><td>$textof[1] </td><td>$i1</td></tr>";
$pr .= "<tr><td>$textof[2]</td><td> $i2</td></tr>";
$pr .= "<tr><td>$textof[3] </td><td>$i3</td></tr>";
$pr .= "<tr><td>$textof[4] </td><td>$i4</td></tr>";
$pr .= "<tr><td>$textof[5] </td><td>$i5</td></tr>";
$pr .= "<tr><td>$textof[6] </td><td>$i6</td></tr>";
$pr .= "<tr><td>$textof[7] </td><td>$i7</td></tr>";
$pr .= "<tr><td>$textof[8] </td><td>$i8</td></tr>";
$pr .= "<tr><td>$textof[9] </td><td>$i9</td></tr>";
$pr .= "<tr><td>$textof[10] </td><td>$i10</td></tr>";
$pr .= "</table></td></tr>";

//____________________________________________________graficos por factor

$pr .="<tr><td><div STYLE='width: 100%;height: 47px;border-bottom: 1px solid black;'></div></td></tr>";

$result_9=mysql_query("SELECT * FROM encuesta;");
while($row_9 = mysql_fetch_array($result_9)) {
$f=$row_9[0];
$texto[$f] = $row_9[2];
}

$result_8=mysql_query("SELECT DISTINCT tipo1 FROM encuesta;");
$row_8 = mysql_num_rows($result_8);

for ($x=1; $x<=$row_8; $x++)
{
$pr .= "<tr><td STYLE='padding-top:25px;'><a name='ancla$x'></a>Factor $x: $textof[$x]</td></tr>";
$strXML  = "";
$strXML .= "<graph xAxisName='Afirmaciones' yAxisName='Evaluacion de los Factores' decimalPrecision='2' formatNumberScale='0' canvasBorderThickness='1' canvasBorderColor='114B78' showBarShadow='1' yAxisMaxValue='100' chartRightMargin='10' animation='0'>";

for ($y=$lim1[$x]; $y<=$lim2[$x]; $y++)
{
$gg = $y - $lim1[$x] +1;
if($valafi[$y] <= 60) {$color[$y] = "FF3100";} else {$color[$y] = "0031FF";}
$strXML .= "<set name='$gg' hoverText='$texto[$y]' value='$valafi[$y]' color='$color[$y]' />";
}
$height = 35 * ($lim2[$x] - $lim1[$x]);

if ($height < 350) {$height = 350;}

$strXML .= "</graph>";
$pr .= "<tr><td>";
$pr .= renderChartHTML("FusionCharts/FCF_Bar2D.swf", "", $strXML, "myNext", 850, $height);
$pr .= "</td></tr>";;
$pr .= "<tr><td><a href ='#subir'>Volver al resumen</a></td></tr>";
}

}

$pr .= "</table>";

$pr = utf8_encode ($pr);
echo $pr;

mysql_close($db);
?>

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
dsfew215211 2018-11-20 19:58
关注
The problem is your sort function is in the JavaScript portion of your code. Move it below the <?php tag in the file you'd like to reference it in (or include/require it from another PHP file).

本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

报告相同问题？

关注问题

合并和排序关联数组 php
2015-05-14 19:37

回答 4 已采纳 This should work for you: First of I use array_column() to get an array with the id's from the fi
对已排序的关联数组进行迭代 php
2019-06-11 08:52

回答 2 已采纳 I completely revamped your snippet. You can take whatever you want from below snippet, $array = [
合并，删除重复项并在php中排序关联数组 php
2015-10-08 04:51

回答 3 已采纳 The PHP-based solution could look something like this: //Define arrays for testing $array1[0]['id
PHP关联数组的10个操作技巧
2020-10-27 17:33

6、按键对数组排序：如果需要按键对关联数组进行排序，可以使用`ksort()`函数。这个函数会根据键，将数组元素按照键值的字母顺序进行排序： ```php ksort($capitals); ``` 7、随机数组排序：有时候需要随机排序数组...
PHP按元素大小/字符串大小排序关联数组的数组 php
2014-12-05 18:23

回答 2 已采纳 PHP >= 5.5.0 needed for array_column: array_multisort(array_map('strlen', array_column($some_a
按PHP中的值对多维关联数组进行排序 php
2017-06-27 20:06

回答 1 已采纳 The solution using uasort function: // $arr is your initial array uasort($arr['day_1'], function(
按特定键值排序关联数组 php
2014-06-17 21:06

回答 3 已采纳 Try this: function cmp ($a, $b) { return $a['Points'] < $b['Points'] ? 1 : -1; } usort($d
php关联数组快速排序的方法
2020-10-24 08:49

PHP的内置排序函数如sort()、asort()等无法直接应用于关联数组，但通过快速排序算法可以实现对关联数组按键或值进行排序。本文介绍的是一种通过函数封装实现关联数组快速排序的方法。首先，快速排序算法的基本思想...
在PHP 7中对关联数组进行排序[重复] php
2018-06-02 08:11

回答 2 已采纳 You can use usort $user1 = array('username' => 'test1', 'score' => 2000, 'someotherdata' =&
PHP关联数组排序 php
2010-06-02 12:21

回答 2 已采纳 You may want to implement your own sorting function, e.g.: function cmp($a, $b) { if ($a['Own
PHP JSON从关联数组STUCK中排序 json php
2015-12-04 17:09

回答 1 已采纳 To expand on my comment, here's what I'd do: $data = json_decode($json, true); //array_column: us
php 关联数组排序,PHP怎么给关联数组进行排序？（代码示例）
2021-04-12 14:21

sxtagz的博客本篇文章主要给大家介绍如何用PHP给关联数组进行排序。对于PHP学习者来说，数组是一个非常重要的知识点，所谓数组就是能够在单独的变量名中存储一个或多个值。索引数组即带有数字索引的数组，关联数组即带有指定键的...
php数字关联数组排序,php关联数组排序（快速排序）
2021-04-16 16:19

义之言的博客下面的文章里我会用c语言的思想提出两种php快速排序的解决方案：自己实现快速排序，用分治和归并的思想调用系统的usort，类似于c的qsort，感谢dickeylth的提醒使用环境和条件有这样一种情况，php里面的关联数组，...
php通过ksort()函数给关联数组按照键排序的方法
2020-12-19 15:38

除了`ksort()`和`krsort()`，PHP还提供了其他数组排序函数，如`asort()`（按值升序排序关联数组，保持键值对应关系）、`arsort()`（按值降序排序关联数组，保持键值对应关系）、`sort()`（按值升序排序索引数组）和`...
php一维关联数组排序,php关联数组排序的方法
2021-05-04 00:51

zqk666mkq~的博客这篇文章主要介绍了php关联数组快速排序的方法,涉及php数组排序的相关技巧,非常具有实用价值,需要的朋友可以参考下本文实例讲述了php关联数组快速排序的方法。分享给大家供大家参考。具体如下：...
没有解决我的问题, 去提问

悬赏问题

¥15 乌班图ip地址配置及远程SSH
¥15 怎么让点阵屏显示静态爱心，用keiluVision5写出让点阵屏显示静态爱心的代码，越快越好
¥15 PSPICE制作一个加法器
¥15 javaweb项目无法正常跳转
¥15 VMBox虚拟机无法访问
¥15 skd显示找不到头文件
¥15 机器视觉中图片中长度与真实长度的关系
¥15 fastreport table 怎么只让每页的最下面和最顶部有横线
¥15 java 的protected权限，问题在注释里
¥15 这个是哪里有问题啊？

排序关联数组

1条回答 默认 最新

悬赏问题

1条回答默认最新