[PHP-DB] Help ! MySQL Problem
Hi, I'm using MySQL database and I try: " insert into roubr('id','pos','name') values ( select id,pos,name from requestroubr) " and it don't work ! Please help! Rosen Marinov -- 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] Help ! MySQL Problem
ok you must get your variables like row1, row2 etc from anywherelse then try this format too insert them at your db mysql_connect("localhost","username","password") or die ("cant connect database"); @mysql_select_db("databasename") or die("cant connect database"); mysql_query("INSERT INTO yourtablename(row1, row2, row3) VALUES ('$row1', '$row2', '$row3') ") ""Rosen"" [EMAIL PROTECTED] wrote in message 987flt$h2r$[EMAIL PROTECTED]">news:987flt$h2r$[EMAIL PROTECTED]... Hi, I'm using MySQL database and I try: " insert into roubr('id','pos','name') values ( select id,pos,name from requestroubr) " and it don't work ! Please help! Rosen Marinov -- 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] Help ! MySQL Problem
Thanks, but it doesn't work ! "Brinzoi Constantin Aurelian" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... On Thu, 8 Mar 2001, Rosen wrote: Hi, I'm using MySQL database and I try: " insert into roubr('id','pos','name') values ( select id,pos,name from requestroubr) " Try this: insert into roubr(id,pos,name) values select id,pos,name from requestroubr I hope this will work ! Best regards Constantin Brinzoi and it don't work ! Please help! Rosen Marinov -- 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] PHP vs. Perl for XML
Hi, I've been trying to find information on the interaction of XML and PHP recently (for a view of one day writing .cgi scripts that search my xml documents with a knowledge of their hierarchy, etc.) And I came across this recorded roundtable discussion on perl and xml at: http://www.xml.com/lpt/a/av/revised.html Now, I wonder if Perl is a better choice than PHP to interact with XML Any experience on integrating PHP with XML? Santi PS: (The two main speakers are Larry Wall, the developer of the Perl programming language, and Tim Bray, the co-editor of the XML Specification and the technical editor for XML.com) -- 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] About MySQL connections
Hi, I use "mysql_pconnect" function to connect to MySQL server. When I call function second time I receive error: "Warning: MySQL Connection Failed: Too many connections in /website/transfer.php on line 17" Please HELP! Rosen MArinov -- 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] MySQL selects it's clients carefully?
Environment: Two servers, which another has Windows 2000 Server and another one runs Linux. Both of them has PHP (IIS/Apache) and MySQL installed. They seemingly share configuration and they have exactly the same database structure, data and PHP scripts as well. This combination works in following cases: - Linux PHP application uses Windows's MySQL database - Windows PHP application uses Windows's MySQL database - Linux MySQL client software uses Windows's MySQL database - Windows MySQL client software uses Linux's MySQL database - Either computer's MySQL client software uses MySQL database on the same computer However, if PHP application on either server tries to use MySQL database on the Linux server, it doesn't work. Symptom is quite strange: MySQL connection is established normally, but any simple query fails to run (there is no error, but it returns no result set). I've run all the tests on same user account and this situation is the only one that fails. MySQL version is 3.23.33 and PHP version 4.0.4pl1. Any ideas? -- 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] connecting to a sybase-database using php 4.04pl1 on win32
Hi! I am trying to connect a sybase-database using the php_sybase_ct.dll module, but all I get is a pop-up window telling: "Unable to load dynamic library './extensions/php_sybase-ct.dll' - The dynamic library could not be found.". I have really worked hard on this one. I'm sure that the path is correct spelled in php.ini, because the postgreSQL-dll placed in the same directory and it's working out fine. Any suggestions? Regards Trond Straume -- 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] PHP4 and ORACLE8i
Hi, Maybe you should modify extension_dir in the php.ini file as following: extension_dir=path\to\you\extension\dll\ the extension dll such as php_oci8.dll should place in such a directory. Weiping Tsen [EMAIL PROTECTED] --Original Message-- Hi, I'm having some troubles connecting php with a oracle8 DB. Even the extensions are a problem. I uncomment extension=php_oci8.dll in the php.ini file (yeah yeah php and apache on win32, company rules you know), but it's giving a error like "cannot find extension .". You have to know that our DB is managed on an other computer. I assume that php needs the oracle libs?? Need some more information about this, php and ora is rather difficult compared to php en mysql (which I'm used to). thx Günther [EMAIL PROTECTED] Want a free mail at http://www.mail.be ? -- 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] password security on an isp
Hi all - I am using php/MySQL on an ISP in which there are other users. Everyone has SSH access and can therefore enter everyone else's directories and read any world-readable files. I have a config.inc file which contains my MySQL username and password. This file is located outside of my web directory (to prevent web browsers from reading it). In addition, my ISP added the user 'www' to my group, enabling me to make config.inc group readable but not user readable. Therefore, none of the other users can SSH into the system and read my username and password. This is great, but there is one more concern: if the user 'www' can read this file, isn't it possible for any other user to write a php script, executable by 'www', that instructs the web server to echo the contents of this file? All they have to know is the directory and name of the file they are looking for. Anyone have suggestions on how to close this security hole? Thanks, Jamie -- 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] Newbie: dba_open error
Hi, I am currently running PHP 4.04/ Apache 1.3 on Windows 2000 and I still get the same error.(Fatal error: Call to undefined function: dba_open()) When I look at the PHP installation file I cannot find a line: "--enable-dba" anywhere in in there. I am not sure where one shld place this instruction in php.ini file Could you tell me if the instruction above was for Unix machine installs only. If so where / what shld I be doing for a Windows/ Apache version. I am runnning php as a module on apache. Thanks Sharat -- 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] Oracle Function Calls Redux
Problem solved! Thanks to everyone who helped out (and to our system DBA for reminding me that an Oracle function is just a type of stored procedure). For what it's worth, here is the code that I wound up using (sensitive company information 'ed out, of course): ?php // Establish Oracle connection putenv("ORACLE_SID="); putenv("ORACLE_HOME="); $db = ocilogon("","",""); if(!$db) die("Database connection failed."); // Execute stored procedure $functionCall = "begin :result := hubins_func('Richard','Y');end;"; $parsedFunctionCall=ociparse($db,$functionCall); ocibindbyname($parsedFunctionCall,":result",$result,10); if(!ociexecute($parsedFunctionCall)) die ("Stored Procedure execution failed."); print("Value of primary key: $result"); // End Oracle connection ocilogoff($db); ? The value of $result is the primary key which is associated with the value inserted into the database with the hubins_func stored proc. -- 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] About MySQL connections
mysql_pconnect() opens a persistent connection, that is, one that remains open for the duration of you session. Therefore, you don't need to re-open it. Either that, or you can use mysql_connect() to open a non-persistent connection. -Original Message- From: Rosen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 5:55 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] About MySQL connections Hi, I use "mysql_pconnect" function to connect to MySQL server. When I call function second time I receive error: "Warning: MySQL Connection Failed: Too many connections in /website/transfer.php on line 17" Please HELP! Rosen MArinov -- 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] About MySQL connections
From the PHP documention: "First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection." According to this, and my own experience also, you can "open" as many pconnects you want without causing any trouble. Lasse Laurila "Rick Emery" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... mysql_pconnect() opens a persistent connection, that is, one that remains open for the duration of you session. Therefore, you don't need to re-open it. Either that, or you can use mysql_connect() to open a non-persistent connection. -Original Message- From: Rosen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 5:55 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] About MySQL connections Hi, I use "mysql_pconnect" function to connect to MySQL server. When I call function second time I receive error: "Warning: MySQL Connection Failed: Too many connections in /website/transfer.php on line 17" Please HELP! Rosen MArinov -- 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: Select just the first two letters in a column (MySQL)
On Thu, 8 Mar 2001 08:47:41 -0600, John Guynn wrote: Is there a way to select just the first two letters in a column? I have a column that contains values like TT1, TT2, TT3, TT4, PR1, PR2, RD1, RD2, RD3, and I'd like to SELECT DISTINCT the first two letters. In otherwords have the select statement return TT, PR, RD. -- Rod Buchanan Programmer/Analyst/List Manager/JOATMON KDS Internet Services http://www.kdsi.net -- 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] Too many includes?
Good Day All, I have my scripts in place and the website is running fine. When there's a surge in traffic, the pages take longer being served up. No big news there, I would expect that. My question is, several of my scripts have: require("file.php"); spread out all over the place. As a matter of fact, there are about 15 of them on several of the pages that get hit the hardest. Do too many includes slow down the pages being rendered in the browser? Cheers, chris -- 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] 1 TNS error out of 25 connections
HI I have a strange behaviour of my remote Apache-PHP-Oracle-Client. Apache 1.3.14 mod SSL PHP 4.0.3pl1 (everything compiled from sources) Oracle 8.1.6 on remote Intel/Redhat 6.2 (100MBit, same subnet) The Oracle Server runs a Multi-Threaded-Server (successfully) and accepts dedicated Serverconnections on the same Port. tnsnames.ora and sqlnet.ora are placed in the proper directories. it works in 95% of all requests, but sometimes (with no specific traffic reason or network problem) it shows an typical _oci_openserver_error: COULD NOT RESOLVE SERVICE NAME. I looked up Oracles Online Help but it's just like check your tnsnames.ora, check your servicename ... But as it works in 95% of all cases, I do not think that the problem is my path to tnsnames.ora Is there anyone that is familiar with that problem or the configuration of MTS and Dedicated at the same port / time ? thank you mk -- 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
I am trying to connect to local Interbase server, folowing exactly PHP online documentation. But I always get a warning: "InterBase: unavailable database in d:\program files\apache group\apache\htdocs\\tabulka.php on line 22" my script is: $db=ibase_connect('D:\Program Files\Borland\Interbase\Examples\Databse\employee.gdb', $username, $password); and I am using Apache under Windows NT 4. Does anybody see a mistake? Thank you for your help Martin -- 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] Ms SQL Server inserting image datatype with PHP??
How can I accomplish this?? -- 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] Ms SQL Server inserting image datatype with PHP??
Althought the article addresses MySQL it may help http://www.phpbuilder.com/columns/florian19991014.php3 Good Luck! Kevin Leavell [EMAIL PROTECTED] P 406.829.8989 C 406.240.4595 --- -Original Message- --- From: j. vos [mailto:[EMAIL PROTECTED]] --- Sent: Thursday, March 08, 2001 2:13 PM --- To: [EMAIL PROTECTED] --- Subject: [PHP-DB] Ms SQL Server inserting image datatype with PHP?? --- --- --- How can I accomplish this?? --- --- --- --- -- --- 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: Good for articles?
Dan, I think it is a very powerful combination. PHP is easy to learn as is mySQL. They are both free and powerful. Question 2: Yes you can do about anything to a database with PHP including updating field data, adding field data, and even creating a new database from a web front end. Chad -Original Message- From: Dan Eskildsen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 5:35 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP: Good for articles? Hi everyone. I am a freelance html web designer - and I am new at it. I have also learnt Javascript. I have a customer - a local newspaper - who wants me to update their site weekly with newspaper articles. I have been doing this in html. I recently changed ISP - and my new ISP allows me to run a MySQL database and PHP. I haven't used PHP before and I am now looking into it as a possiblity to dynamically create html pages that contain the articles sucked out of a SQL database. I was wondering if there is anyone out there who can tell me if PHP + MySQL is a good setup / combination for this type of application. Another Question: Can users via PHP update field data in a MySQL database? I would really appreciate any comments. Please cc: your reply to [EMAIL PROTECTED] It's snowing over here! Regards, Dan -- 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] Where do I get started?
Thanks for the comments. The server is running both MySQL and PHP. How do I get started that this? Can anyone recomment a good book? Thanks again. ""Angerer, Chad"" [EMAIL PROTECTED] skrev i en meddelelse 9E35C54B0C7AD411B5C1009027DE539940B515@MSPMX01">news:9E35C54B0C7AD411B5C1009027DE539940B515@MSPMX01... Dan, I think it is a very powerful combination. PHP is easy to learn as is mySQL. They are both free and powerful. Question 2: Yes you can do about anything to a database with PHP including updating field data, adding field data, and even creating a new database from a web front end. Chad -Original Message- From: Dan Eskildsen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 5:35 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP: Good for articles? Hi everyone. I am a freelance html web designer - and I am new at it. I have also learnt Javascript. I have a customer - a local newspaper - who wants me to update their site weekly with newspaper articles. I have been doing this in html. I recently changed ISP - and my new ISP allows me to run a MySQL database and PHP. I haven't used PHP before and I am now looking into it as a possiblity to dynamically create html pages that contain the articles sucked out of a SQL database. I was wondering if there is anyone out there who can tell me if PHP + MySQL is a good setup / combination for this type of application. Another Question: Can users via PHP update field data in a MySQL database? I would really appreciate any comments. Please cc: your reply to [EMAIL PROTECTED] It's snowing over here! Regards, Dan -- 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]
AW: [PHP-DB] PHP: Good for articles?
Another Question: Can users via PHP update field data in a MySQL database? I would really appreciate any comments. PHP and MySQL (at standard ISPs) is a good (the best) choice for your business. It's cheap, fast and reliable, although i would not take my mission critical parts to an ISP. check out: http://www.phpwizard.net/projects/phpMyAdmin/ phpMyAdmin is a DB-Manager for MySql completely written in PHP. You can do everything with that and so can you with your PHP-Script mk -- 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-INST] FW: I'm not sure where to begin...
Maybe I should have put "NEWBIE ALERT" as part of the subject :) All the same. I thought that the build had already been done in steps 9 and 10 (see manual exerpt). And then, right after that is the line about "building" the CGI executable (section following the steps). Has that not been done already? Perhaps I have done something wrong with the compile or the post-compile Apache configuration. I am probably going to do the compile again. I want to use Apache and MySQL with PHP. Any tips? Before I attempt to compile, where should I locate the Apache, MySQL and PHP source directories (/usr/local?) in terms of best practices? After the build, can I remove the source directories from that machine? When I try to open a sample .php, the browser asks me where I would like to download it. I have obviously missed something. I tried to fix this by adding "AddModule mod_php3.c" to the end of the list of modules in httpd.conf and get an error stating "Cannot add module via name 'mod_php4.c':not in list of loaded modules" on httpd startup. I looked at the other loaded modules and they all end in .so. There is no mod_php4.so on my system. I guess the idiot-proof install wasn't written for SuperIdiot. Anyway, any direction regarding how to troubleshoot this is vigorously encouraged. Regards, Rob x---From the Manualx Apache Module Quick Reference PHP can be compiled in a number of different ways, but one of the most popular is as an Apache module. The following is a quick installation overview. Example 2-1. Quick Installation Instructions for PHP 4 (Apache Module Version) 1. gunzip apache_1.3.x.tar.gz 2. tar xvf apache_1.3.x.tar 3. gunzip php-x.x.x.tar.gz 4. tar xvf php-x.x.x.tar 5. cd apache_1.3.x 6. ./configure --prefix=/www 7. cd ../php-x.x.x 8. ./configure --with-mysql --with-apache=../apache_1.3.x --enable-track-vars 9. make 10. make install 11. cd ../apache_1.3.x 12. ./configure --activate-module=src/modules/php4/libphp4.a 13. make 14. make install 15. cd ../php-x.x.x 16. cp php.ini-dist /usr/local/lib/php.ini 17. Edit your httpd.conf or srm.conf file and add: AddType application/x-httpd-php .php 18. Use your normal procedure for restarting the Apache server. (You must stop and restart the server, not just cause the server to reload by use a HUP or USR1 signal.) Building When PHP is configured, you are ready to build the CGI executable. The command make should take care of this. If it fails and you can't figure out why, see the Problems section. x---End of Manual excerptx -Original Message- From: Josh Lokot [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 11:57 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-INST] FW: I'm not sure where to begin... Type make from in your php-4.0.4pl1 directory. then it should compile. then you can type "make install" and it should install. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, 8 March 2001 10:33 AM To: [EMAIL PROTECTED] Subject: [PHP-INST] FW: I'm not sure where to begin... Hello all, I'm using RHL 6.0 with Apache 1.3.6 and downloaded and attempted an install of PHP-4.0.4pl1 today. As you can probably guess, I was unsuccessful in my first try to get things working here, but I remain hopeful. I followed the instructions given on pp. 51-52 of the http://snaps.php.net/~jah/pdf/manual-en.pdf document. Well, mostly. I don't know what is meant by "When PHP is configured, you are ready to build the CGI executable. The command make should take care of this. If it fails, and you can't figure out why, see the problems section." What directory should I be in when I run make? I thought I had already built everything in the previous 18 step procedure. While I'm at it, since another compile/build seems inevitable, I might as well ask for configuration suggestions as well. The install is on a development server, I just need it to work for now. Regards, Rob -- PHP Install 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] ftp upload
hi there, i want my users to upload their image files to a desired directory, i can handle that but... is it possible to make a "upload file" php script ? any example is high acceptable :) thx in adv. -- 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] ftp upload
http://www.php.net/manual/en/features.file-upload.php -aaron At 3:03 AM +0200 3/9/01, karakedi wrote: hi there, i want my users to upload their image files to a desired directory, i can handle that but... is it possible to make a "upload file" php script ? any example is high acceptable :) thx in adv. -- 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] ftp upload
At 03:03 AM 3/9/2001 +0200, you wrote: is it possible to make a "upload file" php script ? any example is high acceptable :) Read the supplied PHP documentation at: http://www.php.net/manual/en/features.file-upload.php The above link was from the table of contents of the manual which suggests that you did not even try to look this up yourself. Secondly, this has nothing to do with databases and therefore has no place on this list. Not trying to be mean really but it is inappropriate to post off topic questions to what is already a high volume mailing list, especially when the answer is readily available in the PHP manual. Cheers, Ron - Island Net AMT Solutions Group Inc. Telephone: 250 383-0096 1412 Quadra Toll Free:1 800 331-3055 Victoria, B.C. Fax:250 383-6698 V8W 2L1 E-Mail:[EMAIL PROTECTED] Canada WWW: http://www.islandnet.com/ - -- 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] ftp upload
nope i am aware of that manual, simply couldnt figure that out. i see the point of your warning anyway next time that d be more polite if you sent your special comments via email. thx anyway. btw there are tons of things here which is already at some manuels. and i apologise sending this to db, my bad i was reading smt here so that was a mistake. regards, (really) karakedi "Ron Brogden" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... At 03:03 AM 3/9/2001 +0200, you wrote: is it possible to make a "upload file" php script ? any example is high acceptable :) Read the supplied PHP documentation at: http://www.php.net/manual/en/features.file-upload.php The above link was from the table of contents of the manual which suggests that you did not even try to look this up yourself. Secondly, this has nothing to do with databases and therefore has no place on this list. Not trying to be mean really but it is inappropriate to post off topic questions to what is already a high volume mailing list, especially when the answer is readily available in the PHP manual. Cheers, Ron -- --- Island Net AMT Solutions Group Inc. Telephone: 250 383-0096 1412 Quadra Toll Free:1 800 331-3055 Victoria, B.C. Fax:250 383-6698 V8W 2L1 E-Mail: [EMAIL PROTECTED] Canada WWW: http://www.islandnet.com/ -- --- -- 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] php, netscape and sybase
I would just like to thank all of you for your help I have completed the install of php with netscape and sybase database. It was a hard road but your help made it enjoyable. Thanks again. -- 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] Where do I get started?
I enjoyed FAST AND EASY PHP by Julie Meloni [ www.thickbook.com ] and the PHP4 BIBLE [ www.troutworks.com/phpbook ] has served as a good reference. I am new so these are the only two i've read. I just picked up SAMS Teach Yourself SQL in 10 minutes. I know I have heard the books are crap, but i needed a quick references [ tiny little $13 book ] antoher great book is HTML 4: No Experience required by Sybex Books. olinux - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 08, 2001 4:59 PM Subject: Re: [PHP-DB] Where do I get started? I am also very knew at PHP/MySQL and have been busy populating my MySQL databases with tables (phpMyAdmin is a snap-LOL!). I am currently reading 3 different books on PHP, which also discuss use of MySQL as the back end: Essential PHP (Julie Meloni), Beginning PHP (Wrox), and Essential PHP for Web Professionals (Christopher Cosentino). I also bought a book appropriately titled MySQL by Paul DuBois as additional reference for the back end. Dont forget the web: There are also tutorials on the web that may help also. Steph _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- 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-mySQL and an SQL query
Hi, folks, Can someone insight me regarding this? I have a datetime field in mySQL (-mm-dd hh:mm:ss) called event_time I want to pull records hitting against this field with the idea: where the abbreviated month from this field LIKE '$month' and here's the SQL string I've been playing with. It works when I comment out the line that tries to do the above with a subquery. $strSQL = "SELECT DATE_FORMAT(event_time, '%M %e %Y, %l:%i %p'), bandname, image "; $strSQL .= "FROM doings, styles "; $strSQL .= "WHERE style = musicstyle "; $strSQL .= "AND bandname LIKE '$artist' "; $strSQL .= "AND style LIKE '$style' "; $strSQL .= "AND (SELECT DATE_FORMAT(event_time, '%b') FROM doings) LIKE '$month' "; $strSQL .= "ORDER BY event_time"; echo "$strSQLBR"; $month will be carrying the three-character short version of the alpha month name. I don't think it likes my subquery, though I like it just fine. Regards, Michael -- 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-mySQL and an SQL query
Hi, folks, Can someone insight me regarding this? I have a datetime field in mySQL (-mm-dd hh:mm:ss) called event_time I want to pull records hitting against this field with the idea: where the abbreviated month from this field LIKE '$month' and here's the SQL string I've been playing with. It works when I comment out the line that tries to do the above with a subquery. $strSQL = "SELECT DATE_FORMAT(event_time, '%M %e %Y, %l:%i %p'), bandname, image "; $strSQL .= "FROM doings, styles "; $strSQL .= "WHERE style = musicstyle "; $strSQL .= "AND bandname LIKE '$artist' "; $strSQL .= "AND style LIKE '$style' "; $strSQL .= "AND (SELECT DATE_FORMAT(event_time, '%b') FROM doings) LIKE '$month' "; $strSQL .= "ORDER BY event_time"; echo "$strSQLBR"; $month will be carrying the three-character short version of the alpha month name. I don't think it likes my subquery, though I like it just fine. Regards, Michael -- 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 and an SQL query
mysql doesn't support sub-queries unfortunately =( At 10:22 PM 3/8/01 -0500, Michael Gerholdt wrote: Hi, folks, Can someone insight me regarding this? I have a datetime field in mySQL (-mm-dd hh:mm:ss) called event_time I want to pull records hitting against this field with the idea: where the abbreviated month from this field LIKE '$month' and here's the SQL string I've been playing with. It works when I comment out the line that tries to do the above with a subquery. $strSQL = "SELECT DATE_FORMAT(event_time, '%M %e %Y, %l:%i %p'), bandname, image "; $strSQL .= "FROM doings, styles "; $strSQL .= "WHERE style = musicstyle "; $strSQL .= "AND bandname LIKE '$artist' "; $strSQL .= "AND style LIKE '$style' "; $strSQL .= "AND (SELECT DATE_FORMAT(event_time, '%b') FROM doings) LIKE '$month' "; $strSQL .= "ORDER BY event_time"; echo "$strSQLBR"; $month will be carrying the three-character short version of the alpha month name. I don't think it likes my subquery, though I like it just fine. Regards, Michael -- 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] -- Beau Lebens - Web Master Insurance My Way, Your Friendly Online Broker (08) 9226 5888 http://www.insurancemyway.com.au/ -- 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] odbc_columns problem with MSSQL
I am trying to get the column names of some tables with odbc_columns from MSSQL 2000. As I extract a particular column from the result set, the browser hangs. html body ? $con = odbc_connect("mydatabase", "christopher", ""); $result = odbc_columns($con, "mydatabase", "dbo", "dtproperties"); // this works! odbc_result_all($result); // but this doesn't. /* while (odbc_fetch_row($result)) echo odbc_result($result, COLUMN_NAME); */ ? /body /html -- 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] Where do I get started?
One of the best kept secrets (apparently) is to take a program that someone else has created (preferably a mature project that has undergone some growth and cleaning) and learn what it does...syntax is just that...you will see that there are about a million ways of doing any one thing, but only certain ways (coding style) will guarantee that your projects dont collapse on their own obfuscated methods. I must admit I am a newbie, but I have seen some excellent modular, clean code on this tutorial on building an ecommerce site (MyMarket). It is a great departure point for many projects: http://www.devshed.com/Server_Side/PHP/Commerce1/ hth --- Andrew Halliday [EMAIL PROTECTED] wrote: dont bother reading books...if you have coded any c,c++,java,just about any language these books are 80% fluff. All you need is the php manual, a project to start dabbling and this listreally. AndrewH - Original Message - From: "olinux" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 09, 2001 4:06 PM Subject: Re: [PHP-DB] Where do I get started? I enjoyed FAST AND EASY PHP by Julie Meloni [ www.thickbook.com ] and the PHP4 BIBLE [ www.troutworks.com/phpbook ] has served as a good reference. I am new so these are the only two i've read. I just picked up SAMS Teach Yourself SQL in 10 minutes. I know I have heard the books are crap, but i needed a quick references [ tiny little $13 book ] antoher great book is HTML 4: No Experience required by Sybex Books. olinux - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 08, 2001 4:59 PM Subject: Re: [PHP-DB] Where do I get started? I am also very knew at PHP/MySQL and have been busy populating my MySQL databases with tables (phpMyAdmin is a snap-LOL!). I am currently reading 3 different books on PHP, which also discuss use of MySQL as the back end: Essential PHP (Julie Meloni), Beginning PHP (Wrox), and Essential PHP for Web Professionals (Christopher Cosentino). I also bought a book appropriately titled MySQL by Paul DuBois as additional reference for the back end. Dont forget the web: There are also tutorials on the web that may help also. Steph _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- 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] __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- 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 and an SQL query
And even without the subquery, the "like" keyword expects a wildcard character or two, for example: LIKE '$month%' " mysql doesn't support sub-queries unfortunately =( At 10:22 PM 3/8/01 -0500, Michael Gerholdt wrote: Hi, folks, Can someone insight me regarding this? I have a datetime field in mySQL (-mm-dd hh:mm:ss) called event_time I want to pull records hitting against this field with the idea: where the abbreviated month from this field LIKE '$month' and here's the SQL string I've been playing with. It works when I comment out the line that tries to do the above with a subquery. $strSQL = "SELECT DATE_FORMAT(event_time, '%M %e %Y, %l:%i %p'), bandname, image "; $strSQL .= "FROM doings, styles "; $strSQL .= "WHERE style = musicstyle "; $strSQL .= "AND bandname LIKE '$artist' "; $strSQL .= "AND style LIKE '$style' "; $strSQL .= "AND (SELECT DATE_FORMAT(event_time, '%b') FROM doings) LIKE ; $strSQL .= "ORDER BY event_time"; echo "$strSQLBR"; $month will be carrying the three-character short version of the alpha month name. -- CC -- 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]