PHP - Listing Mysql Table In Reverse

Hi,

I have a little problem that I can't seem to solve myself. My coding skills are very limited, just wanted to mention that  .

I have a list of rows, bascially banners that members submit. They have to be manually approved by me before they are put on air. So to quicken up
this process I made this little code in my admin panel.


$bq = mysql_query("SELECT id, usrid, bname, burl, btarget  FROM ban_rotator WHERE status = 'Waiting'");
$pb = mysql_num_rows($bq);
if ($_GET['ap']) 
{ 
$bid = $_GET['ap'];
  mysql_query("UPDATE ban_rotator SET status = 'Active' WHERE id = '$bid'");


It works perfectly except for one thing. It will always show the banner I just approved in addition to the remaining ones that are waiting. Any tips would be appreciated. I have to add that this code is a part of a fairly large admin panel php file.

Just realized i need a bit more explanation. If I hit refresh in the browser the one I just approved will be gone. As I would like it to be after hitting Approve on the banner in question. If I just approve the second banner (after approving the first), the first will be gone from the list of waiting and the second will still show until I either hit approve on the third or hit refresh in the brower.

Alka

Hi there im not quite sure how to do something and was wondering if anyone can help me, I am going to create a large database with lots of fields and these are going to be displayed on a page i want to limit it to 20 per page and be able to sort them aswell by ID (default) and then a-z or z-a, i dont know how to do this and i also need to know how to create the next previous and last and first links im guessing theres a count++ involved ? im not quite sure but anyway if someone can help it will be great.

Thanks,

Blink359

Hey, I am still learning PHP and all it's functions. So some of the coding may not be clean. But here is the script I made that I am having problems with:
Code: [Select]
<?php
// Adjust MySQL connection settings...
$username="newestfu_Dan";
$password = "camaro"; 
$hostname = "localhost"; 
$database = "newestfu_wowtrader";      

// Connect to MySQL...
$conn = mysql_connect($hostname, $username, $password)      or die("Connecting to MySQL failed");  
mysql_select_db($database, $conn)     or die("Selecting MySQL database failed"); 

// Run our query, see if session username exists in session field...
$sql="select username,email from user where username='{$_SESSION['user']}' limit 1";
$result=mysql_query($sql,$conn);

// Parse our results into $data (as an associative array)...
$data=mysql_fetch_assoc($result);

// If one row was found in the result set, username exists...
if (mysql_num_rows($result)==1) {
print "Welcome, {$data['username']}, your current email on file is: {$data['email']}";
echo "<br />";
$query="select seller,id,title from listings";
$queryresult=mysql_query($query,$conn);
$info=mysql_fetch_assoc($queryresult);
if ( $info['seller'] == $data['username'] ) {
echo "{$info['title']}";
}
else {
echo "You have no current auctions";
}  
// Otherwise...
}
else {
print "Sorry, the username {$_SESSION['username']} was not found in our database...";
}
?>
</body>
</html>

There are two queries going on. The first selects from the table "user" and gets the username depending on the user session and email. If one exists, it will go onto the next query to select from the table "listings" and gets seller, title, and id. It will then check if the username is equal to the seller. If it is, it will display the title. If not it displays otherwise. The problem is if the user has more than one title listed. But only 1 shows up. I'm guessing the line that has to change is Code: [Select]
echo "{$info['title']}";But I'm not to sure on what to change it to.
Thanks all for your help!

create table mimi (mimiId int(11) not null, mimiBody varchar(255) );
<?php
//connecting to database
include_once ('conn.php');
$sql ="SELECT mimiId, mimiBody FROM mimi";

$result = mysqli_query($conn, $sql );

$mimi = mysqli_fetch_assoc($result);

$mimiId ='<span>No: '.$mimi['mimiId'].'</span>';

$mimiBody ='<p class="leading text-justify">'.$mimi['mimiBody'].'</p>';
?>
//what is next?

i want to download pdf or text document after clicking button or link how to do that

Hello,

I need some help. Say that I have a list in my MySQL database that contains elements "A", "S", "C", "D" etc... Now, I want to generate an html table where these elements should be distributed in a random and unique way while leaving some entries of the table empty, see the picture below. But, I have no clue how to do this... Any hints?



Thanks in advance,
Vero

Hello everyone,

Sorry if this has been answered but if it has I can't find it anywhere. So, from the begining then.  Lets say I had a member table and in it I wanted to store what their top 3 interests are.  Their$ row has all the usual things to identify them userID and password etc.. and I had a further 3 columns which were labled top3_1 top3_2 & top3_3 to put each of their interests in from a post form.

If instead I wanted to store this data as a PHP Array instead (using 1 column instead of 3) is there a way to store it as readable data when you open the PHPmyadmin?

At the moment all it says is array and when I call it back to the browser (say on a page where they could review and update their interests) it displays 'a' as top3_01 'r' as top3_02 and 'r' as top3_03 (in each putting what would be 'array' as it appears in the table if there were 5 results. Does anyone know what I mean?

For example -

If we had a form which collected the top 3 interests to put in a table called users,

Code: [Select]
<form action="back_to_same_page_for_processing.php" method="post" enctype="multipart/form-data">
   
    <input name="top3_01" type="text" value="enter interest number 1 here" />
    <input name="top3_02" type="text" value="enter interest number 2 here" />
    <input name="top3_03" type="text" value="enter interest number 3 here" />
    <input type="submit" name="update_button" value=" Save and Update! " />

   
    </form> // If my quick code example for this form is not correct dont worry its not the point im getting at :)
And they put 'bowling' in top3_01, 'running' in top3_02 and 'diving' in top3_03 and we catch that on the same page with some PHP at the top -->

Code: [Select]
        if (isset($_POST)['update_button']) {
   
    $top3_01 = $_POST['top3_01']; // i.e, 'bowling' changing POST vars to local vars
    $top3_02 = $_POST['top3_02']; // i.e, 'running'
    $top3_03 = $_POST['top3_03']; // i.e, 'diving'

With me so far? If I had a table which had 3 columns (1 for each interest) I could put something like -

  Code: [Select]
   include('connect_msql.php');
   
    mysql_query("Select * FROM users WHERE id='$id' AND blah blah blah");
   
    mysql_query("UPDATE users SET top3_01='$top3_01', top3_02='$top3_02', top3_03='$top3_03' WHERE id='$id'");


And hopefully if ive got it right, it will put them each in their own little column. Easy enough huh? But heres the thing, I want to put all these into an array to be stored in the 1 column (say called 'top3') and whats more have them clearly readable in PHPmyadmin and editable from there yet still be able to be called back an rendered on page when requested.

Continuing the example then, assuming ive changed the table for the 'top3' column instead of individual colums,  I could put something like this -


Code: [Select]
            if (isset($_POST)['update_button']) {
       
        $top3_01 = $_POST['top3_01']; // i.e, 'bowling' changing POST vars to local vars
        $top3_02 = $_POST['top3_02']; // i.e, 'running'
        $top3_03 = $_POST['top3_03']; // i.e, 'diving'
   
    $top3_array = array($top3_01,$top3_02,$top3_03);
   
    include('connect_msql.php');
   
    mysql_query("UPDATE members SET top3='$top3_array' WHERE id='$id' AND blah blah blah");
But it will appear in the column as 'Array' and when its called for using a query it will render the literal string. a r r in each field instead.  Now I know you can use the 'serialize()' & 'unserialize()' funtcions but it makes the entry in the database practically unreadable. Is there a way to make it readable and editable without having to create a content management system?

If so please let me know and I'll be your friend forever, lol, ok maybe not but I'd really appreciate the help anyways.  The other thing is, If you can do this or something like it, how am I to add entries to that array to go back into the data base?

I hope ive explained myself enough here, but if not say so and I'll have another go.  Thanks very much people,  L-PLate (P.s if I sort this out on my own ill post it all here)

I have an array with dates as the key and then an integer for the value. So something like this

Quote

Array
(
    [6/2/2011] => 4
    [6/1/2011] => 3
    [6/4/2011] => 3
    [6/3/2011] => 2
    [6/6/2011] => 4
)


I'm trying to write a function that finds the highest value with max(); and then looks at the keys that have the highest value and then returns an array with the key as the most recent date and the value as the highest value. So in this case this function would return

Quote

Array
(

    [6/6/2011] => 4

)


does anybody have any suggestions on how i can accomplish this?

Hi, starting at a given node, I want to be able to build a pathway from that current node all the way to the root node.

Let's say I have this email.xml file:
<?xml version="1.0" encoding="ISO-8859-1" ?>
<email>
 <message>
  <to>
   <toFirstName>Bob</toFirstName>
   <toLastName type="common">Smith</toLastName>
  </to>
 </message>
</email>

Here is my script which btw is infinite loop:
Code: [Select]
<?php
$doc=new DOMDocument();
$doc->load("email.xml");
$pathway=array();
$dom1=$doc->getElementsByTagName("toLastName")->item(0);
while(!$dom1->documentElement->nodeName) {
$pathway[]=$dom1->nodeName."/".$dom1->parentNode->nodeName."/";
$strPathway=implode("",$pathway);
print $strPathway;
}
?>
The output I want is in this format:
email/message/to/toLastName (I will figure out how to use rsort since in the while loop it appends as: toLastName/to/message/email

Any help much appreciated!

I know I'm doing it something right, but can someone tell me why only one table is showing up? Can you help me fix the issue?

Heres my code:


function showcoords()
{
echo"J3st3r's CoordVision";
$result=dbquery("SELECT alliance, region, coordx, coordy FROM ".DB_COORDFUSION."");
dbarray($result);
$fields_num = mysql_num_fields($result);

echo "<table border='1'>";
// printing table headers


    echo "<td>Alliance</td>";
    echo "<td>Region</td>";
    echo "<td>Coord</td>";


// printing table rows
while($row = mysql_fetch_array($result))
{
    

    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
    foreach($row AS $Cell)
     echo "<tr>";     
     echo "<td>".$row['alliance']."</td>\n";
     echo "<td>".$row['region']."</td>\n";
     echo "<td>".$row['coordx'].",".$row['coordy']."</td>\n";
     echo "</tr>\n";
    
}
echo "</table>";
mysql_free_result($result);

}



I have 2 rows inserted into my coords table. Just frustrated and ignorant to php.

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,
My site was recently "hacked" in the sense that Google was made to crawl a rogue page and came to believe it was the original site. This caused a catastrophic decline in Google position and decline in traffic.

In researching the issue, it seemed that the solution was to install a forward-confirmed reverse DNS on the site.

Yet I've found little information on how to actually implement this.

I'm working on a code example I found, but I'm unsure exactly how to apply this even assuming I can get it to work.

For those interested in this issue  the original site is www.tickerfind.com , the duplicate site is www.handj.net. If you Google "tickerfind.com" you can get the cache, and from this you can see that Google thinks the site is found at handj.net.

One of the puzzling things about the sample code (http://smbrown.wordpress.com/2009/04/29/verify-googlebot-forward-reverse-dns/) is that it appears to be determining whether the bot is "good" or "bad", yet I thought the issue was not the bot itself but where it was retrieving the pages to scan. Somehow I thought it would be a "prevention of redirection" type code.

So first, I suppose my question is: Am I on the right track. And if so then I can dig into the code. But I'd certainly need to understand why it works.

Thanks,
Jeff

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

I posted this on stackoverflow, but no one wanted to touch it.   http://stackoverflow...rse-new-entries   I've tried array_push, but the results remain as SimpleXML, and not a plain array, which I wasn't able to use.  I tried some other things that I can't remember.

$feed_url = 'http://feeds.feedburner.com/SlickdealsnetFP?format=xml';
$contents = file_get_contents($feed_url);
$x = new SimpleXMLElement($contents);

$arrayFPTitle=array();

foreach($x->channel->item as $temp){
	array_push($arrayFPTitle, $temp->title);
}

Have any suggestions?... I've been on this problem for a few hours, now. I even tried regex, but you can imagine I quickly realized I wasn't going to figure that out.
Edited by icor1031, 18 September 2014 - 01:35 AM.

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!

I have a table like this:
http://empirebuildingsestate.com/company.html

How can I separate the table values into variables so I can insert them into my mySQL database?
I have been trying DOMDocument but i need some help.