Editing Mika/Notes

'''This is where I keep notes on things that I will probably need to read again.
'''

=Public Health=

The page got too long, so I moved it to [http://wiki.mako.cc/Mika/Notes/Public_Health Public Health].

=Movies=

I liked these movies:

* Trouble the water
* Cube
* MST3K Pumaman

=Computer Stuff=

Writing down things I've learned. Some miscellaneous stuff are:

* AJAX example: Checks if the username you entered is taken.
* Javascript example: Drag choices up and down.
* The tool to take a screen-videoshot (screencast) is to install recordmydesktop.

==PHP==

'''Problem:'''

Again, I was doing [http://php5.seesaa.net/category/4118446-1.html this tutorial]. I got the update/delete working but not insert. Even when I typed in the values, it returned Missing Values.

'''Solution'''

I said name="id" in select3.php in the form part for insert3.php but I said _POST[ID] in insert3.php. I changed it to id and it works fine now.

----

'''Problem:'''

I was doing [http://php5.seesaa.net/category/4118446-1.html this tutorial]. First of all, I didn't quite write down the codes right:

* incorrect update/delete versions linked from select.php
* <?= is good <? = is not good 
* _GET['X'] is good but _GET["X"] is not good.
* Don't free memory in the php that is required_once

After fixing all these, I got:

"failed query"
SQL:SELECT Name WHERE ID =

'''Solution'''

Since I got the same message for both update and delete, I figured that the problem was elsewhere. I looked at select3 and after update3.php? I said id= instead ID= . I capitalized the id for bother update3 and delete3 and it works fine now.

==MySQL==

To be sorted:

* http://mysqlweb.net/category/4025593-1.html
* http://dev.mysql.com/doc/refman/5.0/en/join.html
* http://dev.mysql.com/doc/refman/5.1/en/selecting-rows.html

===Cheat Sheet===

* mysql_connect()
* mysql_select_db()
* mysql_query()
* mysql_num_rows()
* [http://php.net/manual/en/function.mysql-free-result.php mysql_free_result()]
* mysql_close()
* This is for outputting mysql queries into a text file: mysql > select * from table INTO OUTFILE '/tmp/test.txt';

'''Problem:'''

I tried to write a php and connect to mysql in it but I got an error:

 Fatal Error: undefined function mysql_connect()

'''Solution:'''

[http://www.webmasterworld.com/forum88/5216.htm This page] suggested that mysql isn't enabled by dafault in php5. I installed php5-mysql and restarted apache2 (don't know if that was necessary) and now it works.

----
'''Problem:'''

I restarted my computer because I couldn't start gimp unless I was root. Clint told me that I should sudo /etc/init.d/dbus restart , which basically restarted my whole computer. Since then, I couldn't use mysql because I kept getting this error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

'''Solution:'''

I followed [http://forums.mysql.com/read.php?11,42525,46765#msg-46765 this] and restarted mysql by:

/etc/init.d/mysql restart

But it fails. It seems like I touched my.cnf and didn't restart mysql, so when my computer restarted, it incorporated the changes I made in my.cnf and mysql stopped working. I reinstalled mysql-server through apt-get, restarted mysql and now it's fine. 

 
----
'''Problem:'''

I have a bunch of text files from USDA, which contain bits and pieces USDA ASCII databases. I want to put them into mysql. 

'''Solution:'''

1. I found schema.sql that Erik created, so I'm going to borrow it rather than creating my own.

mysql databasename < schema.sql -p


'''Problem:'''

mysql> create database newdatabase;

ERROR 1044 (42000): Access denied for user 'user'@'localhost'...

'''Solution:''' 

[http://dev.mysql.com/doc/refman/5.1/en/creating-database.html mysql]

1. Check grants for 'user'@'localhost' in mysql:

mysql> show grants for 'user'@'localhost';

2. Log into mysql as root (has all privileges) and change grants for a specific user:

mysql> grant all privileges on *.* to 'user'@'localhost';

Query OK, 0 rows affected (0.00 sec)

3. Log back into mysql as user (now has all privileges) and try creating a new database again.

----

==Python==

To be sorted
* http://mysql-python.sourceforge.net/MySQLdb.html
** http://www.devshed.com/c/a/Python/MySQL-Connectivity-With-Python/2/


'''Problem:'''

I wanted to create a [http://en.wikipedia.org/wiki/Table_markup wiki table] from CIA's Infant Mortality Rate [https://www.cia.gov/library/publications/the-world-factbook/rankorder/2091rank.html ranking] data. I didn't want to change to the wiki table format, so I decided to write a python code.

'''Solutions:'''

I had to read a text file, make a list for each line, take out the words I need, and print in the wiki table format. I did the following first to change tabs to commas but that was probably not necessary:
 
     sed 's/\\t/,/g' Desktop/rawIMRdata.text > rawIMRdata2.text


When I forgot /g, it only outputted the last line. 

Here's the python code:

     imr_data = open("rawIMRdata6.text")
     #f = file("imr_data","r")
     print '''{| class="wikitable" border="1" \n|- \n!  Ranking 1 \n!  Country 2 \n!  IMR \n'''
     for line in imr_data.readlines():
         # To make a list for each line from text file:
         a = line.split(',')
         #print a and strip the space after each word
         one = a[0].strip()
         two = a[1].strip()
         three = a[3].strip()	
         combined = '|-\n|' + one + '\n|' + two + '\n|' + three   
         print combined
     print r'''|}'''

----

==Django==
----

*Tried setting up Django on my computer by following this [http://itpro.nikkeibp.co.jp/article/COLUMN/20081031/318265/?ST=develop&P=4 tutorial]

'''Problem:'''

It worked mostly ok but I couldn't go further than the second to the last coding box on page 4. I kept getting long error messages. 

'''Solution:'''

[http://docs.djangoproject.com/en/dev/intro/tutorial02/ Django tutorial about django.contrib.admin]

1. Check if I typed in the correct codes.

2. Check if the output are the same everwhere:

Although the codes were correct, they didn't create all the necessary things, so it couldn't find the index.html. 

* I went to setting.py to specify:
** the absolute path for Template_Dir. Don't forget the , after '/path/' .
** two additional Installed_Apps: myprj_myapp (where I save my project) and django.contrib.admin . Run python manage.py syncdb afterwards.

This created myapp_post and django_admin_log in mysql database.

----

==Javascript==
----

[http://java-script.seesaa.net/category/2493027-1.html JS Tutorial]

----

==HTML==

'''Problem:'''

I didn't know what <td> meant.

'''Solution:'''

[http://www.w3schools.com/TAGS/tag_td.asp This website] says: An HTML table has two kinds of cells:

    * Header cells - contains header information (created with the th element)
    * Standard cells - contains data (created with the td element)

----

'''Problem:'''

I didn't know what <form name="form1"> meant.

'''Solution:'''

"A form is an area that can contain form elements.

Form elements are elements that allow the user to enter information (like text fields, textarea fields, drop-down menus, radio buttons, checkboxes, etc.) in a form."
[http://www.tohoho-web.com/js/index.htm　とほほのjavascript]

==Command line==

* arch: get architecture info
@@ Line 1: / Line 1: @@
 '''This is where I keep notes on things that I will probably need to read again.
 '''
-* I moved Computer Stuff to a [http://wiki.mako.cc/Mika/Notes/Computer_Stuff new page]
-* [http://wiki.mako.cc/Mika/Notes/Biking Biking] information on a separate page.
-* Moved to [http://wiki.mako.cc/Mika/Notes/Public_Health Public Health].
-* Made a [http://wiki.mako.cc/Mika/Notes/Beer Beer] page
-=Miscellaneous=
-* Banach-Tarski paradox.
+=Public Health=
-* minipimer
-* Temblor Range
-* Khalil Gibran
-* Making of 3 'Idiots'
-* <strike/> 野菜寿し ポタジエ Yasai Sushi </strike>
-* ヴィーガンメニューが提供されているのは、権八の銀座・渋谷・西麻布店
-* 8tablish
-* Sundial Atelier
-* MOCORO モコロ vacuum
-* 丸ゆべし
-* Fly Geyser
-* Bar Yamamoto
-* Wall bar
-* Rage bar
-* Tapas Molecular Bar at Mandarin Oriental, Tokyo
-* [http://daikokuyu.com/index.html daikokuyu]
-* ディマシオ美術館
-* MERIDA X BASE
-* 御殿場MTBパークFUTAGO
-* notNeutral cups
-* おふろcafeハレニワの湯 - cheap fun sento in Saitama
-* Kerala Onam festival
-* オレンジ食堂
-* hijikawa arashi
-* 狸サイクル
-=Gardening=
+The page got too long, so I moved it to [http://wiki.mako.cc/Mika/Notes/Public_Health Public Health].
-* I can use agar to grow Kaiware seeds etc.
+=Movies=
+I liked these movies:
+* Trouble the water
+* Cube
+* MST3K Pumaman
+=Computer Stuff=
+Writing down things I've learned. Some miscellaneous stuff are:
+* AJAX example: Checks if the username you entered is taken.
+* Javascript example: Drag choices up and down.
+* The tool to take a screen-videoshot (screencast) is to install recordmydesktop.
+==PHP==
+'''Problem:'''
+Again, I was doing [http://php5.seesaa.net/category/4118446-1.html this tutorial]. I got the update/delete working but not insert. Even when I typed in the values, it returned Missing Values.
+'''Solution'''
+I said name="id" in select3.php in the form part for insert3.php but I said _POST[ID] in insert3.php. I changed it to id and it works fine now.
+----
+'''Problem:'''
+I was doing [http://php5.seesaa.net/category/4118446-1.html this tutorial]. First of all, I didn't quite write down the codes right:
+* incorrect update/delete versions linked from select.php
+* <?= is good <? = is not good
+* _GET['X'] is good but _GET["X"] is not good.
+* Don't free memory in the php that is required_once
+After fixing all these, I got:
+"failed query"
+SQL:SELECT Name WHERE ID =
+'''Solution'''
+Since I got the same message for both update and delete, I figured that the problem was elsewhere. I looked at select3 and after update3.php? I said id= instead ID= . I capitalized the id for bother update3 and delete3 and it works fine now.
+==MySQL==
+To be sorted:
+* http://mysqlweb.net/category/4025593-1.html
+* http://dev.mysql.com/doc/refman/5.0/en/join.html
+* http://dev.mysql.com/doc/refman/5.1/en/selecting-rows.html
+===Cheat Sheet===
+* mysql_connect()
+* mysql_select_db()
+* mysql_query()
+* mysql_num_rows()
+* [http://php.net/manual/en/function.mysql-free-result.php mysql_free_result()]
+* mysql_close()
+* This is for outputting mysql queries into a text file: mysql > select * from table INTO OUTFILE '/tmp/test.txt';
+'''Problem:'''
+I tried to write a php and connect to mysql in it but I got an error:
+ Fatal Error: undefined function mysql_connect()
+'''Solution:'''
+[http://www.webmasterworld.com/forum88/5216.htm This page] suggested that mysql isn't enabled by dafault in php5. I installed php5-mysql and restarted apache2 (don't know if that was necessary) and now it works.
+----
+'''Problem:'''
+I restarted my computer because I couldn't start gimp unless I was root. Clint told me that I should sudo /etc/init.d/dbus restart , which basically restarted my whole computer. Since then, I couldn't use mysql because I kept getting this error:
+ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
+'''Solution:'''
+I followed [http://forums.mysql.com/read.php?11,42525,46765#msg-46765 this] and restarted mysql by:
+/etc/init.d/mysql restart
+But it fails. It seems like I touched my.cnf and didn't restart mysql, so when my computer restarted, it incorporated the changes I made in my.cnf and mysql stopped working. I reinstalled mysql-server through apt-get, restarted mysql and now it's fine.
+----
+'''Problem:'''
+I have a bunch of text files from USDA, which contain bits and pieces USDA ASCII databases. I want to put them into mysql.
+'''Solution:'''
+. I found schema.sql that Erik created, so I'm going to borrow it rather than creating my own.
+mysql databasename < schema.sql -p
+'''Problem:'''
+mysql> create database newdatabase;
+ERROR 1044 (42000): Access denied for user 'user'@'localhost'...
+'''Solution:'''
+[http://dev.mysql.com/doc/refman/5.1/en/creating-database.html mysql]
+. Check grants for 'user'@'localhost' in mysql:
+mysql> show grants for 'user'@'localhost';
+. Log into mysql as root (has all privileges) and change grants for a specific user:
+mysql> grant all privileges on *.* to 'user'@'localhost';
+Query OK, 0 rows affected (0.00 sec)
+. Log back into mysql as user (now has all privileges) and try creating a new database again.
+----
+==Python==
+To be sorted
+* http://mysql-python.sourceforge.net/MySQLdb.html
+** http://www.devshed.com/c/a/Python/MySQL-Connectivity-With-Python/2/
+'''Problem:'''
+I wanted to create a [http://en.wikipedia.org/wiki/Table_markup wiki table] from CIA's Infant Mortality Rate [https://www.cia.gov/library/publications/the-world-factbook/rankorder/2091rank.html ranking] data. I didn't want to change to the wiki table format, so I decided to write a python code.
+'''Solutions:'''
-=Bicycle=
+I had to read a text file, make a list for each line, take out the words I need, and print in the wiki table format. I did the following first to change tabs to commas but that was probably not necessary:
+     sed 's/\\t/,/g' Desktop/rawIMRdata.text > rawIMRdata2.text
-* Brakes
-** Change brake pads before the grooves are gone: http://www.jimlangley.net/wrench/brake1.htm
-** U-brake (Center pulled calliper brake) are what's on my red bike.
-* Items that may be useful for touring trips
-** Portable Water Heater - SunRocket Solar Thermos and Kettle - Boil Water With Only Sunlight
-=Hiking=
+When I forgot /g, it only outputted the last line.
-* Potential summer hike ideas
+Here's the python code:
-:: [http://www.wta.org/go-hiking/seasonal-hikes/summer-destinations/mount-st.-helens-hikes Mt. St. Helens]
-=Concert=
+     imr_data = open("rawIMRdata6.text")
+     #f = file("imr_data","r")
+     print '''{| class="wikitable" border="1" \n|- \n!  Ranking 1 \n!  Country 2 \n!  IMR \n'''
+     for line in imr_data.readlines():
+         # To make a list for each line from text file:
+         a = line.split(',')
+         #print a and strip the space after each word
+         one = a[0].strip()
+         two = a[1].strip()
+         three = a[3].strip()
+         combined = '|-\n|' + one + '\n|' + two + '\n|' + three
+         print combined
+     print r'''|}'''
-* Chopin Piano Concerto #1
+----
-* Ravel Piano Concerto in G major
-* Gruppen (Stockhausen)　(2012 May NY Philharmonic?)
-* Symphony No. 3 (Górecki)
-=Piano=
+==Django==
+----
-* Balakirev / Glinka "The Lark"
+*Tried setting up Django on my computer by following this [http://itpro.nikkeibp.co.jp/article/COLUMN/20081031/318265/?ST=develop&P=4 tutorial]
-* Liszt "Gnomenreigen"
-* Chopin 3rd Sonata
-* Beethoven Sonata 31
-* ラヴェル／鏡より「道化師の朝の歌」
-=Movies=
+'''Problem:'''
+It worked mostly ok but I couldn't go further than the second to the last coding box on page 4. I kept getting long error messages.
+'''Solution:'''
+[http://docs.djangoproject.com/en/dev/intro/tutorial02/ Django tutorial about django.contrib.admin]
-I liked these movies:
+. Check if I typed in the correct codes.
-* Trouble the water
+. Check if the output are the same everwhere:
-* Cube
-* MST3K Pumaman
-* Tokyo!
-* Annabel Chong
-* I love me
-I want to watch these movies:
+Although the codes were correct, they didn't create all the necessary things, so it couldn't find the index.html.
-* Uncle Boonmee Who Can Recall His Past Lives
+* I went to setting.py to specify:
-* Faust by Alexander Sokurov
+** the absolute path for Template_Dir. Don't forget the , after '/path/' .
-* ビルマVJ 消された革命
+** two additional Installed_Apps: myprj_myapp (where I save my project) and django.contrib.admin . Run python manage.py syncdb afterwards.
-* Sleeping Beauty (2011)
-* Amour
-* Pee Wee's big adventure
-* White Dog, The Naked Kiss, Shock Corridor by Samuel Fuller
-* スープ
-* Kings of Pastry
-* Streetwise (1984)
-=Books=
+This created myapp_post and django_admin_log in mysql database.
-* 1Q84
+----
-* AIDS and Accusation (Paul Farmer)
-* 農協との３０年戦争 岡本重明
-* Saturday is for Furnerals (Max Essex)
-* クォンタム・ファミリーズ
-* Penguin and Leviathan (Yochai Benkler)
-* The Price of Civilization (Jeffrey Sachs)
-* Godel, Escher, Bach
-* 百年の孤独
-*Ramesh S. Arunachalam, 2011: The Journey of Indian Micro-Finance: Lessons for the Future.
-* 石の花 (坂口尚)
-* Reassembling the Social
-* reread: biology as ideology
-* reread: the structure of scientific revolution
-* 最貧困女子
-* On Food and Cooking: The Science and Lore of the Kitchen (Hardcover)
-* Les Animaux tels qu'ils sont
-=Articles=
+==Javascript==
+----
-* Happy Land
+[http://java-script.seesaa.net/category/2493027-1.html JS Tutorial]
-* Ashtrays
-* Wasteland
-=Places=
+----
-* Xkeken
+==HTML==
-* Shark Bay
-* スコトラ島
-* Kayangan Lake
-* Perchten festival in the western Austrian village of Heitwerwang
-* 坊主バー　in Yotsuya: http://vowz-bar.com/
-* cycling museum in osaka
-* キットカット　ショコラトリー
-* ベーカリー兎座LEPUS うさぎ型食パン
-* EdiTion Koji Shimomura: French restaurant with some veg options; near Roppongi
-* Veganic to go: burger place near Roppongi
-* Japanese [https://vegewel.com/ja/cuisine/93 website] for finding veg restaurants
-=Diving=
+'''Problem:'''
-* Jewfish
+I didn't know what <td> meant.
-* Basking shark
-* Mola mola
-* Turtles
-=Wines=
+'''Solution:'''
-* majo norante "ramitello" rosso biferno molise at Nook. Can't remember the year.
+[http://www.w3schools.com/TAGS/tag_td.asp This website] says: An HTML table has two kinds of cells:
-* Denavolo Dinavolo Vino da Tavola 2007 at The Remedy.
-=Traveling tips=
+    * Header cells - contains header information (created with the th element)
+    * Standard cells - contains data (created with the td element)
-* How to send things from UK:
+----
-: You can get a small, medium, or large box at post office (haven't tried royal mail but they're similar?). You can send a ''small parcel'' = less than 2kg internationally for a reasonable price. From UK to Japan is about 25 quid for 2kg.
-==Tokyo Bars==
+'''Problem:'''
-Good:
+I didn't know what <form name="form1"> meant.
-* BAR ORCHARD (Ginza)
+'''Solution:'''
-* High Five (Ginza)
-* Mori Bar (Ginza)
-* Bar Hoshi (Ginza)
-* Ben Fiddich (Shinjuku)
-* The SG Club (Shibuya)
+"A form is an area that can contain form elements.
-Ok:
+Form elements are elements that allow the user to enter information (like text fields, textarea fields, drop-down menus, radio buttons, checkboxes, etc.) in a form."
-* Star Bar (Ginza)
+[http://www.tohoho-web.com/js/index.htm　とほほのjavascript]
-* swrl (Shibuya)
-* Gen Yamamoto (Azabujuban)
-* グランドファイン (Nakameguro)
-List of subpages:
+==Command line==
-* [[Mika/Notes/2016]]
+* arch: get architecture info
-* [[Mika/Notes/Beer]]
-* [[Mika/Notes/Beer/Imperial IPA 2017]]
-* [[Mika/Notes/Computer Stuff]]
-* [[Mika/Notes/Computer Stuff/Debian Installation]]
-* [[Mika/Notes/Computer Stuff/Debian Maintenance]]
-* [[Mika/Notes/Computer Stuff/R]]
-* [[Mika/Notes/Phrontistery 2015]]
-* [[Mika/Notes/Public Health]]
-* [[Mika/Notes/Seattle]]
-* [[Mika/Notes/Todo]]
-* [[Mika/Notes/Travel]]
-* [[Mika/Notes/Travel/2015 FridayHarbor]]
-* [[Mika/Notes/moving]]
-* [[Mika/Temp/WikiFCD/FCTtemplate]]
-* [[Mika Books]]
-* [[Modularity and FOSS]]