PHP - Moved: Help With Coding A Product List Page - Urgent

Hi,

I am just wondering if there is any way that I can link Google Maps which will then link to my product stocklist - see attachment for what I am trying to achieve.

Please let me know if this is possible.

Thanks,

This topic has been moved to Ajax Help.

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

hi

i have generated a product list from a mysql table called product_list, once i enter a new product in to the table the product will be shown in the generated list and the list will grow and the table grows.  and i want to allow user the edit/delete/save the products from the generated table, i have no idea how to do it and what is the algorithmic idea to do it so. here is the php and the html code.

<!--Body container  for creating a new product in to the list-->
<div class="body_orderviewform">
  <form name="form1" method="post" action="upload_file.php" enctype="multipart/form-data">
    <p>
      <label for="user_id">User ID:</label>
      <input type="text" name="user_id" id="user_id">
      <label for="customer_name">Customer Name:</label>
      <input type="text" name="customer_name" id="customer_name">
      <label for="customer_family">Customer_family</label>
      <input type="text" name="customer_family" id="customer_family">
      <label for="freelancer_name">Purchaser:</label>
      <input name="freelancer_name" type="text" id="freelancer_name">
     
      <? if (isset($_COOKIE['picAdd'])) echo $_COOKIE['picAdd'];?>
     
    </p>
 <!------------------------------------------------------------------------------------------------------- for generating the list -->
   
<div  class="div.neworder_list" >   

   <div  class="div.neworder_listheader" align="center">
   
    <table width="637" border="1" >
      <tr>
        <td width="193"><label for="link">link:</label>
          <label for="link_new"></label>
          <input type="text" name="link_new" id="link_new"></td>
        <td width="202"><label for="unitprice">Unit Price:</label>
          <label for="Unit_price_new"></label>
          <input type="text" name="Unit_price_new" id="Unit_price_new"></td>
        <td width="220"><label for="qty">Quantity:</label>
          <label for="quantity_new"></label>
          <input type="text" name="quantity_new" id="quantity_new"></td>
      </tr>
      <tr>
        <td><label for="express">Express Fee:</label>
          <label for="express_new"></label>
          <input type="text" name="express_new" id="express_new"></td>
        <td><label for="commission_new">Commission:</label>
          <input type="text" name="commission_new" id="commission_new"></td>
        <td><label for="customer_description">Description</label>
          <label for="description_new"></label>
          <textarea name="description_new" id="description_new" cols="45" rows="5"></textarea></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">Picture Upload:
              <input type="hidden" name="<?php echo ini_get("session.upload_progress.name");?>" value="123" />
              <input name="file" type="file" autofocus="autofocus"/>
              <br />


      </tr>
      <tr>
        <td colspan="3"><input type="reset" name="reset" id="reset" value="Reset">
        <input type="submit" name="submit" id="submit" value="Submit The Product"></td>
      </tr>
    </table>

 
</form>   
</div>
   
<div class="neworder_listview">
  <p>
  <form action="" method="post" name="list">
    <input type="submit" name="del" id="del" value="Save">
    <input type="submit" name="save" id="save" value="Del">
  </p>
  <table width="1022" border="1" align="center">
    <tr>
      <th width="24" scope="col">&nbsp;</th>
    <th width="24" scope="col">Row#</th>
    <th width="137" scope="col">Manager</th>
    <th width="137" scope="col">Purchaser Desc</th>
    <th width="40" scope="col"><p>Link</p>
      <p>/Ссылки</p></th>
    <th width="53" scope="col">ФОТО</th>
    <th width="50" scope="col">Unit Price/Цена за еденицу товара</th>
    <th width="46" scope="col">Quantity/ Кол-во</th>
    <th width="138" scope="col">Total Unit Price/ Общая цена</th>
    <th width="89" scope="col">Express/Доставка по Китаю</th>
    <th width="119" scope="col">Description/Описание</th>
    <th width="89" scope="col">ADDITIONAL LINKS/ЗAMЕНЫ</th>
    </tr>
   


