Code: Select all
CREATE TABLE `logistics`.`contact_rate` ( `CAT` varchar( 100 ) NOT NULL ,
`JEEP` double default '0',
`GYPSY` double default '0',
`BUS` double default '0',
`MC` double default '0',
`1 TON` double default '0',
`TR 2.5` double default '0',
`CAR STAFF` double default '0',
`LY 3 TON` double default '0',
`TATA 4.5 TON` double default '0',
`ALS/ MOD ALS` double default '0',
`FOL BROWER` double default '0',
`SCANIA GTV` double default '0',
`LOADER SCANIA` double default '0',
`AMN SCANIA` double default '0',
`URAL` double default '0',
`LRV 3 TON` double default '0',
`LRV ALS` double default '0',
`HRV` double default '0',
`KRAZ` double default '0',
`LY 10 TON 6x6` double default '0',
`KOLOSTATRA 6X6` double default '0',
`TATRA 8X8` double default '0',
`JCB` double default '0',
`WH DOZER` double default '0',
`TRACTOR` double default '0',
`TATRA 10X10` double default '0',
`TATRA 10X 10 LV` double default '0',
`TATRA 10X 10 TLV` double default '0',
`TATRA 4X 4 MET SPL VEH` double default '0',
`TATRA 6X 6 CSV` double default '0',
`TATRA 6X 6 WKSP` double default '0',
`TATRA 8X 8 AMN` double default '0',
`BMP` double default '0',
`ALS THIRD LINE` double default '0',
`WATER BROWSER 3 TON` double default '0',
`WATER BROWSER 2.5 TON` double default '0',
PRIMARY KEY ( `CAT` ) ) ENGINE = MyISAM DEFAULT CHARSET = latin1;But the values are not getting updated where ever fields name contain 'space', '.', and '/'
the program is as below:-
Code: Select all
<?php require_once('../Connections/Logistics.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE contact_rate SET JEEP=%s, GYPSY=%s, BUS=%s, MC=%s, `1 TON`=%s, `TR 2.5`=%s, `CAR STAFF`=%s, `LY 3 TON`=%s, `TATA 4.5 TON`=%s, `ALS/ MOD ALS`=%s, `FOL BROWER`=%s, `SCANIA GTV`=%s, `LOADER SCANIA`=%s, `AMN SCANIA`=%s, URAL=%s, `LRV 3 TON`=%s, `LRV ALS`=%s, HRV=%s, KRAZ=%s, `LY 10 TON 6x6`=%s, `KOLOSTATRA 6X6`=%s, `TATRA 8X8`=%s, JCB=%s, `WH DOZER`=%s, TRACTOR=%s, `TATRA 10X10`=%s, `TATRA 10X 10 LV`=%s, `TATRA 10X 10 TLV`=%s, `TATRA 4X 4 MET SPL VEH`=%s, `TATRA 6X 6 CSV`=%s, `TATRA 6X 6 WKSP`=%s, `TATRA 8X 8 AMN`=%s, BMP=%s, `ALS THIRD LINE`=%s, `WATER BROWSER 3 TON`=%s, `WATER BROWSER 2.5 TON`=%s WHERE CAT=%s",
GetSQLValueString($_POST['JEEP'], "double"),
GetSQLValueString($_POST['GYPSY'], "double"),
GetSQLValueString($_POST['BUS'], "double"),
GetSQLValueString($_POST['MC'], "double"),
GetSQLValueString($_POST['1 TON'], "double"),
GetSQLValueString($_POST['TR 25'], "double"),
GetSQLValueString($_POST['CAR STAFF'], "double"),
GetSQLValueString($_POST['LY 3 TON'], "double"),
GetSQLValueString($_POST['TATA 45 TON'], "double"),
GetSQLValueString($_POST['ALS MOD ALS'], "double"),
GetSQLValueString($_POST['FOL BROWER'], "double"),
GetSQLValueString($_POST['SCANIA GTV'], "double"),
GetSQLValueString($_POST['LOADER SCANIA'], "double"),
GetSQLValueString($_POST['AMN SCANIA'], "double"),
GetSQLValueString($_POST['URAL'], "double"),
GetSQLValueString($_POST['LRV 3 TON'], "double"),
GetSQLValueString($_POST['LRV ALS'], "double"),
GetSQLValueString($_POST['HRV'], "double"),
GetSQLValueString($_POST['KRAZ'], "double"),
GetSQLValueString($_POST['LY 10 TON 6x6'], "double"),
GetSQLValueString($_POST['KOLOSTATRA 6X6'], "double"),
GetSQLValueString($_POST['TATRA 8X8'], "double"),
GetSQLValueString($_POST['JCB'], "double"),
GetSQLValueString($_POST['WH DOZER'], "double"),
GetSQLValueString($_POST['TRACTOR'], "double"),
GetSQLValueString($_POST['TATRA 10X10'], "double"),
GetSQLValueString($_POST['TATRA 10X 10 LV'], "double"),
GetSQLValueString($_POST['TATRA 10X 10 TLV'], "double"),
GetSQLValueString($_POST['TATRA 4X 4 MET SPL VEH'], "double"),
GetSQLValueString($_POST['TATRA 6X 6 CSV'], "double"),
GetSQLValueString($_POST['TATRA 6X 6 WKSP'], "double"),
GetSQLValueString($_POST['TATRA 8X 8 AMN'], "double"),
GetSQLValueString($_POST['BMP'], "double"),
GetSQLValueString($_POST['ALS THIRD LINE'], "double"),
GetSQLValueString($_POST['WATER BROWSER 3 TON'], "double"),
GetSQLValueString($_POST['WATER BROWSER 25 TON'], "double"),
GetSQLValueString('contact_rate', "text"));
mysql_select_db($database_Logistics, $Logistics);
$Result1 = mysql_query($updateSQL, $Logistics) or die(mysql_error());
}
mysql_select_db($database_Logistics, $Logistics);
$query_contact = "SELECT * FROM contact_rate";
$contact = mysql_query($query_contact, $Logistics) or die(mysql_error());
$row_contact = mysql_fetch_assoc($contact);
$totalRows_contact = mysql_num_rows($contact);
?><!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>
<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
<table align="center">
<tr valign="baseline">
<td nowrap="nowrap" align="right">CAT:</td>
<td><?php echo $row_contact['CAT']; ?></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">JEEP:</td>
<td><input type="text" name="JEEP" value="<?php echo htmlentities($row_contact['JEEP'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">GYPSY:</td>
<td><input type="text" name="GYPSY" value="<?php echo htmlentities($row_contact['GYPSY'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">BUS:</td>
<td><input type="text" name="BUS" value="<?php echo htmlentities($row_contact['BUS'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">MC:</td>
<td><input type="text" name="MC" value="<?php echo htmlentities($row_contact['MC'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">1 TON:</td>
<td><input type="text" name="1 TON" value="<?php echo htmlentities($row_contact['1 TON'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">TR 2.5:</td>
<td><input type="text" name="TR 25" value="<?php echo htmlentities($row_contact['TR 2.5'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">CAR STAFF:</td>
<td><input type="text" name="CAR STAFF" value="<?php echo htmlentities($row_contact['CAR STAFF'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">LY 3 TON:</td>
<td><input type="text" name="LY 3 TON" value="<?php echo htmlentities($row_contact['LY 3 TON'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">TATA 4.5 TON:</td>
<td><input type="text" name="TATA 45 TON" value="<?php echo htmlentities($row_contact['TATA 4.5 TON'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">ALS/ MOD ALS:</td>
<td><input type="text" name="ALS MOD ALS" value="<?php echo htmlentities($row_contact['ALS/ MOD ALS'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">FOL BROWER:</td>
<td><input type="text" name="FOL BROWER" value="<?php echo htmlentities($row_contact['FOL BROWER'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">SCANIA GTV:</td>
<td><input type="text" name="SCANIA GTV" value="<?php echo htmlentities($row_contact['SCANIA GTV'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">LOADER SCANIA:</td>
<td><input type="text" name="LOADER SCANIA" value="<?php echo htmlentities($row_contact['LOADER SCANIA'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">AMN SCANIA:</td>
<td><input type="text" name="AMN SCANIA" value="<?php echo htmlentities($row_contact['AMN SCANIA'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">URAL:</td>
<td><input type="text" name="URAL" value="<?php echo htmlentities($row_contact['URAL'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">LRV 3 TON:</td>
<td><input type="text" name="LRV 3 TON" value="<?php echo htmlentities($row_contact['LRV 3 TON'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">LRV ALS:</td>
<td><input type="text" name="LRV ALS" value="<?php echo htmlentities($row_contact['LRV ALS'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">HRV:</td>
<td><input type="text" name="HRV" value="<?php echo htmlentities($row_contact['HRV'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">KRAZ:</td>
<td><input type="text" name="KRAZ" value="<?php echo htmlentities($row_contact['KRAZ'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">LY 10 TON 6x6:</td>
<td><input type="text" name="LY 10 TON 6x6" value="<?php echo htmlentities($row_contact['LY 10 TON 6x6'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">KOLOSTATRA 6X6:</td>
<td><input type="text" name="KOLOSTATRA 6X6" value="<?php echo htmlentities($row_contact['KOLOSTATRA 6X6'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">TATRA 8X8:</td>
<td><input type="text" name="TATRA 8X8" value="<?php echo htmlentities($row_contact['TATRA 8X8'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">JCB:</td>
<td><input type="text" name="JCB" value="<?php echo htmlentities($row_contact['JCB'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">WH DOZER:</td>
<td><input type="text" name="WH DOZER" value="<?php echo htmlentities($row_contact['WH DOZER'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">TRACTOR:</td>
<td><input type="text" name="TRACTOR" value="<?php echo htmlentities($row_contact['TRACTOR'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">TATRA 10X10:</td>
<td><input type="text" name="TATRA 10X10" value="<?php echo htmlentities($row_contact['TATRA 10X10'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">TATRA 10X 10 LV:</td>
<td><input type="text" name="TATRA 10X 10 LV" value="<?php echo htmlentities($row_contact['TATRA 10X 10 LV'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">TATRA 10X 10 TLV:</td>
<td><input type="text" name="TATRA 10X 10 TLV" value="<?php echo htmlentities($row_contact['TATRA 10X 10 TLV'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">TATRA 4X 4 MET SPL VEH:</td>
<td><input type="text" name="TATRA 4X 4 MET SPL VEH" value="<?php echo htmlentities($row_contact['TATRA 4X 4 MET SPL VEH'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">TATRA 6X 6 CSV:</td>
<td><input type="text" name="TATRA 6X 6 CSV" value="<?php echo htmlentities($row_contact['TATRA 6X 6 CSV'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">TATRA 6X 6 WKSP:</td>
<td><input type="text" name="TATRA 6X 6 WKSP" value="<?php echo htmlentities($row_contact['TATRA 6X 6 WKSP'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">TATRA 8X 8 AMN:</td>
<td><input type="text" name="TATRA 8X 8 AMN" value="<?php echo htmlentities($row_contact['TATRA 8X 8 AMN'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">BMP:</td>
<td><input type="text" name="BMP" value="<?php echo htmlentities($row_contact['BMP'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">ALS THIRD LINE:</td>
<td><input type="text" name="ALS THIRD LINE" value="<?php echo htmlentities($row_contact['ALS THIRD LINE'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">WATER BROWSER 3 TON:</td>
<td><input type="text" name="WATER BROWSER 3 TON" value="<?php echo htmlentities($row_contact['WATER BROWSER 3 TON'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">WATER BROWSER 2.5 TON:</td>
<td><input type="text" name="WATER BROWSER 25 TON" value="<?php echo htmlentities($row_contact['WATER BROWSER 2.5 TON'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td><input type="submit" value="Update record" /></td>
</tr>
</table>
<input type="hidden" name="MM_update" value="form1" />
<input type="hidden" name="CAT" value="<?php echo $row_contact['CAT']; ?>" />
</form>
<p> </p>
</body>
</html>
<?php
mysql_free_result($contact);
?>
Monindra Masia..