Back for 2014!

Goodbye, summer.

Goodbye, summer.

Have you ever had that desire to go on a vacation for two weeks just to shrug the stress away?

How about a 10-week vacation? Sounds even better, right? For me, I think mine was too comfortable and relaxing that going back to work is really another journey back to your very first day at the office. You are back to normal routine from the vacation that spoiled you without alarm clocks to wake you up and deadlines to fulfil.

But the thing is, muscle memory and old habits die so hard that a day on your own desk sends back all that is lost. And you are ready again to be the hero you always have the rest of the year.

The school started yesterday, June 16, 2014, which is also the day the Spurs won the championship and the day I turned 24 (yes, I just posted my own age online). It will be another great year for the freshmen and the second year people. I’m sure their 10-week vacation was no different than mine, so it’s better to warm their fresh-from-hibernation selves up for the next 5 months that would mostly involve me and the computer.

Welcome to Academic Year 2014.

- glenoid

 

 

 

 

Activity 4 for PHP: Searching with AJAX (Asynchronous JavaScript And XML)

Create a web application using AJAX, PHP, MySQL and HTML that could search seamlessly to a MySQL database. Instructions will be given during class.

profile.html

<!doctype html>
<html>
<head>

<link href="css/style.css" rel="stylesheet" type="text/css" />
<script>
    function showUser(str)
    {
    if (str=="")
      {
      document.getElementById("txtHint").innerHTML="";
      return;
      }
    if (window.XMLHttpRequest)
      {// code for IE7+, Firefox, Chrome, Opera, Safari
      xmlhttp=new XMLHttpRequest();
      }
    else
      {// code for IE6, IE5
      xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
      }
    xmlhttp.onreadystatechange=function()
      {
      if (xmlhttp.readyState==4 && xmlhttp.status==200)
        {
        document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
        }
      }
    xmlhttp.open("GET","search.php?q="+str,true);
    xmlhttp.send();
}
</script>
</head>
<body>

<form>
<input type="text" id="search-bar" placeholder="Enter fullname" />
<input type="button" id="search-button" onClick="showUser(document.getElementById('search-bar').value)" value="Go" />
</form>
<br>
<div id="txtHint"><b>Person info will be listed here.</b></div>

</body>
</html>

style.css

@charset "utf-8";
/* CSS Document */

#txtHint{
    width: 500px;
    margin: 0 auto;
    padding: 20px;
    background-color: #30A7AD;
}

#txtHint table{
    width: inherit;
    margin: 0 auto;
}

#txtHint table h1{
    text-align: center;
}

#txtHint table td{
    background-color: #009191;
    color: #E4E4E4;
    padding: 10px;
}

form{
    width: 500px;
    margin: 0 auto;
    background-color: #703788;
    height: 30px;
    padding: 20px;
}

form input{
    border-radius: 20px;
    background-color: #4E6D58;
    color: white;
    font-weight: bold;
    font-size: 18px;
    text-align: center;
}

Activity 3 for PHP: Project Planemo

Follow the instructions for this activity:

Create a database named ‘project_planemo_database’. This database will contain 3 tables: ‘tblinventory’, tblmemberlogininformation’, ‘tbloutgoingtransactions’.

project_planemo_database

Create the three tables with the specs shown.

tblinventory

tblinventory and its structure

tblinventory-contents

tblinventory sample contents

tbloutgoingtransactions

tbloutgoingtransactions and its structure

tbloutgoingtransactions-contents

tbloutgoingtransactions sample contents

tblmemberlogininformation

tblmemberlogininformation and its structure

tblmemberlogininformation-contents

tblmemberlogininformation sample contents

- glenoid

Activity 1 (Midterm) – MySQL Creation in phpMyAdmin

This is an activity for Compro 2 – Love from Sir Glen. To be submitted January 15, 2013 until 6pm. Follow the following directions in creating your database and tables. Good luck.

1. Create a new database in phpMyAdmin named ‘enrolment_system_database’.

2. Inside are three tables ‘tblstudents’, ‘tblfaculty, and ‘tblsubjects’.

3. Create the tables with the following attributes:

tblstudents
Field Name stud_no stud_name stud_age stud_course
Type int varchar int varchar
Length 20 255 10 255
tblfaculty
Field Name fa_no fa_name fa_age fa_course
Type int varchar int varchar
Length 20 255 10 255
tblsubjects
Field Name subj_no subj_name subj_yearlvl
Type int varchar int
Length 20 255 10

4. Fill in each table with at least 5 entries inside it.

5. Export the three tables with NO compression. Don’t zip.

6. Attach and send all files to ‘lasaltechsirglen@gmail.com’.

- glenoid

Christmas Music Video

First, Merry Christmas to all students and  staff of LaSalTech – La Carlota. This blog may be overdue (thanks to my busy schedule during the holiday) but the fact that the students took the time to shoot this within 2 hours each day in a period of two weeks is a great feat. To Compro – Truth who fast-edited the audio and video of this project, good job. Especially to Mr Archie Ong, who was a genius consultant who propelled this venture into further development. Marvin Dave Ganza who edited the whole thing, did most of the heavy-lifting, and uploaded this video to Youtube. To President Anthony Delfin who crammed inspiration to himself and to those who worked with him. To John Manuel Aries for giving the project idea.

Enjoy the video and it has been a great 2013 to all of us.

- glenoid