Damien,
We have been using xammp lite since 2007. Apache web server - PHP and PERL built in plus a MYSQL server. It works a treat, but is difficult (for students) to transfer to a live web page e.g. MIS. When you give a user DB privaleges in MIS you will get $con to copy and paste. You will also get listed separately the username, password and server name so you can break down mysql_connect() for the students. You should print the information on student's db page immediately and twice. One for you and one for them. Finding the information after the db has been created in a pain. I have used MIS last year for students' Major Projects and will not this year! PHP pages hosted in MIS do not return an error messages for Parse errors, unexpected T_echo errors and numerous other error categories. In MIS when a syntax error occurs the page is blank. When using Xampp this only occurs when the PHP works but there is an error in the SQL being passed to the SQL server. PHP code is already pretty hard to debug (without CS5) this makes it close to impossible for students to find syntax errors in code. Hope this helps Ross Jardine (SRPC IPT) ########################### A/Deputy Principal Toolooa SHS <http://www.toolooashs.eq.edu.au/> http://www.toolooashs.eq.edu.au ( 49714355 7 49714300 PO BOX 8109 GLADSTONE Q 4680 This message (including attachments) is intended for the addressee named above. It may also be confidential,privileged and/or subject to copyright. If you wish to forward this message to others, you must first obtainthe permission of the author. If you are not the addressee named above, you must not disseminate, copy,communicate or otherwise use or take any action in reliance on this message. You understand that any privilegeor confidentiality attached to this message is not waived, lost or destroyed because you have received thismessage in error. If you have received this message in error please notify the sender and delete from anycomputer. Unless explicitly attributed, the opinions expressed in this message do not necessarily representthe official position or opinions of the State of Queensland or the Queensland Department of Education.Whilst all care has been taken, the Department of Education disclaims all liability for loss or damage to person or property arising from this message being infected by computer virus or other contamination. From: [email protected] [mailto:[email protected]] On Behalf Of Peter Cruickshank Sent: Friday, 4 March 2011 5:04 PM To: QSITE ICT Teachers Cc: REYNOLDS Damien Subject: Re: [qsiteict] SQL & MIS Damien, By default, students do not have a database allocated to them in MIS. Your MIS administrator is the only person who can create these databases from somewhere in MIS - it's been a long time (& I've since given up on using MIS for hosting web pages) . We had a large number of the databases not working after the MIS administrator created the accounts, so we had to forward the account details to the help desk and they set up all the databases that didn't work. I have just finished a 2 day course with Richard Kelly and Paul Herring, and we ran xampp very successfully from memory sticks. Xampp runs a database and web server from their memory stick and hosts it through localhost. This is how I will approach it next time I teach it, cos the kids can take the memory stick home and still access a web/database server. Cheers & Beers Cruickers. On 4/03/2011 8:59 AM, REYNOLDS Damien wrote: I am trying to figure out connection details to connect student personal web pages, on our school website, to their SQL Databases - The connection details I need are : DB_USER DB_PASSWORD DB_HOST Also when I manage db this mis I have no creation rights if anyone out there has done this some help would be greatly appreciated thanks in advance Damien Reynolds I.T Teacher | Accredited Facilitator - SCPDF | Iconnect Moderator eLearn Mentor - Kepnock SHS | NCR Accredited Facilitator ------------------------ Phone: 41311888 Fax: 41311800 This message (including attachments) is intended for the addressee named above. It may also be confidential,privileged and/or subject to copyright. If you wish to forward this message to others, you must first obtain the permission of the author. If you are not the addressee named above, you must not disseminate, copy,communicate or otherwise use or take any action in reliance on this message. You understand that any privilegeor confidentiality attached to this message is not waived, lost or destroyed because you have received thismessage in error. If you have received this message in error please notify the sender and delete from anycomputer. Unless explicitly attributed, the opinions expressed in this message do not necessarily representthe official position or opinions of the State of Queensland or the Queensland Department of Education.Whilst all care has been taken, the Department of Education disclaims all liability for loss or damage to person or property arising from this message being infected by computer virus or other contamination. --- You are currently subscribed to qsiteict as: [email protected]. To unsubscribe click here: http://lyris.edna.edu.au/u?id=771475.81b41f3ae311137baafde102b3fdc1e0 <http://lyris.edna.edu.au/u?id=771475.81b41f3ae311137baafde102b3fdc1e0&n=T&l =qsiteict&o=1843446> &n=T&l=qsiteict&o=1843446 (It may be necessary to cut and paste the above URL if the line is broken) or send a blank email to leave-1843446-771475.81b41f3ae311137baafde102b3fdc...@edna.edu.au --- You are currently subscribed to qsiteict as: [email protected]. To unsubscribe click here: http://lyris.edna.edu.au/u?id=705704.eb4eafa03d4ac080a56ae0b874cf1739 <http://lyris.edna.edu.au/u?id=705704.eb4eafa03d4ac080a56ae0b874cf1739&n=T&l =qsiteict&o=1843884> &n=T&l=qsiteict&o=1843884 (It may be necessary to cut and paste the above URL if the line is broken) or send a blank email to leave-1843884-705704.eb4eafa03d4ac080a56ae0b874cf1...@edna.edu.au --- You are currently subscribed to qsiteict as: [email protected]. To unsubscribe click here: http://lyris.edna.edu.au/u?id=705742.d42ea647e85be3beb25392eea1a77f09&n=T&l=qsiteict&o=1845132 or send a blank email to leave-1845132-705742.d42ea647e85be3beb25392eea1a77...@edna.edu.au
<<image001.jpg>>
<<image002.gif>>
