php-general Digest 20 Jul 2006 04:01:47 -0000 Issue 4248

php-general-digest-help Wed, 19 Jul 2006 21:05:00 -0700

php-general Digest 20 Jul 2006 04:01:47 -0000 Issue 4248

Topics (messages 239570 through 239603):


Class ADODB - Method GenID() in MySQL
        239570 by: Renne Rocha
        239571 by: John Meyer
        239573 by: chris smith
        239575 by: John Meyer
        239578 by: Renne Rocha
        239585 by: Lester Caine
        239587 by: Lester Caine
        239592 by: Brady Mitchell
        239602 by: chris smith

Re: pg_query and COPY in transaction
        239572 by: David Tulloh
        239589 by: Luis Magaña
        239591 by: Jochem Maas

Return XML using PHP and Content-Type with UTF-8 breaks the UTF-8
        239574 by: Mathijs
        239576 by: Ray Hauge

Basic PHP knowledge test
        239577 by: John Nichel
        239579 by: Ray Hauge
        239580 by: Jim Moseby
        239581 by: KermodeBear
        239582 by: John Nichel
        239583 by: John Nichel
        239584 by: Ray Hauge
        239586 by: Rory Browne
        239596 by: tedd
        239598 by: tedd

Problem With Cookies
        239588 by: Prathaban Mookiah
        239595 by: Prathaban Mookiah

Re: GD to database directly
        239590 by: Jay Blanchard
        239600 by: tedd

Re: Different php.ini files for different apache processes on one server
        239593 by: spam.pflaesterer.de> (Karl Pflästerer)

Re: forcing a script to run on page unload
        239594 by: tedd

Open Source mailinglist?
        239597 by: Gustav Wiberg
        239599 by: Jay Blanchard
        239601 by: Gustav Wiberg

ROZ pdf
        239603 by: weetat

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 ---

 Hello,

 I am using the ADODB class to connect to a MySQL server. I am trying
to generate an ID with the method GenID(), but when I tried this:

 $id = $db->GenID('table');

 The value of $id is equal to zero. I know that MySQL doesn't use
sequences like PostgreSQL does (I've used this code in a PostgreSQL
project), but in the documentation of ADODB I saw that it is possible
to use it. Is there any trick about how to make it work?

 Thanks.

--
Renne Rocha
www.inova.unicamp.br
[EMAIL PROTECTED]
+55 11 8467-9456

--- End Message ---

--- Begin Message ---
Renne Rocha wrote:
 Hello,

 I am using the ADODB class to connect to a MySQL server. I am trying
to generate an ID with the method GenID(), but when I tried this:

 $id = $db->GenID('table');

 The value of $id is equal to zero. I know that MySQL doesn't use
sequences like PostgreSQL does (I've used this code in a PostgreSQL
project), but in the documentation of ADODB I saw that it is possible
to use it. Is there any trick about how to make it work?

 Thanks.
Okay, I'd have to ask at this point what are you using the ID for? Ifyou're generating it for an insert, just put null on the primary key ifit's auto-increment and MySQL will do it for you.
--- End Message ---

--- Begin Message ---

On 7/19/06, Renne Rocha <[EMAIL PROTECTED]> wrote:

  Hello,

  I am using the ADODB class to connect to a MySQL server. I am trying
to generate an ID with the method GenID(), but when I tried this:

  $id = $db->GenID('table');

  The value of $id is equal to zero. I know that MySQL doesn't use
sequences like PostgreSQL does (I've used this code in a PostgreSQL
project), but in the documentation of ADODB I saw that it is possible
to use it. Is there any trick about how to make it work?


You'll need to insert a value into the table first, then you can do:

$query = "UPDATE tablename SET id=LAST_INSERT_ID(id+1)";
$result = mysql_query($query);
$id = mysql_insert_id();

This is in the mysql docs somewhere...

--
Postgresql & php tutorials
http://www.designmagick.com/

--- End Message ---

--- Begin Message ---

Wouldn't this:
$id = mysql_insert_id();
$query = "UPDATE tablename SET id=" . ($id + 1);
$result = mysql_query($query);
Be a little simpler.
But like I said, I'm confused over the need for this in the first place,
seeing as how an "auto_incremented" primary key is self-descriptive.  or are
you saving this somewhere else in the DB?



