NYCPHP Meetup

[selyah]

Hello:
I am trying to understand what your are trying to accomplish.
this is just a suggestion.
if  you are using a form to submit the data, then I would change the isset($_GET'aid'] to isset($_GET['submitted'])) to test if a form was submitted.  The your could use $query="SELECT....VALUE.....    items to be place into the database.
if the result is ok then $result=mysql_query($query); the if($result) {
print the results.
That way all of the artist is into one database and you only use one statement to display the info from the data base using the aid.
Good luck
see a sample below:
/////////////////////////////////////////////
if(isset($_POST['submitted'])) {//if the form was submitted
    
if(!empty($_POST['artistfname'])) {
    $afn=$_POST['artistfname'];
    } else {
        $_POST['artistfname']=NULL;
        }
        
if(!empty($_POST['artistlname'])) {
    $aln=$_POST['artistlname'];
    } else {
        $_POST['artistlname']=NULL;
        }


if(!empty($_POST['description'])) {
    $desc=$_POST['description'];
    } else {
        $_POST['description']=NULL;
        
        }
        }


 

require_once ('../mysql_connect.php'); // Connect to the database.

 

// Are we looking at a particular artist?

if(empty($errors)) {
    require_once('./connect/mysql_connect.php');
    $query="INSERT INTO artisttable concat(artist_fname, artist_lname) as name,price, description) VALUES ('$afn','aln','$price', '$description');
                                        
    $result=@mysql_query($query);
    if($result) {
    
echo '<table border="0" width="90%" cellspacing="3" cellpadding="3" align="center">

<tr>

<td align="left" width="20%"><b>Artist</b></td>

<td align="left" width="20%"><b>Print Name</b></td>

<td align="left" width="40%"><b>Description</b></td>

<td align="right" width="20%"><b>Price</b></td>

</tr>';

 

// Display all the prints, linked to URLs.

$result = mysqli_query ($dbc, $query);

while ($row = mysqli_fetch_array ($result, MYSQL_ASSOC)) {

 

            // Display each record.

            echo "   <tr>

                        <td align=\"left\"><a href=\"browse_prints.php?aid={$row['artist_id']}\">{$row['name']}</a></td>

                        <td align=\"left\"><a href=\"view_print.php?pid={$row['print_id']}\">{$row['print_name']}</td>

                        <td align=\"left\">{$row['description']}</td>

                        <td align=\"right\">\${$row['price']}</td>

            </tr>\n";

           

} // End of while loop.

 

echo '</table>'; // Close the table.

 

mysqli_close($dbc); // Close the database connection.

include ('./includes/footer.html');

 

?>

 

///////////////////////////////


----- Original Message ----
From: anang tawiah <anangtt at hotmail.com>
To: talk at lists.nyphp.org
Sent: Tuesday, December 11, 2007 12:16:56 PM
Subject: [nycphp-talk] Help in creating multiple columns and rows to display product name pice and images





.hmmessage P
{
margin:0px;padding:0px;}
body.hmmessage
{
FONT-SIZE:10pt;FONT-FAMILY:Tahoma;}



I am a relative php amateur who is trying to kind of master
the php 5 syntax and I have using Larry Ulmanns php and mysql 2nd edition
book.  The problem I am facing is that in
the authors example he lists all the results.


  
 

What I want to do for this project is to display the
following product information in rows and columns whereby; 


  
 

i
     could  specify the number of columns
     and rows per page (using php 5 syntax)And finally
     I also want to paginate the result set (using php 5 syntax)

  
 

I know this might sound trivial to most of you ‘Gurus’ on
this list (which is why I finally decided to stop trying to figure it out
myself and ask for help) and I appreciate your help in advance.


  
 

  
 



  
 




<?php # Script 14.6 -
browse_prints.php
 

// This page displays the available
prints (products).
 

  
 

// Set the page title and include
the HTML header.
 

$page_title = 'Browse the Prints';
 

include ('./includes/header.html');
 

  
 

require_once
('../mysql_connect.php'); // Connect to the database.
 

  
 

// Are we looking at a particular
artist?
 

if (isset($_GET['aid'])) {
 

            $aid
= (int) $_GET['aid'];
 

            if
($aid > 0) {
 

                        $query
= "SELECT artists.artist_id, CONCAT_WS(' ', first_name, middle_name,
last_name) AS name, print_name, price, description, print_id FROM artists,
prints WHERE artists.artist_id = prints.artist_id AND prints.artist_id =$aid
ORDER BY prints.print_name";
 

            }
else {
 

                        $query
= "SELECT artists.artist_id, CONCAT_WS(' ', first_name, middle_name,
last_name) AS name, print_name, price, description, print_id FROM artists,
prints WHERE artists.artist_id = prints.artist_id ORDER BY artists.last_name
ASC, prints.print_name ASC";
 

            }
 

} else {
 

            $query
= "SELECT artists.artist_id, CONCAT_WS(' ', first_name, middle_name,
last_name) AS name, print_name, price, description, print_id FROM artists,
prints WHERE artists.artist_id = prints.artist_id ORDER BY artists.last_name ASC,
prints.print_name ASC";
 

}
 

  
 

// Create the table head.
 

echo '<table border="0"
width="90%" cellspacing="3" cellpadding="3"
align="center">
 

<tr>
 

<td align="left"
width="20%"><b>Artist</b></td>
 

<td align="left"
width="20%"><b>Print Name</b></td>
 

<td align="left"
width="40%"><b>Description</b></td>
 

<td align="right"
width="20%"><b>Price</b></td>
 

</tr>';
 

  
 

// Display all the prints, linked to
URLs.
 

$result = mysqli_query ($dbc,
$query);
 

while ($row = mysqli_fetch_array
($result, MYSQL_ASSOC)) {
 

  
 

            //
Display each record.
 

            echo
"   <tr>
 

                        <td
align=\"left\"><a
href=\"browse_prints.php?aid={$row['artist_id']}\">{$row['name']}</a></td>
 

                        <td
align=\"left\"><a
href=\"view_print.php?pid={$row['print_id']}\">{$row['print_name']}</td>
 

                        <td
align=\"left\">{$row['description']}</td>
 

                        <td
align=\"right\">\${$row['price']}</td>
 

            </tr>\n";
 

            
 

} // End of while loop.
 

  
 

echo '</table>'; // Close the
table.
 

  
 

mysqli_close($dbc); // Close the
database connection.
 

include ('./includes/footer.html');
 

  
 



?>


  
 




  
 

  
 

Thanks,



 








-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20071211/54cea675/attachment.html>