CodeJunkie88

Hi PFMaBiSmAd, Looks like that was it. I found an updated version of that Excel script and installed it. Lo and behold, the error message is gone. I guess the author fixed it so it no longer uses register_globals. I wasn't aware register_globals would be completely removed so luckily I've always thought register_globals were a messy way of passing data and I've always passed data as arguments instead of setting globals. Thanks a lot for your help. Terry

Hi everyone, I'm really stumped regarding this problem when running my php script. On one server I don't get the error but on almost every other server I've tried it on I get an "Undefined variable: $formatsr on line 410" message. here is the PHPinfo output from the server that doesn't give me the error message: ------------------------------------------------------------------------------------------------ PHP Version 5.2.4 System Linux web2505 2.4.31 #7 Wed Aug 17 12:03:50 EDT 2005 i686 Build Date Oct 18 2007 16:12:14 Configure Command ./configure '--with-mysql=/usr/local/mysql' '--disable-debug' '--disable-posix' '--with-apache=../apache_1.3.39/' '--with-imap=../../pine4.64/imap/' '--with-gd' '--with-zlib-dir' '--enable-soap' '--enable-siteguard' '--with-mcrypt' '--enable-gd-native-ttf' '--with-jpeg-dir' '--with-png-dir' '--with-ttf' '--with-xml' '--with-dom' '--with-cal' '--with-freetype-dir' '--with-gdbm' '--with-db' '--with-dba' '--enable-wddx' '--enable-inline-optimization' '--with-gettext' '--with-curl' '--enable-dbase' '--with-db2' '--with-openssl' '--with-ndb' '--enable-mbstring' Server API Apache Virtual Directory Support disabled Configuration File (php.ini) Path /usr/local/lib Loaded Configuration File /usr/local/lib/php.ini PHP API 20041225 PHP Extension 20060613 Zend Extension 220060519 Debug Build no Thread Safety disabled Zend Memory Manager enabled IPv6 Support enabled Registered PHP Streams php, file, data, http, ftp, compress.zlib, https, ftps Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*, zlib.* This program makes use of the Zend Scripting Language Engine: Zend Engine v2.2.0, Copyright © 1998-2007 Zend Technologies PHP Credits Configuration PHP CoreDirective Local Value Master Value allow_call_time_pass_reference On On allow_external_includes Off Off allow_url_fopen On On allow_url_include On On always_populate_raw_post_data Off Off arg_separator.input & & arg_separator.output & & asp_tags Off Off auto_append_file no value no value auto_globals_jit On On auto_prepend_file no value no value browscap no value no value default_charset no value no value default_mimetype text/html text/html define_syslog_variables Off Off disable_classes no value no value disable_functions no value no value display_errors Off Off display_startup_errors Off Off doc_root no value no value docref_ext no value no value docref_root no value no value enable_dl Off Off error_append_string no value no value error_log no value no value error_prepend_string no value no value error_reporting 1 1 expose_php On On extension_dir /usr/local/lib/php/extensions/no-debug-non-zts-20060613 /usr/local/lib/php/extensions/no-debug-non-zts-20060613 file_uploads On On global_deny_external_includes On On highlight.bg #FFFFFF #FFFFFF highlight.comment #FF8000 #FF8000 highlight.default #0000BB #0000BB highlight.html #000000 #000000 highlight.keyword #007700 #007700 highlight.string #DD0000 #DD0000 html_errors On On ignore_repeated_errors Off Off ignore_repeated_source Off Off ignore_user_abort Off Off implicit_flush Off Off include_path . . log_errors Off Off log_errors_max_len 1024 1024 magic_quotes_gpc On On magic_quotes_runtime Off Off magic_quotes_sybase Off Off mail.force_extra_parameters no value no value max_execution_time 30 30 max_input_nesting_level 64 64 max_input_time -1 -1 memory_limit 128M 128M open_basedir no value no value output_buffering 0 0 output_handler no value no value post_max_size 250000000 250000000 precision 14 14 realpath_cache_size 16K 16K realpath_cache_ttl 120 120 register_argc_argv On On register_globals On On register_long_arrays On On report_memleaks On On report_zend_debug On On safe_mode Off Off safe_mode_exec_dir /usr/local/php/bin /usr/local/php/bin safe_mode_gid Off Off safe_mode_include_dir no value no value sendmail_from no value no value sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i serialize_precision 100 100 short_open_tag On On SMTP localhost localhost smtp_port 25 25 sql.safe_mode Off Off track_errors Off Off unserialize_callback_func no value no value upload_max_filesize 250000000 250000000 upload_tmp_dir /localservices/phpupload /localservices/phpupload user_dir no value no value variables_order EGPCS EGPCS xmlrpc_error_number 0 0 xmlrpc_errors Off Off y2k_compliance On On zend.ze1_compatibility_mode Off Off apacheAPACHE_INCLUDE no value APACHE_TARGET no value Apache Version Apache Apache Release 10339100 Apache API Version 19990320 Hostname:Port www.carrierzone.com:0 User/Group nobody(65534)/65534 Max Requests Per Child: 10000 - Keep Alive: on - Max Per Connection: 100 Timeouts Connection: 150 - Keep-Alive: 10 Server Root /services/apache Loaded Modules mod_hproxy, mod_php5, mod_frontpage, mod_setenvif, mod_auth, mod_access, mod_rewrite, mod_alias, mod_speling, mod_actions, mod_imap, mod_cgi, mod_dir, mod_autoindex, mod_include, mod_negotiation, mod_mime, mod_log_config, mod_env, mod_vhost_alias, http_core Directive Local Value Master Value child_terminate 0 0 engine 1 1 last_modified 0 0 xbithack 0 0 Apache EnvironmentVariable Value DOCUMENT_ROOT /services/webpages/m/k/mklo.net/public GDFONTPATH /services/share/fonts HTTP_ACCEPT text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1 HTTP_ACCEPT_CHARSET iso-8859-1, utf-8, utf-16, *;q=0.1 HTTP_ACCEPT_ENCODING deflate, gzip, x-gzip, identity, *;q=0 HTTP_ACCEPT_LANGUAGE en-US,en;q=0.9 HTTP_CONNECTION Keep-Alive HTTP_HOST www.mklo.net HTTP_USER_AGENT Opera/9.52 (Windows NT 6.0; U; en) MvCONFIG_LIBRARY /services/websoftware/miva/Empresa/cgi-bin/libmivaconfig.so PATH /usr/bin:/bin:/sbin:/usr/sbin:/usr/local/bin REMOTE_ADDR 68.100.219.215 REMOTE_HOST ip68-100-219-215.dc.dc.cox.net REMOTE_PORT 50193 SCRIPT_FILENAME /services/webpages/m/k/mklo.net/public/phpinfo.php SERVER_ADDR 64.29.145.73 SERVER_ADMIN or webmaster SERVER_DOMAIN mklo.net SERVER_NAME www.mklo.net SERVER_PORT 80 SERVER_SIGNATURE no value SERVER_SOFTWARE Apache GATEWAY_INTERFACE CGI/1.1 SERVER_PROTOCOL HTTP/1.1 REQUEST_METHOD GET QUERY_STRING no value REQUEST_URI /phpinfo.php SCRIPT_NAME /phpinfo.php HTTP Headers InformationHTTP Request Headers HTTP Request GET /phpinfo.php HTTP/1.1 Accept text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1 Accept-Charset iso-8859-1, utf-8, utf-16, *;q=0.1 Accept-Encoding deflate, gzip, x-gzip, identity, *;q=0 Accept-Language en-US,en;q=0.9 Connection Keep-Alive Host www.mklo.net User-Agent Opera/9.52 (Windows NT 6.0; U; en) HTTP Response Headers X-Powered-By PHP/5.2.4 Keep-Alive timeout=10, max=100 Connection Keep-Alive Transfer-Encoding chunked Content-Type text/html ctypectype functions enabled curlcURL support enabled cURL Information libcurl/7.17.0 OpenSSL/0.9.8g zlib/1.2.3 datedate/time support enabled "Olson" Timezone Database Version 2007.6 Timezone Database internal Default timezone America/New_York Directive Local Value Master Value date.default_latitude 31.7667 31.7667 date.default_longitude 35.2333 35.2333 date.sunrise_zenith 90.583333 90.583333 date.sunset_zenith 90.583333 90.583333 date.timezone no value no value dbaDBA support enabled Supported handlers gdbm cdb cdb_make db2 inifile flatfile domDOM/XML enabled DOM/XML API Version 20031129 libxml Version 2.6.27 HTML Support enabled XPath Support enabled XPointer Support enabled Schema Support enabled RelaxNG Support enabled filterInput Validation and Filtering enabled Revision $Revision: 1.52.2.39 $ Directive Local Value Master Value filter.default unsafe_raw unsafe_raw filter.default_flags no value no value gdGD Support enabled GD Version bundled (2.0.34 compatible) FreeType Support enabled FreeType Linkage with freetype FreeType Version 2.3.5 GIF Read Support enabled GIF Create Support enabled JPG Support enabled PNG Support enabled WBMP Support enabled XBM Support enabled gettextGetText Support enabled hashhash support enabled Hashing Engines md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5 iconviconv support enabled iconv implementation glibc iconv library version 2.2.4 Directive Local Value Master Value iconv.input_encoding ISO-8859-1 ISO-8859-1 iconv.internal_encoding ISO-8859-1 ISO-8859-1 iconv.output_encoding ISO-8859-1 ISO-8859-1 imapIMAP c-Client Version 2000 jsonjson support enabled json version 1.2.1 libxmllibXML support active libXML Version 2.6.27 libXML streams enabled mbstringMultibyte Support enabled Multibyte string engine libmbfl Multibyte (japanese) regex support enabled Multibyte regex (oniguruma) version 4.4.4 Multibyte regex (oniguruma) backtrack check On mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1. Directive Local Value Master Value mbstring.detect_order no value no value mbstring.encoding_translation Off Off mbstring.func_overload 0 0 mbstring.http_input pass pass mbstring.http_output pass pass mbstring.internal_encoding no value no value mbstring.language neutral neutral mbstring.strict_detection Off Off mbstring.substitute_character no value no value mcryptmcrypt support enabled Version 2.5.8 Api No 20021217 Supported ciphers cast-128 gost rijndael-128 twofish arcfour cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes Supported modes cbc cfb ctr ecb ncfb nofb ofb stream Directive Local Value Master Value mcrypt.algorithms_dir no value no value mcrypt.modes_dir no value no value mysqlMySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 3.23.54 MYSQL_MODULE_TYPE external MYSQL_SOCKET /tmp/mysql.sock MYSQL_INCLUDE -I/usr/local/mysql/include/mysql MYSQL_LIBS -L/usr/local/mysql/lib/mysql -lmysqlclient Directive Local Value Master Value mysql.allow_persistent Off Off mysql.connect_timeout 60 60 mysql.default_host no value no value mysql.default_password no value no value mysql.default_port no value no value mysql.default_socket no value no value mysql.default_user no value no value mysql.max_links Unlimited Unlimited mysql.max_persistent Unlimited Unlimited mysql.trace_mode Off Off opensslOpenSSL support enabled OpenSSL Version OpenSSL 0.9.8f 11 Oct 2007 pcrePCRE (Perl Compatible Regular Expressions) Support enabled PCRE Library Version 7.2 2007-06-19 Directive Local Value Master Value pcre.backtrack_limit 100000 100000 pcre.recursion_limit 100000 100000 PDOPDO support enabled PDO drivers sqlite2, sqlite pdo_sqlitePDO Driver for SQLite 3.x enabled PECL Module version (bundled) 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.2 2007/03/23 14:30:00 wez Exp $ SQLite Library 3.3.17 ReflectionReflection enabled Version $Id: php_reflection.c,v 1.164.2.33.2.45 2007/08/20 17:01:22 sebastian Exp $ sessionSession Support enabled Registered save handlers files user sqlite Registered serializer handlers php php_binary wddx Directive Local Value Master Value session.auto_start Off Off session.bug_compat_42 On On session.bug_compat_warn On On session.cache_expire 180 180 session.cache_limiter nocache nocache session.cookie_domain no value no value session.cookie_httponly Off Off session.cookie_lifetime 0 0 session.cookie_path / / session.cookie_secure Off Off session.entropy_file no value no value session.entropy_length 0 0 session.gc_divisor 100 100 session.gc_maxlifetime 1440 1440 session.gc_probability 1 1 session.hash_bits_per_character 4 4 session.hash_function 0 0 session.name PHPSESSID PHPSESSID session.referer_check no value no value session.save_handler files files session.save_path /services/webdata/php_sessions /services/webdata/php_sessions session.serialize_handler php php session.use_cookies On On session.use_only_cookies Off Off session.use_trans_sid 0 0 SimpleXMLSimplexml support enabled Revision $Revision: 1.151.2.22.2.35 $ Schema support enabled siteguardSiteGuard Support enabled Userlock enabled uid 8025 ipf no homedirprefix /services/webpages WebServerMode enabled soapSoap Client enabled Soap Server enabled Directive Local Value Master Value soap.wsdl_cache 1 1 soap.wsdl_cache_dir /tmp /tmp soap.wsdl_cache_enabled 1 1 soap.wsdl_cache_limit 5 5 soap.wsdl_cache_ttl 86400 86400 SPLSPL support enabled Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RegexIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException SQLiteSQLite support enabled PECL Module version 2.0-dev $Id: sqlite.c,v 1.166.2.13.2.9 2007/05/19 17:58:22 iliaa Exp $ SQLite Library 2.8.17 SQLite Encoding iso8859 Directive Local Value Master Value sqlite.assoc_case 0 0 standardRegex Library Bundled library enabled Dynamic Library Support enabled Path to sendmail /usr/sbin/sendmail -t -i Directive Local Value Master Value assert.active 1 1 assert.bail 0 0 assert.callback no value no value assert.quiet_eval 0 0 assert.warning 1 1 auto_detect_line_endings 0 0 default_socket_timeout 60 60 safe_mode_allowed_env_vars PHP_ PHP_ safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH url_rewriter.tags a=href,area=href,frame=src,form=,fieldset= a=href,area=href,frame=src,form=,fieldset= user_agent no value no value tokenizerTokenizer Support enabled wddxWDDX Support enabled WDDX Session Serializer enabled xmlXML Support active XML Namespace Support active libxml2 Version 2.6.27 xmlreaderXMLReader enabled xmlwriterXMLWriter enabled zlibZLib Support enabled Stream Wrapper support compress.zlib:// Stream Filter support zlib.inflate, zlib.deflate Compiled Version 1.2.3 Linked Version 1.2.3 Directive Local Value Master Value zlib.output_compression Off Off zlib.output_compression_level -1 -1 zlib.output_handler no value no value Additional ModulesModule Name dbase EnvironmentVariable Value SHELL /bin/bash SSH_CLIENT 64.29.146.10 42909 22 USER root TWO_TASK /localservices/oracle8/network/admin/tnsnames.ora LD_LIBRARY_PATH /localservices/oracle8/lib LS_COLORS no value ORACLE_SID TOR GDFONTPATH /services/share/fonts MAIL /var/mail/root PATH /usr/bin:/bin:/sbin:/usr/sbin:/usr/local/bin PWD /root SHLVL 3 HOME /root LS_OPTIONS -a -N --color=none -T 0 LOGNAME root ORACLE_HOME /localservices/oracle8 _ /services/apache/bin/httpd PHP VariablesVariable Value PHP_SELF /phpinfo.php _SERVER["DOCUMENT_ROOT"] /services/webpages/m/k/mklo.net/public _SERVER["GDFONTPATH"] /services/share/fonts _SERVER["HTTP_ACCEPT"] text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1 _SERVER["HTTP_ACCEPT_CHARSET"] iso-8859-1, utf-8, utf-16, *;q=0.1 _SERVER["HTTP_ACCEPT_ENCODING"] deflate, gzip, x-gzip, identity, *;q=0 _SERVER["HTTP_ACCEPT_LANGUAGE"] en-US,en;q=0.9 _SERVER["HTTP_CONNECTION"] Keep-Alive _SERVER["HTTP_HOST"] www.mklo.net _SERVER["HTTP_USER_AGENT"] Opera/9.52 (Windows NT 6.0; U; en) _SERVER["MvCONFIG_LIBRARY"] /services/websoftware/miva/Empresa/cgi-bin/libmivaconfig.so _SERVER["PATH"] /usr/bin:/bin:/sbin:/usr/sbin:/usr/local/bin _SERVER["REMOTE_ADDR"] 68.100.219.215 _SERVER["REMOTE_HOST"] ip68-100-219-215.dc.dc.cox.net _SERVER["REMOTE_PORT"] 50193 _SERVER["SCRIPT_FILENAME"] /services/webpages/m/k/mklo.net/public/phpinfo.php _SERVER["SERVER_ADDR"] 64.29.145.73 _SERVER["SERVER_ADMIN"] or webmaster _SERVER["SERVER_DOMAIN"] mklo.net _SERVER["SERVER_NAME"] www.mklo.net _SERVER["SERVER_PORT"] 80 _SERVER["SERVER_SIGNATURE"] no value _SERVER["SERVER_SOFTWARE"] Apache _SERVER["GATEWAY_INTERFACE"] CGI/1.1 _SERVER["SERVER_PROTOCOL"] HTTP/1.1 _SERVER["REQUEST_METHOD"] GET _SERVER["QUERY_STRING"] no value _SERVER["REQUEST_URI"] /phpinfo.php _SERVER["SCRIPT_NAME"] /phpinfo.php _SERVER["PATH_TRANSLATED"] /services/webpages/m/k/mklo.net/public/phpinfo.php _SERVER["PHP_SELF"] /phpinfo.php _SERVER["REQUEST_TIME"] 1220291649 _SERVER["argv"] Array ( ) _SERVER["argc"] 0 _ENV["SHELL"] /bin/bash _ENV["SSH_CLIENT"] 64.29.146.10 42909 22 _ENV["USER"] root _ENV["TWO_TASK"] /localservices/oracle8/network/admin/tnsnames.ora _ENV["LD_LIBRARY_PATH"] /localservices/oracle8/lib _ENV["LS_COLORS"] no value _ENV["ORACLE_SID"] TOR _ENV["GDFONTPATH"] /services/share/fonts _ENV["MAIL"] /var/mail/root _ENV["PATH"] /usr/bin:/bin:/sbin:/usr/sbin:/usr/local/bin _ENV["PWD"] /root _ENV["SHLVL"] 3 _ENV["HOME"] /root _ENV["LS_OPTIONS"] -a -N --color=none -T 0 _ENV["LOGNAME"] root _ENV["ORACLE_HOME"] /localservices/oracle8 _ENV["_"] /services/apache/bin/httpd ----------------------------------------- Here's the PHPINFO output from the one tha's giving me a problem: ----------------------------------------- PHP Version 5.2.4-2ubuntu5.3 System Linux intra 2.6.24-19-server #1 SMP Wed Jun 18 15:18:00 UTC 2008 i686 Build Date Jul 23 2008 06:28:41 Server API Apache 2.0 Handler Virtual Directory Support disabled Configuration File (php.ini) Path /etc/php5/apache2 Loaded Configuration File /etc/php5/apache2/php.ini Scan this dir for additional .ini files /etc/php5/apache2/conf.d additional .ini files parsed /etc/php5/apache2/conf.d/mysql.ini, /etc/php5/apache2/conf.d/mysqli.ini, /etc/php5/apache2/conf.d/pdo.ini, /etc/php5/apache2/conf.d/pdo_mysql.ini PHP API 20041225 PHP Extension 20060613 Zend Extension 220060519 Debug Build no Thread Safety disabled Zend Memory Manager enabled IPv6 Support enabled Registered PHP Streams zip, php, file, data, http, ftp, compress.bzip2, compress.zlib, https, ftps Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*, bzip2.*, zlib.* This server is protected with the Suhosin Patch 0.9.6.2 Copyright © 2006 Hardened-PHP Project This program makes use of the Zend Scripting Language Engine: Zend Engine v2.2.0, Copyright © 1998-2007 Zend Technologies PHP Credits Configuration PHP CoreDirective Local Value Master Value allow_call_time_pass_reference On On allow_url_fopen On On allow_url_include Off Off always_populate_raw_post_data Off Off arg_separator.input & & arg_separator.output & & asp_tags Off Off auto_append_file no value no value auto_globals_jit On On auto_prepend_file no value no value browscap no value no value default_charset no value no value default_mimetype text/html text/html define_syslog_variables Off Off disable_classes no value no value disable_functions no value no value display_errors On On display_startup_errors Off Off doc_root no value no value docref_ext no value no value docref_root no value no value enable_dl Off Off error_append_string no value no value error_log no value no value error_prepend_string no value no value error_reporting 6135 6135 expose_php On On extension_dir /opt/lampp/lib/php/extensions/no-debug-non-zts-20020429 /opt/lampp/lib/php/extensions/no-debug-non-zts-20020429 file_uploads On On highlight.bg #FFFFFF #FFFFFF highlight.comment #FF8000 #FF8000 highlight.default #0000BB #0000BB highlight.html #000000 #000000 highlight.keyword #007700 #007700 highlight.string #DD0000 #DD0000 html_errors On On ignore_repeated_errors Off Off ignore_repeated_source Off Off ignore_user_abort Off Off implicit_flush Off Off include_path .:/usr/share/php:/usr/share/pear .:/usr/share/php:/usr/share/pear log_errors Off Off log_errors_max_len 1024 1024 magic_quotes_gpc On On magic_quotes_runtime Off Off magic_quotes_sybase Off Off mail.force_extra_parameters no value no value max_execution_time 30 30 max_input_nesting_level 64 64 max_input_time 60 60 memory_limit 128M 128M open_basedir no value no value output_buffering no value no value output_handler no value no value post_max_size 128M 128M precision 12 12 realpath_cache_size 16K 16K realpath_cache_ttl 120 120 register_argc_argv On On register_globals Off Off register_long_arrays On On report_memleaks On On report_zend_debug On On safe_mode Off Off safe_mode_exec_dir no value no value safe_mode_gid Off Off safe_mode_include_dir no value no value sendmail_from no value no value sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i serialize_precision 100 100 short_open_tag On On SMTP localhost localhost smtp_port 25 25 sql.safe_mode Off Off suhosin.log.phpscript 0 0 suhosin.log.phpscript.is_safe Off Off suhosin.log.phpscript.name no value no value suhosin.log.sapi no value no value suhosin.log.script no value no value suhosin.log.script.name no value no value suhosin.log.syslog no value no value suhosin.log.syslog.facility no value no value suhosin.log.syslog.priority no value no value suhosin.log.use-x-forwarded-for Off Off track_errors Off Off unserialize_callback_func no value no value upload_max_filesize 2M 2M upload_tmp_dir no value no value user_dir no value no value variables_order EGPCS EGPCS xmlrpc_error_number 0 0 xmlrpc_errors Off Off y2k_compliance On On zend.ze1_compatibility_mode Off Off apache2handlerApache Version Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.3 with Suhosin-Patch Apache API Version 20051115 Server Administrator webmaster@localhost Hostname:Port hop.mywebhop.org:0 User/Group www-data(33)/33 Max Requests Per Child: 0 - Keep Alive: on - Max Per Connection: 100 Timeouts Connection: 300 - Keep-Alive: 15 Virtual Server Yes Server Root /etc/apache2 Loaded Modules core mod_log_config mod_logio prefork http_core mod_so mod_alias mod_auth_basic mod_authn_file mod_authz_default mod_authz_groupfile mod_authz_host mod_authz_user mod_autoindex mod_cgi mod_dir mod_env mod_mime mod_negotiation mod_php5 mod_setenvif mod_status Directive Local Value Master Value engine 1 1 last_modified 0 0 xbithack 0 0 Apache EnvironmentVariable Value HTTP_USER_AGENT Opera/9.52 (Windows NT 6.0; U; en) HTTP_HOST 70.108.254.138 HTTP_ACCEPT text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1 HTTP_ACCEPT_LANGUAGE en-US,en;q=0.9 HTTP_ACCEPT_CHARSET iso-8859-1, utf-8, utf-16, *;q=0.1 HTTP_ACCEPT_ENCODING deflate, gzip, x-gzip, identity, *;q=0 HTTP_CACHE_CONTROL no-cache HTTP_CONNECTION Keep-Alive, TE HTTP_TE deflate, gzip, chunked, identity, trailers PATH /usr/local/bin:/usr/bin:/bin SERVER_SIGNATURE <address>Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.3 with Suhosin-Patch Server at 70.108.254.138 Port 80</address> SERVER_SOFTWARE Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.3 with Suhosin-Patch SERVER_NAME 70.108.254.138 SERVER_ADDR 192.168.1.2 SERVER_PORT 80 REMOTE_ADDR 68.100.219.215 DOCUMENT_ROOT /var/www/ SERVER_ADMIN webmaster@localhost SCRIPT_FILENAME /var/www/xampp.orig/xampp/phpinfo.php REMOTE_PORT 53953 GATEWAY_INTERFACE CGI/1.1 SERVER_PROTOCOL HTTP/1.1 REQUEST_METHOD GET QUERY_STRING no value REQUEST_URI /xampp.orig/xampp/phpinfo.php SCRIPT_NAME /xampp.orig/xampp/phpinfo.php HTTP Headers InformationHTTP Request Headers HTTP Request GET /xampp.orig/xampp/phpinfo.php HTTP/1.1 User-Agent Opera/9.52 (Windows NT 6.0; U; en) Host 70.108.254.138 Accept text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1 Accept-Language en-US,en;q=0.9 Accept-Charset iso-8859-1, utf-8, utf-16, *;q=0.1 Accept-Encoding deflate, gzip, x-gzip, identity, *;q=0 Cache-Control no-cache Connection Keep-Alive, TE TE deflate, gzip, chunked, identity, trailers HTTP Response Headers X-Powered-By PHP/5.2.4-2ubuntu5.3 Keep-Alive timeout=15, max=100 Connection Keep-Alive Transfer-Encoding chunked Content-Type text/html bcmathBCMath support enabled bz2BZip2 Support Enabled Stream Wrapper support compress.bz2:// Stream Filter support bzip2.decompress, bzip2.compress BZip2 Version 1.0.4, 20-Dec-2006 calendarCalendar support enabled ctypectype functions enabled datedate/time support enabled "Olson" Timezone Database Version 2007.6 Timezone Database internal Default timezone America/New_York Directive Local Value Master Value date.default_latitude 31.7667 31.7667 date.default_longitude 35.2333 35.2333 date.sunrise_zenith 90.583333 90.583333 date.sunset_zenith 90.583333 90.583333 date.timezone no value no value dbaDBA support enabled Supported handlers cdb cdb_make db4 inifile flatfile domDOM/XML enabled DOM/XML API Version 20031129 libxml Version 2.6.31 HTML Support enabled XPath Support enabled XPointer Support enabled Schema Support enabled RelaxNG Support enabled exifEXIF Support enabled EXIF Version 1.4 $Id: exif.c,v 1.173.2.5.2.20 2007/06/10 20:12:45 iliaa Exp $ Supported EXIF Version 0220 Supported filetypes JPEG,TIFF filterInput Validation and Filtering enabled Revision $Revision: 1.52.2.39 $ Directive Local Value Master Value filter.default unsafe_raw unsafe_raw filter.default_flags no value no value ftpFTP support enabled gettextGetText Support enabled hashhash support enabled Hashing Engines md2 md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5 iconviconv support enabled iconv implementation glibc iconv library version 2.7 Directive Local Value Master Value iconv.input_encoding ISO-8859-1 ISO-8859-1 iconv.internal_encoding ISO-8859-1 ISO-8859-1 iconv.output_encoding ISO-8859-1 ISO-8859-1 jsonjson support enabled json version 1.2.1 libxmllibXML support active libXML Version 2.6.31 libXML streams enabled mbstringMultibyte Support enabled Multibyte string engine libmbfl Multibyte (japanese) regex support enabled Multibyte regex (oniguruma) version 4.4.4 Multibyte regex (oniguruma) backtrack check On mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1. Directive Local Value Master Value mbstring.detect_order no value no value mbstring.encoding_translation Off Off mbstring.func_overload 0 0 mbstring.http_input pass pass mbstring.http_output pass pass mbstring.internal_encoding ISO-8859-1 no value mbstring.language neutral neutral mbstring.strict_detection Off Off mbstring.substitute_character no value no value mime_magicmime_magic support invalid magic file, disabled Directive Local Value Master Value mime_magic.debug Off Off mime_magic.magicfile /usr/share/file/magic.mime /usr/share/file/magic.mime opensslOpenSSL support enabled OpenSSL Version OpenSSL 0.9.8g 19 Oct 2007 pcrePCRE (Perl Compatible Regular Expressions) Support enabled PCRE Library Version 7.4 2007-09-21 Directive Local Value Master Value pcre.backtrack_limit 100000 100000 pcre.recursion_limit 100000 100000 posixRevision $Revision: 1.70.2.3.2.16 $ ReflectionReflection enabled Version $Id: php_reflection.c,v 1.164.2.33.2.45 2007/08/20 17:01:22 sebastian Exp $ sessionSession Support enabled Registered save handlers files user Registered serializer handlers php php_binary wddx Directive Local Value Master Value session.auto_start Off Off session.bug_compat_42 On On session.bug_compat_warn On On session.cache_expire 180 180 session.cache_limiter nocache nocache session.cookie_domain no value no value session.cookie_httponly Off Off session.cookie_lifetime 0 0 session.cookie_path / / session.cookie_secure Off Off session.entropy_file no value no value session.entropy_length 0 0 session.gc_divisor 100 100 session.gc_maxlifetime 1440 1440 session.gc_probability 0 0 session.hash_bits_per_character 4 4 session.hash_function 0 0 session.name PHPSESSID PHPSESSID session.referer_check no value no value session.save_handler files files session.save_path /var/lib/php5 /var/lib/php5 session.serialize_handler php php session.use_cookies On On session.use_only_cookies Off Off session.use_trans_sid 0 0 shmopshmop support enabled SimpleXMLSimplexml support enabled Revision $Revision: 1.151.2.22.2.35 $ Schema support enabled soapSoap Client enabled Soap Server enabled Directive Local Value Master Value soap.wsdl_cache 1 1 soap.wsdl_cache_dir /tmp /tmp soap.wsdl_cache_enabled 1 1 soap.wsdl_cache_limit 5 5 soap.wsdl_cache_ttl 86400 86400 socketsSockets Support enabled SPLSPL support enabled Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RegexIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException standardRegex Library Bundled library enabled Dynamic Library Support enabled Path to sendmail /usr/sbin/sendmail -t -i Directive Local Value Master Value assert.active 1 1 assert.bail 0 0 assert.callback no value no value assert.quiet_eval 0 0 assert.warning 1 1 auto_detect_line_endings 0 0 default_socket_timeout 60 60 safe_mode_allowed_env_vars PHP_ PHP_ safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH url_rewriter.tags a=href,area=href,frame=src,input=src,form=,fieldset= a=href,area=href,frame=src,input=src,form=,fieldset= user_agent no value no value sysvmsgsysvmsg support enabled Revision $Revision: 1.20.2.3.2.6 $ tokenizerTokenizer Support enabled wddxWDDX Support enabled WDDX Session Serializer enabled xmlXML Support active XML Namespace Support active libxml2 Version 2.6.31 xmlreaderXMLReader enabled xmlwriterXMLWriter enabled zipZip enabled Extension Version $Id: php_zip.c,v 1.1.2.38 2007/08/06 22:02:32 bjori Exp $ Zip version 2.0.0 Libzip version 0.7.1 zlibZLib Support enabled Stream Wrapper support compress.zlib:// Stream Filter support zlib.inflate, zlib.deflate Compiled Version 1.2.1.1 Linked Version 1.2.3.3 Directive Local Value Master Value zlib.output_compression Off Off zlib.output_compression_level -1 -1 zlib.output_handler no value no value Additional ModulesModule Name sysvsem sysvshm EnvironmentVariable Value APACHE_PID_FILE /var/run/apache2.pid PATH /usr/local/bin:/usr/bin:/bin LANG C APACHE_RUN_GROUP www-data APACHE_RUN_USER www-data PWD /etc/init.d PHP VariablesVariable Value _SERVER["HTTP_USER_AGENT"] Opera/9.52 (Windows NT 6.0; U; en) _SERVER["HTTP_HOST"] 70.108.254.138 _SERVER["HTTP_ACCEPT"] text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1 _SERVER["HTTP_ACCEPT_LANGUAGE"] en-US,en;q=0.9 _SERVER["HTTP_ACCEPT_CHARSET"] iso-8859-1, utf-8, utf-16, *;q=0.1 _SERVER["HTTP_ACCEPT_ENCODING"] deflate, gzip, x-gzip, identity, *;q=0 _SERVER["HTTP_CACHE_CONTROL"] no-cache _SERVER["HTTP_CONNECTION"] Keep-Alive, TE _SERVER["HTTP_TE"] deflate, gzip, chunked, identity, trailers _SERVER["PATH"] /usr/local/bin:/usr/bin:/bin _SERVER["SERVER_SIGNATURE"] <address>Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.3 with Suhosin-Patch Server at 70.108.254.138 Port 80</address> _SERVER["SERVER_SOFTWARE"] Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.3 with Suhosin-Patch _SERVER["SERVER_NAME"] 70.108.254.138 _SERVER["SERVER_ADDR"] 192.168.1.2 _SERVER["SERVER_PORT"] 80 _SERVER["REMOTE_ADDR"] 68.100.219.215 _SERVER["DOCUMENT_ROOT"] /var/www/ _SERVER["SERVER_ADMIN"] webmaster@localhost _SERVER["SCRIPT_FILENAME"] /var/www/xampp.orig/xampp/phpinfo.php _SERVER["REMOTE_PORT"] 53953 _SERVER["GATEWAY_INTERFACE"] CGI/1.1 _SERVER["SERVER_PROTOCOL"] HTTP/1.1 _SERVER["REQUEST_METHOD"] GET _SERVER["QUERY_STRING"] no value _SERVER["REQUEST_URI"] /xampp.orig/xampp/phpinfo.php _SERVER["SCRIPT_NAME"] /xampp.orig/xampp/phpinfo.php _SERVER["PHP_SELF"] /xampp.orig/xampp/phpinfo.php _SERVER["REQUEST_TIME"] 1220319702 _SERVER["argv"] Array ( ) _SERVER["argc"] 0 _ENV["APACHE_PID_FILE"] /var/run/apache2.pid _ENV["PATH"] /usr/local/bin:/usr/bin:/bin _ENV["LANG"] C _ENV["APACHE_RUN_GROUP"] www-data _ENV["APACHE_RUN_USER"] www-data _ENV["PWD"] /etc/init.d ------------------------------------------------ I would really appreciate help on this. Thanks.

Hi! With .csv files, I don't think you can include any formatting information that Excel would recognize. Try loading a .csv file in excel, format the cells (change fonts, column widths, etc.) then try saving the file. Excel will warn you that you will lose any formatting if you proceed to save the file as a .csv file.

Hi! First of all I have to tell you I've only been using PHP for 4 months or so I'm not completely sure the solution I'm about to describe is the best way to do this. That said, I would generate temporary php script where the value of final1 is now used as a variable. Your main script would write a few lines of php code into a .php file and then call the generated .php file. Does that make sense to you?