Page 1 of 1

$_POST to database problem

Posted: Mon Mar 14, 2011 5:15 pm
by marimifs
Hello, I am new here and I am doing some personal project. the problem I have is that i am trying to update my database through a form but to no avail, can someone help please?

These are parts used for the update code:
//index.html The problem i think its in this part ***
$result = new dataclass();
$result->updateMember2
(
$_POST["txtHidden"],
$_POST["MemberName"],
$_POST["MemberSurname"],
$_POST['MemberUsername'],
$_POST["MemberEmail"],
$_POST["MemberPassword"]
);

//dataclass.php
function updateMember2($memberID, $name, $surname,$username, $email, $password)
{
echo("update tblmembers
set MemberName='$name', MemberSurname='$surname',MemberUsername='$username',
MemberEmail='$email', MemberPassword='$password'
where idtblMembers = $memberID");

//test2.php
function update() {
if(isset($_GET['updateid']))
{
echo '<form method="post" action="indexass.php?upMem='.($_GET['updateid']).'"><table>';
echo "<tr><td><strong></td><td></strong><input name='txtHidden'type='hidden' value='". $_GET['updateid'] ."' /></td></tr>";
while($record = mysql_fetch_assoc($this->dataset))
{
$COUNT=0;
if($record[$this->itemID] == $_GET['updateid'])
{
foreach($this->fields as $field => $value)
{


echo "<tr><td><strong>".$this->fields[$field]."</td><td></strong><input name='.$this->fields[$field].'type='text' value=' $record[$value]' /></td></tr>";
//echo "<tr><td><strong>".$this->fields[$field]."</td><td></strong><input name='.$this->fields[$field].'type='text' value='";
//echo $record[$value];
//echo' /></td></tr>"';
PRINT_R($this->fields[$field]);
ECHO'</BR>';

}
}
}


echo ' <tr><td><input type="submit" value="Submit"/></td></tr><tr><td><ul>
<a href="indexass.php?new">ADD New Record</a></td></tr></table></form>';


}

}


//PRINT_R ***
update tblmembers set MemberName='', MemberSurname='',MemberUsername='', MemberEmail='', MemberPassword='' where idtblMembers = 40

OKdataclass Object ( ) Array ( [txtHidden] => 40 [_Array] => Array ( [MemberName] => txtName [MemberSurname] => txtSurname [MemberUsername] => txtUsername [MemberEmail] => txtEmail [MemberPassword] => txtPassword ) )

Only the id is getting through to the sql as u can see from the POST_R


Can you please help me out with this problem? cheers

I am really lost...