On 7/19/06, chris smith <[EMAIL PROTECTED]> wrote:


On 7/19/06, Renne Rocha <[EMAIL PROTECTED]> wrote:
>   Hello,
>
>   I am using the ADODB class to connect to a MySQL server. I am trying
> to generate an ID with the method GenID(), but when I tried this:
>
>   $id = $db->GenID('table');
>
>   The value of $id is equal to zero. I know that MySQL doesn't use
> sequences like PostgreSQL does (I've used this code in a PostgreSQL
> project), but in the documentation of ADODB I saw that it is possible
> to use it. Is there any trick about how to make it work?

You'll need to insert a value into the table first, then you can do:

$query = "UPDATE tablename SET id=LAST_INSERT_ID(id+1)";
$result = mysql_query($query);
$id = mysql_insert_id();

This is in the mysql docs somewhere...

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



--
"I'm American, fatboy.  What's your excuse?"

--- End Message ---

--- Begin Message ---

 Yes, using the PHP functions for MySQL, it works. But I am using the
abstraction class ADODB to make the queries in my database. Why?
Probably we will change the database system (probably to PostgreSQL)
and we don want to change all the code to make the things work in the
new BD.

 I don't know if anyone have ever used this class before. I am trying
to use the GenID method, because in PostgreSQL we don't have the
auto_increment field type. I made it work (with the Insert_ID method),
but it isn't portable. Does anyone that knows this class can help me?

 Thanks a lot for the replies.

--
Renne Rocha
[EMAIL PROTECTED]
55 11 8467-9456

On 7/19/06, John Meyer <[EMAIL PROTECTED]> wrote:

Wouldn't this:
$id = mysql_insert_id();
$query = "UPDATE tablename SET id=" . ($id + 1);
$result = mysql_query($query);
Be a little simpler.
But like I said, I'm confused over the need for this in the first place,
seeing as how an "auto_incremented" primary key is self-descriptive.  or are
you saving this somewhere else in the DB?

On 7/19/06, chris smith <[EMAIL PROTECTED]> wrote:
>
On 7/19/06, Renne Rocha <[EMAIL PROTECTED]> wrote:
>   Hello,
>
>   I am using the ADODB class to connect to a MySQL server. I am trying
> to generate an ID with the method GenID(), but when I tried this:
>
>   $id = $db->GenID('table');
>
 >   The value of $id is equal to zero. I know that MySQL doesn't use
> sequences like PostgreSQL does (I've used this code in a PostgreSQL
> project), but in the documentation of ADODB I saw that it is possible
> to use it. Is there any trick about how to make it work?

You'll need to insert a value into the table first, then you can do:

$query = "UPDATE tablename SET id=LAST_INSERT_ID(id+1)";
$result = mysql_query($query);
$id = mysql_insert_id();

This is in the mysql docs somewhere...

--- End Message ---

--- Begin Message ---
Renne Rocha wrote:
 Yes, using the PHP functions for MySQL, it works. But I am using the
abstraction class ADODB to make the queries in my database. Why?
Probably we will change the database system (probably to PostgreSQL)
and we don want to change all the code to make the things work in the
new BD.
ADOdb will emulate SEQUENCES using what is available in the databaseengine. Firebird uses Generators - MySQL it generates a table of values.So which ever engine you use, GenID should give you the next values forthe SEQUENCE you asked for.
 I don't know if anyone have ever used this class before. I am trying
to use the GenID method, because in PostgreSQL we don't have the
auto_increment field type. I made it work (with the Insert_ID method),
but it isn't portable. Does anyone that knows this class can help me?
GenID is not needed to be linked to an AUTO field. In fact it's muchbetter NOT to make the field AUTO, and use the SEQUENCE value instead.That way you can create an ID and use it in several tables.
MySQL driver may have the option switched off - check $hasGenID setting.
Main thing is that the name of the SEQUENCE should not be the same as atable name for easier understanding.
--
Lester Caine - G8HFL
-----------------------------
L.S.Caine Electronic Services - http://home.lsces.co.uk
Model Engineers Digital Workshop -http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php
--- End Message ---

--- Begin Message ---

