PHP - Confusion With How To Set A Session To A Table Colum Result

Hi, I have results from a MySQL table column which does an echo into a table cell, but some of the results from the table column is be empty, so is there a way to fill in the blanks with text like "No data"?  

My first post and I am not a programmer or familiar with the correct vocabulary associated with php. I thought I would give the following a go as it is the holidays and my php programmer is no where to be found.

I am ok at following scripts to get a simple result, unfortunately the listing manager I am using is coded with Zend. The system is built on a curve2.com and I am pretty much stuck with what exists. I would like to add some more php outputs, which I don't think are too complicated, but I can't seem to get my head around pulling information from multiple tables in to 1 result.

I am trying to pull all the data from a 'Listing' table in to 4 columns, which works ok. What I can not get around is trying to link up the 'Image' table to my 'Listing' table and pulling the main image in to my php output. There is a common 'id' but each 'id' has 4+ images and I would like to select the just main one and resize it smaller.

So far, I have the following, which I have put together from following examples on this website. 'id' is the unique id for each record.


<?
   $query="select * from listings";
   $result=mysql_query($query);
 
   $cols=4;      
   echo "<table>";   
   do{
      echo "<tr>";
      for($i=1;$i<=$cols;$i++){   
                        
         $row=mysql_fetch_array($result);
         if($row){
            $img = $row['image_path'];
 ?>
        <td>
            <table>
                <tr valign="top">
                    <td><img src="images/<?=$img ?>" /></td>
                    <td>
                        <b><a href="http://www.coralbayrealestate.com/search/show.php?id=<?=$row['id'] ?> "> <?=$row['title'] ?> </a> </b><br />
                        <?=$row['state'] ?><br />
                        $USD <?=number_format ($row['price']) ?><br />
                    </td>
                    <td width="20">&nbsp;</td>
                </tr>
           </table>
        </td>
<?
         }
         else{
            echo "<td>&nbsp;</td>";   
         }
      }
   } while($row);
   echo "</table>";
 ?>

The image table, called 'images' has 3 fields

'id' - individual photos id's
'listid' - Id record to the listing table
'fname' - image name

Any guidance would be much appreciated on how to get the primary image on to the table.
Happy holidays and best wishes to all for 2011.
Sandydr

I am getting  the row results from mysql as called, but they appear as a straight line instead of new table row when I echo like:

echo "TABLETABLETABLETABLE";

I am looking for:

echo "TABLE
          TABLE
          TABLE
          TABLE";

Here is my code:
Code: [Select]

$brand = $_POST['brand'];
$city = stripslashes($_POST['city']);
$state = $_POST['state'];
$zip_code = stripslashes($_POST['zip_code']);


if($city !=""){
$query = "SELECT name, bus_type, street, city, state, zip_code, brand, quantity, price1, price2, date FROM `prices` WHERE city ='".$city."' AND state ='".$state."' AND brand = '".$brand."'";
}else{
$query = "SELECT name, bus_type, street, city, state, zip_code, brand, quantity, price1, price2, date FROM `prices` WHERE zip_code ='".$zip_code."'";
}
$result = mysql_query($query);
 
     $count=mysql_num_rows($result);
if($count==0 && $zip_code !=""){?>

    <td width="100%" class="style9">Sorry! There are no results for that city, state and brand.</td>
 
<?
}else{
   while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
?>
  <td width="100%" class="style9"><?php 
  echo "<table width=\"100%\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">
  <tr>
     <td{$typ_image}</td>
<td><b><a href=\"\" title=\"{$row['street']} {$row['city']}, {$row['state']}. {$row['zip_code']}\" target=\"_blank\">{$row['name']}</a></b><br>Last Updated:{$row['date']}</td>
    <td><b>{$row['brand']} - {$row['quantity']}</b><br>Before Tax:\${$row['price1']} After Tax:\${$row['price2']}</td>
<td{$pago}</td>
  </tr>
</table><BR>";
  ?></td>
<?php
 }
} 
?></table>   
    <p>&nbsp;</p>
    </td>

Hi There,

I have an SQL query that returns 10 rows, which I want to echo over 2 columns and 5 rows, however, I want rows 1-5 on the left hand column and rows 6-10 on the right hand side.

