[WTH] MySQL to PHP

Jerlene · Jun 6, 2007

My PHP sessions are stored in a MySQL database table, and not in files. The database is executing too many queries and this overloads my shared server.

My host strongly suggests I have my PHP sessions stored in files and not in MySQL database table. I don't know how to change that setting so I'm looking to hire someone that can do this for me.

Reply in this thread if you know how to do this and let me know the price you'll do it for. Make me an offer, I will not set a price. Thanks.

Peter · Jun 6, 2007

this should be very simple and SHOULD only require a line change in the php script.

In your script look for a line that looks like:-

session_set_save_handler("open", "close", "read", "write", "destroy", "gc");

this is where it is set.

Jerlene · Jun 6, 2007

Sorry. I have no clue what that's all about. What exactly do I have to do?

Oh and what script will this be in? I have a lot of files on my server.

Peter · Jun 6, 2007

without seeing the files it is impossible to say. An application can be made up of literally hundreds of files and the names and what is contained in them is pretty much up to the person who wrote it.

Regarding the line I posted. The line is an example piece of code that sets routines for php to know how to handle the sessions, by default php users files as your host is advising but this behaviour can be over written. It is possible they do not use php session handling at all but that is less likely.

samuofm · Jun 6, 2007

peter@flexiwebhost said:
Regarding the line I posted. The line is an example piece of code that sets routines for php to know how to handle the sessions, by default php users files as your host is advising but this behaviour can be over written. It is possible they do not use php session handling at all but that is less likely.

This is true, I've actually never thought about storing the sessions in a database, always used files by default. Since its a shared host he probably can't edit the php.ini file so he'll have to go with a solution like you suggested, setting the session mode in the actual request calls.

bollyflix.taxi

gigride.live

circolotenniscasalecchio.it

medteh.info

badbanana.co.uk

votewatch.pro

themodelnottingham.co.uk

excheats.world

mauleinvestments.cl

[WTH] MySQL to PHP

Established Member

VIP Member

Established Member

VIP Member

Established Member

Hearth.net

streamearn.com

image.xyz

backroom.com

Ceee.com

Finance.xyz

Sable.co

Music.studio

Cycle.co

Swan.co

Similar threads

We're social

Hearth.net

streamearn.com

image.xyz

backroom.com

Ceee.com

Finance.xyz

Sable.co

Music.studio

Cycle.co

Swan.co

Pinned

Appreciation

Preference

Appreciation

Upvoting

Agreement

Answers

Decisions

Relevance

Reaction

Facial expressions

Vocal expressions

Status

Workflow

Clarification

Feeling

Sympathy