Sydders01 Posted October 3, 2017 Posted October 3, 2017 Please has anyone set up any facility in their school that will enable students to hook up databases to a web page? Any ideas welcome
Steve21 Posted October 3, 2017 Posted October 3, 2017 (edited) We run a standard SQL server with PHP front-end using IIS and shared folders mapped to a drive for them. Also got FTP on it for Dreamweaver lot to use rather than mapping it. The SQL side is under the understanding that the users are using a shard login and need to create unique databases, and basically if they're prats they will lose it (But this was what was asked by CS so all good, as they're saving copies of all their scripts to create tables etc so if someone did delete it by accident re-run script and it's back ). You could go to the extent of setting up individual tables etc assigned to users with permissions and whatnot. If your machines run decently enough locally could always just setup a VM too depends how complex you want it and for how many Steve Edited October 3, 2017 by Steve21
dhicks Posted October 3, 2017 Posted October 3, 2017 Please has anyone set up any facility in their school that will enable students to hook up databases to a web page? Depends on what, exactly, the students are trying to do, but using SQLite along with whatever language they're using to create the web page might be an option. There's no database server to install, the datastore is simply a file, so each student's data can be separate.
mavhc Posted October 3, 2017 Posted October 3, 2017 Could just use html5 storage and something like https://github.com/google/lovefield/blob/master/demos/todo/README.md
vizubeat Posted October 3, 2017 Posted October 3, 2017 I installed Easy Hosting Control Panel | for Ubuntu and alikes...- Free Fast Opensource web hosting control panel for your server ** for use by students, set up an FTP account and a MySQL database, they get free reign of their own space. It comes with phpmyadmin, works with Dreamweaver or FileZilla (it's FTP!) and behaves kind of like a proper web hosting/reseller account.
mavhc Posted October 3, 2017 Posted October 3, 2017 Bit weird that we're still using ftp and not git, how far behind 3 years ago are curricula?
Sydders01 Posted October 3, 2017 Author Posted October 3, 2017 I installed Easy Hosting Control Panel | for Ubuntu and alikes...- Free Fast Opensource web hosting control panel for your server ** for use by students, set up an FTP account and a MySQL database, they get free reign of their own space. It comes with phpmyadmin, works with Dreamweaver or FileZilla (it's FTP!) and behaves kind of like a proper web hosting/reseller account. Thanks,Please guide on how do it.The web link didn't say much
Bob_the_Goon Posted October 3, 2017 Posted October 3, 2017 I'm looking at these options too. Had a rake around Edugeeks and multiple people are mentioning cPanel. Apparently it is free for schools to use. I can't find anything on their website to sign a school up though. I can only find the paid for options.
vizubeat Posted October 3, 2017 Posted October 3, 2017 Thanks,Please guide on how do it.The web link didn't say much What? Not everything is 'download and run this MSI'. Have a look at the Download page on the site, it includes instructions there.
vizubeat Posted October 3, 2017 Posted October 3, 2017 Surely FTP is a much more sensible starting point? Helps students to understand what's happening on the server, that everything's a file, that kind of thing. And, forgive my ignorance, but wouldn't everyone need CLI access to a server to start pushing/pulling repos?
mavhc Posted October 3, 2017 Posted October 3, 2017 Surely FTP is a much more sensible starting point? Helps students to understand what's happening on the server, that everything's a file, that kind of thing. And, forgive my ignorance, but wouldn't everyone need CLI access to a server to start pushing/pulling repos? Well, that's the first problem, everything isn't a file. Websites built by creating a file for each url are a thing of the past. Fine to start off with a few local html files, don't even need a server for that, but when coding server side stuff students should be adding html to code, not code to html. Eg writing a router https://developer.mozilla.org/en-US/docs/Learn/Server-side/Express_Nodejs/routes https://roots.io/routing-wp-requests/ meanwhile I found https://github.com/education/classroom You would need cli access, or someone would need to set it up, could be scripted I guess. However that doesn't really seem to be a problem, just install your server, then join it to AD and tell it to auth via AD https://help.ubuntu.com/community/ActiveDirectoryWinbindHowto 1
Marci Posted October 3, 2017 Posted October 3, 2017 I'm looking at these options too. Had a rake around Edugeeks and multiple people are mentioning cPanel. Apparently it is free for schools to use. I can't find anything on their website to sign a school up though. I can only find the paid for options. Email [email protected]
Sydders01 Posted October 3, 2017 Author Posted October 3, 2017 I have done this,How do you get the student to connect to the server? I installed Easy Hosting Control Panel | for Ubuntu and alikes...- Free Fast Opensource web hosting control panel for your server ** for use by students, set up an FTP account and a MySQL database, they get free reign of their own space. It comes with phpmyadmin, works with Dreamweaver or FileZilla (it's FTP!) and behaves kind of like a proper web hosting/reseller account.
mavhc Posted October 3, 2017 Posted October 3, 2017 I have done this,How do you get the student to connect to the server? Connect to myphpadmin? web browser Connect to the database? however you do that to any database Authenticate? Whatever username/password system you set up
Sydders01 Posted October 4, 2017 Author Posted October 4, 2017 (edited) Thanks, I created users on the EHCP panel under 'add msql database&users'. what address should i give the user to get him to the logo page? if i give the user the ip address of the ubuntu server it defaults to the ehcp page. Please help! I get this error when adding a user "Warning : Your dns/server ip seems your local/private ip (ip address). in order your server be accessible from outside, you should set it to your outside/real ip (your modem/router's ip)" Connect to myphpadmin? web browser Connect to the database? however you do that to any database Authenticate? Whatever username/password system you set up Edited October 4, 2017 by Sydders01
mavhc Posted October 4, 2017 Posted October 4, 2017 Thanks, I created users on the EHCP panel under 'add msql database&users'. what address should i give the user to get him to the logo page? if i give the user the ip address of the ubuntu server it defaults to the ehcp page. Please help! I get this error when adding a user "Warning : Your dns/server ip seems your local/private ip (ip address). in order your server be accessible from outside, you should set it to your outside/real ip (your modem/router's ip)" Don't worry about the ip address, as it's only for internal use, you're not actually hosting websites for the public. What happens if you go to http://1.2.3.4/phpmyadmin ?
Sydders01 Posted October 4, 2017 Author Posted October 4, 2017 Thanks ,how do I connect dreamweaver to it?Don't worry about the ip address, as it's only for internal use, you're not actually hosting websites for the public. What happens if you go to http://1.2.3.4/phpmyadmin ?
Steve21 Posted October 4, 2017 Posted October 4, 2017 (edited) I'd really suggest considering taking a step back here. What is it you've actually been asked to do? If all it is is a database linked to a website, and (pardon the phrase) it seems like you haven't ever done this or software linked to it before, Do you need to setup this much for it? Can they just use an access database locally etc? If you're going to be using webservers and software server side for all the config/management you're going to have to know how to run it, and seems like everything we suggest (including the PMs asking for more info) are constantly asking for step by step guides etc. What language/code are they going to be using? What requirements do they need to do to a database? If you're using Dreamweaver are you using FTP etc now? If it's SQL will it be PHP? It'd help if you let us know the details of what's been asked, and what you know well in terms of software etc to link the easiest way together with the two Steve Edited October 4, 2017 by Steve21
Sydders01 Posted October 4, 2017 Author Posted October 4, 2017 I have done my bit. The ubuntu server is up and running. EHCP installed and I can create users. The users are able to log on using their own logins. I have being asked to do a demo The demo is create a dummy account in phpmyadmin in EHCP,login with it,create a table,create my website using Dreamweaver then connect it to the database. any Ideas? I'd really suggest considering taking a step back here. What is it you've actually been asked to do? If all it is is a database linked to a website, and (pardon the phrase) it seems like you haven't ever done this or software linked to it before, Do you need to setup this much for it? Can they just use an access database locally etc? If you're going to be using webservers and software server side for all the config/management you're going to have to know how to run it, and seems like everything we suggest (including the PMs asking for more info) are constantly asking for step by step guides etc. What language/code are they going to be using? What requirements do they need to do to a database? If you're using Dreamweaver are you using FTP etc now? If it's SQL will it be PHP? It'd help if you let us know the details of what's been asked, and what you know well in terms of software etc to link the easiest way together with the two Steve
mavhc Posted October 4, 2017 Posted October 4, 2017 You need to ask the teacher how they're teaching it. Get the example code from them, no point you finding out one way to do it that they're not using.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now