> -----Original Message-----
>   I am using the ADODB class to connect to a MySQL server. I am trying
> to generate an ID with the method GenID(), but when I tried this:
> 
>   $id = $db->GenID('table');
> 
>   The value of $id is equal to zero. I know that MySQL doesn't use
> sequences like PostgreSQL does (I've used this code in a PostgreSQL
> project), but in the documentation of ADODB I saw that it is possible
> to use it. Is there any trick about how to make it work?

>From the ADOdb Manual:   "GenID() will automatically create the sequence
for you if it does not exist (provided the userid has permission to do
so)."

Does the MySQL user have permission to create tables?  Since ADOdb fakes
sequences by creating a table, that could be a problem.

Brady

--- End Message ---

--- Begin Message ---
John Meyer wrote:
Wouldn't this:
$id = mysql_insert_id();
$query = "UPDATE tablename SET id=" . ($id + 1);
$result = mysql_query($query);
Be a little simpler.
But like I said, I'm confused over the need for this in the first place,seeing as how an "auto_incremented" primary key is self-descriptive. orare you saving this somewhere else in the DB?
Using it elsewhere in the db as a foreign key..

;)

--
Postgresql & php tutorials
http://www.designmagick.com/
--- End Message ---

--- Begin Message ---

Luis Magaña wrote:
> I have the following code:
> 
> pg_query($conn,"BEGIN TRANSACTION;
>           DELETE FROM codigo_postal;
>           COPY
> codigo_postal(codigo_postal,asentamiento,tipo_asentamiento,municipio,estado)
> FROM '$tmpfname2' DELIMITER '|';
>           COMMIT");
> 
> It is suppoused as I understand it, that if an error occurs on the copy
> statement, then the codigo_postal table should still have all of the
> previous records. Actually I've tested it within psql and it works as
> expected.
> 
> However, the shown code does not. If an error occurs on the copy
> transaction, the data on the table gets deleted.
> 

The above code looks like it should work.  I have done similar stuff in
the past.

A useful trick that you might like to try is that PHP automatically will
automatically wrap a query with multiple parts into a transaction for
you.  I believe it will also do slightly more advanced clean up of the
commit/rollback than the default.  Doing it this way might work better
for you.

David

--- End Message ---

--- Begin Message ---

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I've found the problem and this is not a PHP issue with the pg_query
function at all.

It turned out the COPY command was executing properly since the
specified file for copying records was empty, therefore the COPY was not
issuing any error as it should be.

Thank you for the help.

Jochem Maas wrote:
> Luis Magaña wrote:
>> It is a PHP question because the Postgres querys do work, I ran them
>> directly on the postgres server and there is no problem, but if you use
>> pg_query then it does not work, and pg_query is a PHP function, is it no t?
>>
>> Any way, I've tried already giving each query in separate function
>> calls, and it does not work either. As the rollback you suggest, I
>> haven't tried that since it is suppoused to be automatic. So I will try
>> that and it might work but that does not change the fact that the
>> pg_query function is not doing what the manual says it should do, or at
>> least does not beheave as expected.
> 
> so it seems that you _may_ have a bug. what version of php are you using?
> and do pg_last_error() and/or pg_last_notice() offer any useful info?
> 
> (having read the pg_*() docs somewhat I can only - ouch! makes firebird
> look even simpler than it is already)
> 
> I don't know what the COPY syntax in your SQL does exactly but have you looked
> at pg_copy_from() and pg_copy_to() ?
> 
>> thank you very much for your help.
>>
>> regards.
>>
>> Jochem Maas wrote:
>>> Luis Magaña wrote:
>>>> I have the following code:
>>>>
>>>> pg_query($conn,"BEGIN TRANSACTION;
>>>>           DELETE FROM codigo_postal;
>>>>           COPY
>>>> codigo_postal(codigo_postal,asentamiento,tipo_asentamiento,municipio,estado)
>>>> FROM '$tmpfname2' DELIMITER '|';
>>>>           COMMIT");
>>>>
>>>> It is suppoused as I understand it, that if an error occurs on the copy
>>>> statement, then the codigo_postal table should still have all of the
>>>> previous records. Actually I've tested it within psql and it works as
>>>> expected.
>>>>
>>>> However, the shown code does not. If an error occurs on the copy
>>>> transaction, the data on the table gets deleted.
>>> wrapping an SQL question in a php function doesn't make it a php question. 
>>> ;-)
>>>
>>> $apps = array("apache", "mysql", "windows"); $i = 0;
>>> while ($i++ < 100) printf("how do I install %s?\n", $apps[ rand(0,2) ]);
>>>
>>> // I ran that code for a laugh a number of times - seems to a bias towards
>>> // asking how to install windows... go figure on a php list.
>>>
>>>> I'm certainly lost on this one, is it a bug ?, am I doing something
>>>> wrong ? (most likely I guess)
>>> you are wrong. there is no ROLLBACK specified. I suggest you
>>> do the queries one by one (i.e. one call to pg_query() for each statement)
>>> and if the 'COPY' fails call a 'ROLLBACK'
>>>
>>> disclaimer: I know nothing about PG as such - I mostly use Firebird;
>>>
>>>> Any help will be apprecciated.
>>>>
>>>> PHP: 5.1.2
>>>> PostgreSQL: 8.1.4
>>>> Apache: 2.0.55
>>>> Debian Linux with Kernel 2.6.16
>>>>
>>>>
> 

- --
Luis Magaña
Gnovus Networks & Software
www.gnovus.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (Darwin)

iD8DBQFEvmTQ+QIHCUdTm7sRAib8AKCcdlpR+cv4eMQRNEVJRTRiLycW5QCeNx1d
HsJ2PvsiKOQ1PLN+92JmnrA=
=KEzZ
-----END PGP SIGNATURE-----

--- End Message ---

--- Begin Message ---

Luis Magaña wrote:
> I've found the problem and this is not a PHP issue with the pg_query
> function at all.
> 
> It turned out the COPY command was executing properly since the
> specified file for copying records was empty, therefore the COPY was not
> issuing any error as it should be.

LOL. It's always in the last place you look. :-)

> 
> Thank you for the help.

--- End Message ---

--- Begin Message ---

Hello there,

I Have an problem with UTF-8 and XML.

I Output perfect XML (according to IE, Opera and Firefox).
I use the Content-Type header with "text/xml; charset=utf-8".
For some reason this breaks UTF-8 output.
When i remove it it works. But i need the text/xml header.

If i save an document as .xml with the same contents as UTF-8 it works.

Is this a known problem?

Thx in advanced.

--- End Message ---

--- Begin Message ---

On Wednesday 19 July 2006 09:27, Mathijs wrote:
> Hello there,
>
> I Have an problem with UTF-8 and XML.
>
> I Output perfect XML (according to IE, Opera and Firefox).
> I use the Content-Type header with "text/xml; charset=utf-8".
> For some reason this breaks UTF-8 output.
> When i remove it it works. But i need the text/xml header.
>
> If i save an document as .xml with the same contents as UTF-8 it works.
>
> Is this a known problem?
>
> Thx in advanced.

I would try just specifying UTF-8 in the XML header, and remove the charset 
from the content-type header, and just have the text/xml.

<?xml version="1.0" encoding="utf-8"?>

HTH

-- 
Ray Hauge
Programmer/Systems Administrator
American Student Loan Services
www.americanstudentloan.com
1.800.575.1099

--- End Message ---

--- Begin Message --- We're looking to hire an entry level php programmer here, and I've beentasked with writing the test to evaluate the potential candidates.Being the lazy guy that I am, I naturally turned to Google to see if Icould find some tests that I could use. After clicking thru many links,and finding mostly 'basic php tutorials', I've come here to ask youpeople to do my homework for me. ;) Does anyone have anylinks/resources for a basic php knowledge test? If not, I'll have towrite one from scratch myself, and mess up the rest of my day of goofingoff/sleeping.
--
John C. Nichel IV
Programmer/System Admin (ÜberGeek)
Dot Com Holdings of Buffalo
716.856.9675
[EMAIL PROTECTED]
--- End Message ---

--- Begin Message ---

On Wednesday 19 July 2006 10:31, John Nichel wrote:
> We're looking to hire an entry level php programmer here, and I've been
> tasked with writing the test to evaluate the potential candidates.
> Being the lazy guy that I am, I naturally turned to Google to see if I
> could find some tests that I could use.  After clicking thru many links,
> and finding mostly 'basic php tutorials', I've come here to ask you
> people to do my homework for me.  ;)  Does anyone have any
> links/resources for a basic php knowledge test?  If not, I'll have to
> write one from scratch myself, and mess up the rest of my day of goofing
> off/sleeping.
>
> --
> John C. Nichel IV
> Programmer/System Admin (ÜberGeek)
> Dot Com Holdings of Buffalo
> 716.856.9675
> [EMAIL PROTECTED]

