PHP - Results Not Showing In Browser?

I am writing a CRON job that will execute daily.  First it will identify from a MySql table the date in a field 'FAPforSale_repost35'  If the date is the today date it will then execute commands to delete photo images in a directory, delete the directory, and finally remove the record from the database.   I am on step one which is to build the array of records that match the days date.  When I run the code, there are no errors but I am not getting results even though the records in the test table are set for today.  Below is the select

<?php

 define( "DIR", "../zabp_employee_benefits_processor_filesSm/", true );
 
 require( '../zipconfig.php' );
 require( DIR . 'lib/db.class.php' );
 require_once( $_SERVER['DOCUMENT_ROOT'] . '/_ZABP_merchants/configRecognition.php' );
 require_once( $_SERVER['DOCUMENT_ROOT'] . '/_ZABP_merchants/libRecognition/MailClass.inc' );
 
 
 
$todayRepost35 = date("Y-m-d");
echo $todayRepost35;



function repostEndSelect()
 
      {
        
        global $db;
            
    $this->db = $db;
        
            
     $data = $this->db->searchQuery( "SELECT `FAPforSale_IDnumber`,  `FAPforSale_image1`,  `FAPforSale_image2`,  `FAPforSale_image3`,  `FAPforSale_repost35`  FROM  `FAP_forSaleTest` Where `FAPforSale_repost35` = '$todayRepost35' ");
    
    
         $this->FAPforSale_IDnumber = $data[0]['FAPforSale_IDnumber'];
        $this->FAPforSale_image1 = $data[0]['FAPforSale_image1'];
        $this->FAPforSale_image2 = $data[0]['FAPforSale_image2'];
        $this->FAPforSale_image3 = $data[0]['FAPforSale_image3'];
        $this->FAPforSale_repost35 = $data[0]['FAPforSale_repost35'];
        
        echo $this->FAPforSale_IDnumber;
        echo $this->FAPforSale_image1;
        echo $this->FAPforSale_image2;
        echo $this->FAPforSale_image3;
        echo $this->FAPforSale_repost35;
        
    } // ends function...
        
echo( ' Finished...' );

?>

Thanks in advance for any suggestions or direction.  Chapter two will be when I start testing the commands to delete.

Hi people.

I am creating a carpet website for a good friend of mine as a favour.  I am storing the carpets info in a MYSQL database and am currently trying to relay the info on a page.  I have the array kind of done but it is not producing the results I want.  Let me explain further:

The columns in my database under the table "carpets" a

id (auto incremented)
colour
type
title
price
description
imageloc

------

under the type I have various types of carpet (6-ish).  They a Twist, Striped etc etc...

Heres the php problem.


I have all the images there and ready on the page and want to link them all with linking commands. i.e:

the main page is at: http://www.ircdirect.co.uk/FTPServers/supremecarpets/index.php

the carpets results page is at: http://www.ircdirect.co.uk/FTPServers/supremecarpets/carpetlist.php

on the index.php page I want to link them so that for example:

If he looks for a striped carpet he clicks "striped" and is shows carpetlist.php but with the striped carpets displayed.

example link: <A HREF="carpetlist.php?type=striped">IMAGE HERE</A>

I have tried various coding on the carpetlist.php and cant seem to get it to work.

here is the snippets:

<?php
// Make a MySQL Connection
$query = "SELECT * FROM carpets GROUP BY type"; 
 
$result = mysql_query($query) or die(mysql_error());


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


echo "<TABLE CELLPADDING=0 CELLSPACING=0 WIDTH=100% />";

echo "<TR />";

echo "<TD WIDTH=23 /><IMG SRC=images/main/search/topleft.png /></TD />";

echo "<TD BACKGROUND=images/main/search/top.png /> </TD />";

echo "<TD WIDTH=23 /><IMG SRC=images/main/search/topright.png /></TD />";

echo "</TR />";

echo "<TR />";

echo "<TD BACKGROUND=images/main/search/left.png />";
echo " ";
echo "</TD />";

echo "<TD BACKGROUND=images/main/search/bg.png />";

echo "<FONT FACE=VERDANA SIZE=1 />";
echo $row['title'];

echo "</TD />";

echo "<TD BACKGROUND=images/main/search/right.png />";

echo " ";

echo "</TD />";

echo "</TR />";

echo "<TR />";

echo "<TD WIDTH=23 /><IMG SRC=images/main/search/bottomleft.png /></TD />";

echo "<TD BACKGROUND=images/main/search/top.png /> </TD />";

echo "<TD WIDTH=23 /><IMG SRC=images/main/search/bottomright.png /></TD />";

