php-general Digest 5 Aug 2003 13:40:00 -0000 Issue 2218
Topics (messages 158230 through 158279):
Re: Display Records in Multiple Pages help please !
158230 by: daniel.electroteque.org
158277 by: Justin French
Re: Regular Expression
158231 by: Curt Zirzow
Extracting Compressed Files
158232 by: Matt Palermo
158233 by: Matt Palermo
158234 by: Curt Zirzow
Handling DELETE requests
158235 by: Seairth Jacobs
158237 by: Curt Zirzow
158273 by: Seairth Jacobs
Re: Addin a column of numbers not using MySQL
158236 by: Jason Wong
PHP Fusebox
158238 by: Ralph Guzman
158239 by: daniel.electroteque.org
158240 by: Tariq Murtaza
158243 by: daniel.electroteque.org
158245 by: Alexandru COSTIN
158246 by: daniel.electroteque.org
158250 by: Joona Kulmala
checking how many records are returned?
158241 by: Amanda McComb
158242 by: Nadim Attari
Sum a column of values from a MySQL query
158244 by: Ben C.
158247 by: Giz
158249 by: Ben C.
158251 by: Jason Wong
158255 by: Ford, Mike [LSS]
158264 by: Ben C.
158266 by: Adam Alkins
158267 by: Jay Blanchard
158268 by: Jay Blanchard
158269 by: CPT John W. Holmes
158270 by: Jay Blanchard
Re: easier than switch
158248 by: Nicholas Robinson
Some SOAP samples
158252 by: Pascal Miquet
158261 by: Marek Kilimajer
Ezmlm Hash
158253 by: Eyles, Richard
Re: Values from forms
158254 by: Ford, Mike [LSS]
snippet
158256 by: Harry Wiens
158257 by: David Nicholson
158258 by: Jon Haworth
158259 by: David Nicholson
158260 by: imran
problem using unlink()
158262 by: James Brash
158278 by: Pascal Miquet
158279 by: Pascal Miquet
strange foreach behaviour
158263 by: Martin Peck
158265 by: Martin Peck
PHP/JavaScript/HTML
158271 by: Mauricio
158272 by: CPT John W. Holmes
Formatted text from mySQL DB
158274 by: PHPSpooky
158275 by: CPT John W. Holmes
158276 by: David Nicholson
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
100k = 100k records = 200 meg hehe
> a sample from my db class, i had to store the total in a session as
> calling the total on every page on a large database was painful doing
> count(*) or even SQL_CALC_FOUND_ROWS, on a small database u just cant
> tell but on a database of 100k + it was painful to load each page ;)
>
> function page_query($per_page, $query, $page, $session_var, $debug =
> null, $start_session = null) {
> if ($start_session) session_start();
> if(!$page) {
> $this->page = 1;
> $this->start = 0;
> } else {
> $this->page = $page;
> $this->start = ($this->page - 1) * $per_page;
> }
>
> if ((!$page && !$_SESSION[''.$session_var.'']) || (!
> $_SESSION[''.$session_var.''])) {
> $query = preg_replace("/SELECT|select/","\\0
> SQL_CALC_FOUND_ROWS",$query);
> $query = "$query LIMIT $this->start, $per_page";
> $result = $this->query($query);
> if ($debug) $this->debug();
> $row = $this->getOne("SELECT FOUND_ROWS() as
> total_rows");
> $_SESSION[''.$session_var.''] = $row['total_rows'];
> $this->total = $_SESSION[''.$session_var.''];
> } else {
> $query = "$query LIMIT $this->start, $per_page";
> $result = $this->query($query);
> if ($debug) $this->debug();
> $this->total = $_SESSION[''.$session_var.''];
> }
> $this->pages = ceil($this->total / $per_page);
> return $result;
> }
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
If you're using CGI/Perl, WHY WHY WHY are you asking questions on a PHP
list?
I've given you a hint, so perhaps take that hint and ask a question on
an Oracle list, or search the Oracle documentation for similar
functions.
Justin French
On Tuesday, August 5, 2003, at 10:37 PM, Coello, David wrote:
thank you for replying, good morning.
im using oracle 8. with cgi/perl
thank you david
-----Original Message-----
From: Justin French [mailto:[EMAIL PROTECTED]
Well, you haven't told us what database you're using at all, but I'll
assume MySQL. In which case you should look at the LIMIT part of your
query.
http://www.mysql.com/doc/en/SELECT.html
All you need to do is pass around a starting point variable on each
page, so that you know where the result for the next page of results
will start from (eg row 40 or 41 for page 3)
On Tuesday, August 5, 2003, at 02:53 AM, Coello, David wrote:
good afternoon i found a forum about displaying 25 records per page,
im using cgi and i need also to display only 25 records per page but i
want to be able to go to my next page and see the next 25 and so on...
the proble that im having is that i have a about 2000 records and the
query that i use calls all of them? how do i limit them
thank you david coello
--- End Message ---
--- Begin Message ---
* Thus wrote Ralph Guzman ([EMAIL PROTECTED]):
> Been working on this one for a while but can't get it working properly.
> I need a regular expression to match if address is
>
> 1. PO Box
> 2. P.O. Box
> 3. P.O.Box
>
> I'm using /i to make this case insensitive.
/p\.?o\.?\s*box/i
>
> I got it working with 1 & 2, but it's still not matching 3. Any
> suggestions?
>
> if(preg_match( "/p[\.]o\.* +box/i", trim($_POST['address'])){
> echo "Address is P.O. BOX";
> }
hmm.. if i read that right that will only match #2 (I'm not sure
that the [] includes a null match or not.) Also the character class
[] has special escapes, you dont need to escape the period because
the period is literal there.
there are other alternatives people might also type like:
p/o box
thus my original pattern becomes:
/p[.\\]?o\.?\s*box/i
HTH,
Curt
--
"I used to think I was indecisive, but now I'm not so sure."
--- End Message ---
--- Begin Message ---
Does anyone know of easy ways to be able to extract all
files/folders/subfolders from different types of compressed files (.zip,
.tar.gz, etc.)? If anyone could help me out with this, I would really
appreciate it.
Thanks,
Matt
--- End Message ---
--- Begin Message ---
Do you happen to know where I can find some examples or sample code for
these? The exec function on php.net didn't go into much detail about
extraction from compressed files. Anyone know of any good references?
Thanks,
Matt
-----Original Message-----
From: Jason Sheets [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 11:46 PM
To: Matt Palermo
Subject: Re: [PHP] Extracting Compressed Files
Use exec to execute the command line programs that deal with these
archives. Namely tar and gz and bzip2 and zip/unzip.
For single files that are compressed you can use PHP to decompress bzip2
and .gz files if you have compiled PHP --with-zlib and --with-bz2,
otherwise you must use the command line tools.
Jason
Matt Palermo wrote:
>Does anyone know of easy ways to be able to extract all
>files/folders/subfolders from different types of compressed files
(.zip,
>.tar.gz, etc.)? If anyone could help me out with this, I would really
>appreciate it.
>
>Thanks,
>
>Matt
>
>
>
--- End Message ---
--- Begin Message ---
* Thus wrote Matt Palermo ([EMAIL PROTECTED]):
> Does anyone know of easy ways to be able to extract all
> files/folders/subfolders from different types of compressed files (.zip,
> .tar.gz, etc.)? If anyone could help me out with this, I would really
> appreciate it.
man unzip
man tar
man <put decompression tool here>
if you dont have shell acess google will yeild results for those
man pages.
Curt
--
"I used to think I was indecisive, but now I'm not so sure."
--- End Message ---
--- Begin Message ---
Under Apache 1.3, how can I respond to DELETE request with a PHP script? I
have no problem with GET, POST, or PUT. The only thing I found was the
"Scripts" directive, but that requires a specic script to be named. I am
looking for something more generic, possibly where I can just say that php
scripts can accept DELETE requests.
Any suggestions?
---
Seairth Jacobs
[EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
* Thus wrote Seairth Jacobs ([EMAIL PROTECTED]):
> Under Apache 1.3, how can I respond to DELETE request with a PHP script? I
> have no problem with GET, POST, or PUT. The only thing I found was the
> "Scripts" directive, but that requires a specic script to be named. I am
> looking for something more generic, possibly where I can just say that php
> scripts can accept DELETE requests.
hmm.. I've never seen the DELETE method used anywhere, and probably
for good reason. By default you cant use this method with apache
and I'm not sure if you can enable it without recompiling it or
getting a patch that enables it.
Now if you do enable the method, it is rather undefined on how it
would be handled by php. According to some documentation I found
(w3c) is:
<quote>
DELETE
Requests that the server delete the information corresponding to
the given URL. After a successfull DELETE method, the URL becomes
invalid for any future methods.
</quote>
If the client issues a 'DELETE /file.php' will the server delete
the php file and make it unusable. Or will it pass the Request to
php. If the latter happens then my assumption is that it will be like
a GET request but the $REQUEST_METHOD variable will be 'DELETE'
instead of 'GET'. And you program can act accordingly.
Now with that said, the common way to simulate a DELETE method is
by using GET with query paramaters telling you that this request want
to really delete something.
HTH,
Curt
--
"I used to think I was indecisive, but now I'm not so sure."
--- End Message ---
--- Begin Message ---
"Curt Zirzow" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> * Thus wrote Seairth Jacobs ([EMAIL PROTECTED]):
> > Under Apache 1.3, how can I respond to DELETE request with a PHP script?
I
> > have no problem with GET, POST, or PUT. The only thing I found was the
> > "Scripts" directive, but that requires a specic script to be named. I
am
> > looking for something more generic, possibly where I can just say that
php
> > scripts can accept DELETE requests.
>
> hmm.. I've never seen the DELETE method used anywhere, and probably
> for good reason. By default you cant use this method with apache
> and I'm not sure if you can enable it without recompiling it or
> getting a patch that enables it.
Yes, Mod_Actions allows this functionality, but this ability is a "blanket
statement"-style directive, where *all* DELETE requests would go to the same
single script, regardless of what the DELETE was for.
> Now if you do enable the method, it is rather undefined on how it
> would be handled by php. According to some documentation I found
> (w3c) is:
>
> <quote>
> DELETE
> Requests that the server delete the information corresponding to
> the given URL. After a successfull DELETE method, the URL becomes
> invalid for any future methods.
> </quote>
>
> If the client issues a 'DELETE /file.php' will the server delete
> the php file and make it unusable. Or will it pass the Request to
> php. If the latter happens then my assumption is that it will be like
> a GET request but the $REQUEST_METHOD variable will be 'DELETE'
> instead of 'GET'. And you program can act accordingly.
Well, the argument could be made for PUT as well. Should the server PUT a
new copy of the PHP file, or pass the PUT on to the PHP file for processing?
Currently, the default behaviour is to pass the request on to the script,
which is what I would expect and what I want for DELETE as well. My
application has a single entry-point script with its own maintained
sub-paths. Such a DELETE request would inform that script to delete the
names subpath (or return the appropriate HTTP response... likely 405).
> Now with that said, the common way to simulate a DELETE method is
> by using GET with query paramaters telling you that this request want
> to really delete something.
In general, this is not a good design. GETs are not supposed to cause
side-effects. Use of POST to a given URI's container URI would be a better
alternative.
Still, it's a shame that all the HTTP verbs are not better supported, as
more applications are beginning to use them (finally). It's just that most
people think the only HTTP client is the Web browser, which is not true
anymore.
Thanks for the reply.
---
Seairth Jacobs
[EMAIL PROTECTED]
--- End Message ---
--- Begin Message ---
On Tuesday 05 August 2003 04:01, Ben C. wrote:
> It still returns '0'. I think we are missing something. Any other ideas?
> Anyone else have any ideas?
My ideas are:
1) turn on FULL error reporting
2) print out all your variables at every step
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
------------------------------------------
/*
America!! I saw it all!! Vomiting! Waving! JERRY FALWELLING into
your void tube of UHF oblivion!! SAFEWAY of the mind ...
*/
--- End Message ---
--- Begin Message ---
I am trying to standardize my development process and have been looking
at the different frameworks out there.
One of the philosophies I like is that of Fusebox, although originally
developed for ColdFusion it is now available for PHP:
http://bombusbee.com/
Anybody have any experience working with Fusebox, or can anybody
recommend any other frameworks that I should also look at? I am looking
for a framework that will be developed going into PHP 5 also.
Your help is appreciated.
Ralph
--- End Message ---
--- Begin Message ---
i have used this before , its a wierd system and you have to echo the html
absolutely painful
> I am trying to standardize my development process and have been looking
> at the different frameworks out there.
>
> One of the philosophies I like is that of Fusebox, although originally
> developed for ColdFusion it is now available for PHP:
>
> http://bombusbee.com/
>
> Anybody have any experience working with Fusebox, or can anybody
> recommend any other frameworks that I should also look at? I am looking
> for a framework that will be developed going into PHP 5 also.
>
> Your help is appreciated.
>
> Ralph
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hi Ralph!
I suggest MVC.
http://phrame.sourceforge.net/
http://www.phpmvc.net/
Regards,
TM.
Ralph Guzman wrote:
I am trying to standardize my development process and have been looking
at the different frameworks out there.
One of the philosophies I like is that of Fusebox, although originally
developed for ColdFusion it is now available for PHP:
http://bombusbee.com/
Anybody have any experience working with Fusebox, or can anybody
recommend any other frameworks that I should also look at? I am looking
for a framework that will be developed going into PHP 5 also.
Your help is appreciated.
Ralph
--- End Message ---
--- Begin Message ---
ok i have a standard of executing things i use a switch case to switch $_GET
['action'] , so i can have ?action=add_entry ?action=edit ?action=insert ?
action=update ?action=delete etc .. this works well for a cms system
> Hi Ralph!
>
> I suggest MVC.
>
> http://phrame.sourceforge.net/
> http://www.phpmvc.net/
>
> Regards,
> TM.
>
> Ralph Guzman wrote:
>
>>I am trying to standardize my development process and have been looking
>>at the different frameworks out there.
>>
>>One of the philosophies I like is that of Fusebox, although originally
>>developed for ColdFusion it is now available for PHP:
>>
>>http://bombusbee.com/
>>
>>Anybody have any experience working with Fusebox, or can anybody
>>recommend any other frameworks that I should also look at? I am looking
>>for a framework that will be developed going into PHP 5 also.
>>
>>Your help is appreciated.
>>
>>Ralph
>>
>>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Hello,
You could also take a look at Krysalis Foundation -
http://www.interakt.ro/products/Krysalis/
It implements the MVC approach by defining a sitemap with the request
serving rules, and by separating the model from the view using XML trees as
the output of the model and XSL to add the presentation layer over it.
Alexandru
--
Alexandru COSTIN
Chief Operating Officer
http://www.interakt.ro/
+4021 312 5312
"Tariq Murtaza" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi Ralph!
>
> I suggest MVC.
>
> http://phrame.sourceforge.net/
> http://www.phpmvc.net/
>
> Regards,
> TM.
>
> Ralph Guzman wrote:
>
> >I am trying to standardize my development process and have been looking
> >at the different frameworks out there.
> >
> >One of the philosophies I like is that of Fusebox, although originally
> >developed for ColdFusion it is now available for PHP:
> >
> >http://bombusbee.com/
> >
> >Anybody have any experience working with Fusebox, or can anybody
> >recommend any other frameworks that I should also look at? I am looking
> >for a framework that will be developed going into PHP 5 also.
> >
> >Your help is appreciated.
> >
> >Ralph
> >
> >
>
>
--- End Message ---
--- Begin Message ---
really tedious logic
> Hello,
> You could also take a look at Krysalis Foundation -
> http://www.interakt.ro/products/Krysalis/
>
> It implements the MVC approach by defining a sitemap with the
> request
> serving rules, and by separating the model from the view using XML
> trees as the output of the model and XSL to add the presentation layer
> over it.
>
> Alexandru
>
> --
> Alexandru COSTIN
> Chief Operating Officer
> http://www.interakt.ro/
> +4021 312 5312
> "Tariq Murtaza" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
>> Hi Ralph!
>>
>> I suggest MVC.
>>
>> http://phrame.sourceforge.net/
>> http://www.phpmvc.net/
>>
>> Regards,
>> TM.
>>
>> Ralph Guzman wrote:
>>
>> >I am trying to standardize my development process and have been
>> >looking at the different frameworks out there.
>> >
>> >One of the philosophies I like is that of Fusebox, although
>> >originally developed for ColdFusion it is now available for PHP:
>> >
>> >http://bombusbee.com/
>> >
>> >Anybody have any experience working with Fusebox, or can anybody
>> >recommend any other frameworks that I should also look at? I am
>> >looking for a framework that will be developed going into PHP 5 also.
>> >
>> >Your help is appreciated.
>> >
>> >Ralph
>> >
>> >
>>
>>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
Ralph Guzman wrote:
I am trying to standardize my development process and have been looking
at the different frameworks out there.
One of the philosophies I like is that of Fusebox, although originally
developed for ColdFusion it is now available for PHP:
http://bombusbee.com/
Anybody have any experience working with Fusebox, or can anybody
recommend any other frameworks that I should also look at? I am looking
for a framework that will be developed going into PHP 5 also
Hi,
I don't know about Fusebox, but recommend Web Application Framework
called phpWebCore. This is simple and powerfull framework which has
ADOdb and Smarty implemented.
I've been also developing one whole summer in company I'm working for,
but maybe I'll release Open Source framework on my own later on.
You can find phpWebCore from:
http://phpwebcore.php
Cheers, Joona
--
Joona Kulmala <[EMAIL PROTECTED]>
PHP Finland
--- End Message ---
--- Begin Message ---
Is there a way to check how many records are returned from a query to the
database?
--- End Message ---
--- Begin Message ---
> Is there a way to check how many records are returned from a query to the
> database?
Which database? MsSQL? mySQL? mSQL? PostgreSQL? .... ?????
If it's mySQL then try mysql_num_rows
--- End Message ---
--- Begin Message ---
I am trying to sum a query of values from a MySQL table. The code I am
using is:
---BEGIN CODE #1--------------
$sql_2 = "SELECT SUM(partpaidamount) as partpaid
FROM $tb_name
WHERE invoiceid = \"$invoiceid\"
";
$result_2 = @mysql_query($sql_2,$connection) or die(mysql_error());
while ($row = mysql_fetch_array($result_2)) {
$invoicepartpaid = $row['partpaid'];
}
---END CODE #2----------------
1) The code returns the sum of a partially paid invoice. The individual
invoice is 'partpaid'. WORKS...NO PROBLEM
2) The while() then return a list of partially paid invoices which is
$invoicepartpaid. WORKS..NO PROBLEM
3) I then want to add the list of partially paid invoices ($invoicepartpaid)
together. I AM STUCK HERE ADDING THE INVOICES AMOUNTS TOGETHER.
If anyone can help I would greatly appreciate it.
--- End Message ---
--- Begin Message ---
I think you're a big confused here. Your query will only return one row,
because you're using sum(). $invoicepartpaid will be your total for the
invoiceid specified.
-----Original Message-----
From: Ben C. [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 11:42 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Sum a column of values from a MySQL query
I am trying to sum a query of values from a MySQL table. The code I am
using is:
---BEGIN CODE #1--------------
$sql_2 = "SELECT SUM(partpaidamount) as partpaid
FROM $tb_name
WHERE invoiceid = \"$invoiceid\"
";
$result_2 = @mysql_query($sql_2,$connection) or die(mysql_error());
while ($row = mysql_fetch_array($result_2)) {
$invoicepartpaid = $row['partpaid'];
}
---END CODE #2----------------
--- End Message ---
--- Begin Message ---
Yes, I know. However, the while() loop should generate all the invoice in a
list.
-----Original Message-----
From: Giz [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 12:03 AM
To: 'Ben C.'; [EMAIL PROTECTED]
Subject: RE: [PHP] Sum a column of values from a MySQL query
I think you're a big confused here. Your query will only return one row,
because you're using sum(). $invoicepartpaid will be your total for the
invoiceid specified.
-----Original Message-----
From: Ben C. [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 11:42 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Sum a column of values from a MySQL query
I am trying to sum a query of values from a MySQL table. The code I am
using is:
---BEGIN CODE #1--------------
$sql_2 = "SELECT SUM(partpaidamount) as partpaid
FROM $tb_name
WHERE invoiceid = \"$invoiceid\"
";
$result_2 = @mysql_query($sql_2,$connection) or die(mysql_error());
while ($row = mysql_fetch_array($result_2)) {
$invoicepartpaid = $row['partpaid'];
}
---END CODE #2----------------
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
On Tuesday 05 August 2003 15:43, Ben C. wrote:
> Yes, I know. However, the while() loop should generate all the invoice in
> a list.
As has been pointed out the query only results in a single row. So how would
the while-loop "generate all the invoice[s]"? It's only ever given a single
row to play with.
And has also been pointed out, could you state clearly:
- what exactly you're trying to do
- what your database schema is
- what you tried that didn't work, and *how* it didn't work
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
------------------------------------------
/*
I appoint you ambassador to Fantasy Island!!!
*/
--- End Message ---
--- Begin Message ---
> -----Original Message-----
> From: Ben C. [mailto:[EMAIL PROTECTED]
> Sent: 05 August 2003 07:42
>
> I am trying to sum a query of values from a MySQL table. The
> code I am
> using is:
>
> ---BEGIN CODE #1--------------
> $sql_2 = "SELECT SUM(partpaidamount) as partpaid
> FROM $tb_name
> WHERE invoiceid = \"$invoiceid\"
> ";
>
> $result_2 = @mysql_query($sql_2,$connection) or die(mysql_error());
>
> while ($row = mysql_fetch_array($result_2)) {
> $invoicepartpaid = $row['partpaid'];
> }
> ---END CODE #2----------------
>
> 1) The code returns the sum of a partially paid invoice. The
> individual
> invoice is 'partpaid'. WORKS...NO PROBLEM
That's a very confusing description -- what do you mean by "sum of a
partially paid invoce"? What you're getting is the sum of partpaidamount
for all invoices with the given invoiceid -- although how you can have more
than one invoice with the same invoiceid beats me!
> 2) The while() then return a list of partially paid invoices which is
> $invoicepartpaid. WORKS..NO PROBLEM
No, wrong -- it can't and doesn't return a list, since the query above will
return a *single* value -- the sum of partpaidamount for the selected
invoices. That's one row with one value in it.
> 3) I then want to add the list of partially paid invoices
> ($invoicepartpaid)
> together. I AM STUCK HERE ADDING THE INVOICES AMOUNTS TOGETHER.
But you've already added the partially paid invoice amount together with
your "SELECT SUM(partpaidamount) -- why are you trying to do it again?
There seems to be a fundamental problem here somewhere -- why don't you go
right back to the beginning and describe:
(1) The table you are selecting from (fieldnames, what they contain, etc.).
(2) Exactly what you are trying to extract from it, using what criteria.
(3) Which exact values from that you want to add together.
(4) and what you expect the final result to be.
Then we might all be starting from a level playing field in terms of
understanding exactly what you're trying to do (and if not, someone will be
sure to ask further questions!).
Cheers!
Mike
---------------------------------------------------------------------
Mike Ford, Electronic Information Services Adviser,
Learning Support Services, Learning & Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Beckett Park, LEEDS, LS6 3QS, United Kingdom
Email: [EMAIL PROTECTED]
Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211
--- End Message ---
--- Begin Message ---
I am trying to sum a query of values from a MySQL table. The code I am
using is:
---BEGIN CODE #1--------------
$sql_2 = "SELECT SUM(partpaidamount) as partpaid
FROM $tb_name
WHERE invoiceid = \"$invoiceid\"
";
$result_2 = @mysql_query($sql_2,$connection) or die(mysql_error());
while ($row = mysql_fetch_array($result_2)) {
$invoicepartpaid = $row['partpaid'];
}
---END CODE #2----------------
1) The code returns the sum of a partially paid invoice. The individual
invoice is 'partpaid'. WORKS...NO PROBLEM
2) The while() then return a list of partially paid invoices which is
$invoicepartpaid. WORKS..NO PROBLEM
3) I then want to add the list of partially paid invoices ($invoicepartpaid)
together. I AM STUCK HERE ADDING THE INVOICES AMOUNTS TOGETHER.
If anyone can help I would greatly appreciate it.
--------------------------------------------------------------------------
The content of this email message and any attachments are confidential and
may be legally privileged, intended solely for the addressee. If you are
not the intended recipient, be advised that any use, dissemination,
distribution, or copying of this e-mail is strictly prohibited. If you
receive this message in error, please notify the sender immediately by reply
email and destroy the message and its attachments.
--- End Message ---
--- Begin Message ---
Quoting "Ben C." <[EMAIL PROTECTED]>:
> I am trying to sum a query of values from a MySQL table. The code I am
> using is:
>
> ---BEGIN CODE #1--------------
> $sql_2 = "SELECT SUM(partpaidamount) as partpaid
> FROM $tb_name
> WHERE invoiceid = \"$invoiceid\"
> ";
>
> $result_2 = @mysql_query($sql_2,$connection) or die(mysql_error());
>
> while ($row = mysql_fetch_array($result_2)) {
> $invoicepartpaid = $row['partpaid'];
> }
> ---END CODE #2----------------
>
> 1) The code returns the sum of a partially paid invoice. The individual
> invoice is 'partpaid'. WORKS...NO PROBLEM
> 2) The while() then return a list of partially paid invoices which is
> $invoicepartpaid. WORKS..NO PROBLEM
> 3) I then want to add the list of partially paid invoices ($invoicepartpaid)
> together. I AM STUCK HERE ADDING THE INVOICES AMOUNTS TOGETHER.
Well, instead of doing $invoicepartpaid = $row['partpaid']; you could do
$invoicepartpaid += $row['partpaid']; which will just add $row['partpaid'] to
$invoicepartpaid, not replace it.
However, why not just SUM all the rows in the table in the query if you just
want a total?
$sql_2 = "SELECT SUM(partpaidamount) as partpaid FROM $tb_name";
--
Adam Alkins
http://www.rasadam.com
--- End Message ---
--- Begin Message ---
[snip]
However, why not just SUM all the rows in the table in the query if you
just
want a total?
$sql_2 = "SELECT SUM(partpaidamount) as partpaid FROM $tb_name";
[/snip]
That is what he is doing. The SELECT SUM will only return ONE row! I am
not sure that the problem is being explained clearly though.
--- End Message ---
--- Begin Message ---
[snip]
1) The code returns the sum of a partially paid invoice. The individual
invoice is 'partpaid'. WORKS...NO PROBLEM
2) The while() then return a list of partially paid invoices which is
$invoicepartpaid. WORKS..NO PROBLEM
3) I then want to add the list of partially paid invoices
($invoicepartpaid)
together. I AM STUCK HERE ADDING THE INVOICES AMOUNTS TOGETHER.
[/snip]
Ben...do you want to add together invoices where each ID is different?
Is that right? If so I have the answer! You need to loop through the
ID's which you are not doing....I have taken your code and added to
it....(and made changes for clarity in the e-amil)
//get invoice id's
$sql_1 = "SELECT DISTINCT(invoiceid) as inid FROM $tb_name ";
$result_1 = mysql_query($sql_1, $connection) or die(mysql_error());
while($idinvoice = mysql_fetch_array($result_1)){
// get partial paid for THIS invoice
$sql_2 = "SELECT SUM(partpaidamount) as partpaid ";
$sql_2 .= "FROM $tb_name ";
$sql_2 .= "WHERE invoiceid = '" . $idinvoice['inid'] . "' ";
$result_2 = @mysql_query($sql_2,$connection) or die(mysql_error());
//you will only be returning ONE row, so no need for while loop
$row = mysql_fetch_array($result_2);
$invoicepartpaid = $row['partpaid'];
$total = $total + $invoicepartpaid;
} // loop to NEXT invoice
print(number_format($total, 2, '', ','). "\n");
Does this make sense? You must loop through each ID and query for that
ID's partial amount.
--- End Message ---
--- Begin Message ---
Sorry, Jay, but that's a horrible method. You could just run one query with
a GROUP BY clause to get the sum for each invoiceID, instead of running
multiple queries like you've mentioned...
$query = "SELECT invoiceid, SUM(partpaidamount) AS partpaid FROM $tb_name
GROUP BY invoiceid";
$rs = mysql_query($query) or die(mysql_error());
while($r = mysql_fetch_assoc($rs))
{ echo "Invoice: {$r['invoiceid']}, SUM: {$r['partpaid']}"; }
---John Holmes...
PS: Sorry for the top post, but I'm at work and outlook express sucks. :)
----- Original Message -----
From: "Jay Blanchard" <[EMAIL PROTECTED]>
To: "Ben C." <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, August 05, 2003 8:29 AM
Subject: RE: [PHP] Sum a column of values from a MySQL query
[snip]
1) The code returns the sum of a partially paid invoice. The individual
invoice is 'partpaid'. WORKS...NO PROBLEM
2) The while() then return a list of partially paid invoices which is
$invoicepartpaid. WORKS..NO PROBLEM
3) I then want to add the list of partially paid invoices
($invoicepartpaid)
together. I AM STUCK HERE ADDING THE INVOICES AMOUNTS TOGETHER.
[/snip]
Ben...do you want to add together invoices where each ID is different?
Is that right? If so I have the answer! You need to loop through the
ID's which you are not doing....I have taken your code and added to
it....(and made changes for clarity in the e-amil)
//get invoice id's
$sql_1 = "SELECT DISTINCT(invoiceid) as inid FROM $tb_name ";
$result_1 = mysql_query($sql_1, $connection) or die(mysql_error());
while($idinvoice = mysql_fetch_array($result_1)){
// get partial paid for THIS invoice
$sql_2 = "SELECT SUM(partpaidamount) as partpaid ";
$sql_2 .= "FROM $tb_name ";
$sql_2 .= "WHERE invoiceid = '" . $idinvoice['inid'] . "' ";
$result_2 = @mysql_query($sql_2,$connection) or die(mysql_error());
//you will only be returning ONE row, so no need for while loop
$row = mysql_fetch_array($result_2);
$invoicepartpaid = $row['partpaid'];
$total = $total + $invoicepartpaid;
} // loop to NEXT invoice
print(number_format($total, 2, '', ','). "\n");
Does this make sense? You must loop through each ID and query for that
ID's partial amount.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
[snip]
Sorry, Jay, but that's a horrible method. You could just run one query
with
a GROUP BY clause to get the sum for each invoiceID, instead of running
multiple queries like you've mentioned...
$query = "SELECT invoiceid, SUM(partpaidamount) AS partpaid FROM
$tb_name
GROUP BY invoiceid";
$rs = mysql_query($query) or die(mysql_error());
while($r = mysql_fetch_assoc($rs))
{ echo "Invoice: {$r['invoiceid']}, SUM: {$r['partpaid']}"; }
---John Holmes...
PS: Sorry for the top post, but I'm at work and outlook express sucks.
:)
[/snip]
No problem bro'. I knew it was the long way around I was trying to
understand if that was what Ben wanted. And I am so old school that
almost always avoid ternary! :) And I feel for you....Express...blech!
--- End Message ---
--- Begin Message ---
As, in this case, only one of the variables is non-null, then you could use
the string concatenation operator and this would return what you want.
i.e. type = $_POST['news'] . $_POST['dreams'] . $_POST['storys']...
I think I've used the same variable name in different forms on the same page,
as only one form submission occurs at any one time there can't be a conflict
and PHP doesn't care where the POST'ed variable came from.. So, you could
rename news, dreams, etc. to be type and extract the result directly without
having to fiddle around.
HTH
Nick
On Monday 04 Aug 2003 11:19 pm, skate wrote:
> okay, so i know there's an easy way to do this, and i've seen it done, sure
> of it. so please forgive the stupidity of my question, i don't even know
> where to begin to look in the archives either...
>
> i have several forms on one page, they all submit a different variable, i
> then want to set one variable depending on that... okay, now i'm confusing
> myself, lets try explain it with some code...
>
> <?
>
> if(isset($_POST))
> {
> $type = $_POST['news'] || $_POST['dreams'] || $_POST['storys'] ||
> $_POST['words'] || $_POST['chat']; }
>
> ?>
>
> obviously this doesn't work. but i wanna set $type depending on which
> $_POST variable was sent. only one of these will ever be sent. rather than
> doing a big ass switch statement, is there no way i can get this into one
> line?
>
> i hope this isn't too confusing...
--- End Message ---
--- Begin Message ---
Hello,
I'm looking for PHP/SOAP Samples. Where should I found some ?
Thanks for your help.
Regards
Pascal Miquet
--- End Message ---
--- Begin Message ---
google -> PHP/SOAP Samples
Pascal Miquet wrote:
Hello,
I'm looking for PHP/SOAP Samples. Where should I found some ?
Thanks for your help.
Regards
Pascal Miquet
--- End Message ---
--- Begin Message ---
Hi,
I'm looking for a function to convert an email address to the file name hash
in ezmlm. I've found the ezmlm_hash function but this is for mysql based
mailing lists and not file based.
I've tried looking at the source for ezmlm and converting the code there to
php but I've never used c or the like and don't fully understand what it is
doing!
Can anyone help please?
Thank you
Richard
--
Richard Eyles
Principal Pharmacist Computer Services
Portsmouth Hospitals NHS Trust 023 9237 2923 / Ext 5283
--- End Message ---
--- Begin Message ---
> -----Original Message-----
> From: Beauford.2005 [mailto:[EMAIL PROTECTED]
> Sent: 05 August 2003 00:36
>
> Thanks for the info. The first suggestion doesn't work,
The first suggestion does work -- I've used it more than once in the past.
If it doesn't work for you, you're doing something wrong. But the array
solution is better.
> and the second
> may work - but the problem is I need the array to start at '1' - and
> arrays in general start at 0.
PHP arrays start wherever they start -- by default, if you don't specify
otherwise, they start at 0, but they can "start" with anything (e.g.
array('foo'=>'bar', 'plugh'=>'xyzzy') starts at 'foo') -- so if you want one
to start at 1 then just start it at 1.
Cheers!
Mike
---------------------------------------------------------------------
Mike Ford, Electronic Information Services Adviser,
Learning Support Services, Learning & Information Services,
JG125, James Graham Building, Leeds Metropolitan University,
Beckett Park, LEEDS, LS6 3QS, United Kingdom
Email: [EMAIL PROTECTED]
Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211
--- End Message ---
--- Begin Message ---
can someone explain this for me:
...
$sFont =submit("font") ? SITE_ROOT . PROG_PATH . submit("font") : "";
...
mfg.
hwiens
--- End Message ---
--- Begin Message ---
** CORRECTION BELOW **
Hello,
This is a reply to an e-mail that you wrote on Tue, 5 Aug 2003 at
11:14, lines prefixed by '>' were originally written by you.
> $sFont =submit("font") ? SITE_ROOT . PROG_PATH .
submit("font") : "";
it is the same as:
if(submit("font")){
$sFont = SITE_ROOT . PROG_PATH;
} else {
$sFont = "";
}
(see http://uk.php.net/language.operators.comparison)
submit() is a user defined function, if it evaluates to **TRUE**
then
$sFont will contain the value of those two constants put togetherm
otherwise it will be set to an empty string.
HTH
David.
--
phpmachine :: The quick and easy to use service providing you with
professionally developed PHP scripts :: http://www.phpmachine.com/
Free PHP error handling script: www.phpmachine.com/error-handler/
Professional Web Development by David Nicholson
http://www.djnicholson.com/
QuizSender.com - How well do your friends actually know you?
http://www.quizsender.com/
--- End Message ---
--- Begin Message ---
Hi Harry,
> can someone explain this for me:
> ...
> $sFont =submit("font") ? SITE_ROOT . PROG_PATH . submit("font") : "";
> ...
It's called the "ternary operator", and it's a shorthand for if...else...
The line you're asking about is equivalent to:
if (submit("font")) {
$sFont = SITE_ROOT . PROG_PATH . submit("font");
} else {
$sFont = "";
}
The format is:
(condition to check) ? (result if true) : (result if false);
Cheers
Jon
--- End Message ---
--- Begin Message ---
Hello,
This is a reply to an e-mail that you wrote on Tue, 5 Aug 2003 at
11:14, lines prefixed by '>' were originally written by you.
> $sFont =submit("font") ? SITE_ROOT . PROG_PATH .
submit("font") : "";
it is the same as:
if(submit("font")){
$sFont = SITE_ROOT . PROG_PATH;
} else {
$sFont = "";
}
(see http://uk.php.net/language.operators.comparison)
submit() is a user defined function, if it evaluates to false then
$sFont will contain the value of those two constants put togetherm
otherwise it will be set to an empty string.
HTH
David.
--
phpmachine :: The quick and easy to use service providing you with
professionally developed PHP scripts :: http://www.phpmachine.com/
Free PHP error handling script: www.phpmachine.com/error-handler/
Professional Web Development by David Nicholson
http://www.djnicholson.com/
QuizSender.com - How well do your friends actually know you?
http://www.quizsender.com/
--- End Message ---
--- Begin Message ---
hi
It is a Ternary Operator, Often you can avoid large if/else statements in
your code by using the ternary operator. For example:
echo "You have $i ". ($i==1 ? "message" : "messages"). " in your box.\n";
Note: "? : " operator has this syntax "expr ? expr : expr;"
imran
----- Original Message -----
From: "Harry Wiens" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 05, 2003 3:26 PM
Subject: [PHP] snippet
> can someone explain this for me:
> ...
> $sFont =submit("font") ? SITE_ROOT . PROG_PATH . submit("font") : "";
> ...
>
> mfg.
> hwiens
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
Hi,
I have a problem using unlink(); on a system using FreeBSD and Apache...
where my local system using Windows and Apache experiences no problems.
<?
unlink("test1.php");
?>
On the windows system is deletes the file, but on the FBSD system the file
does not delete and returns no error. I have tried using the full path, and
CHMODing the files but no luck. Thanks for any help/advice you can give me.
James Brash
--- End Message ---
--- Begin Message ---
Hello,
I'd suggest to have a look at your php.ini and see the value of some
execute external commands. Don't remember exactly the name of this flag.
HTH
Regards
Pascal Miquet
Le mar 05/08/2003 à 13:53, James Brash a écrit :
>
> Hi,
> I have a problem using unlink(); on a system using FreeBSD and Apache...
> where my local system using Windows and Apache experiences no problems.
>
> <?
> unlink("test1.php");
> ?>
>
> On the windows system is deletes the file, but on the FBSD system the file
> does not delete and returns no error. I have tried using the full path, and
> CHMODing the files but no luck. Thanks for any help/advice you can give me.
>
> James Brash
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
I think that the safe mode is on
But no executables into the safe_mode_exec_dir
beware if you set the safe mode to OFF. This is my value, but my server
is in a safe place.
HTH
Regards
--- End Message ---
--- Begin Message ---
I have come up against a very strange problem. I currently have no idea how
to even approach attempting to fix it...
--- End Message ---
--- Begin Message ---
My apologies for the last post - somehow managed to send whilst attempting
to copy and paste... d'oh.
I'd like to try again.
I have come up against a very strange problem. I currently have no idea how
to even approach attempting to fix it...
In the following code snippet, $this->items is an array of objects - each of
these objects is one of two object types (with similar interfaces). There
is nothing that unusual in the these few lines:
foreach ($this->items as $code => $item) {
var_dump($this->items[$code]);
var_dump($item);
etc.
}
but after successfully calling this piece of code a number of times in my
application, I get the following output:
object(citem)(2) {
["q"]=>
int(1)
["c"]=>
string(3) "157"
}
NULL
Fatal error: Call to a member function on a non-object in
/var/www/local/ge/include/product.php4 on line 58
I have no comprehension how it is that the two var_dump() commands can
produce different outputs. Can anyone suggest what sort of thing I need to
be looking at?!
Any help very gratefully received,
regards,
Martin
--- End Message ---
--- Begin Message ---
Hello folks
I wrote a JavaScript to set the values of a Select html object by client
side. The values are copied from another Select that I create getting the
values from the database. After the user set the values he/she wants to add
it in another form, for example, then press submit button, the values of the
"user" Select object doesn't appears on the next page. What can I do to get
the user selected values in the another page?
Someone could help me?
Thanks!
.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Maurício Alegre Valente
AGP5 Tecnologia da Informação Ltda.
(48) 439-3004
Visite nosso site: www.agp5.com.br
.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
----- Original Message -----
From: "Nicholas Robinson" <[EMAIL PROTECTED]>
To: "skate" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, August 05, 2003 4:26 AM
Subject: Re: [PHP] easier than switch
> As, in this case, only one of the variables is non-null, then you could
use
> the string concatenation operator and this would return what you want.
>
> i.e. type = $_POST['news'] . $_POST['dreams'] . $_POST['storys']...
>
> I think I've used the same variable name in different forms on the same
page,
> as only one form submission occurs at any one time there can't be a
conflict
> and PHP doesn't care where the POST'ed variable came from.. So, you could
> rename news, dreams, etc. to be type and extract the result directly
without
> having to fiddle around.
>
> HTH
>
> Nick
>
> On Monday 04 Aug 2003 11:19 pm, skate wrote:
> > okay, so i know there's an easy way to do this, and i've seen it done,
sure
> > of it. so please forgive the stupidity of my question, i don't even know
> > where to begin to look in the archives either...
> >
> > i have several forms on one page, they all submit a different variable,
i
> > then want to set one variable depending on that... okay, now i'm
confusing
> > myself, lets try explain it with some code...
> >
> > <?
> >
> > if(isset($_POST))
> > {
> > $type = $_POST['news'] || $_POST['dreams'] || $_POST['storys'] ||
> > $_POST['words'] || $_POST['chat']; }
> >
> > ?>
> >
> > obviously this doesn't work. but i wanna set $type depending on which
> > $_POST variable was sent. only one of these will ever be sent. rather
than
> > doing a big ass switch statement, is there no way i can get this into
one
> > line?
> >
> > i hope this isn't too confusing...
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
From: "Mauricio" <[EMAIL PROTECTED]>
> I wrote a JavaScript to set the values of a Select html object by client
> side. The values are copied from another Select that I create getting the
> values from the database. After the user set the values he/she wants to
add
> it in another form, for example, then press submit button, the values of
the
> "user" Select object doesn't appears on the next page. What can I do to
get
> the user selected values in the another page?
Well, if I understand that correctly, you need to use Javascript to "select"
all of the options that the user selected to add to the second select box.
If they aren't selected, then they won't be passed to the next page.
---John Holmes...
--- End Message ---
--- Begin Message ---
Astrum Et Securis!
I had a question..
When I create any field and let data be sent into my mySQL DB through
it.. it goes ok. But when I retrieve it.. the data comes completely
unformatted.
That is.. let's say I fed this in a textarea..
The
Man
Is
Cool.
If I view the data from my phpMyAdmin or even Command Line mySQL.. the
data has gone just this way..
But when I use mysql_fetch_array() to get the data back from mySQL, it
prints as ..
The Man Is Cool.
The newline disappears, and I have to use <br>'s while feeding the data
to have the line gaps. What am I doing wrong?
Following is an example code of what I use..
<?
while ($result = mysql_fetch_array($query)) {
echo "
$result[data] <br>
";
}
?>
If the data stored in 'data' was multiple lines.. I would get one single
line from the Database.. not as I had sent it in.
Dominor!
PHPSpooky
--- End Message ---
--- Begin Message ---
From: "PHPSpooky" <[EMAIL PROTECTED]>
> When I create any field and let data be sent into my mySQL DB through
> it.. it goes ok. But when I retrieve it.. the data comes completely
> unformatted.
Ah, this question again. Has it been four days already?
HTML does not render new lines. Have a look at the source code of your page
and you'll see that the text is indeed on separate lines. HTML only
understands something like <br />, though, to go to a new line. So, you need
to replace the new line characters with HTML breaks in order to maintain
appearance.
www.php.net/nl2br
---John Holmes...
--- End Message ---
--- Begin Message ---
Hello,
This is a reply to an e-mail that you wrote on Tue, 5 Aug 2003 at
14:18, lines prefixed by '>' were originally written by you.
> Astrum Et Securis!
> I had a question..
> When I create any field and let data be sent into my mySQL DB
through
> it.. it goes ok. But when I retrieve it.. the data comes
completely
> unformatted.
> That is.. let's say I fed this in a textarea..
> The
> Man
> Cool.
> If I view the data from my phpMyAdmin or even Command Line mySQL..
the
> data has gone just this way..
> But when I use mysql_fetch_array() to get the data back from
mySQL, it
> prints as ..
> The Man Is Cool.
> The newline disappears, and I have to use <br>'s while feeding the
> data
> to have the line gaps. What am I doing wrong?
The newlines will be there if you view the source of your page.
Browsers do not render newlines in the source as newlines in the
browser display, as you have found out you have to convert the
newlines to <BR>s.
HTH
David.
--
phpmachine :: The quick and easy to use service providing you with
professionally developed PHP scripts :: http://www.phpmachine.com/
Free PHP error handling script: www.phpmachine.com/error-handler/
Professional Web Development by David Nicholson
http://www.djnicholson.com/
QuizSender.com - How well do your friends actually know you?
http://www.quizsender.com/
--- End Message ---
