Jump to content

space in input name

craygo

By craygo
in PHP Coding Help

 Share

Recommended Posts

craygo Member

craygo

Posted
Posted
I have inherited a database adn the tables have spaces in the field names. I have a script to update the record but when the POST data is sent it is sending the field name thru with an "_" instead of a space.

Here in the page
[code]<?php
if(isset($_POST['submit'])){

  $cpc = $_POST['CPC'];

  foreach($_POST as $field => $value){
    if($field <> 'CPC'){
      if($field <> 'submit'){
        if($field <> 'keyword'){
          if($field <> 'stype'){
          if($field <> 'field'){

          $sql = "UPDATE parcels SET
            `".$field."` = ".$value." WHERE CPC = '$cpc'";

            echo "$sql<br>";
            //$res = mysql_query($sql) or die (mysql_error());
            }
          }
        }
      }
    }
  }

  echo "Data inserted into table<br>
        Click <a href=\"home.php?keyword=".$_POST['keyword']."&stype=".$_POST['stype']."&field=".$_POST['field']."&submit=submit\">HERE</a> to return to list or<br>
        Click <a href=home.php>HERE</a> to return to search page";
} else {
?>
<table width=600 align=center border=1>
  <form name=cpcform method=POST action="<?=$_SERVER['PHP_SELF']?>">
  <input type=hidden name=CPC value="<?=$_GET['cpc']?>">
  <input type=hidden name=keyword value="<?=$_GET['keyword']?>">
  <input type=hidden name=stype value="<?=$_GET['stype']?>">
  <input type=hidden name=field value="<?=$_GET['field']?>">
<?php
// start your count here for row offsets
$k=0;
// Query database for data
$sql = "SELECT * FROM parcels WHERE CPC='". $_GET['cpc']."'" ;
// run query
  $res = mysql_query($sql) or die (mysql_error());
//count how many fields in table
$num_fields = mysql_num_fields($res);
// Get data from query
$r = mysql_fetch_row($res);
// start loop
    while($k < $num_fields){
      // Fetch field names
      $meta = mysql_fetch_field($res, $k);
      // Substitute N/A if field is blank
      if(empty($r[$k])){
        $field = "N/A";
        } else {
        $field = $r[$k];
        }
        // Start output rows

        echo "<tr>\n";
        echo "<td width=150><font color=#FF0000>".$meta->name."</font></td>\n";
        if($meta->name == 'CPC'){
        echo "<td width=200><b><input type=text name=\"".$meta->name."\" value=\"$field\" size=60 disabled></b></td>\n";
        } else {
        echo "<td width=200><input type=text name=\"".$meta->name."\" value=\"$field\" size=60></td>\n";
        }
        echo "</tr>\n";

$k++;
}
echo "<tr>
      <td colspan=2 align=center><input type=submit name=submit value=Submit></td>
      </tr>
      </form>
      </table>";
}
?>[/code]

One of the field names is Old Plat. When I look at the source code for the form it says
[code]<td width=200><input type=text name="Old Lot" value="937, 938; 74, 72 & 83" size=60></td>[/code]

But when the form is submitted the $_POST is called $_POST['Old_Lot'] Not $_POST['Old Lot']

Thanks

Ray
Link to comment
Share on other sites
craygo Member

craygo

Posted
  • Author
Posted
I know I can do that. There is alot of code that references the fields already so I need a fix.

