diff options
Diffstat (limited to 'mysql-php/code/a2.php')
| -rw-r--r-- | mysql-php/code/a2.php | 24 |
1 files changed, 8 insertions, 16 deletions
diff --git a/mysql-php/code/a2.php b/mysql-php/code/a2.php index 9d9a1a5..84a56f8 100644 --- a/mysql-php/code/a2.php +++ b/mysql-php/code/a2.php @@ -3,7 +3,7 @@ declare(strict_types=1); error_reporting(E_ALL); function connect_to_database() { - mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); + # mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); if (!($dbh = mysqli_connect('localhost', 'root', ''))) display_failure('Could not connect to the database: ' . mysqli_connect_error($dbh)); mysqli_set_charset($dbh, 'utf8mb4'); @@ -11,21 +11,14 @@ function connect_to_database() { display_failure('Could not create database: ' . mysqli_error($dbh)); mysqli_select_db($dbh, 'STUDENTS_DB'); if (!mysqli_query($dbh, 'CREATE TABLE IF NOT EXISTS STUDENT ( - ROLL INT(20) PRIMARY KEY, - NAME VARCHAR(255), - CITY VARCHAR(255), - EMAIL VARCHAR(255), - DATE_OF_BIRTH DATE - )')) + ROLL INT(20) PRIMARY KEY, NAME VARCHAR(255), CITY VARCHAR(255), + EMAIL VARCHAR(255), DATE_OF_BIRTH DATE)')) display_failure('Could not create `STUDENT` table: ' . mysqli_error($dbh)); - if (!mysqli_query($dbh, 'CREATE TABLE IF NOT EXISTS `LOGIN` ( - `USERNAME` VARCHAR(255), - `PASSWORD` VARCHAR(255), - UNIQUE (`USERNAME`) - )')) + if (!mysqli_query($dbh, 'CREATE TABLE IF NOT EXISTS `LOGIN` (`USERNAME` VARCHAR(255), `PASSWORD` VARCHAR(255), UNIQUE (`USERNAME`))')) display_failure('Could not create `LOGIN` table: ' . mysqli_error($dbh)); if (!mysqli_query($dbh, 'IF NOT EXISTS (SELECT * FROM `LOGIN` WHERE `USERNAME` = "admin") THEN - INSERT INTO `LOGIN` (`USERNAME`, `PASSWORD`) VALUES ("admin", "$2y$10$3cq2joFu6kEYccaTxDkRXexrsd3GAnq4rGTip9erOucM9H9E8q5ly"); + INSERT INTO `LOGIN` (`USERNAME`, `PASSWORD`) VALUES ("admin", "$2y$10$3cq2joFu6kEYccaTxDkRXexrsd3GAnq4rGTip9erOucM9H9E8q5ly"), + ("user123", "$2y$10$F1gZoOfRUMcMduyokgOKcevNAZ9GXmUHrtjWoZYkgN38NJ6pKgPAC"); END IF')) display_failure('Could not create `LOGIN` table: ' . mysqli_error($dbh)); return $dbh; @@ -45,8 +38,7 @@ function check_credentials($dbh, $username, $password) { function update_credentials($dbh) { if (!check_credentials($dbh, @$_POST['previous_username'], @$_POST['previous_password'])) display_failure('Can not update credentials, both previous usernames and passwords need to be provided and they need to be valid.'); - $new_username = null; - $new_password = null; + $new_username = $new_password = null; $successful = []; if (!empty($_POST['new_username'])) $new_username = $_POST['new_username']; @@ -61,7 +53,7 @@ function update_credentials($dbh) { mysqli_stmt_bind_param($stmt, 'ss', password_hash($new_password, PASSWORD_DEFAULT), $_POST['previous_username']); $successful['password'] = mysqli_stmt_execute($stmt); } - if ($new_username !== NULL) { + if ($new_username !== null) { $stmt = mysqli_prepare($dbh, 'UPDATE `LOGIN` SET `USERNAME` = ? WHERE `USERNAME` = ?'); mysqli_stmt_bind_param($stmt, 'ss', $_POST['new_username'], $_POST['previous_username']); $successful['username'] = mysqli_stmt_execute($stmt); |