Tutorial on how to prevent mysql injection using mysql function and php script from beginning to advance no PDO

Guides Resources
, ,
#40

But as I told you earlier, this problem arises when I use procdure, not funnction.
And for the record, this sentence works in function normally.
But what made me hate function when I ask for example id, usernaem from within row I can’t do RETURN except id for example
I mean I couldn’t get the id and the username back together unfortunately

#41

RETURN It’s only allowed in function.

#42

I understand…

You are doing it wrong…

just calm the script has no issue…

according to the error you sent it means no row was return from your statement.

now when i looked into your statement you are not out putting anything out you need to select the variable.

you know in function you use Return but in procedure you will use Select

#43

You need to select it not return

1 Like
#44

yes, when I did what you say and went to write RETURN in the procdure, I got an error message telling me return can only be used in function.

#45

Use Select not Return

1 Like
#46

Is here now… Select the variable not return

#47

Yes, after using SELECT, the code has worked :tada::tada:

#48

you can mark one of my reply has solution… happy coding… you just need to understand mysql very well… the script is okay no issue.

bye for now :slight_smile:

1 Like
#49

I really wanted to do something for you this solution was less the least I could have done for you to help me but unfortunately you created the post so do not show me the sign of solution here you are the only one who can make a solution mark

#50

If that’s not going to bother you, please wipe the solution mark.
Because this post will close in 30 days, and no one if they need help can write their problem here.

#52

I did it like you said, but still when I get in +1, two are added.

#53

send me your code privately… let me check.

1 Like
#54

You may also want to try this library for running MYSQL in a simple way. only for web developer.
MYSQL LIBRARY

#55

I see I missed some things. Please don’t use all caps. That is like shouting and we don’t shout here. Please change that.

#56

Brand new version…

OSQL - Mysql freedom is here, injection stop and bind parameter available - Guides / Resources - Kodular Community

#57

When call unicode string charactors from sql table, those strings showing as “?? ?” marks only.
How to fix it?

#58

Recently i am using taifun mysql.php
And deephost mysql extension

So som hackers decompile my apk ang get all database details and making script of my app.

How can i hide my mysql key & url.

#59

follow this guide as mentioned in the first post

Taifun
PS: I will close this thread

#60