[RESOLVED] INSERT into db

dmcglone

Hi All,

I'm new to MySQL and PHP and I have a question, I am trying to learn how to insert data into a database and I have written this code and I am trying to figure out why it will not update the data in the db. The code probably looks like crap to an experienced person, but it is the only I could think of writing it to try and make things a little more clear in my mind.

$query = "SELECT * FROM subheaderText WHERE subheaderTextID=1";
$result = @($query);

echo "<form name='subheader' action='$SERVER[PHP_SELF]' method='POST'>";
$UpdateQuery = "UPDATE workshop SET
*****subheaderText='".$POST['subheaderText']."',
*****pageID='".$POST['headerText']."',
headerText='".$POST['headerText']."',
WHERE subheaderTextID='".$_POST['subheaderTextID']."'";

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

echo "<OPTION VALUE='subheaderText'>$row[subheaderText]<br>";
echo "<input type=text name='subheaderTextID' size='30' value='$row[subheaderTextID]'>";
echo "<input type=text name='subheaderText' size='30' value='$row[subheaderText]'><br>";
echo "<textarea name='headerText' cols='50' rows='15' />$row[headerText]</textarea>";
echo "<input type=text name='pageID' size='10' value='$row[pageID]'><br>";
}

Thanks,
David M.

djjjozsi

hi,
when you asking and posting php codes, please use the

  [ /PHP] tags please
(a little php image from the html textarea)

And i think this line have no sense:
[code=php]echo "<OPTION VALUE='subheaderText'>$row[subheaderText]<br>";

If you wanted a dropdown list? A list looks like:

  <select name="select">
    <option value="1">a</option>
    <option value="2">b</option>
  </select>

dmcglone

I fixed up the script, and now have this code. I still can't get it to update the info in the database. The var dump shows the changes that were made after the form is submitted, but the database still remains the same.

<?php
echo var_dump($_POST);

$query = "UPDATE workshop subheaderText SET NULL,
*****subheaderText='".$POST['subheaderText']."'
**headerText='".$POST['headerText']."'
page='".$POST['page']."'
*****WHERE subheaderTextID='".$POST['subheaderTextID']."'";

$query2= "SELECT * FROM subheaderText WHERE subheaderTextid=1";
$result2= @($query2);
echo "<form name='subheader' action='$_SERVER[PHP_SELF]' method='POST'>";
while ($row=mysql_fetch_array($result2)){

echo "<input type=text name='subheaderTextID' size='30' value='".$row['subheaderTextID']."'>ID<br>";
echo "<input type=text name='page' size='10' value='".$row['page']."'>page<br>";
echo "<input type=text name='subheaderText' size='30' value='".$row['subheaderText']."'>subheader<br>";
echo "text <textarea name='headerText' cols='50' rows='15' />'".$row['headerText']."'</textarea><br>";

}
echo '<input type="submit" name="submit" value="update" /><br>';
echo '</form><br>';
?>

Desbrina

i dont see a

mysql_query($query);

after the update code. it needs to be there for the database to be updated (or any sql to be ran for that matter)

djjjozsi

run the $query1 as Desbrina suggested,

$result1= mysql_query($query);

In the second part of this code you make brunches of textfields with the same field names, that is wrong.
if you want to make a batch update , lets add the textfield's variable name an array index, which is that row's ID:

 echo "<input type=text name='subheaderText[$row['header_id']]' size='30' value='".$row['subheaderText']."'>subheader<br>";

And on the processiong part of you page, you can get these arrays with foreach.

walterquez

The very last field, just before WHERE, ends with a comma. Remove it. The last field should not end with a comma.

Instead of -> headerText='".$POST['headerText']."',
Try -> headerText='".$POST['headerText']."'

$UpdateQuery = "UPDATE workshop SET
subheaderText = '{$POST['subheaderText']}',
pageID = '{$POST['headerText']}',
headerText = '{$POST['headerText']}'
WHERE subheaderTextID='{$POST['subheaderTextID']}'";