Mark Bomgardner wrote:
> way or is there? There are pros and cons to both methods, but I am
> concerned about opening and closing a text file some many times that
> it may cause and issue. The file may be opened and closed 1,000 or
> more times a day.
1000 times? Nothing to worry about. Even i
> -Original Message-
> From: philip [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 02, 2008 10:03 PM
> To: Bastien Koert
> Cc: php-general@lists.php.net
> Subject: [SPAM] Re: [PHP] how to create a slide show using PHP5
> Importance: Low
>
> Bastien Koert wrote:
> >
> >
> > On Wed, Jul
Happy 4th of July!
I am having a little bit of a problem using PHPExcel. I think I'm doing
everything right but apparently not! I am basically trying to output results
of a query to Excel using PHPExcel.
My query works fine, my variables are being passed correctly, my database
connection is fine.
Okay, I found PART of my problem.
$objPHPExcel->getActiveSheet()->setCellValue('A' . $stat_year);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $stat_month);
I must have mistyped and put period "." instead of comma "," to seperate the
cell number from the variable. Fixed that and now I get
Dan Shirah wrote:
Happy 4th of July!
I am having a little bit of a problem using PHPExcel. I think I'm doing
everything right but apparently not! I am basically trying to output results
of a query to Excel using PHPExcel.
My query works fine, my variables are being passed correctly, my database
Jim,
I placed it above like you said, but i get the same result. I think I need
to do something like the below:
if(!empty($query)) {
while ($row = ifx_fetch_row($query)) {
for ($i = 3; $i <= 50; $i++) {
$stat_year = $row['stat_year'];
$stat_month = $row['stat_month'];
$name = $row['_name'];
$
Dan Shirah wrote:
Jim,
I placed it above like you said, but i get the same result. I think I need
to do something like the below:
if(!empty($query)) {
while ($row = ifx_fetch_row($query)) {
for ($i = 3; $i <= 50; $i++) {
$stat_year = $row['stat_year'];
$stat_month = $row['stat_month'];
$name
On Thu, 2008-07-03 at 08:59 -0400, Dan Shirah wrote:
> Happy 4th of July!
How did you know it was my sisters birthday today? Been an exciting
week, first Canada's birthday was on Monday, now my sister's birthday
today. What a thrill ride.
>:)
Cheers,
Rob.
> I am having a little bit of a proble
Hi,
I want to create a new column or table from queries of the values of
columns I( already have.
My table is :
PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS
products_id products_extra_fields_id products_extra_fields_value
1
1
Happy 4th of July!
How did you know it was my sisters birthday today? Been an exciting
week, first Canada's birthday was on Monday, now my sister's birthday
today. What a thrill ride.
Isn't it the 3rd?
--
Richard Heyes
Employ me:
http://www.phpguru.org/cv
--
PHP General Mailing List (http:/
Richard Heyes wrote:
Happy 4th of July!
How did you know it was my sisters birthday today? Been an exciting
week, first Canada's birthday was on Monday, now my sister's birthday
today. What a thrill ride.
Isn't it the 3rd?
It is in the great Republic of Texas.
-Shawn
--
PHP General Mailin
On 7/3/08, Shawn McKenzie <[EMAIL PROTECTED]> wrote:
> Richard Heyes wrote:
>
>> Happy 4th of July!
>>>
>>> How did you know it was my sisters birthday today? Been an exciting
>>> week, first Canada's birthday was on Monday, now my sister's birthday
>>> today. What a thrill ride.
>>>
>>
>> I
> -Original Message-
> From: David Giragosian [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 03, 2008 11:19 AM
> To: php-general@lists.php.net
> Subject: Re: [PHP] PHPExcel
>
> On 7/3/08, Shawn McKenzie <[EMAIL PROTECTED]> wrote:
>
> > Richard Heyes wrote:
> >
> >> Happy 4th of July!
>
So how would I go about getting each result from my query into the
columns/rows?
Should I do my query, and then assign the first column to an array, the
second to another array, etc?
And then try to loop it using $i to count each row?
And just FYI, I put Happy 4th (even though today is the 3rd)
On Thu, 2008-07-03 at 16:36 +0100, Richard Heyes wrote:
> >> Happy 4th of July!
> >
> > How did you know it was my sisters birthday today? Been an exciting
> > week, first Canada's birthday was on Monday, now my sister's birthday
> > today. What a thrill ride.
>
> Isn't it the 3rd?
*doh* I took
GOT IT!!!
I changed my code to the following:
$sql = "SELECT * FROM brev_pending_summary_detail WHERE name =
'$name_code'";
if (!empty($case_age)) {
$sql.=" AND case_age_group = '$case_age'";
}
if (!empty($case_cat)) {
$sql.=" AND case_category = '$case_cat'";
}
if (!empty($case_status)
UGH!
I am now constantly getting an error of "PHP Fatal error: Allowed memory
size of 16777216 bytes exhausted (tried to allocate 936 bytes) on line 689"
Is there a way to continuously write to the file and avoid getting this
error?
On 7/3/08, Dan Shirah <[EMAIL PROTECTED]> wrote:
>
> GOT IT!!
2008/7/2 Daniel Brown <[EMAIL PROTECTED]>:
>> Fatal error: Call to undefined function shawn() in /home/shawn/life.php on
>> line 1
>
>I like it. ;-P
>
I think that a 500 internal service error would be more appropriate at
that stage...
Dotan Cohen
http://what-is-what.com
http://gibberish.co
But this isn't a day of celebration for you guys, Richard, to be sure.
Depends how you look at it. My passing out parade (Navy not booze) was
on the 4th July.
Do you all just ignore the day, or do you hold some kind of
anti-celebration?
Well for me personally it's just another day. Can't s
*doh* I took for granted someone else had the date right... I rarely
know what day it is :)
It's not often I know what day it is... :-)
--
Richard Heyes
Employ me:
http://www.phpguru.org/cv
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Richard Heyes wrote:
*doh* I took for granted someone else had the date right... I rarely
know what day it is :)
It's not often I know what day it is... :-)
Oops, sorry, I read your message wrong.
--
Richard Heyes
Employ me:
http://www.phpguru.org/cv
--
PHP General Mailing List (http://www
On Thu, Jul 03, 2008 at 02:36:18PM -0400, Dan Shirah wrote:
> UGH!
>
> I am now constantly getting an error of "PHP Fatal error: Allowed memory
> size of 16777216 bytes exhausted (tried to allocate 936 bytes) on line 689"
>
> Is there a way to continuously write to the file and avoid getting this
I changed the max memory limit to 512MB and the max timeput to 60...
I'm trying to export a report that only has 3,600 rows and it still exceeds
my memory size/timeout.
any suggestions that I could make to my code to make it more efficient and
not use up so much memory?
On 7/3/08, Mario Guenter
Please contact me if you are interested in learning more:
Abby Knight
EQQUS Technologies
555 Bryant Street, Suite 700
Palo Alto, CA 94301
650-234-1000 ext. 355
[EMAIL PROTECTED]
My client is venture funded startup building
[confirm: ffd06320e87b4e72f197eae8dfdde17a [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Dan Shirah wrote:
UGH!
I am now constantly getting an error of "PHP Fatal error: Allowed memory
size of 16777216 bytes exhausted (tried to allocate 936 bytes) on line 689"
Is there a way to continuously write to the file and avoid getting this
error?
On 7/3/08, Dan Shirah <[EMAIL PROTECTED]>
On 7/3/08, Dan Shirah <[EMAIL PROTECTED]> wrote:
GOT IT!!!
I changed my code to the following:
$sql = "SELECT * FROM brev_pending_summary_detail WHERE name =
'$name_code'";
if (!empty($case_age)) {
$sql.=" AND case_age_group = '$case_age'";
}
if (!empty($case_cat)) {
$sql.=" AND case_ca
Dan Shirah wrote:
GOT IT!!!
I changed my code to the following:
$sql = "SELECT * FROM brev_pending_summary_detail WHERE name =
'$name_code'";
if (!empty($case_age)) {
$sql.=" AND case_age_group = '$case_age'";
}
if (!empty($case_cat)) {
$sql.=" AND case_category = '$case_cat'";
}
if (
Shawn McKenzie wrote:
On 7/3/08, Dan Shirah <[EMAIL PROTECTED]> wrote:
GOT IT!!!
I changed my code to the following:
$sql = "SELECT * FROM brev_pending_summary_detail WHERE name =
'$name_code'";
if (!empty($case_age)) {
$sql.=" AND case_age_group = '$case_age'";
}
if (!empty($case_cat))
I've installed PHP version 5.2.6 but phpinfo() and php -v both report back
the old version 5.0.2. I even copied php.ini-dist from the distribution to
/etc/php.ini and restarted the physical server. It still does show version
5.2.6 as the current version.
As a sidenote, I'm having the same thi
For some reason this first post didn't "post" to this newsgroup...
"x0ml" <[EMAIL PROTECTED]> wrote in message news:...
> I've installed PHP version 5.2.6 but phpinfo() and php -v both report back
> the old version 5.0.2. I even copied php.ini-dist from the distribution
> to /etc/php.ini and r
x0ml wrote:
I've installed PHP version 5.2.6 but phpinfo() and php -v both report back
the old version 5.0.2. I even copied php.ini-dist from the distribution to
/etc/php.ini and restarted the physical server. It still does show version
5.2.6 as the current version.
As a sidenote, I'm havin
Does anyone know if static member overloading was added in PHP 5.3? I
noticed that static method overloading was (__callStatic). Thought I'd
ask here before attempting to ask in the internals. Ex:
__setStatic()
__getStatic()
__isset()
__unset()
--
PHP General Mailing List (http://www.php.net/)
33 matches
Mail list logo