Learn VBA & Macros in 1 Week!

PHP - Sorting An Upvoting System

Full Excel VBA Course - Beginner to Expert

Sorting An Upvoting System	View Content

Hey I'm trying to do an up voting system kinda like reddit. So I got my table with upvotes and downvotes. The hiccup is when i want to echo all the entries in my table but I want these being sorted by effective votes. So basically if an entry has 250 upvotes and 30 downvotes and the second entry has 250 upvotes and 2 downvotes the second one should be echoed first. I know how to echo all the rows of my table I just don't know how to sort them via effectives votes. I'm not sure how I should proceed. Any help to get started would be welcome.
Edited by activee, 20 May 2014 - 04:07 AM.

Full Excel VBA Course - Beginner to Expert

Understanding Mvc Sorting System

Similar Tutorials

View Content

I want to start a new project, before I do so I would like to understand the MVC sorting system better, I do call it a sorting system because I mainly want to use it to sort my php files, I hope this is not the wrong approach.(?)

I am simply asking to get a clarification, the way I understood MVC is, that you do put all your "business logic" into Model, for example:

form_script.php

While you do put your "input logic" into Controller, for example:

form_form.php

And you do put your "UI logic" into View, for example:

article_about_my_travel.php

Is this the right way to understand MVC, and after all the right way to use it with PHP ?

Similar Tags In A Tags Sorting System

Similar Tutorials

View Content

I am asking out of curiosity, how does this problem usually get solved, when using a tag system to sort content, and users enter similar tags.

For example:

flower and flowers...

which means the difference between singular and plural. Judging by other sites which are around, this problem is not solved at all, they simply let you add as many tags as you want and then rank the most used tags, it indeed is a solution, but seems more like a walk-around solution to me.

Any ideas how somebody could approach to solve this one?

EDIT:

My suggestion would be an analysis function, which analyzes the entered tag and then suggests the user that similar tags have been already entered and perhaps he wants to choose one of those which have been already entered. This does work though with a high traffic websites what can happen is the following:

php and php5

You can end up with two similar tags which are both widely used though have different meanings to the user base.

This one could be solved by simply prohibiting similar tags with little additions or changes, and so to speak "forcing" the user to choose something which is already there. May be a way, though it can turn out as a bad solution as well.

Php On A Wamp-system On My Opensuse 11.4 System - Permissions-question

Similar Tutorials

View Content

hello dear PHP-Fans - greetings to you - and a happy new year!!

i set up a WAMP-System on my openSuse 11.4 system. In order to learn as much as i can bout PHP i want to do some tests and write some scripts.

Well the WAMP is allready up and running. Now i try to give the writing access to the folder

mkdir /srv/www/

where the php-scripts should go in...

i want to give write permission to all to all files in /srv/www

As root I generally:

mkdir /srv/www/
chown <webmaster usrername> /srv/www/

/srv/www/ should be readable and traversable by all, but only writeable by it's owner (the user designated as the webmaster.)

can i do this like mentioned above,...

Love to hear from you

greetings
db1

Sorting By Day

Similar Tutorials

View Content

i need to sort my database results by the day they were added to the database. There is a column with the timestamp of when they were inserted but how do i group them by the day they were inserted so i can display them as such:

Mon 14th: 5 records
Tues 15th: 11 records

etc.

Sorting

Similar Tutorials

View Content

Just a further question from a earlier post that was complete if i do a search and i want to order them from a drop box the if statement would it just look like
Quote

"select * from Table order by '".$_POST['order']."'"

Or would this not work ?

Thanx

Need Help Sorting...

Similar Tutorials

View Content

I have a situation where I need to sort files on a screen based on the date that is embedded into the file name. The problem is that I am sorting based off the file name, and when I get my output the LEGACY file always comes out on top of the sort because it starts with a 0 meanwhile the rest have dates appended the the filename so I don't have a problem sorting those.

