Database Choices

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
tecktalkcm0391
DevNet Resident
Posts: 1030
Joined: Fri May 26, 2006 9:25 am
Location: Florida

Database Choices

Post 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
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Post by Christopher »

I would recommend SQLite. It is well supported by PHP.
(#10850)
mrkite
Forum Contributor
Posts: 104
Joined: Tue Sep 11, 2007 4:19 am

Post 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.
User avatar
tecktalkcm0391
DevNet Resident
Posts: 1030
Joined: Fri May 26, 2006 9:25 am
Location: Florida

Post 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?
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Post by Christopher »

What kind of server is it?
(#10850)
User avatar
tecktalkcm0391
DevNet Resident
Posts: 1030
Joined: Fri May 26, 2006 9:25 am
Location: Florida

Post 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.
User avatar
iknownothing
Forum Contributor
Posts: 337
Joined: Sun Dec 17, 2006 11:53 pm
Location: Sunshine Coast, Australia

Post by iknownothing »

You could always use a CSV or a Plain Text file, if you can't get access to a real database.
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Post 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.
(#10850)
User avatar
tecktalkcm0391
DevNet Resident
Posts: 1030
Joined: Fri May 26, 2006 9:25 am
Location: Florida

Post 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.
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Post by Christopher »

When you find out more about the system, let us know what questions you have.
(#10850)
Post Reply