Click here to Skip to main content
15,891,184 members

Comments by kmllev (Top 56 by date)

kmllev 28-Dec-16 1:48am View    
I was wishing to know how I could run an SQL query directly from a view.
kmllev 8-Dec-16 1:36am View    
I see. Even though I typed the correct password when trying to "log in", which is "hello", the hash returned is different after checking the $pass in password_hash(), so a successful login perhaps would never be possible. How can I fix it? Or should it be in a new post? All I do is get the input from the user and then fetch from the database the corresponding (hashed) password for that username and then use password_verify to see if they match. More like the question though is: why is hello being hashed when verified as a variable but not when it's explicitly typed?
kmllev 8-Dec-16 0:11am View    
The problem is isn't the method comparing exactly the same values? Basically I copied the value from the database and pasted it in the variable for debugging in the 1st block. In the 1st block I simply did an override of the values, to check if it's working correctly. The 2nd block of code fetches the corresponding hash from the database and returns the same hash/value as in the 1st block. What confuses me is why it returns false when the values aren't changed, as seen in the message the 2nd block returns.
Could it be I'm missing out on something since I'm fetching the value from the database? Some parsing needed?
kmllev 4-Oct-16 11:07am View    
I see. But how will I get the result or the return value of SOUNDEX and DIFFERENCE? I tried them in SQL Server and when they return the result there is no column name?
kmllev 4-Oct-16 1:57am View    
WOW.
I've never heard of this feature before, I'm extremely amazed, lol
But I wonder how I will be able to implement this in C#? How will I get the return value if there is no column name?