Ok dont laugh! :S

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

Moderator: General Moderators

phpnewbie1985
Forum Commoner
Posts: 33
Joined: Thu Jan 08, 2004 6:15 am

Ok dont laugh! :S

Post by phpnewbie1985 »

Im new to PHP, and i have started using and looking at how php works. Now when i look at some tutorials it says u need MySQL installed... ok 1) how do i know if this is installed on my server and 2)if it isnt how can it be done?

I have a few books arriving tommorow to help me along for the meantime, i love php it looks like such a helping hand when all i have been using is HTML and javascript..

Many thanks
Chris
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Post by JayBird »

run this script on your server

Code: Select all

<?
phpinfo();
?>
If there is a MySQL section, then you have it isntalled.

You DO NOT need MySQL to use PHP, it is good if yo do tho

Mark
Nay
Forum Regular
Posts: 951
Joined: Fri Jun 20, 2003 11:03 am
Location: Brisbane, Australia

Post by Nay »

Bech100 wrote: You DO NOT need MySQL to use PHP, it is good if yo do tho
Let's hope you didn't drive him away to MSSQL 8O.

Anyhow, like Mark said, run a phpinfo() then you'll see what you have installed. Find a big bold black centered "MySQL" there ;)

-Nay
phpnewbie1985
Forum Commoner
Posts: 33
Joined: Thu Jan 08, 2004 6:15 am

wow

Post by phpnewbie1985 »

That was quick thanks guys, just did it and it says, MySQL enabled... but no passwords etc.. are set. anyone know any aites that can give me detailed tutorial of using it for first time cos id really like to start using it to log users etc.....

many thanks again.
Chris
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post by Pyrite »

For logging users btw ..

Check out bbclone.tuxfamily.org
phpnewbie1985
Forum Commoner
Posts: 33
Joined: Thu Jan 08, 2004 6:15 am

Post by phpnewbie1985 »

have you got this running? i dont think the instructions given are very detailed.... may ust be me being a muppet

Thanks
Chris
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post by Pyrite »

Do I have bbclone running you mean? Yes, I used it on several sites of mine.
phpnewbie1985
Forum Commoner
Posts: 33
Joined: Thu Jan 08, 2004 6:15 am

Post by phpnewbie1985 »

Ok so i just download it, upload the contents to root directory on server. and then put that bit of code included onto every php page i want to record stats for? and then what do i do to see the stats. sorry if im getting annoying :S

thanks
Chris
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post by Pyrite »

Then Just go to the URL with the bbclone dir. ie. for me it's

http://www.internetseminary.org/bbclone/
phpnewbie1985
Forum Commoner
Posts: 33
Joined: Thu Jan 08, 2004 6:15 am

Post by phpnewbie1985 »

ok *Crosses fingers while uploading.

Thanks for your help :)

Chris
phpnewbie1985
Forum Commoner
Posts: 33
Joined: Thu Jan 08, 2004 6:15 am

Post by phpnewbie1985 »

cool it works! can i make it make stats for my *.html or *.asp pages? or can it just do PHP? and if i can do the other how do i do that?

Thanks! :D
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post by Pyrite »

It's only for PHP. I only use it for log the first page of my sites index.php usually.
phpnewbie1985
Forum Commoner
Posts: 33
Joined: Thu Jan 08, 2004 6:15 am

Post by phpnewbie1985 »

Do search engines like google like spidering PHP pages? as i have hear they dont like them, which is why i stay away from ASP and PHP but PHP is becoming so much more appealing.

Chris
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Post by JayBird »

Search engine spider, see exactly what your browsers see. They can't see your PHP code.

So, it doesn't make and difference as long as there are links to follow.

Mark
phpnewbie1985
Forum Commoner
Posts: 33
Joined: Thu Jan 08, 2004 6:15 am

Post by phpnewbie1985 »

Ah ok super cheers

Everything seems to be clear to me now lol :lol:

Ill just wait for my books to come tommorow and spend a day juciing myself on PHP knowledge and MySQL stuff

Thanks alot for your help people.

Chris
Post Reply