I just recently ran into the same problem.  I got tired of trying to find one, 
so I made it myself.  It's very specific to what we do here though.  I'd 
definitely be interested in that info though, because we're still looking, 
and I'm not totally happy with mine, as I didn't have a whole lot of time to 
write it.

-- 
Ray Hauge
Programmer/Systems Administrator
American Student Loan Services
www.americanstudentloan.com
1.800.575.1099

--- End Message ---

--- Begin Message ---

> 
> We're looking to hire an entry level php programmer here, and 
> I've been 
> tasked with writing the test to evaluate the potential candidates. 
> Being the lazy guy that I am, I naturally turned to Google to 
> see if I 
> could find some tests that I could use.  After clicking thru 
> many links, 
> and finding mostly 'basic php tutorials', I've come here to ask you 
> people to do my homework for me.  ;)  Does anyone have any 
> links/resources for a basic php knowledge test?  If not, I'll have to 
> write one from scratch myself, and mess up the rest of my day 
> of goofing 
> off/sleeping.

<stock answer>
STFW!  RTFM!!  STFA!!  STFU!!
</stock answer>

Ahem...  Now that that's out of my system, you could start with the Zend
sample exam:

http://www.zend.com/education/certification/self_test

I know you're saying "entry level", not "Zend certified", but there are some
pretty basic questions there.

