More progress on the profile-page, a little delayed due to some changes. Pictures coming tomorrow!
Started coding the profile-page. Not much different from the last, just a bit more stylish
Turned up the saturation on the background a bit, looks even cooler now! Full screenshot coming hopefully tomorrow!
Making some sketches for the user & trip page in Figma
Moved things around on the Users-page. Instead of having text flying around everywhere, I put location + following status in badges
Named the Shared City Database... to "Databae", I guess it's better than nothing 🤔
Finished the Shared Database. So to summarize what it is: A database filled with info about cities that will be used for a new Outglobing project and Venture Cost. Going to implement it tomorrow to see how it works!
Got a crash course in Marketing from my new friend I met in Chiang Mai. Literally spoon fed with valuable information! :D
Learned about Many-to-Many Relationships in MySQL. Realized I already knew all of it, but what I really looked for was how to combine the joined tables in PHP. I really need ELI5 for those things!
Do you happen to know much about this? I feel like my solution is too hacky for being the "official" solution to what I need.
Not really sure what an ORM is, but I found the easiest way was to use GROUPCONCAT together with JSONOBJECT. After the query I instantly json_decode the data to make it nice little array! :)
Almost done with the database structure for the shared database I talked about yesterday!
Started working on a shared database for Venture Cost and Outglobing to gather and create valuable city information. This will take a while, but it will be worth the time!
Sneak peek of what's coming! Nothing set in stone, but I can guarantee it's going to look sweet!
Started sketching on the new City Thumbnail. I really recommend trying Figma if you're normally using Photoshop for sketching. It's my first time using it, and I already understand all tools and properties!
More progress on the logo, getting better and better! I think this is my final version, unless someone has some input of course! Thanks @cedricium for the feedback! 🙏
I'll look into it tomorrow, you're right about the graph and I do agree. I think I just got blind adjusting it for too long :D It looks nice when the logo is big, but the graph-line didn't look that nice when the logo is smaller (about 70px). Thanks everyone
Retouched and picked 100 photos from my year in Asia. Going to make a little photo album for friends & family!
Started sketching on a new logo. A more simple look, colors undecided. Any feedback so far? 😇
Hmm 🤔 Maybe I should look into combining the two! Thanks for the input!
Re-wrote major parts of how trips are loaded. Instead of loading everything using AJAX, I preload the first chunk in PHP to give scrapers (Google) a chance to find the URLs. I went from having around 24 pages to 151, which is all of them
And on top of that, since the first chunk is pre-loaded server-side, the loading time is GREATLY reduced. Check it out here: http://localhost/explore
Switched using FontAwesome JS to FontAwesome CSS. Performance got way better as I already use much JS, and the flickering for all icons are gone when refreshing the page
Added current location based on your current trip. Ended up being way more advanced than I thought, but now it's done!
Sorted categories by alphabetical order (Not sure how I missed doing this months ago)
Cities are now initially loaded back-end to make sure SEO stays good. After filters are applied, it uses AJAX of course
Fixed a bug that reloaded the favicon after closing a popup (Caused by editing the url # hash, even though it was empty)
The current trip is now shown in the Header dropdown for easy access. The plus-sign goes to the trip and auto-opens the Add expense-popup