This is what i had to use but don't understand why I would need to do it.
[code]if(isset($_POST['submit'])){
  // update query here

  $cpc = $_POST['CPC'];
foreach($_POST as $fields => $value){
  $field = ereg_replace("\+", " ", $fields);
    if($field <> 'CPC'){
    if($field <> 'submit'){
        if($field <> 'keyword'){
          if($field <> 'stype'){
          if($field <> 'field'){

          $sql = "UPDATE parcels SET
            `".$field."` = '".$value."' WHERE CPC = '$cpc'";

            //echo "$sql<br>";
            $res = mysql_query($sql) or die (mysql_error());
            }
          }
        }
      }
    }
  }

  echo "Data inserted into table<br>
        Click <a href=\"home.php?keyword=".$_POST['keyword']."&stype=".$_POST['stype']."&field=".$_POST['field']."&submit=submit\">HERE</a> to return to list or<br>
        Click <a href=home.php>HERE</a> to return to search page";
} else {
?>
<table width=600 align=center border=1>
  <form name=cpcform method=POST action="<?=$_SERVER['PHP_SELF']?>">
  <input type=hidden name=CPC value="<?=$_GET['cpc']?>">
  <input type=hidden name=keyword value="<?=$_GET['keyword']?>">
  <input type=hidden name=stype value="<?=$_GET['stype']?>">
  <input type=hidden name=field value="<?=$_GET['field']?>">
<?php
// start your count here for row offsets
$k=0;
// Query database for data
$sql = "SELECT * FROM parcels WHERE CPC='". $_GET['cpc']."'" ;
// run query
  $res = mysql_query($sql) or die (mysql_error());
//count how many fields in table
$num_fields = mysql_num_fields($res);
// Get data from query
$r = mysql_fetch_row($res);
// start loop
    while($k < $num_fields){
      // Fetch field names
      $meta = mysql_fetch_field($res, $k);
      // Substitute N/A if field is blank
      if(empty($r[$k])){
        $field = "N/A";
        } else {
        $field = $r[$k];
        }
      $fieldname = ereg_replace(" ", "+", $meta->name);
        // Start output rows

        echo "<tr>\n";
        echo "<td width=150><font color=#FF0000>".$meta->name."</font></td>\n";
        if($meta->name == 'CPC'){
        echo "<td width=200><b><input type=text name=\"".$fieldname."\" value=\"$field\" size=60 disabled></b></td>\n";
        } else {
        echo "<td width=200><input type=text name=\"".$fieldname."\" value=\"$field\" size=60></td>\n";
        }
        echo "</tr>\n";

$k++;
}
echo "<tr>
      <td colspan=2 align=center><input type=submit name=submit value=Submit></td>
      </tr>
      </form>
      </table>";
}
?>[/code]

Ray
Link to comment
Share on other sites
craygo Member

craygo

Posted
  • Author
Posted
Since I am editing all the fields in the database I run a query to fetch all the field names and all the values, then I make the form name the actual name of the field. That way when the POST values come thru it should be fieldname=newvalue. But what is happening is the fieldnames that have spaces are coming thru the POST with an "_" instead of the space. So to work around it I replaced the space with a "+" in the form name, then when the form is submitted I replaced the "+" back to a space.

[code]<?php
if(isset($_POST['submit'])){
  // update query here

  $cpc = $_POST['CPC'];
foreach($_POST as $fields => $value){
// Replace the + with a space so the field name is correct
  $field = ereg_replace("\+", " ", $fields); 
    if($field <> 'CPC'){
    if($field <> 'submit'){
        if($field <> 'keyword'){
          if($field <> 'stype'){
          if($field <> 'field'){

          $sql = "UPDATE parcels SET
            `".$field."` = '".$value."' WHERE CPC = '$cpc'";

            //echo "$sql<br>";
            $res = mysql_query($sql) or die (mysql_error());
            }
          }
        }
      }
    }
  }

  echo "Data inserted into table<br>
        Click <a href=\"home.php?keyword=".$_POST['keyword']."&stype=".$_POST['stype']."&field=".$_POST['field']."&submit=submit\">HERE</a> to return to list or<br>
        Click <a href=home.php>HERE</a> to return to search page";
} else {
?>
<table width=600 align=center border=1>
  <form name=cpcform method=POST action="<?=$_SERVER['PHP_SELF']?>">
  <input type=hidden name=CPC value="<?=$_GET['cpc']?>">
  <input type=hidden name=keyword value="<?=$_GET['keyword']?>">
  <input type=hidden name=stype value="<?=$_GET['stype']?>">
  <input type=hidden name=field value="<?=$_GET['field']?>">
<?php
// start your count here for row offsets
$k=0;
// Query database for data
$sql = "SELECT * FROM parcels WHERE CPC='". $_GET['cpc']."'" ;
// run query
  $res = mysql_query($sql) or die (mysql_error());
//count how many fields in table
$num_fields = mysql_num_fields($res);
// Get data from query
$r = mysql_fetch_row($res);
// start loop
    while($k < $num_fields){
      // Fetch field names
      $meta = mysql_fetch_field($res, $k);
      // Substitute N/A if field is blank
      if(empty($r[$k])){
        $field = "N/A";
        } else {
        $field = $r[$k];
        }
// First add this in to put a plus in the form name, which is the field name, in place of the space
      $fieldname = ereg_replace(" ", "+", $meta->name);
        // Start output rows

        echo "<tr>\n";
        echo "<td width=150><font color=#FF0000>".$meta->name."</font></td>\n";
        if($meta->name == 'CPC'){
        echo "<td width=200><b><input type=text name=\"".$fieldname."\" value=\"$field\" size=60 disabled></b></td>\n";
        } else {
        echo "<td width=200><input type=text name=\"".$fieldname."\" value=\"$field\" size=60></td>\n";
        }
        echo "</tr>\n";

$k++;
}
echo "<tr>
      <td colspan=2 align=center><input type=submit name=submit value=Submit></td>
      </tr>
      </form>
      </table>";
}
?>[/code]

Ray
Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.