Is there an easy way to do this? Normally I would do a fetch_array but, that would place the rows in order of, left, right, left, right - if that makes sense?

Table is a standard table with 2 columns and 5 rows.

Thanks
Matt

Hello!

I have this code

Code: [Select]
<?php

include_once('../database_connection.php');


$thiskeyword = addslashes($_REQUEST['keyword']);

$sqlquery = "Select * from nba_info where player_id like '%$thiskeyword' OR fname like '%$thiskeyword' OR lname like '%$thiskeyword' OR team like '%$thiskeyword' OR email like '%$thiskeyword'";


$result = MYSQL_QUERY($sqlquery);
$numberOfRows = MYSQL_NUM_ROWS($result);


?>





<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Search Result</title>
</head>

<body><center><br /><br />
<?php



if($numberOfRows==0)
{

die('You keywords haven\'t much any data from the database');
        
}
else if($numberOfRows>0)
{
echo $numberOfRows. " Results have been found!";
$i = 0;


?>

<table>
<tr>
    <td>player_id</td>
   
    <td>fname</td>
 
    <td>lname</td>

    <td>team</td>

    <td>email</td>
       
    </tr>
 
 
<?php

while($i<$numberOfRows)
{

$player_id = MYSQL_RESULT($result,$i,"player_id");
$fname = MYSQL_RESULT($result,$i,"fname");
$lname = MYSQL_RESULT($result,$i,"lname");
$team = MYSQL_RESULT($result,$i,"team");
$email = MYSQL_RESULT($result,$i,"email");


?>



<tr>
   
    <td><? echo $player_id; ?></td>
<td><? echo $fname; ?></td>
<td><? echo $lname; ?></td>
<td><? echo $team; ?></td>
<td><? echo $email; ?></td>

    </tr>

<?php

$i++;

}

?>


</table>

<?php } ?>



<ul>
<li><a href="/php/database/ManipulatingDatabase/add_database.php">Add New Player</a></li>
    <li><a href="/php/database/ManipulatingDatabase/edit_form.php">Edit Player</li>
    <li><a href="/php/database/ManipulatingDatabase/delete_form.php">Delete Player</li>
    <li><a href="/php/database/ManipulatingDatabase/search_form.php">Search Player</li>
    <li><a href="/php/database/ManipulatingDatabase/manipulate_database.php">BACK TO MAIN</a></li>
</ul>




</center>
</body>
</html>

I have no problem with the sql statement as  code

Code: [Select]
echo $numberOfRows. " Results have been found!";
is giving me a numbers of rows. The problem is the rows that have been found is not showing up in the html row.


I wonder what the problem is.. anyone?

I am having so much trouble with this. I want to create a html table that looks like this:
Code: [Select]
<table id="datatable">
 <thead>
  <tr>
   <th></th>
   <th>test</th>
   <th>test 2</th>
  </tr>
 </thead>
 <tbody>
  <tr>
   <th>2011-03-17</th><td>1</td><td>0</td>
  </tr>
  <tr>
   <th>2011-03-18</th><td>3</td><td>2</td>
  </tr>
  <tr>
   <th>2011-03-19</th><td>1</td><td>0</td>
  </tr>
 </tbody>
</table>

out of this mysql result:
opens | name | date
1 | test | 2011-03-17
3 | test | 2011-03-18
2 | test 2 | 2011-03-18
1 | test 2 | 2011-03-19

Here is my mysql code:
Code: [Select]
SELECT count( o.campaign_id ) AS opens, c.name, date(o.created_at) as date FROM opens o LEFT JOIN campaigns c ON c.id = o.campaign_id WHERE (o.created_at between '2011-03-17 00:00:00' and '2011-03-19 23:59:59') GROUP BY date,c.name
I also attached a sql dump of my database.

