NEOHAPSIS - Peace of Mind Through Integrity and Insight

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com

Neohapsis > Archives > PHP Discussion Digest> 2002-07

php-general-digest-help_at_lists.php.net
Date: Sat Jul 13 2002 - 01:30:56 CDT

Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

php-general Digest 13 Jul 2002 06:30:56 -0000 Issue 1461

Topics (messages 107412 through 107494):

Re: PHP codes and variables
        107412 by: Kevin Stone
        107414 by: J. Alden Gillespy
        107419 by: Kevin Stone

Re: PHP and ORACLE
107413 by: Chris Hewitt
107450 by: Anas Mughal

Re: odbc_exec(), any way to validate whether it work or not?
107415 by: Scott Fletcher

Re: PHP/cron fetching and processing email from a POP3 account
107416 by: Chris Hewitt

How do I send files with HTTP socket post (PostToHost)
107417 by: Kevin Stone

black becomes red w/ imagecreatefromjpeg
107418 by: Don Howland

Re: Final Year Computer Science Project involving PHP
107420 by: Scott Hurring

Re: ' giving problem while inserting in table.
107421 by: Scott Hurring

Re: gd ->1:image resolution 2:font quality
107422 by: 1LT John W. Holmes

Re: PHP and geographic maps
107423 by: Richard Lynch

Re: help with mail() function!
107424 by: Analysis & Solutions
107479 by: Thomas \"omega\" Henning

Re: A question of style ...
107425 by: Analysis & Solutions

Re: IIS Bugs???
107426 by: Scott Hurring

good article on creating a subscription form/script
        107427 by: René Fournier
        107428 by: Lazor, Ed
        107442 by: Michael Sims

another pair of eyes?
        107429 by: Jas
        107432 by: Greg Donald
        107436 by: Lee Doolan

Encoding problem with command line PHP.exe
        107430 by: Emile Axelrad
        107431 by: Emile Axelrad
        107438 by: Analysis & Solutions

pgSQL Functions with results set to php?
107433 by: David Busby

PHP/MySQL -- Date/Time Confusion
        107434 by: Monty
        107435 by: 1LT John W. Holmes
        107447 by: David Freeman
        107451 by: Anas Mughal

problem with cookies and some browsers
107437 by: Andy
107459 by: Alberto Serra

php.security newsgroup any time?
107439 by: Jas

Encoding problem ONLY with _command line_ PHP.exe
107440 by: Emile Axelrad

getlastmod() returns error??
107441 by: Andrew Ziem
107446 by: Andrew Ziem

Help a n00b with Server-to-Server file transfers?
107443 by: Steve Keller

out of office test
107444 by: Collins, Robert
107445 by: Collins, Robert

Re: php4apache.dll...
107448 by: Bruce Karstedt

Convert MySQL table into Access or Excell format
        107449 by: Alex Shi
        107476 by: Jason Wong
        107477 by: Jason White
        107483 by: Alex Shi
        107487 by: Jason Wong
        107490 by: Alex Shi
        107492 by: Jason Wong

PHP as smart .bat files on windows?
107452 by: Francisco Reyes
107453 by: Analysis & Solutions

PHPDiscuss.com
        107454 by: Erich Kolb
        107455 by: Jeff Lewis
        107456 by: 1LT John W. Holmes

Advice needed
        107457 by: Mike Tuller
        107460 by: Alberto Serra
        107463 by: Mike Tuller
        107466 by: Analysis & Solutions
        107468 by: Alberto Serra

File Browser
107458 by: Darren Young
107475 by: Jason Wong

Librep (yes it's definitely OT)
107461 by: Alberto Serra

Re: [PHP-WIN] PHP meetup [CROSS-POST] Meet other PHP Developers in Your Area
107462 by: C. Hendrie

checkboxes / form elements
        107464 by: Blue Presley
        107467 by: 1LT John W. Holmes
        107469 by: Analysis & Solutions
        107470 by: Alberto Serra

Gainesville, Florida PHP Users? (Re: [PHP-WIN] PHP meetup [CROSS-POST] Meet other PHP Developers in Your Area)
107465 by: Tim Luoma

is_null question
        107471 by: Matthew K. Gold
        107473 by: Jason White
        107474 by: Jason White

Inheritance
        107472 by: Jason White
        107478 by: Alberto Serra
        107480 by: Alberto Serra

Restricting access using IPs
        107481 by: Liam MacKenzie
        107486 by: Jason Wong
        107488 by: Liam MacKenzie
        107491 by: Jason Wong

problems with variable variables...
107482 by: Dave at Sinewaves.net

NEVERMIND! [PHP] problems with variable variables...
107484 by: Dave at Sinewaves.net

Connecting LocalHost & Remote mySQL DB
        107485 by: Thomas Edison Jr.
        107489 by: Jason Wong
        107493 by: Thomas Edison Jr.
        107494 by: Jason Wong

Administrivia:

To subscribe to the digest, e-mail:
php-general-digest-subscribelists.php.net

To unsubscribe from the digest, e-mail:
php-general-digest-unsubscribelists.php.net

To post to the list, e-mail:
php-generallists.php.net

----------------------------------------------------------------------

attached mail follows:

Or use implode instead of join makes skips the step of extracting the
index..
$file = implode ('', file ("afile.html"));

If you'll be sending more output than just one file then another favorite
method is this..
ob_start();
readfile("file1.txt");
readfile("file2.html");
$output = ob_get_contents();
ob_end_clean();

-Kevin

----- Original Message -----
From: "Miguel Cruz" <mncstoic.net>
To: "J. Alden Gillespy" <doggabowjackloren.com>
Cc: "Groups - PHP-General" <php-generallists.php.net>
Sent: Friday, July 12, 2002 12:17 PM
Subject: Re: [PHP] PHP codes and variables

> On Fri, 12 Jul 2002, J. Alden Gillespy wrote:
> > Anyone know how to do have a variable equal the contents of a file? I
tried
> > the include function, but it just prints the file out on the screen
rather
> > than including the contents in the variable itself. I need help with
this
> > ASAP. Thanks.
>
> $variable = join('', file('path/to/file'));
>
> miguel
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

attached mail follows:

Which method makes it possible to process any variables in the included
file? See, I have variables in the included file that are defined in the
page that's calling it.

J. Alden Gillespy (DJ Rage)
Broadcasting on Test Pattern Radio
Shock Rock! Every Sunday 5-8pm edt (21-0 gmt)
http://www.thetestpattern.com

----- Original Message -----
From: "Kevin Stone" <kevinhelpelf.com>
To: "PHP-general" <php-generallists.php.net>
Sent: Friday, July 12, 2002 2:35 PM
Subject: Re: [PHP] PHP codes and variables

> Or use implode instead of join makes skips the step of extracting the
> index..
> $file = implode ('', file ("afile.html"));
>
> If you'll be sending more output than just one file then another favorite
> method is this..
> ob_start();
> readfile("file1.txt");
> readfile("file2.html");
> $output = ob_get_contents();
> ob_end_clean();
>
> -Kevin
>
> ----- Original Message -----
> From: "Miguel Cruz" <mncstoic.net>
> To: "J. Alden Gillespy" <doggabowjackloren.com>
> Cc: "Groups - PHP-General" <php-generallists.php.net>
> Sent: Friday, July 12, 2002 12:17 PM
> Subject: Re: [PHP] PHP codes and variables
>
>
> > On Fri, 12 Jul 2002, J. Alden Gillespy wrote:
> > > Anyone know how to do have a variable equal the contents of a file? I
> tried
> > > the include function, but it just prints the file out on the screen
> rather
> > > than including the contents in the variable itself. I need help with
> this
> > > ASAP. Thanks.
> >
> > $variable = join('', file('path/to/file'));
> >
> > miguel
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

attached mail follows:

In that case you'll have to use the output buffering method ob_start(); The
include() function parses and executes any valid PHP code within the file
and produces output (if any). Output buffering captures the display output
and stores it until you clean the buffer or the script terminates.

ob_start();
include ("header.php");
include ("body.php");
include ("footer.php");
$out = ob_get_contents();
ob_end_clean();

echo $out;

Note: instead of ob_end_clean() you can also do ob_end_flush() to send the
output to the display and destroy the buffer simultaneously.

-Kevin

----- Original Message -----
From: "J. Alden Gillespy" <doggabowjackloren.com>
To: "PHP-general" <php-generallists.php.net>
Sent: Friday, July 12, 2002 12:42 PM
Subject: Re: [PHP] PHP codes and variables

> Which method makes it possible to process any variables in the included
> file? See, I have variables in the included file that are defined in the
> page that's calling it.
>
> J. Alden Gillespy (DJ Rage)
> Broadcasting on Test Pattern Radio
> Shock Rock! Every Sunday 5-8pm edt (21-0 gmt)
> http://www.thetestpattern.com
>
> ----- Original Message -----
> From: "Kevin Stone" <kevinhelpelf.com>
> To: "PHP-general" <php-generallists.php.net>
> Sent: Friday, July 12, 2002 2:35 PM
> Subject: Re: [PHP] PHP codes and variables
>
>
> > Or use implode instead of join makes skips the step of extracting the
> > index..
> > $file = implode ('', file ("afile.html"));
> >
> > If you'll be sending more output than just one file then another
favorite
> > method is this..
> > ob_start();
> > readfile("file1.txt");
> > readfile("file2.html");
> > $output = ob_get_contents();
> > ob_end_clean();
> >
> > -Kevin
> >
> > ----- Original Message -----
> > From: "Miguel Cruz" <mncstoic.net>
> > To: "J. Alden Gillespy" <doggabowjackloren.com>
> > Cc: "Groups - PHP-General" <php-generallists.php.net>
> > Sent: Friday, July 12, 2002 12:17 PM
> > Subject: Re: [PHP] PHP codes and variables
> >
> >
> > > On Fri, 12 Jul 2002, J. Alden Gillespy wrote:
> > > > Anyone know how to do have a variable equal the contents of a file?
I
> > tried
> > > > the include function, but it just prints the file out on the screen
> > rather
> > > > than including the contents in the variable itself. I need help
with
> > this
> > > > ASAP. Thanks.
> > >
> > > $variable = join('', file('path/to/file'));
> > >
> > > miguel
> > >
> > >
> > > --
> > > PHP General Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

attached mail follows:

Ricardo Fitzgerald wrote:

>Hi,
>
>I started with PHP and MYSQL a while ago and now I've been involved in
>a huge database project with ORACLE.
>
-----------snip---------------

>And i don't have any kind of experience with Oracle, so I would
>appreciate any recommendations from experienced developers.
>
I develop a lot with Oracle (pl/sql not php) but I think the key factors
remain the same with a small or large amount of data. Spend time
ensuring the table layout (and its indices) are fairly optimal. With a
small amount of data extra time in doing sql statements may not be
critical, but with a lot of data it would be very noticeable.

Two of the Oracle CDs in the distribution are documentation. MostOne of
the books on them is the Server Applications Developer's Guide, some of
the information on table layout and general optimising may be useful,
but most of it is about using pl/sql.

Otherwise just ensure the database is doing all your sorting etc, and
gives you the data in the order you need it.

This doesn't seem much advice, but its a start. Post anything else more
specific. Hope it helps.

Chris
PS Your computer clock tells me I'm a teenager again!

attached mail follows:

I don't think you would find any book covering PHP and Oracle. They technologies usually don't mix. Oracle is very enterprise oriented; whereas, PHP is open source community favorite.
Oracle is a beast by its nature. So, you would need a few good books on Oracle.
I would suggest following proper design approaches up-front. Large/huge projects incur large costs if design has to change during later stages of development. Frankly, I don't know of any good PHP design books. Please let me know if you find any.
Good luck.

Ricardo Fitzgerald <axismovinet.com.uy> wrote: Hi,

I started with PHP and MYSQL a while ago and now I've been involved in
a huge database project with ORACLE.
My point is I never used it nor develop with ORACLE, so I want to know
where and what kind of information I need to port my web application
developed with php and mysql to port it to ORACLE, and where can I
find information regarding HUGE database applications design using
php.

So far I only have the book Designing Web Applications using PHP and
MySQL by Luke Wellington, and MySQL by Paul Dubois.

And i don't have any kind of experience with Oracle, so I would
appreciate any recommendations from experienced developers.

TIA,
Regards,
Ricardo Fitzgerald

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

--------------------------------- Do You Yahoo!? New! SBC Yahoo! Dial - 1st Month Free & unlimited access

attached mail follows:

Never Mind! It was the $_GET['VIEW'] that was the problem. Since some script use Get method while other use Post method, so I changed it to $_REQUEST['VIEW'] and that took care of the problem.

"Scott Fletcher" <scottabcoa.com> wrote in message news:20020712163636.89878.qmailpb1.pair.com... > For the odbc_exec(), is there a way to validate whether this return a true > or false. If false, then the error message? > > I really hate PHP_SELF now, this one web page is written to be repeated 3 > times. With the global register turned off, everything was really a mess > and I'm close to being done in cleaning it up. Now, the odbc_exec() doesn't > work. > >

attached mail follows:

D. Reid Wilson wrote:

>I would like to write a PHP script that fetchs email from a POP3 account and >then processes it based on the content of the email, such as writing it to a >CRM database or confirming an ezine subscription. I would then run the PHP >script via a cron job every ten minutes or so. > Try searching the websites for available code, phpclasses.org, google.com etc. You should be able to find quite a bit of useful code for your project.

HTH Chris

attached mail follows:

Okay enough answering questions this week, now I have a question to ask. :)

