[PHP] An easier way? $_POST[] = $_SESSION[]

2004-11-01 Thread Erich Kolb
Is there an easier way to assign all post data from a form to session data?

Eg.,

$_SESSION['first_name'] = $_POST['first_name'];
$_SESSION['last_name'] = $_POST['last_name'];

$_SESSION['email'] = $_POST['email'];

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



Re: [PHP] PHP Working With Excel File ?

2004-11-01 Thread Erich Kolb
I think the easiest way is to store your data in MySQL and then create a DSN 
via MyODBC and connect to your spreadsheet.

Matt M. [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]
 Can PHP work with Excel files as database ?
 If not, how can I conver it to MySQL format and
 reconvert it to Excel 'coz I need it to report it
 in Excel format,


 if you are on windows you could use a com object.

 if you have access to perl, you could use
 http://search.cpan.org/~kwitknr/Spreadsheet-ParseExcel-0.2603/ParseExcel.pm 

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



Re: [PHP] An easier way? $_POST[] = $_SESSION[]

2004-11-01 Thread Erich Kolb
Thanks a million, this is exactly what I was looking for!

-- 
http://www.providenames.com
http://www.erichkolb.com
http://www.kolbsoft.com
http://www.phpquestions.com

John Nichel [EMAIL PROTECTED] wrote in message 
news:[EMAIL PROTECTED]
 Erich Kolb wrote:
 Is there an easier way to assign all post data from a form to session 
 data?

 Eg.,

 $_SESSION['first_name'] = $_POST['first_name'];
 $_SESSION['last_name'] = $_POST['last_name'];

 $_SESSION['email'] = $_POST['email'];


 If you're not worried about checking the integrity of your data...

 foreach ( $_POST as $key = $value ) {
 $_SESSION[$key] = $value;
 }

 -- 
 John C. Nichel
 ÜberGeek
 KegWorks.com
 716.856.9675
 [EMAIL PROTECTED] 

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



Re: [PHP] Search Submission Tool

2003-09-28 Thread Erich Kolb
Sorry about that, the URL is: http://www.submitsend.com

Mek2600-Php [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
 *This message was transferred with a trial version of CommuniGate(tm) Pro*


 First suggestion- include the URL.  :)

 Michael Kennedy

 -Original Message-
 From: Erich Kolb [mailto:[EMAIL PROTECTED]
 Sent: Friday, September 26, 2003 10:55 PM
 To: [EMAIL PROTECTED]
 Subject: [PHP] Search Submission Tool


 Im putting together a free web based tool available to anyone who wants
 to automatically submit their website to multiple search engines at the
 same time.  I know this has been done before, but I haven't done it and
 its pretty much a learning experience for me.  It is currently
 functioning, and I will be adding some additional search engines, but I
 was wondering if anyone would be willing to take a look and offer any
 suggestions for improvement.

 I apoligize if this is in the incorrect forum, but im looking for as
 much feedback as possible.

 Thanks,
 Erich Kolb

 -- 
 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] Search Submission Tool

2003-09-26 Thread Erich Kolb
Im putting together a free web based tool available to anyone who wants to
automatically submit their website to multiple search engines at the same
time.  I know this has been done before, but I haven't done it and its
pretty much a learning experience for me.  It is currently functioning, and
I will be adding some additional search engines, but I was wondering if
anyone would be willing to take a look and offer any suggestions for
improvement.

I apoligize if this is in the incorrect forum, but im looking for as much
feedback as possible.

Thanks,
Erich Kolb

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



[PHP] PHP user group

2003-07-01 Thread Erich Kolb
Does anyone know of a PHP user group near Gurnee, IL.  I found one in
Chicago, but its a little far to go and they meet in the middle of the day
on Sat.



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



[PHP] Speed up MySQL

2003-06-27 Thread Erich Kolb
Can anyone offer some suggestions as to how I can speed up MySQL query
results?  I have a simple database with 3 fields in 1 table.  The thing is
that there are over 11 million records.  Average query time is about 25
seconds.  The machine itself is pretty fast(P4 1.8ghz/ 1gb ram).  Any
suggestions would be great!



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



[PHP] Re: Speed up MySQL

2003-06-27 Thread Erich Kolb
I am already running MySQL 4, how would I go about adding indexes?

