I need LOCK IN SHARE MODE for database model

I need LOCK IN SHARE MODE for database model when i use transaction. how  can i add this in the query. i saw codeigniter built in transStart if i use this transStart. do i need to use LOCK IN SHARE MODE or it will auto lock the query? i have no idea please someon help me.

One more thing i have to say the speed codeigniter is so fast.
I just love it. thankyou codeigniter team.

You would need to build your own queries to lock and unlock.
MySQL Table Locking

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

You would need to build your own queries to lock and unlock.
MySQL Table Locking

In codeigniter how can protect from SQL injection. how to clean user input?

Protecting identifiers

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

is it good practice? if i use form validation for SQL injection & XSS attack instead prepare statement.

Why don't you use prepared statements for this?
I think that's a better approach against validating requests.

alpha_numric not enugh for SQL injection filter?

That depends on the input, for insert/update i prefer using prepared statements, and on output i use the esc(); function. You should never trust any input/output always be aware of abuse.

You query bindings then.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )