This topic is locked

update registration

6/8/2018 7:09:53 PM
PHPRunner General questions
ruzgarajans author

hi,

how to update the username in dynamic permissions page if the user name in kullanicilar table changes?
master table

kullanicilar ===>

UserName(PK,NN,UQ), kullanici_kodu(id)(PK,NN)
dynamic permission

esubeugmembers==>

UserName(Pk,NN,UQ), kullanici_kodu(id)(PK,NN)
my code:

kullanicilar table /edit/ UserName
event/ before record update



global $dal;

$tblesubeugmembers = $dal->Table("esubeugmembers");

$tblesubeugmembers->Value["UserName"] = $values["UserName"];

$tblesubeugmembers->Param["kullanici_kodu"] = $values["kullanici_kodu"];

$tblesubeugmembers->Update();
unset($values["UserName"]);
return true;


thank you.
https://xlinesoft.com/phprunner/docs/update_multiple_tables.htm

https://xlinesoft.com/phprunner/docs/update.htm

ruzgarajans author 6/9/2018

I think it's quite complicated,
I found a working code,
edit page/before record;

global $conn;

$sql = "update esubeugmembers set esubeugmembers.UserName='".$values["UserName"]."' where esubeugmembers.kullanici_kodu=".$keys["kullanici_kodu"];

db_exec($sql,$conn);

unset($values["UserName"]);

return true;


I have changed the session,

things are broken <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=85188&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />
the idea of ​​profile editing