PHP - A Select Array Not Showing Results

So I have 2 queries, that has the potential to return alot of data, foreach loops running. The first shows each group heading, and the foreach nested is calling another query specific to the group heading. The result currently is a lengthy delay in results showing. (Now this may/may not be the most ideal code practise in this instance however... short term solution discussion please).

For Each State
   Read Each States Details from DB
   For Each State Listing
      Display Details
   Next
Next

Is there a command or other where I can say, Display HTML page as it stands while it continues to process the FOREACH loops?

EG:

For Each State
   Read Each States Details from DB
   For Each State Listing
      Display Details
      REFRESH HTML DISPLAYED
   Next
Next

Hi   I have 2 tables that I am searching infor for. One holds the phone info and the other the repairs that are available.   I have the code below and it displays on the webpage in a table for the phone information and then another table the repairs but they seem to be separate tables and headers. inbetween them is the phone and the details which separates the repairs but its not in a table.   Hopefully the code below will explain better.   What I would like it the phone details in one table and then a table full of all the repairs (I am not bothered about a new heading for each repair).

$result = mysql_query("SELECT * FROM phone, phonerepairs WHERE phone.model_no='".$_POST['model']."' AND phone.phone = phonerepairs.phone");

while($row = mysql_fetch_array($result))
{
echo '<td width="70" align="center"><img src="'.$row['icon'].'" width="66"></td>';
echo '<td width="100" align="center">'.$row['model_no'].'</td>';
echo '<td width="130" align="center">'.$row['model'].'</td>';
echo '<td width="50" align="center">'.$row['year'].'</td>';
echo '<td width="150" align="center">'.$row['capacity'].'</td>';
echo '</tr>';
echo '</table><br>';
echo '</p>';
echo '<p>';
echo '<div id="pageheading"><h3><div id="title">Repairs we carry out for '.$row['model'].'</div></h3></div>';
echo '<table width="99%" cellpadding="5" cellspacing="0" border="1">';
echo '</p>';
echo '<p>';
echo '<tr>';
echo '<td align="center"><strong>Image</strong></td>';
echo '<td align="center"><strong>Fault</strong></td>';
echo '<td align="center"><strong>Repair</strong></td>';
echo '<td align="center"><strong>Cost</strong></td>';
echo '</tr>';
echo '<tr>';
echo '<td width="70" align="center"><img src="'.$row['icon'].'" width="66"></td>';
echo '<td width="100" align="center">'.$row['fault'].'</td>';
echo '<td width="130" align="center">'.$row['description'].'</td>';
echo '<td width="50" align="center">&pound'.$row['cost'].'</td>';
echo '</tr>';
echo '</table><br>';

Thanks in advance    Martyn

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.

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 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

When i use this code it show everything except for the first record in the table. I have also tried it with the users for the login system im using and then it doesnt show the person im logged in to or also the first record in the table and i need it too show all the records

How do i solve this? I thought it had something to do with:

Code: [Select]
                                                                             <?php while ($rij = mysql_fetch_array($result)){
echo ("<tr><td>". $rij['ID'] . " </td> " .
"<td>" . $rij['naam'] . " " . 
$rij['telefoon'] . " </td> " .
"<td>" . $rij['adres'] . " </td> " .
"<td>" . $rij['mobiel`'] . " </td>".
"</td></tr>\n ");
}
?>
But i dont know how to solve it.

Code: [Select]
                                                                       <?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}


mysql_select_db("root123", $con);

$sql= "SELECT * FROM root123 ORDER BY ID;";
$result = mysql_query($sql, $con);
$rij = mysql_fetch_array($result);

?>

<table width="80%" align="center">
<tr>
<th>ID</th>
<th width="150px">Naam</th>
<th>Gebruikersnaam</th>
<th width="300px">Wachtwoord</th>

</tr>
<?php while ($rij = mysql_fetch_array($result)){
echo ("<tr><td>". $rij['ID'] . " </td> " .
"<td>" . $rij['naam'] . " " . 
$rij['telefoon'] . " </td> " .
"<td>" . $rij['adres'] . " </td> " .
"<td>" . $rij['mobiel`'] . " </td>".
"</td></tr>\n ");
}
?>
</table>

here is some simple code for getting and displaying fata from a database

Code: [Select]
$sql="SELECT * FROM messages WHERE m_id = '".$id."'";

$result = mysql_query($sql);

<table border='0' cellspacing="4">

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<th>Message</th>";
  echo "</tr>";
  echo "<tr>";
  echo "<td>" . $row['message'] . "</td>";
  echo "</tr>";
  }

now ive used that while loop to display those results how can i do that again without having a new SQL statement.

i cant do 2 while loops because the first one has already got to the end of the amount of rows

basically how can i have another while loop displaying those same results again?

Code: [Select]
$query  = "SELECT content FROM license WHERE serial  = '".$serial."'";

i have a php script:

$sql5 = "select *,count(*) from rc_language_type_assoc_table group by language_type_id";
$result5 = mysql_query($sql5);                                                 //not correct
$count5 = mysql_num_rows($result5);                                   //not correct