<?php

   $username = "my username";
   $password = "my pass";
   $database = "userinfo";
   $link = mysql_connect("localhost", "$username", "$password");
   
   if(!$link) {echo("Failed to establish connection to mysql server");
               exit();}

   $status = mysql_select_db($database);
   $query = "SELECT * FROM order_list";
   $result = mysql_query($query);
   $num = mysql_num_rows($result);
   $i=0;
 
 
 
  while ($i < $num) {
   $field1_name=mysql_result($result,$i,"admin_st");
   $field2_name=mysql_result($result,$i,"freelancer_st");
   $field3_name=mysql_result($result,$i,"link");
   $field4_name=mysql_result($result,$i,"picture");
   $field5_name=mysql_result($result,$i,"unitprice");
   $field6_name=mysql_result($result,$i,"qty");
   $field7_name=mysql_result($result,$i,"express");
   $field8_name=mysql_result($result,$i,"customer_st");
   $i++;
    }
 
?>







<?php
$i=0;
$row=1;
while ($i < $num) {

$f1=mysql_result($result,$i,"admin_st");
$f2=mysql_result($result,$i,"freelancer_st");
$f3=mysql_result($result,$i,"link");
$f4=mysql_result($result,$i,"pic_address");
$f5=mysql_result($result,$i,"unitprice");
$f6=mysql_result($result,$i,"qty");
$f7=mysql_result($result,$i,"express");
$f8=mysql_result($result,$i,"customer_st");
$totao_unit_price = $f5*$f6;
?>
  <tr>
    <td><input type="checkbox" name="del_chbox" id="del_chbox">
   <td><p><font face="Arial"><input name="row_txtbox" type="text" id="row_txtbox" size="2" value="<?php echo $row; ?>"></font></td>
   <td><p><font face="Arial"> <textarea name="manager_txtbox" cols="10" id="manager_txtbox"><?php echo $f1; ?></textarea></font></td>
   <td><p><font face="Arial">        <textarea name="purchase_txtbox" cols="10" id="purchase_txtbox"><?php echo $f2; ?></textarea>
</font></td>


   <td><font face="Arial"><a href="<?php $f3 ?>" target="_blank"><?php echo $f3; ?></a></font></td>
   <td><font face="Arial"><img src="<?php echo $f4;?>" width="100" align="middle"100></font></td>
   <td><font face="Arial"><input name="unitprice_txtbox" type="text" id="unitprice_txtbox" size="2" value="<?php echo $f5; ?>"></font></td>
   <td><font face="Arial"> <input name="qty_txtbox" type="text" id="qty_txtbox" size="2" value="<?php echo $f6; ?>"></font></td>
   <td><p><font face="Arial"><?php echo $totao_unit_price; ?></font></td>
   <td><p><font face="Arial"><input name="express2" type="text" id="express3" size="2" value="<?php echo $f7; ?>"></font></td>
   <td><p><font face="Arial"> <textarea name="custdesc_txtbox" cols="20" id="custdesc_txtbox"><?php echo $f8; ?></textarea></font></td>
    <td><input name="express2" type="text" id="express3" size="2" value="<?php echo "new link" ?>"></td>
   </tr>

  <p>
    <?php
$i++;
$row++;
}
?>
</table>
   
  </p>
  <p>&nbsp;</p>
  </form>

I am wanting to create a basic product listing page for a product category called "Belts".

My latest attempt was this, but I got an error:
PHP Code:
Code: [Select]
$query = "select * from products";
$result = mysql_query($query);
while($row=mysql_fetch_assoc($result)) {
    print ".$row['name'] where category = 'Belts'.$row['colour'] where category = 'Belts'";
}

Quote

PHP Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING


This is what my MySQL table looks like:
http://i54.tinypic.com/2j1si8w.png

I image what I am trying to do will print "Somename Black, ProductName2 Brown"?

I'm not really interested in styling at the moment, I just want to see the PHP-MySQL work at the most basic level.

I am unsure what the error cosde means. Can anyone see a fault in my code?

This topic has been moved to PHP Applications.

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

Hi.  This question is building off of things you all helped me with earlier in my other two threads.  (I go no sleep last night, so sorry if my thinking is a bit off!)

Now that I know how to create a gallery page - as far as HTML goes - to display a listing of free add-on items you get when you subscribe, I need to extend those concepts to my next project.

I need to create a product catalog page for my e-commerce site.  (Not sure if there is a better name?)

This is the page you would see if you went to an e-commerce site and started shopping.