I have a situation where two web servers need to share files with one another. FTP is not an option. So I am resorting to HTTP socket connection. I am able to open the connection (using Rasmus's PostToHost function) to PHP scripts running on both servers and send structured queries back and forth. This was easy. The queries can trigger actions so that I can communicate seamlessly and do work. But I cannot for the life of me figure out how to send whole files (mostly image files). There's obviously more to it than just sending the ASCII conversion.

I really don't have any meaningful code to show you. The code is all standard anyway so if you know what I'm talking about then you have probably coded it yourself at one point or another. Are there any tutorials or examples out there that will show me how to send files using fsocketopen() and POST method?

Much thanks! Kevin Stone Helpelf, Inc.

attached mail follows:

Hello group,

It's been over a year since I've had to come to you for help, but your insights and experience are too hard to resist... :-)

I don't have a problem with any of the gd functions and they all works fine except that when I try to fill a circle or draw onto an imported image from imagecreatefromjpeg:

When I create my working jpg image from scratch:

$im = ImageCreate($sizew, $sizeh); $black = ImageColorAllocate($im, 0, 0, 0);

... The image has many different colored stripes which are drawn here 200+ lines ...

ImageArc($im, $arrwell, $arrwell, 10, 10, 0, 360, $black); ImageFillToBorder($im, $arrwell, $arrwell, $black, $black);

...

everything works perfectly.

NOW...

I decided to cut out the 200+ lines of stripe drawing code and import the fixed stripped image using imagecreatefromjpeg to draw and fill the circle and arrow onto:

...

$im = imagecreatefromjpeg("stripes.jpg"); $black = ImageColorAllocate($im, 0, 0, 0);

ImageArc($im, $arrwell, $arrwell, 10, 10, 0, 360, $black); ImageFillToBorder($im, $arrwell, $arrwell, $black, $black);

...

The problem is that now the Arc and arrow lines comes out in a reddish color and the fill to border doesn't fill (regardless of the color used in ImageArc).

Anything I attempt to draw in any color comes out in red (it doesn't matter what the stripe color behind it is, it's still the same red).

See the two small attached images (a small portion of the larger image).

The blackdot.jpg is what it is supposed to look like. The reddot.jpg is what it looks like when drawn on the imported image.

I guess I could go back to drawing it from scratch but it's over 200 lines of code to draw the stripes in an already 800 line program.

Do you know why the reddish color over rides the allocated colors and what I can do to get the $black to draw on the imported image?

Thanks for any ideas,

I'm not on the list, so please respond directly if you can.

Thanks again,

Don

attached mail follows:

... and you could provide hooks so that the billing/sales/inventory systems could all be separate "modules" of some sort, and you could add/swap out modules as they're needed... and perhaps have them communicate thru XML/SOAP, so that they could be on different hosts altogether. :-)

There's a million things you could do, that's the beauty and curse of knowing how to program... too many projects and ideas, not enough time.

