TudloTech

TudloTech is an offline learning companion for practicing CRUD systems in PHP + MySQL and Python (Flask). It adds a panel to the Explorer sidebar where you can browse complete sample projects, read their code, and store your own projects for review.

Features

• Project Library: 18 built-in training projects (11 PHP, 7 Python), each labelled php or python.
• Project search: type part of a name to filter the list. Type py to show only the Python projects.
• File Explorer: lists every file in the selected project, with a filename search box.
• Code Viewer: shows the code of the file you click, with syntax colours for PHP, SQL, JavaScript and Python.
• Copy and Open in Editor: copy a file's code, or open it in a full editor tab.
• Store your own projects: save any folder from your computer into the library, or start an empty project and add files to it.
• Works offline: after installing, no internet is needed.

How it works

The built-in projects are packed inside the extension, so they are available on every computer that installs it. They are read-only.

Projects you add yourself are saved as copies in a private folder on your computer. Your original folders are never changed, and your stored projects are only visible to you on that computer.

How to use it

Open the panel

1. Open the Explorer (Ctrl+Shift+E).
2. Find the TudloTech section. If it is hidden, right-click any section header in the Explorer and tick TudloTech.

Study a project

1. Click a project in the Project Library.
2. Click a file in the File Explorer. Use the search box to find a file by name.
3. Read the code in the Code Viewer. Click Copy to copy it, or Open in Editor for a full tab.

Store your own project

Adding a file to a built-in project makes your own editable copy of it first.

How to run the sample projects

PHP projects

1. Install XAMPP and start Apache and MySQL.
2. Copy the project's files into a folder inside C:\xampp\htdocs.
3. Open http://localhost/phpmyadmin and import the project's .sql file.
4. Open http://localhost/<your folder>/ in a browser.

Python projects (names ending in _py)

1. Install Python, then run pip install flask.
2. Copy the project's files into a folder, keeping the templates folder.
3. In that folder, run python app.py.
4. Open the address shown in the terminal, usually http://127.0.0.1:5000. The database is created from the .sql file on first run.

Uninstalling and clearing its files

Uninstalling removes the extension and its built-in projects, but VS Code keeps the projects you stored yourself. To clear everything:

1. Delete your stored projects first. In the TudloTech panel, click ... and choose Delete All My Stored Projects. Skip this if you never added a project.
2. Uninstall. Open Extensions (Ctrl+Shift+X), find TudloTech, and click Uninstall.
3. Restart VS Code. The extension's own files are removed on restart.

If you already uninstalled without step 1, delete the leftover folder by hand. Close VS Code, then delete the bisayanibai.tudlotech folder in:

On Windows, press Win+R, paste the path, and press Enter to open it.

To check that the extension itself is gone, look in %USERPROFILE%\.vscode\extensions on Windows, or ~/.vscode/extensions on macOS and Linux. If a folder starting with bisayanibai.tudlotech- is still there after a restart, delete it.

Built-in projects

PHP + MySQL: Library, Intramurals, BooksISBN, VetClinic, ClinicLogging, Congress, EventsRegistration, EmployeeAttendance, ClinicConsultations, Events, Library_v2

Python (Flask): BookSystem_py, EmployeeAttendance_py, EventSports_py, ICTCongressRegistration_py, Intramurals_system_py, Library_system_py, Clinic_py