Very very nice. I'm impressed with how easy everything was to
setup. I keep wondering why nobody at PHP/MySQL/Apache ever sets up
stuff like this.
On Nov 2, 2006, at 8:40 PM, Wee Keat Chin wrote:
Ed,
Ed Lazor wrote:
I'm trying to configure and compile PHP 5. The configure is
failing
On 02 Nov 2006, at 5:11 PM, Ed Lazor wrote:
I'm trying to configure and compile PHP 5. The configure is
failing to find the MySQL UNIX socket. Any ideas?
./configure \
--with-apxs2=/usr/local/apache2/bin/apxs \
--with-zlib \
--with-mysql=/usr/local/mysql \
--with-mysql-socket=/tmp
I
Dave Goodchild wrote:
Hi all. I am writing a web app with a mysql back end and there is every
chance one of the tables may have to handle 56+ million records. I am no
mysql expert but has anyone else here ever handled that volume of data, and
if so, any suggestions or caveats? The tables will of
Hi all. I am writing a web app with a mysql back end and there is every
chance one of the tables may have to handle 56+ million records. I am no
mysql expert but has anyone else here ever handled that volume of data, and
if so, any suggestions or caveats? The tables will of course be correctly
On Sun, 01 Oct 2006 19:59:08 +0100, Deckard wrote:
Hello,
I have this code:
// insert new user in mysql user table
$sqlInsertUser = INSERT INTO user (Host, User , Password ,
Select_priv, Insert_priv, Update_priv, Delete_priv) VALUES ('$hostname',
'$mysql_username', '$mysql_password',
if (mysql_query($sqlInsertUser, $conn))
$messagesqlInsertUser = 'Success...';
else
$messagesqlInsertUser = 'Error: ' . mysql_error();
$result = mysql_query($sqlInsertUser);
I see this being executed twice. - mysql_query($sqlInsertUser); I
believe that is your problem. Change the
Do you have the Host field set to unique?
--
http://www.web-buddha.co.uk
http://www.projectkarma.co.uk
We need a guy for some hourly PHP/MySQL work. Large project to start
with, plenty of incremental stuff down the road. Looking for someone
expert, with a flexible schedule who can make hours available when we
need them. Your regular hourly rate.
Also - only interested in someone local
On Fri, 2006-09-22 at 09:00 -0700, Brian Dunning wrote:
Also - only interested in someone local to south Orange County, CA.
No outsourcers or non-locals can be considered, sorry.
Geee, way to fight back against the shrinking distance of the global
community brought to you by the
On 22 Sep 2006, at 11:14 , Robert Cummings wrote:
Geee, way to fight back against the shrinking distance of the
global
community brought to you by the Internet. I'm just curious why so many
posters for jobs feel the need to force a local boundary. Is the
quality
of work somehow better
Hi all. I am building an online events listing and when I run the following
query I get the expected result set:
SELECT events.id AS eventid, name, postcode, start_time, dates.date FROM
events, dates_events, dates WHERE dates_events.event_id = events.id and
dates_events.date_id = dates.id AND
Have you tried echoing out your query to run on the backend itself?
Maybe there is some problem with how your join is being constructed...
Perhaps a left outer join is called for? Hard to tell without having
knowledge of your table structure and table data...
-B
Dave Goodchild wrote:
Hi all.
On 15/09/06, Brad Bonkoski [EMAIL PROTECTED] wrote:
Have you tried echoing out your query to run on the backend itself?
Maybe there is some problem with how your join is being constructed...
Perhaps a left outer join is called for? Hard to tell without having
knowledge of your table structure
Also you should check if dates.date is a DATE type, not DATETIME. Lost
some time on that when I wanted to select enregs for a specific date,
field was DATETIME and I was querying `date` = '2006-01-01'... :p
Andy
Dave Goodchild wrote:
On 15/09/06, Brad Bonkoski [EMAIL PROTECTED]
On Fri, September 15, 2006 7:35 am, Dave Goodchild wrote:
Hi all. I am building an online events listing and when I run the
following
query I get the expected result set:
Any ideas why not? I know it's more of a mySQL question so apologies
in
advance!
Well, you'd have to tell us what's in
Hi all,
Koala Telecom is seeking a full time programmer with experience with
PHP5, Perl and SQL (MySQL).
Core requirements are:
- Experience developing projects in a team environment using a
versioning system such as Subversion or CVS.
- Design and analysis skills.
- Experience with
Original Message
Subject: Re: [PHP-DEV] mysql-* versus db_* statements (26-Jun-2006 9:21)
From:[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Please user php-general@lists.php.net for such questions.
Thank you.
On 26.06.2006 11:10, [EMAIL PROTECTED] wrote:
require_once
Could someone explain the behaviour of the following code fragments. I have a
serious problem with db-statements.
##
It's currently a little bit late in the US and you only waited 2 hours
since your last post. While this is an international list the majority
of the posters are US based. Not getting a response within two hours at
this time is not unusual and you should probably be more patient.
As for your
[EMAIL PROTECTED] wrote:
...
$link = mysql_connect(localhost, root, 040573);
what was your IP address again?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Ok, here's what i got in my mysql db. I got a table listed with numbers as
follows
1
2
3
4
5
6
7
10
11
12
13
14
15
16
17
18
19
20
21
22
25
These numbers I can display fine. I'm using ..
$query=SELECT * FROM db ORDER BY numbers ASC;
Right now it displays it as
1
10
11
12
.
2
22
23
25
Yeah, I got this problem fixed. The datbase was listed under [chr] instead of
[integer].
Thanks for the help though.
- Original Message -
From: Xavier Casto
To: Rob W.
Cc: php-general@lists.php.net
Sent: Sunday, June 18, 2006 7:30 PM
Subject: Re: [PHP] mysql ORDER
Hi all,
I have SQL query , for example , Select country , name from
tbl_chassis order by country.
The problem of the sql statement is that , if there are empty value in
country field , it be sorted first .
How to do sorting the empty value last
? I can cp() function to do this ? or any
perhaps this will work:
Select country , name from tbl_chassis order by ifnull(country,'')
didn't try it.
- Original Message -
From: weetat [EMAIL PROTECTED]
To: php-general@lists.php.net
Sent: Thursday, June 15, 2006 8:14 AM
Subject: [PHP] mysql + PHP
Hi all,
I have SQL
: Thursday, June 15, 2006 8:14 AM
Subject: [PHP] mysql + PHP
Hi all,
I have SQL query , for example , Select country , name from
tbl_chassis order by country.
The problem of the sql statement is that , if there are empty value
in country field , it be sorted first .
How to do sorting the empty
-general@lists.php.net; Satyam [EMAIL PROTECTED]
Cc: php-general@lists.php.net
Sent: Thursday, June 15, 2006 8:51 AM
Subject: Re: [PHP] mysql + PHP
hi , not working .
The empty value still sorted first.
Thanks.
Satyam wrote:
perhaps this will work:
Select country , name from tbl_chassis order
2006/6/15, weetat [EMAIL PROTECTED]:
Hi all,
I have SQL query , for example , Select country , name from
tbl_chassis order by country.
The problem of the sql statement is that , if there are empty value in
country field , it be sorted first .
How to do sorting the empty value last
? I
On Thu, June 15, 2006 1:14 am, weetat wrote:
I have SQL query , for example , Select country , name from
tbl_chassis order by country.
The problem of the sql statement is that , if there are empty value
in
country field , it be sorted first .
How to do sorting the empty value last
?
Thank all for your inputs.
Yes . the data should be null , really bad data , will try to change
database structure.
Richard Lynch wrote:
On Thu, June 15, 2006 1:14 am, weetat wrote:
I have SQL query , for example , Select country , name from
tbl_chassis order by country.
The problem
At 2:14 PM +0800 6/15/06, weetat wrote:
Hi all,
I have SQL query , for example , Select country , name from tbl_chassis
order by country.
The problem of the sql statement is that , if there are empty value in
country field , it be sorted first .
How to do sorting the empty value last
? I
I have a php form that pulls data from the database (hence the problems)
I need to do an OR search on three columns, and AND the rest, anyone
have a good way to do this? So far my searching on the MySQL lists have
been fruitless more then anything, and I figured we've probably come
across this
[snip]
I need to do an OR search on three columns, and AND the rest, anyone
have a good way to do this? So far my searching on the MySQL lists have
been fruitless more then anything, and I figured we've probably come
across this ourselves at some point.
[/snip]
More of a MySQL question, but
On Mon, June 5, 2006 10:32 am, Wolf wrote:
I have a php form that pulls data from the database (hence the
problems)
I need to do an OR search on three columns, and AND the rest, anyone
have a good way to do this? So far my searching on the MySQL lists
have
been fruitless more then
Thanks guys, I knew it was a stupid Q when I sent it, but I had another
one where I encapsulated them in () blow up on me, so I figured if I
asked and it was the same answer then I was on the right track.
And so far all the tests have shown positive. :)
Wolf
More of a MySQL question, but
On Fri, June 2, 2006 12:59 am, Matthew Pegg wrote:
Working on a PHP script at the moment where I want to be able to
extract a file (PDF file) from a mysql database\
That's bad. Read the archives.
and force the popup
of the File Download dialog, to allow the user to either save or open
the
Hi all,
Working on a PHP script at the moment where I want to be able to
extract a file (PDF file) from a mysql database and force the popup
of the File Download dialog, to allow the user to either save or open
the document (ie. and bypass loading the file using the browser's plugin)
I've found
Hi,
In this case I usually creating Iframe with zero with and zero height
and using
your header code in the iframe sorce file.
DS
-Original Message-
From: Matthew Pegg [mailto:[EMAIL PROTECTED]
Sent: Friday, June 02, 2006 7:59 AM
To: php-general@lists.php.net
Subject: [PHP] PHP/Mysql
Matthew Pegg wrote:
Hi all,
Working on a PHP script at the moment where I want to be able to
extract a file (PDF file) from a mysql database and force the popup
of the File Download dialog, to allow the user to either save or open
the document (ie. and bypass loading the file using the
Hi,
I am sorry for this not being really a PHP question, anyway I use
MySQL database, I have a table, which is HEAP (memory) type and I found
out I can store only about 22000 entries in it, then when I want to
insert new entry it gives me an error that the table is full.
The question is:
On 5/14/06, Martin Zvarík [EMAIL PROTECTED] wrote:
Hi,
I am sorry for this not being really a PHP question, anyway I use
MySQL database, I have a table, which is HEAP (memory) type and I found
out I can store only about 22000 entries in it, then when I want to
insert new entry it gives me an
Martin Zvarík wrote:
Hi,
I am sorry for this not being really a PHP question
So you know it's off topic, yet you're going to ask anyway.
MySQL database, I have a table, which is HEAP (memory) type and I found
out I can store only about 22000 entries in it, then when I want to
insert new
On Tue, May 2, 2006 7:05 am, Ross wrote:
This is my database now...I will use the item_id for the order but
what if I
want to change item_id 3 to item id 1? How can I push all the items
down one
place? How can I delete any gaps when items are deleted.
Change item_id 3 to 1.
... select id
On Tue, May 2, 2006 7:22 am, chris smith wrote:
On 5/2/06, Ross [EMAIL PROTECTED] wrote:
This is my database now...I will use the item_id for the order but
what if I
want to change item_id 3 to item id 1? How can I push all the items
down one
place? How can I delete any gaps when items are
On 5/3/06, Richard Lynch [EMAIL PROTECTED] wrote:
On Tue, May 2, 2006 7:22 am, chris smith wrote:
On 5/2/06, Ross [EMAIL PROTECTED] wrote:
This is my database now...I will use the item_id for the order but
what if I
want to change item_id 3 to item id 1? How can I push all the items
down
list where you can swap dvd to the
top of the list and delete this is what I am trying to achive with
php/mysql.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Ross schrieb:
Just say I have a db
CREATE TABLE `mytable` (
`id` int(4) NOT NULL auto_increment,
`fileName` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
when I add items they go id 1,2,3 etc. Whn I delete them gaps appear.
- Original Message -
From: Ross [EMAIL PROTECTED]
To: php-general@lists.php.net
Sent: Tuesday, May 02, 2006 12:00 PM
Subject: [PHP] php mysql problem
Just say I have a db
CREATE TABLE `mytable` (
`id` int(4) NOT NULL auto_increment,
`fileName` varchar(50) NOT NULL default
the ids to be changed so the items can change position in the
list. If I change id 3 to id 1 then everything else shifts down.
If anyone has seen the amazon dvd rental list where you can swap dvd to
the top of the list and delete this is what I am trying to achive with
php/mysql.
--
PHP
On 5/2/06, Ross [EMAIL PROTECTED] wrote:
This is my database now...I will use the item_id for the order but what if I
want to change item_id 3 to item id 1? How can I push all the items down one
place? How can I delete any gaps when items are deleted.
Why do you want to do that? There's no
1,2,3
(b) allow the ids to be changed so the items can change position in the
list. If I change id 3 to id 1 then everything else shifts down.
If anyone has seen the amazon dvd rental list where you can swap dvd to
the top of the list and delete this is what I am trying to achive with
php/mysql
to achive with
php/mysql.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Really can't imagine why you wanna do something like this. What's the use
in reordering a database. It's just a database. you can sort it in any way
you like.. gaps
At 11:00 AM +0100 5/2/06, Ross wrote:
Just say I have a db
CREATE TABLE `mytable` (
`id` int(4) NOT NULL auto_increment,
`fileName` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
when I add items they go id 1,2,3 etc. Whn I
Depending on your needs, here is another tack to think about (I know,
everyone else will be gasping and running for air...)
A few years ago I had to make a shopping cart. I had an archaic system
that would not share information with my web/db server, so I had to
write a query to dump the
Ross wrote:
This is my database now...I will use the item_id for the order but what if I
want to change item_id 3 to item id 1? How can I push all the items down one
place? How can I delete any gaps when items are deleted.
CREATE TABLE `board_papers` (
`id` int(4) NOT NULL auto_increment,
Ross wrote:
This is my database now...I will use the item_id for the order but what if I
want to change item_id 3 to item id 1? How can I push all the items down one
place? How can I delete any gaps when items are deleted.
CREATE TABLE `board_papers` (
`id` int(4) NOT NULL auto_increment,
of updates.
(b) allow the ids to be changed so the items can change position in
the
list. If I change id 3 to id 1 then everything else shifts down.
If anyone has seen the amazon dvd rental list where you can swap dvd
to the
top of the list and delete this is what I am trying to achive with
php
On Fri, April 28, 2006 10:26 am, sathyashrayan wrote:
I am a self thought php beginner. I wrote my first toy
code for database connection in php/mysql. The connection
is successful but iam getting a warning and my rows/columns
are not showing. I am getting a warning:
Warning
Dear group,
(I am a very beginner so please bear with me for a simple question)
I am a self thought php beginner. I wrote my first toy
code for database connection in php/mysql. The connection
is successful but iam getting a warning and my rows/columns
are not showing. I am getting a warning
sathyashrayan schrieb:
Dear group,
(I am a very beginner so please bear with me for a simple question)
I read that sentence somewhere before *mmh*
I am a self thought php beginner. I wrote my first toy
code for database connection in php/mysql. The connection
is successful but iam
sathyashrayan wrote:
Dear group,
(I am a very beginner so please bear with me for a simple question)
I am a self thought php beginner. I wrote my first toy
code for database connection in php/mysql. The connection
is successful but iam getting a warning and my rows/columns
are not showing
-Original Message-
From: John Nichel [mailto:[EMAIL PROTECTED]
Sent: Friday, April 28, 2006 9:11 PM
To: Php-General
Subject: Re: [PHP] Beginner's php/mysql connection probs
sathyashrayan wrote:
Dear group,
(I am a very beginner so please bear with me for a simple question)
I am
sathyashrayan wrote:
-Original Message-
From: John Nichel [mailto:[EMAIL PROTECTED]
Sent: Friday, April 28, 2006 9:11 PM
To: Php-General
Subject: Re: [PHP] Beginner's php/mysql connection probs
sathyashrayan wrote:
Dear group,
(I am a very beginner so please bear with me
-Original Message-
From: John Nichel [mailto:[EMAIL PROTECTED]
Sent: Friday, April 28, 2006 10:14 PM
To: Php-General
Subject: Re: [PHP] Beginner's php/mysql connection probs
sathyashrayan wrote:
-Original Message-
From: John Nichel [mailto:[EMAIL PROTECTED]
Sent: Friday
Jay Paulson wrote:
I have no idea if this is possible or not but is there a way to run Apache,
PHP, and MySQL from a CD? I'd like it to be possible to run it on Windows,
Mac OSX and *nix. If it is possible could someone point me in the right
direction?
Thanks!
XAMPP is a distribution of
: [PHP] Re: Run Apache/PHP/MySQL from CD?
Jay Paulson wrote:
I have no idea if this is possible or not but is there a way to run
Apache, PHP, and MySQL from a CD? I'd like it to be possible to run
it on Windows, Mac OSX and *nix. If it is possible could someone
point me in the right direction
I have no idea if this is possible or not but is there a way to run Apache,
PHP, and MySQL from a CD? I'd like it to be possible to run it on Windows,
Mac OSX and *nix. If it is possible could someone point me in the right
direction?
Thanks!
--
PHP General Mailing List (http://www.php.net/)
[snip]
I have no idea if this is possible or not but is there a way to run
Apache,
PHP, and MySQL from a CD? I'd like it to be possible to run it on
Windows,
Mac OSX and *nix. If it is possible could someone point me in the right
direction?
[/snip]
You'd have to have CD's for each OS on which
[snip]
I have no idea if this is possible or not but is there a way to run
Apache,
PHP, and MySQL from a CD? I'd like it to be possible to run it on
Windows,
Mac OSX and *nix. If it is possible could someone point me in the right
direction?
[/snip]
Yippee, cross-posting!
- Original Message -
From: Jay Blanchard [EMAIL PROTECTED]
To: Jay Paulson [EMAIL PROTECTED]; php-general@lists.php.net;
mysql@lists.mysql.com
Sent: Wednesday, April 19, 2006 8:53 PM
Subject: [PHP] RE: Run Apache/PHP/MySQL from CD?
[snip]
I have no idea if this is possible
Jay Paulson escreveu:
I have no idea if this is possible or not but is there a way to run Apache,
PHP, and MySQL from a CD? I'd like it to be possible to run it on Windows,
Mac OSX and *nix. If it is possible could someone point me in the right
direction?
Thanks!
-
Please see:
i was wondering what is the most secure way to use mysql in php. is there a
certain way it should be done or a way that is more secure than another?
iv'e seen it done many ways and was wondering if it was just preference or a if
there was a reason behind it.
if you guys could post some
Display the different ways in which you've seen php using mysql, and we'll
see if any one of them is any more secure than another.
Most Security issues can be left to MySQL and the MySQL API.
A few pointers -
Store parameters(username/password) outside the DocuementRoot.
Put your server on local
[snip]
$sql = SELECT * FROM `table1` LEFT JOIN `table2` USING `id` WHERE ...
GROUP BY `table1`.`id`;
mysql_query($sql);
the problem is, that, when in table2 is not matching data using that id,
i lose that id from output array. but i don`t want to.. is there any
posibility to keep that id?
thanks for your posting, but I have:
table1
id
name
value
table2
id
x
y
i want to
id name value x y
but there is no id from table 2 that is in table2.id and i want the
resource to bu something like this:
id(from table 1) name value (empty) (empty)
Jay Blanchard wrote:
[snip]
$sql =
[snip]
table1
id
name
value
table2
id
x
y
i want to
id name value x y
but there is no id from table 2 that is in table2.id and i want the
resource to bu something like this:
id(from table 1) name value (empty) (empty)
SELECT table2.*
FROM table1 LEFT OUTER JOIN table2
ON(table1.id =
[snip]
SELECT table1., *table2.*
FROM table1 LEFT OUTER JOIN table2
ON(table1.id = table2.id)
[/snip]
Oops, typo.
SELECT table1.*, table2.*
FROM table1 LEFT OUTER JOIN table2
ON(table1.id = table2.id)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
thanks a lot for your posting,
[cut]
Posted by Fred Mitchell on December 11 2004 2:47pm [Delete] [Edit]
Let's say you are doing a LEFT JOIN with a table that shares a column
name in common with another table, and that you are selecting for
instances where the join is missing, that is IS
I haven't thought about this much, but I'd probably create an onSubmit
handler, that would hide the form in an iframe, and create a new one. I
would then when they are online, submit all the forms.
This would require the user to keep the browser window open and at the same
page. Alternatively you
Hi,
Apologies if this is the wrong place for this question, but I'm sure there
are some experts out there who might be able to point me in the right
direction... :)
I'm doing some work at the moment where remote teams can submit reports
through to our database when connected over the internet to
[snip]
Apologies if this is the wrong place for this question, but I'm sure
there
are some experts out there who might be able to point me in the right
direction... :)
I'm doing some work at the moment where remote teams can submit reports
through to our database when connected over the internet
If your users are using Windows, then something like
http://www.hypervisual.com/winbinder/
might be good on the user side, as you can bundle the PHP binary and
everything else needed into one executable (with some work of course)
And then they can create a file formatted to your specifications
At 01:06 PM 4/7/2006, Kevin Davies - Bonhurst Consulting wrote:
Hi,
Apologies if this is the wrong place for this question, but I'm sure there
are some experts out there who might be able to point me in the right
direction... :)
I'm doing some work at the moment where remote teams can submit
chris said:
Time. Opening a db connection is time consuming. There are many levels
involved (making the connection, authentication, etc).. Even worse if
the connection is over tcp/ip because that overhead comes in on top as
well.
I replied:
Have you timed it?
Maybe I'll do that tomorrow.
On 4/3/06, tedd [EMAIL PROTECTED] wrote:
chris said:
Time. Opening a db connection is time consuming. There are many levels
involved (making the connection, authentication, etc).. Even worse if
the connection is over tcp/ip because that overhead comes in on top as
well.
I replied:
Have
chris said:
Just out of interest, could you re-run the test using persistent connections?
change mysql_connect to mysql_pconnect..
In doing so, the overall results dropped from a tenth of a second
difference between both methods to three-one-hundredths of a second
difference. In other
On Mon, April 3, 2006 1:33 pm, tedd wrote:
Just out of interest, could you re-run the test using persistent
connections?
change mysql_connect to mysql_pconnect..
In doing so, the overall results dropped from a tenth of a second
difference between both methods to three-one-hundredths of a
tedd wrote:
chris said:
Just out of interest, could you re-run the test using persistent
connections?
change mysql_connect to mysql_pconnect..
[snip]
Thanks -- does the persistent connection thing hold the server up
until released? How does that work?
MySQL is threaded so will not be
I always close the connection right after my
query -- force of habit. It's like leaving the
toilet seat up, it's only going to get you into
trouble.
So you close it after every query and then re-open it later for the
next query? I don't see that as a good idea.
No, you
tedd wrote:
I always close the connection right after my
query -- force of habit. It's like leaving the
toilet seat up, it's only going to get you into
trouble.
So you close it after every query and then re-open it later for the
next query? I don't see that as a good idea.
On 4/2/06, tedd [EMAIL PROTECTED] wrote:
I always close the connection right after my
query -- force of habit. It's like leaving the
toilet seat up, it's only going to get you into
trouble.
So you close it after every query and then re-open it later for the
next
At 11:07 AM +1200 4/2/06, Jasper Bryant-Greene wrote:
tedd wrote:
I always close the connection right after my
query -- force of habit. It's like leaving the
toilet seat up, it's only going to get you into
trouble.
So you close it after every query and then re-open it later
Time. Opening a db connection is time consuming. There are many levels
involved (making the connection, authentication, etc).. Even worse if
the connection is over tcp/ip because that overhead comes in on top as
well.
Have you timed it?
It would be interesting to actually run a script that
On Sat, 2006-04-01 at 20:15, tedd wrote:
Time. Opening a db connection is time consuming. There are many levels
involved (making the connection, authentication, etc).. Even worse if
the connection is over tcp/ip because that overhead comes in on top as
well.
Have you timed it?
It would
Robert Cummings wrote:
On Sat, 2006-04-01 at 20:15, tedd wrote:
It would be interesting to actually run a script that opens,
retrieves, and inserts data -- let's say 50k times. What's the time
difference between one open, 50k retrieves/inserts, and one close--
as compared 50k opens
On Sat, 2006-04-01 at 20:48, Jasper Bryant-Greene wrote:
Yeah, e.g. I have a database objects layer that means I only write SQL
in classes, everything else is just calling object methods. I create the
database object at the start of every script but that doesn't
necessarily open the
Robert Cummings wrote:
On Sat, 2006-04-01 at 20:48, Jasper Bryant-Greene wrote:
Yeah, e.g. I have a database objects layer that means I only write SQL
in classes, everything else is just calling object methods. I create the
database object at the start of every script but that doesn't
On Sat, 2006-04-01 at 21:39, Jasper Bryant-Greene wrote:
Robert Cummings wrote:
There's smart lazy programming, and sloppy lazy programming. I don't
trust anything magical in PHP. Most of us are familiar with the magic
quotes and global vars fiascos *LOL*. But hey, if you can squeeze a
Robert Cummings wrote:
On Sat, 2006-04-01 at 21:39, Jasper Bryant-Greene wrote:
Robert Cummings wrote:
There's smart lazy programming, and sloppy lazy programming. I don't
trust anything magical in PHP. Most of us are familiar with the magic
quotes and global vars fiascos *LOL*. But hey, if
On Sat, 2006-04-01 at 21:57, Jasper Bryant-Greene wrote:
Robert Cummings wrote:
Of course, it wouldn't exactly be a rewrite to make it close the
connection at the end of every script before PHP did, if I'm proven
wrong and it one day is necessary. I'd only need to change the database
Jasper Bryant-Greene wrote:
snip
I never close connections; PHP does that for me and has never caused any
problems doing that. I don't see it as sloppy programming, it is a
documented feature that PHP closes resources such as database
connections at the end of the script.
It's extremely
701 - 800 of 3625 matches
Mail list logo