--
Scott Hurring
Systems Programmer
EAC Corporation
scott (*) eac.com
--
"Jay Blanchard" <jay.blanchardniicommunications.com> wrote in message
news:002f01c229ba$a796a9c0$8102a8c0niigziuo4ohhdt...
> [snip]
> Computer Science student (yes, that's me...) by giving him some ideas on his
> final year project very possible involving PHP and SQL...
> [/snip]
>
> How about a billing system? Accepts orders, processes invoicing, tracks
> customer trends and habits, has a method for tracking "aged" bills (over 30,
> over 60, over 90, etc.), a method for collections, etc. Billing systems can
> be quite complex and require extensive planning, they must tie in with
> inventory systems, sales systems, etc. You could do the whole integration.
>
> HTH!
>
> Jay
>
>

attached mail follows:

or, more appropriately, use the database-specific escape function...

for mysql: http://www.php.net/manual/en/function.mysql-escape-string.php http://www.php.net/manual/en/function.mysql-real-escape-string.php

--
Scott Hurring
Systems Programmer
EAC Corporation
scott (*) eac.com
--
"Martin Clifford" <MLC1nrc.gov> wrote in message
news:sd2eb466.001nrcgwia.nrc.gov...
Use addslashes() on ALL strings before inserting them into your database.  Then,
on your frontend, extract the data and use stripslashes() on all strings.
Hope to help!
Martin Clifford
Homepage: http://www.completesource.net
Developer's Forums: http://www.completesource.net/forums/
>>> "Anil Garg" <anilgniksun.com> 07/12/02 10:45AM >>>
Hi,
I am making a faq maintenance system using mysql and php.
To insert a entry in to a faq table i am using the following query:
---------
INSERT INTO faq_table_netvd (id,question,
answer,netvcr,netdetector,add_date,mod_date,keyword,category,display,attach_
id)
 VALUES ('0','$frm[question]',
'$frm[answer]','$frm[netvcr]','$frm[netdetector]','$frm[add_date]','$frm[mod
_date]','$frm[keyword]','$frm[category]','$frm[display]','$frm[attach_id]')
 ");
-----------
now the problem is when $frm[question] has some string like: "why i can't
eat".
i get the following error:
MySQL Error: You have an error in your SQL syntax near 't eat?' ,answer =
'Please recheck the power of your specs:)' ' at line 3.Putting a '\' before
' (e.g. \')solves my problem...but when i open the same quesion to edit it,
again i have to put backslashes where ever i find " ' "  in the quesion or
answer.
Can anyone please suggest a solution to this.
thanx and regards
anil
[please ask if i havent explained the problem fully]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

attached mail follows:

> The GIMP is free

Man, if I had a nickel for every time I heard that...

---John Holmes...

attached mail follows:

>> But keeping all that junk in the database as 2-D mapping would only be >> needed if you're going to be providing driving directions and keeping all >> the highways and all that crap that MapQuest keeps (I assume). You almost >> for sure don't need all that. > >It seems to me like they still need street addresses, unless they have a >database of the shapes of every private property parcel in the country.

If they plan to display *every* parcel as a distinct element, yeah, but as I understood it, they just want the properties they are selling to "stand out" on the map.

You wouldn't be using GPS to *outline* every single property, nor even the properties in question -- The "outline" for any object at any level of a map is hand-drawn by a human for the given map.

The GPS data tells you what's on the map and "where" the "dot" belongs, but doesn't attempt to model the entire planet. Modeling that much data for such a "small" project (compared to e.g. MapQuest) would be silly.

This is "do-able" for a reasonable number of properties, but "impossible" for doing every property when you want to scale up to something like MapQuest size.

They're solving different problems, and I don't think the best solution for both is the same.

-- Like Music? http://l-i-e.com/artists.htm

attached mail follows:

You wouldn't happen to be on a windows system? Read the "Warning:" on the manual page: http://www.php.net/manual/en/function.mail.php

--Dan

-- PHP classes that make web design easier SQL Solution | Layout Solution | Form Solution sqlsolution.info | layoutsolution.info | formsolution.info T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409

attached mail follows:

No I only work on *nix platforms "Analysis & Solutions" <danielcanalysisandsolutions.com> wrote in message news:20020712194939.GA28506panix.com... > You wouldn't happen to be on a windows system? Read the "Warning:" on the > manual page: > http://www.php.net/manual/en/function.mail.php > > --Dan > > -- > PHP classes that make web design easier > SQL Solution | Layout Solution | Form Solution > sqlsolution.info | layoutsolution.info | formsolution.info > T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y > 4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409

attached mail follows:

Hi Jay:

On Fri, Jul 12, 2002 at 08:40:31AM -0500, Jay Blanchard wrote: > > The agent selects a referral which is processed by an intermediary > script which sets a flag in the database saying that "this agent" is, has,or > will be contacting this referral (to prevent duplicate contact). Then this > redirects to the referral's interface where the details about this referral > are revealed.

Modularizing things makes TOTAL sense. At the same time, I'd have all processing done by the second (Interface B) page. This is more robust than having the system "transparently" stopping along the way at intermediate scripts.

--Dan

attached mail follows:

There's a problem with IIS and the rest of the world :-)

-- Scott Hurring Systems Programmer EAC Corporation scott (*) eac.com -- "Brian McGarvie" <bmcgarvie

lennox-mckinlay.co.uk> wrote in message news:1E6C09BA9AA33E408D6531ADE236DD01060FAC

ad2.lan.lennox-mckinlay.co.uk... OK This is a followon from my Browser thread... on php-general

lists.php.net; php-windows

lists.php.net

I have switched the application to run from Apache, and the Browsers that were having trouble now seem (I think - will be doing more testing later) to have dissapeared.

So, is there a problem with IIS or PHP or IIS with PHP?

[ http://www.the-local-guide.com :: http://www.mcgarvie.net ]

attached mail follows:

I've looked on php.net, phpbuilder.com, and zend.com, but to no avail. Any suggestions?

--- René Fournier, rene

smartslitters.com

Toll-free +1.888.886.2754 Tel +1.403.291.3601 Fax +1.403.250.5228 www.smartslitters.com

SmartSlitters International #33, 1339 - 40th Ave NE Calgary AB T2E 8N6 Canada

attached mail follows:

It may not be the best approach, but I've always created a form that accepts the users e-mail address and passes it to a script. The script generates an e-mail and sends it to the listserv on behalf of the user. The listserv sends a message to the user and confirms the subscription.

-Ed

-----Original Message----- I've looked on php.net, phpbuilder.com, and zend.com, but to no avail. Any suggestions? **************************************************************************** This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete the message. Thank you very much.

attached mail follows:

On Thu, 12 Jul 2001 14:32:57 -0600, you wrote:

>I've looked on php.net, phpbuilder.com, and zend.com, but to no avail. >Any suggestions?

I don't know of any articles, but I'm actually working on a project that is exactly what you are talking about. I'm going to code the signup interface in PHP, but the email scripts are going to be written in Perl. I've found a nice, simple mailing list script called "Minimalist" that I am going to use to handle the email-based confirmation part of the project. Maybe it can help you too:

http://www.mml.org.ua/

Feel free to email me if you want to trade some ideas. :-)

attached mail follows:

Hello all, I have a parse error and I am not sure why, I think my eyes are giving up on me, or its a friday. Any help is appreciated. // just trying to compare the session var $date to timeout if older than 5 minutes [snippit] /* Begin Session and register timeout, random image & client info variables */ session_start(); session_register('$var1); session_register('$var2'); session_register('$var3'); session_register('$var4'); session_register('$var5'); } elseif (isset($HTTP_SESSION_VARS[$hour]) => $hour + 5*60)) { header("Location: https://localhost/index.php"}; } else { endif(); } [end snippit]

attached mail follows:

On Fri, 12 Jul 2002, Jas wrote:

>Hello all, >I have a parse error and I am not sure why, I think my eyes are giving up on >me, or its a friday. Any help is appreciated. >// just trying to compare the session var $date to timeout if older than 5 >minutes >[snippit] >/* Begin Session and register timeout, random image & client info variables >*/ > session_start(); > session_register('$var1); > session_register('$var2'); > session_register('$var3'); > session_register('$var4'); > session_register('$var5'); > } elseif (isset($HTTP_SESSION_VARS[$hour]) => $hour + 5*60)) { > header("Location: https://localhost/index.php"}; > } else { > endif(); } >[end snippit]

The syntax should be:

$var1 = "some value"; session_register("var1");

-- ----------------------------------------------------------------------- Greg Donald http://destiney.com/public.key -----------------------------------------------------------------------

attached mail follows:

>>>>> "Jas" == Jas <jlgerfenhotmail.com> writes:

Jas> Hello all, Jas> I have a parse error and I am not sure why, I think my eyes are giving up on Jas> me, or its a friday. Any help is appreciated. Jas> // just trying to compare the session var $date to timeout if older than 5 Jas> minutes Jas> [snippit] Jas> /* Begin Session and register timeout, random image & client info variables Jas> */ Jas> session_start(); Jas> session_register('$var1); . /\\ / \ \ \ missing single quote ------------'

Jas> session_register('$var2'); Jas> session_register('$var3'); Jas> session_register('$var4'); Jas> session_register('$var5'); Jas> } elseif (isset($HTTP_SESSION_VARS[$hour]) => $hour + 5*60)) { . /\\ / \ \ \ extra parenthesis -----------------------------------------------' Jas> header("Location: https://localhost/index.php"}; . /\\ / \ \ \ should be paren, not curly--------------------------------' Jas> } else { Jas> endif(); } ?????? . /\\ / \ \ \ huh? -------'

Jas> [end snippit]

-- When the birdcage is open, | donate to causes I care about: the selfish bird flies away, | http://svcs.affero.net/rm.php?r=leed_25 but the virtuous one stays. |

attached mail follows:

Hello - My problem is as follows: <? $data = mssql_result(mssql_query("SELECT Field FROM table WHERE ID='1'"),0); echo $data; mysql_insert("INSERT INTO table2 VALUES('$data')"); ?> The data in the MSSQL table is: Æã IF I call this PHP code from my browser (IE6) it results in the following output: Æã and it also places into the MySQL database the value: Æã However, if I call this PHP code from the command line, using "php.exe test.php" it also results in the following output: Æã but it places into the MySQL database: ’Æ Does anyone have any idea why this is happening? I am sure it is a character set issue, but for the life of me I cannot work out why the command-line does not run the exact same script in the same way as a browser would? Regards, Emile Axelrad, <mailto:emile.axelradconnect.co.uk> emile.axelradconnect.co.uk

attached mail follows:

Emile:

On Fri, Jul 12, 2002 at 09:58:53PM +0100, Emile Axelrad wrote:

> $data = mssql_result(mssql_query("SELECT Field FROM table WHERE > ID='1'"),0); > mysql_insert("INSERT INTO table2 VALUES('$data')");

Ouch.

First, you're mixing and matching mssql and mysql functions. Second, there is no function named mysql_insert(). Third, mssql_result() requires three arguments, you only provided two. Fourth, if you mean to be calling mysql_result(), I've never seen folks call it with a mysql_query() function in it, people usually call the query function separately first and put the resource identifier into a variable. Fifth, all of this could be thrown off by your retyping the example rather than copying/pasting or importing the acutal script that's giving you the error. Sixth, you posted the same question twice.

--Dan

attached mail follows:

List, I'm creating a PHP/pgSQL web site...I need to execute queries with a cursor and get their result set into my PHP script. How can I make a pgSQL procedure with logic that also returns a result set? I've searched and searched but cannot find the answer. Does anyone got it?

attached mail follows:

Which method is the best way to store date/time in MySQL and then which PHP command is the best to use to convert that date to something useful? I'm having a difficult time figuring out how to reconcile the date in MySQL so it works with PHP's various date commands, like getdate().

Any suggestions? I'll mostly need to compared dates/times of different records and then extract parts of the date for displaying on the screen.

Thanks!

Monty

attached mail follows:

