Chapter 1 Database Connection

jaguarcat · April 16th, 2012, 05:40 AM

Yes: Trying to modify the database connection constance code to a variable for use with a form filed. Like to change WROX_ prefix to whatever I choose. The constance code to change is

Code:

  ('DB_TBL_PREFIX', 'WROX_')

to some type of a variable. Need to know what change to make to the User object query lines that use the DB_TBL_PREFIX code. Examples of code are most welcome.
Jaguarcat.

Master Yoda · April 16th, 2012, 11:55 AM

If I'm understanding what you want to do, there is no need to change the user class object.
If you update the DB_TBL_PREFIX to NEW_DB_, the user class still uses the constant DB_TBL_PREFIX. All you'd have to guarantee is that all your tables in the MySQL database start with NEW_DB_ (or whatever name you choose as long as you define it as DB_TBL_PREFIX).

Hope that helps (and was what you were after).

Best Regards,
Master Yoda

jaguarcat · April 24th, 2012, 08:07 PM

Yes, thank you Master Yoda. You really helped me out with the constant prefix workaround. Can I ask this?
Do I need now to modify the user object SQL query lines to accept my table name variable something like this:

Code:

$query = sprintf ('INSERT INTO $_POST['some_name']%USER (

and add to the register.php form new User code like:

Code:

$user->$_POST['some_name'];

this to get my table name variable working? Code examples most appreciated.
Jaguarcat.

Master Yoda · April 26th, 2012, 06:57 AM

Well it all depends on how much you've changed...

In theory, if just the prefix to the tables were changed, then you won't need to change anything else, but if you've changed the names of fields, or the names to the tables, that would need to be reflected in any code that requires access to those tables.

For example:

PHP Code:


			
// Initialize a User object.

    public function __construct()

    {

        $this->uid = null;

        $this->fields = array('username' => '', 'password' => '', 'email_address' => '', 'is_active' => false, 'permission' => 0);

    }

I use slightly different naming conventions than the author of the book, so I had to change those in the user class.

Also:

PHP Code:


			
public static function getById($user_id)

    {

        $user = new User();

        $query = sprintf('SELECT username, password, email_address, is_active, permission FROM %suser WHERE user_id = %d', DB_TBL_PREFIX, $user_id);

        $result = mysql_query($query, $GLOBALS['DB']);

        if (mysql_num_rows($result))

        {

            $row = mysql_fetch_assoc($result);

            $user->username = $row['username'];

            $user->password = $row['password'];

            $user->email_address = $row['email_address'];

            $user->is_active = $row['is_active'];

            $user->permission = $row['permission'];

            $user->uid = $user_id;

        }

        mysql_free_result($result);

        return $user;

    }

The author uses uppercase letters for his field names, I don't... and these changes also need to be reflected in the user class.

Hope that helps to steer you in the right direction.

jaguarcat · May 14th, 2012, 11:34 PM

Yes: thanks Master Yoda for the example how to add a field to the User Class but I still need to add a variable to all the MYSQL query lines which brings me back to my original post question. I think I can do this if I modify the query lines But this is the block.

The query code is written with expressions

Code:

%sUSER

and

Code:

%d

I think? When I try to remove the expressions from the query lines in the USER object all actions of the User object stop. How do I remove the expressions from the query lines in the User object with modification so I can use a variable or other code within this routine?
Any examples most welcome.