PHP - Results Not Showing After First One

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

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

This topic has been moved to Ajax Help.

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

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

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

Hi,
I just connect to my server through ftp. i want to edit php.ini file. which is placed in /etc/php.ini   "etc" folder. but i'm unable to see etc folder. there are only two folders one is cgi-bin and other is www. can anyone help me to find out etc folder. i've check to show hidden files in filezilla.

Thanks

Hi guys   I am using the code below to show distinct months using one query then for each month I am trying to show a list of fixtures for the month, the problem I have is only one month is showing.   where am i going wrong?  

<?php
//find distinct months
$sql="SELECT DISTINCT MONTH( match_date ) AS
MONTH FROM tbl_fixtures
WHERE season_id =$current_season
UNION SELECT DISTINCT MONTH( match_date ) AS
MONTH FROM tbl_gp
WHERE season_id =$current_season";
$result=mysqli_query($dbConn, $sql);
if(mysqli_num_rows($result)>0){
    while($row=mysqli_fetch_assoc($result)){
        $month=$row['MONTH'];
        echo '<div class="fixtureMonth">
              <h2>'.$months[$month].'</h2>
              </div>
              <div class="fixtures">';
              //find fixtures for month
        $sql="SELECT Opposition, match_date, competition, tbl_clubs.club_name AS club, image, HomeAway, team, opposition_points, points
        FROM tbl_fixtures
        INNER JOIN tbl_clubs ON tbl_fixtures.club = tbl_clubs.club_id
        WHERE season_id =$current_season and MONTH(match_date)=$month
        UNION SELECT Opposition, match_date, \"SGP\" AS competition, \"SGP\" AS club, \"sgp.png\" AS image,  \"\" as HomeAway, \"\" as team, \"\" as opposition_points, points
        FROM tbl_gp
        WHERE season_id =$current_season and MONTH(match_date)=$month
        ORDER BY match_date";
        $result=mysqli_query($dbConn,$sql)or die(mysqli_error($dbConn));
        if(mysqli_num_rows($result)==0){
            echo no_fixtures_found;
        }
        else{
            echo '<table class="fixturesTable">';
            while($row=mysqli_fetch_assoc($result)){
                echo'<tr>
    <td>'.date("d-M-Y",strtotime($row['match_date'])).'</td>
          <td><img src="'.$shopConfig['url'].'images/'.$row['image'].'"/></td>
          <td>'.$row['Opposition'].'</td>
          <td>'.$row['HomeAway'].'</td>
          <td><b>'.$row['team'].'</b>-'.$row['opposition_points'].'</td>
          <td>'.$row['team'].'</td>
          </tr>';
            }
            echo '</table>';
        }
        echo '</div>';
    }
    
}
?>