JM

--- End Message ---

--- Begin Message ---

> Does anyone have any links/resources for a 
> basic php knowledge test?  If not, I'll have to 
> write one from scratch myself, and mess up the 
> rest of my day of goofing off/sleeping.

It wouldn't hurt to pick up one of those Zend PHP Certification study guides
and pull some things from there. Or, browse the PHP manual for commonly used
functions and ask questions from there. 

What might work better though would be to pull some questions from this
mailing list and ask them how they would answer them. It will give you some
insight into their knowledge of PHP as well as how well they can solve
problems using the language.

That, in my (not so) humble opinion, is better than just knowledge of the
language. You need to know how to apply it to be a decent programmer.

HTH. I would be very interested in seeing what you come up with, actually.
(o:

-K. Bear

--- End Message ---

--- Begin Message ---
Jim Moseby wrote:
<stock answer>
STFW!  RTFM!!  STFA!!  STFU!!
</stock answer>
That totally goes against my being lazy. Hell, I didn't get to where Iam today by *not* exploiting the 'little people' :-p
--
John C. Nichel IV
Programmer/System Admin (ÜberGeek)
Dot Com Holdings of Buffalo
716.856.9675
[EMAIL PROTECTED]
--- End Message ---

--- Begin Message ---
Ray Hauge wrote:
On Wednesday 19 July 2006 10:31, John Nichel wrote:
We're looking to hire an entry level php programmer here, and I've been
tasked with writing the test to evaluate the potential candidates.
Being the lazy guy that I am, I naturally turned to Google to see if I
could find some tests that I could use.  After clicking thru many links,
and finding mostly 'basic php tutorials', I've come here to ask you
people to do my homework for me.  ;)  Does anyone have any
links/resources for a basic php knowledge test?  If not, I'll have to
write one from scratch myself, and mess up the rest of my day of goofing
off/sleeping.
I just recently ran into the same problem. I got tired of trying to find one,so I made it myself. It's very specific to what we do here though. I'ddefinitely be interested in that info though, because we're still looking,and I'm not totally happy with mine, as I didn't have a whole lot of time towrite it.
Yeah, reading the writing on the wall, I think I'm just going to have tosuck it up, and write it. The worst part of it is, I'm going to have tobe involved in the interview process, and I'm *not* a people person. ;)
I think I'll go with a few syntax questions (not really worried aboutthat aspect, cause even after 8 years of doing php, I still hit themanual a few times a week), maybe have the people write a basic functionor two to check how clean/readable their code it. Possibly also testhow efficient their code would be (like to they call a function insideof a loop to get a static value that could have been set outside theloop). Basic db stuff...........ugh, I don't feel like doing this.
I'll post what I come up with here; maybe we (this list) can combineideas and such, and actually put together a pretty good test or two sowe can spare the next poor soul who gets put into this position by MBAwielding managers.
--
John C. Nichel IV
Programmer/System Admin (ÜberGeek)
Dot Com Holdings of Buffalo
716.856.9675
[EMAIL PROTECTED]
--- End Message ---