$myFile = "/home/rainbowcode/StatsFile.txt";
$fh = fopen($myFile, 'w') or die("can't open file");

fwrite($fh, $sql5."\n");



the above is not what i  want,   i want  the actual result set of the select to print in my StatsFile
how can i achieve this please???

Hey there. Not sure how to word this. I've been flying blind as a newbie trying to figure out some pagination for a left joined query. I've got syntax errors trying to set up the SELECT COUNT function that adds up the results of the search on a previous page so it knows how many results matched both tables.

Right now, I've got this mess, and it's giving me a syntax error,
"You have an error in your SQL syntax; .... near 'LEFT JOIN plantae ON (descriptors.plant_id = plantae.pla' at line 12"
Code: [Select]
$data = "Select (SELECT COUNT(*)
                    FROM
                        descriptors
                    ) AS
                        count1,
                (SELECT COUNT(*)
                    FROM
                         plantae
                    ) AS
                        count2

                    LEFT JOIN
                        plantae ON (descriptors.plant_id = plantae.plant_name)
                    WHERE
                        `leaf_shape` LIKE '%$select1%'
                        AND `leaf_venation` LIKE '%$select3%'
                        AND `leaf_margin` LIKE '%$select4%'";
                   
 
$result = mysql_query ($data);
if (!$result) {
    die("Oops, my query failed.  The query is: <br>$data<br>The error is:<br>".mysql_error());
}

Hi. I will try and explain simply.   I have a list of item codes eg.  size1 Acolor1 size1 Bcolor3 size1 Bcolor1 size1 Acolor3 size1 Acolor4 size2 Acolor1 size3 Bcolor1 size3 Bcolor2 size3 Bcolor2 size3 Acolor1   I want to take these and split them into parts:   size1 Acolor2 size1 Bcolor3 etc.   Then I want to create a form with 2 dropdowns. The first option would just have all unique sizes so: size1 size2 size3   Then when one is selected, option 2 would show the colours available in that size.   Is there a standard way of doing this? Can I use PHP to create the array and then jquery to display and hide the options?   I'm totally stuck and i'm not just looking for somebody to code it all for me. any help would be greatly appreciated   thanks Sam

Hello, I got a simple script to show how many user's are online for a game.
It is showing the user's but in a ARRAY like this

Array
(
    => Rchsingram34 [1] => killgorekiller
    [2] => jasonry25
    [3] => suburbanite09
    [4] => Torn2010
    [5] => Xacktar
    [6] => The5thExotic
    [7] => Pledgemonkey
    [8] => Mystikilla
    [9] => luge
    [10] => tbtregenza
    [11] => dffidel
    [12] => xaanit
    [13] => mrxCIC
    [14] => vobilli
    [15] => cyberbullet
    [16] => porkycain
    [17] => Doombringer721
    [18] => Ishaye
    [19] => CkGordon
    [20] => Mahngiel
    [21] => dj_de1337ed
)

Here is my code
<?php

define("NL", "\n");

class Minequery
{

function __construct($server, $port = 25566)
{
$this->socket = fsockopen($server, $port, $erno, $erst, 5);
if ($this->socket == FALSE) {
trigger_error("Could not connect to the remote server", E_USER_ERROR);
die();
}
else {
$this->query();
}

}


private function query()
{
$query = "QUERY\n";
$buffer = "";
fwrite($this->socket, $query);
while (!feof($this->socket)) {
$buffer .= fgets($this->socket, 1024);
}
$this->query = explode("\n", $buffer);
}


public function port()
{
$port = explode(' ', $this->query[0]);
return $port[1];
}


public function player_count()
{
$count = explode(' ', $this->query[1]);
return $count[1];
}


public function max_players()
{
$max = explode(' ', $this->query[2]);
return $max[1];
}

public function player_list()
{
$list = explode(' ', $this->query[3], 2 );
$list = trim($list[1], '[]');
$list = explode(',', $list);
foreach ($list as $player) {
$player_list[] = trim($player);
}
return $player_list;
}

}

?>

and the useage is pretty simple print_r($status->player_list());

but I cant for the life of me not get it to print Array ( ) I would like to just get the user names without Array and the Array numbers to it.. any help would be great.

What I'm trying to achieve is to get a set of data from a database and then cycle through the array and add the contents of each row to a variable.  I'm trying to use $i to cycle through the array but at the moment it's just printing the first character of each set.  Any help would be great. 


$fav_products_sql = "select fav_products.product_id, fav_products.product_order, product_list.product_name from fav_products, product_list where fav_products.product_id = product_list.id";
$fav_products_rs = mysql_query($fav_products_sql, $conn);
$fav_products = mysql_fetch_array ($fav_products_rs);

while ($i < 11) {
$_SESSION['fav_products'] = "<li>" . $fav_products['product_order']['$i'] . ": " . $fav_products['product_name']['$i'] . "</li>";
$i++;
}