I am trying to convert ms access sql to postgresql using php.
I have a sql statement in the form ;-
$sql = SELECT DISTINCT [Table Name].[Column.Name], [Table Name 1].[Column
Name 2] etc.
what I want to end up with is $sql = SELECT DISTINCT table_name.column_name,
table_name_1.column_name_2,
hi guys,
I need to do some performance testing for a site of mine.
I want to compare performance of various combinations
of using APC, Squid, Apache/LightHTTPD mod_php/fastcgi.
all very well I can build the various setups but I'm stuck as
to how to go about recreating realistic load on the
Ron Rademaker schreef:
Hi Jochem,
Apache comes with an nice ab tool which stands for apache benchmarking.
You can use this to benchmark stuff like concurrent requests.
indeed, I know ab, but it doesn't allow for a very realistic request 'spread'
- at least as far as I know.
I was hoping for
On Mon, 2008-01-21 at 10:50 +0100, Jochem Maas wrote:
Does anyone have any tips, urls, advice as to how to start
going about creating something like a 'test suite' for testing
high load performance of a website?
I went through a similar headache recently, and looked at a whole whack
of
2008. 01. 19, szombat keltezéssel 11.12-kor Daniel Brown ezt írta:
Aside from that, Zoltan, if you happen to be able to find the
function to post without much problem, feel free, and I'll look into
incorporating it into the script. Otherwise, I can fix it myself. My
fault for not
Jochem Maas wrote:
Ron Rademaker schreef:
Hi Jochem,
Apache comes with an nice ab tool which stands for apache
benchmarking. You can use this to benchmark stuff like concurrent
requests.
indeed, I know ab, but it doesn't allow for a very realistic request
'spread'
- at least as far as I
Can yo upost the code you have got to do the conversion
so far please?
Regards
Keith
-
Websites:
http://www.karsites.net
http://www.php-debuggers.net
http://www.raised-from-the-dead.org.uk
All email addresses are
Ron Rademaker schreef:
Jochem Maas wrote:
Ron Rademaker schreef:
Hi Jochem,
Apache comes with an nice ab tool which stands for apache
benchmarking. You can use this to benchmark stuff like concurrent
requests.
indeed, I know ab, but it doesn't allow for a very realistic request
'spread'
Well actually not a real lot so far. I'm just trial and error(lots of that)
at the moment. I've only been 'playing with php for about a month or so.
$file = phptest1.txt;
$rep = array (tbl_ , _%, bool default 0, bool default 1, '?');
$wih = array (, _pc, bool DEFAULT FALSE, bool DEFAULT TRUE, );
On Jan 20, 2008 10:15 PM, nihilism machine [EMAIL PROTECTED] wrote:
im trying to keep this php4 OOP. im just trying to clean the post/gets
and then make them all into variables with their names being the keys
to the get/post, and their values as the variables values.
ie:
On Jan 20, 2008 10:06 PM, Nathan Nobbe [EMAIL PROTECTED] wrote:
On Jan 20, 2008 9:47 PM, nihilism machine [EMAIL PROTECTED] wrote:
how does this look? should this by me calling ... myforms = new
forms(); work by turning all key/value pairs for both get and post
into variable names of the
On Jan 20, 2008 8:36 PM, Jochem Maas [EMAIL PROTECTED] wrote:
now for the juicy bit - you have *no* garantee that the system clock and/or
the timezone setting on the client machine is anything like correct. actually
the chances that it is not are quite high - disregarding idiots, just think of
Eric Butera schreef:
...
then from client space you would just say
InputFilter::filterInput();
then, subsequently you can use $_POST and $_GET directly with the
assumption
that the input has been escaped.
BAD! assuming $_GET/$_POST are sanitized and escaped is always wrong. stick
-- Forwarded message --
From: Nathan Nobbe [EMAIL PROTECTED]
Date: Jan 21, 2008 10:43 AM
Subject: Re: [PHP] change php variable depending on selection
To: stp [EMAIL PROTECTED]
On Jan 21, 2008 9:42 AM, stp [EMAIL PROTECTED] wrote:
I'm sorry…..I've got the conversion of the
I'm developing a traning page for basic math. The answers are entered by
the user in simple text input fields and the same page is returned (after
having been processed by php) to the user with indications of correctness
or error on each answer. If the AutoComplete feature is turned on a
Hi Peter. Is this what you want to do. Copy this into a
*.php page, and then look at it with your browser.
I just refactored one of my heredoc queries to handle your
problem.
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0
Transitional//EN
On Jan 21, 2008 5:50 AM, Jochem Maas [EMAIL PROTECTED] wrote:
Ron Rademaker schreef:
Jochem Maas wrote:
Ron Rademaker schreef:
Hi Jochem,
Apache comes with an nice ab tool which stands for apache
benchmarking. You can use this to benchmark stuff like concurrent
requests.
indeed,
On Jan 21, 2008 10:19 AM, Eric Butera [EMAIL PROTECTED] wrote:
I don't think making a single generic function to iterate over every
value in the GET/POST arrays is a very good idea. Each field on a
form can contain very different pieces of data that should be handed
quite differently. I
On Jan 21, 2008 10:31 AM, Tor Vidvei [EMAIL PROTECTED] wrote:
I'm developing a traning page for basic math. The answers are entered by
the user in simple text input fields and the same page is returned (after
having been processed by php) to the user with indications of correctness
or error
On 1/21/08, Tor Vidvei [EMAIL PROTECTED] wrote:
I'm developing a traning page for basic math. The answers are entered by
the user in simple text input fields and the same page is returned (after
having been processed by php) to the user with indications of correctness
or error on each
Chris, Jochem, Nathan, Jason, Paul,
Thanks for the suggestions and information. This is great, gives me a good
place to start.
Best,
-dg
Daneane schreef:
Chris, Jochem, Nathan, Jason, Paul,
Thanks for the suggestions and information. This is great, gives me a good
place to start.
let us know how you get on - chances are you'll learn some tricks other may
find handy :-)
Best,
-dg
--
PHP General Mailing List
Peter wrote:
I am trying to convert ms access sql to postgresql using php.
I have a sql statement in the form ;-
$sql = SELECT DISTINCT [Table Name].[Column.Name], [Table Name 1].[Column
Name 2] etc.
what I want to end up with is $sql = SELECT DISTINCT table_name.column_name,
I have a text file that contains 200k rows. These rows are to be imported
into our database. The majority of them will already exists while a few are
new. Here are a few options I've tried:
I've had php cycle through the file row by row and if the row is there,
delete it and do a straight
rectified ;-)
Originele bericht
On Jan 21, 2008 11:51 AM, Jochem Maas [EMAIL PROTECTED] wrote:
yeah - you'll get used to it, mostly. it happens to everyone that they seem to
be
getting replies to things they didn't write - I was responding to the OP in this
case - adding to
RavenWorks schreef:
Well, just for the sake of anybody in my situation finding this thread in the
future -- the workaround is to use this:
Options +FollowSymLinks
RewriteEngine on
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.+)$
On Jan 21, 2008 12:35 PM, blackwater dev [EMAIL PROTECTED] wrote:
I have a text file that contains 200k rows. These rows are to be imported
into our database. The majority of them will already exists while a few are
new. Here are a few options I've tried:
I've had php cycle through the
On Mon, 2008-01-21 at 12:35 -0500, blackwater dev wrote:
I have a text file that contains 200k rows. These rows are to be imported
into our database. The majority of them will already exists while a few are
new. Here are a few options I've tried:
I've had php cycle through the file row
I think that's possible, so I'll give it a shot.
For some reason, even with straight inserts my php script is dying around
180,000 rows. Basically, I took out all the compare/update code so now I
grab the row from the db and if there isn't one, do an insert. I've wiped
my db so should do
On Jan 21, 2008 1:08 PM, blackwater dev [EMAIL PROTECTED] wrote:
I think that's possible, so I'll give it a shot.
For some reason, even with straight inserts my php script is dying around
180,000 rows. Basically, I took out all the compare/update code so now I
grab the row from the db and if
My apologies Robert, Gmail sucks. I'm bouncing this back to the list, where it
belonged in the first place. Feel free to make corrections if I've
mischaracterized
what you wrote. Good luck with that, btw, but don't expect me to engage.
Robert Cummings wrote:
And THAT does remind me of my MUD
On Mon, 2008-01-21 at 14:37 -0500, Mike Potter wrote:
You should have said yes and quit while you thought you were ahead.
I'm not trying to get ahead... I didn't know I was competing. Are we
competing? I thought I was just answering posts.
that was me saying that there is certainly a good
Today, I found a bug in my software which I was originally happy to
find since that means there's one less that I have to worry about... 3
hours later while trying to figure out how to fix it I wish I never
found it!
Here's the deal, I have a file that exports the records in the
database
On Jan 21, 2008 2:57 PM, Jason Pruim [EMAIL PROTECTED] wrote:
Today, I found a bug in my software which I was originally happy to
find since that means there's one less that I have to worry about... 3
hours later while trying to figure out how to fix it I wish I never
found it!
Here's the
On Jan 21, 2008 11:57 AM, Jason Pruim [EMAIL PROTECTED] wrote:
Today, I found a bug in my software which I was originally happy to
find since that means there's one less that I have to worry about... 3
hours later while trying to figure out how to fix it I wish I never
found it!
Here's the
On Jan 21, 2008, at 3:04 PM, James Ausmus wrote:
On Jan 21, 2008 11:57 AM, Jason Pruim [EMAIL PROTECTED] wrote:
Today, I found a bug in my software which I was originally happy to
find since that means there's one less that I have to worry
about... 3
hours later while trying to figure out
On Jan 21, 2008, at 3:02 PM, Eric Butera wrote:
On Jan 21, 2008 2:57 PM, Jason Pruim [EMAIL PROTECTED] wrote:
Today, I found a bug in my software which I was originally happy to
find since that means there's one less that I have to worry
about... 3
hours later while trying to figure out
On Mon, 2008-01-21 at 15:20 -0500, Jason Pruim wrote:
I try so hard to NOT rely on the wealth of info available here, but
you guys don't make it easy!! :)
The only good thing to do with wealth is share.
Cheers,
Rob.
--
...
On Jan 21, 2008, at 3:27 PM, Robert Cummings wrote:
On Mon, 2008-01-21 at 15:20 -0500, Jason Pruim wrote:
I try so hard to NOT rely on the wealth of info available here, but
you guys don't make it easy!! :)
The only good thing to do with wealth is share.
Now you're just trying to add to
Jason Pruim [EMAIL PROTECTED] wrote:
On Jan 21, 2008, at 3:27 PM, Robert Cummings wrote:
On Mon, 2008-01-21 at 15:20 -0500, Jason Pruim wrote:
I try so hard to NOT rely on the wealth of info available here, but
you guys don't make it easy!! :)
The only good thing to do with
On Jan 21, 2008, at 3:47 PM, Robert Cummings wrote:
On Mon, 2008-01-21 at 15:28 -0500, Jason Pruim wrote:
On Jan 21, 2008, at 3:27 PM, Robert Cummings wrote:
On Mon, 2008-01-21 at 15:20 -0500, Jason Pruim wrote:
I try so hard to NOT rely on the wealth of info available here, but
you guys
On Jan 21, 2008 3:47 PM, Robert Cummings [EMAIL PROTECTED] wrote:
Now I just need to find a way to increase the content of my posts.
Just reply to everyone with random Wikipedia articles. You can even
say it is on topic because it is generated with PHP.
--
PHP General Mailing List
On Jan 21, 2008 3:52 PM, Jason Pruim [EMAIL PROTECTED] wrote:
Would that not give favor to people who appear to like to hear them
selves talk (Or type in this case since I can not just call a simple
txttospeach(Speak this electronic mail so that all may hear the glory
that is my voice!);) and
On Jan 21, 2008, at 3:33 PM, Wolf wrote:
Jason Pruim [EMAIL PROTECTED] wrote:
On Jan 21, 2008, at 3:27 PM, Robert Cummings wrote:
On Mon, 2008-01-21 at 15:20 -0500, Jason Pruim wrote:
I try so hard to NOT rely on the wealth of info available here, but
you guys don't make it easy!!
On Mon, 2008-01-21 at 15:28 -0500, Jason Pruim wrote:
On Jan 21, 2008, at 3:27 PM, Robert Cummings wrote:
On Mon, 2008-01-21 at 15:20 -0500, Jason Pruim wrote:
I try so hard to NOT rely on the wealth of info available here, but
you guys don't make it easy!! :)
The only good thing
Don't be scared of functions, no magic or mystery there, all you are doing
is putting your code in a function like so:
function add($a, $b) {
return $a + $b;
}
..for example and calling it like so:
$a = 12;
$b = 100;
$sum = add(12, 13);
...etc etc, not too much more to learn than that and now
Jim Lucas wrote:
Peter wrote:
I am trying to convert ms access sql to postgresql using php.
I have a sql statement in the form ;-
$sql = SELECT DISTINCT [Table Name].[Column.Name], [Table Name
1].[Column Name 2] etc.
what I want to end up with is $sql = SELECT DISTINCT
what about uploading the entire file into a [semi]temp table..then doing cross
table comparisons to load your main table with the data?
bastien Date: Mon, 21 Jan 2008 13:08:27 -0500 From: [EMAIL PROTECTED] To:
php-general@lists.php.net Subject: Re: [PHP] a better way to do a data
import? I
On Jan 20, 2008 6:13 AM, Richard Heyes [EMAIL PROTECTED] wrote:
If your server's default file is index.php, you could use the following
in an index.php file:
?php
header('Location: /');
?
You really shouldn't use relative paths in a header location.
On Jan 20, 2008 9:53 PM, Leticia Larrosa [EMAIL PROTECTED] wrote:
Hello
I have a MSSql 2000 database that have stored data with the follow special
characters: ó, í, Ñ, á, é, ú.
When I see the data through any MsSql Client I see exactly those characters.
The Collation of database is:
Hey-
I'm trying to install PHP5 with mysql support and I keep running into
the same problem over and over again. I run the configuration with this:
--with-mysql=/usr/local/mysql and without fail I get this every time:
ext/mysql/php_mysql.o: In function `zif_mysql_create_db':
Nathan Nobbe wrote:
hi all,
recently ive been debating a bit about the use of the crypt() function and
the best practice thereof, im hoping you can help to clarify this for me.
so, the crypt function
http://www.php.net/manual/en/function.crypt.php
has a second parameter, $salt, which, if not
blackwater dev wrote:
I have a text file that contains 200k rows. These rows are to be imported
into our database. The majority of them will already exists while a few are
new. Here are a few options I've tried:
I've had php cycle through the file row by row and if the row is there,
delete
Hi all,
Does anyone understand the difference between memory_get_usage and
memory_get_peak_usage with and without the parameter?
I don't understand how the allocations could be so far apart.
eg (small script that takes a minute to run):
$ php -f file.php
Peak usage (true): 4,608.0
Jim Lucas wrote:
Peter wrote:
I am trying to convert ms access sql to postgresql using php.
I have a sql statement in the form ;-
$sql = SELECT DISTINCT [Table Name].[Column.Name], [Table Name
1].[Column Name 2] etc.
what I want to end up with is $sql = SELECT DISTINCT
blackwater dev [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I have a text file that contains 200k rows. These rows are to be
imported
into our database. The majority of them will already exists while a few
are
new. Here are a few options I've tried:
I've had php cycle
David Giragosian [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On 1/21/08, Tor Vidvei [EMAIL PROTECTED] wrote:
I'm developing a traning page for basic math. The answers are entered by
the user in simple text input fields and the same page is returned (after
having been processed
Tom Ray [Lists] wrote:
Hey-
I'm trying to install PHP5 with mysql support and I keep running into
the same problem over and over again. I run the configuration with this:
--with-mysql=/usr/local/mysql and without fail I get this every time:
ext/mysql/php_mysql.o: In function
Chris wrote:
Tom Ray [Lists] wrote:
Hey-
I'm trying to install PHP5 with mysql support and I keep running into
the same problem over and over again. I run the configuration with
this: --with-mysql=/usr/local/mysql and without fail I get this every
time:
ext/mysql/php_mysql.o: In function
Hello fellow members of this list,
There is a couple of rutinary tasks that our servers (different platforms)
perform during the night. Early during the day, we have to check that every
task was performed correctly and without errors. Actually, we do this by
hand, going first to server A (AIX
Tom Ray [Lists] wrote:
Chris wrote:
Tom Ray [Lists] wrote:
Hey-
I'm trying to install PHP5 with mysql support and I keep running into
the same problem over and over again. I run the configuration with
this: --with-mysql=/usr/local/mysql and without fail I get this every
time:
Miguel Guirao wrote:
Hello fellow members of this list,
There is a couple of rutinary tasks that our servers (different platforms)
perform during the night. Early during the day, we have to check that every
task was performed correctly and without errors. Actually, we do this by
hand, going
sure, why notyou can exec most of the commands and log all of the results
to a file that you can email yourself
bastien
Date: Mon, 21 Jan 2008 17:55:11 -0600
From: [EMAIL PROTECTED]
To: php-general@lists.php.net
Subject: [PHP]
I configured autofs in my fedora so that when I plug any usb stick in
/dev/sda1 it automatically mounts in /mnt/auto/usb0
There is two lines where the problem arise.
$util-run_command(ls -1 /mnt/auto/usb0 | wc -l);// it shows 13 when I
plug my usb stick.
$list = scandir(/mnt/auto/usb0 ); //
Chris wrote:
Tom Ray [Lists] wrote:
Chris wrote:
Tom Ray [Lists] wrote:
Hey-
I'm trying to install PHP5 with mysql support and I keep running
into the same problem over and over again. I run the configuration
with this: --with-mysql=/usr/local/mysql and without fail I get
this every time:
On Mon, 2008-01-21 at 18:01 -0500, Tom Ray [Lists] wrote:
Hey-
I'm trying to install PHP5 with mysql support and I keep running into
the same problem over and over again. I run the configuration with this:
--with-mysql=/usr/local/mysql and without fail I get this every time:
Why isnt this cleaning my form $_POST's
class forms {
var $UserInputClean;
// Forms to variables
function forms() {
if (count($_POST) 0) {
foreach($_POST as $curPostKey = $curPostVal) {
On Mon, 2008-01-21 at 23:15 -0500, nihilism machine wrote:
Why isnt this cleaning my form $_POST's
class forms {
var $UserInputClean;
// Forms to variables
function forms() {
if (count($_POST) 0) {
foreach($_POST as
now my debug shows that with the following code, all of the
$_POST['whatever'] values are blank.
class forms {
var $UserInput;
// Forms to variables
function forms() {
if (count($_POST) 0) {
foreach($_POST as
On Mon, 2008-01-21 at 23:39 -0500, nihilism machine wrote:
now my debug shows that with the following code, all of the
$_POST['whatever'] values are blank.
class forms {
var $UserInput;
// Forms to variables
function forms() {
if
What is a good tool to coordinate a team of programmers efficiently?
To give each one a different part of the project is a start, but it needs to
get combined at some points to be a working project.
Not to debug code you have written was a hint, to see actually bugs as a bug
and not as a
It depends. If the project built up of slightly different modules, putting
the coders on a big, white table seems to be a good idea. But if the modules
are completely different, you should separate them, so each of them can be
focused on their own subject. In this case, you have to have some
72 matches
Mail list logo
