RE: [PHP-DB] PHP Mysql apache economy hosting
> Hello, > can anyone recommend a good > PHP4/ Mysql/ apache/Unix-Linux economy web hosting co.? > what should I look for? > how do I verify uptime? http://www.php4hosting.com (Root access to MySQL on most accounts, latest versions of PHP/MySQL) Free hosts listed at http://www.alt-php-faq.org/links.htm Regards Darren -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] upload problem ...
many thanks i'll try that asap. Steve "Xsarus Internetdiensten" <[EMAIL PROTECTED]> wrote in message 002901c0fe68$48613d40$0201a8c0@xsarusxsarus2">news:002901c0fe68$48613d40$0201a8c0@xsarusxsarus2... > He! > > Don't use the function 'copy', but 'move_uploaded_file'. > > Ready... > Daniel Kieviet > Xsarus Internetdiensten > Holland > [EMAIL PROTECTED] > > > - Original Message - > From: "Andre P." <[EMAIL PROTECTED]> > To: "Steve Brett" <[EMAIL PROTECTED]> > Cc: "php-db@lists. php. net (E-mail)" <[EMAIL PROTECTED]> > Sent: Monday, June 25, 2001 6:17 AM > Subject: Re: [PHP-DB] upload problem ... > > > > Steve, > > > > When you use input type=file the web server uploads the file to a > > temporary directory which it must have write access to, i.e. the user > > that the httpd process is run as must have write access to /php/tmp. > > > > To my knowledge there is no way of allowing the httpd process to write > > to that directory using your ftp users/password. Bear in mind that you > > could change the temporary upload directory from /php/tmp to /tmp. > > > > do you have full access to you box or only an account? > > > > hope this helps > > > > ciao > > Andre. > > > > Steve Brett wrote: > > > > >hi, > > > > > >i have a site and need to write a script to upload / download files so > the > > >database can be updated / backed up. > > > > > >i've tried setting up an > >machine but php gives an eror onthe server saying that the /php/tmp dir > > >cannot be written to by, i assume, the nobody account within whihc the > web > > >server runs. > > > > > >i need to be bale to write to the httpd dir using php and then i can get > > >the db to import the files. > > > > > >i have an ftp username and password but don't know how to get php to pass > > >the authorisation the server. the site is already password protected just > > >using a table of username / passowrds. > > > > > >many thanks in advance > > > > > >Steve > > > > > > > > > > > > > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] upload problem ...
> -Original Message- > From: Steve Brett [mailto:[EMAIL PROTECTED]] > Sent: 13 July 2001 11:05 > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] upload problem ... > > > many thanks i'll try that asap. The directorys will still need the permissions set so anyone can read/write to the directorys (Using chmod if using linux) Darren > > Steve > > "Xsarus Internetdiensten" <[EMAIL PROTECTED]> wrote in message > 002901c0fe68$48613d40$0201a8c0@xsarusxsarus2">news:002901c0fe68$48613d40$0201a8c0@xsarusxsarus2... > > He! > > > > Don't use the function 'copy', but 'move_uploaded_file'. > > > > Ready... > > Daniel Kieviet > > Xsarus Internetdiensten > > Holland > > [EMAIL PROTECTED] > > > > > > - Original Message - > > From: "Andre P." <[EMAIL PROTECTED]> > > To: "Steve Brett" <[EMAIL PROTECTED]> > > Cc: "php-db@lists. php. net (E-mail)" <[EMAIL PROTECTED]> > > Sent: Monday, June 25, 2001 6:17 AM > > Subject: Re: [PHP-DB] upload problem ... > > > > > > > Steve, > > > > > > When you use input type=file the web server uploads the file to a > > > temporary directory which it must have write access to, i.e. the user > > > that the httpd process is run as must have write access to /php/tmp. > > > > > > To my knowledge there is no way of allowing the httpd process to write > > > to that directory using your ftp users/password. Bear in mind that you > > > could change the temporary upload directory from /php/tmp to /tmp. > > > > > > do you have full access to you box or only an account? > > > > > > hope this helps > > > > > > ciao > > > Andre. > > > > > > Steve Brett wrote: > > > > > > >hi, > > > > > > > >i have a site and need to write a script to upload / > download files so > > the > > > >database can be updated / backed up. > > > > > > > >i've tried setting up an fine on my > > > >machine but php gives an eror onthe server saying that the > /php/tmp dir > > > >cannot be written to by, i assume, the nobody account within > whihc the > > web > > > >server runs. > > > > > > > >i need to be bale to write to the httpd dir using php and then i can > get > > > >the db to import the files. > > > > > > > >i have an ftp username and password but don't know how to get php to > pass > > > >the authorisation the server. the site is already password protected > just > > > >using a table of username / passowrds. > > > > > > > >many thanks in advance > > > > > > > >Steve > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > To contact the list administrators, e-mail: > [EMAIL PROTECTED] > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP Mysql apache economy hosting
How long have you been using phpwebhosting.com? They sound pretty amazing for the low price of $9.99. Are they stable? I'm curious because I may be doing some work for a few clients and I'm looking for a good hosting provider to set them up at. Currently I'm using cedant.com and they are not bad at all but phpwebhosting.comjust sounds really amazing. - Original Message - From: "Beau Lebens" <[EMAIL PROTECTED]> To: "'Ken Sommers'" <[EMAIL PROTECTED]>; "PHP DB Mailing List" <[EMAIL PROTECTED]> Sent: Friday, July 13, 2001 2:32 AM Subject: RE: [PHP-DB] PHP Mysql apache economy hosting > i am using phpwebhosting.com, which is only 9.95US per month, so far they > have been really good. > > have PHP4, MYSQL (one table with account, extras by request) 150mb storage, > but this is unmonitored, PO3 email account, subdomains etc etc - take a look > at their site :) > > // -Original Message- > // From: Ken Sommers [mailto:[EMAIL PROTECTED]] > // Sent: Friday, 13 July 2001 2:26 PM > // To: PHP DB Mailing List > // Subject: [PHP-DB] PHP Mysql apache economy hosting > // > // > // Hello, > // can anyone recommend a good > // PHP4/ Mysql/ apache/Unix-Linux economy web hosting co.? > // what should I look for? > // how do I verify uptime? > // > // thanks > // Ken > // > // > // > // > // -- > // PHP Database Mailing List (http://www.php.net/) > // To unsubscribe, e-mail: [EMAIL PROTECTED] > // For additional commands, e-mail: [EMAIL PROTECTED] > // To contact the list administrators, e-mail: > // [EMAIL PROTECTED] > // > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Chose ID from Table ?
Hello How can i do this here: I have a script, where i insert informations into a table. I now want now to read out the ID those informations got. Hot to do that ? -- mfg, andy - In Memoriam - Jaques www.amdclan.de/jaques -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Chose ID from Table ?
Hi, If you're using MySQL you could try with mysql_insert_id() http://www.php.net/manual/en/function.mysql-insert-id.php Dobromir Velev -Original Message- From: Andreas Iwanowski <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Friday, July 13, 2001 2:12 PM Subject: [PHP-DB] Chose ID from Table ? >Hello >How can i do this here: >I have a script, where i insert informations into a table. >I now want now to read out the ID those informations got. > >Hot to do that ? > >-- > > >mfg, andy > >- >In Memoriam - Jaques >www.amdclan.de/jaques >-- > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
php-db@lists.php.net
Thanks to all for your help. I had to step away for a while yesterday so I am just now getting back to your responses. Here is what I was having a problem with: $Customer Based on your responses, here is what I have now (this works!): $Customer As you can see, urlencode did the trick. Thanks again everybody!! Randy Rankin -Original Message- From: Ken Sommers [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 10:27 PM To: Rankin, Randy; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Escaping & Please explain the dynamic link . is that in the documentation somewhere>? Kne - Original Message - From: "Rankin, Randy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 12, 2001 8:18 AM Subject: [PHP-DB] Escaping & > Hello, > > I have a table in a MySQL DB (RH Linux/Apache) with a field called > customer_name. Some of the customer names have an ampersand in them (ie; X & > X Supply). I am performing a select statement on this table to create a > sales summary with customer name and total sales. > > This works fine; however, I am also creating a dynamic link on the customer > name so that the user can click on it to get a detailed report of sales to > that customer. This works great EXCEPT for the customers with ampersands in > thier names. The result of clicking on these customers indicates a "No > Records found for X" where X is the letter immediately preceding the > ampersand. > > Does anyone know how to get around this? > > TIA, > > Randy Rankin > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Prob's with saving special Chars into LDAP under PHP
On Tue, Jun 12, 2001 at 09:43:28AM +0200, Felix Meulenkamp wrote: > My Prob... I'm adding ldap-entrys utf8-encoded to the db, but i have > probs to add them to utf8-encoded DNs like: > cn=Mike Müller, o=My Org, c=de > But after saving, it looks like: > cn=Mike M?ller, ... > And... I can add attributes with a utf8-encoded value, but not with > many encoded values ... Are you sure it isn't just your LDAP client that displays it as ?, I find it hard to believe that PHP actually stores it as a ?. I'm not sure what you mean by the last comment. > Q: Are there some special hints to follow for encoding the DN? Not in this respect > Q: What to do for saving many special-chars-strings for one attribute? So you have multiple values where at least two have non-ascii characters? > I'm running PHP 4.0.4pl1 and Open-LDAP 2.0.7. > ...perhaps this behavior depends on a bug..? If you could send me a smallest possible PHP script that shows the bad behavior, I'll try it out and fix the bug, or if there is no bug tell you why. Stig -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] PHP Mysql apache economy hosting
I recommend MissoulaWeb for $10/month. http://www.missoulaweb.com/testimonials.phtml http://www.missoulaweb.com/allfeatures.phtml http://www.missoulaweb.com/compare.phtml (a chart) As for verifying uptime, try using the tool at http://uptime.netcraft.com/up/graph/ -- Allen Lee http://MissoulaWeb.com Hosting, Programming and Design -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Ingres & PHP
Hello, I'm trying to access Ingres II database servers. But if I use the extension php_ingres.dll php.exe crashes (with and without parsing a file). I executed php.exe wih the Dependency Walker (http://www.dependencywalker.com). Here the last output of the log window after profiling: ... LoadLibraryA("./extensions/php_ingres.dll") returned 0x00DE by thread 1. GetProcAddress(0x00DE [c:\php\extensions\PHP_INGRES.DLL], "get_module") called from "c:\winnt\system32\PHP4TS.DLL" at address 0x10019DDF and returned 0x00DE1000 by thread 1. First chance exception 0xC005 (Access Violation) occurred in "c:\winnt\system32\PHP4TS.DLL" at address 0x100969C9 by thread 1. Second chance exception 0xC005 (Access Violation) occurred in "c:\winnt\system32\PHP4TS.DLL" at address 0x100969C9 by thread 1. Exited "c:\php\PHP.EXE" (process 0x428) with code 128 (0x80) by thread 1. Second, I tried a ODBC_CONNECT with PHP (without the extension php_ingres.dll). But no success. It's no problem to access INGRES-ODBC with Crystal Reports and JDBC. Even if php.exe parse test.php it pop´s up a Errorwindow: ODBC/OpenAPI Initialization Error: IIapi_initialize() return code=8(out of memory) Output on commandline: Trashed symbol table C:\oro\ingres\files\symbol.tbl Warning: SQL error: [Microsoft][ODBC Driver Manager] Fehler beim SQLAllocHandle-Aufruf f³r Treiber auf SQL_HANDLE_ENV., SQL state IM004 in SQLConnect in e:\php\condb.php on line 5 My environment: W2k SP2, Apache 1.3.20, PHP 4.0.6, Ingres II 2.5 I hope there's anyone can help me. thanks Frank Pietsch -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] RE: PHP Mysql apache economy hosting
I used Cedant.com to host my own site for a few months, and they were excellent - no down time that I was aware of, and a handy web-based control panel (and of course SSH shell access for anything not covered by the control panel.) Although they didn't have a large tech support phone bank (Usually I'd leave a voice mail and get a call or e-mail back within a couple of hours), their support was intelligent and very responsive. I think it was about $12.95/month for the plan I used, which included PHP/MySQL on RedHat Linux 7.0 and plenty of traffic for my small needs. -Andy P.S. I don't work for Cedant or anything, and the only reason I stopped using them was that I got my own Linux/PHP/MySQL server going on an old Pentium 200 at home - no 100% uptime guarantees, but I don't really get any traffic to speak of so it's not a huge concern. ;-) > -Original Message- > From: Ken Sommers [mailto:[EMAIL PROTECTED]] > Hello, > can anyone recommend a good > PHP4/ Mysql/ apache/Unix-Linux economy web hosting co.? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Selecting userID
I have attached what I have so far. This version uses a table called "picture_upload" and the field name is "picture_name".. also in my user table I have the same field name, but that is from past trying to get it to work... crap I got it to upload to the table just fine and copy the file from a temp source to the image directory I have chosen. So it works... but! it will not insert into the right userid field, so I took it out and just made it where they can copy and paste the url into the old way.. defeats the purpose of uploading but atleast it gives them a place to put their files if they don't have one :) Can you take a look at my code below, and tell me how we can make it Select a userid from the person who is logged in so that that the url can be posted in the right field. I will try to play with it a little more today, but I have sun poisoning and I am itching and burning all over... what a pain. This is for use with vb bulletin board software.. there is a user table with userid for the id number of the user.. and I am sure I will have to include the global.php file to find the bbuserinfo that is logged in. start code --- Photo Upload Information VERY, VERY IMPORTANT - PLEASE READ! If you have "Turned On" the picture activation to show your photo, be reminded that it is shown to all members and guests that come to this site to look around and vote. If there is any information that you have given upon your part to this site that you don't want others to know about, please go into your user control panel and change it. If you have any problems with users and/or guests of this site because of your photo or your actions, please notify one of the Administrators or Moderators. Also please try to limit photos to no more than 500 pixels in width, and 75kb in size. Reason being is that you will probably get a better rating if it does not take forever for your picture to download, and you also don't want your face to take up the whole screen. Upload Form Upload a Photo http://www.addictedusers.com/board/ranking/images";; echo "temp file: $picture\n"; echo "file name: $picture_name\n"; echo "file size: $picture_size\n"; echo "file type: $picture_type\n"; echo "\n"; echo "Copy and Paste this url : $beefy/$picture_name\n"; echo "\n"; echo "\n"; return 0; } ?> --- end code --- Thanks BradC -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] data consistency
MySQL supports transactions so you can submit multiple SQL statements and commit them all at once. example of statement (from www.mysql.com) BEGIN; SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summmary=@A WHERE type=1; COMMIT; Robert Klinkenberg > -Oorspronkelijk bericht- > Van: andRie Is [SMTP:[EMAIL PROTECTED]] > Verzonden:Friday, July 13, 2001 2:19 AM > Aan: [EMAIL PROTECTED] > Onderwerp:[PHP-DB] data consistency > > Hello php-db, > > is PHP / Mysql could handle multiple access into table to keep data > consistency ? > > > ,,, > (@-@) > +==---o00(_)00o-==+ > > "It is better to be defeated on principle than to win on lies." > --Arthur Calwell > -- > Best regards, > andRie > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] PHP Mysql apache economy hosting
Well that's mighty tacky of you. On Fri, 13 Jul 2001, [EMAIL PROTECTED] wrote: > > I recommend MissoulaWeb for $10/month. > > http://www.missoulaweb.com/testimonials.phtml > http://www.missoulaweb.com/allfeatures.phtml > http://www.missoulaweb.com/compare.phtml (a chart) > > As for verifying uptime, try using the tool at > http://uptime.netcraft.com/up/graph/ > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Selecting userID
Brad-- I see what you're trying to do. Here's how this issue with a site I did, perhaps this will help: Eliminate the database of images all together. Create an image that says "No Picture Available", and save it as "/images/no_photo.jpg". When (if) a user uploads a file, have it rename the file as /home/addicted/public_html/board/ranking/images/$user_id.jpg. Then, place a call in your php page to: And in the image.php file, have it check to see if the image actually exists: (this is assuming $user_id is an integer) Good luck! -Original Message- From: Brad R. C. [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 12:22 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Selecting userID I have attached what I have so far. This version uses a table called "picture_upload" and the field name is "picture_name".. also in my user table I have the same field name, but that is from past trying to get it to work... crap I got it to upload to the table just fine and copy the file from a temp source to the image directory I have chosen. So it works... but! it will not insert into the right userid field, so I took it out and just made it where they can copy and paste the url into the old way.. defeats the purpose of uploading but atleast it gives them a place to put their files if they don't have one :) Can you take a look at my code below, and tell me how we can make it Select a userid from the person who is logged in so that that the url can be posted in the right field. I will try to play with it a little more today, but I have sun poisoning and I am itching and burning all over... what a pain. This is for use with vb bulletin board software.. there is a user table with userid for the id number of the user.. and I am sure I will have to include the global.php file to find the bbuserinfo that is logged in. start code --- Photo Upload Information VERY, VERY IMPORTANT - PLEASE READ! If you have "Turned On" the picture activation to show your photo, be reminded that it is shown to all members and guests that come to this site to look around and vote. If there is any information that you have given upon your part to this site that you don't want others to know about, please go into your user control panel and change it. If you have any problems with users and/or guests of this site because of your photo or your actions, please notify one of the Administrators or Moderators. Also please try to limit photos to no more than 500 pixels in width, and 75kb in size. Reason being is that you will probably get a better rating if it does not take forever for your picture to download, and you also don't want your face to take up the whole screen. Upload Form Upload a Photo http://www.addictedusers.com/board/ranking/images";; echo "temp file: $picture\n"; echo "file name: $picture_name\n"; echo "file size: $picture_size\n"; echo "file type: $picture_type\n"; echo "\n"; echo "Copy and Paste this url : $beefy/$picture_name\n"; echo "\n"; echo "\n"; return 0; } ?> --- end code --- Thanks BradC -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] RE: PHP Mysql apache economy hosting
You might want to try nomonthlyfees.com. I host two sites with them (that's my only relation) and I've been happy so far. It's $200 up front then $35/year which includes the domain name registration. Aral :) __ ([EMAIL PROTECTED]) New Media Producer, Kismia, Inc. ([EMAIL PROTECTED]) Adj. Prof., American University ¯¯ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] PHP Mysql apache economy hosting
Actually I hadn't noticed that several people were pitching their companies on this list. I noticed this one because of the alias. My apologies. John On Fri, 13 Jul 2001, John Starkey wrote: > Well that's mighty tacky of you. > > On Fri, 13 Jul 2001, [EMAIL PROTECTED] wrote: > > > > > I recommend MissoulaWeb for $10/month. > > > > http://www.missoulaweb.com/testimonials.phtml > > http://www.missoulaweb.com/allfeatures.phtml > > http://www.missoulaweb.com/compare.phtml (a chart) > > > > As for verifying uptime, try using the tool at > > http://uptime.netcraft.com/up/graph/ > > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] IBM DB2 on Linux with PHP is very slow
I just tried the Cursortype parameter (apache-1.3.20+php-4.0.6, DB2-7.1), but I get this message: Warning: SQL error: [IBM][CLI Driver] CLI0150E Driver not capable. SQLSTATE=S1C00, SQL state S1C00 in SQLSetConnectOption in /home/butcher/public_html/php/service_portal/content.php(68) : eval()'d code online 56 msg: [IBM][CLI Driver] CLI0150E Driver not capable. SQLSTATE=S1C00 Is there something I must enable? I've been through the DB2 docs and can't find anything related... g Christian Szardenings wrote: > > Hi Andrew, > > thanks a lot for your help. Today we discovered what > our real problem was: > > After "playing" a little bit with the php-scripts that try > to connect to the IBM DB2, we set the optional parameter > Cursortype when calling odbc_pconnect(). > > And the exciting thing: When we set the cursor type > to SQL_CUR_USE_ODBC Cursor Type, then > the whole query speed up from 1 till 10 seconds > to 0.2 till 0.3 seconds for 100 records. Amazing!!! > > Therfore, PHP is just almost fast as calling the DB2 > from Servlets using JDBC (don't take too much care > about the speed at whole: the database was on a > completely other location, so the whole connection > was made over a slow network connection). > > I hope this helps when other encounter the same > problem when trying to connect to DB2 from > PHP. > > Kind regards, > Christian Szardenings > > "Andrew Hill" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Christian, > > > > Are you using an ODBC driver or just the unified-ODBC functions? > > If a driver, then I suggest changing vendors - that performance is in no > way > > representative of ODBC in general. > > In addition, to improve performance even more when using similar queries, > > first use odbc_prepare to prepare a parameter-bound query and then use > > odbc_execute to create the result set for specific parameter values. > > > > You may wish to try our Multi-Tier drivers at http://www.openlinksw.com. > > Multi-Tier UDA is exceptionally fast and secure, and downloads with a > free, > > non-expiring 2 user license. > > In addition, free support is available at > > http://www.openlinksw.com/support/suppindx.htm > > > > Please let me know if you require assistance. > > > > Best regards, > > Andrew Hill > > Director of Technology Evangelism > > OpenLink Software http://www.openlinksw.com > > Universal Data Access & Data Integration Technology Providers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] upload problem ...
Could anyone send me the actual code for doing the files upload to a linux box with php. I know the form for the upload but not the php file that does the upload . Thanks everyone. "Steve Brett" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > many thanks i'll try that asap. > > Steve > > "Xsarus Internetdiensten" <[EMAIL PROTECTED]> wrote in message > 002901c0fe68$48613d40$0201a8c0@xsarusxsarus2">news:002901c0fe68$48613d40$0201a8c0@xsarusxsarus2... > > He! > > > > Don't use the function 'copy', but 'move_uploaded_file'. > > > > Ready... > > Daniel Kieviet > > Xsarus Internetdiensten > > Holland > > [EMAIL PROTECTED] > > > > > > - Original Message - > > From: "Andre P." <[EMAIL PROTECTED]> > > To: "Steve Brett" <[EMAIL PROTECTED]> > > Cc: "php-db@lists. php. net (E-mail)" <[EMAIL PROTECTED]> > > Sent: Monday, June 25, 2001 6:17 AM > > Subject: Re: [PHP-DB] upload problem ... > > > > > > > Steve, > > > > > > When you use input type=file the web server uploads the file to a > > > temporary directory which it must have write access to, i.e. the user > > > that the httpd process is run as must have write access to /php/tmp. > > > > > > To my knowledge there is no way of allowing the httpd process to write > > > to that directory using your ftp users/password. Bear in mind that you > > > could change the temporary upload directory from /php/tmp to /tmp. > > > > > > do you have full access to you box or only an account? > > > > > > hope this helps > > > > > > ciao > > > Andre. > > > > > > Steve Brett wrote: > > > > > > >hi, > > > > > > > >i have a site and need to write a script to upload / download files so > > the > > > >database can be updated / backed up. > > > > > > > >i've tried setting up an > > >machine but php gives an eror onthe server saying that the /php/tmp dir > > > >cannot be written to by, i assume, the nobody account within whihc the > > web > > > >server runs. > > > > > > > >i need to be bale to write to the httpd dir using php and then i can > get > > > >the db to import the files. > > > > > > > >i have an ftp username and password but don't know how to get php to > pass > > > >the authorisation the server. the site is already password protected > just > > > >using a table of username / passowrds. > > > > > > > >many thanks in advance > > > > > > > >Steve > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: upload problem ...
File 1 (whateverform.php): File 2 (fileupload-destination.php): if (is_uploaded_file($alfredoUpload)) { // Uncomment the following line ONLY if you're on Red Hat 7.0 // $Fix_RH7_Upload = fix_php_rh7_upload_bug($alfredoUpload); // Move to directory $filename = basename ($alfredoUpload_name); move_uploaded_file($alfredoUpload, "/home/mydirectory/uploadfolder/" . $filename); } // # // Fix PHP Upload Bug on Red Hat 7.0 // # function fix_php_rh7_upload_bug($tmp) { $infile=fopen($tmp,"r"); // Open the file for the copy $outfile=fopen("$tmp.new","w"); // create a new temp file $header=fgets($infile,255); //get the 1st line (netscape sometimes doesn't add a Content-type line) //if its more than just a \r\n sequence then if (strlen($header)>2) $header=fgets($infile,255); //get next line also while(!feof($infile)) { // Loop through the remaining file $temp=fread($infile,128); fwrite($outfile,$temp,strlen($temp)); //copying contents to new temp file } fclose($outfile); fclose($infile); copy("$tmp.new","$tmp"); //replace the original with our new bug fixed file unlink("$tmp.new"); //and delete the new file return filesize($tmp); //return a true file size } You can post the upload to the same file if you want (so File 1 AND File 2 are whateverform.php). I just split them up for this example. I don't take credit for the fix_php_rh7_upload_bug function. That was posted by someone else on the PHP documentation. - Jonathan -Original Message- From: comp.mail.sendmail [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 10:28 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] upload problem ... Could anyone send me the actual code for doing the files upload to a linux box with php. I know the form for the upload but not the php file that does the upload . Thanks everyone. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] PHP calling Javascript
Hi. I was wondering how to call a javascript function within PHP? Any ideas of solutions. Thanks in advance. Kevin Johnson Jr. System Administrator Erogo, Inc. www.erogo.com Contact Info: Email: [EMAIL PROTECTED] Office: (714) 832- x150 Cell: (714) 454-6763 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] PHP calling Javascript
"; echo "execMyFunction(var1topass, anothervar, funfunvars);"; echo ""; ?> Then again, if you want to assign a $var to a returned value from a JavaScript function...well...I can't help you there (personally, I don't think that's even possible, but..what do I know? -- David Balatero [EMAIL PROTECTED] -- -Original Message- From: Kevin Johnson [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 11:14 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP calling Javascript Hi. I was wondering how to call a javascript function within PHP? Any ideas of solutions. Thanks in advance. Kevin Johnson Jr. System Administrator Erogo, Inc. www.erogo.com Contact Info: Email: [EMAIL PROTECTED] Office: (714) 832- x150 Cell: (714) 454-6763 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] CGI or API installation?
Hello, How to tell if php4 is installed as a CGI or API module) installation? will phpinfo() tell me? thanks , Ken -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: PHP calling Javascript
"Kevin Johnson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > I was wondering how to call a javascript function within PHP? > Any ideas of solutions. You can't, at least not in the way you seem to mean. PHP runs on the server, JavaScript on the client. PHP finishes completely before JavaScript starts. The two can't interact as such. What you CAN do is use PHP to create a page such that the JavaScript function will get run. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: upload problem ...
I have implemented the code even as one file but the php file just run without uploading the file to the server, though i have chmod the uploadfolder "tmp" as 777,, Any help.Thanks ... "Jonathan Hilgeman" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > File 1 (whateverform.php): > > METHOD=POST> > > > > > > File 2 (fileupload-destination.php): > > if (is_uploaded_file($alfredoUpload)) > { > // Uncomment the following line ONLY if you're on Red Hat 7.0 > // $Fix_RH7_Upload = fix_php_rh7_upload_bug($alfredoUpload); > // Move to directory > $filename = basename ($alfredoUpload_name); > move_uploaded_file($alfredoUpload, "/home/mydirectory/uploadfolder/" . > $filename); > } > // # > // Fix PHP Upload Bug on Red Hat 7.0 > // # > function fix_php_rh7_upload_bug($tmp) > { > $infile=fopen($tmp,"r"); // Open the file for the copy > $outfile=fopen("$tmp.new","w"); // create a new temp file > $header=fgets($infile,255); //get the 1st line (netscape sometimes doesn't > add a Content-type line) > //if its more than just a \r\n sequence then > if (strlen($header)>2) $header=fgets($infile,255); //get next line also > while(!feof($infile)) > { // Loop through the remaining file > $temp=fread($infile,128); > fwrite($outfile,$temp,strlen($temp)); //copying contents to new temp file > } > fclose($outfile); > fclose($infile); > copy("$tmp.new","$tmp"); //replace the original with our new bug fixed file > unlink("$tmp.new"); //and delete the new file > return filesize($tmp); //return a true file size > } > > > You can post the upload to the same file if you want (so File 1 AND File 2 > are whateverform.php). I just split them up for this example. I don't take > credit for the fix_php_rh7_upload_bug function. That was posted by someone > else on the PHP documentation. > > - Jonathan > > > -Original Message- > From: comp.mail.sendmail [mailto:[EMAIL PROTECTED]] > Sent: Friday, July 13, 2001 10:28 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] upload problem ... > > Could anyone send me the actual code for doing the files upload to > a linux box with php. I know the form for the upload but not the php file > that > does the upload . > Thanks everyone. > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] RE: PHP Mysql apache economy hosting
Try http://www.aletiahosting.com/. I have my sites hosted by them. Excellent support especially the ones via AIM/ICQ. The people are always around to answer your questions. Plans start at $9.95/month. Hope this helps. Best wishes, Indri >> -Original Message- >> From: Ken Sommers [mailto:[EMAIL PROTECTED]] > >> Hello, >> can anyone recommend a good >> PHP4/ Mysql/ apache/Unix-Linux economy web hosting co.? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] problem with " "
hello, i'm having problems with " " ... when i'm using stripslashes ... the word is cut after the quotation marks ... for example This is the sample "sentence" ... the output will be ... This is the sample it works fine if i will not use stripslashes however the apostrophe will the one to encounter problems... hope someone could help... thanks very much :)
Re: [PHP-DB] problem with " "
maybe a \"sentence\" will help? maybe i'm talking about something else? beckie http://www.onlymacintosh.com > From: "Jennifer Arcino Demeterio" <[EMAIL PROTECTED]> > Date: Sat, 14 Jul 2001 11:57:54 +0800 > To: <[EMAIL PROTECTED]> > Subject: [PHP-DB] problem with " " > > hello, > > i'm having problems with " " ... when i'm using stripslashes ... the word is > cut after the quotation marks ... > > for example > > This is the sample "sentence" ... > > the output will be ... > > This is the sample > > it works fine if i will not use stripslashes however the apostrophe will the > one to encounter problems... > > hope someone could help... > > thanks very much :) > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] display errors
i am using php3 and mysql to develop a scheuler app. i have a column name name (varchar 40) i am pulling the value into a text field with a name=name and value =$name on a php page. the problem is for ie. name=chris hebert i get chris in my text field. it stops displying the data at the space. thoughts. CSHebert -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] display errors
I'm assuiming this means you're pulling the name from the DB and putting it as the value of a text input, as in: INPUT TYPE=TEXT NAME="name" VALUE="$name" The quotes should fix that problem. -Original Message- From: Christopher Hebert [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 4:07 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] display errors i am using php3 and mysql to develop a scheuler app. i have a column name name (varchar 40) i am pulling the value into a text field with a name=name and value =$name on a php page. the problem is for ie. name=chris hebert i get chris in my text field. it stops displying the data at the space. thoughts. CSHebert -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] Interbase/PHP/Apache implimentation
Od: "Jordan" <[EMAIL PROTECTED]> Temat: [PHP-DB] Interbase/PHP/Apache implimentation > So my question is this: Can DBMS support be enabled using the extension=php_interbase.dll directive > in the php.ini file (as opposed to MySQL, where support is built in) ONLY while in CGI mode? Will > the distribution version of php4apache.dll not look at the php.ini file, to enable Interbase > support? > > If that is the case, is there anywhere one might find a version of the php4apache.dll file which > enables Interbase support? > I will use CGI if I must, but my preference is to use the Apache Module I have 2 installations: on NT4 at work and W98 at home, both working as a module. Except of OS the configuration is same: Apache 1.3.19, PHP 4.0.5, Borland's IB 6.0.1. If you are interested, i can send you my php.ini files privately, although this one from my work in tuesday. Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Interbase/PHP/Apache implimentation
Okay... ...I have been trying (and failing) to get Interbase to work with PHP, served up by Apache on a Win2K machine. Through a lot of headache and the process of elimination, I have succeeded in getting an SQL response from PHP, after eliminating any instructions for Apache to load the PHP module - using only the CGI interface. So, if I understand things, my problem has been that I've been attempting to get Interbase support from the PHP module for Apache, which won't work for one reason or another. If true, this comes as great relief, because I was beating my head against the wall trying to figure out where my php.ini file was misconfigured So my question is this: Can DBMS support be enabled using the extension=php_interbase.dll directive in the php.ini file (as opposed to MySQL, where support is built in) ONLY while in CGI mode? Will the distribution version of php4apache.dll not look at the php.ini file, to enable Interbase support? If that is the case, is there anywhere one might find a version of the php4apache.dll file which enables Interbase support? I will use CGI if I must, but my preference is to use the Apache Module Thanks in advance, --Jordan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]