You've got all kinds of options. I suggest you do any date calculations in the database and use DATE_FORMAT to format any dates pulled out. It's exactly like the date() function in PHP. MySQL has some great date and time functions so you can select out exactly what you want. You can use the UNIXTIME() (I think that's the function) function, too, to convert the MySQL timestamp to a unix timestamp. It's all in the MySQL manual, chapter 6, Date and Time Functions.

---John Holmes...

----- Original Message ----- From: "Monty" <monty3hotmail.com> To: <php-generallists.php.net> Sent: Friday, July 12, 2002 5:06 PM Subject: [PHP] PHP/MySQL -- Date/Time Confusion

> Which method is the best way to store date/time in MySQL and then which PHP > command is the best to use to convert that date to something useful? I'm > having a difficult time figuring out how to reconcile the date in MySQL so > it works with PHP's various date commands, like getdate(). > > Any suggestions? I'll mostly need to compared dates/times of different > records and then extract parts of the date for displaying on the screen. > > Thanks! > > Monty > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >

attached mail follows:

> Which method is the best way to store date/time in MySQL and > then which PHP > command is the best to use to convert that date to something > useful?

Get comfortable with MySQL's date functionality and you'll find that you don't often need to do the date comparisons and manipulation in php at all.

MySQL lets you store date/time stuff as date, time or timestamp formats (off-hand, haven't referred to the manual here) that will store the data for you. You can manipulate this date information in your sql query using things like DATE_FORMAT() and the like. Check the MySQL manual for all of those (chapter 6 or 7 I think it is).

If you're mostly doing data extraction based on date criteria then you'll find it works best as sql queries basically.

CYA, Dave

attached mail follows:

The easiest and my preferred way is to use "strtotim" method. This method accepts MySQL format "2002-12-23" and converts it into a UNIX time stamp. After that you can use the date function to format time as you wish! Monty <monty3hotmail.com> wrote: Which method is the best way to store date/time in MySQL and then which PHP command is the best to use to convert that date to something useful? I'm having a difficult time figuring out how to reconcile the date in MySQL so it works with PHP's various date commands, like getdate().

Any suggestions? I'll mostly need to compared dates/times of different records and then extract parts of the date for displaying on the screen.

Thanks!

Monty

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

--------------------------------- Do You Yahoo!? New! SBC Yahoo! Dial - 1st Month Free & unlimited access

attached mail follows:

Hi there,

I am wondering if there is a possiblity that some browsers like IE 5.1 do not accespt cookies by default. I am working on a session management system and some users report that they have not been able to login because the cookie has been rejected. They are running IE 5.1 Mac (and maybe PC as well) Are there any known problems?

Andy

attached mail follows:

ðÒÉ×ÅÔ!

Andy wrote: > I am wondering if there is a possiblity that some browsers like IE 5.1 do > not accespt cookies by default.

No, it's that they do not accept standards by default :) Try this and have M$ go to hell:

// send/refresh cookie $time = mktime()+ $lifeInDays*86400; $date = date("l, d-M-y H:i:s", ($time)); header("Set-Cookie: YourCookie=YourValue; expires=$date GMT");

ðÏËÁ áÌØÂÅÒÔÏ ëÉÅ×

-_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_-

LoRd, CaN yOu HeAr Me, LiKe I'm HeArInG yOu? lOrD i'M sHiNiNg... YoU kNoW I AlMoSt LoSt My MiNd, BuT nOw I'm HoMe AnD fReE tHe TeSt, YeS iT iS ThE tEsT, yEs It Is tHe TeSt, YeS iT iS ThE tEsT, yEs It Is.......

attached mail follows:

I am wondering how we can get a newsgroup for security type of things, with either php, mysql or apache... To be honest I am interested in the php security newsgroup the most being as there is for the following two applications. How can one ask a moderator about that type of newsgroup? Jas

attached mail follows:

Hello - My problem is as follows (I am trying to migrate from a mssql server to a mysql server)

<? ## I have already made pconnect statements to both the mssql and mysql servers. ## I have summarized what I am trying to achieve below (actual, full code available below): $data = mssql_result(mssql_query("SELECT field1 FROM table1 WHERE ID='1'"),0,0); echo $data; mysql_query("INSERT INTO table2 VALUES('$data')"); ?> The data in the MSSQL table is: Æã IF I call this PHP code from my browser (IE6) it results in the following output: Æã and it also places into the MySQL database the value: Æã However, if I call this PHP code from the command line, using "php.exe test.php" it also results in the following output: Æã but it places into the MySQL database: ’Æ Does anyone have any idea why this is happening?

I am sure it is a character set issue, but for the life of me I cannot work out why the command-line does not run the exact same script in the same way as a browser would? Regards, Emile Axelrad, <mailto:emile.axelradconnect.co.uk> emile.axelradconnect.co.uk

-- Reposted in response to: - Ouch.

--Dan

--
<html><head><style>
		BODY,td {font:9pt Verdana, Arial, sans-serif;color:red}
		.black {color:black}
		</style></head>
		<body>
<?
set_time_limit(3530);
#mssql_pconnect("SQL-1", "xxx", "xxx");
mssql_pconnect("SQL-1", "xxx", "xxx");
mssql_select_db ("xxx");
mysql_pconnect("localhost", "xxx", "xxx");
function AddToErrorDisplay ($text) {
	global $errordisplay;
	echo $text;
	$errordisplay .= $text;
	return true;
}
function CreateTable($tablename) {
	$_temp = mssql_query("exec sp_columns table_name =
'$tablename'");
	
	while ($row = mssql_fetch_assoc($_temp)) {
		$tablestructure[] = $row;
	}
	##
	## Build fieldlist and create table structure
	##
	
	$createquery = "CREATE TABLE `acclinetest`.`" .
strtolower(ereg_replace("[[:space:]+]","",$tablename)) . "_import`
(\r\n";
	foreach ($tablestructure as $rowid=>$row) {
		if ($rowid > 0) $fieldlist .= ",";
		if ($row["TYPE_NAME"] == "ntext") {
			$fieldlist .= "SUBSTRING([" .
$row["COLUMN_NAME"] . "],1,DATALENGTH([" . $row["COLUMN_NAME"] . "])) As
[" . $row["COLUMN_NAME"] . ']';
		} else {
			$fieldlist .= '[' . $row["COLUMN_NAME"] . ']';
		}
		
		switch ($row["COLUMN_NAME"]) {
			#case 'group':
			case 'option':
				$createquery .=  "`" .
$row["COLUMN_NAME"] . "column` ";
			break;
			default:
		 		$createquery .=  "`" .
$row["COLUMN_NAME"] . "` ";
			break;
		}
		switch ($row["TYPE_NAME"]) {
			case 'nvarchar':
			 if (($row["LENGTH"]/2) > 255) {
			 	$createquery .= 'MEDIUMTEXT';
			 } else {
			 	$createquery .= 'VARCHAR(' .
($row["LENGTH"]/2) . ')';
			 }
			
			break;
			case 'varchar':
			 if ($row["LENGTH"] > 255) {
			 	$createquery .= 'MEDIUMTEXT';
			 } else {
			 	$createquery .= 'VARCHAR(' .
$row["LENGTH"] . ')';
			 }
			break;
			case 'nchar':
			case 'char':
			 $createquery .= 'VARCHAR(' . $row["LENGTH"] .
')';
			break;
			case 'text':
			case 'ntext':
			 $createquery .= 'MEDIUMTEXT';
			break;
			case 'varbinary':
			 $createquery .= 'BLOB';
			break;
			case 'image':
			 $createquery .= 'MEDIUMBLOB';
			break;
			case 'smallint':
			 $createquery .= 'SMALLINT(' .
($row["PRECISION"]+1) . ')';
			break;
			case 'tinyint':
			 $createquery .= 'TINYINT(' .
($row["PRECISION"]) . ')';
			break;
			case 'int':
			 $createquery .= 'INT(' . ($row["PRECISION"]+1)
. ')';
			break;
			case 'float':
			 $createquery .= 'FLOAT(8)';
			break;
			case 'int identity': # AUTO_INCREMENT field
			 $createquery .= 'INT(' . ($row["PRECISION"]+1)
. ')';
			break;
			case 'bit':
			 $createquery .= 'TINYINT(4)';
			break;
			case 'real':
			 $createquery .= 'FLOAT(4)';
			break;
			case 'money':
			 $createquery .= 'DECIMAL(19,4)';
			break;
			case 'smalldatetime':
			case 'datetime':
			 $createquery .= 'VARCHAR(40)';			
			break;
			
			default:
			 AddToErrorDisplay("<br><b>UKNOWN FIELD TYPE: "
. $tablename . ' --> ' . $row["COLUMN_NAME"]  . ' --> ' .
$row["TYPE_NAME"] . "</b>");
			 AddToErrorDisplay("<br><span
style='display:none'>" . print_r($row) . "</span>");
			break;
		}
		$createquery .= ' ' . ($row["NULLABLE"] ? "NULL" : "NOT
NULL");
		if ($rowid+1 < sizeof($tablestructure)) $createquery .=
",";
		$createquery .= "\r\n";
		# print_r($row);
	}
	$createquery .= "\r\n)";
	#echo $fieldlist;
	#echo $createquery;
	mysql_query($createquery);
	AddToErrorDisplay(" \r\n:: <span class=black><b>[" .
date("H:i:s") . "] " . $tablename . "</b></span><u>" . mysql_error() .
"</u>");
	flush();
	
return $fieldlist;
}
function InsertData($tablename,$fieldlist) {
	
	##
	## Retrieve data and build/run reinsert queries
	##
	$_temp = mssql_query("SELECT $fieldlist FROM [$tablename]");
	while ($row = mssql_fetch_row($_temp)) {
		#print_r($row); 
		$i=0;
				
		$insertquery = " (";
		foreach ($row as $fieldvalue) {
			$insertquery .= "'" . addslashes($fieldvalue) .
"'";
			if (++$i < sizeof($row)) $insertquery .= ",";
		}
		$insertquery .= ")";
		
		## Every x rows insert data using SQL query...
		$dataquery .= ($j % 75 > 0 ? ',' : '') . $insertquery;
		if (++$j % 75 == 0) {
			if ($dataquery) {
				mysql_query("INSERT INTO " .
strtolower(ereg_replace("[[:space:]+]","",$tablename)) . "_import
VALUES" . $dataquery);
				AddToErrorDisplay(mysql_error());
				# AddToErrorDisplay("<br>INSERT INTO " .
strtolower($tablename) . "_import" . $dataquery);
				unset($dataquery);
			}		
		}	
		
		# echo $insertquery . "<br>\r\n";
	}
# Finish off any remaining queries before ending.
if ($dataquery) {
	mysql_query("INSERT INTO " .
strtolower(ereg_replace("[[:space:]+]","",$tablename)) . "_import
VALUES" . $dataquery);
	AddToErrorDisplay(mysql_error());
}
AddToErrorDisplay("<span class=black> (inserted $j rows)</span>");
}
#mysql_query("DROP DATABASE acclinetest");
#mysql_query("CREATE DATABASE acclinetest");
mysql_select_db("acclinetest");
$_temp = mssql_query("exec sp_tables");
	
while ($row = mssql_fetch_assoc($_temp)) {
	if ($row["TABLE_TYPE"] == "TABLE") $tables[] = $row;
}
foreach ($tables as $tabledata) {
	mysql_query("DROP TABLE IF EXISTS " .
strtolower(ereg_replace("[[:space:]+]","",$tabledata["TABLE_NAME"])) .
"_import");
	$fieldlist = CreateTable($tabledata["TABLE_NAME"]);
	InsertData($tabledata["TABLE_NAME"],$fieldlist);
	
}
foreach ($tables as $tabledata) {
	mysql_query("DROP TABLE IF EXISTS " .
strtolower(ereg_replace("[[:space:]+]","",$tabledata["TABLE_NAME"])));
	mysql_query("ALTER TABLE " .
strtolower(ereg_replace("[[:space:]+]","",$tabledata["TABLE_NAME"])) .
"_import RENAME AS " .
strtolower(ereg_replace("[[:space:]+]","",$tabledata["TABLE_NAME"])));
	mysql_query("DROP TABLE IF EXISTS " .
strtolower(ereg_replace("[[:space:]+]","",$tabledata["TABLE_NAME"])) .
"_import");
}
?>
</body></html>

attached mail follows:

Hi,

I am using getlastmod() to create a META HTTP-EQUIV tag. However, getlastmod() SOMETIMES returns FALSE (for error).

When I run PHP from a Perl script, getlastmod() returns FALSE. When I run it from the command line, it returns the correct information.

I usually use a Perl script to process a directory of PHP files. It pipes them to HTML files in another directory, and I upload those to my server as static pages.

I am using Mandrake Linux v8.1 and PHP v4.0.6.

Andrew Ziem http://www.springsrescuemission.org

attached mail follows:

I upgraded to PHP 4.2.1,and I still receive the error.

Andrew

"Andrew Ziem" <andrzejziemhotmail.com> wrote in message news:20020712220818.68787.qmailpb1.pair.com... > Hi, > > I am using getlastmod() to create a META HTTP-EQUIV tag. However, > getlastmod() SOMETIMES returns FALSE (for error). > > When I run PHP from a Perl script, getlastmod() returns FALSE. When I run > it from the command line, it returns the correct information. > > I usually use a Perl script to process a directory of PHP files. It pipes > them to HTML files in another directory, and I upload those to my server as > static pages. > > I am using Mandrake Linux v8.1 and PHP v4.0.6. > > > > Andrew Ziem > http://www.springsrescuemission.org > >

attached mail follows:

Ok, here's the situation:

I've got a script that's catching a backdoor post from Verisign. The script then generates an XML file based on the information that's posted. The goal being to make Verisign and our online accounting system pseudo- integrated so that as soon as a post comes through Verisign, the information is passed along to the accounting system and added to the ledger, saving us the time required to manually post those entries.

So the XML file is written correctly now, and we've tested it by uploading it manually.

The next step here is to pass that XML file from our server to the accounting system's server, where it'll be processed. The way the system is set up, they have a DLL that catches a form posted from a browser that also attaches the file. I'm hoping to use that same DLL to post from our server.

I've been trying to read up on socket functions, but all I can find are the function formats listed on the PHP.net documents. That's great for reference, not so great for learning how it's done.

I don't need an answer on how to pass the file, but I would appreciate some help in the way of a pointer to where I can go to read up on how I can accomplish this. Is there a particular tutorial I can read that's relevent? Perhaps a sample script available that I can peruse to see how someone did something similar?

Any help would be appreciated.

~Steve-o

attached mail follows:

sorry to do this but need to make sure my out of office response isint going to spam you guys.

Robert W. Collins II Webmaster New Orleans Regional Transit Authority Phone : (504) 248-3826 Fax: (504) 248-3866 Email : rcollinsnorta.com <mailto:rcollinsnorta.com>

-----Original Message----- From: Alberto Serra [mailto:albertoserragala.net] Sent: Friday, July 12, 2002 11:25 AM Cc: php-generallists.php.net Subject: Re: [PHP] PHP and ORACLE

ðÒÉ×ÅÔ!

I hope you are not really living in the early 70's, are you?

Ricardo Fitzgerald wrote: > Hi, > > I started with PHP and MYSQL a while ago and now I've been involved in > a huge database project with ORACLE.

Have the Oracle box do most of it. Make sure that: 1) there is a well defined API for external application (including your PHP client) to access data. This *must* written an paper and documented. No code writing prior to this. 2) all about referential integrity is done within Oracle 3) use triggers and SPs to enforce data consistency (handle with care, they load the db server if used unproperly) 4) find a good DBA to maintain the system (Oracle can degrade quite dramatically if not properly maintained) 5) interact very little with the DB, to avoid loading its server. (That is, call an SP, get the result set from a tmp table) 6) avoid locking as much as you can 7) Prey the current Oracle bugs are not too evil. 8) get ready to say good bye to your vacations. 9) ask for a paycheck raise

