codeigniter transact add data into two table

Question

hi i have a problem about adding data into two tables, heres the situation, i want to add a student with his username and password in users table and his personal info like name and age into users_profiles,, heres my code:

function add_user($username,$password,$fname,$lname,$sex,$address,$city,$country,$role) { $this->db->trans_start();

    $user = array(
    'usrName'=>$username,
    'usrPassword'=>sha1($password),
    'roleID'=>$role
    );

    $this->db->insert('users', $user);

    $this->db->query('SELECT usrID FROM users WHERE usrName=$username');

    $usrID = $this->db->get(); //i know this is wrong thats why i need help

    $user_profile = array(
    'usrpFirstName'=>$fname,
    'usrpLastName'=>$lname,
    'usrpSex'=>$sex,
    'usrpAddress'=>$address,
    'usrpCity'=>$city,
    'usrpState'=>$country,
    'usrID'=>**$usrID** // this is the foreign key from users table
    );

    $this->db->insert('users_profiles', $user_profile);

    $this->db->trans_complete();
}

jisaacstone · Accepted Answer · 2011-05-17 05:12:15Z

2

You do not need to use get() when you use the query() method. Instead store the result from the query() method and use result() or row() to access the data.

So your code should be something like:

$result = $this->db->query("SELECT usrID FROM users WHERE usrName=$username");

$row = $result->row();

$user_profile = array(
  'usrpFirstName'=>$fname,
  'usrpLastName'=>$lname,
  'usrpSex'=>$sex,
  'usrpAddress'=>$address,
  'usrpCity'=>$city,
  'usrpState'=>$country,
  'usrID'=>$row->usrID
);

edited May 17, 2011 at 5:12

answered May 17, 2011 at 4:26

jisaacstone

4,3043 gold badges27 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

kester martinez Over a year ago

it returns an error. can you please help.... A Database Error Occurred Error Number: 1054 Unknown column '$username' in 'where clause' SELECT usrID FROM users WHERE usrName=$username

kester martinez Over a year ago

also with the code above it also returns error Fatal error: Call to undefined method CI_DB_mysql_driver::row() in C:\wamp\www\pgoadmin\application\models\user_model.php on line 54

kester martinez Over a year ago

the $row = $this->db->row(); returns an error Fatal error: Call to undefined method CI_DB_mysql_driver::row()

kester martinez Over a year ago

the code is working but after inserting data from users table ,, the next query cant read the username=$username even it is already inserted in users table

kester martinez Over a year ago

Unknown column 'sample' in 'where clause' SELECT usrID FROM users WHERE usrName=sample,,, but in phpmyadmin usrName sample is already inserted

|

Collectives™ on Stack Overflow

codeigniter transact add data into two table

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related