[PHP] Sort function

[kito2]

Hey there, Im using modern AAC but the sort function isnt working :S

Actually it looks like this:

echo "<b>Sort by </b> &nbsp; <select name='sort'>";
echo "<option  value=''>None</option>";
echo "<option ".set_select('sort', 'level')." value='level'>Level</option>";
echo "<option ".set_select('sort', 'Vocation')." value='Vocation'>Profession</option>";
echo "<option ".set_select('sort', 'name')." value='name'>Name</option>";
echo "</select>";
echo "&nbsp; <input type='submit' value='Order'>";
echo "</form>";
 
echo "</form>";
if(count($players) > 0) {
	echo "<table width='100%'>";
	echo

But when you submite the sort selection, it doesn't sort the players... Any one could give me a working example on how to sort them?

 

[Cykotitan]

you sort them in the query with ORDER BY, set_select is only for selecting the used dropdown option

 

[kito2]

Thanks, and why this doesn't work:

$ide = new IDE;
	try { $ide->loadInjections("players_online"); } catch(Exception $e) { error($e->getMessage()); }
echo form_open("character/online", array('method'=>'POST'));
if(count($config['worlds']) > 1) {
	echo "<b>World </b> &nbsp; <select name='world'>";
	echo "<option value=''>All</option>";
	foreach($config['worlds'] as $key=>$value) {
		echo "<option ".set_select('world', $key)." value='$key'>$value</option>";
	}
	echo "</select>&nbsp; &nbsp;";
	
}
echo "<b>Ordenar por: </b> &nbsp; <select name='sort'>";
echo "<option  value=''>None</option>";
echo "<option ".set_select('sort', 'level')." value='level'>Level</option>";
echo "<option ".set_select('sort', 'vocation')." value='vocation'>Profession</option>";
echo "<option ".set_select('sort', 'name')." value='name'>Name</option>";
echo "</select>";
echo "&nbsp; <input type='submit' value='sort'>";
echo "</form>";

Since it checks the new ide and return the players sorted?

 

[Chris]

You would have to share the players_online injection for further assistance.

 

[kito2]

Maybe more simple... I want to do something like this:

echo '<div class="message"><div class="title">Who is Online</div></div>';
echo "<b>Sort by </b> &nbsp; <select name='sort'>";
echo "<option  value=''>None</option>";
echo "<option ".set_select('sort', 'level')." value='level'>Level</option>";
echo "<option ".set_select('sort', 'Vocation')." value='Vocation'>Profession</option>";
echo "<option ".set_select('sort', 'name')." value='name'>Name</option>";
echo "</select>";
echo "&nbsp; <input type='submit' value='Order'>";
echo "</form><hr>";

echo "</form>";

$players = "SELECT * FROM  `players` WHERE  `online` = 1 SOME HOW PUT SET_SELECT";
$players = $SQL->query($players)->fetchAll();
foreach($players as $player) {
		...
	}

Check the SOME HOW PUT SET_SELECT part.

 

[Chris]

I suppose this should do the trick...

$allowed_sorts = array(
    'level'    => 'ORDER BY experience DESC',
    'vocation' => 'ORDER BY vocation_id ASC',
    'name'     => 'ORDER BY name ASC',
);

$sort_post = strtolower($_POST['sort']);
$sort = isset($sort_post, $allowed_sorts[$sort_post]) ? $allowed_sorts[$sort_post] : $allowed_sorts['name'];

$players = "SELECT * FROM  `players` WHERE  `online` = 1 {$sort}";

 

[kito2]

A PHP Error was encountered

Severity: Notice

Message: Undefined index: sort

Filename: views/online_players.php

Line Number: 177