<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1476" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Hi Peter</DIV>
<DIV> </DIV>
<DIV>Yes, feel free to modify and use my material as you please (for educational purposes).</DIV>
<DIV>There is a note to that effect in the Speakers Notes area for Slide 1.</DIV>
<DIV> </DIV>
<DIV>Regards - John<BR><BR>>>> pruwoldt@bigpond.net.au 20/12/2005 4:14:46 pm >>><BR></DIV>
<DIV style="COLOR: #000000">Thanks for that John. I am thinking at this stage of using LiveLamp as <BR>the server. I have set up a machine last night and am having some <BR>success. I have been very pleased with the support from the developers <BR>and usergroup. I like the idea of it being able to so easily be set it <BR>up and a couple of the basic management tools seem very useful to allow <BR>us to start fresh in a new semester and so on. Very low cost solution.<BR><BR>Thanks for sharing the presentation. <BR><BR>I am hoping to ultimately host my course on a Moodle site. Do I have <BR>permission to use/adapt these materials for that please?<BR><BR>Cheers<BR>Peter<BR><BR><BR><BR><BR>John de Figueiredo wrote:<BR><BR>> Hi Peter<BR>> <BR>> Here at Holmesglen we use a product called "Uniform Server" which is a <BR>> WAMP (Windows, Apache, MySQL, php) distribution, like XAMPP (I used <BR>> XAMPP the first time I ran my Web Programming night class). It's free.<BR>> Go to <A href="http://www.uniformserver.com/">http://www.uniformserver.com/</A> and download UniServer3_2a.exe <BR>> (4.5 meg)<BR>> Running this exe file installs the AMP components wherever you tell it <BR>> (without touching the Windows registry).<BR>> We use the Novell Application Launcher and the "techie" in charge has <BR>> set it up to install on the students' S: drives.<BR>> When it is set up (in a folder called UniServer3_2a) it creates a file <BR>> called start.bat which uses the good old DOS subst command to "map" W: <BR>> drive so that the "Local Root Folder" is accessed as w:\www (like <BR>> XAMPP's htdocs folder).<BR>> It has one minor annoyance - when first started up it tries to find <BR>> the localhost too quickly and you get a "Page not found" time message <BR>> - very disconcerting - but wait 10 seconds and click Refresh and all <BR>> is well. The aforementioned "techie" solved this problem by putting <BR>> in a Web page that says - wait
20 sec then click here - so that <BR>> whatever needs to start up has a chance before the Uniform Server Main <BR>> Page is displayed.<BR>> (The distribution includes PhpMyAdmin.)<BR>> <BR>> I have been promising for a while that I would share my course. <BR>> Attached is the PowerPoint presentation I use.<BR>> It is in need of updating - a job I keep planning to do - but other <BR>> things always get in the way.<BR>> Please note: much of the material and almost all the php code samples <BR>> are in the "Speaker's Notes" area. You should view/print the course in <BR>> Notes Page view.<BR>> <BR>> I hope this helps - let me know if I can assist further.<BR>> <BR>> Best Regards (and condiments of the Season) - John<BR>> <BR>> &&&&&&&&&&&&&&&&&&&&&&&&&&&&<BR>> John de Figueiredo - 9209 5855<BR>> Staff Computer Applications Trainer<BR>> Holmesglen Institute of TAFE VC PA<BR>> johnde@holmesglen.vic.edu.au <<A href="mailto:johnde@holmesglen.vic.edu.au">mailto:johnde@holmesglen.vic.edu.au</A>><BR>> <A href="http://www.att.holmesglen.vic.edu.au">www.att.holmesglen.vic.edu.au</A> <<A href="http://www.att.holmesglen.vic.edu.au">http://www.att.holmesglen.vic.edu.au</A>><BR>><BR>> >>> pruwoldt@bigpond.net.au 19/12/2005 4:28:03 pm >>><BR>> Thanks for that Maggie<BR>> I was hoping to avoid the ftp part of this, at least during the<BR>> development stages for students. My hope was for students to be able to<BR>> save their work over the network to their space on the server and then<BR>> test their work from a browser.<BR>> Peter<BR>><BR>> iaquinto@ozemail.com.au wrote:<BR>><BR>> > Try also <A href="http://www.openlab.net.au">www.openlab.net.au</A> <<A href="http://www.openlab.net.au">http://www.openlab.net.au</A>> for an <BR>> account there. Rola
nd Gesthuizen is<BR>> > your<BR>> > contact for help with this. As part of the VITTA subscription for our<BR>> > school,<BR>> > we also purchased virtual server space on Openlab. You, as the<BR>> > administrator,<BR>> > can make accounts for your students. They can then ftp their files to<BR>> > their<BR>> > account at Openlab and view the html/php forms.<BR>> ><BR>> > Maggie<BR>> ><BR>> > Quoting "Peter Ruwoldt (wrk)" <pruwoldt@bigpond.net.au>:<BR>> ><BR>> >> I have started my learning of PH! P/MySQL and very happy with the<BR>> >> progress to date.<BR>> >><BR>> >> *What I have done.*<BR>> >> I have downloaded and installed xampp<BR>> >> <<A href="http://www.apachefriends.org/en/xampp-windows.html">http://www.apachefriends.org/en/xampp-windows.html</A>> . Setup and<BR>> >> configuration was a snap except that the Apache server would not<BR>> >> start until I changed the port that Skype was using from port 80.<BR>> >> Since I modified the MySQL login credentials the samples (eg CD's)<BR>> >> did not work until I modified the relevant PHP files using a text<BR>> >> editor.<BR>> >><BR>> >> Next was to download and install the freeware tool PHP Designer 2005<BR>> >> <<A href="http://www.apachefriends.org/en/xampp-windows.html">http://www.apachefriends.org/en/xampp-windows.html</A>> . A couple of<BR>> >> configuration settings were needed to let PHP Designer know where the<BR>> >> PHP i! nterpreter was located as well as the PHP ini file. I am also<BR>> > > saving the php experiments into \xampp\xampp\htdocs where the php<BR>> >> files that come with xampp are located. This means that my browser<BR>> >> can also use these files using the address<BR>> >> <A href="http://localhost/xampp/filename.php">http://localhost/xampp/filename.php</A><BR>>
>><BR>> >> Finally a great set of tutorials at<BR>> >> <A href="http://www.tizag.com/mysqlTutorial/mysqlinsert.php">http://www.tizag.com/mysqlTutorial/mysqlinsert.php</A> that covers mySQL,<BR>> >> PHP, HTML and CSS.<BR>> >><BR>> >> I have created a sample database using PHPmyadmin that comes with<BR>> >> xampp. I created two tables that could be linked. Then I followed the<BR>> >> mySQL tutorial from<BR>> >> <A href="http://www.tizag.com/mysqlTutorial/mysqlinsert.php">http://www.tizag.com/mysqlTutorial/mysqlinsert.php</A> but modifying it<BR>> >> on the fly to suit the database that I created. This modifying on the<BR>> >! > fly has been good as I know that I have understood.<BR>> >><BR>> >> I have successfully created a html form and used the data input into<BR>> >> this form to update a MySQL table. Fantastic. I have enough to<BR>> >> continue building my knowledge and feel comfortable with this<BR>> >> development environment. I am not sure that it is the best<BR>> >> environment for school and this relates to my next question. Before I<BR>> >> go too much further I need to work out how do I implement this<BR>> >> learning in a school.<BR>> >><BR>> >> *What I need is some advice about how to create a PHP/MySQL work<BR>> >> environment at school*. Some of the issues are<BR>> >><BR>> >> * Students should not store there work on a PC. PC's can be<BR>> >> re-imaged without notice. We can not assume that students will<BR>> >> work on the same PC each time either. They will need to be able to<BR>> >> continue with their wo! rk at other locations in the school and<BR>> >> hopefully at home.<BR>> >> * I would be happy with students doing their development on an<BR>> >> external server so that it can be accessed from school and home.<BR>> >> How
ever, working on a server adds complexity as code has to be<BR>> >> written, uploaded to the server and then executed by checking with<BR>> >> a browser. They do not get the benefit of using tools like PHP<BR>> >> Designer 2005.<BR>> >> * How do you easily have a server set up so that 20 students can<BR>> >> each have their space for testing?<BR>> >> * It is easy to backup a database, destroy it and then restore it<BR>> >> using PHPmyadmin. PHP files can be copied to another location for<BR>> >> safe keeping.<BR>> >><BR>> >> Regards<BR>> >> Peter<BR>> >><BR>> >><BR>> >><BR>> >> --<BR>> >> If computers get too powerful, we can organize them into a committee<BR>> >> -- that will do them in.<BR>> >><BR>> >> Peter Ruwoldt<BR>> >> ICT! Coordinator<BR>> >> Grant High School<BR>> >> Hosking Avenue<BR>> >> MOUNT GAMBIER SA 5290<BR>> >><BR>> >> P. 08 87263107 (Do not leave voice mail)<BR>> >> F. 08 87250173<BR>> >><BR>> >> ruwoldtp@granths.sa.edu.au<BR>> >> <A href="http://waraku.blogspot.com/">http://waraku.blogspot.com/</A><BR>> >><BR>> >><BR>> >> _______________________________________________<BR>> >> <A href="http://www.edulists.com.au">http://www.edulists.com.au</A><BR>> >> IT Systems Mailing List kindly supported by<BR>> >> <A href="http://www.vcaa.vic.edu.au">http://www.vcaa.vic.edu.au</A> - Victorian Curriculum and Assessment<BR>> >> Authority and<BR>> >> <A href="http://www.vitta.org.au ">http://www.vitta.org.au </A> <<A href="http://www.vitta.org.au%A0">http://www.vitta.org.au%A0</A>> - VITTA <BR>> Victorian Information Technology<BR>> >> Teachers Association Inc<BR>> >><BR>> ><BR>> ><BR>> ><BR>> > --------------
--------------------------------------------------<BR>> > ! This message was sent using MyMail<BR>> > ___________________________ ____________________<BR>> > <A href="http://www.edulists.com.au">http://www.edulists.com.au</A><BR>> > IT Systems Mailing List kindly supported by<BR>> > <A href="http://www.vcaa.vic.edu.au">http://www.vcaa.vic.edu.au</A> - Victorian Curriculum and Assessment<BR>> > Authority and<BR>> > <A href="http://www.vitta.org.au ">http://www.vitta.org.au </A> <<A href="http://www.vitta.org.au%A0">http://www.vitta.org.au%A0</A>> - VITTA <BR>> Victorian Information Technology<BR>> > Teachers Association Inc<BR>> ><BR>><BR>> -- <BR>> If computers get too powerful, we can organize them into a committee <BR>> -- that will do them in.<BR>><BR>> Peter Ruwoldt<BR>> ICT Coordinator<BR>> Grant High School<BR>> Hosking Avenue<BR>> MOUNT GAMBIER SA 5290<BR>><BR>> P. 08 87263107 (Do not leave voice mail)<BR>> F. 08 87250173<BR>><BR>> ruwoldtp@granths.sa.edu.au<BR>> <A href="http://waraku.blogspot.com/">http://waraku.blogspot.com/</A><BR>><BR>><BR>> _______________________________________________<BR>> <A href="http://www.edulists.com.au">http://www.edulists.com.au</A><BR>> IT Syste! ms Mailing List kindly supported by<BR>> <A href="http://www.vcaa.vic.edu.au">http://www.vcaa.vic.edu.au</A> - Victorian Curriculum and Assessment <BR>> Authority and<BR>> <A href="http://www.vitta.org.au ">http://www.vitta.org.au </A> <<A href="http://www.vitta.org.au%A0">http://www.vitta.org.au%A0</A>> - VITTA <BR>> Victorian Information Technology Teachers Association Inc<BR>> -- <BR>> Message protected by MailGuard: e-mail anti-virus, anti-spam and <BR>> content filtering.<BR>> <A href="http://www.mailguard.com.au">http://www.mailguard.com.au</A><BR>><BR>><BR>><BR>><BR>><BR>> Proud Sponsor and Official Training Provider of
the Melbourne 2006<BR>> Commonwealth Games.<BR>> ______________________________________________________<BR>> This email and any files transmitted with it are confidential and<BR>> intended solely for the use of the individual or entity to whom they<BR>> are addressed. If you have received this email in error please notify<BR>> the email administrator.<BR>><BR>> This footnote also confirms that this email message has been swept by<BR>> MAILsweeper for the presence of computer viruses.<BR>> ______________________________________________________<BR>> _______________________________________________<BR>> <A href="http://www.edulists.com.au">http://www.edulists.com.au</A> <<A href="http://www.edulists.com.au">http://www.edulists.com.au</A>> IT Systems <BR>> Mailing List kindly supported by<BR>> <A href="http://www.vcaa.vic.edu.au">http://www.vcaa.vic.edu.au</A> <<A href="http://www.vcaa.vic.edu.au">http://www.vcaa.vic.edu.au</A>> - Victorian <BR>> Curriculum and Assessment Authority and<BR>> <A href="http://www.vitta.org.au">http://www.vitta.org.au</A> <<A href="http://www.vitta.org.au">http://www.vitta.org.au</A>> - VITTA Victorian <BR>> Information Technology Teachers Association Inc<BR><BR><BR>-- <BR>If computers get too powerful, we can organize them into a committee -- that will do them in.<BR><BR>Peter Ruwoldt<BR>ICT Coordinator<BR>Grant High School<BR>Hosking Avenue<BR>MOUNT GAMBIER SA 5290<BR><BR>P. 08 87263107 (Do not leave voice mail)<BR>F. 08 87250173<BR><BR>ruwoldtp@granths.sa.edu.au<BR><A href="http://waraku.blogspot.com/">http://waraku.blogspot.com/</A><BR><BR><BR>_______________________________________________<BR><A href="http://www.edulists.com.au">http://www.edulists.com.au</A><BR>IT Systems Mailing List kindly supported by<BR><A href="http://www.vcaa.vic.edu.au">http://www.vcaa.vic.edu.au</A> - Victorian Curriculum and Assessment Authority and<BR><A href="http://www.vitta.org.au ">http://www.vitta.org.au </A> -
VITTA Victorian Information Technology Teachers Association Inc<BR>-- <BR>Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.<BR><A href="http://www.mailguard.com.au">http://www.mailguard.com.au</A><BR><BR><BR><BR></DIV></BODY></HTML>