[Year 12 Its] PHP/MySQL learning environment

Tue Dec 20 16:14:46 EST 2005

Thanks for that John.  I am thinking at this stage of using LiveLamp as 
the server.  I have set up a machine last night and am having some 
success.  I have been very pleased with the support from the developers 
and usergroup.  I like the idea of it being able to so easily be set it 
up and a couple of the basic management tools seem very useful to allow 
us to start fresh in a new semester and so on.  Very low cost solution.

Thanks for sharing the presentation. 

I am hoping to ultimately host my course on a Moodle site.  Do I have 
permission to use/adapt these materials for that please?

Cheers
Peter

John de Figueiredo wrote:

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

-- 
If computers get too powerful, we can organize them into a committee -- that will do them in.

Peter Ruwoldt
ICT Coordinator
Grant High School
Hosking Avenue
MOUNT GAMBIER  SA  5290

P. 08 87263107 (Do not leave voice mail)
F. 08 87250173

ruwoldtp at granths.sa.edu.au
http://waraku.blogspot.com/