echo "</TR />";

echo "</TABLE />";

echo "<BR />";

}
?>

It displays ALL the results which is not what I want.  I want only striped carpets, blue carpets etc....

Help is needed and VERY much appreciated!

Kind Regards,
Ian

Our product is running on LAMP(PHP) architecture. For MySQL operation PDO library has been used.

We are in the process of moving the product to a new Linux server.
On the new server we are facing MySQL query output related issue. At the end of the post I have listed the server configuration details of both the servers and the sample PHP program with the output.

It works fine in server 1 but when the same code moved to Server 2, the output is not correct.

Would appreciate any points to solve this problem

The following piece of code is tested and output is also given.

<?php

/*** mysql hostname ***/
$hostname = 'localhost';

/*** mysql username ***/
$username = 'ram';

/*** mysql password ***/
$password = 'tellmehow';

try {
       $dbh = new PDO("mysql:host=$hostname;dbname=inhouse", $username, $password);

       $sql = "SELECT first_name,last_name,user_id,email FROM users LIMIT 1";
       $stmt = $dbh->prepare($sql,array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => TRUE));
       $stmt->execute();
       $result = $stmt->fetch(PDO::FETCH_OBJ);
       $stmt->closeCursor();
       /*foreach($result as $key=>$val)
       {
               echo $key.' - '.$val.'<br />';
       }*/
       print_r($result);
       $dbh = null;
   }
   catch(PDOException $e)
   {
       echo $e->getMessage();
   }
?>


Output for server 1:

stdClass Object
(
   [first_name] => super
   [last_name] => admin
   [user_id]=>1
   [email] => ram@greynium.com
)

output for server 2:

stdClass Object
(
   [first_name] => super
   [last_name] => admin
   [users] => ram@greynium.com
)

On server 2 I am not getting the output for field 'user_id' from the table 'users'.

For the field 'email' from 'users' table, it is displaying the name of the table itself (users). Not sure what is wrong.

The configuration of the servers are given below
Server 1
--------
OS Details:
Linux 2.6.9-5.ELsmp

PHP Details:
PHP 5.2.3 (cli) (built: Aug 28 2007 11:48:30)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
   with Suhosin v0.9.22, Copyright (c) 2007, by SektionEins GmbH

PDO details:
PDO
PDO support => enabled
PDO drivers => sqlite2, sqlite, mysql
PDO Driver for MySQL, client library version => 5.0.37
PDO Driver for SQLite 3.x => enabled



Server 2
---------
OS Details:
Linux 2.6.18-8.el5

PHP Details:
eAccelerator requires Zend Engine API version 220060519.
The Zend Engine API version 220090626 which is installed, is newer.
Contact eAccelerator at http://eaccelerator.net for a later version of eAccelerator.

PHP 5.3.2 (cli) (built: Jul  6 2010 17:57:31)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies


PDO Details:
PDO
PDO support => enabled
PDO drivers => mysql, sqlite, sqlite2
PDO Driver for MySQL => enabled
PDO Driver for SQLite 3.x => enabled

i have built pages that paginate with 10 rows per page (some pages show more but for the moment i want to focus on this particular page)

//Define Some Options for Pagination
$num_rec_per_page=10;
if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }; 
$start_from = ($page-1) * $num_rec_per_page;

$results = mysql_query("SELECT * FROM `ecmt_memberlist` WHERE toonCategory='Capital' AND oldMember = 0 ORDER BY CONCAT(MainToon, Name) LIMIT $start_from, $num_rec_per_page") or die(mysql_error());

	$results_array = array();
	while ($row = mysql_fetch_array($results)) {
    	$results_array[$row['characterID']] = $row;
}

The above sets the variables for the pagination and below the results are echo with 10 rows per page   then i show the pagination links:

<?php 
$sql = "SELECT * FROM `ecmt_memberlist` WHERE toonCategory='Capital' AND oldMember = 0 ORDER BY CONCAT(MainToon, Name)";

$rs_result = mysql_query($sql); //run the query
$total_records = mysql_num_rows($rs_result);  //count number of records
$total_pages = ceil($total_records / $num_rec_per_page); 
?>


      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td align="center"><div style="width:100%; text-align:center;">
          <ul class="pagination">
    <li class="selected">
	<?php
echo "<a href='capitalmember.php?page=1'>".'«'."</a> ";?> 
</li>
<?
for ($i=1; $i<=$total_pages; $i++) { 
            echo "<li><a href='capitalmember.php?page=".$i."'>".$i."</a></li> "; 
};
?>
<li class="selected">
<? 
echo "<a href='capitalmember.php?page=$total_pages'>".'»'."</a> "; // Goto last page
?></li>
  </ul></div>
    <?php
  $pageNr = $page;   // Get Current Page Number