ðÏËÁ áÌØÂÅÒÔÏ ëÉÅ×

-_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_-

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

attached mail follows:

Robert W. Collins II Webmaster New Orleans Regional Transit Authority Phone : (504) 248-3826 Fax: (504) 248-3866 Email : rcollinsnorta.com <mailto:rcollinsnorta.com>

-----Original Message----- From: Collins, Robert [mailto:RCollinsNORTA.COM] Sent: Friday, July 12, 2002 5:24 PM To: php-generallists.php.net; 'php-windowslists.php.net' Subject: [PHP] out of office test

sorry to do this but need to make sure my out of office response isint going to spam you guys.

Robert W. Collins II Webmaster New Orleans Regional Transit Authority Phone : (504) 248-3826 Fax: (504) 248-3866 Email : rcollinsnorta.com <mailto:rcollinsnorta.com>

-----Original Message----- From: Alberto Serra [mailto:albertoserragala.net] Sent: Friday, July 12, 2002 11:25 AM Cc: php-generallists.php.net Subject: Re: [PHP] PHP and ORACLE

ðÒÉ×ÅÔ!

I hope you are not really living in the early 70's, are you?

Ricardo Fitzgerald wrote: > Hi, > > I started with PHP and MYSQL a while ago and now I've been involved in > a huge database project with ORACLE.

ðÏËÁ áÌØÂÅÒÔÏ ëÉÅ×

-_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_-

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

attached mail follows:

I got it when I downloaded 4.2.1 if you can't find it I'll e-mail you a copy.

Bruce Karstedt President Technology Consulting Associates, Ltd. Tel: 847-735-9488 Fax: 847-735-9474

-----Original Message----- From: Peter [mailto:phpvfsa.com.au] Sent: Thursday, July 11, 2002 1:22 AM To: php_gen Subject: [PHP] php4apache.dll... Importance: Low

Howdy

can any one remember where to get the apache2 ver of php4apache.dll?

Cheers

Peter "the only dumb question is the one that wasn't asked"

attached mail follows:

Hello,

My client has a website and it support MySQL/PHP. The client want to download the MySQL tables and then access them in Excell or Access. So my question is, is it possible to convert MySQL table into Access or Excell format? Thanks in advance for all answer!

Alex

-- --------------------------- TrafficBuilder Network: http://www.bestadv.net/index.cfm?ref=7029

attached mail follows:

On Saturday 13 July 2002 06:48, Alex Shi wrote: > Hello, > > My client has a website and it support MySQL/PHP. The client want > to download the MySQL tables and then access them in Excell or > Access. So my question is, is it possible to convert MySQL table into > Access or Excell format? Thanks in advance for all answer!

archives -> "mysql excel"

-- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development *

/* After years of research, scientists recently reported that there is, indeed, arroz in Spanish Harlem. */

attached mail follows:

You can also use ODBC (Ships with Acess) to make a DSN connection to MySQL. Access can retrieve data from any ODBC DSN.

Jason White

----- Original Message ----- From: "Jason Wong" <php-generalgremlins.com.hk> To: <php-generallists.php.net> Sent: Friday, July 12, 2002 9:48 PM Subject: Re: [PHP] Convert MySQL table into Access or Excell format

> On Saturday 13 July 2002 06:48, Alex Shi wrote: > > Hello, > > > > My client has a website and it support MySQL/PHP. The client want > > to download the MySQL tables and then access them in Excell or > > Access. So my question is, is it possible to convert MySQL table into > > Access or Excell format? Thanks in advance for all answer! > > archives -> "mysql excel" > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > > /* > After years of research, scientists recently reported that there is, > indeed, arroz in Spanish Harlem. > */ > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >

attached mail follows:

The thing is that, the MySQL table resides on a remote web server, my client want to download it and access it in Access.

Alex

> You can also use ODBC (Ships with Acess) to make a DSN connection to MySQL. > Access can retrieve data from any ODBC DSN. > > Jason White > > ----- Original Message ----- > From: "Jason Wong" <php-generalgremlins.com.hk> > To: <php-generallists.php.net> > Sent: Friday, July 12, 2002 9:48 PM > Subject: Re: [PHP] Convert MySQL table into Access or Excell format > > > > On Saturday 13 July 2002 06:48, Alex Shi wrote: > > > Hello, > > > > > > My client has a website and it support MySQL/PHP. The client want > > > to download the MySQL tables and then access them in Excell or > > > Access. So my question is, is it possible to convert MySQL table into > > > Access or Excell format? Thanks in advance for all answer! > > > > archives -> "mysql excel" > > > > -- > > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > > Open Source Software Systems Integrators > > * Web Design & Hosting * Internet & Intranet Applications Development * > > > > /* > > After years of research, scientists recently reported that there is, > > indeed, arroz in Spanish Harlem. > > */ > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > >

attached mail follows:

On Saturday 13 July 2002 13:31, Alex Shi wrote: > The thing is that, the MySQL table resides on a remote web server, my > client want to download it and access it in Access.

Doesn't matter, ODBC works across a network.

-- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development *

/* The young lady had an unusual list, Linked in part to a structural weakness. She set no preconditions. */

attached mail follows:

"Jason Wong" <php-generalgremlins.com.hk> wrote in message news:200207131352.42073.php-generalgremlins.com.hk... > On Saturday 13 July 2002 13:31, Alex Shi wrote: > > The thing is that, the MySQL table resides on a remote web server, my > > client want to download it and access it in Access. > > Doesn't matter, ODBC works across a network.

But what can we do if the ISP closed 3306 port on their firewall?

> > -- > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > > /* > The young lady had an unusual list, > Linked in part to a structural weakness. > She set no preconditions. > */ >

