Introduction to Information and Communication Technologies for Development

• Aims: The roles and history of information and communication technologies in environment and social development are explained. Basic protocols for Internet (Ethernet and TCP/IP) and its related protocols (SMPT, FTP, and HTTP) are then explained. The basic technologies for Internet communication are explained. Internet services and their basic technologies, and the technologies which support web-based approaches are outlined. Finally, as an example of these technologies applied to development, we focus on e-learning.

• Lecture note for the 1st, 2nd, and 3rd days: lec01-03.pdf
• Lecture note for the 4th, 5th, and 6th days: lec04-06.pdf

How to upload files to web serve sv123.ide.titech.ac.jp

• First, you make directory pubic_html in your home directory at your local computer
• Make for edit files in pubic_html
• We assume that your account name is 17M01234
• Upload files by the following command at your home directory.

    rsync -av public_html/ 17M01234@sv123.ide.titech.ac.jp:public_html/
  

• / (slash) at the last is important.
• You can see the result using web server by the following URL http://sv123.ide.titech.ac.jp/~17M01234/
• Errors of a PHP program is displayed by the setting of php.ini

Login: 
  mysql -u 00M00000 -p
  (password)

Logout:
  quit

Create database (Its name is D00M00000).
  create database D00M00000;

Use a database
  use D00M00000;

Delete a database
  drop database D00M00000;

---------------------------------
Make a table :
  create table testTbl (type char(1), sname text, fname text);

Input data :
  insert into testTbl values ('1', 'Einstein', 'Albert');
  insert into testTbl values ('1', 'Newton', 'Isaac');
  insert into testTbl values ('2', 'Curie', 'Maria');
  insert into testTbl values ('3', 'Heisenberg', 'Werner');

Search data :
  select * from testTbl;
  select type,sname from testTbl;
  select * from testTbl where type='1';

Update data :
  select * from testTbl;
  update testTbl set type='5' where sname='Curie';
  select * from testTbl;

Delete data :
  select * from testTbl;
  delete from testTbl where type='1';
  select * from testTbl;

Delete a table :
  drop table testTbl;

---------------------------------
  create table groupTbl (gid char(4), name varchar(64));
  create table groupUser (gid char(4), uid varchar(4));
  create table userTbl (uid char(4), name varchar(64));

  insert into userTbl values ('0001', 'Hirobumi ITO');
  insert into userTbl values ('0002', 'Kiyotaka KURODA');
  insert into userTbl values ('0003', 'Saneto SANJO');
  insert into userTbl values ('0004', 'Aritomo YAMAGATA');
  insert into userTbl values ('0005', 'Saneyoshi MATSUKATA');
  insert into userTbl values ('0006', 'Shigenobu OKUMA');

  insert into userTbl values ('0007', 'Kinmochi SAIONJI');
  insert into userTbl values ('0008', 'Taro KATSURA');
  insert into userTbl values ('0009', 'Gonbei YAMAMOTO');

  insert into groupTbl values ('0001', 'East Asia');
  insert into groupTbl values ('0002', 'South East Asia');
  insert into groupTbl values ('0003', 'Africa');

  insert into groupUser values ('0001', '0002');
  insert into groupUser values ('0001', '0003');
  insert into groupUser values ('0001', '0004');
  insert into groupUser values ('0001', '0005');
  insert into groupUser values ('0002', '0001');
  insert into groupUser values ('0002', '0002');
  insert into groupUser values ('0002', '0008');
  insert into groupUser values ('0003', '0003');
  insert into groupUser values ('0003', '0007');
  insert into groupUser values ('0003', '0009');

  select * from groupTbl,groupUser,userTbl where groupTbl.gid=groupUser.gid and userTbl.uid=groupUser.uid;

  select userTbl.name,groupTbl.name from groupTbl,groupUser,userTbl where groupTbl.gid=groupUser.gid and userTbl.uid=groupUser.uid;

  select userTbl.name,groupTbl.name from groupTbl,groupUser,userTbl;