php-general Digest 4 Oct 2010 21:08:56 -0000 Issue 6973
php-general Digest 4 Oct 2010 21:08:56 - Issue 6973 Topics (messages 308417 through 308449): Re: Syntax Error 308417 by: a...@ashleysheridan.co.uk New to PHP and struggling with the basics 308418 by: Col Day 308419 by: Peter Lind 308422 by: kranthi 308423 by: Abah Joseph 308428 by: Col Day 308429 by: kranthi 308431 by: Alejandro Michelin Salomon 308433 by: Col Day 308436 by: Steve Staples 308438 by: Col Day 308439 by: Col Day Re: file_get_contents() failing on CentOS. 308420 by: Richard Quadling 308421 by: kranthi 308424 by: Richard Quadling 308427 by: Richard Quadling 308430 by: kranthi Re: Little Parsing help... 308425 by: Richard Quadling 308426 by: Richard Quadling 308437 by: Adam Richardson 308440 by: Richard Quadling open .zip from memory... 308432 by: Steve Staples 308442 by: Jim Lucas 308443 by: Steve Staples Re: cant find uploaded file in /tmp. 308434 by: tedd Is it possible to create a global namespace alias? 308435 by: Matt Palermo Join me on Multiply 308441 by: Farianto Kurniawan (via Multiply) PHPExcel with large files (27,000+ rows) 308444 by: chris h 308445 by: Per Jessen 308446 by: Marc Guay 308447 by: shiplu 308448 by: chris h Connecting to MySql with PHP 308449 by: sueandant Administrivia: To subscribe to the digest, e-mail: php-general-digest-subscr...@lists.php.net To unsubscribe from the digest, e-mail: php-general-digest-unsubscr...@lists.php.net To post to the list, e-mail: php-gene...@lists.php.net -- ---BeginMessage--- Switching to pdo won't necessarily remove sql errors any more than using a php framework will remove php errors. Thanks, Ash http://www.ashleysheridan.co.uk - Reply message - From: kranthi kranthi...@gmail.com Date: Mon, Oct 4, 2010 09:04 Subject: [PHP] Syntax Error To: a...@ashleysheridan.co.uk Cc: chris h chris...@gmail.com, Gary gp...@paulgdesigns.com, php-gene...@lists.php.net As pointed out echo $insertSQl should help you locate many trivial problems. But using PDO will avoid these kind of problems -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ---End Message--- ---BeginMessage--- Hi all, Working with the PHP5 for Dummies book (yup real noob, feel free to ridicule (after telling me what I've done wrong)) and have installed Apache 2.2 and PHP 5.3.3 onto a laptop running Vista. (yes I know!!!). I've had Apache running fine with my basic web site created using Serif's Webplus10 but wanted to experiment with PHP as I want an uploadable area on my website for my friends and family to submit video/photos. I've checked the install of PHP using php -v and I get the output that PHP 5.3.3 (cli) (built: Jul 21 2010 20:10:20) but when I try and go to the test.php file (below) I get an http 403 webiste requires you to log in. Error message. html head titlePHP Test/title /head body pThis is an HTML line ?php echo pThis is a PHP line/p; phpinfo(); ? /body /html This is the text of the test.php file which I have plonked down in /apache/htdocs What have I missed? the Dummies book is quoting PHP 5.0.0 as the latest release so not too far away really. Thanks for your help. Cheers. Col Day ---End Message--- ---BeginMessage--- On 4 October 2010 11:30, Col Day colind...@aol.com wrote: Hi all, Working with the PHP5 for Dummies book (yup real noob, feel free to ridicule (after telling me what I've done wrong)) and have installed Apache 2.2 and PHP 5.3.3 onto a laptop running Vista. (yes I know!!!). I've had Apache running fine with my basic web site created using Serif's Webplus10 but wanted to experiment with PHP as I want an uploadable area on my website for my friends and family to submit video/photos. I've checked the install of PHP using php -v and I get the output that PHP 5.3.3 (cli) (built: Jul 21 2010 20:10:20) but when I try and go to the test.php file (below) I get an http 403 webiste requires you to log in. Error message. html head titlePHP Test/title /head body pThis is an HTML line ?php echo pThis is a PHP line/p; phpinfo(); ? /body /html This is the text of the test.php file which I have plonked down in /apache/htdocs What have I missed? the Dummies book is quoting PHP 5.0.0 as the latest release so not too far away really. A) v5.0.0 is years old. B) your issue is with apache, not php - 403 is a you have no permission to see this. Check permissions for the file you're trying to test, as well as for the folder. Also, seeing as you're naming the file test.php, make sure you're browsing for that file and not just / or index.php. Regards Peter -- hype WWW: http://plphp.dk /
Re: [PHP] file_get_contents() failing on CentOS.
On 1 October 2010 16:19, kranthi kranthi...@gmail.com wrote: probably not the issue, but is the php engine behind a proxy server ? wget uses the environment variable, but PHP does not Kranthi. http://goo.gl/e6t3 Hopefully getting a reply today on this. What env_var is used by wget? -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] New to PHP and struggling with the basics
Kranthi Many thanks, any idea on the name of the error logs? Peter, Yes, browsing to the correct location but still getting the 403. this website requires you to log in. Abah, I've gone to the httpd-userdir.conf file and replaced it with your text (not including the directory tree), restarted apache (after each change) but am still getting the same error. However I have found that if I paste the html into my web page created by Serif WebPlus 10 I get the html line but not the php line. Any further thoughts? It has to be something simple that I'vw not done! Cheers all. kranthi kranthi...@gmail.com wrote in message news:aanlktik6=68ho+hdfpvd3x2qmrudlz_ttco2oqk1b...@mail.gmail.com... apache error logs will be helpful in this case. Their location varies depending upon your installation. But in any case they'll be insde your server directory (IIRC it is c:/Program Files/Apache Software Foundation/Apache by default) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Syntax Error
As pointed out echo $insertSQl should help you locate many trivial problems. But using PDO will avoid these kind of problems -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Little Parsing help...
On 1 October 2010 16:20, Don Wieland d...@pointmade.net wrote:
The logic I need is pretty straight forward, but I am having a hard time
replicating it using PHP functions. I will try to break it down to it's
simplest form:
I have a field that has several lines of text. Chords and Song Lyrics.
The Chord lines begin with an asterisk * and end with the line break.
This is the string I want to parse. Lines with no asterisk at the beginning
are ignored.
Based on 3 arrays of NOTES, I want SUBSTITUTE the text (based on exact text
character patterns - just NOTES not the chord type) of the lines in my field
that start with an asterisk *.
original_chord_array = A, A#, B, C, C#, D, D#, E, F, F#, G, G#
transpose_up_array = A#, B, C, C#, D, D#, E, F, F#, G, G#, A
transpose_down_array = G#, A, A#, B, C, C#, D, D#, E, F, F#, G
It is important that it only effects EXACT strings. Notes will always be
capitalized and chord types will be lower case. Maybe we can use that
characteristic to better identify what to change. Here are some examples of
chords:
A
Asus7
Csus add9
Dmaj7
F#m7
G#
C#dim no3
When I transpose UP these chords, just the NOTE should change:
A#
A#sus7
C#sus add9
D#maj7
Gm7
A
Ddim no3
When I transpose DOWN these chords, just the NOTE should change:
G#
G#sus7
Bsus add9
C#maj7
Fm7
G
Cdim no3
I am working on a function, but still not producing the proper results.
Hopefully this break down is more clear and someone will bail me out ;-)
Thanks again for the feedback.
Don
On Oct 1, 2010, at 7:02 AM, Richard Quadling wrote:
Changing the NormalKeyID and using that ID with NoteSequenceNumber
should give you the new note to play.
I think.
/**
* Transpose a chord sequence.
*
* @param $s_Sequence The chord sequence to transpose.
* @param $b_TransposeUp Transpose up or down.
*
* @return The transposed sequence.
*/
function transposeChord($s_Sequence, $b_TransposeUp = True) {
$a_Chords = array('A', 'A#', 'B', 'C', 'C#', 'D', 'D#', 'E', 'F',
'F#', 'G', 'G#');
return preg_replace_callback (
'`([A-G]#?)`',
function($a_Matches) use($a_Chords, $b_TransposeUp) {
// Find the position in the chords array of the found
chord.
$a_ChordPositions = array_keys($a_Chords,
$a_Matches[1], True);
// Get the new chord position.
$i_NewChordPosition = (count($a_Chords) +
$a_ChordPositions[0] +
($b_TransposeUp ? 1 : -1)) % count($a_Chords);
// Return the new chord position.
return $a_Chords[$i_NewChordPosition];
},
$s_Sequence
);
}
--
Richard Quadling
Twitter : EE : Zend
@RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] New to PHP and struggling with the basics
Hi Kranthi, No, I just literally get the HTML line shown but absolutely nothing beneath it. kranthi kranthi...@gmail.com wrote in message news:aanlktin2xnthqm-pp7qwtgo=sqtkctthtwz+08bbw...@mail.gmail.com... they should be something like error_log-[date] not sure about windows though However I have found that if I paste the html into my web page created by Serif WebPlus 10 I get the html line but not the php line. are you saying that you are getting the php code in your browser ? ?php echo pThis is a PHP line/p; phpinfo(); ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] New to PHP and struggling with the basics
On 4 October 2010 11:30, Col Day colind...@aol.com wrote: Hi all, Working with the PHP5 for Dummies book (yup real noob, feel free to ridicule (after telling me what I've done wrong)) and have installed Apache 2.2 and PHP 5.3.3 onto a laptop running Vista. (yes I know!!!). I've had Apache running fine with my basic web site created using Serif's Webplus10 but wanted to experiment with PHP as I want an uploadable area on my website for my friends and family to submit video/photos. I've checked the install of PHP using php -v and I get the output that PHP 5.3.3 (cli) (built: Jul 21 2010 20:10:20) but when I try and go to the test.php file (below) I get an http 403 webiste requires you to log in. Error message. html head titlePHP Test/title /head body pThis is an HTML line ?php echo pThis is a PHP line/p; phpinfo(); ? /body /html This is the text of the test.php file which I have plonked down in /apache/htdocs What have I missed? the Dummies book is quoting PHP 5.0.0 as the latest release so not too far away really. A) v5.0.0 is years old. B) your issue is with apache, not php - 403 is a you have no permission to see this. Check permissions for the file you're trying to test, as well as for the folder. Also, seeing as you're naming the file test.php, make sure you're browsing for that file and not just / or index.php. Regards Peter -- hype WWW: http://plphp.dk / http://plind.dk LinkedIn: http://www.linkedin.com/in/plind BeWelcome/Couchsurfing: Fake51 Twitter: http://twitter.com/kafe15 /hype -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] file_get_contents() failing on CentOS.
http_proxy or HTTP_PROXY i m not sure -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Little Parsing help...
On 4 October 2010 11:26, Richard Quadling rquadl...@gmail.com wrote: On 1 October 2010 16:20, Don Wieland d...@pointmade.net wrote: The logic I need is pretty straight forward, but I am having a hard time replicating it using PHP functions. I will try to break it down to it's simplest form: I have a field that has several lines of text. Chords and Song Lyrics. The Chord lines begin with an asterisk * and end with the line break. This is the string I want to parse. Lines with no asterisk at the beginning are ignored. Based on 3 arrays of NOTES, I want SUBSTITUTE the text (based on exact text character patterns - just NOTES not the chord type) of the lines in my field that start with an asterisk *. original_chord_array = A, A#, B, C, C#, D, D#, E, F, F#, G, G# transpose_up_array = A#, B, C, C#, D, D#, E, F, F#, G, G#, A transpose_down_array = G#, A, A#, B, C, C#, D, D#, E, F, F#, G It is important that it only effects EXACT strings. Notes will always be capitalized and chord types will be lower case. Maybe we can use that characteristic to better identify what to change. Here are some examples of chords: A Asus7 Csus add9 Dmaj7 F#m7 G# C#dim no3 When I transpose UP these chords, just the NOTE should change: A# A#sus7 C#sus add9 D#maj7 Gm7 A Ddim no3 When I transpose DOWN these chords, just the NOTE should change: G# G#sus7 Bsus add9 C#maj7 Fm7 G Cdim no3 I am working on a function, but still not producing the proper results. Hopefully this break down is more clear and someone will bail me out ;-) Thanks again for the feedback. Don On Oct 1, 2010, at 7:02 AM, Richard Quadling wrote: Changing the NormalKeyID and using that ID with NoteSequenceNumber should give you the new note to play. I think. http://pastebin.com/rsV35czb Code with tests and output. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] New to PHP and struggling with the basics
they should be something like error_log-[date] not sure about windows though However I have found that if I paste the html into my web page created by Serif WebPlus 10 I get the html line but not the php line. are you saying that you are getting the php code in your browser ? ?php echo pThis is a PHP line/p; phpinfo(); ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] New to PHP and struggling with the basics
apache error logs will be helpful in this case. Their location varies depending upon your installation. But in any case they'll be insde your server directory (IIRC it is c:/Program Files/Apache Software Foundation/Apache by default) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Syntax Error
Switching to pdo won't necessarily remove sql errors any more than using a php framework will remove php errors. Thanks, Ash http://www.ashleysheridan.co.uk - Reply message - From: kranthi kranthi...@gmail.com Date: Mon, Oct 4, 2010 09:04 Subject: [PHP] Syntax Error To: a...@ashleysheridan.co.uk Cc: chris h chris...@gmail.com, Gary gp...@paulgdesigns.com, php-general@lists.php.net As pointed out echo $insertSQl should help you locate many trivial problems. But using PDO will avoid these kind of problems -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] file_get_contents() failing on CentOS.
and if proxxy is the issue http://proxychains.sf.net/ will help -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] file_get_contents() failing on CentOS.
On 4 October 2010 11:24, Richard Quadling rquadl...@gmail.com wrote: On 4 October 2010 10:48, kranthi kranthi...@gmail.com wrote: http_proxy or HTTP_PROXY i m not sure Thanks. Passing it on (and learning a bit). http://docs.php.net/manual/en/function.stream-context-get-default.php#72086 Could help to some degree. Not sure if SOAPClient will go through the context, though there is a 'stream_context' parameter that can be set ... All passed on. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] New to PHP and struggling with the basics
Hi all, Working with the PHP5 for Dummies book (yup real noob, feel free to ridicule (after telling me what I've done wrong)) and have installed Apache 2.2 and PHP 5.3.3 onto a laptop running Vista. (yes I know!!!). I've had Apache running fine with my basic web site created using Serif's Webplus10 but wanted to experiment with PHP as I want an uploadable area on my website for my friends and family to submit video/photos. I've checked the install of PHP using php -v and I get the output that PHP 5.3.3 (cli) (built: Jul 21 2010 20:10:20) but when I try and go to the test.php file (below) I get an http 403 webiste requires you to log in. Error message. html head titlePHP Test/title /head body pThis is an HTML line ?php echo pThis is a PHP line/p; phpinfo(); ? /body /html This is the text of the test.php file which I have plonked down in /apache/htdocs What have I missed? the Dummies book is quoting PHP 5.0.0 as the latest release so not too far away really. Thanks for your help. Cheers. Col Day -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] cant find uploaded file in /tmp.
At 7:16 PM +0100 10/3/10, Ashley Sheridan wrote: On Sun, 2010-10-03 at 20:53 +0300, Prekates Alexandros wrote: Hi to the list. Trying to test php upload i used a very simple scrip. I managed to upload files but i dont understand why the dont stay in the /tmp dir where the initialy are put even if i dont move them to another dir. alex. Files are put into the /tmp directory by Apache, before PHP is even aware of them. Unless you create a copy of the file, then Apache will clean it up after your script has run (or at least it's supposed to, but sometimes /tmp becomes a little cluttered with crud) The best thing to do is to use move_uploaded_file to move the file to someplace, and give the file a new name (or keep the same one and add an extension if you want to ensure the file is given a unique name in the directory you're putting it into) There are lots of different scripts on the manual page for move_uploaded_file if you're feeling a little stuck. As a safety precaution, it's considered good practice to copy the file to a location outside of your document root. So if your document root is /var/www/html/ then maybe put the file in /var/www/user_files/ . This means that people can't use your website to upload their own scripts and gain access to your server, although it does mean you need to find an alternative way to serve up that file if you need, but that is quite easy, and there are lots of example scripts about for that if you need; many people on the list have written their own, and Tedd most likely has an example somewhere too! Thanks, Ash Ash: Thanks for the plug. The code is pretty simple. If the simple script the OP used did indeed move the file to the tmp directory, then it should be there for him to see. I suspect that: 1) the upload script is not working properly; 2) or the OP needs to refresh his IDE to reflect changes made to the server. Cheers, tedd -- --- http://sperling.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Is it possible to create a global namespace alias?
Is it possible to create a global namespace alias in PHP or does the alias have to be defined in EVERY file that I use? Here is an example: file: main.php ?php use \this\is\my\custom\namespace\Item as nsItem; ? file: index.php ?php require_once “main.php”; // Attempt to use namespace alias defined in main.php file nsItem::test(); ? The above code doesn’t work for me. The namespace alias defined in the main.php file isn’t accessible in the index.php file. Is there a way to make the “nsItem” alias a “global” one, so that I don’t have to define it in EVERY file that I want to use? -Matt
Re: [PHP] New to PHP and struggling with the basics
Col. Since you're new to php, then an easy way to install apache, is using XAMPP ( http://www.apachefriends.org/en/xampp.html ) I would suggest you remove the apache you have installed, and the php you installed, and install the XAMPP package as it comes prebuilt with mysql, ftp, apache and php, and it is simple to use/work with. And if you install to defaults there, you will put your web files into C:\xampp\htdocs\ and everythign should just work. The way i read your initial post, is that you installed just apache, and just php... if you did this, then you may not have integrated php into apache properly, so then your php pages will not work. just my $0.02 here, cuz if it doesn't work after you install XAMPP, then there is something else wrong. And the other thing, is that you're running on vista, and vista doesn't like things running on localhost (or at least it didn't used to) Steve On Mon, 2010-10-04 at 13:51 +0100, Col Day wrote: Hi Kranthi, No, I just literally get the HTML line shown but absolutely nothing beneath it. kranthi kranthi...@gmail.com wrote in message news:aanlktin2xnthqm-pp7qwtgo=sqtkctthtwz+08bbw...@mail.gmail.com... they should be something like error_log-[date] not sure about windows though However I have found that if I paste the html into my web page created by Serif WebPlus 10 I get the html line but not the php line. are you saying that you are getting the php code in your browser ? ?php echo pThis is a PHP line/p; phpinfo(); ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RES: [PHP] New to PHP and struggling with the basics
Col Day : Go to : C:\Arquivos de programas\Apache Software Foundation\Apache2.2\conf or the folder in your machine. Search for this file = httpd.conf Search for DocumentRoot D:/webroot put your work folder in my case D:/webroot. Search for this line and apply the same changes make in DocumentRoot # # This should be changed to whatever you set DocumentRoot to # Directory D:/webroot Search for DirectoryIndex, and add index.php to the list # # DirectoryIndex: sets the file that Apache will serve if a directory # is requested. # IfModule dir_module DirectoryIndex index.html index.php /IfModule Add on the end of the file this lines : My php installation folder is D:/PHP/, change D:/PHP/ to your installation folder. #BEGIN PHP INSTALLER EDITS - REMOVE ONLY ON UNINSTALL PHPIniDir D:/PHP/ # Php as Apache module LoadModule php5_module D:/PHP/php5apache2_2.dll Restart apache. Browse to localhost Alejandro M.S. -Mensagem original- De: Col Day [mailto:colind...@aol.com] Enviada em: segunda-feira, 4 de outubro de 2010 06:31 Para: php-general@lists.php.net Assunto: [PHP] New to PHP and struggling with the basics Hi all, Working with the PHP5 for Dummies book (yup real noob, feel free to ridicule (after telling me what I've done wrong)) and have installed Apache 2.2 and PHP 5.3.3 onto a laptop running Vista. (yes I know!!!). I've had Apache running fine with my basic web site created using Serif's Webplus10 but wanted to experiment with PHP as I want an uploadable area on my website for my friends and family to submit video/photos. I've checked the install of PHP using php -v and I get the output that PHP 5.3.3 (cli) (built: Jul 21 2010 20:10:20) but when I try and go to the test.php file (below) I get an http 403 webiste requires you to log in. Error message. html head titlePHP Test/title /head body pThis is an HTML line ?php echo pThis is a PHP line/p; phpinfo(); ? /body /html This is the text of the test.php file which I have plonked down in /apache/htdocs What have I missed? the Dummies book is quoting PHP 5.0.0 as the latest release so not too far away really. Thanks for your help. Cheers. Col Day -- 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] open .zip from memory...
Not sure if my subject is misleading or not, but anyway, here it goes... I am trying to download a file using file_get_contents($url) which happens to be a .zip file. I have no issues downloading the file, saving it to the harddrive, opening it, and getting what i need from it... but what I am trying to do, is not save it to disk, but to just grab the .zip file, and open it in memory, grab the file i need from it, and then discard the .zip file, and parse out the file i grabbed (this would prevent having a folder with R/W access that could possibly be set wrong, or using the /tmp folder) Again, I dont have any issues doing it where i save it first, but when I try to use the file from memory, i get errors saying that it can't open the zip file becuase it has no valid resource id#. The zip commands i am using, are the php ones zip_open, zip_read, zip_entry_read, zip_entry_name, zip_entry_filesize and obviously zip_close. Can this be done, or should I just forget it, and use the /tmp dir? Steve. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] New to PHP and struggling with the basics
Your directory configuration should look like this Directory C:\path_to_www_root Order Deny,Allow Allow from all Options Indexes FollowSymLinks Includes ExecCGI # # AllowOverride controls what directives may be placed in .htaccess files. # It can be All, None, or any combination of the keywords: # Options FileInfo AuthConfig Limit # AllowOverride All /Directory On Mon, Oct 4, 2010 at 10:53 AM, kranthi kranthi...@gmail.com wrote: apache error logs will be helpful in this case. Their location varies depending upon your installation. But in any case they'll be insde your server directory (IIRC it is c:/Program Files/Apache Software Foundation/Apache by default) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Share with free mind! Join the world largest open forum for hackers and programmers. http://www.tuwana.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] file_get_contents() failing on CentOS.
On 4 October 2010 10:48, kranthi kranthi...@gmail.com wrote: http_proxy or HTTP_PROXY i m not sure Thanks. Passing it on (and learning a bit). -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Little Parsing help...
On Mon, Oct 4, 2010 at 6:29 AM, Richard Quadling rquadl...@gmail.comwrote: http://pastebin.com/rsV35czb Code with tests and output. Nice code, Richard. Adam -- Nephtali: PHP web framework that functions beautifully http://nephtaliproject.com
Re: [PHP] New to PHP and struggling with the basics
Steve, That's superb, many thanks for the link! I shall give it a go! Yes I did install apache then php, however I tried to follow the instructions in the Dummies book (what does it make me if I can't follow the dummies book?) but to no avail. I have just printed off the first 40 pages so that i can read it whilst looking at the screen ratrher than switching about, however I will give Xammp a go first and foremost seeing as I only want to test my own web page before I start to buy hosting elsewhere. Seeing as you are so great :-) Any ideas of the best way to script an upload page that will deliver files to the server? Family photo's and video clips mainly. Thoughts? Also, many thanks to everyone who has tried to help a muppet. But I guess we all gotta start somewhere! Cheers again! Steve Staples sstap...@mnsi.net wrote in message news:1286202653.4703.48.ca...@webdev01... Col. Since you're new to php, then an easy way to install apache, is using XAMPP ( http://www.apachefriends.org/en/xampp.html ) I would suggest you remove the apache you have installed, and the php you installed, and install the XAMPP package as it comes prebuilt with mysql, ftp, apache and php, and it is simple to use/work with. And if you install to defaults there, you will put your web files into C:\xampp\htdocs\ and everythign should just work. The way i read your initial post, is that you installed just apache, and just php... if you did this, then you may not have integrated php into apache properly, so then your php pages will not work. just my $0.02 here, cuz if it doesn't work after you install XAMPP, then there is something else wrong. And the other thing, is that you're running on vista, and vista doesn't like things running on localhost (or at least it didn't used to) Steve On Mon, 2010-10-04 at 13:51 +0100, Col Day wrote: Hi Kranthi, No, I just literally get the HTML line shown but absolutely nothing beneath it. kranthi kranthi...@gmail.com wrote in message news:aanlktin2xnthqm-pp7qwtgo=sqtkctthtwz+08bbw...@mail.gmail.com... they should be something like error_log-[date] not sure about windows though However I have found that if I paste the html into my web page created by Serif WebPlus 10 I get the html line but not the php line. are you saying that you are getting the php code in your browser ? ?php echo pThis is a PHP line/p; phpinfo(); ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] New to PHP and struggling with the basics
In addition, I think I may have got to the bottom of what I was doing wrong in the first place. I recently swapped out my laptop for my wifes one (she upgraded, well I upgraded hers, and I got the old one) and I forgot that this one didn't automatically boot up into the Administrator profile. Doh! Cheers again all! Col Day colind...@aol.com wrote in message news:a2.70.25536.9a5f9...@pb1.pair.com... Steve, That's superb, many thanks for the link! I shall give it a go! Yes I did install apache then php, however I tried to follow the instructions in the Dummies book (what does it make me if I can't follow the dummies book?) but to no avail. I have just printed off the first 40 pages so that i can read it whilst looking at the screen ratrher than switching about, however I will give Xammp a go first and foremost seeing as I only want to test my own web page before I start to buy hosting elsewhere. Seeing as you are so great :-) Any ideas of the best way to script an upload page that will deliver files to the server? Family photo's and video clips mainly. Thoughts? Also, many thanks to everyone who has tried to help a muppet. But I guess we all gotta start somewhere! Cheers again! Steve Staples sstap...@mnsi.net wrote in message news:1286202653.4703.48.ca...@webdev01... Col. Since you're new to php, then an easy way to install apache, is using XAMPP ( http://www.apachefriends.org/en/xampp.html ) I would suggest you remove the apache you have installed, and the php you installed, and install the XAMPP package as it comes prebuilt with mysql, ftp, apache and php, and it is simple to use/work with. And if you install to defaults there, you will put your web files into C:\xampp\htdocs\ and everythign should just work. The way i read your initial post, is that you installed just apache, and just php... if you did this, then you may not have integrated php into apache properly, so then your php pages will not work. just my $0.02 here, cuz if it doesn't work after you install XAMPP, then there is something else wrong. And the other thing, is that you're running on vista, and vista doesn't like things running on localhost (or at least it didn't used to) Steve On Mon, 2010-10-04 at 13:51 +0100, Col Day wrote: Hi Kranthi, No, I just literally get the HTML line shown but absolutely nothing beneath it. kranthi kranthi...@gmail.com wrote in message news:aanlktin2xnthqm-pp7qwtgo=sqtkctthtwz+08bbw...@mail.gmail.com... they should be something like error_log-[date] not sure about windows though However I have found that if I paste the html into my web page created by Serif WebPlus 10 I get the html line but not the php line. are you saying that you are getting the php code in your browser ? ?php echo pThis is a PHP line/p; phpinfo(); ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Little Parsing help...
On 4 October 2010 16:10, Adam Richardson simples...@gmail.com wrote: On Mon, Oct 4, 2010 at 6:29 AM, Richard Quadling rquadl...@gmail.comwrote: http://pastebin.com/rsV35czb Code with tests and output. Nice code, Richard. Adam Thank you. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] open .zip from memory...
Steve Staples wrote: Not sure if my subject is misleading or not, but anyway, here it goes... I am trying to download a file using file_get_contents($url) which happens to be a .zip file. I have no issues downloading the file, saving it to the harddrive, opening it, and getting what i need from it... but what I am trying to do, is not save it to disk, but to just grab the .zip file, and open it in memory, grab the file i need from it, and then discard the .zip file, and parse out the file i grabbed (this would prevent having a folder with R/W access that could possibly be set wrong, or using the /tmp folder) Again, I dont have any issues doing it where i save it first, but when I try to use the file from memory, i get errors saying that it can't open the zip file becuase it has no valid resource id#. The zip commands i am using, are the php ones zip_open, zip_read, zip_entry_read, zip_entry_name, zip_entry_filesize and obviously zip_close. Can this be done, or should I just forget it, and use the /tmp dir? Steve. Might see if this page will glean you any information http://us3.php.net/manual/en/wrappers.php.php I think the php://temp or php://memory will work for you instead of a file on the file system. Jim -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] open .zip from memory...
On Mon, 2010-10-04 at 10:12 -0700, Jim Lucas wrote: Steve Staples wrote: Not sure if my subject is misleading or not, but anyway, here it goes... I am trying to download a file using file_get_contents($url) which happens to be a .zip file. I have no issues downloading the file, saving it to the harddrive, opening it, and getting what i need from it... but what I am trying to do, is not save it to disk, but to just grab the .zip file, and open it in memory, grab the file i need from it, and then discard the .zip file, and parse out the file i grabbed (this would prevent having a folder with R/W access that could possibly be set wrong, or using the /tmp folder) Again, I dont have any issues doing it where i save it first, but when I try to use the file from memory, i get errors saying that it can't open the zip file becuase it has no valid resource id#. The zip commands i am using, are the php ones zip_open, zip_read, zip_entry_read, zip_entry_name, zip_entry_filesize and obviously zip_close. Can this be done, or should I just forget it, and use the /tmp dir? Steve. Might see if this page will glean you any information http://us3.php.net/manual/en/wrappers.php.php I think the php://temp or php://memory will work for you instead of a file on the file system. Jim Jim: That is exactly what I was looking for... man, I feel dumb... I was looking at the tmpfile() and tmpname() but it wasn't quite what i was looking for. I've use the php://xxx before, but it slipped my mind. thanks again :) I will implement this tonight :) Steve -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHPExcel with large files (27,000+ rows)
I'm currently working on a project that requires the parsing of excel files. Basically the user uploads an excel file, and then a script needs to save a row in a Postgres database for each row in the excel file. The issue we are having is that when we task PHPExcel with parsing an excel file with, say 27k rows, it explodes with a memory error. I've read up on the PHPExcel forums and we've tried cell caching as well as ReadDataOnly, they do not seem to be sufficient. Does anyone here know of a way to do this? Surely there is a way to parse a large excel file with PHP. This is also NOT an on-demand service. That is, when someone uploads a file they get a task_id which allows them to check the status of their excel file. So the solution does not need to be a fast one! Thanks, Chris.
Re: [PHP] PHPExcel with large files (27,000+ rows)
chris h wrote: I'm currently working on a project that requires the parsing of excel files. Basically the user uploads an excel file, and then a script needs to save a row in a Postgres database for each row in the excel file. The issue we are having is that when we task PHPExcel with parsing an excel file with, say 27k rows, it explodes with a memory error. I've read up on the PHPExcel forums and we've tried cell caching as well as ReadDataOnly, they do not seem to be sufficient. Does anyone here know of a way to do this? Surely there is a way to parse a large excel file with PHP. If your excel file is or can be transformed to XML, I would just use XSLT. No PHP needed. -- Per Jessen, Zürich (19.1°C) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHPExcel with large files (27,000+ rows)
I use this: http://code.google.com/p/php-csv-parser/ No idea if it's any better than your current solution. I presume you've tried extending PHP's memory limit? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHPExcel with large files (27,000+ rows)
On Tue, Oct 5, 2010 at 12:39 AM, chris h chris...@gmail.com wrote: I'm currently working on a project that requires the parsing of excel files. Basically the user uploads an excel file, and then a script needs to save a row in a Postgres database for each row in the excel file. The issue we are having is that when we task PHPExcel with parsing an excel file with, say 27k rows, it explodes with a memory error. I've read up on the PHPExcel forums and we've tried cell caching as well as ReadDataOnly, they do not seem to be sufficient. Does anyone here know of a way to do this? Surely there is a way to parse a large excel file with PHP. This is also NOT an on-demand service. That is, when someone uploads a file they get a task_id which allows them to check the status of their excel file. So the solution does not need to be a fast one! Thanks, Chris. 1. Remove any variable that contains big object if its not necessary. 2. Use unset when applicable 3. Read chunk by chunk. 4. Profile it to find the exact place where you are wasting memory. Optimizing that little portion of code can improve memory performance. -- Shiplu Mokadd.im My talks, http://talk.cmyweb.net Follow me, http://twitter.com/shiplu SUST Programmers, http://groups.google.com/group/p2psust Innovation distinguishes bet ... ... (ask Steve Jobs the rest) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHPExcel with large files (27,000+ rows)
Thanks Jessen/Marc, though the user provided format can be in xls, xlsx, or csv. So i need a solution to support all formats. Thanks for the ideas shiplu I'll get with the team and see if there's anything there we aren't trying. Chris. On Mon, Oct 4, 2010 at 3:01 PM, shiplu shiplu@gmail.com wrote: On Tue, Oct 5, 2010 at 12:39 AM, chris h chris...@gmail.com wrote: I'm currently working on a project that requires the parsing of excel files. Basically the user uploads an excel file, and then a script needs to save a row in a Postgres database for each row in the excel file. The issue we are having is that when we task PHPExcel with parsing an excel file with, say 27k rows, it explodes with a memory error. I've read up on the PHPExcel forums and we've tried cell caching as well as ReadDataOnly, they do not seem to be sufficient. Does anyone here know of a way to do this? Surely there is a way to parse a large excel file with PHP. This is also NOT an on-demand service. That is, when someone uploads a file they get a task_id which allows them to check the status of their excel file. So the solution does not need to be a fast one! Thanks, Chris. 1. Remove any variable that contains big object if its not necessary. 2. Use unset when applicable 3. Read chunk by chunk. 4. Profile it to find the exact place where you are wasting memory. Optimizing that little portion of code can improve memory performance. -- Shiplu Mokadd.im My talks, http://talk.cmyweb.net Follow me, http://twitter.com/shiplu SUST Programmers, http://groups.google.com/group/p2psust Innovation distinguishes bet ... ... (ask Steve Jobs the rest)
[PHP] Connecting to MySql with PHP
I am running PHP 5.3.3, with Apache 2.0 Handler and MySql Server 5.1. My OS
is Vista Home Premium 32 bit with SP2.
MySql works fine from the command prompt, Apache is running and PHP works.
But I cannot access the mysqli classes. This simple program:
?php
$mysqli = new mysqli(localhost, root, ##, testDB);#I've
deliberately obliterated the password
if (mysqli_connect_errno()) {
printf(Connect failed: %s\n, mysqli_connect_error());
exit();
} else {
printf(Host information: %s\n, mysqli_get_host_info($mysqli));
}
?
produces this error message:
Warning: mysqli::mysqli() [mysqli.mysqli]: [2002] A connection attempt failed
because the connected party did not (trying to connect via
tcp://localhost:3306) in C:\Apache\htdocs\mysqlconnect.php on line 3
Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2002): A connection attempt
failed because the connected party did not properly respond after a period of
time, or established connection failed because connected host has failed to
respond. in C:\Apache\htdocs\mysqlconnect.php on line 3
Fatal error: Maximum execution time of 30 seconds exceeded in
C:\Apache\htdocs\mysqlconnect.php on line 3
I guess PHP cannot find the mysqli classes. I've checked the phpinfo() output
and discovered :
Configuration File (php.ini) Path C:\Windows
Loaded Configuration File C:\PHP\php.ini
I don't know if this ok. I've tried changing the location of the loaded file
to C:\Windows\php.ini, but to no avail, and I don't know how to change the
location of the config file.
I am obviously doing something wrong, but I don't know what. Can anyone help?
Ironically, everything worked perfectly before I upgraded to PHP 5.3.3!
Re: [PHP] Connecting to MySql with PHP
Have you installed the php mysql module? Basically, it tells php how to connect
to mysql.
This question has come up a few times this week, have you tried installing
something like xampp or easyphp rather than the individual software components:
Apache, php mysql.
Thanks,
Ash
http://www.ashleysheridan.co.uk
- Reply message -
From: sueandant hollandsath...@tiscali.co.uk
Date: Mon, Oct 4, 2010 22:08
Subject: [PHP] Connecting to MySql with PHP
To: php-general@lists.php.net
I am running PHP 5.3.3, with Apache 2.0 Handler and MySql Server 5.1. My OS
is Vista Home Premium 32 bit with SP2.
MySql works fine from the command prompt, Apache is running and PHP works.
But I cannot access the mysqli classes. This simple program:
?php
$mysqli = new mysqli(localhost, root, ##, testDB);#I've
deliberately obliterated the password
if (mysqli_connect_errno()) {
printf(Connect failed: %s\n, mysqli_connect_error());
exit();
} else {
printf(Host information: %s\n, mysqli_get_host_info($mysqli));
}
?
produces this error message:
Warning: mysqli::mysqli() [mysqli.mysqli]: [2002] A connection attempt failed
because the connected party did not (trying to connect via
tcp://localhost:3306) in C:\Apache\htdocs\mysqlconnect.php on line 3
Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2002): A connection attempt
failed because the connected party did not properly respond after a period of
time, or established connection failed because connected host has failed to
respond. in C:\Apache\htdocs\mysqlconnect.php on line 3
Fatal error: Maximum execution time of 30 seconds exceeded in
C:\Apache\htdocs\mysqlconnect.php on line 3
I guess PHP cannot find the mysqli classes. I've checked the phpinfo() output
and discovered :
Configuration File (php.ini) Path C:\Windows
Loaded Configuration File C:\PHP\php.ini
I don't know if this ok. I've tried changing the location of the loaded file
to C:\Windows\php.ini, but to no avail, and I don't know how to change the
location of the config file.
I am obviously doing something wrong, but I don't know what. Can anyone help?
Ironically, everything worked perfectly before I upgraded to PHP 5.3.3!
Re: [PHP] Connecting to MySql with PHP
The code execute fine on my LAMP server, but I am wondering does
localhost really works on Windows ?As this on MAC you need to actually
tell a complete path.On MAC with Zend-Server I had to mention something
like /var/tmp/mysql
Anyways, by looking on the error it might be mysql server is not
accessed...Can you actually access the myql server with anything else
like phpmyadmin or cli ?
Gr
mrfroasty
On 10/04/2010 11:21 PM, a...@ashleysheridan.co.uk wrote:
Have you installed the php mysql module? Basically, it tells php how to
connect to mysql.
This question has come up a few times this week, have you tried installing
something like xampp or easyphp rather than the individual software
components: Apache, php mysql.
Thanks,
Ash
http://www.ashleysheridan.co.uk
- Reply message -
From: sueandant hollandsath...@tiscali.co.uk
Date: Mon, Oct 4, 2010 22:08
Subject: [PHP] Connecting to MySql with PHP
To: php-general@lists.php.net
I am running PHP 5.3.3, with Apache 2.0 Handler and MySql Server 5.1. My OS
is Vista Home Premium 32 bit with SP2.
MySql works fine from the command prompt, Apache is running and PHP works.
But I cannot access the mysqli classes. This simple program:
?php
$mysqli = new mysqli(localhost, root, ##, testDB);#I've
deliberately obliterated the password
if (mysqli_connect_errno()) {
printf(Connect failed: %s\n, mysqli_connect_error());
exit();
} else {
printf(Host information: %s\n, mysqli_get_host_info($mysqli));
}
?
produces this error message:
Warning: mysqli::mysqli() [mysqli.mysqli]: [2002] A connection attempt failed
because the connected party did not (trying to connect via
tcp://localhost:3306) in C:\Apache\htdocs\mysqlconnect.php on line 3
Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2002): A connection attempt
failed because the connected party did not properly respond after a period of
time, or established connection failed because connected host has failed to
respond. in C:\Apache\htdocs\mysqlconnect.php on line 3
Fatal error: Maximum execution time of 30 seconds exceeded in
C:\Apache\htdocs\mysqlconnect.php on line 3
I guess PHP cannot find the mysqli classes. I've checked the phpinfo()
output and discovered :
Configuration File (php.ini) Path C:\Windows
Loaded Configuration File C:\PHP\php.ini
I don't know if this ok. I've tried changing the location of the loaded
file to C:\Windows\php.ini, but to no avail, and I don't know how to change
the location of the config file.
I am obviously doing something wrong, but I don't know what. Can anyone
help?
Ironically, everything worked perfectly before I upgraded to PHP 5.3.3!
--
Extra details:
OSS:Gentoo Linux
profile:x86
Hardware:msi geforce 8600GT asus p5k-se
location:/home/muhsin
language(s):C/C++,VB,VHDL,bash,PHP,SQL,HTML,CSS
Typo:40WPM
url:http://www.mzalendo.net
url:http://www.zanbytes.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
