I'm trying to make a simple login page with MySQL but been having problem linking. I'm using xampp and eclipse as my php development tool. My database name is 'arc' with the table 'login'.
Script:
Error:
Am I missing something?
Asked
Active
Viewed 30 times
0
-
You're missing that `mysql` extension is __removed__ – u_mulder Aug 27 '17 at 18:36
-
can you please point which line I'm missing? @u_mulder – David Aug 27 '17 at 18:47
-
See http://php.net/manual/en/mysqlinfo.api.choosing.php don't use `mysql_` – chris85 Aug 27 '17 at 18:58
1 Answers
1
According to php docs mysql_real_escape_string extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0.
You should check mysqli instead.
-
Oh I see. Is there a way to go around it? or the new extension perhaps? I've read about using 'mysqli', but i'm not really familiar about it. I'm kinda new in this development. – David Aug 27 '17 at 18:54
-
@David The latest is the PDO stack which has many more options. But the thing you are trying to do is available in mysqli. Check the updated answer. – Fawaz Aug 27 '17 at 19:12
-
@David You literally replace `mysql` with `mysqli` in each function name - it can be done with a single search and replace. Although I'd recommend PDO over MySQLi myself because it makes it easier to switch away from MySQL if necessary. – Matthew Daly Aug 27 '17 at 19:15