What and How possible injection in PHP and mysql?
Answers were Sorted based on User's Feedback
Answer / ram
sql injection can be given along with user supplied data.
Examples of sql injection:
' or 1=1 --
' OR '1'='1. these sort of input could break into the code
by tricking the sql query.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / tarun
first of all tell me what is injection here...........
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / dinesh g
What is Injection?
When a user is inserting any value into the text box, we
store that in a variable and place it in a query. If the
user also types any query within the text box our mysql will
run the query.
ex :
INSERT INTO students (name) VALUES ('Dinesh'); DROP TABLE
Students;
Here the user types his name as Dinesh also he write the
next query to drop the table. so this table is dropped if it
is present.
TO avoid it we use addslashes() else
mysql_real_escape_string() methods to escape from the users
query.
| Is This Answer Correct ? | 1 Yes | 1 No |
we store and display scores of users in different games. In MySQL, records are stored as tuples (user-id, game-id, score). Now we need to support ranks of users, i.e., each user should be informed of his current rank in the community. The challenge is to come up with the best way to store the data in MySQL so that the requirements are efficiently met.
Explain about switch statement in PHP?
How to upload and play video in Php when u r in localhost?
Differentiate echo vs. Print statement.
Does php have multiple inheritance?
Do you know what is the function mysql_pconnect() usefull for?
How to use validations in php?(codelgniter)
What is call by reference in php?
Why do we use cookie?
How I use global variable in another page without using $_GET method?
Is false empty php?
What are the differences between session and cookie?