[PHP] Re: MySQL Access

2002-09-20 Thread M1tch
I had the problem a few days ago. Here's some software that makes it easy as clicking a button - http://www.convert-in.com/sql2acc.htm Be warned though, it's only free to copy table structure. It requires registration to copy data. Christian Calloway [EMAIL PROTECTED] wrote in message [EMAIL

Re: [PHP] PreCaching Db into Variables Slows it down?!??

2002-09-12 Thread M1tch
That's an expansive reply! Cheers Peter Since I had to alter the db (quite simply) to include this tweak, I thought best to do it now in dev phase (and keep it as an option), that mess around with it later when lots of data exists. It's my own code, and benchmarks show it to perform fast.

[PHP] Re: Extracting Numbers from a string.

2002-09-11 Thread M1tch
it doesn't use ereg, but it (should) would work: $mystring = I have $56.55 dollars, don't you know; $mystring = substr($mystring, strpos($mystring, $));//strip out after the $ sign $mystring = substr($mystring, 0, strpos($mystring, ));//keep only till first space //mystring now

[PHP] PreCaching Db into Variables Slows it down?!??

2002-09-11 Thread M1tch
Grrr! Just spent ages (well, 2hours) on a precaching system for my PHP code that didn't work out! Hang on, I'll backtrack a bit... My website is using a php engine that picks at snippets of html from the database, and builds them up to form the page. A typical page may use 5 of these html

Re: [PHP] Re: Proposal for securing PHP sessions

2002-09-08 Thread M1tch
Ooooh, it's a lesson every day! Right, back to the drawing board :( Justin French [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... on 08/09/02 5:04 AM, M1tch ([EMAIL PROTECTED]) wrote: Why not just use IP? I created a nice system, whereby if

[PHP] Re: Proposal for securing PHP sessions

2002-09-08 Thread M1tch
Okay, having had my own solution shot and burned ;), I would love to look at yours, but unfortunately the page (well, the entire site), will not load. It could be a temporary outage with either ISP, but is there anyway you could post it here? (I perhaps flag it as large?). On my site, I'm not

[PHP] Re: Proposal for securing PHP sessions

2002-09-08 Thread M1tch
lol, no sooner had I spoke than it sprang back into action! I now have the source you posted. Looking it over! M1tch [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Okay, having had my own solution shot and burned ;), I would love to look a

Re: [PHP] Re: Proposal for securing PHP sessions

2002-09-08 Thread M1tch
:( (but still thanks for bringing it up now, rather than at production time!) Justin French [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... on 08/09/02 5:04 AM, M1tch ([EMAIL PROTECTED]) wrote: Why not just use IP? I created a nice system, whereby if your IP is

[PHP] Re: Proposal for securing PHP sessions

2002-09-08 Thread M1tch
One thing that I did that may help. Every time a session is opened, the system insists on writing to disk on every page, whether the session is updated or not. With a lot of users, this is a bit of a system bog. So, I hold the contents of a session when 'read', in a global variable. Then, in the

[PHP] Re: Proposal for securing PHP sessions

2002-09-07 Thread M1tch
Why not just use IP? I created a nice system, whereby if your IP is changed (or someone is hacking your session), the session is destroyed, and the user must log in. Does not add much overhead either. Also, I built it using database (using my own session functions in savehandler), that stores

Re: [PHP] Re: Proposal for securing PHP sessions

2002-09-07 Thread M1tch
s:[EMAIL PROTECTED]... You're going to be shutting out a lot of AOL users (bah! who needs em! ;p) if you do that, as AOL changes a user's IP address about as often as you read the word the... Dave -Original Message- From: M1tch [mailto:[EMAIL PROTECTED]] Sent: Saturday, September