tag:blogger.com,1999:blog-5208088681305957591.post1301998924497000861..comments2023-12-21T01:04:27.555-05:00Comments on onlyxcodes: Login and Register Script In PHP PDO With MySQLHamid Shaikhhttp://www.blogger.com/profile/11249349085848207703noreply@blogger.comBlogger21125tag:blogger.com,1999:blog-5208088681305957591.post-20603919832806370632022-02-13T11:02:47.670-05:002022-02-13T11:02:47.670-05:00Outstanding tutorial. I was having a terrible time...Outstanding tutorial. I was having a terrible time getting PHP's password_hash() and password_verify() to work and your code executes them perfectly. I was perplexed/annoyed at first by the image-type code snippets, but I eventually found the Download button, piped the SQL into my database, changed four variables in the connection script, and everything just worked!RatherLoopyhttps://www.blogger.com/profile/11737123852698206938noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-37386279656244649972021-06-28T01:11:33.175-04:002021-06-28T01:11:33.175-04:00thankthankZailir Othmanhttps://www.blogger.com/profile/13675071764158003326noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-14509462986942225942021-06-27T23:48:30.832-04:002021-06-27T23:48:30.832-04:00Yes use $_SESSION and apply different session name...Yes use $_SESSION and apply different session name in login codes.<br /><br />Include session destroy method after user click on the logout link.<br /><br /><br /> Hamid Shaikhhttps://www.blogger.com/profile/11249349085848207703noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-12831306618460920852021-06-27T09:47:37.384-04:002021-06-27T09:47:37.384-04:00Salam Mr Hamid..I have one more question: I have o...Salam Mr Hamid..I have one more question: I have one domain with two sub-page: Example test.com/demo1 & test.com/demo2. Every page I created different login database. Because it is not a different site/domain, so when I login in one page then another page also login. I was thinking we can use $_SESSION to prevent this, but I do not know how to do that..do you have any idea? Zailir Othmanhttps://www.blogger.com/profile/13675071764158003326noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-82973898617363734382021-06-26T23:50:38.223-04:002021-06-26T23:50:38.223-04:00Welcome keep visiting and share your friendsWelcome keep visiting and share your friendsHamid Shaikhhttps://www.blogger.com/profile/11249349085848207703noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-17419921310296857452021-06-25T10:56:09.749-04:002021-06-25T10:56:09.749-04:00Thank you very much Mr Hamid. Finally I successful...Thank you very much Mr Hamid. Finally I successfully apply your advise and solve my problem!<br /><br />Below is the code with your advise(may be can help other people that facing same problem)<br /><br />$select_stmt=$db->prepare("SELECT * FROM masterlogin<br />WHERE username=:uusername AND role=:urole");<br />$select_stmt->bindParam(":uusername", $username);<br />$select_stmt->bindParam(":urole", $role);<br />$select_stmt->execute();<br /><br />while($row=$select_stmt->fetch(PDO::FETCH_ASSOC))<br />{<br />$dbusername =$row["username"];<br />$dbpassword =$row["password"];<br />if(password_verify($password, $dbpassword));<br />$dbrole =$row["role"];<br />}<br />if(($username!=null AND $password!=null AND $role!=null))<br />{<br />if($select_stmt->rowCount()>0)<br />{<br />if($username==$dbusername AND $role==$dbrole)<br />{<br />switch($dbrole)<br />{Zailir Othmanhttps://www.blogger.com/profile/13675071764158003326noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-35199895821406478342021-06-25T07:59:18.447-04:002021-06-25T07:59:18.447-04:00remove password=:upassword and remove $select_stmt...remove password=:upassword and remove $select_stmt->bindParam(":upassword", $password).<br /><br />Try select * from masterlogin query.<br /><br />Put below <br /><br />WHERE username=:username AND role=:urole")<br /><br />within While condition put $dbpassword = $row["password"].<br /><br />and apply this condition if(password_verify($password, $dbpassword)) <br /><br />Hamid Shaikhhttps://www.blogger.com/profile/11249349085848207703noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-70207354384359948562021-06-25T07:21:41.055-04:002021-06-25T07:21:41.055-04:00Thanks..
After I remove $dbpassword=$row["pa...Thanks..<br /><br />After I remove $dbpassword=$row["password"], I got error<br /><br />"Undefined variable: dbpassword in..line 42"<br /><br />Line 42 refer to:-<br /><br />WHERE username=:uusername AND password=:upassword AND role=:urole");Zailir Othmanhttps://www.blogger.com/profile/13675071764158003326noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-83911151072999353842021-06-25T06:20:13.434-04:002021-06-25T06:20:13.434-04:00remove $dbpassword=$row["password"] befo...remove $dbpassword=$row["password"] before password_verify() conditionHamid Shaikhhttps://www.blogger.com/profile/11249349085848207703noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-20516525497727847512021-06-25T03:33:29.403-04:002021-06-25T03:33:29.403-04:00I so sorry sir to disturb you..I had apply your su...I so sorry sir to disturb you..I had apply your suggestion but I get error "Wrong username or password or role" - the code I reply as below (sorry if I'm wrong)<br /><br />$select_stmt=$db->prepare("SELECT username, password, role FROM masterlogin<br />WHERE<br />username=:uusername AND password=:upassword AND role=:urole");<br />$select_stmt->bindParam(":uusername", $username);<br />$select_stmt->bindParam(":upassword", $password);<br />$select_stmt->bindParam(":urole", $role);<br />$select_stmt->execute();<br /><br />while($row=$select_stmt->fetch(PDO::FETCH_ASSOC))<br />{<br /> $dbusername =$row["username"];<br /> $dbpassword =$row["password"];<br /> $dbrole =$row["role"];<br />}<br />if(($username!=null AND $password!=null AND $role!=null))<br />{<br />if($select_stmt->rowCount()>0)<br />{<br />if($username==$dbusername AND $role==$dbrole)<br />$dbpassword=$row["password"];<br />if(password_verify($password, $dbpassword))<br />{<br />switch($dbrole)<br />{<br /><br />Zailir Othmanhttps://www.blogger.com/profile/13675071764158003326noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-73159915355172667752021-06-25T03:06:57.942-04:002021-06-25T03:06:57.942-04:00Welcome, like on Facebook and keep visitingWelcome, like on Facebook and keep visitingHamid Shaikhhttps://www.blogger.com/profile/11249349085848207703noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-39457726133968386612021-06-25T03:05:18.568-04:002021-06-25T03:05:18.568-04:00First put $dbpassword = $row["password"]...First put $dbpassword = $row["password"] as it is. <br /><br />Next, try this condition if (password_verify($password, $dbpassword)). <br /><br />Note: above condition put after this condition if($username==$dbusername AND $role==$dbrole). Remove $password==$dbpassword within this condition.<br />Hamid Shaikhhttps://www.blogger.com/profile/11249349085848207703noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-90326414581606446142021-06-25T02:28:12.562-04:002021-06-25T02:28:12.562-04:00Hi Mr Hamid..that is correct to place here?: the p...Hi Mr Hamid..that is correct to place here?: the password_verify($dbpassword =$row["password"]);<br />Because I got the error "PHP Warning: password_verify() expects exactly 2 parameters, 1 given in.."<br /><br />$select_stmt=$db->prepare("SELECT username, password, role FROM masterlogin<br />WHERE<br />username=:uusername AND password=:upassword AND role=:urole");<br />$select_stmt->bindParam(":uusername", $username);<br />$select_stmt->bindParam(":upassword", $password);<br />$select_stmt->bindParam(":urole", $role);<br />$select_stmt->execute();<br /><br />while($row=$select_stmt->fetch(PDO::FETCH_ASSOC))<br />{<br /> $dbusername =$row["username"];<br /> password_verify($dbpassword =$row["password"]);<br /> //$dbpassword =$row["password"];<br /> $dbrole =$row["role"];<br />}<br />if(($username!=null AND $password!=null AND $role!=null))<br />{<br />if($select_stmt->rowCount()>0)<br />{<br />if($username==$dbusername AND $password==$dbpassword AND $role==$dbrole)<br />{<br />switch($dbrole)<br />{Zailir Othmanhttps://www.blogger.com/profile/13675071764158003326noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-4775435149655064942021-06-25T01:08:22.836-04:002021-06-25T01:08:22.836-04:00Thank you very much sir..most appreciated !Thank you very much sir..most appreciated !Zailir Othmanhttps://www.blogger.com/profile/13675071764158003326noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-46374711725387714162021-06-25T00:53:48.874-04:002021-06-25T00:53:48.874-04:00Hi, Zailir Othman on the registration page impleme...Hi, Zailir Othman on the registration page implements password_hash() function to generate secure password and in login codes use password_verify() function to verify password on the article Multi User Role Based login System.<br /><br />Thank you keep visiting and like on Facebook.Hamid Shaikhhttps://www.blogger.com/profile/11249349085848207703noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-89824673396386322912021-06-25T00:37:37.914-04:002021-06-25T00:37:37.914-04:00Dear Mr Hamid, firstly have to thanks for this cod...Dear Mr Hamid, firstly have to thanks for this code & I successfully apply it. My question is, how to create Masterlogin that comes with roles..like your previous post "Multi User Role Bases Login in PHP with MySQL PDO" ? <br /><br />OR .. how to implement Password Hashed / Encrypt in your "Multi User Role Bases Login in PHP with MySQL PDO" Zailir Othmanhttps://www.blogger.com/profile/13675071764158003326noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-77806438061172502112021-06-05T16:17:40.105-04:002021-06-05T16:17:40.105-04:00I got this warning when trying to register user
Wa...I got this warning when trying to register user<br />Warning: Trying to access array offset on value of type bool in C:\xampp8\htdocs\login1\register.php on line 36<br /><br />Warning: Trying to access array offset on value of type bool in C:\xampp8\htdocs\login1\register.php on line 39Anonymoushttps://www.blogger.com/profile/16500011502763619483noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-67112084387133788902020-12-13T06:21:15.893-05:002020-12-13T06:21:15.893-05:00Saying that password_verify() checks against a has...Saying that password_verify() checks against a hashed/encrypted password string is 50% wrong. password_hash() and password_verify() has nothing to do with encryption (which suggests that they can be decrypted, which they can't.) It's all hashes.maerhttps://www.blogger.com/profile/11997568404005367484noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-23014779216069959002020-04-14T15:08:58.504-04:002020-04-14T15:08:58.504-04:00Ok Hamid Ok Hamid emmyhttps://www.blogger.com/profile/16986578436311795437noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-85722864452497379462020-04-14T02:12:40.601-04:002020-04-14T02:12:40.601-04:00thank you emmy keep visitingthank you emmy keep visitingHamid Shaikhhttps://www.blogger.com/profile/11249349085848207703noreply@blogger.comtag:blogger.com,1999:blog-5208088681305957591.post-12167133952331657912020-04-13T15:11:06.669-04:002020-04-13T15:11:06.669-04:00Dear hamid
Really u are a great man. am glad for ...Dear hamid<br /><br />Really u are a great man. am glad for all the information u have placed on your site . it has helped me alot. am grateful <br /><br />thank u so much for sharing your knowledge , keep it up emmyhttps://www.blogger.com/profile/16986578436311795437noreply@blogger.com