Comments for Rene's PHP Blog

Comment on MySQL issue with character set by Roberto

Roberto — Thu, 23 Jul 2009 16:24:54 +0000

Hi Reneee!!!
Thanks for your nice advice!!! I had that problem and now thanks to you I resolved!!! THANKS THANKS THANKS!!!!

Comment on MySQL issue with character set by Rene

Rene — Wed, 28 Jan 2009 14:39:34 +0000

Hey,

yeah you can insert everything you want. The string can be as long as you want.

Good luck!

Comment on MySQL issue with character set by Frank Los

Frank Los — Wed, 28 Jan 2009 09:17:00 +0000

Hi Renee,

could I instert more characters in that string?
Like the strange ř from Dvořák.
I am a php dummie, so…

best, Frank.

Comment on Read and Download a XML File by Rene

Rene — Wed, 29 Oct 2008 20:15:44 +0000

even i had read your comment i decided to do it after all. And, i saved about half time. So it was an increase for my script. You are talking about reading the xml 15 times, and i think it went from 2 seconds to 1 second.

A XML-playlist of a player (www.1080dots) is the output after the xml has been downloaded. And this playlist is downloaded by the player once every 10 minutes. Everytime the playlist is read, the xml files will be updated. So not that often.
Another web-application is reading the same files localy, but isn’t downloading it from external locations.

Comment on Read and Download a XML File by evert

evert — Tue, 28 Oct 2008 20:30:30 +0000

This probably won’t help you make things faster. The difference is that you’re saving it in a file first, and then opening it straight away. So in fact, this is likely a bit slower..

What you should do though is download the file, save it and keep it around for say, 30 minutes. Only when the file is older than 30mins (using filemtime) you download it again. This means that the slowdown only happens for one visitor every 30 minutes.

Alternatively you can avoid saving it on the disk altogether and for example place it in the memory using apc_store / apc_fetch

Comment on Function Exists by Rene

Rene — Wed, 22 Oct 2008 16:56:34 +0000

the problem i encountered was:

-the main application had a functions file with multiple functions
-a sub application (A) had a functions file with multiple functions.
-another sub application (B) had a functions file with multiple functions.

Both sub applications had some same, and some different functions, but they needed to be separated. Some clients will use sub function A and not B, and otherwise.

include once wont help because i need the other functions that are both files. So, i had to bring up a new solution. And this is what i have found.

Comment on Function Exists by evert

evert — Wed, 22 Oct 2008 15:51:53 +0000

How about including your modules with require_once ?

putting a function into a conditional (if) has the potential to make things slow..

Comment on Work with function ezSQL by admin

admin — Mon, 29 Sep 2008 06:56:13 +0000

I have posted 3 options for ezSQL. But forgot to mention the $db->query

With this option you can insert, update or delete. Or whatever function you want to use.