Page 1 of 1

Database Choices

Posted: Thu Sep 13, 2007 2:41 pm
by tecktalkcm0391
I am doing my schools NHS website, and our school is stupid and has no MySQL database, and only gives one person the password (so they only have on website admin... instead of just making a folder base access, so NHS could only get to the NHS folder.. but anyways).

What are my alternatives for MySQL. They suggested using something with Excel using FrontPage (*gag*). [Also, I don't want anyone being able to download the database with personal member information!@#!@#.. duh..]

So... what do you guys think... I wanted to make a user database, as well as databases for storing other information.

Edit: Wrong Forum... should have been in Databases... oops

Posted: Thu Sep 13, 2007 3:44 pm
by Christopher
I would recommend SQLite. It is well supported by PHP.

Posted: Thu Sep 13, 2007 4:13 pm
by mrkite
arborint wrote:I would recommend SQLite. It is well supported by PHP.
Although not by default... you'll need to compile support in.

Posted: Thu Sep 13, 2007 4:31 pm
by tecktalkcm0391
mrkite wrote:
arborint wrote:I would recommend SQLite. It is well supported by PHP.
Although not by default... you'll need to compile support in.
Do you connect to SQLite the same as MySQL? How do I compile support?

Posted: Thu Sep 13, 2007 4:33 pm
by Christopher
What kind of server is it?

Posted: Thu Sep 13, 2007 4:36 pm
by tecktalkcm0391
I have no clue, I have no access to it because the school is stupid. So I don't think SQLite will work, cause I can't get to the command prompt. If it will work, how would I set it up... i'm so confused.

Posted: Thu Sep 13, 2007 7:56 pm
by iknownothing
You could always use a CSV or a Plain Text file, if you can't get access to a real database.

Posted: Thu Sep 13, 2007 9:20 pm
by Christopher
tecktalkcm0391 wrote:I have no clue, I have no access to it because the school is stupid. So I don't think SQLite will work, cause I can't get to the command prompt. If it will work, how would I set it up... i'm so confused.
Have you written a page like the following to tell you what is installed for PHP. If SQLite is installed and you have even FTP access to a directory then you can use it.

Code: Select all

<?php
phpinfo();
Your school is not stupid ... is sounds like the have some reasonable security policies. There are many ways to do what you want to do. Even text files as suggested above could be made to work. You could store the data in an array and serialize it, then write it to a file. Stop blaming and get creative.

Posted: Fri Sep 14, 2007 10:35 pm
by tecktalkcm0391
Ok, thanks for the help. I'll see what I can do. Sorry about the blaming, I was just frustrated because at my middle school they just gave me the password, because they know me, and they know me very well at my high school.

Posted: Sat Sep 15, 2007 12:05 am
by Christopher
When you find out more about the system, let us know what questions you have.