--- Begin Message ---

On Wednesday 19 July 2006 11:12, John Nichel wrote:
> Yeah, reading the writing on the wall, I think I'm just going to have to
> suck it up, and write it.  The worst part of it is, I'm going to have to
> be involved in the interview process, and I'm *not* a people person.  ;)
>
> I think I'll go with a few syntax questions (not really worried about
> that aspect, cause even after 8 years of doing php, I still hit the
> manual a few times a week), maybe have the people write a basic function
> or two to check how clean/readable their code it.  Possibly also test
> how efficient their code would be (like to they call a function inside
> of a loop to get a static value that could have been set outside the
> loop).  Basic db stuff...........ugh, I don't feel like doing this.
>
> I'll post what I come up with here; maybe we (this list) can combine
> ideas and such, and actually put together a pretty good test or two so
> we can spare the next poor soul who gets put into this position by MBA
> wielding managers.

That's pretty much what I did.  I went with questions that would show how much 
they understand from a conceptual level.  I don't know many people who don't 
have www.php.net as a bookmark.  I did basic questions to show they 
understood OOP, recursion, pass-by-reference, etc.

I also had to be in the interview.  There were a lot of odd moments of silence 
when people were looking at me to ask some questions.  I just wanted him to 
do the quiz and that was pretty much it ;)

-- 
Ray Hauge
Programmer/Systems Administrator
American Student Loan Services
www.americanstudentloan.com
1.800.575.1099

--- End Message ---

--- Begin Message ---

On 7/19/06, KermodeBear <[EMAIL PROTECTED]> wrote:


> Does anyone have any links/resources for a
> basic php knowledge test?  If not, I'll have to
> write one from scratch myself, and mess up the
> rest of my day of goofing off/sleeping.

It wouldn't hurt to pick up one of those Zend PHP Certification study
guides
and pull some things from there. Or, browse the PHP manual for commonly
used
functions and ask questions from there.



Assuming that doing so was either "Fair use" or authorised by Zend, and that
you aren't going to get your ass sued for copyright violation - then again
maybe on a small enough scale.



What might work better though would be to pull some questions from this

mailing list and ask them how they would answer them. It will give you
some
insight into their knowledge of PHP as well as how well they can solve
problems using the language.




To an extent. I personally think the best way is to outline a set of
situations and have them write scripts to solve that problem. You need to
know that they have both the knowledge and language to solve a problem. It
doesn't really matter if they know the syntax of strpos, if they know other
methods of solving their potential problems.

Perhaps a CSV to MySQL converter - although not exactly that, because I've
mentioned it on the list :p


That, in my (not so) humble opinion, is better than just knowledge of the

language. You need to know how to apply it to be a decent programmer.

HTH. I would be very interested in seeing what you come up with, actually.
(o:



After the person sitting the exam has passed their test.


-K. Bear


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--- End Message ---

--- Begin Message ---

At 12:12 PM -0400 7/19/06, John Nichel wrote:
>The worst part of it is, I'm going to have to be involved in the interview 
>process, and I'm *not* a people person.  ;)

Really, who would have guessed that? ;)

tedd
-- 
------------------------------------------------------------------------------------
http://sperling.com  http://ancientstones.com  http://earthstones.com

--- End Message ---

--- Begin Message ---

At 11:31 AM -0400 7/19/06, John Nichel wrote:
>We're looking to hire an entry level php programmer here, and I've been tasked 
>with writing the test to evaluate the potential candidates. Being the lazy guy 
>that I am, I naturally turned to Google to see if I could find some tests that 
>I could use.  After clicking thru many links, and finding mostly 'basic php 
>tutorials', I've come here to ask you people to do my homework for me.  ;)  
>Does anyone have any links/resources for a basic php knowledge test?  If not, 
>I'll have to write one from scratch myself, and mess up the rest of my day of 
>goofing off/sleeping.

Why is hr typically so limited in creativity? Do you want someone who can read 
and regurgitate the manual or do you want someone who can get the job done?