attached mail follows:

On Saturday 13 July 2002 14:00, Alex Shi wrote: > "Jason Wong" <php-generalgremlins.com.hk> wrote in message > news:200207131352.42073.php-generalgremlins.com.hk... > > > On Saturday 13 July 2002 13:31, Alex Shi wrote: > > > The thing is that, the MySQL table resides on a remote web server, my > > > client want to download it and access it in Access. > > > > Doesn't matter, ODBC works across a network. > > But what can we do if the ISP closed 3306 port on their firewall?

This thread is leading into non-PHP territory (ie you're better off asking on the mysql list). Put simply, you can specify which port you want MySQL to use. However if the ISP only allows certain ports, eg SMTP, HTTP, _and_ you're already using those ports, then you're stuck up a creek.

Of course you can always ask your ISP to unblock that port. Why are _they_ firewalling _your_ network anyway?

-- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development *

/* What we do not understand we do not possess. -- Goethe */

attached mail follows:

Any experiences on using PHP as a replacement for bat files?

For instance I can't find how to pass a parameter to a PHP program when running PHP as a scripting/CGI language. For regular bat files I can reference parameters by using $1 Anything like that with PHP under windows?

attached mail follows:

On Fri, Jul 12, 2002 at 07:26:52PM -0400, Francisco Reyes wrote: > Any experiences on using PHP as a replacement for bat files?

http://www.php.net/manual/en/features.commandline.php

--Dan

attached mail follows:

I have started a new website devoted strictly to discussing development with PHP. If anyone is interested, you can see it at http://www.phpdiscuss.com.

attached mail follows:

Is it like http://www.phptalk.com ? Like just discussion or are their tutorials etc?

Jeff

>I have started a new website devoted strictly to discussing development with >PHP. If anyone is interested, you can see it at http://www.phpdiscuss.com.

attached mail follows:

> I have started a new website devoted strictly to discussing development > with > PHP. If anyone is interested, you can see it at > http://www.phpdiscuss.com.

Wow...a forum. Is that vBulletin your using? Shouldn't you be giving them credit somewhere??

---John Holmes...

attached mail follows:

I am trying to develop a front end to a database that will be used for entering information about the computer systems I take care of. It would be easy to do if it weren't for one problem. I want to list information about the drives that are in each system. There could be one, two, or 10 drives, so I want to have it generate a new table row for each drive. That I can do. The issue I run into is how best to create the interface. Right now I have a page where everything is entered on one page.

I have two tables in the database. One for the basic hardware information, and one for the volume information. The volume table has a field for the hardwareID so that I can tie the volumes to the hardware, and with a separte table, I can have as many drives as I want. The problem with this is that when I click on a hyperlink to open a window for adding a volume, I need a hardwareID to be able to tie the volume information to the hardware. The hardwareID is created in MySql when the information entered for the hardware is submitted, which hasn't been done yet.

I could break this up into multiple pages, where I enter the basic information, and then I will have an ID created to use so that I can add the volumes, but this could get messy. Is there a better way of doing this?

This is confusing to follow, I know. Here is a link to the page I am talking about so that you can get an idea of what I am talking about. http://bowser.homedns.org/assets/addasset.html About 1/3 the way down, you will see an Add Volume link that will take you to the addvolume page.

Thanks in advance,

Mike

attached mail follows:

ðÒÉ×ÅÔ!

Mike Tuller wrote: > The hardwareID is created in MySql when the information entered for the hardware is submitted, which hasn't been done yet.

You don't need it immediately. Just have a progressive key (like 1,2,3,4...) stored in a hidden field along with the new info you are getting. Once you'll process the final result you will substitute it with the values assigned by your DB engine. Sort of "temporary primary key", if you want :)

ðÏËÁ áÌØÂÅÒÔÏ ëÉÅ×

-_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_-

attached mail follows:

So I would have the progressive key inside the addvolume window? Can you explain how to go about doing this?

----- Original Message ----- From: "Alberto Serra" <albertoserragala.net> Cc: <php-generallists.php.net> Sent: Friday, July 12, 2002 8:56 PM Subject: Re: [PHP] Advice needed

> ðÒÉ×ÅÔ! > > Mike Tuller wrote: > > The hardwareID is created in MySql when the information entered for the hardware is submitted, which hasn't been done yet. > > You don't need it immediately. Just have a progressive key (like > 1,2,3,4...) stored in a hidden field along with the new info you are > getting. Once you'll process the final result you will substitute it > with the values assigned by your DB engine. Sort of "temporary primary > key", if you want :) > > ðÏËÁ > áÌØÂÅÒÔÏ > ëÉÅ× > > -_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_- > > LoRd, CaN yOu HeAr Me, LiKe I'm HeArInG yOu? > lOrD i'M sHiNiNg... > YoU kNoW I AlMoSt LoSt My MiNd, BuT nOw I'm HoMe AnD fReE > tHe TeSt, YeS iT iS > ThE tEsT, yEs It Is > tHe TeSt, YeS iT iS > ThE tEsT, yEs It Is....... > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >

attached mail follows:

Mike:

You MUST store the hardware information first so you can get the actual HardwareID determined by the hardware table's auto increment field. Any other way you do it you leave open the possibility for error.

On your main hardware page, I'd make the "Volume Information" section have conditional text. If the presently viewed page is for a new piece of hardware, show a note saying something like "Save the hardware information. Then you can input the volumes." But, if the hardware page is displaying the data for an existing piece of hardware, the "Add Volume" link would be shown. The link would have a HardwareID in the URI query string.

--Dan

attached mail follows:

ðÒÉ×ÅÔ!

Mike Tuller wrote: > So I would have the progressive key inside the addvolume window? Can you > explain how to go about doing this?

How you organize your HTML output should *never* interfere with the way you organize your data, they are two different things and must be kept well separated. In a perfect world design, process flow and datamodeling should be free to evolve without stepping into each other's way. It's obviously impossible to fully meet this condition in the real world, but one should always try and get as close to it as he can.

Just do this:

Think of your data as a temporary table, in which you have two keys: 1) the real key, whenever available (will be blank on the stuff you haven't written in the database yet) 2) a progressive key, assigned by your php scripts by some means

You just have the two keys constantly in your forms as hidden fields, so that at process time you can still tell which is which when it comes to relations, even if you do not have an already established relation system (which is the case on new data).

So: you load your hdw components, they all have a db id already, so your dataset will look like this:

1) hdw 1, its real id, your own internal key (say 1), rest of the data 2) hdw 2, its real id, your own internal key (say 2), rest of the data ...

you add a new component and save the result on a temporary table, now your temporary dataset is:

1) hdw 1, its real id, your own internal key (say 1), rest of the data 2) hdw 2, its real id, your own internal key (say 2), rest of the data 3) hdw new, no real id, your own internal key (say 3), rest of the data ...

You add a new volume and stock the data on a second temporary table, which contains:

1) vol 1, no real id, your own hdw internal key (should be 3 since you are adding to the last new hdw), your own internal volume id (say 1), rest of the data

You can repeat this step all over as much as you want (like fully building up a number of new disks, volumes or whatever), and have it as multilayered as you want (it will just take as many temporary tables as are the real tables involved).

Once your user finally reviews his/her data (say you entered a totally new system, reviewed it and felt satisfied with it) he will have a "fire" button somewhere.

At this point your final script just takes the data off the temporary tables and uses them to build the real thing.

Notice that this way you also sort of implemented a transaction. Not a real one, since it will not protect you if your final script fails at runtime. Yet you can be sure no unconsistent data from unterminated sessions will ever enter your stable datamodel, and that's were 99.99% of the risk would come from.

ðÏËÁ áÌØÂÅÒÔÏ ëÉÅ×

-_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_-

attached mail follows:

I'm looking for some type of file storage / browsing script to park on an Intranet site. I need to have people log in and be presented with a listing of files stored on the server along with other info such as dates/times, description, author and perhaps some versioning abilities. The files themselves should be stored on disk and the "metadata" about the files inside a database (MySQL preferred but Postgres is OK). All the db should house is a "pointer" to the path of the file on the server's disk. I'd like them to be categorized by topic or subject area (network, sales, finance, etc) and have some type of search interface to locate them. If general users can have the ability to upload it would be nice if there were some type of permissioning on who can view/edit/save docs back to the server/database. If it could have some type of version control (CVS preferred) that would be wonderful.

Anyone have any pointers to existing scripts? What would this type of application be called? A document repository perhaps?

Thanks in advance,

Darren Young darrenyounghome.com

attached mail follows:

On Saturday 13 July 2002 09:51, Darren Young wrote:

> Anyone have any pointers to existing scripts? What would this type of > application be called? A document repository perhaps?

There's something called Owl (search sourceforge/freshmeat etc). Or you can try phprojeckt which has a document repository module.

-- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development *

/* A synonym is a word you use when you can't spell the word you first thought of. -- Burt Bacharach */

attached mail follows:

ðÒÉ×ÅÔ!

Sorry, got no time to surf around for a Linux list, so please answer privately since this is totally OT.

I am running gnome on top of rh 7.1, since I upgraded to librep 0.15.1 and sawfish 1.0.1 I need to reinstall librep once a week.

