Note

9base status: Educational · Lifecycle: archived.

This repository is retained as historical material and is not actively maintained by 9base. The provenance and scope below distinguish local work from inherited projects and dependencies.

mysqlogin — PHP/MySQL learning archive

This is a small registration, login and account-settings learning application, with local history from April–May 2021. The existing README explains its rewrite from an unsuccessful Flutter/database approach and records development using PHP, MySQL, LAMP and phpMyAdmin. No particular course association is established by the inspected record.

The source entry points are index.php, register.php, login.php and settings.php, with SQL material, styles and historical screenshots. The original README's schema, installation narrative and screenshots are preserved below. Its old demo links, server/configuration examples and deployment statements are historical documentation, not evidence of a currently live or supported service.

The collection is retained to make the learning exercise understandable; it is not presented as a current production authentication component. Source, database material, LICENSE and existing attribution are unchanged. No contemporary deployment or runtime verification was performed.

Archival reconstruction note

This explanation was reconstructed on 8 October 2026 from the public repository tree, metadata and commit history. It is new documentation of historical material, not evidence that this explanation existed during the original development period. Original source authorship, technical history and license files have not been rewritten.

---

Legacy README (preserved unchanged)

mysqlogin

A simple login and log up application written in PHP. That uses MySQL queries and server connection.

..Note: Flutter side is not actually worked in some situations. It needs a localhost database connection without any password security (neither native_sql_connection nor chipher_sha2_secure). So I rewrite them up in PHP as well.

Installation

I use my own server to develop this project. You can preview it on with clicking.

I developed it onto phpstorm, served using LAMP and phpmyadmin. If you dont know how to install LAMP server look at my post about it on dev.to from here

Lets import database

Importing Database

phpmyadmin

Put all files with *.php extension and css/ directory on /var/www/html directory.

Open the phpadmin. Add new database from left side of the page
Put name as new database users then click Create
Select users database name left of the databases. An then click Import from tab In this page you will import database with sql file provided with this project Click to browse Find sql file fith explorer.
Scroll down and click to go. It will open a page and this page give lots of successfull output.

From manual

If you dont have any information about the phpmyadmin you can import it manually. Firstly create a database into your mysql. Lets open mysql from console:

mysql

Then create a database named users from here.

CREATE DATABASE users;

Then say exit to mysql shell and import file from console

mysql -u username -p users < sql/auth.sql

Installing Files

If this step is done, open /var/www/html directory and fix your config.php file.

config.php is generation codes of yout server.

In my side my server is http://68.183.106.165/ my database host is 127.0.0.1 my database is users my database username is admin and password is admin config.php file should look like that:

<?php
   $link = "http://68.183.106.165/";
   $host = '127.0.0.1'; 
   $database = 'users';
   $username = 'admin'; 
   $password = 'admin';
?>

.. Note: Don't forget / character at the end of the link. .. Note: Dont use localhost. Use 127.0.0.1 instead of localhost

And your server is ready.

DDL Codes

-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- Host: mysql
-- Generation Time: Apr 26, 2021 at 09:29 PM
-- Server version: 10.5.8-MariaDB-1:10.5.8+maria~focal
-- PHP Version: 7.2.34

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `users`
--

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255),
  `address` varchar(255),
  `phone_number` varchar(255)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `email`,`address`, `phone_number`) VALUES
(1, 'suleyman', 'poyraz', '[email protected]', 'Somewhere around the world', '110510181'),
(2, 'deneme', '827ccb0eea8a706c4c34a16891f84e7b', NULL, NULL, NULL),
(3, 'ray', 'malifalitiko', NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

DML Codes

This queries used in PHP codes. Also you can found it on index.php file.

This shows all users with given $user_id

SELECT * FROM users WHERE id = $user_id

This shows all users with given user_name

SELECT * FROM users WHERE username = $user_name

This shows all user rows.

SELECT * FROM users

This creates new user with given password and username variables. ":username" and ":password" are php queries.

INSERT INTO users (username, password)
            VALUES (:username, :password)

This is changes user credentials where user_id is same with given parameter.":username", ":password", ":email",":address" and "phone_number" are php queries. '{$_COOKIE["user_id"]}' is also cookie for php.

UPDATE users SET username = :username, password = :password, email = :email, address = :address,  phone_number=:phone_number WHERE id = '{$_COOKIE["user_id"]}';