Skip to main content

Posts

Preparing for Business Attire

During college, it is really difficult for our bodies to accept formal wears . You will become a laugh of the town if you wear business attire when everybody else is wearing casual wear which are in with fashion . Well eventually after college, we would have to wear those clothes that we've avoided all along. How do we train our bodies to accept this? I've got one tip (for college students): 1. Mix formal wear with your casual wear. You can combine jeans with a polo (with trendy designs), and gradually shift those designs to lesser and more formal ones. The jeans gives an impression of a fashionable attire .

Webcam in php

Recently, I got a project for an online DTR system which required the user to have a snapshot of himself/herself first. I really had the trouble doing it since I am not very good in web programming. I searched in Google about using a webcam in php but I was not productive with it. I got really frustrated because as simple as it sounds when the client had me do it, I didn't know how. Well, to be able to pursue the project, I improvised. What I did was create a desktop application using C# that uses an online database in MySQL. The program can read a usb webcam and upload the picture via ftp to the web server. The reports reside on the website so it can be viewed anywhere without installing the application. The problem came when the hosting provider stopped allowing remote MySQL connections due to security reasons. Rather than finding another hosting (I've tried 4 already and they all have one disadvantage or two), I'm trying to find ways to code in php where I can make use o...

1 Million Tweets

Here's something new (well as of this post): 1 Million Tweets in one tweeter account for $1. Basically, you are to post a tweet through their tweeter account which is 1milliontweets , from which you are to post whatever you want (preferably advertise your products or services or your website). This will cost you $1 per tweet. This is quite interesting. Will people patronize this? This will be a question to SEOs. Do you have to pay $1 to advertise through 1 tweeter account? Will this make a significant contribution to optimizing your website?

Ecommerce and Paypal

Just last year before my students did their proposal for their Systems Analysis and Design, I explored Paypal. We wanted to incorporate it into our website at Trimaran Solutions before but the solution was not that easy before. I remembered participating in a campaign to have it offered here in the Philippines. I just can't remember the link. Well back to Paypal, to those programmers who are hesitant on using it, try to explore. They have made it easier to integrate to our websites. You have a lot of options. You can have your own shopping cart, or you can use their shopping cart. Security is not a problem since Paypal had it planned already. They even have all the codes you need ready on their site. (See https://cms.paypal.com/us/cgi-bin/?cmd=_render-content&content_ID=developer/howto_overview https://cms.paypal.com/us/cgi-bin/?cmd=_render-content&content_ID=developer/library_code). What I like the most is the hosted button. I have an example below: (You can donate here if...

Number to Text in Excel in currency format that spells out the decimal portion

follow the instructions on my previous post . replace the code with the following: Option Explicit '**************** ' Main Function * '**************** Function SpellNumber(ByVal MyNumber) Dim Temp, WholeNumberText, DecimalText Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Million " Place(4) = " Billion " Place(5) = " Trillion " ' String representation of amount. MyNumber = Trim(Str(MyNumber)) ' Position of decimal place 0 if none. DecimalPlace = InStr(MyNumber, ".") ' Convert cents and set MyNumber to dollar amount. If DecimalPlace > 0 Then DecimalText = GetTens(Round(Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2), 2)) MyNumber = Trim(Left(MyNumber, DecimalPlace - 1)) End If Count = 1 Do While MyNumber "" Temp = GetHundreds(Right(MyNumber, 3)) If Temp "" Then WholeNumberText = Temp & Place(Count) & WholeNumberText End If If ...

Time range in SQL Server

Sometimes we encounter situations wherein we need to include in our query, a time range given that the only fields in the SQL server database is the start time and the duration: StartTime Duration 09:30:00 AM 60 07:30:00 AM 90 *The table name in this example is tbl_UserSchedule We sometimes want to show it in a form of a time range just like looking at a schedule: Schedule 09:30:00 AM - 10:30:00 AM 07:30:00 AM - 09:00:00 AM The following SQL statement does the job (although not quite optimized): SELECT CONVERT(char(9), StartTime, 108) + CASE WHEN StartTime > '11:59:59 PM' THEN 'PM' ELSE 'AM' END + ' - ' + CONVERT(char(9), DATEADD(minute, Duration, StartTime), 108) + CASE WHEN DateAdd(minute, Duration, StartTime) > '11:59:59 PM' THEN 'PM' ELSE 'AM' END FROM tbl_UserSchedule

Create a CNAME record at godaddy

These instructions are from blogger's site. However, you have to have both domain and hosting account with Godaddy. Total DNS will be empty otherwise. GoDaddy.com Log in to your account at www.godaddy.com . Open the Domains tab and select My Domain Names . You'll be directed to the Domain Manager page. Click the domain that you'd like to use with your blog. Click the Total DNS Control And MX Records link at the bottom of the section entitled Total DNS . Click Add New CNAME Record in the box labelled CNAMES (aliases) . If you've already created a CNAME record for your blog's address, click the pencil icon next to the existing CNAME record. For the Name , enter only the subdomain of the address you want to use for your blog. For example, if you picked www.mydomain.com as your address, enter www here. Enter ghs.google.com as the Host Name . Specify a TTL or use the default setting of 1 hour. Click OK , and then click OK again. Keep up with the la...