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 )
(06-28-2021, 05:11 AM)InsiteFX Wrote: You would need to build your own queries to lock and unlock. 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.
You query bindings then.
What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
|
Welcome Guest, Not a member yet? Register Sign In |