SQL PHP Help!

El Brenty · Post by **El Brenty** » Tue Oct 12, 2004 5:30 pm

I've just started out on a massive database project - I'm not disclosing any specifics until I have the site up and running. I'm interested to know who has used SQL and PHP for programming. I touched on SQL a little bit at University, but our teacher's English was so bad I hardly understood anything, so I'm learning it again along with PHP and, well, it's fairly straightforward, but Imay be asking too much from it, time will tell (and sudden plethora of "Help with this PHP code please" type posts!

So, what experiences have you folks had with PHP and SQL, and have you got any pointers?

film fanatic · Post by **film fanatic** » Tue Oct 12, 2004 5:35 pm

Ha, sorry I can't help! I know that isn't ANY help at all, but I'd like to say I know what this project is and I'm not telling ANYBODY what it is!

Carnage7p · Post by **Carnage7p** » Tue Oct 12, 2004 8:00 pm

That is like a little kid saying "I've got a secret and I can't tell you"

El Brenty · Post by **El Brenty** » Tue Oct 12, 2004 8:05 pm

LOL! It is secret to! I got php/SQL for dummies, and so far I have a headache!

man, that book is so full of waffle! I can almost summarise each paragraph in a couple of words!

Grant · Post by **Grant** » Tue Oct 12, 2004 10:46 pm

http://uob-community.ballarat.edu.au/units/cp688/

Mt Helen location, then lecture notes and there may be some help there. It covers PHP and MySQL, plus XML, VB.Net etc, even the lab sheets may help

El Brenty · Post by **El Brenty** » Wed Oct 13, 2004 12:15 pm

Grant, you are the man! That's really great!

One thing I have found in the dummies book is that ojects mean the same thing as tables! Why I never understood this when I did software engineering, escapes me! Object Oriented Databases now make complete sense.

You know what, I'm finding this fairly straightforward so far!

Grant · Post by **Grant** » Wed Oct 13, 2004 10:49 pm

go here also

http://lspace.ballarat.edu.au/

username: student1
password: password

gives you access to many more subjects and their resources across the uni

El Brenty · Post by **El Brenty** » Thu Oct 14, 2004 10:16 am

Wow, that's fantabulous!

Grant · Post by **Grant** » Thu Oct 14, 2004 12:18 pm

hey just call me the key master lol. You must share the knowledge

El Brenty · Post by **El Brenty** » Sat Oct 16, 2004 12:07 pm

Just started building the database now - Figuring out what fields I need and their types and sizes. So far so good!

Grant · Post by **Grant** » Sun Oct 17, 2004 3:05 am

make sure their is no data redundancy and all the tables are in 3rd normal form

El Brenty · Post by **El Brenty** » Sun Oct 17, 2004 10:32 pm

I have a kazillion tables!

Grant · Post by **Grant** » Sun Oct 17, 2004 11:24 pm

read previous post lol

El Brenty · Post by **El Brenty** » Sun Oct 17, 2004 11:29 pm

That's what I meant! It's a truly relational database!

Tables everywhere, and all linked together to!

What I'm worried about is how cyclic data is going to affect the database

Grant · Post by **Grant** » Mon Oct 18, 2004 2:09 am

if it is formed right then you have no data problems with referential integrity, just make sure no data is replicated in other tables

El Brenty · Post by **El Brenty** » Mon Oct 18, 2004 9:29 am

I'm doing something like this as an example:

Create a table called Tutor
Tutor ID
Tutor Name
Tutor Birth
Tutor's address (Location)
Tutor's Tutor

Then I have a table called Birth
Tutor ID
Birth Date
Birth Location

Then a table called Location
Location ID
Location Street
Location Town
Location City
Location Country

And finally Tutor's Tutor would contain a different Tutor ID (Cyclic table possible here if a tutor taught their tutor!)

So is that kinda along the right lines here?

I was thinking of adding a table called Event, where you have an Event ID, Date, and detail (Like a birth).

Grant · Post by **Grant** » Mon Oct 18, 2004 10:14 am

when you said heaps of tables i thought you meant HEAPS of tables lol. Yo have to make sure that no tables have a many-to-many relationship. I will send you over an example when i get home lol

El Brenty · Post by **El Brenty** » Tue Nov 30, 2004 10:01 pm

Well I have heaps and heaps of heaps of tables, I was just showing a segment as an example. I have about 4 pages of tables so far!

EDIT: Well, this is going to take a long time to program. In the mean time, I've come up with a couple of other projects to.

Is there a more secure alternative to php with SQL? I have an application that needs good database security.