I´ve reached to

    <?php require_once('Connections/conexxion.php'); ?>
    <?php
    mysql_select_db($database_conexxion, $conexxion);
    $query_consulta = "SELECT venta,compra,taller,regula_mas,regula_menos,movimiento.id_item,sum(compra+regula_mas-venta-taller-regula_menos)  as stock, cilindro, esfera FROM movimiento  join item on item.id_item=movimiento.id_item join rx on rx.id_rx=item.id_rx join cilindro  on cilindro.id_cil=rx.id_cil  join esfera  on esfera.id_esf=rx.id_esf GROUP BY movimiento.id_item ORDER BY esfera desc, cilindro desc";
    $consulta = mysql_query($query_consulta, $conexxion) or die(mysql_error());
    $row_consulta = mysql_fetch_assoc($consulta);
    $totalRows_consulta = mysql_num_rows($consulta);
    ?>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>test</title>
    </head>
     
    <body>
     
       <?php
    echo "<table align=center>";
     
    $columnes = 10; # Número de columnas (variable)
     
    if (($rows=mysql_num_rows($consulta))==0) {
      echo "<tr><td colspan=$columnes>No hay resultados en la BD.</td></tr> ";
    } else {
      echo "<tr><td colspan=$columnes>$rows Resultados </td></tr>";
    }
     
    for ($i=1; $row = mysql_fetch_row ($consulta); $i++) {
    $resto = ($i % $columnes); # Número de celda del <tr> en que nos encontramos
    if ($resto == 1) {echo "<tr>";} # Si es la primera celda, abrimos <tr>
       echo "<td>$row[1]</td>";
    if ($resto == 0) {echo "</tr>";} # Si es la última celda, cerramos </tr>
    }
    if ($resto <> 0) { # Si el resultado no es múltiple de $columnes acabamos de rellenar los huecos
    $ajust = $columnes - $resto; # Número de huecos necesarios
    for ($j = 0; $j < $ajust; $j++) {echo "<td>&nbsp;</td>";}
    echo "</tr>"; # Cerramos la última línea </tr>
    }
    mysql_close($connexion);
    echo "</table>";
    ?>
     
     
     
    </body>
    </html>
    <?php
    mysql_free_result($consulta);
    ?>

it "works", but results doesn´t start at number 1 but number 2   anyways, The intent of this table is to show the stock of a product, a lens, that has a range of Rx, we use to see this range this way, and show the stock this way would be very productive, but I can´t figure out how to achive it, any sugestion??  
Edited by gralfitox, 16 December 2014 - 06:45 AM.

Hi I have two tables Employer and Job. Emp_ID as PK of Employer and Job_id as PK of Job. I want to put Emp_ID as Foreign key for jobs. and when the employer logs in his empid is being stored as a session and when he creates a job his empid will be entered in the job table.

I am retrieving a rowfrom a table and when I post the row variable it doesnt read it.
___
$query = "SELECT * FROM $tbl_name";
   
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
   echo $row['name'];
   echo "<br />";

$postinfo = 'p_doctor_name=' . $row .'&p_name_type=A&p_search_type=BEGINS';
__
This outputs p_entity_name=&p_name_type=A&p_search_type=BEGINS
Note that it is missing $row

Do I need to put it in an array?

Hi all,

I have a number of tables within a mysql database and I'm stuck on how to pull information from one based on the results being displayed by another.

The site shows items for sale where by all the product information is held in tablea, when an individual item is being displayed I need to be able to pull a manufacturer profile from tableb based on the manufacturer name stored in tablea column profile. The manufacturer name is already being called into the page by existing code as the site has always shown the manufacturer name, I just can't work out out to pull the new profile information in as well from the new table.

Any help appreciated

Iain

OK, Here is the code

$sql = "SELECT
TrialListing.listingID AS Trial, TrialClass.classID AS Class, place.place_name AS Place,
CONCAT_WS(
' ',
pedigree.pretitle,
pedigree.`Name`) AS Hound,
CONCAT_WS(
' ',
ped2.pretitle,
ped2. NAME
)AS Sire,
CONCAT_WS(
' ',
ped3.pretitle,
ped3. NAME
)AS Dam,
pedigree.Breeder,
pedigree.`Owner`,
CASE
WHEN placement.place_id < 5 THEN
TRUNCATE(TrialClass.number_of_entrants / placement.place_id,2)
WHEN placement.place_id  = 5 THEN
''
ELSE
0
END

AS Score
FROM
TrialListing
Left Join TrialClass ON TrialListing.listingID = TrialClass.listingID

