Re: [PHP] best function to use ~ file_get_contents or ?
There is no best function as such. Everything depends upon your requirement. You can also use fopen() to get the contents of the remote file and do some error handling that if you get any content then display image else a message etc.. Gaurav Kumar (Team Lead- open source) oswebstudio.com On Wed, Sep 16, 2009 at 4:06 AM, CRM c...@globalissa.com wrote: Hi All, Not sure of the best approach, need your feedback. I have 4 images on a website. These are used in navigation. When I load a reference webpage on my local machine the local page calls 4 images from an external website, each image will be on a different domain. What I want to see is if the navigation images/buttons can be loaded/displayed in my browser. If they can, then I will display the images on my local page. If the images cannot be loaded, then this indicates some connection issue and the result will be some text like 'Site Offline'. So just by glancing at my local machine reference page I can tell if one or more of the different sites is or is not available. So what is the best function to use? if ( @file_get_contents( DOMAIN_PATH . images/navigation/nav_globalissa.png )): or ??? Please also cc i...@globalissa.com Thanks for any helpful suggestions. Sincerely, Rob Global I.S. S.A. Software Powers the Net Email: crm at globalissa dot com * * * The Forge of Globalissa ~ PHP Foobar Machine * * * http://globalissa.com/forge/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: php/mysql Query Question.
ad...@buskirkgraphics.com wrote: Before most of you go on a rampage of how to please read below... As most of you already know when using MySQL from the shell you can write your queries in html format in an out file. Example: shellmysql -uyourmom -plovesme --html This now will return all results in an html format from all queries. Now I could “tee” this to a file and save the results returned if I so choose to save the result of the display . Let’s say I want to be lazy and write a php MySQL query to do the same so that any result I queried for would return the html results in a table without actually writing the table tags in the results. Is there a mysql_connect or select_db or mysql_query tag option to do that since mysql can display it from the shell? I think you'll find that the HTML output is a function of the mysql command line program (I tend to use PostgreSQL, where 'psql' is a similar program) so you can only access that functionality by calling the command line. I suspect that, since PHP is a HTML processing language (originally), the creators of the mysql_ functions figured that the user could sort out making HTML from the data returned... It's should be a simple operation to write a wrapper function to put HTML around the results. There might even be a PEAR extension or PHPClasses class to do it (I haven't looked yet) -- Peter Ford phone: 01580 89 Developer fax: 01580 893399 Justcroft International Ltd., Staplehurst, Kent -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] best function to use ~ file_get_contents or ?
On Wed, 2009-09-16 at 12:08 +0530, Gaurav Kumar wrote: There is no best function as such. Everything depends upon your requirement. You can also use fopen() to get the contents of the remote file and do some error handling that if you get any content then display image else a message etc.. Gaurav Kumar (Team Lead- open source) oswebstudio.com On Wed, Sep 16, 2009 at 4:06 AM, CRM c...@globalissa.com wrote: Hi All, Not sure of the best approach, need your feedback. I have 4 images on a website. These are used in navigation. When I load a reference webpage on my local machine the local page calls 4 images from an external website, each image will be on a different domain. What I want to see is if the navigation images/buttons can be loaded/displayed in my browser. If they can, then I will display the images on my local page. If the images cannot be loaded, then this indicates some connection issue and the result will be some text like 'Site Offline'. So just by glancing at my local machine reference page I can tell if one or more of the different sites is or is not available. So what is the best function to use? if ( @file_get_contents( DOMAIN_PATH . images/navigation/nav_globalissa.png )): or ??? Please also cc i...@globalissa.com Thanks for any helpful suggestions. Sincerely, Rob Global I.S. S.A. Software Powers the Net Email: crm at globalissa dot com * * * The Forge of Globalissa ~ PHP Foobar Machine * * * http://globalissa.com/forge/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php The way I've always seen this approached before is by using the wget command, which can be asked to just return the headers for a page. In your case you'd be looking for all 200 codes, which means that all the sites are up. This is faster than asking to return a full image each time. Thanks, Ash http://www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] best function to use ~ file_get_contents or ?
The way I've always seen this approached before is by using the wget command, which can be asked to just return the headers for a page. In your case you'd be looking for all 200 codes, which means that all the sites are up. This is faster than asking to return a full image each time. but slower 'cause for each image you need to requests On the other hand, file_get_contents could return false positives cause the fact we are asking for an image does not mean an image will be returned. I would go for a curl call, where you can have both headers and content so in one call you can handle every case. A bit slower than a HEAD request, surely faster than a HEAD request plus the REQUEST. One more thing, I hope you have rights to grab these images, usually there are APIs or webservices when a website would like to share images in this way but it does not seem the case here ... Regards _ Drag n’ drop—Get easy photo sharing with Windows Live™ Photos. http://www.microsoft.com/windows/windowslive/products/photos.aspx
RE: [PHP] best function to use ~ file_get_contents or ?
On Wed, 2009-09-16 at 11:17 +0200, Andrea Giammarchi wrote: The way I've always seen this approached before is by using the wget command, which can be asked to just return the headers for a page. In your case you'd be looking for all 200 codes, which means that all the sites are up. This is faster than asking to return a full image each time. but slower 'cause for each image you need to requests On the other hand, file_get_contents could return false positives cause the fact we are asking for an image does not mean an image will be returned. I would go for a curl call, where you can have both headers and content so in one call you can handle every case. A bit slower than a HEAD request, surely faster than a HEAD request plus the REQUEST. One more thing, I hope you have rights to grab these images, usually there are APIs or webservices when a website would like to share images in this way but it does not seem the case here ... Regards _ Drag n’ drop—Get easy photo sharing with Windows Live™ Photos. http://www.microsoft.com/windows/windowslive/products/photos.aspx Requesting only the headers is a lot faster than requesting the headers AND the file itself. I'd also not look to grab an image anyway, try grabbing just the HTML of a web-page. You get the headers, and the HTML is likely to be very small in size. Not only that, you can perform other tests on the returned HTML, for example to see if PHP is still running on the remote site. All of this is very easy to accomplish with a single line call to wget. Thanks, Ash http://www.ashleysheridan.co.uk
RE: [PHP] best function to use ~ file_get_contents or ?
This is what I said, except if you want to grab the content you need to request HEAD first and eventually GET, and this is slower than just GET parsing headers. In any case, curl is the answer, imho. Regards Requesting only the headers is a lot faster than requesting the headers AND the file itself. _ Drag n’ drop—Get easy photo sharing with Windows Live™ Photos. http://www.microsoft.com/windows/windowslive/products/photos.aspx
[PHP] Insert Symbol into Mysql
I want to insert symbols like degree, plusminus, currency along with string into Mysql database. Front is HTML form with javascript. Server side scripts are written in PHP. Please help. Regards, Samrat Kar
RE: [PHP] Insert Symbol into Mysql
does JavaScript use the proper way to encode strings as encodeURIComponent is, and for each sent key/value pair? Is MySQL table charset ut8_general_ci ? If not, do you convert sent UTF-8 charset into table charset? In few words we miss the way/library used to send data, the default PHP charset, the MySQL table charset, the way you store/retrieve data into MySQL, etc etc ... we can help but we need more info From: esam...@barc.gov.in To: php-general@lists.php.net Date: Wed, 16 Sep 2009 17:00:31 +0530 Subject: [PHP] Insert Symbol into Mysql I want to insert symbols like degree, plusminus, currency along with string into Mysql database. Front is HTML form with javascript. Server side scripts are written in PHP. Please help. Regards, Samrat Kar _ With Windows Live, you can organize, edit, and share your photos. http://www.microsoft.com/middleeast/windows/windowslive/products/photo-gallery-edit.aspx
Re: [PHP] Insert Symbol into Mysql
On Wed, 2009-09-16 at 17:00 +0530, Samrat Kar wrote: I want to insert symbols like degree, plusminus, currency along with string into Mysql database. Front is HTML form with javascript. Server side scripts are written in PHP. Please help. Regards, Samrat Kar Two ways to do this: 1. Insert the characters as their escaped HTML codes, e.g. #176; #177; #163; (for °, ± and £) 2. Set the DB to use a utf8 character set, and insert the characters directly as is, without escaping them Thanks, Ash http://www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Insert Symbol into Mysql
He has no utf-8 charset in the table, so the first point is valid and htmlentities is the function ( http://uk.php.net/manual/en/function.htmlentities.php ) You need to remember that in this way you need to use htmlentities for *everything*, specially for searches, otherwise ° against #176; will be a not found. Alternative could be mb_string for charset manipulation but since the table is not UTF-8 you could have lots of problems with other chars ... so you change the charset if this is a new project before you gonna be in trouble for size and/or performances, or you convert each stored stirng via htmlentities and you start right now to use htmlentities as default select/insert parser (or you convert everything into utf-8 via mb_string and you truncate the table, change the charset, refill it via converted values performed into another table) Regards From: a...@ashleysheridan.co.uk Two ways to do this: 1. Insert the characters as their escaped HTML codes, e.g. #176; #177; #163; (for °, ± and £) 2. Set the DB to use a utf8 character set, and insert the characters directly as is, without escaping them _ Share your memories online with anyone you want. http://www.microsoft.com/middleeast/windows/windowslive/products/photos-share.aspx?tab=1
RE: [PHP] Insert Symbol into Mysql
On Wed, 2009-09-16 at 14:47 +0200, Andrea Giammarchi wrote: He has no utf-8 charset in the table, so the first point is valid and htmlentities is the function ( http://uk.php.net/manual/en/function.htmlentities.php ) You need to remember that in this way you need to use htmlentities for *everything*, specially for searches, otherwise ° against #176; will be a not found. Alternative could be mb_string for charset manipulation but since the table is not UTF-8 you could have lots of problems with other chars ... so you change the charset if this is a new project before you gonna be in trouble for size and/or performances, or you convert each stored stirng via htmlentities and you start right now to use htmlentities as default select/insert parser (or you convert everything into utf-8 via mb_string and you truncate the table, change the charset, refill it via converted values performed into another table) Regards From: a...@ashleysheridan.co.uk Two ways to do this: 1. Insert the characters as their escaped HTML codes, e.g. #176; #177; #163; (for °, ± and £) 2. Set the DB to use a utf8 character set, and insert the characters directly as is, without escaping them _ Share your memories online with anyone you want. http://www.microsoft.com/middleeast/windows/windowslive/products/photos-share.aspx?tab=1 I don't recall him saying that a utf8 table was not an option or that he wasn't using one. Also, try not to top post ;) Thanks, Ash http://www.ashleysheridan.co.uk
Re: [PHP] Insert Symbol into Mysql
If he´s really using a any other charset instead of utf8 table, why not using utf8_decode and utf8_decode in his php files to solve this? Ashley Sheridan a...@ashleysheridan.co.uk escreveu na mensagem news:1253101315.2275.4.ca...@localhost... On Wed, 2009-09-16 at 17:00 +0530, Samrat Kar wrote: I want to insert symbols like degree, plusminus, currency along with string into Mysql database. Front is HTML form with javascript. Server side scripts are written in PHP. Please help. Regards, Samrat Kar Two ways to do this: 1. Insert the characters as their escaped HTML codes, e.g. #176; #177; #163; (for °, ± and £) 2. Set the DB to use a utf8 character set, and insert the characters directly as is, without escaping them Thanks, Ash http://www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Insert Symbol into Mysql
I don't recall him saying that a utf8 table was not an option or that he wasn't using one. I know 'cause he replied directly to me rather than this ML Also, try not to top post ;) I usually hate scroll 'till the end to find often a single row as reply ... I'll try though Thanks, Ash http://www.ashleysheridan.co.uk Thanks _ Drag n’ drop—Get easy photo sharing with Windows Live™ Photos. http://www.microsoft.com/windows/windowslive/products/photos.aspx
RE: [PHP] Insert Symbol into Mysql
If he´s really using a any other charset instead of utf8 table, why not using utf8_decode and utf8_decode in his php files to solve this? let's say PHP could have a different charset than the one defined in that MySQL table so this is not a portable solution, specially if you do not perfectly know charset and problems. Regards _ Show them the way! Add maps and directions to your party invites. http://www.microsoft.com/windows/windowslive/products/events.aspx
RE: [PHP] Insert Symbol into Mysql
On Wed, 2009-09-16 at 15:40 +0200, Andrea Giammarchi wrote: I don't recall him saying that a utf8 table was not an option or that he wasn't using one. I know 'cause he replied directly to me rather than this ML Also, try not to top post ;) I usually hate scroll 'till the end to find often a single row as reply ... I'll try though Thanks, Ash http://www.ashleysheridan.co.uk Thanks _ Drag n’ drop—Get easy photo sharing with Windows Live™ Photos. http://www.microsoft.com/windows/windowslive/products/photos.aspx Yeah, the rules say to snip out parts of the convo which aren't pertinent, but I know I don't exactly follow that one either! :-/ Thanks, Ash http://www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] php/mysql Query Question.
I tend to do this robert, while looking at your example i thought to myself since i am trying to mimick a shell command why not run one. Result: ? $db = 'db'; $host = 'host'; $user = 'user'; $pass = 'pass'; $query = select * from $db.my_table; $ddvery = shell_exec(mysql -u$user -p$pass --html --execute=$query); echo pre$ddvery/pre; ? Not are the results safe but the unlimited possibilites are amazing. Thanks so much for the kick starter ad...@buskirkgraphics.com wrote: Would you mind giving me an example of this that i can stick right into a blank php file and run. I get what you are saying but i cant seem to make that even echo out the data. php 5.2 mysql 5.1.3 Apache 2.2 ?php $db = 'db'; $host = 'host'; $user = 'user'; $pass = 'pass'; $query = select * from my_table; $db = escapeShellArg( $db ); $host = escapeShellArg( $host ); $user = escapeShellArg( $user ); $pass = escapeShellArg( $pass ); $query = escapeShellArg( $query ); $command = echo $query | mysql --html -h$host -u$user -p$pass $db; echo 'Command: '.$command.\n; $html = `$command`; echo $html.\n; ? Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Insert Symbol into Mysql
Yeah, the rules say to snip out parts of the convo which aren't pertinent, but I know I don't exactly follow that one either! :-/ Thanks, Ash http://www.ashleysheridan.co.uk to be honest the problem is that I am in hotmail rather than gmail here, and this page is not clever as gmail one is, quotes/replies are quite annoying here. Thanks _ Share your memories online with anyone you want. http://www.microsoft.com/middleeast/windows/windowslive/products/photos-share.aspx?tab=1
Re: [PHP] php/mysql Query Question.
ad...@buskirkgraphics.com wrote: I tend to do this robert, while looking at your example i thought to myself since i am trying to mimick a shell command why not run one. Result: ? $db = 'db'; $host = 'host'; $user = 'user'; $pass = 'pass'; $query = select * from $db.my_table; $ddvery = shell_exec(mysql -u$user -p$pass --html --execute=$query); echo pre$ddvery/pre; ? Not are the results safe but the unlimited possibilites are amazing. Thanks so much for the kick starter This presumes your information is all safe and that there are no special shell characters in any of the configuration settings (now and in the future). Also, the shell_exec() function is identical to the backtick operator that I used in my example (see the help). You've essentially done what I did, but made it less robust... except for the use of the --execute parameter which I wasn't aware existed since it's just as easy to pipe :) Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] php/mysql Query Question.
ad...@buskirkgraphics.com wrote:
Before most of you go on a rampage of how to please read below...
As most of you already know when using MySQL from the shell you can write
your queries in html format in an out file.
Example: shellmysql -uyourmom -plovesme --html
This now will return all results in an html format from all queries.
Now I could “tee” this to a file and save the results returned if I so choose
to save the result of the display .
Let’s say I want to be lazy and write a php MySQL query to do the same so
that any result I queried for would return the html results in a table
without actually writing the table tags in the results.
Is there a mysql_connect or select_db or mysql_query tag option to do that
since mysql can display it from the shell?
Here is my rendition of an result to HTML table output function.
This is normally used within my db class
but I have modified it to work with a MySQLi result object
function debug($result) {
/* get column metadata */
$html = 'table border=1tr';
foreach ( $result-fetch_fields() AS $val ) {
$html .= 'th'.$val-name.'/th';
}
$html .= '/tr';
foreach ( $result-fetch_row() AS $row ) {
$html .= 'tr';
foreach ( $row AS $value ) {
$html .= 'tdnbsp;'.$value.'/td';
}
$html .= '/tr';
}
$html .= '/table';
return $html;
}
Let us know if that works for you.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] APC - Upload progress problem. apc
He's back... Well folks.. The good news is that APC and my upload progress is working! : ) The bad news is, ...kind of working. : | It does exactly what I want, but at 1 hour of progress-barring, it stops. I.e., APC stops returning a response for the given key. Whether the connection has allowed 100MB, 500MB or 1GB. The file actually continues to upload, for hours if necessary, and eventually gets there. APC provides a sort of management page that lets you look at the APC status, including a listing of User Cache Entries which includes any still-valid upload keys, and any keys created via apc_add(). This listing includes a Timeout value, which is none for the apc_add keys and 3600 for the upload keys. Somewhat suspicious, I'd say, since the keys stop being working after 1 hour of use. APC lets you set a number of timeout values: apc.gc_ttl, apc.user_ttl, apc.ttl. I have set all of these to be gianormous, but the upload key timeout value never changes. I can't believe that this is an inherent limitation, or nobody would be using this. The Google claims people are using this for big uploads, so I should be able to. I have looked through Apache/unix to see if this limit refers to something set deeper in the system, but everything that I know of that I can loosen up, I have. Any ideas? Thanks, Phred On Sep 15, 2009, at 8:51 AM, Nathan Nobbe wrote: On Tue, Sep 15, 2009 at 12:05 AM, Phred White phpl...@planetphred.comwrote: Folks: Thanks for all your help and suggestions. Miracle of miracles I am now getting a response,so I can start some level of debugging. I am not sure exactly what has been going on. I NEVER got a response, then I did - when I tried uploading some different files. It seems that larger files always give a negative response for me. Now I am thinking that it has been a timing issue. My ajax stuff doesn't repeat yet, so there is currently only one request. It seems that if the file is a little too large, the first response is always false, that may be the case for very small files too. I finally just picked a file that was the right size. Since I could never verify that APC was responding, it didn't occur to me to go ahead and iron out the ajax stuff. Anyway now I can move forward. Thanks all for all your suggestions, sorry this ends up being such a stupid conclusion. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] APC - Upload progress problem. apc
Phred White wrote: He's back... Well folks.. The good news is that APC and my upload progress is working! : ) The bad news is, ...kind of working. : | It does exactly what I want, but at 1 hour of progress-barring, it stops. I.e., APC stops returning a response for the given key. Whether the connection has allowed 100MB, 500MB or 1GB. The file actually continues to upload, for hours if necessary, and eventually gets there. APC provides a sort of management page that lets you look at the APC status, including a listing of User Cache Entries which includes any still-valid upload keys, and any keys created via apc_add(). This listing includes a Timeout value, which is none for the apc_add keys and 3600 for the upload keys. Somewhat suspicious, I'd say, since the keys stop being working after 1 hour of use. APC lets you set a number of timeout values: apc.gc_ttl, apc.user_ttl, apc.ttl. I have set all of these to be gianormous, but the upload key timeout value never changes. I can't believe that this is an inherent limitation, or nobody would be using this. The Google claims people are using this for big uploads, so I should be able to. I have looked through Apache/unix to see if this limit refers to something set deeper in the system, but everything that I know of that I can loosen up, I have. Any ideas? Thanks, Phred Are you using SESSIONS or COOKIES at all in this application? If so, could it possibly be related to one or the others timeout configuration? -- Jim Lucas Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them. Twelfth Night, Act II, Scene V by William Shakespeare -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] APC - Upload progress problem. apc
upload keys, and any keys created via apc_add(). This listing includes a Timeout value, which is none for the apc_add keys and 3600 for the upload keys. Somewhat suspicious, I'd say, since the keys stop being working after 1 hour of use. APC lets you set a number of timeout values: apc.gc_ttl, apc.user_ttl, apc.ttl. I have set all of these to be gianormous, but the upload key timeout value never changes. I can't believe that this is an inherent limitation, or nobody would be using this. The Google claims people are using this for big uploads, so I I've just had my first glance at the APC source code, so I could be misreading something, but it appears that 3600 was hardcoded in until about 3 weeks ago. Here's the trunk commit that seems to have made that value configurable: http://svn.php.net/viewvc?view=revisionrevision=287534 And there's a reference to a PECL bug in the commit message: http://pecl.php.net/bugs/bug.php?id=16717 I have no idea when this change will trickle through to a production build -- or if it already has, but I suspect not, because the hardcoded 3600 was still present in the latest available source code tarball at http://pecl.php.net/get/APC Ben -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
