{"id":7368,"date":"2022-09-08T08:44:31","date_gmt":"2022-09-08T03:14:31","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-trying-to-convert-mysql-to-mysqli-not-working\/"},"modified":"2022-09-08T08:44:31","modified_gmt":"2022-09-08T03:14:31","slug":"solved-trying-to-convert-mysql-to-mysqli-not-working","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-trying-to-convert-mysql-to-mysqli-not-working\/","title":{"rendered":"[Solved] Trying to convert mysql to mysqli, not working"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

Just for a quick testing<\/strong> purpose, try this below which is a bare bones method. <\/p>\n

You can then slowly build up sanitizing and troubleshoot from thereon.<\/p>\n

<?php\n$username = $_POST['username'];\n$password = sha1($_POST['password']);\n\n$link = mysqli_connect('xxx', 'xxx', 'xxx', 'xxx');\n\n$query = \"SELECT password, id FROM users \nWHERE username=\"$username\" AND password='$password'\";\n\n$result = mysqli_query($link, $query);\n\nif(mysqli_num_rows($result) < 1) \n{\necho 'Sorry, your username and\/or password was incorrect.';\n}\n\nelse\n{\necho \"Welcome!\";\n}\n?>\n<\/code><\/pre>\n
Footnote:<\/strong> I noticed in your original code that you are using sessions. <\/p>\n
I did not see session_start();<\/code> in your code, nor any mention of it.<\/p>\n
This needs to be at the top of your code and inside all<\/strong> your files used,
\nwhich will be needed in order to access anything currently in $_SESSION<\/p>\n
More on sessions can be found on the PHP.net Website.<\/p>\n