At the top of the page would be my company mast.  And beneath that, on the left side of the screen would be a menu listing different areas of my online store.  And to the right, would be the area where you see the actual products.  (And I would be using the same techniques to display items on the right hand side as I did in my earlier gallery.

So here is where I could use some hep with the logic of this page...

Let's say my website is located at www.mystore.com

And in the left menu bar, I have these categories:  Music, TV Shows, Movies, Gear

And in the right pane I want to display items for the chosen section.

So if you chose "Music", I am thinking the hyperlink behind it might read; www.mystore.com/music/   with a mod_rewrite to www.mystore.com?category=music

And then I would have PHP code that would fire when the page is reloaded to www.mystore.com?category=music and it would query MySL and display all music related products in the right pane.

(Note: It is understood I am only using HTML and PHP with no Javascript.)

How does the above approach sound?

 

Hello.  I just created a product gallery containing thumbnails of items that I will be selling.

When a user click on on of the thumbnails, I want a product details page to appear with more details about the chosen product

Could use some feedback if I am going about things the right way...

Step 1: User goes to my gallery located he   www.mysite.com/store/product-gallery.php

Step 2: System displays a page of thumbnails representing items that I am selling.

Step 3: User click on a given thumbnail which is a hyperlink to:  www.mysite.com/store/products/4571

Step 4: System rewrites the URL as such:  www.mysite.com/store/products.php?sku=4571

Step 5: System queries MySQL and retrieves record for sku 4571

Step 6: System displays product details for the chosen item in Step 3 which is sku 4571

 

How does that sound?

 

This topic has been moved to Miscellaneous.

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

Hi, I have this snippet in my page:

<?php echo $EM_Booking->get_price(true) * $EM_Booking->get_spaces(); ?>

The page executes with no hitches except the price is not multiplied by the spaces. I get and echo of "0".   I'm new to this. Any help would be greatly appreciated and thanks!

Basically I have a form and What I want it to do is when a user selects the 'For Sale' radio button the minimum and maximum prices will be displayed in the drop down list as "70,000"+ but when the user selects the 'To Rent' radial button then the minimum and maximum drop down list prices will change to e.g. "200"+. How would I do this?

Heres my Code for the form:
Code: [Select]

<div id="ptype">

<input type="radio" class="styled" name="ptype" value="forsale"/> For Sale

<p class="increase">
<input type="radio" class="styled" name="ptype" value="forrent"/> To Rent
</p>
<p class="increase">
<input type="radio" class="styled" name="ptype" value="any"/> Any
</p>

</div>
</td>
</tr>

</table>

<div id="table2">
<table id="NBtable">
<tr>
<td><p class="NBS">Number of bedrooms:</p></td>
<td><div id="NB">

<select name="min bedrooms">
<?php
$roomLimit = 5;
for($minRooms = 0; $minRooms <= $roomLimit; $minRooms++){
  if ($minRooms == 0){
    echo"<option value=\"0\" selected=\"selected\">No Min</option>";
  }
  else{
    echo "<option value=\"$minRooms\">$minRooms</option>";
  }
}
?>
</select> to

<select name="max bedrooms">
<?php
$roomLimit = 5;
for($maxRooms = 0; $maxRooms <= $roomLimit; $maxRooms++){
  if ($maxRooms == 0){
    echo"<option value=\"0\" selected=\"selected\">No Max</option>";
  }
  else{
    echo "<option value=\"$maxRooms\">$maxRooms</option>";
  }
}
?>
</select>
</div>
</td>

<td><p class="PR">Price range:</p></td>
<td><div id="PR">

<select name="min price" style='width:80px;'>
<?php
$priceLimit = 350;
for($minPrice = 40; $minPrice <= $priceLimit; $minPrice =( $minPrice+ 10)){
  if ($minPrice == 40){
    echo"<option value=\"0\" selected=\"selected\">No Min</option>";
  }
  else{
    echo "<option value=\"$minPrice000\">&pound;$minPrice,000</option>";
  }
}
?> </select> to

<select name="max price" style='width:80px;'>
<?php
$priceLimit = 350;
for($maxPrice = 40; $maxPrice <= $priceLimit; $maxPrice =( $maxPrice+ 10)){
  if ($maxPrice == 40){
    echo"<option value=\"0\" selected=\"selected\">No Max</option>";
  }
  else{
    echo "<option value=\"$maxPrice000\">&pound;$maxPrice,000</option>";
  }
}
?>
</select>
Thanks in advance.

I have a product page which populates all my products in one page. I have also a detail page which gives details on a product which i wanted to know. My problem is when I am going to click on the product that I want the detail page shows incorrect product details. I just want one detail product page so that it will be easy to edit the page in the future.

I am asking an Idea on how to make one detail page in all of my products.. thanks...

This topic has been moved to Third Party PHP Scripts.

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

This topic has been moved to Miscellaneous.

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

This topic has been moved to Application Design.

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