Showing posts with label Web Application. Show all posts
Showing posts with label Web Application. Show all posts

Wednesday, October 24, 2007

New Camp Chicosci

Camp Chicosci is a fansite that I started out when I was still in high school. I just love the kids who come and visit the site making it hard for me to just push the stop button. I'd probably keep the site up even until Chicosci gets tired of rocking. Haha.

Chicosci are the happiest band I know out there who just love being out. This is evident by the number of vampires who still come out every night to get a taste of their blood from the dungeon-ist club to arenas when they open for international acts and even converting more vampires along the way.

My favorite among the albums released by this band is Icarus. The album is so rich with stuff they could pickup one day and work with it. My favorite song is...oh, just check out my Camp Chicosci Vampire profile.

Continue reading ‘New Camp Chicosci‘

Friday, August 31, 2007

Apache on your Flash Drive

A professional conversation between two not-so-acquainted guys of the webdesigning & PHP programming world.

Them meticulous looking Lokis of however-big position they occupy in their company:
So you PHP? So you RDBMS? Show me your stuff! Here, sit here.

You:
Can I install...

TMLLOH-BPTOITC:
No. No. You can't install something.

U:
But...uhm

TMLLOH-BPTOITC:
Tomorrow, I wanna see that tomorrow. Online. Have it online.


You don't want to be the you in this conversation, right? Well, then, bring out your dusty USB flash drive and install the portable XAMPP to it.

Apache server and MYSQL right away!

Make sure to change the Apache default port 80 to something not equal to 80, I use 69, to avoid conflict because some system may already have the same service running on that port. Config file is named httpd.conf on the ...\xampplite\apache\conf folder. Find this line "Listen 80" and change it to "Listen 69" if you want to run on the same Highway 69 like me. You have to restart the services. Install all your sample works in htdocs and I figure you already know what to do after that because I assume you have already used some Apps like XAMPP on your own system.


Download XAMPP: http://portableapps.com/apps/development/xampp

Continue reading ‘Apache on your Flash Drive‘

Sunday, August 05, 2007

MPDS: Medical & Pharmaceutical Distributing System

The layouting is done. Everything's in its proper place, all sample schemas, the sizes and the colors are teacher and peers okied. A go signal for me to start with the real programming.

I've been the pretentious hardcoding genius ever since. Writing in every text editors. No WYSIWYG stuff. From layouting to programming I'm that crazy. I start out from scratch with the ever reliable Notepad then switching to Notepad++, just so I could see the line numbers, when those HTML needs PHP.

Some screenshot of the schemas already PHP-ed and MySQL-ed:
Products listing
Product listing for printing
Product information

And, yes, it's my first time to use constraints in SQL. It's hard but when tables are already linked to its right partner table the burden of linking them through query is reduced. All business rules that should be satisfied are defined from within your tables that lessens the WHEREs and the ANDs and all the SUBs. Here's a sample table with constraints.

CREATE TABLE `territories` (
`territories_ID` bigint(20) unsigned NOT NULL auto_increment,
`areasFK_ID` bigint(20) unsigned NOT NULL default '',
`territories_name` varchar(30) NOT NULL default '',
`territories_quota` varchar(15) NOT NULL default '',
PRIMARY KEY (`territories_ID`),
FOREIGN KEY (`areasFK_ID`) REFERENCES areas(`areas_ID`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

Continue reading ‘MPDS: Medical & Pharmaceutical Distributing System‘

Monday, July 16, 2007

MPDS Beta 1.0

Medical & Pharmaceutical Distributing System
Medical & Pharmaceutical Distributing System
I will be working on this school project until October. A web application that will automate every transaction in a local and multi-national distributor of medical and pharmaceutical products. Because I'm that lazy to hardwork a project documentation, I will be doing it here.

A kick-off for this updater is the schemaview of this "distributing system."

Continue reading ‘MPDS Beta 1.0‘

Recent posts



Search




Candies

Powered by FeedBurner
View blog authority Ranking.PinoyBlogosphere.Com Creative Commons License
[ You've reached the bottom. Scroll back to top ]