Please help me if you can.
<?
//Special case for extra files
IF($Recordmyrow['App'] == "(Printable)")
{
$display = false;
$column3 = "Printable VER";
IF($securityvalue == "P")
{
 if(substr($path, 0, 5) == "file:")
 {
 $filename = substr($path, 5);
 if(file_exists($filename))
 {
$basename = substr($filename, 0, strrpos($filename, '.'));
$ext = ".pdf";
$allfiles = glob("{$basename}*.pdf");
rsort($allfiles, SORT_NUMERIC);

 foreach($allfiles as $file)
 {
 if($ext == ".pdf")
 {
 $column4 = "<a href=\"pdf.php?src={$file}\">VIEW</a> \n";
 $codate = substr($file, 70, 8);
 $co = substr($file, 59, 1);
 if ($codate != "pdf")
 {
 $column3 = "Printable File - ".$codate;
 }
 elseif ($codate == "pdf")
 {
 $column3 = "Printable File - LEGACY";
 }

 IF($lastGroup != $Recordmyrow['Grouping'])
{
$lastGroup = $Recordmyrow['Grouping'];
?>
<TR>
<TD colspan="4" align="center" bgcolor="#418765"><? echo $Recordmyrow['Grouping'] ?></TD>
</TR>
<?
}

 ?>

<TR>
<TD class="display" align="center" bgcolor="<?=changeColor($rowcount)?>"><? echo $column1 ?></TD>
<TD class="display" bgcolor="<?=changeColor($rowcount)?>"><? echo $column2 ?></TD>
<TD class="display" bgcolor="<?=changeColor($rowcount)?>"><? echo $column3 ?></TD>
<TD class="display" bgcolor="<?=changeColor($rowcount)?>" align="center"><? echo $column4 ?></TD>
</TR>
<?
$rowcount++;
 }
 }
 }
 else
 {
 $column4 = "Not Available";
 ?>
<TR>
<TD class="display" align="center" bgcolor="<?=changeColor($rowcount)?>"><? echo $column1 ?></TD>
<TD class="display" bgcolor="<?=changeColor($rowcount)?>"><? echo $column2 ?></TD>
<TD class="display" bgcolor="<?=changeColor($rowcount)?>"><? echo $column3 ?></TD>
<TD class="display" bgcolor="<?=changeColor($rowcount)?>" align="center"><? echo $column4 ?></TD>
</TR>
<?
$rowcount++;
 }
 }
}



}

Sorting

Similar Tutorials

View Content

I have an array like this:

$array[$row] = array (
    'name' = $name,
    'discount' = $discount,
    'price' = $price
);

Now, I have about 200 of those in that array, and im trying to sort by the discount, highest 1st. How would I go about doing that? Thanks.

Php Sorting

Similar Tutorials

View Content

Hello. I have a multi dimensional array that needs to be sorted. Array top25 [index][product id][number_of_purchases]. The index will contain a unique number for each product id. First product will be 1, second product will be 2, etc. The product id will be a id number like 34324ac9a89. The number of purchases will be how many times the item has been purchased.

- End result: I want to print the 25 most purchased products in this format.

product id - number of purchases

a39acz - 503
a8cz9c - 480
zc8ac - 392

How do I do this? Thanks

Sorting

Similar Tutorials

View Content

Part of my code:

Code: [Select]
<?php

