Although HTML table syntax also works, special wikicode can be used as a shortcut to create a table. The pipe (vertical bar) codes function exactly the same as HTML table markup, so a knowledge of HTML table code will help in understanding pipe code. The shortcuts are as follows:
* The entire table is encased with curly brackets and a vertical bar character (a pipe). So use {| to begin a table, and |} to end it. Each one needs to be on its own line:
{|
table code goes here
|}
* An optional table caption is included with a line starting with a vertical bar and plus sign "|+" and the caption after it:
{|
|+ caption
table code goes here
|}
* To start a new table row, type a vertical bar and a hyphen on its own line: "|-". The codes for the cells in that row will start on the next line.
{|
|+ The table's caption
|-
cell code goes here
|-
cell code goes here
|}
* Type the codes for each table cell in the next row, starting with a bar:
{|
|+ The table's caption
|-
| cell codes go here
|-
| cells in the next row go here
| more cells in the same row here
|}
* Cells can be separated with either a new line and new bar, or by a double bar "||" on the same line. Both produce the same output:
{|
|+ The table's caption
|-
|Cell 1 || Cell 2 || Cell 3
|-
|Cell A
|Cell B
|Cell C
|}
* If you use single bars, then what might appear to be the first cell is in fact a format modifier applied to the cell, and the rest of your "cells" will be merged into one:
{| border="1"
|-
|format modifier (not displayed)|These all |(including the pipes)|go into |the first cell
|-
|}
which is probably not what you want:
These all |(including the pipes)|go into |the first cell
However, the format modifier is useful:
{| border="1"
|-
|Cell 1 (no modifier - not aligned)
|-
|align="right" |Cell 2 (right aligned)
|-
|}
Cell 1 (no modifier - not aligned)
Cell 2 (right aligned)
Just remember: no more than 2 single pipes on a line!
* a row of column headings is identified by using "!" instead of "|", and using "!!" instead of "||". Header cells typically render differently from regular cells, depending on the browser. They are often rendered in a bold font and centered.
{|
|+ The table's caption
! Column heading 1 !! Column heading 2 !! Column heading 3
|-
|Cell 1 || Cell 2 || Cell 3
|-
|Cell A
|Cell B
|Cell C
|}
* the first cell of a row is identified as row heading by starting the line with "!" instead of "|", and starting subsequent data cells on a new line.
{|
|+ The table's caption
! Column heading 1 !! Column heading 2 !! Column heading 3
|-
! Row heading 1
| Cell 2 || Cell 3
|-
! Row heading A
|Cell B
|Cell C
|}
* Optional parameters can modify the behavior of cells, rows, or the entire table. For instance, a border could be added to the table:
{| border="1"
|+ The table's caption
! Column heading 1 !! Column heading 2 !! Column heading 3
|-
! Row heading 1
| Cell 2 || Cell 3
|-
! Row heading A
|Cell B
|Cell C
|}
The final table would display like this:
The table's caption Column heading 1 Column heading 2 Column heading 3
Row heading 1 Cell 2 Cell 3
Row heading A Cell B Cell C
The table parameters and cell parameters are the same as in HTML, see [1] and Table (HTML). However, the thead, tbody, tfoot, colgroup, and col elements are currently not supported in MediaWiki.
A table can be useful even if none of the cells have content. For example, the background colors of cells can be changed with cell parameters, making the table into a diagram, like m:Template talk:Square 8x8 pentomino examplehttp://meta.wikimedia.org/wiki/Template_talk:Square_8x8_pentomino_example. An "image" in the form of a table is much more convenient to edit than an uploaded image.
Each row must have the same number of cells as the other rows, so that the number of columns in the table remains consistent. For empty cells, use the non-breaking space as content to ensure that the cells are displayed. To show a visible pipe in a cell, use
| or |.
With colspan and rowspan cells can span several columns or rows, see the Mélange example below. However, this has the disadvantage that sorting does not work properly anymore.
Examples
Simple example
Both of these generate the same output. Choose a style based on the number of cells in each row and the total text inside each cell.
Wiki markup
{|
| A
| B
|-
| C
| D
|}
{|
| A || B
|-
| C || D
|}
What it looks like in your browser
A B
C D
Multiplication table
Wiki markup
{| class="wikitable" style="text-align:center"
|+Multiplication table
|-
! × !! 1 !! 2 !! 3
|-
! 1
| 1 || 2 || 3
|-
! 2
| 2 || 4 || 6
|-
! 3
| 3 || 6 || 9
|-
! 4
| 4 || 8 || 12
|-
! 5
| 5 || 10 || 15
|}
What it looks like in your browser (see: Help:User_style)
Multiplication table × 1 2 3
1 1 2 3
2 2 4 6
3 3 6 9
4 4 8 12
5 5 10 15
Color; scope of parameters
Two ways of specifying color of text and background for a single cell are as follows. The first form is preferred:
Wiki markup
{|
| style="background:red; color:white" | abc
| def
| bgcolor="red" |
ghi
| jkl
|}
What it looks like in your browser
abc def ghi jkl
Like other parameters, colors can also be specified for a whole row or the whole table; parameters for a row override the value for the table, and those for a cell override those for a row:
Wiki markup
{| style="background:yellow; color:green"
|-
| abc || def || ghi
|- style="background:red; color:white"
| jkl || mno || pqr
|-
| stu || style="background:silver" | vwx || yz
|}
What it looks like in your browser
abc def ghi
jkl mno pqr
stu vwx yz
To make the table blend in with the background, use style="background:none" or style="background:transparent". (Warning: style="background:inherit", does not work with some browsers, including IE6!)
See : style, background, list of colors, web colors
Width, height
The width and height of the whole table can be specified, as well as the height of a row. To specify the width of a column one can specify the width of an arbitrary cell in it. If the width is not specified for all columns, and/or the height is not specified for all rows, then there is some ambiguity, and the result depends on the browser.
Wiki markup
{| style="width:75%; height:200px" border="1"
|-
| abc || def || ghi
|- style="height:100px"
| jkl || style="width:200px" |mno || pqr
|-
| stu || vwx || yz
|}
What it looks like in your browser
abc def ghi
jkl mno pqr
stu vwx yz
Note that style="inline CSS" has no effect with some browsers. If compatibility is important, equivalent older constructs like width="75%" should work on more browsers.
Setting your column widths
If you wish to force column widths to your own requirements, rather than accepting the width of the widest text element in a column's cells, then follow this example. Note that wrap-around of text is forced.
{| border="1" cellpadding="2"
!width="50"|Name
!width="225"|Effect
!width="225"|Games Found In
|-
|Poké Ball || Regular Poké Ball || All Versions
|-
|Great Ball || Better than a Poké Ball || All Versions
|}
Name Effect Games Found In
Poké Ball Regular Poké Ball All Versions
Great Ball Better than a Poké Ball All Versions
To set column widths in a table without headers, specify the width in the first cell for each column, like this:
{| border="1" cellpadding="2"
|-
|width="100pt"|This column is 100 points wide
|width="200pt"|This column is 200 points wide
|width="300pt"|This column is 300 points wide
|-
|blah || blih || bluh
|}
This column is 100 points wide This column is 200 points wide This column is 300 points wide
blah blih bluh
One application of setting the widths is aligning columns of consecutive tables:
Country Capital
The Netherlands Amsterdam
Country Capital
France Paris
Vertical alignment
By default data in tables is vertically centrally aligned, which results in odd-looking layouts like this:
Row heading A longer piece of text. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. A shorter piece of text.
Row heading A longer piece of text.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. A shorter piece of text.
To fix this, apply the valign="top" attribute to the rows (unfortunately it seems to be necessary to apply this individually to every single row). For example:
{| border="1" cellpadding="2"
|-valign="top"
|width="10%"|'''Row heading'''
|width="70%"|A longer piece of text. Lorem ipsum...
|width="20%"|A shorter piece of text.
|-valign="top"
|'''Row heading'''
|A longer piece of text. Lorem ipsum...
|A shorter piece of text.
|}
Row heading A longer piece of text. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. A shorter piece of text.
Row heading A longer piece of text.Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. A shorter piece of text.
Positioning
One can position the table itself, and all contents in a row, and contents in a cell, but not with a single parameter for all contents in the table, see m:Template talk:Table demo. Do not, under any circumstances, use "float" to position a table. It will break page rendering at large font sizes.
Mélange
Here's a more advanced example, showing some more options available for making up tables. Note however that with colspan and rowspan sorting does not work properly anymore.
You can play with these settings in your own table to see what effect they have. Not all of these techniques may be appropriate in all cases; just because you can add colored backgrounds, for example, doesn't mean it's always a good idea. Try to keep the markup in your tables relatively simple -- remember, other people are going to be editing the article too! This example should give you an idea of what is possible, though.
Wiki markup
{| border="1" cellpadding="5" cellspacing="0" align="center"
|+'''An example table'''
|-
! style="background:#efefef;" | First header
! colspan="2" style="background:#ffdead;" | Second header
|-
| upper left
|
| rowspan=2 style="border-bottom:3px solid grey;" valign="top" |
right side
|-
| style="border-bottom:3px solid grey;" | lower left
| style="border-bottom:3px solid grey;" | lower middle
|-
| colspan="3" align="center" |
{| border="0"
|+''A table in a table''
|-
| align="center" width="150px" | [[Image:Wiki.png]]
| align="center" width="150px" | [[Image:Wiki.png]]
|-
| align="center" colspan="2" style="border-top:1px solid red; border-right:1px solid red; border-bottom:2px solid red; border-left:1px solid red;" |
Two Wikimedia logos
|}
|}
What it looks like in your browser
An example table First header Second header
upper left
right side
lower left lower middle
A table in a table Image:Wiki.png Image:Wiki.png
Two Wikimedia logos
Floating table
Wiki markup
This paragraph is before the table. Lorem ipsum dolor sit
amet, consectetur adipisicing elit, sed do eiusmod tempor
incididunt ut labore et dolore magna aliqua. Ut enim ad
minim veniam, quis nostrud exercitation...
{| align="right" border="1"
| Col 1, row 1
|rowspan="2"| Col 2, row 1 (and 2)
| Col 3, row 1
|-
| Col 1, row 2
| Col 3, row 2
|}
Note the floating table to the right.
This paragraph is after the table. Lorem ipsum dolor sit
amet, consectetur adipisicing elit, sed do eiusmod tempor
incididunt ut labore et dolore magna aliqua. Ut enim ad
minim veniam, quis nostrud exercitation...
What it looks like in your browser
This paragraph is before the table. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation...
Col 1, row 1 Col 2, row 1 (and 2) Col 3, row 1
Col 1, row 2 Col 3, row 2
Note the floating table to the right.
This paragraph is after the table. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation...
Nested tables
Five different (blue) tables are shown nested inside the cells of a table. Automatically the two tables |A| and |B|B| are vertically aligned instead of the usual side by side of text characters in a cell. "float" is used to fix each of tables |C| and |D| to their own position within one cell of the table. This may be used for charts and schemes. Nested tables must start on a new line.
Wiki markup
{| border="1"
| α
| align="center" | cell2
{| border="2" style="background:#ABCDEF;"
| NESTED
|-
| TABLE
|}
| valign="bottom" | the original table again
| style="width:100px;" |
{| border="2" style="background:#ABCDEF;;"
| A
|}
{| border="2" style="background:#ABCDEF;"
| B || B
|}
| style="width:50px;" |
{| border="2" style="background:#ABCDEF; float:left;"
| C
|}
{| border="2" style="background:#ABCDEF; float:right;"
| D
|}
|}
What it looks like in your browser
α cell2
NESTED
TABLE
the original table again
A
B B
C
D
Combined use of COLSPAN and ROWSPAN
Wiki markup
{| border="1" cellpadding="5" cellspacing="0"
|-
| Column 1 || Column 2 || Column 3
|-
| rowspan="2"| A
| colspan="2" align="center"| B
|-
| C
| D
|-
| E
| rowspan="2" colspan="2" align="center"| F
|-
| G
|-
| colspan="3" align="center"| H
|}
What it looks like in your browser
Column 1 Column 2 Column 3
A B
C D
E F
G
H
Note that using rowspan="2" for cell G combined with rowspan="3" for cell F to get another row below G and F won't work, because all (implicit) cells would be empty. Likewise complete columns are not displayed if all their cells are empty. Borders between non-empty and empty cells might be also not displayed (depending on the browser), use to fill an empty cell with dummy content.
Centering tables
Centered tables can be achieved, but they will not "float"; that is to say, no text will appear to either side. The trick is {| style="margin: 1em auto 1em auto"
Wiki markup
{| class="wikitable" style="margin: 1em auto 1em auto"
|+ '''Cells left-aligned, table centered'''
! Duis || aute || irure
|-
| dolor || in reprehenderit || in voluptate velit
|-
| esse cillum dolore || eu fugiat nulla || pariatur.
|}
What it looks like in your browser
Cells left-aligned, table centered Duis aute irure
dolor in reprehenderit in voluptate velit
esse cillum dolore eu fugiat nulla pariatur.
Setting parameters
At the start of a cell, add your parameter followed by a single pipe. For example width="300"| will set that cell to a width of 300 pixels. To set more than one parameter, leave a space between each one.
Wiki markup
{| style="color:white"
|-
| bgcolor="red"|cell1 || width="300" bgcolor="blue"|cell2 || bgcolor="green"|cell3
|}
What it looks like in your browser
cell1 cell2 cell3
Decimal point alignment
A method to get columns of numbers aligned at the decimal point is as follows:
Wiki markup
{| cellpadding="0" cellspacing="0"
|align="right"| 432 || .1
|-
|align="right"| 43 || .21
|-
|align="right"| 4 || .321
|}
What it looks like in your browser
432 .1
43 .21
4 .321
If the column of numbers appears in a table with cell padding or cell spacing, one can still align the decimal points without an unsightly gap in the middle. Embed a table in each number's cell and specify its column widths. Make the embedded tables' column widths the same for each cell in the column. (If decimal points are still misaligned using this method, the main table's column may be too narrow. Add a parameter to increase the column's width.)
Wiki markup
{|border="1" cellpadding="4" cellspacing="2"
|
{|cellpadding="0" cellspacing="0" width="100%"
|align="right" width="50%"| 432 ||width="50%"| .1
|}
|-
|
{|cellpadding="0" cellspacing="0" width="100%"
|align="right" width="50%"| 43 ||width="50%"| .21
|}
|-
|
{|cellpadding="0" cellspacing="0" width="100%"
|align="right" width="50%"| 4 ||width="50%"| .321
|}
|}
What it looks like in your browser
432 .1
43 .21
4 .321
In simple cases one can dispense with the table feature and simply start the lines with a space, and put spaces to position the numbers:
432.1
43.21
4.321
Style classes
See also Help:User style.
In the first line of table code, after the "{|", instead of specifying a style directly one can also specify a CSS class. The style for this class can be specified in various ways:
* in the software itself, per skin (for example the class sortable)
* collectively for all users of one wiki in MediaWiki:Common.css (for example, on this and some other projects there is the class wikitable)
* separately per skin in MediaWiki:Monobook.css etc.
* individually on one wiki in a user subpage
* individually, but jointly for tables of the class concerned on all web pages, on the local computer of the user.
Instead of remembering table parameters, you just include an appropriate style class after the {|. This helps keep table formatting consistent, and can allow a single change to the class to fix a problem or enhance the look of all the tables that are using it at once. For instance, this:
{| border="1" cellpadding="2"
|+Multiplication table
|-
! × !! 1 !! 2 !! 3
|-
! 1
| 1 || 2 || 3
|-
! 2
| 2 || 4 || 6
|-
! 3
| 3 || 6 || 9
|-
! 4
| 4 || 8 || 12
|-
! 5
| 5 || 10 || 15
|}
Multiplication table × 1 2 3
1 1 2 3
2 2 4 6
3 3 6 9
4 4 8 12
5 5 10 15
becomes this:
{| class="wikitable"
|+Multiplication table
|-
! × !! 1 !! 2 !! 3
|-
! 1
| 1 || 2 || 3
|-
! 2
| 2 || 4 || 6
|-
! 3
| 3 || 6 || 9
|-
! 4
| 4 || 8 || 12
|-
! 5
| 5 || 10 || 15
|}
Multiplication table × 1 2 3
1 1 2 3
2 2 4 6
3 3 6 9
4 4 8 12
5 5 10 15
simply by replacing inline CSS for the table by class="wikitable". This is because the wikitable class in MediaWiki:Common.css contains a number of table.wikitable CSS style rules. These are all applied at once when you mark a table with the class. You can then add additional style rules if desired. These override the class's rules, allowing you to use the class style as a base and build up on it:
Wiki markup
{| class="wikitable" style="font-style:italic; font-size:120%; border:3px dashed red;"
|+Multiplication table
|-
! × !! 1 !! 2 !! 3
|-
! 1
| 1 || 2 || 3
|-
! 2
| 2 || 4 || 6
|-
! 3
| 3 || 6 || 9
|-
! 4
| 4 || 8 || 12
|-
! 5
| 5 || 10 || 15
|}
What it looks like in your browser
Multiplication table × 1 2 3
1 1 2 3
2 2 4 6
3 3 6 9
4 4 8 12
5 5 10 15
Notice that the table retains the gray background of the wikitable class, and the headers are still bold and centered. But now the text formatting has been overridden by the local style statement; all of the text in the table has been made italic and 120% normal size, and the wikitable border has been replaced by the red dashed border.
Of course this works only for browsers supporting inline CSS, if it's important use XHTML markup like
instead of "font-size:120%", or Wiki markup like ''text'' instead of "font-style:italic".
Sorting
Tables can be made sortable by adding class="sortable"; for details see Help:Sorting. Since this can be very useful, it is wise to keep the possibilities and limitations of this feature in mind when designing a table. For example:
* Do not divide a table into sections by subheaders spanning several rows. Instead, an extra column can be made showing the content of these headers on each row, in a short form.
* Do not have elements spanning several columns; instead, again, repeat the content on each row, in a short form.
* In a column of numbers, do not put text such as "ca." in front of a number-it will sort like zero. Do not put text after the number, and do not put a range of numbers (it does not affect the sorting position for numeric sorting mode, and in the case of a range, the first number determines the position, but if, possibly after sorting this or another column, the element is at the top, it will induce alphabetic sorting mode). Instead, put these texts in a separate column. Alternatively, for the greatest flexibility, alphabetic sorting mode with hidden sortkeys can be used.
A long form of abbreviated content can be put as legend outside the table.
Wiki markup
{| class="wikitable sortable"
|+Sortable table
|-
! Alphabetic !! Numeric !! Date !! class="unsortable" | Unsortable
|-
| d || 2 || 2008-11-24 || This
|-
| b || 8 || 2004-03-01 || column
|-
| a || 6 || 1979-07-23 || cannot
|-
| c || 4 || 1492-12-08 || be
|-
| e || 0 || 1601-08-13 || sorted.
|}
What it looks like in your browser
Sortable table Alphabetic ↓ Numeric ↓ Date ↓ Unsortable
d 2 2008-11-24 This
b 8 2004-03-01 column
a 6 1979-07-23 cannot
c 4 1492-12-08 be
e 0 1601-08-13 sorted.
Row template
Regardless of whether wikitable format or HTML is used, the wikitext of the rows within a table, and sometimes even within a collection of tables, has much in common, e.g.:
* the basic code for a table row
* code for color, alignment, and sorting mode
* fixed texts such as units
* special formats for sorting
In that case it can be useful to create a template that produces the syntax for a table row, with the data as parameters. This can have many advantages:
* easily changing the order of columns, or removing a column
* easily adding a new column if many elements of the new column are left blank (if the column is inserted and the existing fields are unnamed, use a named parameter for the new field to avoid adding blank parameter values to many template calls)
* computing fields from other fields, e.g. population density from population and area
* duplicating content and providing span tags with "display:none" for the purpose of having one format for sorting and another for display
* easy specification of a format for a whole column, such as color and alignment
Example:
Using m:help:table/example row template (talk, backlinks, edit)
{| class="wikitable sortable"
|-
! a
! b
! a/b
{{help:table/example row template| 50|200}}
{{help:table/example row template| 8| 11}}
{{help:table/example row template|1000| 81}}
|}
gives:
a ↓ b ↓ a/b ↓
50 200 0.25
8 11 0.72727272727273
1000 81 12.345679012346
Conditional table row
A pipe character for a table row may be desired as part of a parameter value in the call of a template or parser function (in particular, it can be in code made optional using ParserFunctions). However, expansion of templates and parser functions happens before interpretation of table syntax. This causes a pipe character in a parameter value to be interpreted as a separator between parameter definitions. To avoid this these pipe characters are put with a special template:! ( talk edit history links ), see template:Table example with optional row ( talk edit history links ).
If one tries to use as conditional code for a conditional row "{{!}}-{{!}}text" the problem is that the last is ignored:
a{{#if:1|b
}}c
gives "abc".
Thus depending on whether there is a after the condition, we could have a newline too many or too few.
This is solved by using the technique of Help:Newlines and spaces#Spaces and/or newlines as value of an unnamed parameter:
{| class=wikitable
{{#if:x|{{!}}-
{{!}}true}}{{{{#if:x|1x|void}}|
}}{{#if:|{{!}}-
{{!}}true}}{{{{#if:|1x|void}}|
}}{{#if:|{{!}}-
{{!}}true}}{{{{#if:|1x|void}}|
}}{{#if:|{{!}}-
{{!}}true}}{{{{#if:|1x|void}}|
}}{{#if:x|{{!}}-
{{!}}true}}{{{{#if:x|1x|void}}|
}}{{!}}-
|unconditional
|}
gives
true
true
unconditional
Each condition is used at two places; to avoid having it twice in the wikitext it can be made a template parameter for a template containing the code for conditionally producing a table row, e.g. Template:Conditional template call with newline (backlinks, edit), and in this case
{{#if:{{{1}}}|{{!}}-
{{!}}true}}{{{{#if:{{{1}}}|1x|void}}|
}}
Other table syntax
Other types of table syntax that MediaWiki supports:
1. XHTML
2. HTML & wiki- syntax (Do not use)
All three are supported by MediaWiki and create (currently) valid HTML output, but the pipe syntax is the simplest. Also, HTML & wiki- | syntax (i.e., unclosed | and | tags) will not necessarily remain browser-supported in the upcoming future, especially on handheld internet-accessible devices.
See also Table (HTML), HTML element#Tables. Note however that the thead, tbody, tfoot, colgroup, and col elements are currently not supported in MediaWiki.
Comparison of table syntax
XHTML HTML & Wiki-td Wiki-pipe
Table
{|
|}
Caption caption caption
|+ caption
Row
|
|-
Data cell
cell1 |
cell2 |
cell1
| cell2
| cell1
| cell2
Data cell | cell1 | cell2 | cell3 | cell1 | cell2 | cell3
| cell1 || cell2 || cell3
Header cell | heading | heading
! heading
Sample table
1 2
3 4
{|
| 1 || 2
|-
| 3 || 4
|}
Sample table
1 2
3 4
5 6
{|
| 1 || 2
|-
| 3 || 4
|-
| 5 || 6
|}
Pros
* Can be previewed/debugged with any XHTML editor
* Can be formatted for easier reading
* Well-known
* Insensitive to newlines
* No characters like "|" which can collide with template and parser function syntax
* Can be previewed/debugged with any HTML editor
* Can be formatted for easier reading
* Well-known
* Takes less space than XHTML
* Insensitive to newlines
* No characters like "|" which can collide with template and parser function syntax
* Easy to write
* Easy to read
* Takes little space
Cons
* Tedious
* Takes a lot of space
* Difficult to read quickly
* May not have browser support in future
* Unfamiliar syntax
* Rigid structure
* Cannot be indented
* Text (as in HTML tags) may be easier for some people to read than series of pipes, plus signs, exclamation marks, etc.
* Is nothing more than a shortcut for HTML-style tags. Not easily understood by those unfamiliar with HTML table concepts
* Assigning to a template parameter a value containing "|" requires Template:!
* Sensitive to newlines; since these are automatically stripped from templates and parameters in some cases, special techniques are sometimes needed to avoid this, see Help:Newlines and spaces
XHTML HTML & Wiki-td Wiki-pipe
See also Template talk:For#Tables.
Pipe syntax in terms of the HTML produced
The pipe syntax, developed by Magnus Manske, substitutes pipes (|) for HTML. There is an on-line script which converts html tables to pipe syntax tables.
The pipes must start at the beginning of a new line, except when separating parameters from content or when using || to separate cells on a single line. The parameters are optional.
Tables
A table is defined by {| ''params'' |} which equals Insert non-formatted text here
Rows
|
tags will be generated automatically for the first row. To start a new row, use
|-
which results in
Parameters can be added like this:
|- params
which results in
Note:
*
tags will be automatically opened at the first equivalent
* |
tags will be automatically closed at
and equivalents
Cells
Cells are generated either like this:
|cell1
|cell2
|cell3
or like this:
|cell1||cell2||cell3
which both equal
cell1 | cell2 | cell3 |
so "||" equals "newline" + "|"
Parameters in cells can be used like this:
|params|cell1||params|cell2||params|cell3
which will result in
cell1 |
cell2 |
cell3 |
Headers
Functions the same way as TD, except "!" is used instead of the opening "|". "!!" can be used instead of "||". Parameters still use "|", though! Example:
!params|cell1
Captions
A tag is created by
|+ Caption
which generates
Caption
You can also use parameters:
|+ params|Caption
which will generate
Caption
Displaying the table code which generates a table
The code for a simple wiki markup table inside a Code box can be seen below.
{| border="5" cellspacing="5" cellpadding="2"
| style="text-align: center;" | [[Image:gnome-system.png]]
|-
! Computer
|-
| Processor Speed: 1.8 GHz
|}
Above code produces/displays the table below:
Image:gnome-system.png
Computer
Processor Speed: 1.8 GHz
Below code, generated and displayed the above table's Code box code itself, on the screen and web page, inside a blue colored dashed bordered rectangular box.
{| border="5" cellspacing="5" cellpadding="2"
| style="text-align: center;" | [[Image:gnome-system.png]]
|-
! Computer
|-
| Processor Speed: 1.8 GHz
|}
Note that, HTML tag was used to achieve displaying the above codes and the Code box.
Other alternatives to display table code
In most cases, when a code line is longer than the web browser window's width, then a scrolling bar appears at bottom, to let the viewer slide to the right side (and also left side) to see the rest of the codes, because, the use of tag causes the code line to remain intact, unless an EOL (CR/LF) hidden character is reached in that text line. But having to slide or scroll to the right or left for viewing the full codes is often not comfortable to many readers. To solve such problem, using the , and
HTML tags, are better than using the tag, as those will limit the length of a line of code according the available space in the web browser's window and therefor will not result in the need to move the scroll-bar right (or left) for viewing. By placing the codes inside the ... HTML tags, codes are displayed with a fixed width text/font, (like the tag uses) for easier reading. HTML tag
is used to display (or bring) next line of codes, starting from the next line. HTML tag along with its CSS style properties, is used to create the blue colored dashed bordered rectangular box (Code box) around the codes, (like the HTML
tag, which gets these properties from the main.css stylesheet file).
An example of table code with a long line is:
{| border="5" cellspacing="5" cellpadding="2"
| style="text-align: center;" | [[Image:gnome-system.png]]
|-
! Computer
|-
| style="color: yellow; background-color: green;" | Processor Speed: 1.8 GHz
|}
producing the below table:
Image:gnome-system.png
Computer
Processor Speed: 1.8 GHz
Code box above the table has the auto line wrapping feature enabled. Note the long line (the sixth line from top) inside the codes, which is wrapped inside the Code box. This Code box and the codes, can be displayed by using below codes in the edit box.
{| border="5" cellspacing="5" cellpadding="2"
| style="text-align: center;" | [[Image:gnome-system.png]]
|-
! Computer
|-
| style="color: yellow; background-color: green;" | Processor Speed: 1.8 GHz
|}
See the above codes, note that, ... tags were used to disable wiki markup codes for beginning a table ({|), ending a table (|}), start of an image displaying ([[), or a hyperlink, etc. All wiki & HTML markup codes need to be disabled by enclosing them inside the ... tags. If these codes were to be displayed inside another table, then, each | (pipe) & ! (Exclamation mark) symbol also needed to be enclosed inside the tags. Note that, the longer line is automatically wrapped according to the width of the web browser's window, inside the Code box.
Alternatively, we can replace each | (pipe symbol) character with | (HTML decimal entity code), replace each ! (exclamation mark) with ! code, replace { (beginning curly/second bracket) with { and we may replace } (closing curly/second bracket) with } code. Also replace the < (less than sign, or beginning angle bracket) with < numeric entity code or, replace it with < (HTML symbol entity code). For more on HTML decimal or hexadecimal numeric entity codes, please see w:Windows Alt codes. To display the wiki image markup code, we should replace the [ (beginning square/third bracket) with [ and we may replace ] (closing square/third bracket) with ]. When we are replacing characters with their numeric enitity codes, we are actually disabling their normal functionality, so we can display them on the web page(s).
By using the numeric entity codes, mentioned in the above paragraph, below codes can display the above Code box in another alternative (better) way. Note that, the longer line is automatically wrapped, without exceeding the browser window's width, inside the below Code box.
Image:gnome-system.png
Computer
Processor Speed: 1.8 GHz
{| border="5" cellspacing="5" cellpadding="2"
| style="text-align: center;" | [[Image:gnome-system.png]]
|-
! Computer
|-
| style="color: yellow; background-color: green;" | Processor Speed: <span style="color: red;"> 1.8 GHz </span>
|}
See also disabling wikitext interpretation and/or reformatting.
Square monitors
To format for a square monitor or window, use a tape measure. Determine the height of your rectangular screen. Using that figure measure under the screen to determine the width your monitor’s screen would be if it were square. Mark that location using ink or tape under the screen. Drag the side of your browser’s window to that location so the window is square based on accurate measurements. Square monitors and reading windows are not able to contain tables and galleries made for rectangular and wide screens. When a table or gallery is wider than the monitor, it makes every line of text wider than the screen as well. The px amounts of the following gallery were determined after measuring the window to make sure it was square:
Type this:
{| border="0" style="background:transparent;"
|-
|
[[Image:Some_window_blinds.JPG|192px x 155px|thumb|left|Various window shades]]
||
[[Image:Vert-blinds-2145-rs.jpg|192px x 170px|thumb|left|Vertical blinds]]
||
[[Image:Gardine.jpg|192px x 155px|thumb|left|This is not a blind]]
|}
{| border="0" style="background:transparent;"
|-
|
[[Image:Vorhang.jpg|192px x 155px|thumb|left|Solid shade]]
||
[[Image:Jalousie-1.jpg|328px x 55px|thumb|left|Horizonal blinds]]
|}
{| border="0" style="background:transparent;"
|-
|
[[Image:Some_window_blinds.JPG|225px|thumb|left|Shade, shutters; vertical & horizontal blinds.]]
||
[[Image:Miniblinds detail of mechanism.jpg|418px|thumb|left|Detail of turning rod (blind stick) attachment on miniblinds]]
|}
For this:
http://en.wikipedia.org/wiki/Help:Table
Book by a corporate author
Associations, corporations, agencies, government departments and organizations are considered authors when there is no single author
American Psychological Association. (1972). Ethical standards of psychologists. Washington, DC: American Psychological Association.
http://library.concordia.ca/help/howto/apa.php
This can be accomplished using {{Harv}} and {{Citation}} templates. {{Harv}} is used for the inline citation in the body of the article, for example {{Harv|Ritter|2002}} renders as (Ritter 2002).
{{Citation}} is used in references section at the bottom of the article to format the full citation.
* {{Citation| last=Ritter | first=R. | year=2002 | title=The Oxford Style Manual | publisher=Oxford University Press | isbn=0-19-860564-1 }}
This renders as:
* Ritter, R. (2002), The Oxford Style Manual, Oxford University Press, ISBN 0-19-860564-1
Notice that clicking on the inline citation highlights the full citation.
In articles with mixed citation styles and predominantly using the {{Cite xxx}} family of templates, one can create a {{harv}}-compatible citation using the "ref" parameter which is supported by some of the {{Cite xxx}} family templates, as demonstrated:
* {{cite book| last=Ritter | first=R. | year=2002 | title=The Oxford Style Manual | publisher=Oxford University Press | isbn=0-19-860564-1 | ref=CITEREFRitter2002}}
In general, the rule is simply to concatenate the string "CITEREF", the last name, and the year.
http://en.wikipedia.org/wiki/Wikipedia:Parenthetical_referencing
http://en.wikipedia.org/wiki/Template:Cite_bookhttp://en.wikipedia.org/wiki/Wikipedia:Citation_templates
http://www.ehartwell.com/InfoDabble/Mediawiki_citations,_references,_and_bibliography_management
http://en.wikipedia.org/wiki/Wikipedia:Harvard_citation_template_examples
Our employee_data table now contains enough data for us to work with. Let us see how we can extract (query) it. Querying involves the use of the MySQL SELECT command.
Data is extracted from the table using the SELECT SQL command. Here is the format of a SELECT statement:
SELECT column_names from table_name [WHERE ...conditions];
The conditions part of the statement is optional (we'll go through this later). Basically, you require to know the column names and the table name from which to extract the data.
For example, in order to extract the first and last names of all employees, issue the following command.
SELECT f_name, l_name from employee_data;
The statement tells MySQL to list all the rows from columns f_name and l_name.
-----
In this section of the MySQL tutorial we'll look at the format of a SELECT statement we met in the last session in detail. We will learn how to use the select statement using the WHERE clause.
SELECT column_names from table_name [WHERE ...conditions];
Now, we know that the conditions are optional (we've seen several examples in the last session... and you would have encountered them in the assignments too).
The SELECT statement without conditions lists all the data in the specified columns. The strength of RDBMS lies in letting you retrieve data based on certain specified conditions.
In this session we'll look at the SQL Comparision Operators.
The = and != comparision operators for MySQL Select
SELECT f_name, l_name from employee_data where f_name = 'John';
+--------+------------+
| f_name | l_name |
+--------+------------+
| John | Hagan |
| John | MacFarland |
+--------+------------+
2 rows in set (0.00 sec)
This displays the first and last names of all employees whose first names are John. Note that the word John in the condition is surrounded by single quotes. You can also use double quotes. The quotes are important since MySQL will throw an error if they are missing. Also, MySQL comparisions are case insensitive; which means "john", "John" or even "JoHn" would work!
SELECT f_name,l_name from employee_data where title="Programmer";
+--------+------------+
| f_name | l_name |
+--------+------------+
| Fred | Kruger |
| John | MacFarland |
| Edward | Sakamuro |
| Alok | Nanda |
+--------+------------+
4 rows in set (0.00 sec)
Selects the first and last names of all employees who are programmers.
SELECT f_name, l_name from employee_data where age = 32;
+---------+--------+
| f_name | l_name |
+---------+--------+
| John | Hagan |
| Ganesh | Pillai |
| Alok | Nanda |
| Arthur | Hoopla |
| Kim | Hunter |
| Shahida | Ali |
+---------+--------+
6 rows in set (0.00 sec)
This lists the first and last names of all empoyees 32 years of age. Remember that the column type of age was int, hence it's not necessary to surround 32 with quotes. This is a subtle difference between text and integer column types.
The != means 'not equal to' and is the opposite of the equality operator.
http://www.webdevelopersnotes.com/tutorials/sql/mysql_guide_querying_mysql_tables.php3
1. mysql -h host -u user -p
2. enter password
2.a. Show databases:
SHOW DATABASES;
3. Build a database:
CREATE DATABASE
;
4. Use the Database:
USE ;
SHOW TABLES;
5. Build a table:
CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
6. Load data from a file:
LOAD DATA INFILE 'testOne.csv' INTO TABLE ATCCode FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'(ATCCodes, genericName, tradeName, country);
where testOne.csv is the name of the data file and it must be under /var/lib/mysql/
e.g if the dir called testOne, then /var/lib/mysql/testOne/
ATCCode is the name of the table.
1. Using the LOAD DATA INFILE SQL statement
For security reasons, no one has the mysql FILE priv, which means you cannot "LOAD DATA INFILE". You can, however, use a "LOAD DATA LOCAL INFILE" statement as long as you have a mysql prompt on our system and have uploaded the data file to your account here first.
The "LOAD DATA LOCAL INFILE" statement will only work from a MySQL prompt on our local system. It will not work from any web-based tool such as phpMyAdmin, and will never pull a file in directly off your own computer.
To import a file this way, first upload your data file to your home directory on our system with FTP or SCP. Then get a shell prompt on our system, and then a MySQL Monitor prompt so that you can issue the SQL that will import your file.
For example, suppose you have a data file named importfile.csv that contains 3 comma separated columns of data on each line. You want to import this textfile into your MySQL table named test_table, which has 3 columns that are named field1, field2 and field3.
To import the datafile, first upload it to your home directory, so that the file is now located at /importfile.csv on our local system. Then you type the following SQL at the mysql prompt:
LOAD DATA LOCAL INFILE '/importfile.csv'
INTO TABLE test_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(field1, filed2, field3);
The above SQL statement tells the MySQL server to find your INFILE on the LOCAL filesystem, to read each line of the file as a separate row, to treat any comma character as a column delimiter, and to put it into your MySQL test_table as columns field1, field2, and field3 respectively. Many of the above SQL clauses are optional and you should read the MySQL documentation on the proper use of this statement.
http://www.modwest.com/help/kb6-253.html
Import Unicode CSV files to MySQL
Unicode UTF-8 comma-separated values (CSV) text files, which are exported or generated by such applications as Microsoft Access or Excel, can be imported to MySQL via LOAD DATA INFILE command. CSV data files that are in a Vietnamese legacy encoding should first be converted to Unicode UTF-8, using UnicodeConverter tool, before proceeding with the import.
Make sure that MySQL default charset is utf8. You may need to create the schema (i.e., database structure and tables) before executing the LOAD DATA command. This can be accomplished manually or by MySQL Migration Toolkit to re-create the schema in MySQL database and then use TRUNCATE command to clear the table (delete all rows) before importing. For example:
mysql> TRUNCATE TABLE authors;
or
mysql> DELETE FROM authors;
The import will be executed as follows:
mysql> LOAD DATA LOCAL INFILE 'authors.txt' INTO TABLE authors FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
for a CSV file 'authors.txt' with records having data fields as follows:
"authid","lastname","firstname","address","city","country","phone","email"
1,"Nguyễn","Trần","Lý Thường Kiệt","Sài Gòn","Việt Nam","848-999-9999","nguyentran@yahoo.com"
2,"Lê","Lý","Phố Quang Trung","Hà Nội","Việt Nam","848-888-8888","lely@yahoo.com"
The line terminator '\r\n' is for Windows systems; for Unix/Linux, '\n' is used.
http://vietunicode.sourceforge.net/howto/importcsvmysql.html
hi! im a newbie here.. Just wanna ask how to autorun a program everytime a turn on my pc.. It is a .c file.
Hope someone can help
----
Hi,
You can put the commands to run your program in /etc/init.d/boot.local.
http://www.linuxforums.org/forum/suse-linux-help/113611-how-do-i-auto-run-program-everytime-suse-boots.html
Adding Ads
One commonly requested feature for MediaWiki is how to add ads (from Google etc.) to MediaWiki pages. Before you can do this you will first need to set up an account with whoever you want to provide the adds. They will then give you the HTML code needed to display the adds. The next step is to add the code you got to a file named monobook.php which is kept in the skins directory. Simply look through the file until you find
. Then add the following before that replacing the code in red with the code you got from the ad company. The parts in gray should already be in the file, so you don't need to add them, they are here to show you the context.
Save the file, then when you go to a page on your wiki you should see your ads in the left column under the toolbox.
http://www.wikiknowledge.net/wiki/MediaWiki
1. Click on the domain
2. Apply DNS profile
3. Load
4. Save Setteings
5. Backt to domain details
6. Apply Name Sever Profile
7. View Profile
8. Apply Change
9. Validate Modification
Please go to Manage my domains. Click on the domain name you want to delegate new Nameservers. On the left of the actual nameservers click on Apply Nameserver Profile. Choose the profile to use or Create a new one. Click on View profile and them on Apply profile. Them on the top of the page click on Validate modifications.
http://www.eurodns.com/faq/
1. Create Database as in joomla
2. http://www.example.com/www/phpBB3/install/index.php
------
1. Decompress the phpBB3 archive to a local directory on your system.
2. Upload all the files contained in this archive (retaining the directory structure) to a web accessible directory on your server or hosting account.
3. Change the permissions on config.php to be writable by all (666 or -rw-rw-rw- within your FTP Client)
4. Change the permissions on the following directories to be writable by all (777 or -rwxrwxrwx within your FTP Client): store/, cache/, files/ and images/avatars/upload/.
5. Using your web browser visit the location you placed phpBB3 with the addition of install/index.php or pointing directly to install/, e.g. http://www.mydomain.com/phpBB3/install/, http://www.mydomain.com/forum/install/ etc.
6. Click the INSTALL tab, follow the steps and fill out all the requested information.
7. Change the permissions on config.php to be writable only by yourself (644 or -rw-r--r-- within your FTP Client)
8. phpBB3 should now be available, please MAKE SURE you read at least Section 6 below for important, security related post-installation instructions.
If you experienced problems or do not know how to proceed with any of the steps above please read the rest of this document.
http://www.twilightlexiconforum.com/docs/INSTALL.html#quickinstall
1. Create New Database
name_database: myjoomla
user: user name
password: new password
server: ip address
2. Create Dir joomla15 in
/wwww/
3. FTP Joomla to /joomla15
4. Go to http://www.example.com/wwww/joomla15/
This Url is under Home: e.g.
Temp URL: site1.website.com/user/www
5. Start Install
6. Infromation for Database:
6.1. Database location
under Database
Server IP:
user name:
password
download:
webmin-1.420-1.noarch.rpm
Install.
Login:
http://localhost:10000/
user: root
password
http://webmin.gds.tuwien.ac.at/index.html
find /usr/local/lib -type f -iname "*liblua*"
do an ls -l /usr/lib/*lua*
And find /usr/lib -type f -iname "*liblua*
rpm -ql liblua5_1
http://www.linuxjournal.com/article/9036
http://www.novell.com/documentation/apparmor/pdfdoc/apparmor2_admin/apparmor2_admin.pdf
1. Download phbBB
http://www.phpbb.com/downloads/?sid=d8daf7d9885ef06e9549b46a26a37455
2. untar phpBB-3.0.2.tar.bz2
3. Installation Quick Quide:
http://www.phpbb.com/support/documentation/
http://www.phpbb.com/support/documentation/3.0/
4. Create a database called:
phpbb
5. grant to
give the username and remove the brackets
5.1. GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON phpbb.* TO @localhost IDENTIFIED BY 'user password here';
5.2.FLUSH PRIVILEGES;
6. /localhost/phpBB3/ or /local/phpBB3/install/index.php
7. Website Installation follow the procedure
8. Change the permissions on config.php to be writable by all (666 or -rw-rw-rw- within your FTP Client)
http://www.phpbb.com/support/documents.php?mode=install&version=3#quickinstall
10. To create a forum login in as admin
11. Click Adminstration Control Panel (center below the forum)
II. Adding Ads to phpBB3
http://www.phpbb.com/kb/article/advertisements-in-phpbb3/
III. Stop Spam
Update 2006-08-22: The fake users keep coming. So I came up with a cron job that runs this query once per day. It will remove inactive PHPBB users older than 48 hours. This gives time for the new users to properly activate.
DELETE FROM phpbb_users WHERE user_active=0 AND user_id>0 AND FROM_UNIXTIME(user_regdate)
The user_id>0 part is to avoid deleting the Anonymous user, which has a user ID of -1 on my installation.
http://boonedocks.net/mike/archives/124-PHPBB-Fake-Members.html
IV. Delete User:
open php my admin and you can run this query:
DELETE FROM phpbb_users WHERE user_id !=2
http://www.webmaster-talk.com/php-forum/64968-phpbb-forum-delete-all-users.html
Famous 5-Minute Install
Here's the quick version of the instructions, for those that are already comfortable with performing such installations. More detailed instructions follow.
1. Download and unzip the WordPress package, if you haven't already.
2. Create a database for WordPress on your web server, as well as a MySQL user who has all privileges for accessing and modifying it.
3. Rename the wp-config-sample.php file to wp-config.php.
4. Open wp-config.php in your favorite text editor and fill in your database details.
5. Place the WordPress files in the desired location on your web server:
* If you want to integrate WordPress into the root of your domain localhost/wordpress/
6. Run the WordPress installation script by accessing wp-admin/install.php in your favorite web browser.
http://localhost/wordpress/wp-admin/install.php
should visit: http://example.com/blog/wp-admin/install.php
That's it! WordPress should now be installed.
http://codex.wordpress.org/Installing_WordPress
--------------------------
mysql grant hesham the right to use wordpress
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON wordpress.* TO
@localhost IDENTIFIED BY 'user password here';
remove <>
http://codex.wordpress.org/Installing_WordPress
//restart of apache
/etc/init.d/rcapache2 restart
//apache config file
/etc/apache2/httpd.conf
//virtual host
ServerName marei.homelinux.com
ServerAlias marei.homelinux.com
DocumentRoot /srv/www/htdocs/
ServerName medicine.homelinux.com
DocumentRoot /srv/www/htdocs/phpBB3/
//Dump apache httpd.conf
httpd2 -S
//errors are in
/var/logs/apache2/
//discuss of medaiwiki problem:
http://ubuntuforums.org/showthread.php?t=236212
Where can you find Apache Documents
http://wiki.apache.org/httpd/DistrosDefaultLayout#head-43cd7f416175e1fb932e5bb26ac238f8a9324fed
- Run level and stop mysql
su:
password:
- /usr/bin/mysqld_safe --skip-grant-tables &
in another terminal:
mysql -u root -p
update user set Password=PASSWORD('new-password-here') WHERE User='root';
flush privileges;
exit;
return to first terminal:
fg
ctrl + c or z
/etc/init.d/mysql start
mysql -u root -p
First things first. Log in as root and stop the mysql daemon. Now lets start up the mysql daemon and skip the grant tables which store the passwords.
mysqld_safe --skip-grant-tables
ou should see mysqld start up successfully. If not, well you have bigger issues. Now you should be able to connect to mysql without a password.
mysql --user=root mysql
update user set Password=PASSWORD('new-password');
flush privileges;
exit;
Install Summary:
1. Connect to the sever using FileZilla
1.1. ftp.xxxx.com
1.2. username
1.3. password
2. Create mysql database
2.1. databaseName: medicine
2.2. user:
2.3. password:
2.4. give user all privilage
3. http://wiki.xxxx.li/
3.1. Click Setup
3.2. Fill the page
4. Copy localSetting.php to
public_html/xxx/wiki/medicines/wikimedia/
5. Rename config to config.bak
6. End of installation
---------------------
--
MediaWiki installs itself using an interactive, web-based installation script. Before you can run this script, you need to do a couple of things. First, ensure that you have installed prerequisites (Apache/IIS, MySQL4 or later and PHP5). Then you must acquire the MediaWiki software package and upload the MediaWiki software to your server. You may also have to create a new database for your wiki. If necessary, create an account on your web server by following the instructions at Manual:Installation/Creating system accounts.
MediaWiki can be difficult to install for the average computer user who does not have experience with Apache, PHP and MySQL. Most users who wish to use wiki software may benefit from using a free wiki host (see a list of wiki hosts on Wikibooks).
Note Note: For troubleshooting information, see Manual:Errors and Symptoms#Installation Errors.
Download MediaWiki Software
Download MediaWiki from the official download page or from subversion.
Uncompress the files locally or on your server. This is usually done with software such as 7-Zip (free), WinZip, WinRAR or IZArc (free) on Windows. On Linux and Mac OS X, you can untar the file using this command:
tar xvzf mediawiki-*.tar.gz
If you have not already uploaded the files to your web server, do so now. Upload the files to your web server's web directory either by directly copying the unzipped folder or by using an FTP client such as FileZilla (Open Source Software, Windows) or Cyberduck (OSX). If you installed Apache, the correct directory is specified in your httpd.conf file (its typically
/htdocs). If you are using a Linux or Unix you can instead copy the files to any directory on your server and then make a symbolic link to that folder from your web server's web directory.
Rename the uploaded folder to whatever you would like to have in the URL. If your web server is running as http://localhost for example, uploading MediaWiki to /testwiki/ directory would mean you would access your wiki at http://localhost/testwiki/index.php.
This (renamed) folder will now be referred as .
Prepare the Directories
MediaWiki needs to be able to write to the /config directory when it runs its installation script. If you haven't done so already, you need to change the permission settings for the config subdirectory so that it is writable by the webserver. If you are using FileZilla, right-click on the config directory, select "attributes...", and check "Write" under "Owner". If it prompts you for a number instead or if you are using a command-line interface, use 755 (Use 777 on Linux except for RedHat Linux). Alternately, you may be able to change permissions using a "control panel" provided by your web host.
Depending on the server configuration, in some cases you have to check all boxes (777) in FileZilla, to be able to run the install-script of MediaWiki.
On Unix or Linux, if you have admin rights, you can run the command chmod 755 config in your wiki directory.
Create a database
If you know the root password on your database, the MediaWiki installation script can create a new database for you. If this is the case, you can skip to the Run the installation script section below. If you don't know the root password, for example if you are on a hosted server, you will have to create a new database now. Currently, you must use either MySQL or Postgres to store the actual contents of your wiki.
MySQL
* You need to create a MySQL database and a user before installing MediaWiki. You can do this using various control panels such as PhpMyAdmin, which are often available from shared hosts, or you may be able to use ssh to login to your host and type the commands into a MySQL prompt. See the corresponding documentation. Alternatively, contact your host provider to have them create an account for you
1. Download and install MySQL 5.0. It should put itself in /usr/local/mysql
2. Check and see if the database server is running ("/usr/local/mysql/bin/mysqladmin status"), If not, sudo /usr/local/mysql/bin/safe_mysqld &.
(For Fedora Core 5, use /usr/bin/mysqld_safe)
1. Another way to start initially the MySQL server is to run the configure script available at the root of the installation. It creates the initial tables and automatically starts the mysql daemon
3. Set a password for the "root" account on your database server. /usr/local/mysql/bin/mysqladmin -u root password yourpassword
4. Set up a user in MySQL for your Wiki--do this in your terminal: /usr/local/mysql/bin/mysql -u root -p mysql
5. This starts up the MySQL command line client. Now, do this in the client:
create database wikidb;
grant create, select, insert, update, delete, alter, lock tables on wikidb.* to 'wikiuser'@'localhost' identified by 'password';
flush privileges;
\q
If your database is not running on the same server as your web server, you need to give the appropriate web server hostname -- mediawiki.example.com in my example -- as follows:
grant create, select, insert, update, delete, alter, lock tables on wikidb.* to
'wikiuser'@'mediawiki.example.com' identified by 'password';
http://www.mediawiki.org/wiki/Manual:Installing_MediaWiki
Opening the MediaWiki Installation form
In the following examples, it is assumed that your website is located at http://www.example.com/ which is physically located on your server at /home/example/web. You will need to adjust the examples to use the appropriate locations for your situation.
1. Use your web browser to browse to the main wiki page. This is the web-accessible folder that you installed MediaWiki into, and is typically /wiki (e.g. http://www.example.com/wiki/, assuming you installed MediaWiki to /home/example/web/wiki).
2. You will be presented with a message telling you that your wiki is installed, but has not yet been configured and that you need to "click here to setup the wiki". Click on the link to begin the configuration script. For reference (in case you want to go there directly), this is located in the wiki's config directory (so using the example above you would go to http://www.example.com/wiki/config/).
3. If the script spots any configuration errors then it will not allow you to continue. See below for details about the error messages you might encounter, and what to do if you do.
4. If all the tests pass, you will be presented with a form to fill in the information that MediaWiki now requires.
[edit] Filling up the Form fields
Follow the instructions on the form to fill in the required entries (refer to the following table if you're uncertain what to enter) and after that click on the "Install MediaWiki!" button. The script will now populate the database and write a configuration file.
After the setup script has finished running successfully, a file called LocalSettings.php is created in the "config" directory. This file contains all the information needed by MediaWiki to run. Since it stores the specified database user's password in plain text, it is strongly suggested that you create a wiki specific database account (i.e. not root). (see Database username in the table below)
1. Move this file to the main wiki directory (if you installed MediaWiki to /home/example/web/wiki, move it there).
2. Set stringent permissions on the LocalSettings.php file.
* Set chmod 600 and chown (Owner read and write, no other permissions).
3. Delete the "config" directory.
Once you have done the above, your wiki should be ready to use. Browse to the address you installed it to (in our example http://www.example.com/wiki/ and start editing!
http://www.mediawiki.org/wiki/Manual:Config_script
http://www.mediawiki.org/wiki/Manual:Installing_MediaWiki
Quick installation guide
For experienced users only, here is the quick version of the installation instructions. Most users will want to read the more detailed version, below.
1. Check that your system meets the minimum requirements (web server, PHP5, and either MySQL4 or Postgres 8.0).
2. Download MediaWiki (direct link to latest version) and extract the archive to a web-accessible folder on your server.
3. Point your browser to the config directory.
4. Follow the on-screen instructions to complete the process.
These instructions are deliberately brief. There is a lot that could go wrong, so if in any doubt, you are advised to read the full instructions below!!
[edit] Main installation guide
* Before installation
o Read what MediaWiki is
o Check the MediaWiki feature list
o Installation requirements - Check these before going any further!
* Installing MediaWiki
o Downloading MediaWiki
o Installing MediaWiki
* Configuring MediaWiki:
o Initial configuration (using the configuration script)
o Further configuration
o Common customizations
o Installing extensions
[edit]
http://www.mediawiki.org/wiki/Manual:Installation_guide
Joomla needs a database, user and password
You need to create a database. You can do this with PhpMyAdmin or via the command line:
mysqladmin -u root -p create joomla
Where joomla is the name you picked for the mysql database that joomla will use. You can call it anything you want.
mysql -u root -p
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON joomla.* TO 'yourusername'@'localhost' IDENTIFIED BY 'yourpassword';
You do not want to have Joomla use the mysql root user to access the database. The above command creates a mysql user (other than the mysql root user) with some priviledges to use the joomla database. You will need to chose the yourusername and yourpassword. If the command was successful, activate the new permissions:
mysql> FLUSH PRIVILEGES;
Quit the mysql prompt:
mysql> \q
Open history file for MySQL commands and delete the above SQL, since the password is in readable format!
gedit ~/.mysql_history
Reload Apache2
You may need to force-reload apache2 so that it knows to use the php module if you haven't done so since you installed the LAMP stack.
sudo /etc/init.d/apache2 restart
Finish installation
Point your browser to localhost/joomla, and follow the onscreen instructions.
joomla should be installed under /srv/www/htdocs/joomla/
If you have a problem with php, copy and paste the script and insert it in
/srv/www/htdocs/joomla/configuration.php
http://www2.blogger.com/post-create.g?blogID=5032931407220438062
http://linuxindo.web.id/2008/05/06/jooma-tutorial-series-how-to-install-joomla-15/2/
Configuring NVu for XHTML and CSS
Click Tools>preferences then:
* On the General screen there is an option to use "CSS styles instead of HTML elements and attributes". This should be enabled.
* On the Advanced screen you will see 4 radio selection buttons for enabling:
o HTML 4
o XHTML 1
o DTD transitional
o DTD strict
http://www.build-your-website.co.uk/Configure-Web-Page-Editors-XHTML-CSS.htm
Port Forwarding Steps for the SMC Barricade G
1. Log into your router. Usually the URL is http://192.168.2.1/ and the password is what you chose when you first set it up. Consult the manual if you have never set it up before or need to reset the password.
2. Choose "Advanced Setup"
3. Choose "NAT" (Network Address Translation)
4. Choose "Virtual Server"
5. Add an entry with "LAN IP Address" 192.168.2.11, "Protocol Type" TCP&UDP, "LAN Port" 80, "Public Port" 80, and the "Enable" box checked. This assumes you gave your server - that is, the computer that you're forwarding connections to - the static local IP address 192.168.2.11. If you don't understand this, first follow the steps in my article how do I give my computer a static local IP address?
6. Click "Add." Forwarding should begin immediately.
http://www.boutell.com/newfaq/creating/forwardports.html
http://www.new2chat.com/router.html
1. Install http
2. Activate Apache as a service in the runlevel editor
3. Install apache2-mod_perl for Perl
4. To read the manual type:
http://localhost/manual
5. Apache can be configuredunder:
/etc/apache2/httpd.conf
6. Add the Variable
APACHE_CONF_INCLUDE_FILES
then make a file httpd.conf.local
In this way changes to the configuration are retained in the file
/etc/apache2/httpd.conf is overwriten during new installation.
7. Activate Modules under APACHE_MODULES this variable is defined in
/etc/sysconfig/apache2
8. Error log
/var/log/httpd/error.log
Test Apache:
http://localhost/
I got the 403 error.
Then Go To
DocumentRoot at directory:
/srv/www/htdocs
change own of index.html to the user
e.g chown me.users index.html
alt="Monopoly Deluxe" height="160" width="160" />