PHP - Harder Question - Reverse Sql Entries

When you make a mysql query the results are always returned with the first being the first entry in the database.  I was wondering if there is a way to make it so that the last entry is returned first and so on?  Thanks for any help. 

Hi all, Need help in solving this task using PHP built in function : array_reverse() and without it. Appreciate it in explaining the code as I'm completely a newbie. 

function reverseArray($Arr) {
		
	 }
	 $fruits = ["Mango","Strawberry","Bananas","Pineapple"];
	 $result = reverseArray($fruits);

Many thanks, 

 

Hi all,


I have a MySQL table with the field 'number'.
When I SELECT * from that field, I get a return for the rows of 'number' in the order 1, 2, 3, 4, etc...
 

SELECT * FROM products;

Is there a way where I can get a return in the reverse order, so highest to lowest (4, 3, 2, 1, etc...)?
Edited by Phaelon, 13 May 2014 - 03:23 AM.

Hello All
New here and could use a bit of help.

Basically I have 2 separate functions that echo their results out in an html page.
My problem is the first function needs a value from the second function after it has run but needs to be echoed before the second for aesthetics.

Here's a bit of code to explain.
Code: [Select]
  <div class="bag"><br/><?php echo writeShoppingCart(); ?> </div>
<div id="contents">
<?php
echo showCart();
?>
</div>
So basically to work correctly I need showCart to finishing before calling writeShoppingCart()
I tried doing a redirect to the same page but it didn't like that.
Is there another way around this that I'm not aware of?
I suppose I could write a third function to get the value I need and call it before but I was hoping for a something a little cleaner.

Cheers

Hi folks...

Trying to get a bit of gallery code to work the way I want it to and would appreciate some feedback from more experienced folks...

What it's doing, or is supposed to be doing, is taking a thumb called 'thumb.jpg' from each folder within my gallery folder and displaying it in reverse order on a page. I only want a maximum number of images to display on the page at any one time, so that if I end up uploading loads of folders in the future, it will only display a set amount of thumbs on one page.

I want the thumbs displayed in reverse order, so that the newest appears first.