Manuel Lemos [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
 Hello,

 On 06/27/2003 04:55 PM, Erich Kolb wrote:
  Can anyone offer some suggestions as to how I can speed up MySQL query
  results?  I have a simple database with 3 fields in 1 table.  The thing
is
  that there are over 11 million records.  Average query time is about 25
  seconds.  The machine itself is pretty fast(P4 1.8ghz/ 1gb ram).  Any
  suggestions would be great!

 Use the appropriate indexes and upgrade to MySQL 4 to benefit from query
 caching.

 -- 

 Regards,
 Manuel Lemos

 Free ready to use OOP components written in PHP
 http://www.phpclasses.org/




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



[PHP] PHP and XML-RPC on MS Windows

2003-06-11 Thread Erich Kolb
What do I have to do in order to use the XML-RPC functionality on a Windows
based machine?  It was fairly easy to drop the .inc files into the PHP
include directory on a Linux box, but I am not sure if it is possible to do
the same on a Windows machine.



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



[PHP] Re: PHP and XML-RPC on MS Windows

2003-06-11 Thread Erich Kolb
Nevermind.  Duh, I can do it by:
include (xmlrpc.inc);
or
include (xmlrpcs.inc);


Erich Kolb [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
 What do I have to do in order to use the XML-RPC functionality on a
Windows
 based machine?  It was fairly easy to drop the .inc files into the PHP
 include directory on a Linux box, but I am not sure if it is possible to
do
 the same on a Windows machine.





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



[PHP] Array[array]

2003-06-10 Thread Erich Kolb
How do I get a value from an array thats inside of an array?



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



[PHP] How do I grab the first X characters of a string?

2003-06-04 Thread Erich Kolb
How do I grab the first X characters of a string?



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



[PHP] PHP and POP3

2003-06-02 Thread Erich Kolb
I am somwhat aware of the ability to access email using php and IMAP, but is
it at all possible to download email via pop3?



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



[PHP] CleanUp!!

2003-05-29 Thread Erich Kolb
How can I clean this up?
$in_file = http://somedomain.com/somefile.php;

$out_file = ereg_replace(http://;, , $in_file);
$out_file = ereg_replace(/,-, $out_file);
$out_file = /www/dev/.$out_file;



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



[PHP] Help with fread

2003-05-29 Thread Erich Kolb
How can I get statistics from a remote file?

I am trying to get info on:
FileSize
Date Created
Date Modified

when:
fopen (http://somedomain.com/somefile.ext;, r)

Also, I am unable to use filesize function where $fp =
fopen(http://somedomain.com/somefile.ext;, r).


Is it possible to do this, or is it a limitation of php/linux filesystem?



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



[PHP] Multiple values per variable

2003-03-11 Thread Erich Kolb
I am working on some logic where users are categorized based on the results
from a few questions.  So far everything is working properly, but I would
like to be able to assign multiple categories to each user.  Any ideas on
how to accomplish this?
 I am assuming that an array would be in order, but not to sure on the
syntax, or how to explode the array (eg.  User is a member of $cat[1],
$cat[2], $cat[3], etc.



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



[PHP] Databases vs. File Access

2003-01-08 Thread Erich Kolb
I am going to be dealing with a ton of data shortly and my goal is to make
it accessible via the web.  I am curious about the performance differences
between using a database or leaving the data in the individual files they
originated in.  Can anyone offer any recommendations?


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




[PHP] Newbie Help

2003-01-03 Thread Erich Kolb
Does anyone have an example of how to download newsgroup headers from a NNTP
server and insert them into a MySQL DB?



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




[PHP] Please Help

2002-10-28 Thread Erich Kolb
I would like to offer a free webhosting account to the first 25 people who
apply.  We are in the process of starting an internet services company and
would like to offer these accounts provided that the applicants are willing
to provide some feedback on our service.



All free accounts include:



25mb disk space

250mb transfer

1 MySQL Database

PHP 4.2.2

Perl 5.6.1

Full CGI-BIN support

5 Email Accounts

Unlimited sub-domains

Cpanel access

Web mail

Multiple statistics

Auto installer for many popular scripts



More information, as well as an application is available at:
www.kolbsoft.com.



Thanks,

Erich Kolb

President - KolbSoft Technologies

http://www.kolbsoft.com

[EMAIL PROTECTED]



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




[PHP] PHP on WinXP with Apache

2002-10-25 Thread Erich Kolb
I am trying to install php-4.2.3-Win32 on MS WinXP using
apache_2.0.43-win32-x86-no_ssl.

I have followed instructions included in the php package only I have
changed:
LoadModule php4_module C:/php/sapi/php4apache.dll
to
LoadModule php4_module C:/php/sapi/php4apache2.dll

I am receiving:
apache: module c:\php4build\snap\sapi\apache2filter\sapi_apache2.c is
not compatible with this version of Apache (found 20020628, need 20020903).
Please contact the vendor for the correct version.

I have looked around and it appears as though several other people have
had this problem, but I havent been able to find a solution.  It looks
like it is a bug, but it has been around for quite some time and I just
downloaded the Win32 installer for php today.  Does anyone have any
suggestions?


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




[PHP] Looking for feedback

2002-10-03 Thread Erich Kolb

I have setup a web-frontend to the PHP.net Usenet/Mailing List Groups. 
Could anyone take a look and give me some recommendations on enhancements?


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




[PHP] Looking for feedback

2002-10-03 Thread Erich Kolb

Sorry for the ID10T, the address is: http://www.phpdiscuss.com


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




Re: [PHP] Looking for feedback

2002-10-03 Thread Erich Kolb

Ok, I have removed the a href=mailto:.../a references.  It should
only show the actual name of the poster.  I am also currently working on a
login system.

Justin French wrote:

 I'd really appreciate it if you masked email address with javascript or
 something... or perhaps only showed email address' to logged in and
 confirmed users... I already have my email address plastered all over the
 marc archives... one more means twice as much spam :)

 Justin


 on 04/10/02 2:44 PM, Erich Kolb ([EMAIL PROTECTED]) wrote:

  Sorry for the ID10T, the address is: http://www.phpdiscuss.com
 



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




[PHP] php back?

2002-09-03 Thread Erich Kolb

What is the PHP equivalent to javascript: back?



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




[PHP] Re: Help with script

2002-08-26 Thread Erich Kolb

Please see below.  I have posted the entire script.

Bogdan Stancescu [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
 Then you're doing something wrong. Can you post a piece of code?

 Bogdan

 Erich Kolb wrote:
  I have already downloaded the entire file so that Im not constantly
  accessing FreshMeat.net's servers.  I will be processing the update
files as
  soon as I can get the big one done.
  I have also tried to use htmlspecialchars, and nl2br, but it doesnt look
  like there is any output to process.
 
  Bogdan Stancescu [EMAIL PROTECTED] wrote in message
  news:[EMAIL PROTECTED]...
 
 Hi!
 
 You can get the content of that file with php, using ?
 $projects_rdf=file(http://www.freshmeat.net/backend/fm-projects.rdf;);
 ? - then you can do whatever you please with it. Make sure to
 htmlspecialchars() it before outputting to a browser - and consider a
 nl2br() while you're at it as well.
 
 Please be warned that it's a huge download though - you may consider
 only downloading the updates, available from freshmeat from another
 location (I'm sure you can find it easily, I don't have the link at
hand).
 
 HTH
 
 Bogdan
 
 Erich Kolb wrote:
 
 I am trying to write a script that will take a look at the
freshmeat.net
 database (http://www.freshmeat.net/backend/fm-projects.rdf), parse the
 
  file,
 
 and insert it into a MySQL DB.  I have already wrote one for
 
  slashdot.org
 
 that puts the output into html and displays it in a web browser and it
 
  works
 
 fine.  I am trying to do the same to start with for freshmeat (I am
 
  learning
 
 as I go) but there is nothing displayed on the browser.  Can someone
 
  help me
 
 out with this?
 
 Here is the code I have written for slashdot:
 ?php
 
 $insideitem = false;
 $tag = ;
 $title = ;
 $description = ;
 $link = ;
 
 function startElement($parser, $name, $attrs) {
  global $insideitem, $tag, $title, $description, $link;
  if ($insideitem) {
   $tag = $name;
  } elseif ($name == STORY) {
   $insideitem = true;
  }
 }
 
 function endElement($parser, $name) {
  global $insideitem, $tag, $title, $description, $link;
  if ($name == STORY) {
   printf(dtba href='%s'%s/a/b/dt,
trim($description),htmlspecialchars(trim($title)));
   #printf(dd%s/dd,htmlspecialchars(trim($description)));
   $title = ;
   $description = ;
   $link = ;
   $insideitem = false;
  }
 }
 
 function characterData($parser, $data) {
  global $insideitem, $tag, $title, $description, $link;
  if ($insideitem) {
  switch ($tag) {
   case TITLE:
   $title .= $data;
   break;
   case URL:
   $description .= $data;
   break;
  }
  }
 }
 
 $xml_parser = xml_parser_create();
 xml_set_element_handler($xml_parser, startElement, endElement);
 xml_set_character_data_handler($xml_parser, characterData);
 $fp = fopen(http://www.slashdot.org/slashdot.xml,r;)
  or die(Error reading RSS data.);
 while ($data = fread($fp, 4096))
  xml_parse($xml_parser, $data, feof($fp))
   or die(sprintf(XML error: %s at line %d,
xml_error_string(xml_get_error_code($xml_parser)),
xml_get_current_line_number($xml_parser)));
 fclose($fp);
 xml_parser_free($xml_parser);
 
 ?
 
 And here is what I have so far for FreshMeat.net.  Its pretty much the
 
  same,
 
 but the elements are a little different:
 ?php
 
 $insideitem = false;
 $tag = ;
 $project_id = ;
 $date_added = ;
 $date_updated = ;
 $projectname_short = ;
 $projectname_full = ;
 $desc_short = ;
 $desc_full = ;
 $url_homepage = ;
 
 function startElement($parser, $name, $attrs){
 global $insideitem, $tag, $project_id, $date_added, $date_updated,
 $projectname_short, $projectname_full, $desc_short, $desc_full,
 $url_homepage;
  if($insideitem){
   $tag = $name;
   }
  elseif ($name == project){
   $insideitem = true;
   }
 }
 
 function characterData($parser, $data){
 global $insideitem, $tag, $project_id, $date_added, $date_updated,
 $projectname_short, $projectname_full, $desc_short, $desc_full,
 $url_homepage;
  if($insideitem){
   switch ($tag){
case project_id:
$project_id .=$data;
break;
 
case date_added:
$date_added .=$data;
break;
 
case date_updated:
$date_updated .=$data;
break;
 
case projectname_short:
$projectname_short .=$data;
break;
 
case projectname_full:
$projectname_full .=$data;
break;
 
case desc_short:
$desc_short .=$data;
break;
 
case desc_full:
$desc_full .=$data;
break;
 
case url_homepage:
$url_homepage .=$data;
break;
}
   }
  }
 
 function endElement($parser, $name){
 global $insideitem, $tag, $project_id, $date_added, $date_updated,
 $projectname_short, $projectname_full, $desc_short, $desc_full,
 $url_homepage;
 if ($name ==project){
  echo trim($projectname_full).\n;
  echo trim($url_homepage).\n;
  $projectname_full =;
  $url_homepage =;
  }
 }
 
 
 $xml_parser = xml_parser_create();
 xml_set_element_handler($xml_parser, startElement, endElement);
 xml_set_character_data_handler($xml_parser, characterData

[PHP] PHP Cookies

2002-08-26 Thread Erich Kolb

Why cant I use more than 1 variable in a cookie?



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




[PHP] Pausing PHP?

2002-08-22 Thread Erich Kolb

Is there a way to pause a script?



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




[PHP] Remove \n from text

2002-08-20 Thread Erich Kolb

How can I remove all \n and \r from a txt file?



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




[PHP] PHP and Samba

2002-08-14 Thread Erich Kolb

Is there any way to determine if someone is logged in to a Samba Domain
using PHP?  If so, how?



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




[PHP] PHP and MySQL

2002-08-02 Thread Erich Kolb

Is there any way to speed up MySQL queries?



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




[PHP] PHPDiscuss.com

2002-07-12 Thread Erich Kolb

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.



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




[PHP] Global variable

2002-04-17 Thread Erich Kolb

I have developed a simple login script.  Right now it will check a submitted
username and password and verify it against a database.  This part works
fairly well, however I want to know how to assign a variable that will pass
through to the next page(s) to do something like:

if verified == 1 then {display the page} else {display error message}

My apoligies on the syntax of the above, but hopefully you will get the
idea.



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




[PHP] Host question

2001-08-20 Thread Erich Kolb

Just out of curiosity, is there anyone here that is using phpwebhosting.com
to host their site?  Due to ALL the problems with the DSL in my area, I am
thinking about not hosting my own site anymore and phpwebhosting.com seems
to be what I need, I am just looking for some input about any problems that
anyone may have had before I spend my $9.95 per month


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] Loop though email list

2001-08-14 Thread Erich Kolb

I am a total newbie, so please forgive the simplicity!

I have a huge list of email addresses in a text file and also in a MySQL DB
that I would like to use PHP to loop through and send an email to each one
of them. How do I loop through a text file using each email in the txt file
as a seperate email address and send a message to that address?  Or would it
be easier to just do it from a MySQL DB? If so, How??


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] PHP MySQL

2001-07-20 Thread Erich Kolb

When you query a MySQL Database, how do you set the order alphabetically?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] Global Database

2001-07-16 Thread Erich Kolb

Does anynone know where I can find a database of general information like
country abbreviations - country, zip codes, state names?  I am also looking
for a database that has generic topic lists, sort of like how you see on
Yahoo.com or DMOZ?  If there is no database, would anyone be interested in
creating such a thing?


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] PHP4.04pl1 upgrade

2001-01-30 Thread Erich Kolb

Does anyone know where to obtain instructions on how to upgrade to PHP
4.04pl1?  Has anyone done this yet?  What kind of problems did you run into?



[PHP] XML to MySQL

2001-01-29 Thread Erich Kolb

Does anyone know of a script that will take data from XML/RDF news feeds and 
automatically INSERT into a MySQL database?  I have a news script that I can make 
changes to, but I would also like to be able to automatically insert data into the 
database that my news script is running on.