update price with search + txt field

Salvo · July 22, 2005

Hi all

I have downloaded the price update search and works well if I only use it to update prices.

But I have added an other field called products_tel . it is a varchar field, but it only accept NUMERICAL..

Can somebody have a look at it and tell me where I go wrong?

<?php

/*

$Id: aumento_search.php,v 1.29 2003/04/28 15:32:22 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Author: michele gobbi

email: [email protected]

Released under the GNU General Public License

*/

require('includes/application_top.php');

require(DIR_WS_CLASSES . 'currencies.php');

$currencies = new currencies();

// category drop down

$sql3 = mysql_query("SELECT categories_id, categories_name FROM categories_description ORDER BY categories_name");

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

<!--

th { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: x-small; background-color: #eeeeee}

/*table { border: #666666; border-style: dashed; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px}*/

/*td { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: xx-small; padding-top: 3px; padding-bottom: 3px; padding-left: 5px}*/

td.left { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: xx-small; padding-top: 3px; padding-bottom: 3px; padding-left: 5px; text-align: right; padding-right: 16px}

-->

</style>

</head>

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

</table></td>

<tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

<?

if ($action == "search") {

echo "<form name=\"update\" method=\"post\" action=\"".$_SERVER["PHP_SELF"]."?action=update_prices\">";

echo "<table>";

echo "<tr><th>Product ID</th><th>Title</th><th>Price</th><th>Telephone</th></tr><tr>";

$result = mysql_query("SELECT * FROM products, products_description WHERE (products.products_model like '%$search%' OR products_description.products_name like '%$search%') AND products.products_id = products_description.products_id AND products_description.language_id = 1");

if ($row = mysql_fetch_array($result)) {

do {

$prezzo=round($row['products_price'],2);

$telefono=$row['products_tel'];

echo "<td align=\"center\">".$row["products_model"]."</td>\n";

echo "<td>".$row["products_name"]."</td>\n";

echo "<td align=\"center\"><input type=\"text\" name=\"product_new_price[".$row['products_id']."]\" value=\"$prezzo\"></td>\n";

echo "<td align=\"center\"><input type=\"text\" name=\"product_new_tel[".$row['products_id']."]\" value=\"$telefono\"></td>\n";

echo "</tr>\n";

}

while($row = mysql_fetch_array($result));

}

echo "</table>\n";

echo "<br><input type=\"submit\" value=\"Update the prices\">";

echo "</form><br><hr><br>";

}

if ($action == "update_prices") {

foreach($HTTP_POST_VARS['product_new_price'] as $id => $new_price) {

mysql_query("UPDATE products SET products_price=$new_price WHERE products_id=$id");

}

foreach($HTTP_POST_VARS['product_new_tel'] as $id => $new_tel) {

mysql_query("UPDATE products SET products_tel=$new_tel WHERE products_id=$id");

}

$random = date("U");

echo "<p><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\"><b>Prezzi or Tel aggiornati!!</b></font></p>";

}

?>

<form name="update" method="post" action="<?=$_SERVER["PHP_SELF"]?>?action=search">

<table>

<tr>

<th colspan="2">Which product do you want to search for?</td>

</tr>

<tr>

</tr>

<tr>

<td>

Product or Model Number:

</td>

<td>

</td>

</tr>

<tr>

<td>

</td>

<td>

</td>

</tr>

</table>

</form>

</td>

</tr>

</table></td>

</tr>

</table>

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Salvo · July 22, 2005

This would be to update the MODEL BUT does not work. can anybody look at this?

Thanks

<?php

/*

$Id: aumento_search.php,v 1.29 2003/04/28 15:32:22 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Author: michele gobbi

email: [email protected]

Released under the GNU General Public License

*/

require('includes/application_top.php');

require(DIR_WS_CLASSES . 'currencies.php');

$currencies = new currencies();

// category drop down

$sql3 = mysql_query("SELECT categories_id, categories_name FROM categories_description ORDER BY categories_name");

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

<!--

th { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: x-small; background-color: #eeeeee}

/*table { border: #666666; border-style: dashed; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px}*/

/*td { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: xx-small; padding-top: 3px; padding-bottom: 3px; padding-left: 5px}*/

td.left { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: xx-small; padding-top: 3px; padding-bottom: 3px; padding-left: 5px; text-align: right; padding-right: 16px}

-->

</style>

</head>

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

</table></td>

<tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

<?

if ($action == "search") {

echo "<form name=\"update\" method=\"post\" action=\"".$_SERVER["PHP_SELF"]."?action=update_prices\">";

echo "<table>";

echo "<tr><th>Product ID</th><th>Title</th><th>Price</th><th>Telephone</th></tr><tr>";

$result = mysql_query("SELECT * FROM products, products_description WHERE (products.products_model like '%$search%' OR products_description.products_name like '%$search%') AND products.products_id = products_description.products_id AND products_description.language_id = 1");

if ($row = mysql_fetch_array($result)) {

do {

$prezzo=round($row['products_price'],2);

$model=$row['products_model'];

echo "<td align=\"center\">".$row["products_model"]."</td>\n";

echo "<td>".$row["products_name"]."</td>\n";

echo "<td align=\"center\"><input type=\"text\" name=\"product_new_price[".$row['products_id']."]\" value=\"$prezzo\"></td>\n";

echo "<td align=\"center\"><input type=\"text\" size=\"30\" name=\"product_new_model[".$row['products_id']."]\" value=\"$model\"></td>\n";

echo "</tr>\n";

}

while($row = mysql_fetch_array($result));

}

echo "</table>\n";

echo "<br><input type=\"submit\" value=\"Update the prices &/or telephone\">";

echo "</form><br><hr><br>";

}

if ($action == "update_prices") {

foreach($HTTP_POST_VARS['product_new_price'] as $id => $new_price) {

mysql_query("UPDATE products SET products_price=$new_price WHERE products_id=$id");

}

foreach($HTTP_POST_VARS['product_new_model'] as $id => $new_model) {

mysql_query("UPDATE products SET products_model=$new_model WHERE products_id=$id");

}

$random = date("U");

echo "<p><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\"><b>Prezzi or Tel aggiornati!!</b></font></p>";

}

?>

<form name="update" method="post" action="<?=$_SERVER["PHP_SELF"]?>?action=search">

<table>

<tr>

<th colspan="2">Which product do you want to search for?</td>

</tr>

<tr>

</tr>

<tr>

<td>

Product or Model Number:

</td>

<td>

</td>

</tr>

<tr>

<td>

</td>

<td>

</td>

</tr>

</table>

</form>

</td>

</tr>

</table></td>

</tr>

</table>

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

update price with search + txt field

Recommended Posts

Salvo

Link to comment

Share on other sites

Salvo

Link to comment

Share on other sites

Join the conversation

Browse

Activity