php - Mysqli does not retrieve password from database -


I am starting to learn PHP and using mysqli I am working on a simple password change script. I am using a MySQL tutorial as a reference. Now I have a problem where my code is unable to get the old password from the database, and I have not received any error messages. 

  if ($ user) {// start password change ($ submit) {$ oldpassword = $ _POST ['oldpassword']; $ Newpassword = $ _POST ['new password']; $ Repeat_newpassword = $ _POST ['repeat_newpassword']; // $ db connect = mysqli_connect ($ mysqli_error (connect) "Could not connect to database!".) Connect ("localhost", "root", "****", "registration") or die Go; $ Queryget = mysqli_query ($ Connect, "Username WHERE Username = '$ user'" "Select password) or die (" query error ". Mysqli_error ($ connect)); $ line = mysqli_fetch_assoc ($ queryget); $ Oldpassworddb = $ line ['password']; // if checking fields are filled in ($ oldpassword & amp; $ newpassword & amp; $ repeat_newpassword) {if ($ oldpassword $ oldpassworddb ==) {If ($ newpassword == $ repeat_newpassword) {$ querychange = mysqli_query ($ connect, "user update password = '$ new password' WHERE user name = '$ user'") or die ("pass Word query error ". Mysqli_error ($ connect)); session_destroy (); die (" & lt; a href = login.php & gt; 'Return to login.' & Lt; / a & gt; ");} and Die ("new passwords are not match!");} And die ("old password is not match!");} And echo "all fields should be filled!";}

when Also I enter in the $ oldpassword , this "does not match the old password"; even if the old password I enter matches one of the databases. I have also checked the DB password to ensure that there is no free space or this kind of problem arises. 

  $ oldpassword echo "& lt; br & gt;"; Echo $ oldpassworddb "& lt; br & gt;"; $ Count = mysqli_num_rows ($ queryget); Echo $ count; Die (); I have used it to see if the code will print the value from the DBS password block, but it returns only  $ oldpassword  and  $ count  Returns '0' This definitely connects to the database and a user is present, so I have to do something related to the query. 
 
 I appreciate the help, I think that this is a very simple fix due to the slight difference between mysql and mysql, but I'm having a hard time finding a similar problem / solution online. . 
 
 Post text "itemprop =" text "> 
 You should not attempt to get the password from the table, but to check that the password is getting, so use of 
 
  Select user name where user name = '$ user and password = password (' $ oldpassword ')

Comments

Post a Comment

Popular posts from this blog

ios - How do I use CFArrayRef in Swift? -

I am using Objective-class in my Swift Project through a bridging header. The method signature looks like this: - Some cement (some type) some parameters; I started by getting an example of class, calling method, and storing the value: var myInstance = MyClassWithThatMethod (); Var cfArr = myInstance.someMethod (some value); Then try to get the value in the array: var valueInArrayThatIWant = CFArrayGetValueAtIndex (cfArr, 0); However, I get the error unmanaged & lt; Cfarray & gt; Not like 'CFArray' . Unmanaged & lt; Cfarray & gt; also means? I looked, but I do not need to change the array in a fast array (though it would be good). I need to be able to get value from the array. I also tried CFArray method to pass in a function: func doSomeStuffOnArray (myArray: NSArray) {} Although I get the same error when using: doSomeStuffOnArray (cfArr); // unmanaged & lt; CFArray & gt; I am using CFArray because I want to sto...
Read more

eclipse plugin - Run java code error: Workspace is closed -

To create an automated project, I created a plug-in project with the following dependencies: Org.eclipse.core.resources org.eclipse.equinox.registry org.eclipse.core.runtime and the following The Java class is located in the src folder: Package Examiner; Import org.eclipse.core.resources.IProject; Import org.eclipse.core.resources.IWorkspaceRoot; Import org.eclipse.core.resources.ResourcesPlugin; Import org.eclipse.core.runtime.CoreException; Import org.eclipse.core.runtime.IProgressMonitor; Import org.eclipse.core.runtime.NullProgressMonitor; Public class tes {public static zero main (string [] args) {// TODO auto generated method stub IProgressMonitor progress monitor = new NullProgressMonitor (); IWorkspaceRoot root = ResourcesPlugin.getWorkspace (). GetRoot (); Ipoject project = root.jetproject ("desired projectname"); Try {Project.create (progress monitor); Project.open (progressMonitor); } Grip (CoreException E) {// TODO Auto generated blocking block e....
Read more

c - Error on building source code in VC 6 -

When I create my project in VC6, the BScMKE reports the following error Linking .. Creating Library ... .. / ... / PB / Bean / Debub / ICEERP.Lib and Object ........ P.B. / Bean / DBube / ICREPlay.APP Browse information file ... BSMMK: ​​error can not be read from BK 1505: file '../../PB/bin/TmpOut/ICReplay/Debug/ICReplay_PB.bsc' Error executing bscmake.exe Can someone help me? 2 Reason for reference from: "ICReplay_PB .bsc "file will be corrupted The trunk of the file will be happening with the compiler running out of disk space or is being interrupted when creating .sbr file I think this answer will help you!
Read more