JOIN placement ON placement.event_id = TrialClass.trialClassID
JOIN pedigree ON pedigree.PedigreeId = placement.hound_id
LEFT OUTER JOIN pedigree AS ped2 ON pedigree.SireId = ped2.PedigreeId
LEFT OUTER JOIN pedigree AS ped3 ON pedigree.DamId = ped3.PedigreeId
LEFT JOIN place ON place.place_id = placement.place_id

WHERE
TrialListing.listingID = 11
ORDER BY Class, FIELD(place.place_id, '1', '2', '3', '4', '0')


";      // Database Query  

$result = mysql_query("$sql");  // Database Query result

$num_rows = mysql_num_rows($result);





// Starts the table
echo "<table class=\"clubList\">\n
<tr>
<th>trialID</th>
<th>ClassID</th>
<th>Place</th>
<th>Hound</th>
<th>Sire</th>
<th>Dam</th>
<th>Score</th>

</tr>";

// Create the contents of the table.
for( $i = 0; $i < $row = mysql_fetch_array($result); $i++){




echo "<tr>\n"
        ."<td>".$row["Trial"]."</td>\n" 
        ."<td>".$row["Class"]."</td>\n" 
        ."<td>".$row["Place"]."</td>\n"  
        ."<td>".$row["Hound"]."</td>\n"  
        ."<td>".$row["Sire"]."</td>\n"                
        ."<td>".$row["Dam"]."</td>\n"
        ."<td>".$row["Score"]."</td>\n"  
        ."</tr>";}



echo "</TABLE>";


Here is the output, I added the TrialID & ClassID for informational purposes, they do not need to be displayed in the live table.

trialID ClassID Place Hound Sire Dam Score 11 1 1st Eaton Brook Tug Hill Tatonka Eaton Brook Hickety Hawk Eaton Brook Gunner's Beulah 43.00 11 1 2nd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 21.50 11 1 3rd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 14.33 11 1 4th Rail Road Spike VI Elwell's Mike Elwell's Hannah 10.75 11 1 NBQ FC Fish Creek Spike Fish Creek Bull II Fish Creek Susie [H849395] 11 2 1st Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 32.00 11 2 2nd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 16.00 11 2 3rd Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger 10.66 11 2 4th FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 8.00 11 2 NBQ FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka 11 3 1st Bojangle V Lee Otworth Half Acre's Cocoa Candy 23.00 11 3 2nd Gay Doll Gay Roll II Gay Idol 11.50 11 3 3rd Bruce's Blue Lady FC Kilsock's Blue Creek Bart Bishopville's Zippy 7.66 11 3 4th FC Pearson Creek Barbin FC Pearson Creek Barbarian FC B-Line Stubby 5.75 11 3 NBQ Sims Creek Cricket Ronnie Joe Sims Creek Tiny 11 4 1st FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 26.00 11 4 2nd FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka 13.00 11 4 3rd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 8.66 11 4 4th Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 6.50 11 4 NBQ Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger
Below is what I would like to generate. How do I word or nest the proper PHP code/loops to accomplish this?

ClassID

Place Hound Sire Dam Score 1st Eaton Brook Tug Hill Tatonka Eaton Brook Hickety Hawk Eaton Brook Gunner's Beulah 43.00 2nd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 21.50 3rd FC North Bend Igloo FC DFJ Murphy White IFC Brad-Ju's Bella Donna 14.33 4th Rail Road Spike VI Elwell's Mike Elwell's Hannah 10.75 NBQ FC Fish Creek Spike Fish Creek Bull II Fish Creek Susie [H849395]

ClassID

Place Hound Sire Dam Score 1st Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 32.00 2nd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 16.00 3rd Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger 10.66 4th FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 8.00 NBQ FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka

ClassID

Place Hound Sire Dam Score 1st Bojangle V Lee Otworth Half Acre's Cocoa Candy 23.00 2nd Gay Doll Gay Roll II Gay Idol 11.50 3rd Bruce's Blue Lady FC Kilsock's Blue Creek Bart Bishopville's Zippy 7.66 4th FC Pearson Creek Barbin FC Pearson Creek Barbarian FC B-Line Stubby 5.75 NBQ Sims Creek Cricket Ronnie Joe Sims Creek Tiny

