Help with setting up mySQL and PHP

Ilya020 · 03-16-2003, 10:52 AM

Hi Guys,

Recently my teacher asked me to set up an sql database, but I would have to show him how to use it, because he would have to know how it works after I am gone. He is not as geeky as me, so he hope that I would be able to figure it out and show him how to use it. There are some sql tools for Mac OSX on the mac platform. The php page would be for them to login and enter/update their profile information. I would also need pages to display the results of a request for information from someone viewing a page with info about a specific teacher.
Will someone be able to help me figure this out? My real question is how can I make a PHP page were they login and can edit their profile.

Ilya.

sde · 03-16-2003, 11:01 AM

that's a pretty general question. i assume by how much you are here that you know that many people will help you.

help you learn and understand .. not really code entire scripts for you.

do you know some php? do you know how to connect to a database?

if you answered yes, then just post more specific questions in places where you are getting stuck .. if you answered no to either of those, then you might want to practice php a little more before you make a commitment like that to your teacher.

there are always places like www.hotscripts.com where you can find pre-generated code, but you would still need to customize it to your requirements.

sde · 03-16-2003, 11:02 AM

p.s. read this thread to get an idea of where your question as it is would lead:

how do u create login pages??

Ilya020 · 03-16-2003, 03:32 PM

Thx for the toast...

Yes, I know PHP and I am getting an O'reilly mySQL/mSQL book tonight. So when I have questions...Ill ask them...

Ilya.

Ilya020 · 03-17-2003, 06:38 AM

I also just found out that he would prefer that I use file front. FILE FRONT! What the hell is File Front???? And why the hell doesnt he want me to use MySQL? Ughhhh... </RANT>

Ilya.

jeffro · 03-17-2003, 02:59 PM

This may be a little after the fact but I tried the O'Reilly book on MySQL and mSQL and I took it back the next day. I thought it was the worst book on the subject that I have ever encountered. Usually O'Reilly books are very good, but it didn't seem to be the case this time.

jeffro

sde · 03-17-2003, 03:02 PM

never heard of front

Ilya020 · 03-17-2003, 04:08 PM

Quote:

Originally posted by jeffro
This may be a little after the fact but I tried the O'Reilly book on MySQL and mSQL and I took it back the next day. I thought it was the worst book on the subject that I have ever encountered. Usually O'Reilly books are very good, but it didn't seem to be the case this time.

jeffro

I just got that book.

So far...I dont like it much either.

Ilya.

EDIT: ever try Sams MySQL? Tell us what you tought of it.

DesertWolf · 03-17-2003, 11:49 PM

Not sure what kind of answer you are looking for. You mentioned Mac OSX but do you want to access this mysql data base from a web browser or a Carbon or Cocoa program?
If it is from a browser you have a few choices,running Apache and PHP under OSX, if it is from a Mac Carbon or Cocoa program then you are getting into Mac objective C programming.
I am one of the few Mac OSX geeks around here it seems , so let me know and I will see if I can help you.

Ilya020 · 03-18-2003, 03:16 PM

Quote:

Originally posted by DesertWolf
Not sure what kind of answer you are looking for. You mentioned Mac OSX but do you want to access this mysql data base from a web browser or a Carbon or Cocoa program?
If it is from a browser you have a few choices,running Apache and PHP under OSX, if it is from a Mac Carbon or Cocoa program then you are getting into Mac objective C programming.
I am one of the few Mac OSX geeks around here it seems , so let me know and I will see if I can help you.

Thanks a lot! I probably will need some help with the Mac

Ilya.

sde · 03-18-2003, 10:10 PM

i have a mac too =)

running web services on it is so simple. i also hear that mysql is going to be bundled in the next osX upgrade.

so far i've only used my mac for vide/audio editing, but programming on it would be fun too.

maybe we should setup a carbon / cocoa form? dont' know if there would be a demand for it though.

DesertWolf · 03-19-2003, 05:10 AM

I asked about a Cocoa/Carbon forum and that was pretty much as far as it went. There are not alot of people on Codenewbie that are into Macs, the Mac section of the forum is one of the slowest, but once my internship is finished (about 2 more hours to put in) I plan on getting back to Cocoa. So if anyone is interested, let me know.
Also I had Apache,mySQL and PHP running on my imac untill I upgraded to 10.2 that broke it I will probably work on getting it back up during spring break next week.