Tutorial: Part 2: Setting up a Test Website
by Eugene Ruthven, 20110427
This is to be done after Part 1: Turn a GeekBox into a Web Development Box. This was about turning an Ubuntu Desktop computer into a box on which web development can take place.
1.Click Places
2.Click Home Folder
3.Double-click Public folder
4.Click File
5.Click Create Folder
6.Change untitled folder → aatest
7.Double-click aatest
8.Click File
9.Click Create Folder
10.Change untitled folder → logs
11.Click Applications
12.Click Accessories
13.Click Terminal
14.Type sudo nautilus and hit Return – type your password when asked
15.Go to File System → etc → apache2 → sites-available
16.Right-click default
17.Click Open with gedit
18.Highlight <VirtualHost *:80>....</VirtualHost>
19.Ctrl+C
20.Hit Down-arrow
21.Hit Return twice
22.Ctrl+V (pasting text)
23.Remove all lines except:
i) ServerAdmin
ii) DocumentRoot
iii) ErrorLog
iv) CustomLog
24.Change DocumentRoot /var/www to DocumentRoot /home/fgtuser/Public/aatest
25.Change ErrorLog /var/log/apache2/error.log to ErrorLog /home/fgtuser/Public/aatest/logs/aatesterror.log
26.Change CustomLog /var/log/apache2/access.log combined to ErrorLog /home/fgtuser/Public/aatest/logs/aatestaccess.log combined
27.Add the line: ServerName aatest
28.Save file
29.In gedit, open /etc/hosts
30.Add line: 127.0.0.1 aatest below the other lines
31.Save hosts file
32.Click Applications
33.Click Programming
34.Click Bluefish Editor
35.Close Bluefish tip
36.Type this is the aatest website
37.Save as index.html in fgtuser/Public/aatest
38.In Terminal type: sudo /etc/init.d/apache2 restart and hit Return
39.Go to FireFox, and in a new tab type aatest and hit Return
40.You should see: this is the aatest website This means your test website is available to have html pages for a website installed or created.
41.Back to Bluefish
42.Start a new document
43.Type: <?php phpinfo(); ?>
44.Save as aainfo.php in /fgtuser/Public/aatest folder
45.In FireFox, type aatest/aainfo.php and hit Return
46.You should see a page with PHP Version...ubuntu.. at the top of it – this means php scripting works – you can create php files in aatest and do serverside scripting
47.In FireFox, type localhost/phpmyadmin
48.For Username type root, For Password type your password and click Go
49.In box under Create new database, type aatest and click Create button to its right
50.In box under Create new table on database aatest , type test and in Number of fields type 2 and click Go at the right side
51.In box to right of Field type testid and check AUTO_INCREMENT
52.In second box beside Field type testname, in Type dropdown box pick VARCHAR, in box under VARCHAR and for Length/Values type 20
53.Click Save
54.You should see a message Table 'aatest'.'test' has been created.
55.Click Insert at top
56.In box to right of testname type Bill
57.In second box to right of testname type Susan
58.Click Go below and at end of either name
59.You should see a message about 2 row(s) inserted
60.Click Browse
61.You should see 2 rows:
testid testname
1 Bill
2 Susan
62.Click Insert again
63.Again, for testname, in the top box type Elizabeth and in the bottom box type Henry
64.Click Go below and at end of either name
65.Again, you should see a message about 2 row(s) inserted
66.Click Browse again
67.Again, you will see a list of names – this time 4 rows:
testid testname
1 Bill
2 Susan
3 Elizabeth
4 Henry
68.Go back to Bluefish
69.Start a new document
70.Type the following:
<?php
$mysqli = new mysqli('localhost','root','password','aatest');
if ($result = $mysqli->query("SELECT testid, testname FROM test")) {
echo '<p>there are '.$result->num_rows.' rows/names.</p>';
while ($row = $result->fetch_object()) {
echo 'testid: '.$row->testid.', testname: '.$row->testname.'<br />';
}
} else {
// Notice below that the errors are still contained within the mysqli class. This means
//that each result will affect a single "error" property. In otherwords, if your result fails,
//the error returned from MySQL is assigned to the property "error".
// This means the query failed
echo $mysqli->error;
} // end else
$mysqli->close();
?>
71.Save as aadb.php in /home/fgtuser/Public/aatest
72.Go to FireFox and type aatest/aadb.php and hit Return
73.You should see a list of names from the table you had created. This means that you can create php pages that can read info from and insert info into a database.
74.Done