ClassID

Place Hound Sire Dam Score 1st FTCH Fareast Mookie FTCH Mellowrun Sly FTCH Cape Breton Maude 26.00 2nd FTCH Mellowrun Sly Mellowrun Skylighter FTCH Mellowrun Becka 13.00 3rd Fishflakes Penny At Harehaven FTCH Jill's Fair-Isle Spud FTCH Millbridge Brownie 8.66 4th Enman Hill Sweet Poppy FTCH Straight Arrow Lucky of Coos 6.50 NBQ Line Elm Flakers IFC Flakers Rex IFC Line Elm Ginger

i have got the A table. and i want get from data this table to session. how can I ?

I am under developing PHP add to cart without DB, so that i am using SESSION, actually get data from fetch_data.php data to my_cart.php using the POST method, successfully retun the values,

After receiving the post data how can i convert to display like a table.

workout:

fetch_data.php return values.

https://snag.gy/IASCMZ.jpg

& values received

https://snag.gy/ojWxHe.jpg

Here is my my_cart.php :

// FYI -> Here i am using only two fields :  voice_sku & voice_name 

<table width="100%" cellpadding="6" cellspacing="0">
 <thead>
 <tr>
 <th>Voice Sku</th>
 <th>Voice Name</th>
 <th>Remove</th>
 </tr>
 </thead>

 <tbody>

 <?php
 session_start();
 $voice_sku = '';
 $voice_name = '';

 if(isset($_POST['voice_sku'])&& isset($_POST['voice_name']))
            {
 // print_r($_POST);
 // die();
 
 $voice_sku = $_POST['voice_sku'];
 $voice_name = $_POST['voice_name'];
 $_SESSION['voice_sku'] = $voice_sku;
 $_SESSION['voice_name'] = $voice_name;
 
 
            }   
 var_dump($_SESSION);    
 ?>

 <tr>
 <td colspan="5">
 <span style="float:right;text-align: right;">
 <!--  -->
 </span>
 </td>
 </tr>
 <tr>
 <td colspan="5">
 <a href="index.php" class="button">Add More Items</a>
 <button type="submit">Update</button>
 </td>
 </tr>

 </tbody>
</table>

 

Im trying to insert a name into my database but I need it to go into the column that matches the sessions user id


Code: [Select]
"INSERT INTO users SET name = '".$_POST['name']."'";

how do I tell it to put name into name column with id matching Session id.

really appreicate if someone could please help me with this.

Hi I am having issues with the following code.  I cannot get the table to produce a subtotal multiplying the value of 'ITEMQTY' which is a text field in the form in which the user enters by the 'ITEMPRICE' field which value is located in a text document.


<h1>SHOPPING CART</h1><img src="images/cart.png" alt="Cart" width="100" height="100"/>
<a href="browse_index.php">CLICK HERE TO CONTINUE SHOPPING</a>
<?php

  if(isset($_POST['submit']))
  {

$itemname = $_POST['h1'];

//echo $_SESSION['itemname'][$itemname];

  unset($_SESSION['itemqty'][$itemname]);

  unset($_SESSION['itemprice'][$itemname]);

  unset($_SESSION['itemname'][$itemname]);
  

}
  echo "<br/><br/>";
  echo "<table border='8' cellpadding='10' >";
  echo "<tr><th>Name</th><th>Quantity</th><th>Price</th><th>Subtotal</th></tr>";
  foreach($_SESSION['itemname'] as $key => $value)
  
  $subtotal = ($_SESSION['itemprice']*($_SESSION['itemqty'];
{

echo
'<tr>
<td>'.$_SESSION['itemname'][$key].'</td>
<td><input type="text" name="t1" value='.$_SESSION['itemqty'][$key].'></td>
<td>'.$_SESSION['itemprice'][$key].'</td>
<td>'.$_SESSION['h2'][$key].'</td>
<td><form id="f1" method="post" name="f1"><input type="submit" name="submit" value = "delete"><input type="hidden" name="h1" value='.$key.'></td>
</tr>
<tr><form id="t1" method="post" action="summary.php" name="t1"><input type="submit" name="order" value="SUBMIT ORDER"></tr>';

}

  echo "</table>";
  

?>