$from = $pageNr * $rowsPerPage;  // 3 * 10 = 30  // 3 * 10 = 30
$to = $from + $rowsPerPage;      // 30 + 10 = 40
echo $pageNr;
/* Result: From page 30 to 40 */
  ?></td>
        </tr>
      </table>

this works great and shows me 10 results per page,   what i need to work out and work on next is:   echo the number of results above the records (for example: "showing records 1 to 10" and then on page 2 "showing records 11 to 21" and page 3 "showing records 22 to 32"   how can i work out the maths for this echo?   i was thinking along the lines of;

    <?php
$pageNr = $page;   // Gets Current Page Number
$from = $pageNr * $rowsPerPage;  // 3 * 10 = 30  
$to = $from + $rowsPerPage;      // 30 + 10 = 40
// Now Show Results
echo $from; // Echo from
echo $to // Echo to
  ?>

but i'm still working on this..   then i need to look at shortening the amount of page links on the page if for example i have 500 records it shows me links 1 to 50 and eats up the page....   Appreciate any help and light onto my problems.   Many thanks
Edited by jacko_162, 11 January 2015 - 05:43 PM.

I was wondering how does one go about showing results from SELECT query in columns in a html table.

I have a list of products in a table, and would like to show them on the page in 4 columns. I have done many searches on google to try and find the sulution, but the majority of what im finding instead is about displaying a table from phpmyadmin as a table in html.

If its a large operation to do this, I would be very happy if someone could poiint me in the direction of a tutorial maybe.

Here is the code I have so far to display the products, but for some reason, it only show 1 row instead of all the rows from my table.

Code: [Select]
<?php

$dbhost = "localhost";
$dbuser = "user";
$dbpass = "pass";
$dbname = "dbname";

mysql_connect ($dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

$result = mysql_query("SELECT * FROM mcproducts");
while($row = mysql_fetch_array($result))
 {
  $products_local_id = $row['products_local_id'];
  $productname = $row['product_name'];
  $thumburl = $row['image_from_url'];
  $productlink = $row['product_local_url'];
  $thumbnail = $row['product_image_small'];
  $currencysymbol = $row['product_currency'];
  $price = $row['product_price'];
  $flagicon = $row['product_country_from'];

 }

?>
<html>
<head>
<link href="style/stylesheet.css" rel="stylesheet" type="text/css" />
</head>
<body>

<div class="displaybox">
                <div class="productimage">
                <a href="<?php echo $productlink; ?><?php echo $products_local_id; ?>"><img src="<?php echo $thumburl; ?><?php echo $thumbnail ?>" width="150" height="150"></a>
                </div>
                <div class="productdescription">
                  <div class="pro_name">
      <a href="<?php echo $productlink ?><?php echo $products_local_id; ?>"><?php echo $productname; ?></a>
                  </div>
                  <div class="pro_description">
                  </div>
                  <?php
                  if ($flagicon=="Ireland") {
  $flagicon = "<img src=\"flags/ireland.jpg\">";
  }
  
  elseif ($flagicon=="UK") {
  $flagicon = "<img src=\"flags/uk.jpg\">";
  }  else
  echo "";
  ?>
                  <div class="pro_description"><?php echo $flagicon; ?><?php echo $currencysymbol ?> <?php echo $price ?></div>
                </div>
              </div>
             
</body>
</html>


Many thanks,

DB

This topic has been moved to Ajax Help.

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

I am using html5 and all the pages have h2 headings as titles.  They all show up in google search results fine.  The only thing that doesn't show up fine are some of the descriptions under each heading. Some meta descriptions show up fine under the correct heading title, while rest shows ALL the heading tags AS description under each search result.     For eg.   Cars www.mywebsite.com/category?id=5&name=cars

I use this code to open the contents of my Menu Links inside my <div id="main"> so I do not need to reload the whole page each time:

I need to set up a method for a user to be able to upload a pdf that should then be readable in the browser but I want to make it work a bit like Google Patents. Basically the rest of the users shouldn't be able to grab the content. It should be read only so as not to be passed around for free.
It looks like Google is scanning each page and then running it through a reader to get the text. It then also seems to find the position of all the text so it can search the image for particular words and highlight them(cool js).

Any way has anyone seen a php/ js version of this concept that I can get some hints from?
Actually any language is ok if it works well.

Tx

I am pretty new to PHP and am trying to create a simple (so I assumed) page to takes data from one html page(works fine) and updates a MYSQL Database.  I am getting no error message, but the connect string down to the end of the body section is showing up as plain text in my browser window.  I do not know how to correct this.  I have tried using two different types of connect strings and have verified my names from the HTML page are the same as listed within the php page.  Suggestions on what I need to look for to correct would be great.  I have looked online, but so far all I am getting is how to connect, or how to create a comment, so I thought I would try here. 
Thank you for any assistance I may get!!  - Amy -
 
Code: [Select]
<body><font color="006600">
 <div style="background-color:#f9f9dd;">
  <fieldset>
<h1>Asset Entry Results</h1>
<?php
  // create short variable names
  $tag=$_POST['tag'];
  $serial=$_POST['serial'];
  $category=$_POST['category'];
  $status=$_POST['status'];
  $branch=$_POST['branch'];
  $comments=$_POST['comments'];

  if (!$tag || !$serial || !$category || !$status || !$branch) {
     echo "You have not entered all the required details.<br />"
          ."Please go back and try again.";
     exit;
  }

  if (!get_magic_quotes_gpc()) {
    $tag = addslashes($tag);
    $serial = addslashes($serial);
    $category = addslashes($category);
    $status = addslashes($status);
    $branch = addslashes($branch);
    $comments = addslashes($comments);
  }

  //@ $db = new mysqli('localhost', 'id', 'pw', 'inventory');
  $db = DBI->connect("dbi:mysql:inventory:localhost","id","pw") or die("couldnt connect to database");

  $query = "insert into assets values
            ('".$serial."', '".$tag."', '".$branch."', '".$status."', '".$category."', '".$comments."')";
  $result = $db->query($query);

  if ($result) {
      echo  $db->affected_rows." asset inserted into Inventory.";
  } else {
     echo "An error has occurred.  The item was not added.";
  }

  $db->close();
?>
  </fieldset>
 </div>
</body>

I'd like to use an application that's not browser based, on Internet Explorer. I've read somewhere that this is possible with a PHP script, but which one? If you can get me on the right track, I'd really appreciate it. Cheers.

I decided to redo the individual roster page I have on my site and came up with this.


<?php
if(isset($_GET['username']) && $_GET['username'] != '')
{
$username = $_GET['username'];
$query = "SELECT bio.username AS username,  bio.charactername AS charactername, bio.id AS id, bio.style_id AS style FROM `efed_bio` AS bio ON bio.id = ebw.bio_id WHERE bio.username = '$username'";
if(!$result = mysql_query($query))
while ($row = mysql_fetch_assoc($result))
{
$fieldarray=array('id','username','charactername','style');
foreach ($fieldarray as $fieldlabel)
{
if (isset($row[$fieldlabel]))
{ 
$$fieldlabel=$row[$fieldlabel];
$$fieldlabel=cleanquerydata($$fieldlabel);
}
}
}
}
?>

        <h1><?php echo $charactername; ?>'s Biography</h1>
<?php echo getBioMenu($style,$username); ?>

<?
//If the GET page variable is biography, display the biography page
if ($page == 'biography')
{
echo getBiopgrahy($style,$id);
}
//Or if the GET page variable is gallery, display the gallery page
elseif ($page == 'gallery')

{
echo getGallery($style,$id);
}
//If the GET page variable is news, display the news page
elseif ($page == 'news')

{
echo getNews($$id);
}
//If the GET page variable is segments, display the segments page
elseif ($page == 'segments')

{
echo getBioSegments($id,S);
}
//If the GET page variable is matches, display the matches page
elseif ($page == 'matches')

{
echo getBioSegments($id,M);
}
elseif ($page == 'chronology')

{
echo getChronology($id);
}
//Otherwise display the bio
else
{
echo getBio($style,$id);
}

?>




The list of characters are listed he

http://kansasoutlawwrestling.com/roster

An example of someone's individual roster page is located he

http://kansasoutlawwrestling.com/bio?username=oriel

hi all,

I am testing live and the data is downloading to the database but when it goes to the next page it gets this message.

Warning: Wrong parameter count for mysql_result() in /home/ebermy5/public_html/html/login.php on line 25
Could not execute query

THIS IS MY CODING ANY IDEAS WHERE I AM GOING WRONG. YES I HAVE THE OPEN AND CLOSE PHP?

if (@$_SESSION['auth'] != "yes")

 @include('Connections/connect_to_mysql.php');
 $query = "SELECT firstName, lastName FROM `Members`
          WHERE email='{$_SESSION['id']}'";            
 $result = mysql_result($query)
             or die("Could not execute query");
 echo "<html>
       <head><title>New Member Welcome</title></head>
      <body>
      <h2 style='margin-top: .7in; text-align: center'>
      Welcome $firstName </h2>\n";

Okay, after successfully getting a form to input data to a MySQL database, I'm now trying to get the data back out by searching.

Search form code:

Code: [Select]
<form name="search" method="post" action="process_search.php">
 Seach for: <input type="text" name="find" /> in
 <select name="columns">
 <option value="">Please choose one:</option>
 <option value="status">Status</option>
 <option value="date">Date</option>
 <option value="species">Species</option>
 <option value="breed">Breed</option>
 <option value="sex">Sex</option>
 <option value="primary_colour">Primary Colour</option>
 <option value="colour">Colour</option>
 <option value="distinctive_traits">Distinctive Traits</option>
 <option value="fur_length">Fur Length</option>
 <option value="age">Age</option>
 <option value="desexed">Desexed</option>
 <option value="microchipped">Microchipped</option>
 <option value="suburb">Suburb</option>
 <option value="pound_area">Pound Area</option>
 <option value="contact">Contact</option>
 <option value="link">Link</option>
 </Select>
 <input type="hidden" name="searching" value="yes" />
 <input type="submit" name="search" value="Search" />
 </form>

All good there!  Form displays how I want it to, and submits correctly.

The bit I'm struggling with is the process_search.php side of things.  This is what I have (note that i'm trying to get the results into a formatted table and I'd like more results if the match is in more than one column):

Code: [Select]
<?
 //Here we display stuff if they have submitted the form
 if ($searching =="yes")
 {
 echo "<h2>Results</h2><p>";
 
 //If they stuffed up and didn't search for anything, we show them this
 if ($find == "")
 {
 echo "<p>Oh, Bianca, you need to enter SOMETHING to search!";
 exit;
 }
 
 //If everything is all good, we connect to the database
 mysql_connect("localhost", "******", "******") or die(mysql_error());
 mysql_select_db("******") or die(mysql_error());
 
//Let's not forget the register globals off crap
$status = $_POST['status'];
$date = $_POST['date'];
$species = $_POST['species'];
$breed = $_POST['breed'];
$sex = $_POST['sex'];
$primary_colour = $_POST['primary_colour'];
$colour = $_POST['colour'];
$distinctive_traits = $_POST['distinctive_traits'];
$fur_length = $_POST['fur_length'];
$age = $_POST['age'];
$desexed = $_POST['desexed'];
$microchipped = $_POST['microchipped'];
$suburb = $_POST['suburb'];
$pound_area = $_POST['pound_area'];
$contact = $_POST['contact'];
$link = $_POST['link'];
$columns = $_POST['columns'];
 
 // We perform a bit of filtering
 $find = strtoupper($find);
 $find = strip_tags($find);
 $find = trim ($find);
 
 //Now we search for our search term, in the field the user specified
 $data = mysql_query("SELECT * FROM animal_info WHERE upper($columns) LIKE'%$find%'");
 
 //And we display the results
 where($result = mysql_fetch_array( $data ))
 {
    echo "<tr>";
    echo "<td>".$row['status']."</td>";
    echo "<td>".$row['date']."</td>";
    echo "<td>".$row['species']."</td>";
    echo "<td>".$row['breed']."</td>";
echo "<td>".$row['sex']."</td>";
echo "<td>".$row['primary_colour']."</td>";
echo "<td>".$row['colour']."</td>";
echo "<td>".$row['distinctive_traits']."</td>";
echo "<td>".$row['fur_length']."</td>";
echo "<td>".$row['age']."</td>";
echo "<td>".$row['desexed']."</td>";
echo "<td>".$row['microchipped']."</td>";
echo "<td>".$row['suburb']."</td>";
echo "<td>".$row['pound_area']."</td>";
echo "<td>".$row['contact']."</td>";
echo "<td>".$row['link']."</td>";
    echo "</tr>";
 }
 else
 {
echo "ERROR: ".mysql_error();
}
 //This counts the number or results - and if there wasn't any it gives them a little message explaining that
 $anymatches=mysql_num_rows($data);
 if ($anymatches == 0)
 {
 echo "Nope, couldn't find anything here!  Maybe refine your search criteria?<br><br>";
 }
 
 //And we remind them what they searched for
 echo "<b>Searched For:</b> " .$find;
 }
 ?>
Trouble with this is that I'm not getting any errors OR results!

ANY help would be appreciated HUGELY!

Cheers,

Dave