My advice, give the candidates problems and see how they solve them. Even if 
they don't finish, you get an idea of how they think.

tedd
-- 
------------------------------------------------------------------------------------
http://sperling.com  http://ancientstones.com  http://earthstones.com

--- End Message ---

--- Begin Message ---

I have run into a wierd problem with cookies. I am trying to set a cookie as 
usual:

$COOKIE_EXPIRES = 3600;
$COOKIE_VALID_PATH = "/mydirectory/";
$COOKIE_DOMAIN = ".myhost.com"

setcookie("mycookie1", "somevalue", time()+$COOKIE_EXPIRES, 
$COOKIE_VALID_PATH, $COOKIE_DOMAIN, 0)

I want this cookie to be valid only for the directory /mydirectory in the 
server www.myhost.com. i.e. only for http://www.myhost.com/mydirectory/

The problem is that it works fine with IE 5.5 & Opera 8.5 & Firefox 1.5. But 
the cookies are not being accepted by IE 6 & Opera 9.0. 

And this is the header I captured through ethreal:

Set-Cookie: mycookie1=somevalue; expires=Wed,19-Jul-2006 17:08:59 GMT; path=/
mydirectory/; domain=.myhost.com\r\n

I am sure I am not doing something totally wrong because it works well with 
some versions. Are there any known issues with the later versions of IE and 
Opera.

Thanks in advance.

Prathap

--- End Message ---

--- Begin Message ---

This is with regard to my earlier mail today morning.

In fact I found out that, that problem is due to the way the timestamp is 
handled.

Are there any safe ways to handle cookie expiry time regardless of the time 
system the client uses?

Prathap


---------- Original Message -----------
From: "Prathaban Mookiah" <[EMAIL PROTECTED]>
To: PHP Mailing Lists <[email protected]>
Sent: Wed, 19 Jul 2006 23:01:29 +0600
Subject: [PHP] Problem With Cookies

> I have run into a wierd problem with cookies. I am trying to set a 
> cookie as usual:
> 
> $COOKIE_EXPIRES = 3600;
> $COOKIE_VALID_PATH = "/mydirectory/";
> $COOKIE_DOMAIN = ".myhost.com"
> 
> setcookie("mycookie1", "somevalue", time()+$COOKIE_EXPIRES, 
> $COOKIE_VALID_PATH, $COOKIE_DOMAIN, 0)
> 
> I want this cookie to be valid only for the directory /mydirectory 
> in the server www.myhost.com. i.e. only for http://www.myhost.com/
mydirectory/
> 
> The problem is that it works fine with IE 5.5 & Opera 8.5 & Firefox 
> 1.5. But the cookies are not being accepted by IE 6 & Opera 9.0.
> 
> And this is the header I captured through ethreal:
> 
> Set-Cookie: mycookie1=somevalue; expires=Wed,19-Jul-2006 17:08:59 
> GMT; path=/ mydirectory/; domain=.myhost.com\r\n
> 
> I am sure I am not doing something totally wrong because it works 
> well with some versions. Are there any known issues with the later 
> versions of IE and Opera.
> 
> Thanks in advance.
> 
> Prathap
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
------- End of Original Message -------

--- End Message ---

--- Begin Message ---

[snip]
... some research ...
[/snip]

So, am I to assume that this issue about storing images in databases is
dead?

--- End Message ---

--- Begin Message ---

At 12:36 PM -0500 7/19/06, Jay Blanchard wrote:
>[snip]
>... some research ...
>[/snip]
>
>So, am I to assume that this issue about storing images in databases is
>dead?

Yes, it was dead before it started, as it was the last time this issue was 
discussed.

Simply put, there are tradeoffs, but both sides are so entrenched in their 
beliefs that they find it difficult to acknowledge that.

So, as I did, try both and figure out what works for you.

tedd
-- 
------------------------------------------------------------------------------------
http://sperling.com  http://ancientstones.com  http://earthstones.com

--- End Message ---

--- Begin Message ---

On 19 Jul 2006, [EMAIL PROTECTED] wrote:

> You could chroot each apache instance but I would probably try to modify
> the apache module to accept a parameter (and in the process verify that
> one does not already exist).

