bueno en realidad son tres clases...
-AppDataBaseModel
-User
-UserPersonalInfo
Esta es la otra la cual agrega el usuario y después de agregado es que obtengo el último id insertado
Código PHP:
Ver original<?php
class User extends AppDataBaseModel{
private $userName;
private $userCountryId;
private $userLastName;
private $userIdnumberNationality;
private $userIdnumber;
private $userMail;
private $userLogin;
private $userPassword;
private $userRegDate;
private $userEditedDate;
private $userLastVisit;
private $userActivated;
private $userStatus;
private $userLevelAccess;
private $userTerms;
private $tableName = _TABLE_USERS_;
private $tableName2 = _TABLE_USERS_LEVEL_ACCESS_;
private $tableName3 = _TABLE_USERS_INFO_;
private $theId ='u_user_id';
private $orderBy ='u_user_id';
//DECLARAMOS EL CONSTRUCTOR DE LA CLASE EL CUAL SE LLAMA AL MOMENTO DE INSTANCIAR LA CLASE Y RECIBE LOS DATOS A TRAVES DE SUS PARAMETROS
public function __construct($userId=0,$userCountryId=0,$userName="",$userLastName="",$userIdnumberNationality="",$userIdnumber="",$userMail="",$userLogin="",$userPassword="",$userRegDate=0,$userEditedDate=0,$userLastVisit=0,$userActivated="",$userStatus="",$userLevelAccess=0,$userTerms=0){
$this->userName = $userName;
$this->userCountryId = $userCountryId;
$this->userLastName = $userLastName;
$this->userIdnumberNationality = $userIdnumberNationality;
$this->userIdnumber = $userIdnumber;
$this->userMail = $userMail;
$this->userLogin = $userLogin;
$this->userPassword = $userPassword;
$this->userRegDate = $userRegDate;
$this->userEditedDate = $userRegDate;
$this->userLastVisit = $userLastVisit;
$this->userActivated = $userActivated;
$this->userStatus = $userStatus;
$this->userLevelAccess = $userLevelAccess;
}//FIN DEL CONSTRUCTOR
public function save(){
$getResult = $this->executeQuery("INSERT INTO ".$this->tableName."(u_user_id,
u_user_country_id,
u_user_name,
u_user_lastname,
u_user_id_number_nationality,
u_user_id_number,
u_user_mail,
u_user_login,
u_user_password,
u_user_reg_date,
u_user_edited_date,
u_user_last_visit,
u_user_activated,
u_user_status,
u_user_level_access,
u_user_policy)
VALUES ('',
'".$this->userCountryId."',
'".$this->escapeSqlString($this->userName)."',
'".$this->escapeSqlString($this->userLastName)."',
'".$this->escapeSqlString($this->userIdnumberNationality)."',
'".$this->escapeSqlString($this->userIdnumber)."',
'".$this->escapeSqlString($this->userMail)."',
'".$this->escapeSqlString($this->userLogin)."',
'".$this->escapeSqlString(md5($this->userPassword))."', NOW(),
NOW(),
'',
'".$this->userActivated."',
'".$this->userStatus."',
'".$this->userLevelAccess."',
'".$this->userTerms."');");
return $getResult;
}//FIN DEL METODO SAVE
}//FIN DE LA CLASE
?>