|
PHP - Generating A List From Available Products In Database.
Hello everyone,
I've been working on this for about 2 days now, and I just can't seem to figure it out so I need some help from someone here. I have a database with three items (will be more, but for now there's three). The database keeps a record of the days that each item is reserved. I want to be able to select and generate a list of items that are available on a specific day. Here is what I have so far: Code: [Select] <?php $result = mysql_query("SELECT `prodid` FROM reservations WHERE `resdate` = '$resdate'") or die (mysql_error()); while ($row = mysql_fetch_row($result)) { $resprodid = $row[0]; $result2 = mysql_query("SELECT `prodid`,`prodname` FROM products"); $row2 = mysql_fetch_row($result2); $prodid = $row2[0]; $prodname= $row2[1]; if ($prodid != $resprodid) { echo $prodid; } } ?> The result that I'm getting are not correct. I either get only one unit listed, or none. Any help would be appreciated. Thanks! Similar TutorialsHello, I'm generating a list of questions from a database, say $questions. I'd like to number the questions AFTER I load them from the database (I know that I could enter a number associated with them in the database, but it could get tricky, as the questions will continually be updated and deleted). My question, then, is how can a create a new array which associates each question with a number. Thank you! Hi, I have a trouble figuring out how to properly convert a list of product data from XML into CSV format. My source is a XML file containing a list of products with attributes like color, size, material etc. with the following structu Code: [Select] <?xml version="1.0" encoding="utf-8" ?> <store> <products> <product> <name>T-Shirt</name> <price>19.00</price> <attributes> <attribute> <name>Color</name> <options> <option> <name>White</name> <price>0.00</price> </option> <option> <name>Black</name> <price>0.00</price> </option> <option> <name>Blue</name> <price>0.00</price> </option> </options> </attribute> <attribute> <name>Size</name> <options> <option> <name>XS</name> <price>-5.00</price> </option> <option> <name>S</name> <price>-5.00</price> </option> <option> <name>M</name> <price>0.00</price> </option> <option> <name>L</name> <price>0.00</price> </option> <option> <name>XL</name> <price>5.00</price> </option> </options> </attribute> </attributes> </product> <product> <name>Sweatshirt</name> <price>49.00</price> <attributes> <attribute> <name>Color</name> <options> <option> <name>White</name> <price>0.00</price> </option> <option> <name>Black</name> <price>0.00</price> </option> </options> </attribute> <attribute> <name>Size</name> <options> <option> <name>XS</name> <price>-10.00</price> </option> <option> <name>M</name> <price>0.00</price> </option> <option> <name>XL</name> <price>10.00</price> </option> </options> </attribute> <attribute> <name>Material</name> <options> <option> <name>Cotton</name> <price>10.00</price> </option> <option> <name>Polyester</name> <price>0.00</price> </option> </options> </attribute> </attributes> </product> <product> <name>Earrings</name> <price>29.00</price> </product> </products> </store> Each product has a number of elements like name, price etc. but also a random number of attributes (like color, size, material etc.) that also have a random number of options. Each option can affect the price of the product, so ordering a XS sized t-shirt can be cheaper than ordering a XL sized t-shirt. I would like to end up with a CSV representing one attribute combination on each line. In my example that would result in 3 colors x 5 sizes = 15 lines for the T-Shirt , 2 colors x 3 sizes x 2 materials = 12 lines for the Sweatshirt and 1 line for the Earrings without any attributes: Code: [Select] name,price,color,size,material T-Shirt,14.00,White,XS, T-Shirt,14.00,Black,XS, T-Shirt,14.00,Blue,XS, T-Shirt,14.00,White,S, T-Shirt,14.00,Black,S, T-Shirt,14.00,Blue,S, T-Shirt,19.00,White,M, T-Shirt,19.00,Black,M, T-Shirt,19.00,Blue,M, T-Shirt,19.00,White,L, T-Shirt,19.00,Black,L, T-Shirt,19.00,Blue,L, T-Shirt,24.00,White,XL, T-Shirt,24.00,Black,XL, T-Shirt,24.00,Blue,XL, Sweatshirt,49.00,White,XS,Cotton Sweatshirt,49.00,Black,XS,Cotton Sweatshirt,59.00,White,M,Cotton Sweatshirt,69.00,Black,M,Cotton Sweatshirt,69.00,White,XL,Cotton Sweatshirt,69.00,Black,XL,Cotton Sweatshirt,39.00,White,XS,Polyester Sweatshirt,39.00,Black,XS,Polyester Sweatshirt,49.00,White,M,Polyester Sweatshirt,49.00,Black,M,Polyester Sweatshirt,59.00,White,XL,Polyester Sweatshirt,59.00,Black,XL,Polyester Earrings,29.00,,, I already managed to generate the CSV Output for simple products like the Earrings and products with just one attribute, but am struggling to come up with a way to generate all possible product attribute combinations for products with more than one attribute. My miserable attempts at this so far have produced following code: Code: [Select] <?php mb_internal_encoding("UTF-8"); header('Content-Type: text/html; charset=utf-8'); $source = "example.xml"; $handle = fopen($source, "r"); $fp = fopen('export.csv', 'w'); $xml = simplexml_load_file($source); // Generate list of attributes (for csv header etc.) $header_attributes = array(); foreach ($xml->products->product as $product) { if(isset($product->attributes)) { foreach($product->attributes->attribute as $attribute) { array_push($header_attributes, $attribute->name); } } } $header_attributes = array_unique($header_attributes); $csvheader = array( 'name','price' // these exist for all products, could also include weight, image, description, special price etc... ); $static_csvheadercount = count($csvheader); foreach($header_attributes as $attribute) { array_push($csvheader, $attribute); // add variable number of attribute fields to csv header } fputcsv($fp, $csvheader); foreach ($xml->products->product as $product) { // loop through each product if(isset($product->attributes)) $simple = 0; else $simple = 1; if($simple == 1) { // if product is a simple product with no attributes $output=array(); array_push($output,(string)$product->name); array_push($output,(string)$product->price); for($i = $static_csvheadercount + $attribute_position; $i < count($csvheader); $i++) { array_push($output, ''); } fputcsv($fp, $output); } else { // is a configurable product with attributes $json = json_encode($product->attributes); $attributes = json_decode($json, TRUE); $attributes_number = count($product->attributes->attribute); if($attributes_number > 1) { // if product has more than 1 attributes so we have to generate each attribute combination // // I'm trying to figure out what should happen here // } else { // if product has only one attribute $attributename = (string)$product->attributes->attribute->name; $attribute_position = array_search($attributename, $header_attributes); $options_number = count($product->attributes->options->option); $pos = 1; foreach($attributes['attribute']['options']['option'] as $option) { $output=array(); array_push($output,(string)$product->name); array_push($output,(string)$product->price); for($i = $static_csvheadercount - 1; $i < ($static_csvheadercount + $attribute_position); $i++) { array_push($output, ''); } $output[$static_csvheadercount + $attribute_position] = $option['name']; for($i = $static_csvheadercount + $attribute_position; $i < count($csvheader) - 1 ; $i++) { array_push($output, ''); } fputcsv($fp, $output); $pos++; } $output=array(); array_push($output,(string)$product->name); array_push($output,(string)$product->price); for($i = $static_csvheadercount; $i < count($csvheader); $i++) { array_push($output, ''); } fputcsv($fp, $output); } } } ?> I've been stuck at this problem for hours unable to figure out a solution. Can someone give a few tips or pointer how to achieve the output for products with multiple attributes? I am having an issue trying to get products that I am entering through my admin panel to go into my database. I am thinking that the programmer of the script might have forgot some code possibly, but everything else does get inserted into the database regarding categories, manufactures etc. Here is the insert product php script. My db and functions are set to go to my database with website name/password etc.
<?php
if(!isset($_SESSION['customer_email'])){
echo "<script> window.open('../checkout.php','_self'); </script>";
}
$customer_email = $_SESSION['customer_email'];
$get_customer = "select * from customers where customer_email='$customer_email'";
$run_customer = mysqli_query($con,$get_customer);
$row_customer = mysqli_fetch_array($run_customer);
$customer_id = $row_customer['customer_id'];
$select_general_settings = "select * from general_settings";
$run_general_settings = mysqli_query($con,$select_general_settings);
$row_general_settings = mysqli_fetch_array($run_general_settings);
$product_vendor_status = $row_general_settings["new_product_status"];
?>
<script src="//cdn.tinymce.com/4/tinymce.min.js"></script>
<script>tinymce.init({ selector:'#product_desc,#product_features' });</script>
<div class="row"><!-- 2 row Starts -->
<div class="col-lg-12"><!-- col-lg-12 Starts -->
<div class="panel panel-default"><!-- panel panel-default Starts -->
<div class="panel-heading"><!-- panel-heading Starts -->
<h3 class="panel-title">
<i class="fa fa-money fa-fw"></i> Insert Product
</h3>
</div><!-- panel-heading Ends -->
<div class="panel-body"><!-- panel-body Starts -->
<form id="insert_product_form" method="post" enctype="multipart/form-data"><!-- form-horizontal Starts -->
<div class="row"><!-- 2 row Starts -->
<div class="col-md-9"><!-- col-md-9 Starts -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Title </label>
<input type="text" name="product_title" class="form-control" required >
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Seo Description </label>
<textarea name="product_seo_desc" class="form-control" maxlength="230" placeholder="Most search engines use a maximum of 230 chars for the description."></textarea>
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Url </label>
<input type="text" name="product_url" class="form-control" required >
<br>
<p style="font-size:15px; font-weight:bold;">
Product Url Example : navy-blue-t-shirt
</p>
</div><!-- form-group Ends -->
<div class="form-group"><!-- form-group Starts -->
<label> Product Tabs </label>
<ul class="nav nav-tabs"><!-- nav nav-tabs Starts -->
<li class="active">
<a data-toggle="tab" href="#description"> Product Description </a>
</li>
<li>
<a data-toggle="tab" href="#features"> Product Features </a>
</li>
<li>
<a data-toggle="tab" href="#video"> Sounds And Videos </a>
</li>
</ul><!-- nav nav-tabs Ends -->
<div class="tab-content"><!-- tab-content Starts -->
<div id="description" class="tab-pane fade in active"><!-- description tab-pane fade in active Starts -->
<br>
<textarea name="product_desc" class="form-control" rows="15" id="product_desc"></textarea>
</div><!-- description tab-pane fade in active Ends -->
<div id="features" class="tab-pane fade in"><!-- features tab-pane fade in Starts -->
<br>
<textarea name="product_features" class="form-control" rows="15" id="product_features"></textarea>
</div><!-- features tab-pane fade in Ends -->
<div id="video" class="tab-pane fade in"><!-- video tab-pane fade in Starts -->
<br>
<textarea name="product_video" class="form-control" rows="15"></textarea>
</div><!-- video tab-pane fade in Ends -->
</div><!-- tab-content Ends -->
</div><!-- form-group Ends -->
<div class="form-group" id="product_weight"><!-- form-group Starts -->
<label> Product Weight <small> (kg)</small> </label>
<input type="text" name="product_weight" class="form-control">
</div><!-- form-group Ends -->
<div class="form-group" id="product_price"><!-- form-group Starts -->
<label> Product Price </label>
<input type="text" name="product_price" class="form-control" required>
</div><!-- form-group Ends -->
<div class="form-group" id="product_psp_price"><!-- form-group Starts -->
<label> Product Sale Price </label>
<input type="text" name="psp_price" class="form-control">
</div><!-- form-group Ends -->
</div><!-- col-md-9 Ends -->
<div class="col-md-3"><!-- col-md-3 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Select A Product Type </label>
<select class="form-control" name="product_type"><!-- select manufacturer Starts -->
<option value="physical_product"> (Physical Product) Simple Product </option>
<option value="digital_product"> (Digital Product) Downloadable Product </option>
<option value="variable_product"> (Variable Product) Advanced Product </option>
</select><!-- select manufacturer Ends -->
</div><!-- form-group Ends -->
<div class="form-group"><!-- form-group Starts -->
<label> Select A Manufacturer </label>
<select class="form-control" name="manufacturer"><!-- select manufacturer Starts -->
<option> Select A Manufacturer </option>
<?php
$get_manufacturer = "select * from manufacturers";
$run_manufacturer = mysqli_query($con,$get_manufacturer);
while($row_manufacturer= mysqli_fetch_array($run_manufacturer)){
$manufacturer_id = $row_manufacturer['manufacturer_id'];
$manufacturer_title = $row_manufacturer['manufacturer_title'];
echo "<option value='$manufacturer_id'>
$manufacturer_title
</option>";
}
?>
</select><!-- select manufacturer Ends -->
</div><!-- form-group Ends -->
<div class="form-group"><!-- form-group Starts -->
<label> Product Category </label>
<select name="product_cat" class="form-control" >
<option> Select a Product Category </option>
<?php
$get_p_cats = "select * from product_categories";
$run_p_cats = mysqli_query($con,$get_p_cats);
while ($row_p_cats=mysqli_fetch_array($run_p_cats)) {
$p_cat_id = $row_p_cats['p_cat_id'];
$p_cat_title = $row_p_cats['p_cat_title'];
echo "<option value='$p_cat_id' >$p_cat_title</option>";
}
?>
</select>
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Category </label>
<select name="cat" class="form-control" >
<option> Select a Category </option>
<?php
$get_cat = "select * from categories";
$run_cat = mysqli_query($con,$get_cat);
while ($row_cat=mysqli_fetch_array($run_cat)) {
$cat_id = $row_cat['cat_id'];
$cat_title = $row_cat['cat_title'];
echo "<option value='$cat_id'>$cat_title</option>";
}
?>
</select>
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Image 1 </label>
<input type="file" name="product_img1" class="form-control" required >
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Image 2 </label>
<input type="file" name="product_img2" class="form-control">
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Image 3 </label>
<input type="file" name="product_img3" class="form-control">
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Keywords </label>
<input type="text" name="product_keywords" class="form-control">
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Label </label>
<input type="text" name="product_label" class="form-control">
</div><!-- form-group Ends -->
</div><!-- col-md-3 Ends -->
</div><!-- 2 row Ends -->
<div class="form-group" id="product-stock-management"><!-- form-group Starts -->
<label> Product Inventory Stock Management </label>
<div class="panel panel-default"><!-- panel panel-default Starts -->
<div class="panel-heading"><!-- panel-heading Starts -->
<strong> Inventory - Stock Options </strong>
</div><!-- panel-heading Ends -->
<div class="panel-body"><!--panel-body Starts -->
<div class="row"><!-- row Starts -->
<div class="col-sm-6" id="stock-status"><!-- col-sm-6 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Stock Status </label>
<select class="form-control" name="stock_status" required><!-- select manufacturer Starts -->
<option value="instock">In stock</option>
<option value="outofstock">Out of stock</option>
<option value="onbackorder">On backorder</option>
</select><!-- select manufacturer Ends -->
</div><!-- form-group Ends -->
</div><!-- col-sm-6 Ends -->
<div class="col-sm-6"><!-- col-sm-6 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Enable stock management at product level? </label>
<div class="radio">
<label>
<input type="radio" name="enable_stock" value="yes" required> Yes
</label>
<label>
<input type="radio" name="enable_stock" value="no" checked required> No
</label>
</div>
</div><!-- form-group Ends -->
</div><!-- col-sm-6 Ends -->
</div><!-- row Ends -->
<div class="row" id="stock-management-row"><!-- row Starts -->
<div class="col-sm-6"><!-- col-sm-6 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Stock Quantity </label>
<input type="number" name="stock_quantity" value="0" class="form-control" required>
</div><!-- form-group Ends -->
</div><!-- col-sm-6 Ends -->
<div class="col-sm-6"><!-- col-sm-6 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Allow backorders? </label>
<select class="form-control" name="allow_backorders" required><!-- select manufacturer Starts -->
<option value="no">Do not allow</option>
<option value="notify">Allow, but notify customer</option>
<option value="yes">Allow</option>
</select><!-- select manufacturer Ends -->
</div><!-- form-group Ends -->
</div><!-- col-sm-6 Ends -->
</div><!-- row Ends -->
</div><!--panel-body Ends -->
</div><!-- panel panel-default Ends -->
</div><!-- form-group Ends -->
</form><!-- form-horizontal Ends -->
<div class="form-group" id="variable_product_options"><!-- form-group Starts -->
<label> Variable Product Options </label>
<div class="panel panel-default"><!-- panel panel-default Starts -->
<div class="panel-heading"><!-- panel-heading Starts -->
<ul class="nav nav-tabs"><!-- nav nav-tabs Starts -->
<li class="active">
<a data-toggle="tab" href="#product_attributes"> Product Attributes </a>
</li>
<li>
<a data-toggle="tab" href="#product_variations"> Product Variations </a>
</li>
</ul><!-- nav nav-tabs Ends -->
</div><!-- panel-heading Ends -->
<div class="panel-body"><!--panel-body Starts -->
<div class="tab-content"><!-- tab-content Starts -->
<div id="product_attributes" class="tab-pane fade in active"><!-- product_attributes tab-pane fade in active Starts -->
<form id="insert_attribute_form" method="post"><!-- form Starts -->
<div class="row"><!-- row Starts -->
<div class="col-sm-4"><!-- col-sm-4 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Name: </label>
<input type="text" name="attribute_name" class="form-control" required>
</div><!-- form-group Ends -->
</div><!-- col-sm-4 Ends -->
<div class="col-sm-8"><!-- col-sm-8 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Value(s): </label>
<textarea name="attribute_values" class="form-control" placeholder="Enter some attributes by '|' separating values." required></textarea>
</div><!-- form-group Ends -->
</div><!-- col-sm-8 Ends -->
</div><!-- row Ends -->
<div class="form-group"><!-- form-group Starts -->
<input type="submit" value="Insert Product Attribute" class="btn btn btn-primary">
</div><!-- form-group Ends -->
</form><!-- form Ends -->
<table class="table table-hover table-bordered table-striped"><!-- table table-hover table-bordered table-striped Starts -->
<thead><!-- thead Starts -->
<tr>
<th>Attribute Name:</th>
<th>Attribute Value(s):</th>
<th>Actions:</th>
</tr>
</thead><!-- thead Ends -->
<tbody><!-- tbody Starts -->
<?php
$random_id = 152;
$select_product_attributes = "select * from product_attributes where product_id='$random_id'";
$run_product_attributes = mysqli_query($con,$select_product_attributes);
while($row_product_attributes = mysqli_fetch_array($run_product_attributes)){
$attribute_id = $row_product_attributes["attribute_id"];
$attribute_name = $row_product_attributes["attribute_name"];
$attribute_values = $row_product_attributes["attribute_values"];
?>
<tr id="tr-attribute-<?php echo $attribute_id; ?>">
<td>
<div class="edit" data-attribute="<?php echo $attribute_id; ?>"><?php echo $attribute_name; ?></div>
<input type="text" id="attribute-name" class="input-edit form-control" data-attribute="<?php echo $attribute_id; ?>" value="<?php echo $attribute_name; ?>">
</td>
<td>
<div class="edit" data-attribute="<?php echo $attribute_id; ?>"><?php echo $attribute_values; ?></div>
<input type="text" id="attribute-values" class="input-edit form-control" data-attribute="<?php echo $attribute_id; ?>" value="<?php echo $attribute_values; ?>">
</td>
<td>
<div class="btn-group">
<a href="#" class="edit-product-attribute btn btn-primary btn-sm" data-attribute="<?php echo $attribute_id; ?>">
<i class="fa fa-pencil"></i> Edit
</a>
<a href="#" class="save-product-attribute btn btn-success btn-sm" data-attribute="<?php echo $attribute_id; ?>">
<i class="fa fa-floppy-o"></i> Save
</a>
<a href="#" class="delete-product-attribute btn btn-danger btn-sm" data-attribute="<?php echo $attribute_id; ?>">
<i class="fa fa-trash-o"></i> Delete
</a>
</div>
</td>
</tr>
<?php } ?>
</tbody><!-- tbody Ends -->
</table><!-- table table-hover table-bordered table-striped Ends -->
</div><!-- product_attributes tab-pane fade in active Ends -->
<div id="product_variations" class="tab-pane fade in"><!-- product_variations tab-pane fade in Starts -->
<form id="product-variations-form" method="post" enctype="multipart/form-data"><!-- form Starts -->
<div class="form-group row"><!-- form-group Starts -->
<label class="col-sm-3 control-label"> Default Form Values: </label>
<div class="col-sm-9"><!-- col-sm-10 Starts -->
<div class="row" id="default_form_values"><!-- row default_form_values Starts -->
</div><!-- row default_form_values Ends -->
<span class="help-block">
These are the product attributes that will be pre-selected on the frontend.
</span>
</div><!-- col-sm-9 Ends -->
</div><!-- form-group Ends -->
<hr class="variation-hr">
<div class="form-group row"><!-- form-group Starts -->
<label class="col-sm-1 control-label"> Actions: </label>
<div class="col-sm-10"><!-- col-sm-10 Starts -->
<select class="form-control" id="action_select"><!-- select manufacturer Starts -->
<option value="add_variation"> Add A New Variation </option>
<option value="create_variations_from_attributes"> Create New Variations From All Attributes </option>
<option value="delete_all_variations"> Delete All Variations </option>
</select><!-- select manufacturer Ends -->
</div><!-- col-sm-10 Ends -->
<div class="col-sm-1"><!-- col-sm-1 Starts -->
<button type="button" id="go_button" class="btn btn-success form-control"> Go </button>
</div><!-- col-sm-1 Ends -->
</div><!-- form-group Ends -->
<div class="product-variations-div"><!-- product-variations-div Starts -->
</div><!-- product-variations-div Ends -->
<hr class="variation-hr">
<div class="form-group"><!-- form-group Starts -->
<input type="submit" value="Save Product Variations" class="btn btn btn-success">
</div><!-- form-group Ends -->
</form><!-- form Ends -->
<div class="ajax-response-div"></div>
</div><!-- product_variations tab-pane fade in Ends -->
</div><!-- tab-content Ends -->
</div><!--panel-body Ends -->
</div><!-- panel panel-default Ends -->
</div><!-- form-group Ends -->
<div class="form-group"><!-- form-group Starts -->
<input type="submit" name="submit" value="Insert Product" form="insert_product_form" class="btn btn-primary form-control">
</div><!-- form-group Ends -->
</div><!-- panel-body Ends -->
</div><!-- panel panel-default Ends -->
</div><!-- col-lg-12 Ends -->
</div><!-- 2 row Ends -->
<script>
$(document).ready(function(){
//Product Stock Management Code Starts
$("#stock-management-row").hide();
$("input[name='enable_stock']").click(function(){
var radio_value = $(this).val();
if(radio_value == "yes"){
$("#stock-status").hide();
$("#stock-management-row").show();
}else if(radio_value == "no"){
$("#stock-status").show();
$("#stock-management-row").hide();
}
});
//Product Stock Management Code Ends
//Change Product Type Function Code Starts
function change_product_type(){
var product_type = $("select[name='product_type']").val();
if(product_type == "physical_product"){
$("#product_weight").show();
$("#product_price").show();
$("#product_psp_price").show();
$('#product_weight input,#product_price input,#product_psp_price input').prop("disabled", false);
$("#product-stock-management").show();
$('#product-stock-management input,#product-stock-management select').prop("disabled", false);
$("#variable_product_options").hide();
}else if(product_type == "digital_product"){
$("#product_weight").hide();
$("#product_price").show();
$("#product_psp_price").show();
$('#product_weight input,#product_price input,#product_psp_price input').prop("disabled", false);
$("#product-stock-management").show();
$('#product-stock-management input,#product-stock-management select').prop("disabled", false);
$("#variable_product_options").hide();
}else if(product_type == "variable_product"){
$("#product_weight").hide();
$("#product_price").hide();
$("#product_psp_price").hide();
$('#product_weight input,#product_price input,#product_psp_price input').prop("disabled", true);
$("#product-stock-management").hide();
$('#product-stock-management input,#product-stock-management select').prop("disabled", true);
$("#variable_product_options").show();
}
}
//Change Product Type Function Code Ends
change_product_type();
$("select[name='product_type']").change(function(){
change_product_type();
});
//Load Product Attributes Function Code Starts
function load_product_attributes(){
$.ajax({
method: "POST",
url: "variable_product/load_product_attributes.php",
data: { random_id: <?php echo $random_id; ?> },
success:function(data){
$("table tbody").html(data);
$("table").removeClass("wait-loader");
}
});
}
//Load Product Attributes Function Code Ends
//Insert New Product Attribute Code Starts
$("#insert_attribute_form").submit(function(event){
event.preventDefault();
$("table").addClass("wait-loader");
$.ajax({
method: "POST",
url: "variable_product/insert_product_attribute.php",
data: $('#insert_attribute_form').serialize() + "&random_id=<?php echo $random_id; ?>",
success: function(){
$("#insert_attribute_form").find("input[type=text],textarea").val("");
load_product_attributes();
}
});
});
//Insert New Product Attribute Code Ends
//Edit Product Attribute Code Starts
$(".input-edit").hide();
$(".save-product-attribute").hide();
$(".edit-product-attribute").on('click', function(event){
event.preventDefault();
var attribute_id = $(this).data("attribute");
$(".edit").show();
$(".input-edit").hide();
$(".edit[data-attribute='" + attribute_id +"']").hide();
$(".input-edit[data-attribute='" + attribute_id +"']").show().focus();
$(".edit-product-attribute[data-attribute='" + attribute_id +"']").hide();
$(".save-product-attribute[data-attribute='" + attribute_id +"']").show();
});
//Edit Product Attribute Code Ends
//Update Save Product Attribute Code Starts
$(".save-product-attribute").on('click', function(event){
event.preventDefault();
var attribute_id = $(this).data("attribute");
$(".edit[data-attribute='" + attribute_id +"']").show();
$(".input-edit[data-attribute='" + attribute_id +"']").hide();
$(".edit-product-attribute[data-attribute='" + attribute_id +"']").show();
$(".save-product-attribute[data-attribute='" + attribute_id +"']").hide();
var attribute_name = $("#attribute-name[data-attribute='" + attribute_id +"']").val();
var attribute_values = $("#attribute-values[data-attribute='" + attribute_id +"']").val();
$("#attribute-name[data-attribute='" + attribute_id +"']").prev(".edit").text(attribute_name);
$("#attribute-values[data-attribute='" + attribute_id +"']").prev(".edit").text(attribute_values);
var random_id = <?php echo $random_id; ?>;
$.ajax({
method: "POST",
url: "variable_product/update_product_attribute.php",
data: { random_id: random_id, attribute_id: attribute_id, attribute_name: attribute_name, attribute_values: attribute_values }
});
});
//Update Save Product Attribute Code Ends
//Delete Product Attribute Code Starts
$(".delete-product-attribute").on('click', function(event){
event.preventDefault();
var attribute_id = $(this).data("attribute");
$("#tr-attribute-" + attribute_id).remove();
var random_id = <?php echo $random_id; ?>;
$.ajax({
method: "POST",
url: "variable_product/delete_product_attribute.php",
data: { random_id: random_id, attribute_id: attribute_id }
});
});
//Delete Product Attribute Code Ends
//Load Product Variations Default Form Values Function Code Starts
function load_variations_default_form_values(){
$.ajax({
method: "POST",
url: "variable_product/load_default_form_values.php",
data: { random_id: <?php echo $random_id; ?> },
success:function(data){
$("#default_form_values").html(data);
}
});
}
//Load Product Variations Default Form Values Function Code Ends
//Load Product Variations Function Code Starts
function load_product_variations(){
$.ajax({
method: "POST",
url: "variable_product/load_product_variations.php",
data: { random_id: <?php echo $random_id; ?> },
success:function(data){
$(".product-variations-div").html(data);
$(".product-variations-div").removeClass("wait-loader");
}
});
}
//Load Product Variations Function Code Ends
//Click Product Variations Tab Code Starts
$("a[href='#product_variations']").click(function(){
$(".product-variations-div").addClass("wait-loader");
load_variations_default_form_values();
load_product_variations();
});
//Click Product Variations Tab Code Ends
//Save Update Product Variations Function Code Starts
function save_update_product_variations(){
var form = document.getElementById("product-variations-form");
var form_data = new FormData(form);
form_data.append("random_id", <?php echo $random_id; ?>);
$.ajax({
method: "POST",
url: "variable_product/update_all_variations.php",
data:form_data,
contentType: false,
cache: false,
processData:false,
success: function(data){
$(".ajax-response-div").html(data);
$(".product-variations-div").removeClass("wait-loader");
}
});
}
//Save Update Product Variations Function Code Ends
//Product Variations Actions Go Button Code Starts
$("#go_button").click(function(){
var action_select = $("#action_select").val();
if(action_select == "add_variation"){
$(".product-variations-div").addClass("wait-loader");
save_update_product_variations();
$(".product-variations-div").addClass("wait-loader");
$.ajax({
method: "POST",
url: "variable_product/insert_product_variation.php",
data: { random_id: <?php echo $random_id; ?> },
success: function(){
load_product_variations();
}
});
}else if(action_select == "create_variations_from_attributes"){
var confirm_action = confirm("Are you sure you want to link all variations? This will create a new variation for each and every possible combination of variation attributes (max 50 per run).");
if(confirm_action == true){
$(".product-variations-div").addClass("wait-loader");
save_update_product_variations();
$(".product-variations-div").addClass("wait-loader");
$.ajax({
method: "POST",
url: "variable_product/create_variations_from_attributes.php",
data: { random_id: <?php echo $random_id; ?> },
success: function(data){
$(".ajax-response-div").html(data);
load_product_variations();
load_variations_default_form_values();
}
});
}
}else if(action_select == "delete_all_variations"){
var confirm_action = confirm("Are you sure you want to delete all variations? This cannot be undone.");
if(confirm_action == true){
$(".product-variations-div").addClass("wait-loader");
$.ajax({
method: "POST",
url: "variable_product/delete_all_variations.php",
data: { random_id: <?php echo $random_id; ?> },
success: function(){
load_product_variations();
load_variations_default_form_values();
}
});
}
}
});
//Product Variations Actions Go Button Code Ends
//Save Update Submit From Of Product Variations Code Starts
$("#product-variations-form").submit(function(event){
event.preventDefault();
$(".product-variations-div").addClass("wait-loader");
save_update_product_variations();
load_variations_default_form_values();
});
//Save Update Submit From Of Product Variations Code Ends
});
</script>
<?php
if(isset($_POST['submit'])){
$product_title = mysqli_real_escape_string($con, $_POST['product_title']);
$product_seo_desc = mysqli_real_escape_string($con, $_POST['product_seo_desc']);
$product_url = mysqli_real_escape_string($con, $_POST['product_url']);
$product_cat = mysqli_real_escape_string($con, $_POST['product_cat']);
$cat = mysqli_real_escape_string($con, $_POST['cat']);
$manufacturer_id = mysqli_real_escape_string($con, $_POST['manufacturer']);
$product_price = mysqli_real_escape_string($con, $_POST['product_price']);
$product_desc = mysqli_real_escape_string($con, $_POST['product_desc']);
$product_keywords = mysqli_real_escape_string($con, $_POST['product_keywords']);
$psp_price = mysqli_real_escape_string($con, $_POST['psp_price']);
$product_label = mysqli_real_escape_string($con, $_POST['product_label']);
$product_type = mysqli_real_escape_string($con, $_POST['product_type']);
$product_features = mysqli_real_escape_string($con, $_POST['product_features']);
$product_video = mysqli_real_escape_string($con, $_POST['product_video']);
$product_weight = mysqli_real_escape_string($con, $_POST['product_weight']);
$stock_status = mysqli_real_escape_string($con, $_POST['stock_status']);
$enable_stock = mysqli_real_escape_string($con, $_POST['enable_stock']);
$stock_quantity = mysqli_real_escape_string($con, $_POST['stock_quantity']);
$allow_backorders = mysqli_real_escape_string($con, $_POST['allow_backorders']);
$status = "product";
$product_img1 = $_FILES['product_img1']['name'];
$product_img2 = $_FILES['product_img2']['name'];
$product_img3 = $_FILES['product_img3']['name'];
$temp_name1 = $_FILES['product_img1']['tmp_name'];
$temp_name2 = $_FILES['product_img2']['tmp_name'];
$temp_name3 = $_FILES['product_img3']['tmp_name'];
$allowed = array('jpeg','jpg','gif','png');
$product_img1_extension = pathinfo($product_img1, PATHINFO_EXTENSION);
$product_img2_extension = pathinfo($product_img2, PATHINFO_EXTENSION);
$product_img3_extension = pathinfo($product_img3, PATHINFO_EXTENSION);
if(!in_array($product_img1_extension,$allowed)){
echo "<script> alert('Your Product Image 1 File Extension Is Not Supported.'); </script>";
$product_img1 = "";
}else{
move_uploaded_file($temp_name1,"../admin_area/product_images/$product_img1");
}
if(!empty($product_img2)){
if(!in_array($product_img2_extension,$allowed)){
echo "<script> alert('Your Product Image 2 File Extension Is Not Supported.'); </script>";
$product_img2 = "";
}else{
move_uploaded_file($temp_name2,"../admin_area/product_images/$product_img2");
}
}
if(!empty($product_img3)){
if(!in_array($product_img3_extension,$allowed)){
echo "<script> alert('Your Product Image 3 File Extension Is Not Supported.'); </script>";
$product_img3 = "";
}else{
move_uploaded_file($temp_name3,"../admin_area/product_images/$product_img3");
}
}
$insert_product = "insert into products (vendor_id,p_cat_id,cat_id,manufacturer_id,date,product_title,product_seo_desc,product_url,product_img1,product_img2,product_img3,product_price,product_psp_price,product_desc,product_features,product_video,product_keywords,product_label,product_type,product_weight,product_vendor_status,status) values ('$customer_id','$product_cat','$cat','$manufacturer_id',NOW(),'$product_title','$product_seo_desc','$product_url','$product_img1','$product_img2','$product_img3','$product_price','$psp_price','$product_desc','$product_features','$product_video','$product_keywords','$product_label','$product_type','$product_weight','$product_vendor_status','$status')";
$run_product = mysqli_query($con,$insert_product);
$product_id = mysqli_insert_id($con);
if($run_product){
if($product_type != "variable_product"){
if($enable_stock == "yes" and $stock_quantity > 0){
$stock_status = "instock";
}elseif($enable_stock == "yes" and $allow_backorders == "no" and $stock_quantity < 1){
$stock_status = "outofstock";
}elseif($enable_stock == "yes" and ($allow_backorders == "yes" or $allow_backorders == "notify") and $stock_quantity < 1){
$stock_status = "onbackorder";
}
$insert_product_stock = "insert into products_stock (product_id,enable_stock,stock_status,stock_quantity,allow_backorders) values ('$product_id','$enable_stock','$stock_status','$stock_quantity','$allow_backorders')";
$run_insert_product_stock = mysqli_query($con,$insert_product_stock);
}
$update_product_stock = "update products_stock set product_id='$product_id' where product_id='$random_id'";
$run_update_product_stock = mysqli_query($con,$update_product_stock);
$update_product_attributes = "update product_attributes set product_id='$product_id' where product_id='$random_id'";
$run_product_attributes = mysqli_query($con, $update_product_attributes);
$update_product_variations = "update product_variations set product_id='$product_id' where product_id='$random_id'";
$run_product_variations = mysqli_query($con, $update_product_variations);
echo "
<script>
alert(' Your Product Has Been Inserted Successfully. ');
window.open('index.php?products','_self');
</script>
";
}
}
?>
I am building an e-commerce site and I am aiming to create a front end displaying my products with an option for customers to buy them, and have a content management system as a back end for an admin to edit product information.
Currently I am storing information about my products on a mysql database. I access and display the product info using a while loop. Below is a simplified version of what I am doing without any html to style it. This code will go through the database and each iteration will go the to the next row and display the info about the next product.
$query = mysql_query("SELECT * FROM truffleProducts");
while ($row = mysql_fetch_array($query)) {
$id = $row['id'];
$name = $row{'Name'};
$price = $row{'Price'};
$desc = $row{'Description'};
echo $id;
echo $name;
echo $price;
echo $desc;
}
I have began to implement a 'buy' button so that customers are able to click on a button next to the product info and purchase it. However I have come across a problem which is where my program won't be able to tell which product you have selected as the number stored in the $id variable will just be the last product it has fetched from the database. I can't differentiate between all the product's buy buttons, so it will impossible to place an order for a customer with the current system I have.
Can any one tell me how to get the id number of the specific product that a user has selected?
I only started learning PHP a month or two ago so assume I know nothing
Hi all, I want some help regarding my banking project. I have a customer registration form in my project.After successfully completion of the form users have to click on the "Open Account" button.Thereafter a customer id(Auto increment value) should be generated.It was stored in the database where other form details are also being stored. How can i call to this one by one customer id's?? Heshan, Hey guys, I m not yet an experienced coder. SO faced alot of problems. Here, I'm trying to generate a UNIQUE RANDOM NUMBER set between two numbers. Repetative occurance must be avoided by all means as I want every number so generated bears a unique value. In other words, every values that made entry into the field of my database should be differant from each others. <?php $conN=mysql_connect("localhost","root",""); if(!$conN) { die('error'.mysql_error()); } mysql_select_db("freebie_allusers",$conN); $UIN=mt_rand(1,5); $locateUIN="SELECT UIN FROM user_info WHERE UIN='".$UIN."'"; $fetchUIN=mysql_query($locateUIN); $resultUIN=mysql_num_rows($fetchUIN); if($resultUIN>0) { WHAT CODE IS REQUIRED HERE SO AS TO GENERATE UNIQUE RANDOM NUMBER? } else echo $UIN; ?> Thanx in advance I need a way to generate a random number and insert into a database, and I need the database to not contain any duplicates of that number. I basically need to generate a RMA # (Return Merchandise Authorization Number), so the numbers absolutely CAN NOT be duplicate. I have no ideas how to go about this. Should I generate a random number, search the database and see if there's a duplicate, and if there is re-run the script? Hi there i have a big issues which is starting to cause me lots of stress. I have two tables one which is products and contains the following below and the other which is additionalCategories which the contains is also below. products id name image1 image2 image3 image4 image5 description department category subcategory Price additonalCategories id departmentID categoryID subcategoryID productID i have made a products upload script to my site where i can add products too it saves the category and subcategory id's in the fields above then if i wish to add the product to additional categories i do so and again this adds all the data to the addiotnalCategories table. however i can seems to be able to display this on the view products page i tried the below code but get no luck Code: [Select] <?php session_start(); $username=$_SESSION['username']; include_once"../includes/db_connect.php"; $cat=$_GET['cat']; ?> <!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>Untitled Document</title> </head> <body> <?php $query("SELECT products.name AS name, products.price AS price, addtionalCategories.productID AS productID FROM products, addtionalCategories WHERE category='$cat' AND products.id = addtionalCategories.productID"); while($fetch=mysql_fetch_object($query)){ echo"$fetch->name"; } ?> </body> </html> i need a way in which on the page it check the category id then finds all the products that are saved in the additionalCategories table then to find the data saved in the products table such as the name and price etc please any help will be appreciated thank you for reading Hi I have been given a task to create some SQL reports. One of the reports is to display all the customers who have purchased a certain product based on user selection and then have those results able to be extracted to a mailing list. So ive got the report done. Some drop down boxes allow a user to select a product and once submitted the results are then displayed. But i dont even know where to begin with extracting those results to a mailing list. Could someone help me please? What method should I use? and where do i begin? BTW im a rookie with PHP/Mysql ive just got my first job since leaving university and this is a task ive been given at work so any quick and helpful replies are greatly appreciated Thanks in advance. Hi all, i want my list/menu field values to come from my database. how can i accomplish that? thanks i did Code: [Select] <select name="select"> <option value="0">--select below--</option> <option value="1">Me</option> <?php require_once '../konnect/konex.php'; $result = mysql_query("SELECT * FROM is_clients"); while($row = mysql_fetch_array($result)) { echo "<option value ='2'>".$row"['name']</option>"; echo "<br />"; } ?> </select> Hello, I've created a page search to return results from my database inventory. On top of these results I would like to display a seperate list of five products not included in the search results but share the same sub_category_b (a column in my SQL table). Posted below is my primary query of the database. If anyone can help me out with this it would be appreciated. Code: [Select] $colname_product = "-1"; if (isset($_GET['title'])) { $colname_product = $_GET['title']; } mysql_select_db($database_inventory, $inventory); $query_product = sprintf("SELECT * FROM inventory WHERE item_name LIKE %s OR item_desc LIKE %s ", GetSQLValueString("%" . $colname_product . "%", "text"),GetSQLValueString("%" . $colname_product . "%", "text")); $product = mysql_query($query_product, $inventory) or die(mysql_error()); $row_product = mysql_fetch_assoc($product); I've fooled around with this one for some time and haven't come up with a clear cut answer. Thank you in advance! Hi pals, I got a complex Array from the Query. it's Structure is like Quote Array ( => Array ( [server_name] => anes.admod.net [id] => 1 [server_id] => 1 [description] => nice Anes Server [status] => 0 [max_down_count] => 9 [check_interval] => 15 [fail_recheck] => 6 [log_retain] => 1 [warning] => 12 [critical] => 15 [timeout] => 8 [audible] => Y [email] => Y [im] => Y [sms] => Y [rss] => N [rssid] => [vcare] => Y [created] => 2010-12-06 10:26:26 [last_update] => 2010-12-13 16:41:48 [name] => POP3 [port] => 110 [okay] => OK [warn] => WARNING [crit] => CRITICAL [down] => Connection refused [advanced] => N [typestatus] => 1 ) [1] => Array ( [server_name] => neseema.admod.net [id] => 2 [server_id] => 2 [description] => another server [status] => 1 [max_down_count] => 11 [check_interval] => 15 [fail_recheck] => 12 [log_retain] => 2 [warning] => 12 [critical] => 16 [timeout] => 6 [audible] => Y [email] => Y [im] => Y [sms] => N [rss] => N [rssid] => [vcare] => N [created] => 2010-12-07 10:27:42 [last_update] => 2010-12-13 16:41:48 [name] => Cpanel [port] => 2082 [okay] => OK [warn] => WARNING [crit] => CRITICAL [down] => Connection refused [advanced] => N [typestatus] => 1 ) [2] => Array ( [server_name] => anes.admod.net [id] => 3 [server_id] => 1 [description] => nice Anes Server another Service [status] => 1 [max_down_count] => 14 [check_interval] => 15 [fail_recheck] => 3 [log_retain] => 3 [warning] => 12 [critical] => 16 [timeout] => 18 [audible] => Y [email] => [im] => [sms] => [rss] => N [rssid] => [vcare] => N [created] => 2010-12-07 12:58:01 [last_update] => 2010-12-13 16:41:48 [name] => SMTP [port] => 25 [okay] => OK [warn] => WARNING [crit] => CRITICAL [down] => Connection refused [advanced] => N [typestatus] => 1 ) ) In this Result I have 2 Rows in result to show, I mean I need to merge the data of First (0th) and Third(2nd) element because it display the data of same item. So How it can done, I am working in that whole day but not get a solution fully.... I saw a near solution like : <?php $input = array( 0 => array ( 'id' => 160, 'payment_period' => 'Monthly', 'plan_payment_type_id' => 171, 'payment_type_id' => 4), 1 => Array ( 'id' => 160, 'payment_period' => 'Monthly', 'plan_payment_type_id' => 172, 'payment_type_id' => 5), 2 => Array ( 'id' => 161, 'payment_period' => 'Weekly', 'plan_payment_type_id' => 173, 'payment_type_id' => 9), ); echo "<pre>"; print_r($input); echo "</pre>"; echo "****************************************************************************"; $output = array(); $id_array = array(); $i = 0; foreach($input as $key=>$val) { if(array_key_exists($val['id'],$id_array)) { $pos = $id_array[$val['id']]; $output[$pos]['payment_types'][] = array('plan_payment_type_id'=> $val['plan_payment_type_id'],'payment_type_id' => $val['payment_type_id']); } else { $output[$i] = array('id' => $val['id'],'payment_period' => $val['payment_period'],'payment_types' => array(array('plan_payment_type_id'=> $val['plan_payment_type_id'],'payment_type_id' => $val['payment_type_id']))); $id_array[$val['id']] = $i; $i++; } } echo "<pre>"; print_r($output); echo "</pre>"; ?> But I cannot handle it nicely, please give any sample or helping code idea for same , waiting your immediate Reply Thankfully Anes P.A I coded the following but some parts are not working (the "curveball" mentioned at the end). How would YOU do this? I have a page (A) displaying a form with a textarea field using a WYSIWYG interface. The user will enter a list of unordered items and upon submit the string will look something like this: This is my list of food items: <ul> <li> Lettuce </li> <li> Tomatoes </li> <li> Eggs </li> <ul> Upon submit, I need to give each list item an unique id and store this id along with the text next to it in a separate table: List_item_id List_item_text List_item_state food_1 Lettuce food_2 Tomatoes food_3 Eggs The user will then land in another page with a form displaying the list. The text is now in the page itself and not in a textarea. Instead of the bullets a dropdown list appears, and the user can select "buy" or "sell" for each list item. This page (B) looks something like this: <form> This is my list of food items: <br><select name="food_1"> <option value="buy">Buy</option> <option value="sell">Sell</option> </select> Lettuce <br><select name="food_2"> <option value="buy">Buy</option> <option value="sell">Sell</option> </select> Tomatoes <br><select name="food_2"> <option value="buy">Buy</option> <option value="sell">Sell</option> </select> Eggs <input type=submit value="submit"> </form> When the user hits "submit" the table with the list items will be updated with the values selected in the dropdown list: List_item_id List_item_text List_item_state food_1 Lettuce Buy food_2 Tomatoes Buy food_3 Eggs Sell The next time the user goes to Page B the list will remember the states. Here's the curveball: At any point the user may click on "EDIT LIST" on Page B so they may add more items (at the begining, middle or end of the string). On edit mode the list items should appear as bullets again inside the WYSIWYG interface. Keep in mind that some of the text in the string may not be a list item (ie, "this is my list of food...") yes how?
if you don't understand what do i mean, look on the textarea input, when i type some data in list format they are going to be saved in single column but i cant retrieve them as list but a single paragraph. why? I am new to PHP and currently trying to develop a website... i am stuck at one place. Lets say i'm a user(mrX) that has 4 types of car that are Ferrari, Lamborghini, Evo and BMW. So, i will register to the system about my details and all of my car info such as their cc, transmission, plat number, engine capacity. Then, i will log on into the system and after log on, there will be a drop down list. If i pick Ferrari for example, under the drop down list there will be all the information about the car. The same on the other car also. hey guys, I am having a small problem and I can't wrap my head around it. I want users to be able to upload up 10 photos in the database and what I want to do is check the database to see how many pics they have already and if they have 10, just show the photo with action items but if they have 7 for example, show the 7 pictures and three upload fields, if they have 4, show the pics and 6 fields and so on... let me know what you guys think and some help. Thanks in advance guys, you always come through... I am very new new php (wrote my first PHP script 5 Days ago) and am trying to give myself a crash course but I have hit a pit-stop which is killing me a little! I hope that title makes sense.... Basically I created PHP script to take data from a database and display in, I then wrote some code to use a drop down menu to order that data. That all worked ok until I tried to utilise some pagination. I can make the pagination work, and I can make the ordering work, but not at the same time! At the moment the code that I have will allow me to order the list and almost paginate it. There are 40 results and I want to display 10 at a time. When not using the ordering code I can paginate it perfectly but when I try to intergrate the two bits of code it will only display the first 10 results and not give me an option to go to the next page to see the rest! The code: if (!isset($_GET['start'])) { $_GET['start'] = 0; } $per_page = 10; $start = $_GET['start']; if (!$start) $start = 0; $sort = @$_POST['order']; if (!empty($sort)) { $get = mysql_query("SELECT bookname, bookauthor, bookpub, bookisbn FROM booktable ORDER BY ".mysql_real_escape_string($_POST['order'])." ASC LIMIT $start, $per_page"); } else { $get = mysql_query("SELECT bookname, bookauthor, bookpub, bookisbn FROM booktable ORDER BY bookname ASC LIMIT $start, $per_page"); } $record_count = mysql_num_rows($get); ?> <?php if (isset($_GET['showerror'])) $errorcode = $_GET['showerror']; else $errorcode = 0; ?> wont include all the html rubbish and the ordering menu! <div id="mid"> <?php echo "<table>"; echo "<tr>"; echo "<th>"; echo "</th>"; echo "<th>"; echo "Book Title"; echo "</th>"; echo "<th>"; echo "Book Author"; echo "</th>"; echo "<th>"; echo "Book Publisher"; echo "</th>"; echo "<th>"; echo "Book ISBN"; echo "</th>"; echo "<th>"; echo "</th>"; echo "</tr>"; while ($row = mysql_fetch_assoc($get)) { // get data $bookname = $row['bookname']; $bookauthor = $row['bookauthor']; $bookpub = $row['bookpub']; $bookisbn = $row['bookisbn']; echo "<tr>"; echo "<td>"; echo "<a href='addtolist.php?bookname=".$bookname."&bookauthor=".$bookauthor."&bookpub=".$bookpub."&bookisbn=".$bookisbn."'>Add to basket</a>"; echo "</td>"; echo "<td>"; echo $bookname; echo "</td>"; echo "<td>"; echo $bookauthor; echo "</td>"; echo "<td>"; echo $bookpub; echo "</td>"; echo "<td>"; echo $bookisbn; echo "</td>"; echo "</tr>"; } echo "</table>"; $prev = $start - $per_page; $next = $start + $per_page; if (!($start<=0)) echo "<a href='products.php?start=$prev'>Prev</a> "; //set variable for first page number $i=1; //show page numbers for ($x = 0; $x < $record_count; $x = $x + $per_page) { if ($start != $x) echo "<a class='pagin' href='products.php?start=$x'> $i </a>"; else echo "<a class='pagin' href='products.php?start=$x'><b> $i </b></a>"; $i++; } //show next button if (!($start >= $record_count - $per_page)) echo "<a class='pagin' href='products.php?start=$next'> Next </a>"; ?> Thank you so much for reading! could anyone please help me with the code which is i have already displayed data as a multi select list but now i need to select one or more from them and insert into another database table. would be appreciate your help. thanx Hi i have a drop down menu for date which is meant to insert all 3 values into a date column bt is only sending the year how can i fix it <select name="date_of_birth"> <option value="1">January <option value="2">February <option value="3">March <option value="4">April <option value="5">May <option value="6">June <option value="7">July <option value="8">August <option value="9">September <option value="10">October <option value="11">November <option value="12">December </select> <select name="date_of_birth"> <option value="1">1 <option value="2">2 <option value="3">3 <option value="4">4 <option value="5">5 <option value="6">6 <option value="7">7 <option value="8">8 <option value="9">9 <option value="10">10 <option value="11">11 <option value="12">12 <option value="13">13 <option value="14">14 <option value="15">15 <option value="16">16 <option value="17">17 <option value="18">18 <option value="19">19 <option value="20">20 <option value="21">21 <option value="22">22 <option value="23">23 <option value="24">24 <option value="25">25 <option value="26">26 <option value="27">27 <option value="28">28 <option value="29">29 <option value="30">30 <option value="31">31 </select> <select name="date_of_birth" id="year"> <?php $year = date("Y"); for($i=$year;$i>$year-50;$i--) { if($year == $i) echo "<option value='$i' selected>Current Year</option>"; else echo "<option value='$i'>$i</option>"; } ?> |
|||||||