Thanks to all for the answers.  As the solution has to work with Apache 1
I can't use the PHPIniDir directive.  One poster suggested to try to set
the PHPRC env variable.  That seems to be the easiest approach since all
Apache instances get started with a different shell script.

   KP

--- End Message ---

--- Begin Message ---

At 9:32 PM -0700 7/18/06, jekillen wrote:
>Hi:
>I have a web application that creates files and directories to save info
>for a user. If the user decides to link to another page or site altogether
>I want to run a script that will clean up after him or her but won't
>interfere with where they are going. It will eventually expand
>to asking the user if he or she wants to save the info for a return
>visit. If they don't want to save it has to clean up after them
>and if they do it goes through the process of tagging and
>saving the info on the server.
>My strategy is to run a spontaneous form submission with the
>body onunload event. Then run the script and exit. I seem to
>remember a way to force a script to run and I've seen that
>in a site that I visit occasionally. Even if I quit the browser
>it still manages to delay the exit of the browser. But I don't
>remember whether it was one of my books on php or the php
>manual that this is in.
>Can someone point me in the right direction?
>Thanks in advance:
>JK

JK:

I got something to work. It may be an overkill, or perhaps someone has a 
simpler solution, but I took a bit of ajax and mixed it with an onUnload event 
and it ran a php app after a browser exited my site.

If you want to see the code, contact me privately and I'll provide.

hth's

tedd
-- 
------------------------------------------------------------------------------------
http://sperling.com  http://ancientstones.com  http://earthstones.com

--- End Message ---

--- Begin Message ---
Hi there!
I hope you don't kill me out there, but I'm totally out of luck here. I'vebeen doing some research on Open Source questions because I want a productof mine to become better in any ways (yes, it's written in PHP and yes, it'sOpen Source). Because of not doing advertising here, I'll skip the name :-)
I can't seem to find any place on the net where you can discuss OpenSource-related questions in general???
Best regards
/Gustav Wiberg
--- End Message ---

--- Begin Message ---

[snip]
I hope you don't kill me out there, but I'm totally out of luck here.
I've 
been doing some research on Open Source questions because I want a
product 
of mine to become better in any ways (yes, it's written in PHP and yes,
it's 
Open Source). Because of not doing advertising here, I'll skip the name
:-)

I can't seem to find any place on the net where you can discuss Open 
Source-related questions in general???
[/snip]

Don't Sourceforge and Freshmeat have lists?

--- End Message ---

--- Begin Message ---


[snip]
I hope you don't kill me out there, but I'm totally out of luck here.
I've
been doing some research on Open Source questions because I want a
product
of mine to become better in any ways (yes, it's written in PHP and yes,
it's
Open Source). Because of not doing advertising here, I'll skip the name
:-)

I can't seem to find any place on the net where you can discuss Open
Source-related questions in general???
[/snip]

Don't Sourceforge and Freshmeat have lists?

I've checked there, but I just find newsletters. At freshmeat I found somechat-function located at IRC, and I don't want to install IRC.

, but no mailinglists...
(or else I'm blind)

Best regards

/Gustav Wiberg
--- End Message ---

--- Begin Message ---
Hi all,
I am using EZpdf class to create pdf in mysql database . The Ezpdfclass is open source tool for auto-creation of pdf in php , the link ishttp://sourceforge.net/projects/pdf-php
I have the problem with tool , the pdf page is blank , eventhough havesome data in my MySQL database .
Anybody have been using the ROS tool successfully , please give me someguidance what that i have done wrong . Thanks
Below is the code:


error_reporting(E_ALL);
require_once('../library/sql.php');
require_once('../library/class.ezpdf.php');

$pdf = &new Cezpdf();
$pdf->selectFont('../fonts/Helvetica');

$_db = dbconnect();
$result = $_db->queryDB("Select user_name from tbl_user");
$data = array();

while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) {
 $data [] = $row['user_name'];
}


$pdf->ezTable($data);
echo print_r($pdf);

if (isset($d) && $d) {
  $pdfcode = $pdf->output(1);
  $pdfcode = str_replace("\n", "\n<br>", htmlspecialchars($pdfcode));
  echo '<html><body>';
  echo trim($pdfcode);
  echo '</body></html>';
} else {
  $pdf->stream();
}
--- End Message ---

php-general Digest 20 Jul 2006 04:01:47 -0000 Issue 4248

Reply via email to