I can help.. hopefully

Order · 10-18-2003

I am only a novice graphic designer.. but I have expirence in PHP/MySQL. About 3 and a half years, any questions and I can help you out.. not a problem at all..

**Man1c M0g** · 10-18-2003

'To use pconnect, or not to use pconnect - that is the question....'

Well, Shakespearisms aside, I honestly wonder if you'd enlighten me as to which would be the best for Biorust. At the moment I use persistant connections, but i've heard that it may not be ideal for modem users. Are these rumours true, or is it that pconnects merely use up more resources (which this server has in abundance anyway)???

Order · 10-18-2003

ahh.. pconnect.. i can see the problem..

to be honest, i dont think there is much use for pconnect unless the site is constantly getting stuff from mysql. all persistant connections allow is for php to keep the connection throughout several pages, so one does not have to constantly connect and not connect. I have not heard that it is no good for modem users..

I just mearly use the normal usages with connect.. but I see no difference except one stays open and the other does not..

**Man1c M0g** · 10-18-2003

Hmmmmm - that makes sense that does! I think i'll leave it on for the forums (it is, after all, a PHP/MySQL based system), but try turning it off for the biorust portfolio and tutorials system. I can always turn it back on if things start bursting into flames.

Thanks Digital!

Order · 10-18-2003

not a prob, that is why I am here..!!

After consulting the infamous php manual (the great thing it is), I have found the differences, and here they are:

mysql_connect():
Opens a new connectiont to the MySQL Server, and it is used, when the script stops, or a mysql_close() is used, the connection is closed. Uses smaller amount of resources as compared to the persistant connections. Using this is often better then using mysql_pconnect() (90% of the time, this works better).

mysql_pconnect():
This tries to open a connection to the MySQL Server, but instead of closing on the scripts ending, or by mysql_close(), it stays open. There are a quite many problems with this as it takes more resources to run the connection, and is only recommended to people who wish to use it. It is recommended to use mysql_connect() instead.

Hope that clears things up a little more.. if not refer to the all mighty php manual @ http://www.php.net/manual

**Man1c M0g** · 10-18-2003

EEEEEEEP - thats a super scary manual you have there Digital - I should start prescribing it for insomnia. =). It seems there's a lot to read and learn about linux. I was given a huwge book on the subject yesterday for my birthday, and I can guarantee its probably all already out of date anyway. Crazy stuff.

Anyway, those explanations do make lots of sense. Lets see if they work in practice....

Order · 10-18-2003

It does keep me awake. I use Windows, but I do some about Linux (having been stupid enough to actually use it once)..

ConceptualMind · 10-24-2003

Man1c, I'm on dial up and I see no problems. It loads fairly fast.

I say stick with what your doing now.

Evdawg · 11-19-2003

Ok digital, or anyone else, pretty simple question:

Can i set up a forum that requires a mySQL database and a Shoutbox that requires a mySQL database on the same database? Or do i need two seperate ones?

Thanks.

Order · 11-19-2003

Quote:

Originally posted by Evdawg
Ok digital, or anyone else, pretty simple question:

Can i set up a forum that requires a mySQL database and a Shoutbox that requires a mySQL database on the same database? Or do i need two seperate ones?

Thanks.

Yes, this is possible.

A lot of hosts, mainly free ones give you one database, so you can as long as the table names are different, I actually prefer to keep everything in one database.. keep it simple.

Evdawg · 11-19-2003

Thanks!

Well,
I'm working on my website now and something else just popped up, i've installed PHPmyAdmin and i've filled out "config" with my username and password. To acess PHPmyadmin i have to go to www.blahblah.myhost.com/phpmyadmin/

I am wondering if anyone can access my mySQL database now and edit tables?

And if so, then how can i make it secure?

I've looked through the FAQ, but i couldnt find an answer.

Thanks again

Order · 11-19-2003

Quote:

Originally posted by Evdawg
Thanks!

Well,
I'm working on my website now and something else just popped up, i've installed PHPmyAdmin and i've filled out "config" with my username and password. To acess PHPmyadmin i have to go to www.blahblah.myhost.com/phpmyadmin/

I am wondering if anyone can access my mySQL database now and edit tables?

And if so, then how can i make it secure?

I've looked through the FAQ, but i couldnt find an answer.

Thanks again

The way that is most secure in this situation is using .htaccess files to handle it, and yes, phpMyAdmin can be used by anyone who knows the address...

To read how to set up an .htaccess password protection scheme, the place to read it is:

http://www.javascriptkit.com/howto/htaccess3.shtml

If you have any more questions, I am here to help as needed.