Here's the code... and as far as I can see, it should work... and I'm sure I have had it working in the past (I've just come back to working on it after a while) however now, it's putting the thumbs in a random order.

My folders are all in the gallery folder, and are named 001, 002, 003, 004, 005, 006, etc.
I want them to display with 006 at the top and to de-increment, but only for the most recent 16 folders.

Code: [Select]

<?php

$images = "gallery/"; # Location of galleries 
$cols   = 4; # Number of columns to display 
$max     = 16; # Maximum number of galleries to show

if ($handle = opendir($images)) { 
   while (false !== ($file = readdir($handle))) { 
       if ($file != "." && $file != "..") { 
           $files[] = $file; 
       } 
   } 
   closedir($handle); 
} 

$colCtr = 0; 

echo "<div id=\"updates\"><table><tr>"; 

$c = count($files) - 1; //$c = the number of files in the array, minus 1 = highest index in the array.
for($i = $c; $i > ($c - $max); $i--) //$i = $c, $i is greater than the array count minus $max, $i de-increments on each loop.  This will give us a countdown for the number of galleries required.
{ 
  if($colCtr %$cols == 0) 
    echo "</tr><tr>"; 
  echo "<td><img src=\"" . $images . $files[$i] . "/thumb.jpg\" width=\"240px\" height=\"180px\" alt=\"" . $alt . "\" /></td>"; //echo'ing out the $file[$i] on the loop, will give us the last required number of files in the file array.
  $colCtr++; 
} 

echo "</table></div>" . "\r\n"; 

?>


I also want to work out how to set a start number for the galleries, so that I can paginate them... so, once I have 36 galleries (for example) I can have the latest 16 on the first page, and the next 16 on the 2nd page... and the 4 that run over would drift off into obscurity until I get round to deleting them... maybe with a variable named $min... How would I do that...? Like this, or differently? :

Code: [Select]

<?php

$images = "gallery/"; # Location of galleries 
$cols   = 4; # Number of columns to display 
$min     = 16; # Minimum number of galleries to show
$max     = 32; # Maximum number of galleries to show

if ($handle = opendir($images)) { 
   while (false !== ($file = readdir($handle))) { 
       if ($file != "." && $file != "..") { 
           $files[] = $file; 
       } 
   } 
   closedir($handle); 
} 

$colCtr = 0; 

echo "<div id=\"updates\"><table><tr>"; 

$c = count($files) - 1; //$c = the number of files in the array, minus 1 = highest index in the array.
for($i = $c; ($i + $min) > ($c - $max); $i--) //$i = $c, $i plus $min is greater than the array count minus $max, $i de-increments on each loop.  This will give us a countdown for the number of galleries required.
{ 
  if($colCtr %$cols == 0) 
    echo "</tr><tr>"; 
  echo "<td><img src=\"" . $images . $files[$i] . "/thumb.jpg\" width=\"240px\" height=\"180px\" alt=\"" . $alt . "\" /></td>"; //echo'ing out the $file[$i] on the loop, will give us the last required number of files in the file array.
  $colCtr++; 
} 

echo "</table></div>" . "\r\n"; 

?>


Any help greatly appreciated!

This topic has been moved to Miscellaneous.

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

Below is the part of my code that creates the html table.  How do I add pagination every 30 entries?



$db = mysql_connect("localhost","trend_learnu","asdfasdf");
mysql_select_db("trend_learningdb",$db);

$result = mysql_query("SELECT * FROM Peoples ORDER BY number ASC");

$table = '<table width="608" border="0" align="center" cellpadding="10" cellspacing="0">
  <tr>
    <td style="color:#fff;" width="207" bgcolor="#425d74"><strong>Firstname</strong></td>
    <td style="color:#fff;" width="204" bgcolor="#425d74"><strong>Lastname</strong></td>
    <td style="color:#fff;" width="197" bgcolor="#425d74"><strong>Date</strong></td>
<td style="color:#fff;" width="197" bgcolor="#425d74"><strong>Weight</strong></td>
  </tr>';

while($row=mysql_fetch_array($result))
{
  $firstname = $row['Firstname'];
  $lastname = $row['Lastname'];
  $weight = $row['Weight'];
  $date = $row['Date'];

   $table.= '<tr>';
   $table.= '<td bgcolor="#e8f4ff">'.$firstname.'</td>';
   $table.= '<td bgcolor="#e8f4ff">'.$lastname.'</td>';
   $table.= '<td bgcolor="#e8f4ff">'.$date.'</td>';
   $table.= '<td bgcolor="#e0ffe6"><strong>'.$weight.'</strong></td>';
   $table.= '</tr>';
}
$table .= '</table>';

echo $table;



mysql_close($con)

the problem is that when I add an item to be displayed in the blog, shows three instead, which two are empty.
It should not create three entries when I just add one entry. How can I fix this?

<?PHP
/* define the blog content file name */
$filename = "myBlogContent.txt";
?>




<?php
/* check to see if the file exists */
if (!file_exists($filename)) {

echo "The Blog Is Empty";

}else{

/* get the file lines into an array */

$BlogArray = file($filename);

/* count the number of blog entries */
$count = count($BlogArray);

$i=0;

while($i<$count) {

$new_array = explode("|", $BlogArray[$i]);

echo "Posted by: " . $new_array[1] . "<br>";

echo "Posted on: " .  date("m/d/y h:iA", time($new_array[0])) . "<br>"
echo 

"Title: " . $new_array[2] . "<br>";


echo $new_array[3] . "<hr>";


$i ++;


}
}
?>





<?PHP
/* obtain the form data */
$who = $_POST['who'];
$title = $_POST['title'];
$content = $_POST['content'];
$content = str_replace(array("\r\n", "\r", "\n"), "<br>", $content); 

/* create timestamp variable for current date and time */
$when_ts = time(); 

/* define the blog content file name */
$filename = "myBlogContent.txt";

/* prepare the variables for adding to the file */

$new_line_content = $when_ts . "|" . $who . "|" . $title . "|" . $content . "\n";

/* open the file in the APPEND MODE */
$fh = fopen($filename, 'a+') or die("can't open file");

/* add the new content */
fwrite($fh, $new_line_content); 

/* close the file */
fclose($fh); 

 
//exit; // Closes further script execution . 
?>

Hi guys 

Im trying to delete multiple images from  a page with the code below, I have retirieved the images successfully but i can not delete the with checkbox,

wht it does is just refereshing the page and thats it, what im trying to do is to delete the image from the database but it wont.

can u help me please?

<?php
session_start();

include ("../../global.php");
//welcome messaage
$username=$_SESSION['username'];
echo "$username";

$query=mysql_query("SELECT id FROM users WHERE username='$username'");
while($row = mysql_fetch_assoc($query))
{
$user_id = $row['id'];
}

$ref=$_GET['reference'];


$images=mysql_query("SELECT * FROM img WHERE refimage='$ref'");

while($row = mysql_fetch_array($images))
{
$image=$row['image'];
$thumb=$row['thumb'];





?>

<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="" method="post" action=''>
<tr>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
<td bgcolor="#FFFFFF"><? echo "<a href='$image' rel='lightbox[roadtrip]'><img src= '$thumb' width='60' height='40' alt='$title'>";?></td>
<?
}
?>


<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>


<?php

// Check if delete button active, start this
$delete = $_REQUEST['delete'];
if( $delete != '' ){
$checkbox = $_REQUEST['checkbox'];
$count = count($_REQUEST['checkbox']);
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$del = mysql_query("DELETE FROM img WHERE id = '$del_id'");

}
}

