php-general Digest 28 Dec 2006 10:45:39 -0000 Issue 4538
php-general Digest 28 Dec 2006 10:45:39 - Issue 4538 Topics (messages 246245 through 246252): Re: Simple PDF manipulation 246245 by: tg-php.gryffyndevelopment.com 246246 by: Peter Lauri PHP podcasts 246247 by: Skip Evans 246248 by: Stut 246249 by: Skip Evans 246250 by: Skip Evans 246251 by: Stut 246252 by: Skip Evans Administrivia: To subscribe to the digest, e-mail: [EMAIL PROTECTED] To unsubscribe from the digest, e-mail: [EMAIL PROTECTED] To post to the list, e-mail: php-general@lists.php.net -- ---BeginMessage--- Yeah, this is exactly what we do at my work. We have a license for PDFLib and essentually we load blank forms and then say take this text and position it at this location. Kind of like putting words on a clear piece of acetate and overlaying it on top of a piece of paper. If I recall, we had issues trying to do this with fpdf and some other PHP PDF libraries, but PDFlib allowed us to do it and it's what we've used ever since. Actually, tedd.. did you use PDFlib or another library or maybe something in PHP5 (that we don't use yet)? We may be moving off of PDFlib at some point and I may be looking for alternatives. This is the main function we need. Ignorant question, but I havn't even thought of researching it yet and figured I'd ask while the topic was at hand. -TG = = = Original message = = = Interesting, that's a good idea. I was not aware that it was possible to load an existing PDF into memory and then add stuff to it. On Dec 27, 2006, at 7:28 AM, tedd wrote: At 6:32 AM -0800 12/27/06, Brian Dunning wrote: Let's say I have a complicated PDF document, like a Christmas card, that was made in Illustrator -- too complicated to easily create from scratch using PDFlib. Is there a way to use PHP make simple text changes - like changing Dear XXX to Dear John? I've opened the files with a text editor and cannot locate the simple text, it appears to be encoded somehow. The PDF has no security or encryption in it. Thanks Brian: I'm not saying that there is/isn't a way to do this, but I tried and failed. In my investigation, I found that the insides of a PDF file are not conducive to a simple search and replace mechanism. The text is encoded in some fashion that is not easy to decode and reassemble. The solution I came up with was to combine the existing PDF file with my coding and write over (on top of) the old to produce the new PDF that I wanted. In your case, take your Christmas Card with a big space where xxx appears and then write over that space with John in your new code. I wish someone would show me a simpler way to do this. hth's tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. ---End Message--- ---BeginMessage--- FPDF might do the same thing, won't it? Best regards, Peter Lauri www.dwsasia.com - company web site www.lauri.se - personal web site www.carbonfree.org.uk - become Carbon Free -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 27, 2006 11:11 PM To: php-general@lists.php.net Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Simple PDF manipulation Yeah, this is exactly what we do at my work. We have a license for PDFLib and essentually we load blank forms and then say take this text and position it at this location. Kind of like putting words on a clear piece of acetate and overlaying it on top of a piece of paper. If I recall, we had issues trying to do this with fpdf and some other PHP PDF libraries, but PDFlib allowed us to do it and it's what we've used ever since. Actually, tedd.. did you use PDFlib or another library or maybe something in PHP5 (that we don't use yet)? We may be moving off of PDFlib at some point and I may be looking for alternatives. This is the main function we need. Ignorant question, but I havn't even thought of researching it yet and figured I'd ask while the topic was at hand. -TG = = = Original message = = = Interesting, that's a good idea. I was not aware that it was possible to load an existing PDF into memory and then add stuff to it. On Dec 27, 2006, at 7:28 AM, tedd wrote: At 6:32 AM -0800 12/27/06, Brian Dunning wrote: Let's say I have a complicated PDF document, like a Christmas card, that was made in Illustrator -- too complicated to easily create from scratch using PDFlib. Is there a way to use PHP make simple text changes - like changing Dear XXX to Dear John? I've opened the files with a text editor and
php-general Digest 28 Dec 2006 22:54:35 -0000 Issue 4539
php-general Digest 28 Dec 2006 22:54:35 - Issue 4539 Topics (messages 246253 through 246261): Re: GD 2.0.28 + PHP 4.4.2 + pixelation :( 246253 by: zerof reading MS Excel? 246254 by: William Stokes 246255 by: Leonard Burton 246256 by: Miles Thompson 246261 by: John Meyer problem with mysql_real_escape_string() 246257 by: afan.afan.net 246258 by: Chris 246259 by: Stut 246260 by: afan.afan.net Administrivia: To subscribe to the digest, e-mail: [EMAIL PROTECTED] To unsubscribe from the digest, e-mail: [EMAIL PROTECTED] To post to the list, e-mail: php-general@lists.php.net -- ---BeginMessage--- Steven Macintyre escreveu: Hi All, I have done some searching via google and some answers say change copyimageresampled to copyimageresized etc I have tried all fixes ... to no avail I have one image here 1280 x 960 (150 dpi) 24 depth When using the following it pixelates ... function createthumb($name,$filename,$new_w,$new_h) http://www.educar.pro.br/abc/gdlib/ zerof ---End Message--- ---BeginMessage--- Is it possible to read Excel files and store the info to DB? If so how? Thanks -Will ---End Message--- ---BeginMessage--- On 12/28/06, Jiffy Slides Leonard Burton [EMAIL PROTECTED] wrote: HI Will, Is it possible to read Excel files and store the info to DB? If so how? It is best (well depending on the application) to save the files as .csv and then use fgetcsv. it will allow you to parse each line and cell in the file and then go from there. Take Care, -- Leonard Burton, N9URK [EMAIL PROTECTED] The prolonged evacuation would have dramatically affected the survivability of the occupants. -- Leonard Burton, N9URK [EMAIL PROTECTED] The prolonged evacuation would have dramatically affected the survivability of the occupants. ---End Message--- ---BeginMessage--- At 09:49 AM 12/28/2006, William Stokes wrote: Is it possible to read Excel files and store the info to DB? If so how? Thanks -Will Yes - but rather than re-invent the wheel, google for php read excel. Your solution may be there. Once you have read the information, then the rest is just an INSERT into the database. Cheers - Miles -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.15.28/606 - Release Date: 12/28/2006 ---End Message--- ---BeginMessage--- On a side note, but going on the basis that the users are uploading .xls files and don't understand how to convert. Would it be better to use php's routines or to automate excel, convert it inside there, and then use the result? Leonard Burton wrote: On 12/28/06, Jiffy Slides Leonard Burton [EMAIL PROTECTED] wrote: HI Will, Is it possible to read Excel files and store the info to DB? If so how? It is best (well depending on the application) to save the files as .csv and then use fgetcsv. it will allow you to parse each line and cell in the file and then go from there. Take Care, -- Leonard Burton, N9URK [EMAIL PROTECTED] The prolonged evacuation would have dramatically affected the survivability of the occupants. ---End Message--- ---BeginMessage--- Hi to all! I moved my website from one php4/mysql4 based server to new hosting company and php5/mysq5 based server. Everything worked fine on old server, though now, on one page after I submit new record, I'll get this error: Warning: mysql_real_escape_string() [function.mysql-real-escape-string https://www.mydomain.com/function.mysql-real-escape-string ]: Access denied for user 'daemon'@'localhost' (using password: NO) in /srv/www/mydomain/add_record.php on line 30 Warning: mysql_real_escape_string() [function.mysql-real-escape-string https://www.mydomain.com/function.mysql-real-escape-string ]: A link to the server could not be established in /srv/www/mydomain.com/add_record.php on line 30 and this is a code: 26 if(isset($_POST['SubmitNewRecord'])) 27 { 28 foreach($_POST as $key = $value) 29 { 30 ${$key} = mysql_real_escape_string($value); 31 } 32 } Never got such a error message before. Any thoughts? Thanks. -afan ---End Message--- ---BeginMessage--- You need to have established a database connection before using that function, see manual. [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi to all! I moved my website from one php4/mysql4 based server to new hosting company and php5/mysq5 based server. Everything worked fine on old server, though now, on one page after I submit new record, I'll get this error: Warning: mysql_real_escape_string() [function.mysql-real-escape-string https://www.mydomain.com/function.mysql-real-escape-string ]: Access denied for user 'daemon'@'localhost' (using password: NO) in /srv/www/mydomain/add_record.php on line 30 Warning: mysql_real_escape_string()
Re: [PHP] PHP podcasts
I think what is going on is that somehow when the code goes to the podcast feeds to get the URLs it's getting the wrong things because they're not even media files, some times they just look like incomplete URLs. When you go to the site itself the streams work fine and result in proper media file URLs. I should dig deeper into the code to see exactly how it's getting the URLs. I think that should probably be next. Skip Stut wrote: Skip Evans wrote: The URLs are all supposed to come from the live feeds so I am a bit baffled why some work and some don't. Are you sure that all the URLs in the feeds are still working? Remember that links go bad. Beyond that it's difficult to help with this specific problem without seeing some code and the XML feeds that the code is using. -Stut -- Skip Evans Big Sky Penguin, LLC 61 W Broadway Butte, Montana 59701 406-782-2240 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: GD 2.0.28 + PHP 4.4.2 + pixelation :(
Steven Macintyre escreveu: Hi All, I have done some searching via google and some answers say change copyimageresampled to copyimageresized etc I have tried all fixes ... to no avail I have one image here 1280 x 960 (150 dpi) 24 depth When using the following it pixelates ... function createthumb($name,$filename,$new_w,$new_h) http://www.educar.pro.br/abc/gdlib/ zerof -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] reading MS Excel?
Is it possible to read Excel files and store the info to DB? If so how? Thanks -Will -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] reading MS Excel?
On 12/28/06, Jiffy Slides Leonard Burton [EMAIL PROTECTED] wrote: HI Will, Is it possible to read Excel files and store the info to DB? If so how? It is best (well depending on the application) to save the files as .csv and then use fgetcsv. it will allow you to parse each line and cell in the file and then go from there. Take Care, -- Leonard Burton, N9URK [EMAIL PROTECTED] The prolonged evacuation would have dramatically affected the survivability of the occupants. -- Leonard Burton, N9URK [EMAIL PROTECTED] The prolonged evacuation would have dramatically affected the survivability of the occupants. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] reading MS Excel?
At 09:49 AM 12/28/2006, William Stokes wrote: Is it possible to read Excel files and store the info to DB? If so how? Thanks -Will Yes - but rather than re-invent the wheel, google for php read excel. Your solution may be there. Once you have read the information, then the rest is just an INSERT into the database. Cheers - Miles -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.15.28/606 - Release Date: 12/28/2006 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] problem with mysql_real_escape_string()
Hi to all! I moved my website from one php4/mysql4 based server to new hosting company and php5/mysq5 based server. Everything worked fine on old server, though now, on one page after I submit new record, I'll get this error: Warning: mysql_real_escape_string() [function.mysql-real-escape-string https://www.mydomain.com/function.mysql-real-escape-string ]: Access denied for user 'daemon'@'localhost' (using password: NO) in /srv/www/mydomain/add_record.php on line 30 Warning: mysql_real_escape_string() [function.mysql-real-escape-string https://www.mydomain.com/function.mysql-real-escape-string ]: A link to the server could not be established in /srv/www/mydomain.com/add_record.php on line 30 and this is a code: 26 if(isset($_POST['SubmitNewRecord'])) 27 { 28 foreach($_POST as $key = $value) 29 { 30 ${$key} = mysql_real_escape_string($value); 31 } 32 } Never got such a error message before. Any thoughts? Thanks. -afan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: problem with mysql_real_escape_string()
You need to have established a database connection before using that function, see manual. [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi to all! I moved my website from one php4/mysql4 based server to new hosting company and php5/mysq5 based server. Everything worked fine on old server, though now, on one page after I submit new record, I'll get this error: Warning: mysql_real_escape_string() [function.mysql-real-escape-string https://www.mydomain.com/function.mysql-real-escape-string ]: Access denied for user 'daemon'@'localhost' (using password: NO) in /srv/www/mydomain/add_record.php on line 30 Warning: mysql_real_escape_string() [function.mysql-real-escape-string https://www.mydomain.com/function.mysql-real-escape-string ]: A link to the server could not be established in /srv/www/mydomain.com/add_record.php on line 30 and this is a code: 26 if(isset($_POST['SubmitNewRecord'])) 27 { 28 foreach($_POST as $key = $value) 29 { 30 ${$key} = mysql_real_escape_string($value); 31 } 32 } Never got such a error message before. Any thoughts? Thanks. -afan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] problem with mysql_real_escape_string()
[EMAIL PROTECTED] wrote: I moved my website from one php4/mysql4 based server to new hosting company and php5/mysq5 based server. Everything worked fine on old server, though now, on one page after I submit new record, I'll get this error: Warning: mysql_real_escape_string() [function.mysql-real-escape-string https://www.mydomain.com/function.mysql-real-escape-string ]: Access denied for user 'daemon'@'localhost' (using password: NO) in /srv/www/mydomain/add_record.php on line 30 Warning: mysql_real_escape_string() [function.mysql-real-escape-string https://www.mydomain.com/function.mysql-real-escape-string ]: A link to the server could not be established in /srv/www/mydomain.com/add_record.php on line 30 and this is a code: 26 if(isset($_POST['SubmitNewRecord'])) 27 { 28 foreach($_POST as $key = $value) 29 { 30 ${$key} = mysql_real_escape_string($value); 31 } 32 } Never got such a error message before. Check the archives - this was asked a few days ago. The mysql_real_escape_string function requires a connection to the database to be open. If one isn't open it will try to open one with the defaults. All you need to do is make sure you connect to the mysql database before using mysql_real_escape_string. -Stut -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] problem with mysql_real_escape_string()
A little bit lower on php.net/manual I found explanation too. I'm sorry for bothering - wasn't check whole page before posting. The Warning was strange for me because never got it before :) Thanks for your help. -afan [EMAIL PROTECTED] wrote: I moved my website from one php4/mysql4 based server to new hosting company and php5/mysq5 based server. Everything worked fine on old server, though now, on one page after I submit new record, I'll get this error: Warning: mysql_real_escape_string() [function.mysql-real-escape-string https://www.mydomain.com/function.mysql-real-escape-string ]: Access denied for user 'daemon'@'localhost' (using password: NO) in /srv/www/mydomain/add_record.php on line 30 Warning: mysql_real_escape_string() [function.mysql-real-escape-string https://www.mydomain.com/function.mysql-real-escape-string ]: A link to the server could not be established in /srv/www/mydomain.com/add_record.php on line 30 and this is a code: 26 if(isset($_POST['SubmitNewRecord'])) 27 { 28 foreach($_POST as $key = $value) 29 { 30 ${$key} = mysql_real_escape_string($value); 31 } 32 } Never got such a error message before. Check the archives - this was asked a few days ago. The mysql_real_escape_string function requires a connection to the database to be open. If one isn't open it will try to open one with the defaults. All you need to do is make sure you connect to the mysql database before using mysql_real_escape_string. -Stut -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] reading MS Excel?
On a side note, but going on the basis that the users are uploading .xls files and don't understand how to convert. Would it be better to use php's routines or to automate excel, convert it inside there, and then use the result? Leonard Burton wrote: On 12/28/06, Jiffy Slides Leonard Burton [EMAIL PROTECTED] wrote: HI Will, Is it possible to read Excel files and store the info to DB? If so how? It is best (well depending on the application) to save the files as .csv and then use fgetcsv. it will allow you to parse each line and cell in the file and then go from there. Take Care, -- Leonard Burton, N9URK [EMAIL PROTECTED] The prolonged evacuation would have dramatically affected the survivability of the occupants. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] reading MS Excel?
HI John, My reply was made in ignorance of the php classes that will read excel documents. I would follow that road and not my advice! Leonard. On 12/28/06, John Meyer [EMAIL PROTECTED] wrote: On a side note, but going on the basis that the users are uploading .xls files and don't understand how to convert. Would it be better to use php's routines or to automate excel, convert it inside there, and then use the result? Leonard Burton wrote: On 12/28/06, Jiffy Slides Leonard Burton [EMAIL PROTECTED] wrote: HI Will, Is it possible to read Excel files and store the info to DB? If so how? It is best (well depending on the application) to save the files as .csv and then use fgetcsv. it will allow you to parse each line and cell in the file and then go from there. Take Care, -- Leonard Burton, N9URK [EMAIL PROTECTED] The prolonged evacuation would have dramatically affected the survivability of the occupants. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Leonard Burton, N9URK [EMAIL PROTECTED] The prolonged evacuation would have dramatically affected the survivability of the occupants. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Chocked
I was chocked when I got my additional dedicated server from my server provider. I assumed everyting would have been the same as I ordered the server with same package name etc. The chocking part was that the server had PHP5 and not PHP4. Ok, it is not a hard piece of work to get it working, but one thing stunned me :-) Assuming that I have the following structure: /index.php /classes/first.class.php /classes/second.class.php Index.php: include_once(classes/first.class.php); first.class.php include_once(second.class.php); This worked fine, but this time I get an open dir error. Is this something that is new to PHP5 for this, or do I just need to config the server to accept this sloppy including of files? Best regards, Peter Lauri http://www.dwsasia.com/ www.dwsasia.com - company web site http://www.lauri.se/ www.lauri.se - personal web site http://www.carbonfree.org.uk/ www.carbonfree.org.uk - become Carbon Free
Re: [PHP] Chocked
chocked ? chocking ??? Peter Lauri wrote: I was chocked when I got my additional dedicated server from my server provider. I assumed everyting would have been the same as I ordered the server with same package name etc. The chocking part was that the server had PHP5 and not PHP4. Ok, it is not a hard piece of work to get it working, but one thing stunned me :-) Assuming that I have the following structure: /index.php /classes/first.class.php /classes/second.class.php Index.php: include_once(classes/first.class.php); first.class.php include_once(second.class.php); This worked fine, but this time I get an open dir error. Is this something that is new to PHP5 for this, or do I just need to config the server to accept this sloppy including of files? Best regards, Peter Lauri http://www.dwsasia.com/ www.dwsasia.com - company web site http://www.lauri.se/ www.lauri.se - personal web site http://www.carbonfree.org.uk/ www.carbonfree.org.uk - become Carbon Free -- Skip Evans Big Sky Penguin, LLC 61 W Broadway Butte, Montana 59701 406-782-2240 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Chocked
what if you prepend your path with ./ : include_once(./classes/first.class.php); include_once(./second.class.php); is the include path configured correctly? -- View this message in context: http://www.nabble.com/Chocked-tf2892714.html#a8082223 Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Chocked
At 12/28/2006 03:51 PM, Skip Evans wrote: chocked ? chocking ??? RTFM: http://php.net/chocked Warm regards, Paul -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Apache 2.2 + PHP5.2 + php_oci8.dll
Hi Roman, Why can't you use the newest client? Bcoz 10g client doesn't connect to mine server runing on 8i. Which procedure is it? Use depends.exe to find out what other libraries you're missing. Noting is missing, but when it starts it prompts that error. Tq On 12/23/06, Roman Neuhauser [EMAIL PROTECTED] wrote: # [EMAIL PROTECTED] / 2006-12-23 12:21:35 +0800: I saw numerous posting on this type of posting and no one seems to have a consistent solution to it. Lately, I am quite disapointed with the pain of going thru this configuration and testing. I need to access the oracle 8i server db using XP + Oracle client 8i + Apache 2.2 + PHP5.2 and I have tried the following without success. Why can't you use the newest client? What is the error ? not sumething special but common PHP Warning: PHP Startup: Unable to load dynamic library 'c:\\php52\\ext\\php_oci8.dll' - The specified procedure could not be found.\r\n in Unknown on line 0 Which procedure is it? Use depends.exe to find out what other libraries you're missing. 1. download the php_oci8.dll from http://pecl4win.php.net/ext.php/php_oracle.dll (you name the version, tried everythign doesn't work) 2. assign ORACLE_HOME, NSL_LANGUAGE...nope...doesn't work. 3. use old php4.1.xx + Apache 1.3xx on XP with Oracle client 8i...nope doesn't work ( I use this in my NT4, it works like charm) 4. Zendcore for oracle...no no...it doesn't support Oracle 8i connectivity. 5. anyone know where to look for oracle 8i/9i clients for linux ? not available at oracle website :( -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991
[PHP] Re: Chocked
I think this is correct: Let's just assume for a minute that in your index.php you echo out getcwd(); Output would be / (only an example) According to that you do the following include: include(./classes/first.class.php); If you were to echo getcwd() after the include in the first.class.php it would output / You would then have to include your second class (inside the first.class.php - correct?) as: include(./classes/second.class.php) to make it a correct include without PHP having to search the directories for the include. Give that a shot. Regards, Johannes -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] 403 Forbidden
Hi, When I try to run any php script on apache I get a error Authorization required 403 Forbidden. I don't get this error on IIS. I am using Windows XP professional please help. I am using Apache 2.2.1