Apart from the annoying fact in itself, when rep goes astray it simply blocks everything (even ctrl-alt-bspace won't kill X anymore), so that I have to switch the power down and end up having to run fsck to repair my filesystem afterwards. Not a pleasant situation indeed.

Anyone can give me a suggestion about it? Any help would be appreciated, Ineed to finish my job and go on vacation, I can risk having to reinstall my machine from scratch at every step I take :(

ÐÏËÁ áÌØÂÅÒÔÏ ëÉÅ×

-_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_-

attached mail follows:

Tho, when you think about it, most PHP developers COULD use a dating service. :)

Seriously tho, this is a good idea. Thanks for the info Jay. ~ Chris D.O.D

-----Original Message----- From: Jay Blanchard [mailto:jay.blanchardniicommunications.com] Sent: Friday, July 12, 2002 12:24 PM To: php-installlists.php.net; php-dblists.php.net; php-generallists.php.net; php-windowslists.php.net; php-doclists.php.net; php-devlists.php.net; php-announcelists.php.net Subject: [PHP-WIN] PHP meetup [CROSS-POST] Meet other PHP Developers in Your Area

No, it's not a dating service.... :) Want to meet other PHP developers in your area? Check out:

http://php.meetup.com/

Pretty nifty idea... especially given the lack of user groups in the U.S. [/snip]

I thought for others who had not seen this I would post this. There is probably already a user group in your area if you live near a major city. According to the PHPusergroups.org web site [http://www.phpusergroups.org/groups.phtml?menu=groups] there 189 PHP user groups in 52 countries.

Jay

"Chaos, panic & disorder.my work here is done!"

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

attached mail follows:

Hello. I have a form that I would like to use checkboxes. these checkboxes are created dynamically. I've been told that if I want to manipulate each one then I should use 'name=checkbox[]' and make an array out of it. okay, fine. but how do i access them in my PHP script? I know I have to use the $_POST[] array, but this creates a multidiminsional array, yes? do i access it like $_POST[checkbox[1]]?? or $_POST[checkbox][1]??

any info is appreciated.

thanks, blue

attached mail follows:

> Hello. I have a form that I would like to use checkboxes. these > checkboxes > are created dynamically. I've been told that if I want to manipulate each > one then I should use 'name=checkbox[]' and make an array out of it. > okay, > fine. but how do i access them in my PHP script? I know I have to use the > $_POST[] array, but this creates a multidiminsional array, yes? do i > access > it like $_POST[checkbox[1]]?? or $_POST[checkbox][1]??

Yes, the second one, only with single quotes.

$_POST['checkbox][1]

Note that arrays start at zero, too.

---John Holmes...

attached mail follows:

On Fri, Jul 12, 2002 at 10:59:00PM -0400, Blue Presley wrote: > Hello. I have a form that I would like to use checkboxes. > ... snip ... > I've been told that if I want to manipulate each > one then I should use 'name=checkbox[]' and make an array out of it. okay, > fine. but how do i access them in my PHP script? I know I have to use the > $_POST[] array, but this creates a multidiminsional array, yes? do i access > it like $_POST[checkbox[1]]?? or $_POST[checkbox][1]??

The latter. But note, if a box isn't checked, it's not going to be sent, so won't be in the array.

In this case $_POST['checkbox'][0] would be 33 and ...[1] would be 34.

Sometimes it's handy to identify the key upfront:

That would yield $_POST['checkbox']['34'] = 40.

A nice way to handle incomming checkboxes is this:

while ( list($Key, $Val) = each($checkbox) ) { # do what you need to do... # for example, show what was sent... echo "<br />$Key = $Val\n"; }

Enjoy,

--Dan

attached mail follows:

ðÒÉ×ÅÔ!

Analysis & Solutions wrote: > On Fri, Jul 12, 2002 at 10:59:00PM -0400, Blue Presley wrote: > >>Hello. I have a form that I would like to use checkboxes. >>... snip ... >>I've been told that if I want to manipulate each >>one then I should use 'name=checkbox[]' and make an array out of it. okay, >>fine. but how do i access them in my PHP script? I know I have to use the >>$_POST[] array, but this creates a multidiminsional array, yes? do i access >>it like $_POST[checkbox[1]]?? or $_POST[checkbox][1]?? > > > The latter. But note, if a box isn't checked, it's not going to be > sent, so won't be in the array. > > <form> > <input type="checkbox" name="StateID[]" value="32" /> NV > <input type="checkbox" name="StateID[]" value="33" checked /> NH > <input type="checkbox" name="StateID[]" value="34" checked /> NJ > </form> > > In this case $_POST['checkbox'][0] would be 33 and ...[1] would be 34. > > Sometimes it's handy to identify the key upfront: > > <form> > <input type="checkbox" name="StateID[32]" value="608" /> NV > <input type="checkbox" name="StateID[33]" value="2" /> NH > <input type="checkbox" name="StateID[34]" value="40" checked /> NJ > </form> > > That would yield $_POST['checkbox']['34'] = 40. > > A nice way to handle incomming checkboxes is this: > > while ( list($Key, $Val) = each($checkbox) ) { > # do what you need to do... > # for example, show what was sent... > echo "<br />$Key = $Val\n"; > }

Just one thing, as someone noted a week ago or so, you can't use the [] syntax *and* javascript. If you also need to process your checks from jscript side you shall resort to some older method and have your variables called like

<input type="checkbox" name="StateID_32" value="608" /> NV <input type="checkbox" name="StateID_33" value="608" /> NV

then process it with variable variable names (the $$ syntax).

ÐÏËÁ áÌØÂÅÒÔÏ ëÉÅ×

-_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_-

attached mail follows:

Well I don't see a user group listed for Gainesville, FL... and we could have a cool acronym too

PUGG

(php users group of gainesville)

ok, that's a first attempt, but anyway....

So are there other Gainesville, Florida folks around? If so please drop me a link and maybe we can form a local UG.

TjL <luomatpeak.org>

attached mail follows:

Hi Everyone,

Here's my problem: I'd like to make the printing of some text dependent on whether or not a variable is null. In the following example, when $row[1] is null, what gets printed on the page is "Email: ". I'd like the script to not print "Email:" if row[1] is null.

It looks like I should be using is_null(), but I'm not sure how to use it, especially since all of this is embedded in a print statement.

while ($row = mysql_fetch_row ($result)) { print ("\t<tr bgcolor=\"#ff9900\">\n\t\t<th>$row[0]</th>\n</tr>\n\t<tr class=\"default\" bgcolor=\"#ffffff\">\n\t\t<td><p>$row[10]</p><p>Email: <a href=\"mailto:$row[1]\">$row[1]</a><br />Phone: $row[2]</p>\n\n<p>Address: $row[3]<br />$row[4]<br />$row[5] $row[6] $row[7]</p> <p>URL: <a href=\"$row[8]\" target=\"_blank\">$row[8]</a></p></td></tr>"); }

Instead of just printing Email: $row[1], I'd like to test whether it's null first--maybe something like this?

if (is_null($row[1])) print " " else print ("Email: $row[0]")

but can I put that line inside of another print statement? if so, do I have to escape the quotation marks? Please forgive my confusion--I'm new to programming in general and PHP in particular.

Thanks in advance for your help.

best,

Matt

attached mail follows:

You can use:

if($row[1]){print "Email:$row[1]";}else{print " ";}

Jason White

----- Original Message ----- From: "Matthew K. Gold" <mgold1gc.cuny.edu> To: <php-generallists.php.net> Sent: Friday, July 12, 2002 9:23 PM Subject: [PHP] is_null question

> Hi Everyone, > > Here's my problem: I'd like to make the printing of some text dependent on > whether or not a variable is null. In the following example, when $row[1] > is null, what gets printed on the page is "Email: ". I'd like the > script to not print "Email:" if row[1] is null. > > It looks like I should be using is_null(), but I'm not sure how to use it, > especially since all of this is embedded in a print statement. > > while ($row = mysql_fetch_row ($result)) > { > print ("\t<tr bgcolor=\"#ff9900\">\n\t\t<th>$row[0]</th>\n</tr>\n\t<tr > class=\"default\" bgcolor=\"#ffffff\">\n\t\t<td><p>$row[10]</p><p>Email: <a > href=\"mailto:$row[1]\">$row[1]</a><br />Phone: $row[2]</p>\n\n<p>Address: > $row[3]<br />$row[4]<br />$row[5] $row[6] $row[7]</p> <p>URL: <a > href=\"$row[8]\" target=\"_blank\">$row[8]</a></p></td></tr>"); > } > > > Instead of just printing Email: $row[1], I'd like to test whether it's null > first--maybe something like this? > > if (is_null($row[1])) print " " else print ("Email: $row[0]") > > but can I put that line inside of another print statement? if so, do I have > to escape the quotation marks? Please forgive my confusion--I'm new to > programming in general and PHP in particular. > > Thanks in advance for your help. > > best, > > Matt > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >

attached mail follows:

My appologies, I didn't read clear through, your code block confused me :-)

What I usually do in a situation like this, although I'm new to PHP is.

$temp="Some stuff before Email"; if($row[1]){ $temp .= "Email:$row[1]"; } $temp .= "The rest of the stuff after Email"; print $temp;

Jason White

----- Original Message ----- From: "Jason White" <jasonainetarena.com> To: "Matthew K. Gold" <mgold1gc.cuny.edu>; <php-generallists.php.net> Sent: Friday, July 12, 2002 9:28 PM Subject: Re: [PHP] is_null question

> You can use: > > if($row[1]){print "Email:$row[1]";}else{print " ";} > > Jason White > > ----- Original Message ----- > From: "Matthew K. Gold" <mgold1gc.cuny.edu> > To: <php-generallists.php.net> > Sent: Friday, July 12, 2002 9:23 PM > Subject: [PHP] is_null question > > > > Hi Everyone, > > > > Here's my problem: I'd like to make the printing of some text dependent > on > > whether or not a variable is null. In the following example, when $row[1] > > is null, what gets printed on the page is "Email: ". I'd like the > > script to not print "Email:" if row[1] is null. > > > > It looks like I should be using is_null(), but I'm not sure how to use it, > > especially since all of this is embedded in a print statement. > > > > while ($row = mysql_fetch_row ($result)) > > { > > print ("\t<tr bgcolor=\"#ff9900\">\n\t\t<th>$row[0]</th>\n</tr>\n\t<tr > > class=\"default\" bgcolor=\"#ffffff\">\n\t\t<td><p>$row[10]</p><p>Email: > <a > > href=\"mailto:$row[1]\">$row[1]</a><br />Phone: $row[2]</p>\n\n<p>Address: > > $row[3]<br />$row[4]<br />$row[5] $row[6] $row[7]</p> <p>URL: <a > > href=\"$row[8]\" target=\"_blank\">$row[8]</a></p></td></tr>"); > > } > > > > > > Instead of just printing Email: $row[1], I'd like to test whether it's > null > > first--maybe something like this? > > > > if (is_null($row[1])) print " " else print ("Email: $row[0]") > > > > but can I put that line inside of another print statement? if so, do I > have > > to escape the quotation marks? Please forgive my confusion--I'm new to > > programming in general and PHP in particular. > > > > Thanks in advance for your help. > > > > best, > > > > Matt > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >

attached mail follows:

I have a class Foo{} which has a method Print(). I have another class FooBar{} which extends Foo{} and has its own method Print().

How do I invoke Foo{}'s Print() method from within FooBar{} once its been overridden?

Jason White

attached mail follows:

ðÒÉ×ÅÔ!

Jason White wrote: > I have a class Foo{} which has a method Print(). > I have another class FooBar{} which extends Foo{} and has its own method > Print(). > > How do I invoke Foo{}'s Print() method from within FooBar{} once its been > overridden?

parent::print();

if you have multilayered inheritance you may explicitely say which ancemtor class you are calling, like foo:print().

ðÏËÁ áÌØÂÅÒÔÏ ëÉÅ×

-_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_-

attached mail follows:

ðÒÉ×ÅÔ!

> if you have multilayered inheritance you may explicitely say which > anceStor class you are calling, like foo::print().

two typos in a few words are definitely too much, sorry :)

BTW, although almost all class specification is dynamic you cannot dynamically specify a class name in fron of the :: operator. A bug, most probably.

$myclass = 'foo'; $myclass::print();

will produce a weird parse error.

ðÏËÁ áÌØÂÅÒÔÏ ëÉÅ×

-_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_--_=}{=_-

attached mail follows:

Hey all, I'm looking to deny access to all IPs except those that fall into a specific IP range. 192.168.0.* in this case. Am I missing something out of this code, it don't work too well ;-)

<? $localip = "192.168.0.13"; if ($REMOTE_ADDR == $localip) { ?>

Allowed!

<? } else { ?>

Denied!

<? }

Thanks in advance :-)

Liam

attached mail follows:

On Saturday 13 July 2002 13:10, Liam MacKenzie wrote: > Hey all, I'm looking to deny access to all IPs except those that fall into > a specific IP range. 192.168.0.* in this case. > Am I missing something out of this code, it don't work too well ;-)

