Skip to main content

Website Portfolio Update: Creating and Managing your Database

When creating a portfolio website, it would be such a hassle to create and design each page for different portfolios. The smart way to tackle this problem is to create one 'template' for your portfolio details, and inputting the content into a database. Adminer is a tool for managing content in MySQL databases. Primarily, Adminer allows you to manage the content of your website through a table-like database, where you can easily add, remove and change the subject matter.

Here you can see my Adminer database. It has two databases, one to represent the content for the portfolio details, and the other is for the gallery.

 This is the porto_info database. It consists of the project id (code for each project), year, title, video (in the form of iframe), image_thumbnail (the same image used for the featured page and the main cover for the portfolio details), head1 and head2 (headings), desc1 and desc2 (description)

This is how the inside of the database looks. I fill in the information that I want to show, and accordingly 'pull' the information from this database to my website so each project id can dispense the correct information.

This database is a new database, where I just put in the images used for the gallery (the collection of pictures for each project). The project_id correlates directly with the id from the porto_info database. Then the image_name is just the images I want to include (be reminded that the spelling should be precise as it is case-sensitive).

The images you want to include in your portfolio should be inserted into FileZilla; a File-Transfer Protocol/FTP application, which allows clients to upload their website to the server. All codings should be inserted into the 'httpdocs' folder, this is THE folder that allows your coding to be uploaded to the server.

For me, I have a folder called assets where I input all my CSS and images (folder). Below, you can see that the images I uploaded to this folder are the same as the images I typed in the database. Another thing to remember is that make sure to compress the images you upload into FileZilla. This is because a website tends to load longer if the file size is big. It is recommended to have an image with size of under 1MB. 


Comments

Popular posts from this blog

TouchDesigner Experiment: Audio Reactive Particle Cloud

My second experiment with TouchDesigner is creating this audio-reactive particle visual by following Bileam Tschepe 's tutorial on Youtube. Again, I just followed his tutorial step by step. This tutorial is a little different because it uses both audio and visuals. The visual follows the music in real-time. Other than audio, we are also introduced with the element 'Math' to add the channels of the audio together. This is the end product. Music is FriendsV2 by Muskatt.

TouchDesigner Experiment: Spectrum to TOPs

This time, the experiment I did with TouchDesigner is creating this audio-reactive abstract wave visual by following Bileam Tschepe 's tutorial on Youtube. This time, Bileam Tschepe's video thought us how to convert an audio spectrum directly to TOPs using the CHOP to TOP and compositing. Following his tutorial, here is my version of the project.  Song by Muskatt .

Introducing Halcyon

Halcyon is an immersive installation that allows users to translate their brainwave activity into visual art with the help of Muse headset. This project aims to provide entertainment purposes for the curious mind and research a less explored territory that is brainwave art in digital media. Wearing the Muse headset across the head, it transfers the brainwave to an application called Mind Monitor, which then sends the data to another software called TouchDesigner to project the visuals in real-time. Halcyon, as a brand, is very fluid and abstract, since it produces artwork that is different for everyone. To emulate this goal, the references for this project need to be represented as such as well. Furthermore, as Halcyon is a simple project, I think that mere typography would be sufficient to deliver the aim of the brand. A logo is the keystone of a brand, and it has the power to represent the values a brand upholds. Before proceeding to design a logo, there are some essential rules that...