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

We’re Gonna Party Like It’s 2013

The worst thing you could ever do to your day is to say no to the right things and saying yes to what is not. Imagine the things you would do if you know you can possibly do anything. Or how a day can define a year with fewer words. Just a few acts of kindness. A small drop of interest. To reunite and to experience first contact to the people we are yet to know.

Needless to say, this year’s Christmas party was like a rocket ship in a multi stage ignition. At first, a slow but forceful thrust. Then a gradual acceleration up towards the destination. Then a full speed cruise to top it all off.

It was a memorable one. To those who made it through the night and until the last hour, you know how it all went. It was the greatest party yet. Even the next year’s gig had to be epic to even match it.

Happy holidays to all! Thank you all for coming.

IMG-20131221-00377 IMG-20131221-00376 IMG-20131221-00375 IMG-20131221-00366 IMG-20131221-00363 IMG-20131221-00361 IMG-20131221-00360 IMG-20131221-00359 IMG-20131221-00358 IMG-20131221-00357 IMG-20131221-00352IMG-20131221-00349 IMG-20131222-00456 IMG-20131222-00449 IMG-20131222-00401 IMG-20131222-00399 IMG-20131222-00396 IMG-20131222-00393 IMG-20131222-00392 IMG-20131222-00407
- glenoid