HOW doesn't it work too well? It displays a picture of a naked guy instead of the naked girl that you was expecting?

> <? > $localip = "192.168.0.13"; > if ($REMOTE_ADDR == $localip) { > ?> > > Allowed! > > <? > } > else { > ?> > > Denied! > > <? > } > > ?>

-- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development *

/* GOOD-NIGHT, everybody ... Now I have to go administer FIRST-AID to my pet LEISURE SUIT!! */

attached mail follows:

If I enter 192.168.0.13 (My IP) it works, I'm allowed in and any other IP isn't. However, I need to grant access to this whole network, not just me. So I need 192.168.0.* to be able to access it, everyone else should get "Access Denied"

So I need to know how to write this bit: $localip = "192.168.0.13"; so that it's the network, not just me.

I tried these but they didn't work: $localip = "192.168.0.0"; $localip = "192.168.0.*"; $localip = "192.168.0.0/24";

Any other ideas?

Cheers

----- Original Message ----- From: "Jason Wong" <php-generalgremlins.com.hk> To: <php-generallists.php.net> Sent: Saturday, July 13, 2002 3:49 PM Subject: Re: [PHP] Restricting access using IPs

> On Saturday 13 July 2002 13:10, Liam MacKenzie wrote: > > Hey all, I'm looking to deny access to all IPs except those that fall into > > a specific IP range. 192.168.0.* in this case. > > Am I missing something out of this code, it don't work too well ;-) > > HOW doesn't it work too well? It displays a picture of a naked guy instead of > the naked girl that you was expecting? > > > <? > > $localip = "192.168.0.13"; > > if ($REMOTE_ADDR == $localip) { > > ?> > > > > Allowed! > > > > <? > > } > > else { > > ?> > > > > Denied! > > > > <? > > } > > > > ?> > > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > > /* > GOOD-NIGHT, everybody ... Now I have to go administer FIRST-AID to my > pet LEISURE SUIT!! > */ > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >

attached mail follows:

On Saturday 13 July 2002 13:45, Liam MacKenzie wrote: > If I enter 192.168.0.13 (My IP) it works, I'm allowed in and any other IP > isn't. > However, I need to grant access to this whole network, not just me. So I > need 192.168.0.* to be able to access it, everyone else should get "Access > Denied" > > So I need to know how to write this bit: > $localip = "192.168.0.13"; > so that it's the network, not just me. > > I tried these but they didn't work: > $localip = "192.168.0.0"; > $localip = "192.168.0.*"; > $localip = "192.168.0.0/24";

In this particular case all you need to do is check that the ip address ($REMOTE_ADDR) begins with "192.168.0.". So look in the manual to see which of the string function(s) you need to perform this comparison (probably strstr()).

-- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development *

/* Every improvement in communication makes the bore more terrible. -- Frank Moore Colby */

attached mail follows:

I'm having a huge problem with getting variable variables to work.

Here's what the code looks like...

// This is set from a previous array... ///////////////////////////////////////////////// $the_variablename[0] = "processors";

// Now I include a file called vars.processors.php // (which contains an array called processors[] ) ///////////////////////////////////////////////// include("vars.".$the_variablename[0].".php");

Everything works fine so far. Then i make the variable variable, and the shit happens.

// I want to set a javascript array value - already // set up in the script... // So I want to retrieve a value from the included // file dynamically and create a javascript statement // like this: // processors[0] = (whatever the value of $processors[0] within the included file) ///////////////////////////////////////////////// echo $the_variablename[0]."[0] = ".$$the_variablename[0][0].";\n";

And what do I get for wanting total control and dynamic code?? Undefined variable.

Is it because i'm accessing an array within the array?

Should I be calling it as: $($the_variablename[0])[0] or $$the_variablename[0][0]

or do I need to establish a separate temp variable to take care of the array value, like this: $temp = $the_variablename[0]; echo $$temp[0];

Please help!!?!

Dave

attached mail follows:

Nevermind!

I figured out the curly bracket syntax...

Doh! It was buried in the manual the whole time!

Dave

attached mail follows:

Glory!

Let's say i got a bunch of Data in my mySQL Table on my localhost. I need all this Data uploaded on my mySQL on the Server/Internet.

Now one way is to use phpMyAdmin, Export the original data on LocalHost to a .CSV file, then use the Server phpMyAdmin to upload the same .CSV file to the table on the server.

What could be an alternate, in case we dont' want to use this lengthy procedure. Can i make one page which will do both these things? .OR. Can my PHP page on my server, directly pick up data from my localHost mySQL, and feed it in the mySQL Table on the server?

Help needed!

Thanks, T. Edison Jr.

__________________________________________________ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com

attached mail follows:

On Saturday 13 July 2002 13:45, Thomas Edison Jr. wrote: > Glory! > > Let's say i got a bunch of Data in my mySQL Table on > my localhost. I need all this Data uploaded on my > mySQL on the Server/Internet. > > Now one way is to use phpMyAdmin, Export the original > data on LocalHost to a .CSV file, then use the Server > phpMyAdmin to upload the same .CSV file to the table > on the server. > > What could be an alternate, in case we dont' want to > use this lengthy procedure. Can i make one page which > will do both these things? > .OR. > Can my PHP page on my server, directly pick up data > from my localHost mySQL, and feed it in the mySQL > Table on the server?

If all you want is to copy data from ServerA/Database/Table to ServerB/Database/Table you don't even need PHP.

Providing that at least one of the server allows remote access then the easiest way is to use mysqldump. For details consult mysql manual.

-- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development *

/* Love is in the offing. -- The Homicidal Maniac */

attached mail follows:

Glory!

Exactly.. that IS the problem. You see, my mySQL DB on the Server/Internet, on my website.. it DOES NOT allow Remote Host Connection. That's why i need to use a PHP page, that too based on the server. Because i need to move tabel data on my Client/My Computer to the Tables on my Website mySQL.

Thanks, T. Edison Jr.

--- Jason Wong <php-generalgremlins.com.hk> wrote: > On Saturday 13 July 2002 13:45, Thomas Edison Jr. > wrote: > > Glory! > > > > Let's say i got a bunch of Data in my mySQL Table > on > > my localhost. I need all this Data uploaded on my > > mySQL on the Server/Internet. > > > > Now one way is to use phpMyAdmin, Export the > original > > data on LocalHost to a .CSV file, then use the > Server > > phpMyAdmin to upload the same .CSV file to the > table > > on the server. > > > > What could be an alternate, in case we dont' want > to > > use this lengthy procedure. Can i make one page > which > > will do both these things? > > .OR. > > Can my PHP page on my server, directly pick up > data > > from my localHost mySQL, and feed it in the mySQL > > Table on the server? > > If all you want is to copy data from > ServerA/Database/Table to > ServerB/Database/Table you don't even need PHP. > > Providing that at least one of the server allows > remote access then the > easiest way is to use mysqldump. For details consult > mysql manual. > > -- > Jason Wong -> Gremlins Associates -> > www.gremlins.com.hk > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet > Applications Development * > > /* > Love is in the offing. > -- The Homicidal Maniac > */ > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >

===== Rahul S. Johari (Director) ****************************************** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : abraxastechyahoo.com Tel : 91-4546512/4522124 *******************************************

__________________________________________________ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com

attached mail follows:

On Saturday 13 July 2002 14:11, Thomas Edison Jr. wrote: > Glory! > > Exactly.. that IS the problem. > You see, my mySQL DB on the Server/Internet, on my > website.. it DOES NOT allow Remote Host Connection. > That's why i need to use a PHP page, that too based on > the server. Because i need to move tabel data on my > Client/My Computer to the Tables on my Website mySQL.

Allow remote access to your local mysql (read up on the security chapter of manual).

-- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development *

/* "It is easier to fight for principles than to live up to them." -- Alfred Adler */

Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]