$arr = array ("Christina", "Daniel", "Andreea);
reset($arr);

foreach ($arr as $username) {

//more code here ...

foreach ($stats as $result)
{
echo $username."'s points - ".$result." ";
}

}

?>

And gives this:
Code: [Select]
Christina's points - 14
Daniel's points - 45
Andreea's points 23

My question is: can you sort the the $result so it will show

Code: [Select]
Daniel's points - 45
Andreea's points 23
Christina's points - 14

Thank you

Sorting An Array...

Similar Tutorials

View Content

Hi - I'm modifying some PHP code that someone else wrote. Below is a snippet of code that basically takes mp3 files files within all the folders in a directory, and creates an RSS feed. In the resulting feed, the files are intermingled in date order.

Instead, I'd like them sorted by the directory that they are in. So, if there are files in these directories:

01-First
02-Second
03-Third

I'd like all the files in the "01-First" directory to come before the "02-Second" directory and so on. Within each directory the files can be sorted as they currently are. The name of the directory in the code is signified by $dir_name.

I tried sort() and array_multisort() but I couldn't get either of them to work the way I wanted. Any thoughts?

if ($url_params['mode'] == 'rss2') {

print getRSSHeader('UTF-8', $device, $vm_config, $vm_name, $web_master, $logo_image,$context);
 $mailboxes = array();
if ($dev_dir = @opendir($VMHome . $device)) { //might fail if mailbox has not received first message yet
while ($f = readdir($dev_dir)) {
 if (!eregi("tmp","$f") && !eregi("\.+","$f") && !eregi("Exclude-From-CD", "$f")) { //skip tmp directory and Exclude-From-CD Directories
 array_push($mailboxes,"$f"); #collect all existing mailboxes
 }
}
 array_multisort($mailboxes, SORT_DESC);
foreach ($mailboxes as $mailbox) {
$files=array();
$dir_name = $VMHome . $device . '/'. $mailbox .'/';
$dir = opendir($dir_name);
while ($f = readdir($dir)) {
if (eregi("\.txt",$f)){ #if filename matches .txt in the name
 array_push($files,"$f"); #push into $files array
}
}
foreach($files as $file){
 $props = getProperties($dir_name, $file);
 $uid = getMP3File($dir_name, $file, $props, $device, $mailbox, $vm_config, $vm_name,$context);
 print getRSSItem ($props, $uid, $dir_name, $device, '/' . $mailbox . '/', $context);
}
}
}
print '
</channel>
</rss>';
}

Need Help Sorting An Array - Please Help

Similar Tutorials

View Content

Sorting Via A Variable?

Similar Tutorials

View Content

Is it possible to sort a table of mysql data, by using a variable?

I'm trying this:

Code: [Select]
<?php

$result = mysql_query("SELECT * FROM members ORDER BY '$totalpower'");
 echo "<table border='1' cellpadding='10'>";
 echo "<tr>
<th>Rank</th>
<th>Username</th>
</tr>";

while($row = mysql_fetch_array($result))
 {

 echo "<tr>";
 echo '<td> </td>';
 echo '<td>' . $row['Username'] . '</td>';
 echo "</tr>";
 }
 echo "</table>";
?>
It display's a list of username's but not in the correct power order.

$totalpower is defined:

Code: [Select]
<?php

//power calculations

 $result = mysql_query("SELECT * FROM members WHERE Username='$_SESSION[Username]'")
 or die(mysql_error());
 while($row = mysql_fetch_array( $result )) {
 $power1 = $row['ounit1'] * 50;
$power2 = $row['ounit2'] * 70;
$power3 = $row['ounit3'] * 110;
$power4 = $row['ounit4'] * 200;
$power5 = $row['ounit5'] * 150;
$power6 = $row['ounit6'] * 300;
$power7 = $row['ounit7'] * 500;
$power8 = $row['ounit8'] * 450;
$power9 = $row['ounit9'] * 650;
$power10 = $row['ounit10'] * 350;
$power11 = $row['ounit11'] * 600;
$power12 = $row['ounit12'] * 1000;

$dpower1 = $row['dunit1'] * 50;
$dpower2 = $row['dunit2'] * 70;
$dpower3 = $row['dunit3'] * 110;
$dpower4 = $row['dunit4'] * 200;
$dpower5 = $row['dunit5'] * 150;
$dpower6 = $row['dunit6'] * 300;
$dpower7 = $row['dunit7'] * 500;
$dpower8 = $row['dunit8'] * 450;
$dpower9 = $row['dunit9'] * 650;
$dpower10 = $row['dunit10'] * 350;
$dpower11 = $row['dunit11'] * 600;
$dpower12 = $row['dunit12'] * 1000;

$dbase = $row['baselevel'] * 3000;
 }

$offencepower = $power1+$power2+$power3+$power4+$power5+$power6+$power7+$power8+$power9+$power10+$power11+$power12;
$defencepower = $dpower1+$dpower2+$dpower3+$dpower4+$dpower5+$dpower6+$dpower7+$dpower8+$dpower9+$dpower10+$dpower11+$dpower12+$dbase;
$totalpower = (($offencepower+$defencepower)/ 100 * 30) + $offencepower+$defencepower;

?>
Also how do I add auto numbers in the left column e.g 1. 2. 3. 4.

Thanks in advance.

Sorting Simplexml

Similar Tutorials

View Content

Hello,

Hope somebody can help me.
I have an XML file that is generated by active directory that dumps everything required for a telephone directory.
I currently present this using XSL but would like to move towards PHP.

I have some rudimentary code and it's working fine but I'd like to be able to sort by various values, such as First Name or telephone number.

My XML format looks like this:

Code: [Select]
<?xml version="1.0" encoding="UTF-8"?>
<telephonelist>
<employee>
<firstname>Jimmy</firstname>
<lastname>Jimmerson</lastname>
<email>jimbo@companyxyz.com</email>
<extensionnum>956</extensionnum>
<jobtitle>Security Officer</jobtitle>
<department>Security</department>
</employee>
<employee>
<firstname>David</firstname>
<lastname>Davidson</lastname>
<email>David.Davidson@companyxyz.com</email>
<extensionnum>968</extensionnum>
<jobtitle>Manager</jobtitle>
<department>Management</department>
</employee>
Any my current code looks like this:

Code: [Select]
<?
$myStaffMembers = new SimpleXMLElement("includes/telephonelist.xml", null, true);

echo <<<EOF
<table width="95%" border="0">
<tr>
<th>First Name</th>
<th>Last Name</th>
<th>Telephone Number</th>
<th>Position</th>
</tr>
EOF;

foreach($myStaffMembers as $myStaffMember)
{
echo "
<tr>
<td>{$myStaffMember->firstname}</td>
<td>{$myStaffMember->lastname}</td>
<td>{$myStaffMember->extensionnum}</td>
<td>{$myStaffMember->jobtitle}</td>
</tr>";
}
?>
Appreciate any help anybody could give.

Thanks,
LJ

Better Way Of Sorting Data

Similar Tutorials

View Content

I'm attempting to create a SQL command that can sort through a concatenated string in my database it is listed at Colors: blue,red,green,yellow is SELECT * FROM `shoes` WHERE CONCAT(',',color,',') LIKE '%,blue,red%' How do I filter the data where it can come up with shoes that are available in red or blue or red and blue and so on? I could use where find_in_set('blue', colors) > 0 and find_in_set('red', colors) > 0 Is there a better way of doing this? Shoe name: shoe A
Shoe size: 7,8,9 Shoe color: black , brown, grey

For example could have a shoe available in black , size 8 or 9 or 8 and 9.

Function Sorting

Similar Tutorials

View Content

I need to sort this:

Code: [Select]
customVar($var1, $var2, $var3);
I have tried:

Code: [Select]
sort(customVar($var1, $var2, $var3));

Php Array Sorting

Similar Tutorials

View Content

i have an array from a database that looks like this (below) but what i want is for the array to be sorted assedningly by the start position

so the team with start position 1 will be 1st and so on...if anyone can help me on what i should do please...thank you

Code: [Select]
Array
(
[1] => Array
(
[team_name] => A Team
[team_nationality] => British
[start_position] => 2
)

[2] => Array
(
[team_name] => B Team
[team_nationality] => British
[start_position] => 1
)
[3] => Array
(
[team_name] => C Team
[team_nationality] => British
[start_position] => 4
)

[4] => Array
(
[team_name] => B Team
[team_nationality] => British
[start_position] => 3
)

)

Moved: Smf 2.0 Sorting

Similar Tutorials

View Content

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=317320.0

Sorting Array

Similar Tutorials

View Content

I have an array that looks like this...

Code: [Select]
Array (
[0] => Array ( [0] => 2 [1] => Dylan Cross )
[1] => Array ( [0] => 5 [1] => Bob Smith )
[2] => Array ( [0] => 1 [1] => Sarah Park )
[3] => Array ( [0] => 7 [1] => Jane Knowles )
[4] => Array ( [0] => 6 [1] => Harry Hill )
[5] => Array ( [0] => 3 [1] => Jack Rock )
)

How do I sort this array so it is ordered alphabetically by the names so the result will be...

Code: [Select]
Array (
[0] => Array ( [0] => 5 [1] => Bob Smith )
[1] => Array ( [0] => 2 [1] => Dylan Cross )
[2] => Array ( [0] => 6 [1] => Harry Hill )
[3] => Array ( [0] => 3 [1] => Jack Rock )
[4] => Array ( [0] => 7 [1] => Jane Knowles )
[5] => Array ( [0] => 1 [1] => Sarah Park )
)

Thanks

Sorting List In Php

Similar Tutorials

View Content

Hi! I have this problem that I have to solve in PHP. I have such a difficult with this programming and I would be so grateful if someone could help me solve this. The problem: A lecturer has a group of students who need to be assigned to one of two groups for the

Sorting Php Table

Similar Tutorials

View Content

Here is the code:
Code: [Select]
<table class="sortable">
<?php
 while($row = mysql_fetch_array($result))
 { $title = $row["Rim"];
 $model = $row["model"];
 $dimenzija = $row["Dimenzija"];
 $ime = $row['name'];
 $cena = $row['price'];
 $cena = number_format($cena, 2, ',', '.');
 $id = $row['product_id'];

 if($i == 0)
 echo "<tr>";
 echo "<td>" ?><a href="index.php?route=product/product&product_id=<?php echo $id?>"><?php echo $model ?></a>
<?php echo " $dimenzija $ime "; ?>
<?php echo $cena . "din"?> 
<?php echo "</td>";
 if(++$i == $max_columns)
 {
 echo "</tr>";
 $i=0;
 } }}
 if($i > 0)
{
 for($j=$i; $j<$max_columns;$j++) echo "<td> </td>";
 echo "</tr>";
}
$prev = $start - $per_page;
$next = $start + $per_page;

 if (!($start<=0)){
echo "<a href='{$_SERVER['PHP_SELF']}&start=$prev'>Prethodna strana </a>";
}
$page = 1;

for($x=0;$x<$record_count;$x=$x+$per_page){
if($start != $x){
echo " <a href='{$_SERVER['PHP_SELF']}&start=$x'> $page </a> ";}
else{
echo " <a href='{$_SERVER['PHP_SELF']}&start=$x'> $page </a> ";}
$page++;
}

 if (!($start>=$record_count - $per_page)){
 echo "<a href='{$_SERVER['PHP_SELF']}?route=product/search&start=$next'> Sledeća strana</a>";

}
?>
</table>
How can i create sorting button? Is it possible to do it without javascript (I am new to PHP and JS is still unknown to me)?