?>

Code: [Select]
$query = mysql_query("SELECT a.*, b.*
         FROM friendlist a
INNER JOIN friendlist b
ON (a.friendemail=b.friendemail)
INNER JOIN users c
ON (b.friendemail = c.EmailAddress)
WHERE a.email = 'asdf@gmail.com'
AND c.Username LIKE '%carol%'
GROUP BY a.id
ORDER BY count(*) DESC");
Code: [Select]
while ($showfriends = mysql_fetch_array($query)) {
     echo $showfriends['Username'];
}
and I would get nothing. It produces the correct number of <div> so i know it's getting through, but it's having trouble displaying the entries?

Hello,

For starters I'm not sure if what I want to do is possible, but if it is I would like your input. I have a script that will show a number of fields to fill out in a second form based on the number the user puts into the first from. the problem is that only the last one saves into the database and not all of them.

Code: [Select]
<form auction="index.php" method="post">
System Name: <input type="text" name="systemname">
Number of E-sites: <input type="text" name="events">
Number of Sigs: <input type="text" name="sigs"><br>
<input type="reset" name="reset" value="Reset">
<input type="submit" name="start" value="Start">
</form>
<form auction="index.php" method="post">
<?php
$events = $_POST['events'];
$system = $POST['systemname'];

if (isset($_POST['start'])) {
$num = $_POST['sigs'];
$i = 0;
While ($i < $num)
{
echo "Sig ID: <input type=text name=sigid>";
echo "Type: <input type=text name=type>";
echo "Name: <input type=text name=name>";
echo "Notes: <input type=text name=notes>";
echo "<br>";
$i++;
}
}
?>
<input type="submit" name="enter" value="Enter">
</form>
<?php
$sigid = $_POST['sigid'];
$type = $_POST['type'];
$name = $_POST['name'];
$notes = $_POST['notes'];
mysql_connect('xt', 'x', 'x');
mysql_select_db('wormhole');
if (isset($_POST['enter'])) {

$query = "INSERT INTO sites VALUES ('$system','$events','$sigid','$type','$name','$notes')";
mysql_query($query);

}
?>
How do I get it so all the data saves, lets say that $num = 5, I want all 5 to save not just the last one.

I am quite new so I am sure this is an easy fix for some of the experts around here.

I am using the canned script below to add urls to the database as text.  The problem is if you update one of the form text boxes it loads all the urls into the database again resulting in a lot of duplicates.

My question is, How do I get the form to only post the new changes and not re-post the existing urls?


<?php
session_start();

   if(isset($_SESSION['userSession']) && !empty($_SESSION['userSession']))
   {
        include_once("dbc.php");

        if($_POST)
        {
            $c = 0;
            
            $errMssg = "";

            for($i=0;$i<count($_POST['url']);$i++)
            {
                if($_POST['url'][$i]=="")
                {
                    $c++;
                }
            }
            if($c==5)
            {
                $errMssg = "Submission error . Please fill at least 1 url.";
            }
            else
            {
                for($j=0;$j<count($_POST['url']);$j++)
                {
                    if(!empty($_POST['url'][$j]))
                    {
                        $sql = mysql_query("INSERT INTO images (id ,url ,user_id)VALUES (NULL , '".$_POST['url'][$j]."',".$_SESSION['userId'].")");    

                     }
                                    
                }
                
            }
        }    

        
        

        $sqlresult = mysql_query("SELECT * FROM images WHERE user_id =".$_SESSION['userId']);
        
        $count = 0;
            
        while($data = mysql_fetch_array($sqlresult))
        {
            $image[$count] = $data['url'];

            $count++;

        }
         
?>

I have an issue with some code I have.  All the code works correctly apart from when submit is clicked not only does it update a the current club but it creates a blank entry in the database!  I cant see whats wrong.  Here is the code.........



//gets
$validation = $_GET['new_club'];
//Querys
    $qGetClub = "SELECT * FROM clubs WHERE validationID = '$validation'"; 
$rGetClub = mysql_query($qGetClub);
$Club = mysql_fetch_array($rGetClub);
//Query for category by name
$qGetCat = "SELECT * FROM club_category WHERE catID = ".$Club['cat']."";
$rGetCat = mysql_query($qGetCat);
$CatName = mysql_fetch_array($rGetCat);
//query for related sub categorys.
$qGetSub = "SELECT * FROM sub_categorys WHERE catID =".$Club['cat']."";
$rSubCat = mysql_query($qGetSub);
// query for groups created
$Groupq = mysql_query("SELECT * FROM groups WHERE memberID = '".$User['memberID']."'");

//end of querys

if(isset($_POST['insert_clubbtn1'])){ 
//Process data for validation     
$subcat     = trim($_POST['subcat']);  
$NewSubCat = trim($_POST['NewSubCat']); 
//Prepare data for db insertion      
$subcat = mysql_real_escape_string($subcat); 
//find the new category 
//insert
$result = mysql_query("UPDATE clubs  SET 
`sub_category` = '$subcat'
WHERE validationID ='$validation'") or die(mysql_error());



if ($result!=="") {
$otherg = trim($_POST['other_groups']);
$newg = trim($_POST['new_group']);
$newg = mysql_real_escape_string($newg);     
//if an item other than none from the list is selected then update the club with an ID relating to the group it belongs to
if ($otherg !=='None') { $groupsq = mysql_query("UPDATE `clubs` SET groupID ='$otherg' WHERE validationID ='$validation'") or die (mysql_error()); }
// If none is selected then $newg must have a value so create a new group in the groups table and then on the next page I will add the group in the club table 
else {
$groupsq = mysql_query("INSERT INTO `groups` (`memberID`, `group`, `clubID`) VALUES ('".$User['memberID']."', '$newg', '".$Club['clubID']."')")or die (mysql_error());
}   }

if ($NewSubCat !="") { mail("mail","New Sub Category Request","Dear Ring Master,
\n\nThe club in the name of $name with a validation code of $validationID would like a new sub category called $new_cat\n\n  
\nTeam Arena\n\n\n\n"); }

$url = "/members/create/create_clubp3.php?new_club=$validation";  
header("Location: $url");     
}

Hello...
I have a .txt database with ~100 records.  I only want to show the 15 records that are at the top (referring to reading order of the file).
Here is my php code to display the records.
http://www.flcbranson.org/mobile.php?content=mobile-freedownloads.php if you want to see the results of the code, below.
Code: [Select]
<?php
$index_file = 'services/series/Index-Date.txt';
$fd = fopen($index_file, 'r');
if ($fd) {
        while (!feof ($fd)) {
                $seriestitle = trim(fgets($fd, 1024)); // Series Title
                if(feof ($fd))
                break;
                $seriessubtitle = trim(fgets($fd, 1024)); // Series subtitle
                $seriesinfo  = trim(fgets($fd, 1024)); // Series Info (Church name)
                $serieslocation = trim(fgets($fd, 1024)); // City, State
                $seriesindex = trim(fgets($fd, 1024)); // Series index file
                $seriesstatus = trim(fgets($fd, 1024)); //Online Only?
                $divider     = trim(fgets($fd, 1024)); // Divider
                $seriestitle2 = $seriestitle;
                $seriestitle3 = str_replace("'", "%27", $seriestitle); // Kind of makes the alt= below work "God's Will" ends up being "God%27s Will" but without is "God"
                if(strstr($seriestitle,"<")) {
                        $seriestitle2 = strip_tags($seriestitle);
                }
                $seriestitle2 = urlencode($seriestitle2);
                if(file_exists("images/ProductCovers/".substr($seriesindex,0,-4).".jpg")) {
                        echo "<img src='images/ProductCovers/".substr($seriesindex,0,-4).".jpg' width='115' height='150' border='0' alt='".substr($seriestitle3,7)."'><br />";
                }
        }
        fclose ($fd);
}
?>
I'm assuming that "for" would do the trick, but when I tried I got 10 copies of every record.
Hehehe...
I'm guessing that it's a quick fix.
Thanks...
JJ

Hello,
   Hopefully I can ger som help here I have been googling this for months and seem to cant find anything that will help me out.
I am trying to create a form (which is the easy part) but I want this form to send multiple entries at once from what I gather so far I need to use for each and/or loop which i am not familiar with it with my lack of knowledge........
what I have so far is
Table= locations
fields are
id
state
county
city

the form is set up as follows
state
county
city
city
city
city
city
city
city
city
city
city
city
city
The reason for so many cities is so i can update all cities in one county at the same time saving time I am not sure if its % doable in the manner i would like it to be done but i hope so

ok i enter the state and county
then i enter the cities i want
i submit the form i want it to create the state/county and the first city with the next id # then enter the state/county and next city and id#.


please some help me  if u need to see my file let me know and ill post it im just not sure which one you need i believe it will be the save.php file but i also have the create.php file which is the form itself
Thanks anyone for the help i can get