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 ‘
<input name=‘txtHidden’type=‘hidden’ value=’”. $_GET[‘updateid’] ."’ /> | |
”.$this->fields[$field]." | <input name=’.$this->fields[$field].‘type=‘text’ value=’ $record[$value]’ /> |
”.$this->fields[$field]." | <input name=’.$this->fields[$field].‘type=‘text’ value=’"; //echo $record[$value]; //echo’ /> |
}
}
//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…