[PHP-DB] RESEND - php class to C struct interface possible?
Hi all, Thought I would try sending this again - didn't get a reply last time - guess I'll give up if this attempt doesn't get a reply . . I've just subscribed and haven't even got any mail from the list yet so I hope this isn't a dumb question . . The php xBase interface is very basic so: We have an existing (Linux RH6.2) system that has some conventional dumb terminal C programs that have access to a set of CodeBase (xBase) tables through a set of functions that I have written (eg putDBFcchq, getDBFmclm, topDBFest, etc). The applications pass the address of a conventional C struct and the functions do their job talking to the tables and pass back data in the struct. The question is . . can I make use of these functions somehow from my html/php setup? eg Could I produce a little C program that would accept input of a class address from php somehow and then use the appropriate C function to talk to the tables and then pass data back to the php class? Any other way of doing what I want? Thanks, Phil. - Philip Rhoades Pricom Pty Limited (ACN 003 252 275) GPO Box 3411 Sydney NSW 2001 Australia Mobile: +61:0411-185-652 Fax: +61:2:8923-5363 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] db2 with php
Well, if it says that it's looking for it in /etc/httpd/modules then it's obviously not looking in /home/db2inst1/sqllib/lib, eh? Try a symlink... "ln -s /home/db2inst1/sqllib/lib/libdb2.so.1 /etc/httpd/modules/libphp4.so/libdb2.so.1" Or copy the library. Or I think you can add a line into /etc/ld.so.conf too. -Szii At 11:08 PM 2/4/2001 -0500, Chris Book wrote: >Hello, > >I've installed db2 and created the default instance at /home/db2inst1/. >PHP is compiled with the --with-ibm-db2 option, however when I try to start >apache I get the message: "Cannot load /etc/httpd/modules/libphp4.so into >server: libdb2.so.1: cannot open shared object file: No such file or >directory" when I try to load the php4 module. libdb2.so.1 exists in >/home/db2inst1/sqllib/lib/ so I'm not sure why php can't find it. Can >anyone help me with this? > >Thanks, >Chris Book >[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] Remote Oracle Connection
Am I blind? Or is there no support with the regular oracle functions to connect to a database that is hosted on another machine? The manual has this: $conn = Ora_Logon(username, password); but I don't see anywhere to put the host string. - Doug Schasteen
RE: [PHP-DB] & [PHP] .htpasswd?
Hi, you might want to take a look at this one: http://www.thewebmasters.net/php/Htpasswd.phtml Works in both php3 and php4. Give you functions for adding/deleting/listing/renaming users + much more, in standard .htpaccess password files. I use it myself on several sites, it works great. - t.a.madland - --- original message -- From: Cody Caughlan [mailto:[EMAIL PROTECTED]] Sent: 5. februar 2001 04:53 To: Victor Foitzik; php-db Subject: Re: [PHP-DB] .htpasswd? You could also run something like: system("htpasswd -b passwordilf $user $password"),,,basically get the shell to run a the htpasswd program supplied by apache. you might have to play around with the permissions to do this, so the webserver can execute the htpasswd binary. /cody caughlan Victor Foitzik wrote: > James Smith wrote: > > >Is there a way that when a user signs up for a > >user/pass on a site, to automatically update the > >.htpasswd on the site? Right now I'm running a Win2k > >Pro, with Apache installed and MySQL/PHP. > > > >Thanks, > > > >James > > The quite simpliest method is to put appropriate directives in a .htaccess > file in appropriate (e.g. to be protected) directories like this: > > AuthName "Restricted Area" > AuthUserFile /www/users/users > AuthGroupFile /www/users/groups > AuthType Basic > Require registeredusers > > Then all you have to do is to regenerate the user and the group file > according to your needs. > > Another way to do this directly with MySQL is to use the apache auth_mysql > module which allows you to store authentication data in a MySQL DB. See > http://mysql.com/downloads/contrib.html > and > http://httpd.apache.org/docs/misc/FAQ-G.html > for more info. > > HTH > Victor > > -- > 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] db2 with php
Chris, Looks like libphp4.so need sto know where libdb2.so.1 is. I would look at two things: if db2 libraries are not in the standard location then you need to specify the location in --with-ibm-db2=/home/ (this is a guess). or look at ldconfig - you will probably need to specify the db2 library locations in /etc/ld.so.conf and run ldconfig so the libraries can be found. Hope this helps, Wayne On Mon, 5 Feb 2001 15:08, Chris Book wrote: > Hello, > > I've installed db2 and created the default instance at /home/db2inst1/. > PHP is compiled with the --with-ibm-db2 option, however when I try to start > apache I get the message: "Cannot load /etc/httpd/modules/libphp4.so into > server: libdb2.so.1: cannot open shared object file: No such file or > directory" when I try to load the php4 module. libdb2.so.1 exists in > /home/db2inst1/sqllib/lib/ so I'm not sure why php can't find it. Can > anyone help me with this? > > Thanks, > Chris Book > [EMAIL PROTECTED] -- Wayne Bastow - DBA - Central Coast Health Phone: 61 2 43203231 Email: wbastowATccahsDOThealthDOTnswDOTgovDOTau Linux, the choice of a GNU generation Kernel 2.2.16-22 on a i686 Running Windows on a Pentium is like having a brand new Porsche but only be able to drive backwards with the handbrake on. (Unknown source) -- 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] db2 with php
Hello, I've installed db2 and created the default instance at /home/db2inst1/. PHP is compiled with the --with-ibm-db2 option, however when I try to start apache I get the message: "Cannot load /etc/httpd/modules/libphp4.so into server: libdb2.so.1: cannot open shared object file: No such file or directory" when I try to load the php4 module. libdb2.so.1 exists in /home/db2inst1/sqllib/lib/ so I'm not sure why php can't find it. Can anyone help me with this? Thanks, Chris Book [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] .htpasswd?
You could also run something like: system("htpasswd -b passwordilf $user $password"),,,basically get the shell to run a the htpasswd program supplied by apache. you might have to play around with the permissions to do this, so the webserver can execute the htpasswd binary. /cody caughlan Victor Foitzik wrote: > James Smith wrote: > > >Is there a way that when a user signs up for a > >user/pass on a site, to automatically update the > >.htpasswd on the site? Right now I'm running a Win2k > >Pro, with Apache installed and MySQL/PHP. > > > >Thanks, > > > >James > > The quite simpliest method is to put appropriate directives in a .htaccess > file in appropriate (e.g. to be protected) directories like this: > > AuthName "Restricted Area" > AuthUserFile /www/users/users > AuthGroupFile /www/users/groups > AuthType Basic > Require registeredusers > > Then all you have to do is to regenerate the user and the group file > according to your needs. > > Another way to do this directly with MySQL is to use the apache auth_mysql > module which allows you to store authentication data in a MySQL DB. See > http://mysql.com/downloads/contrib.html > and > http://httpd.apache.org/docs/misc/FAQ-G.html > for more info. > > HTH > Victor > > -- > 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] bcmath and rpm
Suhardi, Download the source and configure and make it with the appropriate directives. Wayne On Mon, 5 Feb 2001 14:18, Suhardi Hamid wrote: > Hello, > I am a newbie. I downloaded a new php 4.0.4pl1 rpm and installed it in > my linux box Red Hat version 7.0 which also has a mysql server inside. > The problem is whenever it comes to calculations using bcmath functions, > PHP returns fatal error. I realized that the rpm version of php is not > compiled with --enable-bcmath argument when I checked at phpinfo(). How > can I enable this library? I already checked on the previous postings > but couldnt find the answer. Any help is highly appreciated. > > -suhardi- -- 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] bcmath and rpm
Hello, I am a newbie. I downloaded a new php 4.0.4pl1 rpm and installed it in my linux box Red Hat version 7.0 which also has a mysql server inside. The problem is whenever it comes to calculations using bcmath functions, PHP returns fatal error. I realized that the rpm version of php is not compiled with --enable-bcmath argument when I checked at phpinfo(). How can I enable this library? I already checked on the previous postings but couldnt find the answer. Any help is highly appreciated. -suhardi- -- 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] newbie question
Hi Lisa, >Can search engines index any HTML pages that have .php as its extension (any >.php pages without a '?' or '&' in the URL) ? For example: >http://www.blablabla.com/blabla.php > >Thanks, >Lisa E yes they can, but my experience is, that most search engine robots do _not_ index pages ending in .php and .php3 due to their dynamic nature (please correct me or give me a hint how to change this). We had to change the extensions to .html to avoid being not indexed by search engines. Hope this helps Victor -- 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: AW: [PHP-DB] Oracle Persistant Connections
Hi everybody, We recently had (and have) similar problems running PHP4/Apache with 10 FreeBSD Clients and a SunE450 with Oracle 8.1.6. The machine is quite powerful (4 procs, 4 Gigs RAM). Anyway, we had to limit the number of simultaneous dedicated connections after our server was blown up with open connections, the apaches haven't closed (well, about 4700 oracle processes, not so funny). The main problem is that Oracle spawns a process for _each_ connection opened to the DB. The DB runs in dedicated mode, PHP had several unreproducable errors running the DB in Shared or MTS mode. If anyone has a hint what the hell is going wrong, please let me know ... >Yes, same question. The only thing i know about, is that, if you are running >php not ass an module, your connection will die right ever script executing >therefore making OCIPLogon = OCILogon. > >If run as module the connection will last till your server thread is >regenerated. Therefore it can have a very dark side effect if the >connections are not reliable reused: imagine 250 Apache Spawns with each >hundreds of OCI-COnnections still open ... >be carefull! > >And this is exactly my problem. I can not try tghis since the machine is >running heavy traffic unless i know at leasst the theory > >Another Idea of reduicing Logon overhead is to run the server in MTS - Mode >which does not cause the Oracle Server to start an dedicated ServerProcess >for every Logon/Session. > >Well, suggestions please ;-) > >mk I don't know exactly _what_ your script is doing, anyway running PHP as CGI will be quite slow, as once opened and used multiple times (e.g. persistent) connections are not available. The way, persistent connection work is quite simple: the root Apache process with the root PHP instance holds a pool of connection resources. Now if you run OCIPLogon, PHP looks for opened and unassigned connections first. If no such resource is present, it simply opens a new connection to the database and adds it to the resource pool. After a script has finished, the free, but opened connection is returned to the pool. This is what is called persistance. By nature, this feature is not available in CGI PHP, since the CGI instance is the root instance and all connections are definitely closed upon termination. Maybe a solution would be a PHP CGI-Script running _permanently_ performing periodically select/insert's ? And, this sounds very funny, another way is to run the insert/select part in Apache, returning data to the calling application via HTTP. This _might_ still be faster than calling PHP as a CGI hundred's or thousands of times ... Check it out, and hope this helps. Victor >-Ursprüngliche Nachricht- >Von: Serge Paquin [mailto:[EMAIL PROTECTED]] > >I am using Oracle8i and want to make a little php script that will be run a >huge amount of times (i hope ). PHP has the OCIPLogon for persistent >connections and am wondering the details of how it works. > >I want the php script to run a simple insert then select statement and would >like to avoid a huge logon penalty that comes with creating a new session >to oracle since the life of the program is very short and the frequency >very very high (again I hope). -- 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] .htpasswd?
James Smith wrote: >Is there a way that when a user signs up for a >user/pass on a site, to automatically update the >.htpasswd on the site? Right now I'm running a Win2k >Pro, with Apache installed and MySQL/PHP. > >Thanks, > >James The quite simpliest method is to put appropriate directives in a .htaccess file in appropriate (e.g. to be protected) directories like this: AuthName "Restricted Area" AuthUserFile /www/users/users AuthGroupFile /www/users/groups AuthType Basic Require registeredusers Then all you have to do is to regenerate the user and the group file according to your needs. Another way to do this directly with MySQL is to use the apache auth_mysql module which allows you to store authentication data in a MySQL DB. See http://mysql.com/downloads/contrib.html and http://httpd.apache.org/docs/misc/FAQ-G.html for more info. HTH Victor -- 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] Connection closing problem!
Drew, It is a good idea to explicitly close the connection and release the connection handle on the server side. If Apache PHP threads do not exit normally the database session can remain open. This leaves a zombie connection on the database server. What is your connection/close logic and what driver are you using? Best regards, Andrew --- Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness Infrastructure Technology http://www.openlinksw.com On 2/4/01 8:26 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Hi, > Does anyone know of or have a problem that means that the > HTML server will not receive the message back from the MySQL > server to say close the connection. > The two servers are on two seperate machines. > The html server is Apache using the PHP scripting language. > The error messages I am getting, not so much error messages but > messages, when I do a netstat on the html machine state that alot > of the sql connections are time_wait or close_wait. This should > cause no problem I here you say but when the majority of the html > server connections are on time_wait or close_wait then the site > starts to slow right down. And eventually cause database server > busy errors for users. On the SQL server the netstat results appear > to be fine with the majority of them being Established. Can any > shed some light on this problem or even tell me of a way to fix it. If > any questions about the problem need to be asked I will try and > answer them. Thanks in advance. > > Drew > > Andrew Toussaint > Richardson-Shaw Pty Ltd > [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] Connection closing problem!
Hi, Does anyone know of or have a problem that means that the HTML server will not receive the message back from the MySQL server to say close the connection. The two servers are on two seperate machines. The html server is Apache using the PHP scripting language. The error messages I am getting, not so much error messages but messages, when I do a netstat on the html machine state that alot of the sql connections are time_wait or close_wait. This should cause no problem I here you say but when the majority of the html server connections are on time_wait or close_wait then the site starts to slow right down. And eventually cause database server busy errors for users. On the SQL server the netstat results appear to be fine with the majority of them being Established. Can any shed some light on this problem or even tell me of a way to fix it. If any questions about the problem need to be asked I will try and answer them. Thanks in advance. Drew Andrew Toussaint Richardson-Shaw Pty Ltd [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] How to make $1,000,000 by selling to newcomers on the net
Dear [EMAIL PROTECTED], {Thank you - you have been automatically removed from all future mailings.} Every month over 1,000,000 new commerce web-sites join the internet. Newcomers to the Net who need your help. The question is, how do you trace them, and sell them your Internet Program? In fact, there is a place ... a main gate... a "newbie" lounge where most newcomers gather, to establish a web-based home business. I can show you where they are! None of the Marketing Gurus can tell you where to reach these people, I'll be glad to show how you can. Send an email with "booklet" in the subject field to [EMAIL PROTECTED] and I will send you a 30 page FREE booklet that will explain most of the the details. I'm looking forward to hearing from you soon. Best Regards Chris Moore {Thank you - You have been automatically removed from all future mailings.} -- 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] Oracle TNS problems with PHP4?
Hi Mark, I run Oracle 8i with apache and PHP 4 on about 6 different machines , all connect to a remote DB and i have no problems @ all. Regards Steve Farmer At 8:29 AM -0600 2/2/01, Mark Farver wrote: >I am running Oracle 8.0.5 Net8 drivers on a Win95 system using Apache >and PHP4.04pl1. I'm getting consistent TNS No service errors from PHP >using all three methods of accessing Oracle (oracle,oci,odbc). ODBC works >fine in other apps, and the SQLPlus and tnsping work fine (even when >called from a passthru(), so its not environment related). I've noticed a >large number of bug reports on this.. but no answers (other than modifing >the ORACLE_SID, and ORACLE_HOME environment vars, and that only works >if the DB is local). > >I'm trying to nail down how widespread this problem is... > >How many of you have Oracle working with PHP4? What version of the Oracle >drivers? Are you accessing a local db or a remote one? Did you have to >tweak any settings to make it work? Windows or Unix? > >Thanks >Mark > > >-- >"The greatest dangers to liberty lurk in insidious enroachment by mean of >zeal, well-meaning but without understanding." >-- Justice Louis O. Brandeis, Olmstead vs. United States > > >-- >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] -- --- "Minds are like parachutes, they work best when open" Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- 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] No security on mySql database - help!
Thanks for the tip - I'll give it a read and see if it'll work for me. I need to get a handle on sessions & cookies anyway, maybe this is a good time. I don't have any php books, good or otherwise. I've been using the documentation at www.php.net and scanning the list archives to feel my way around. Probably not the best approach. You could probably sum up my coding style with "why write 1,000 lines of code when 5,000 will do?" Still, it gets the job done, I guess. I'm using O'Reilly's "MySQL & mSQL" for a MySQL reference and it's a good command reference, but for learning code I find the list archives to be a little more instructive. Seeing how other people are doing the stuff I'm trying to do is a little more "real world". olinux wrote: > You could set up a PHP based login, and manage authorization users with > cookies. I am one step behind you as I have not yet finished my > application > pages, but I think that this offers a fair security level. Php Fast & > Easy > Web Development by Julie C. Meloni covers this and is a great starting > book, > http://www.amazon.com/exec/obidos/ASIN/076153055X/qid%3D981318818/102-57 > 7415 > 8-3647359 > > basically it works like this: > the user goes to the login screen, when they submit the > username/password, > the PHP script checks for a row in the db where the two are present. If > there are none then it is not a valid combo. The cookie and session make > it > possible to allow access untill the session ends [when the browser > closes, > though it could be longer I think] > > She also has a web site that includes all of the code from the book, as > well > as some tutorials. www.thickbook.com - chapters 15-17 deal with > authorization, cookies and sessions. and the last chapters 20-22 all use > sessions in the examples. > > Have any good books, URLS's that you read to get started? I am looking > for a > good mySQL book, I haven't heard that there are very many "good" PHP > books > out. > > later, > olinux > > -Original Message- > From: Chuck Mayo [mailto:[EMAIL PROTECTED]] > Sent: Sunday, February 04, 2001 7:47 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] No security on mySql database - help! > > After spending the last two weeks feverishly learning and coding php & > mySql, I'm ready to go live and have discovered that my Hostpro Virtual > Server (Used to be Vservers? never mind...) "doesn't support > password-protecting individual databases". I thought it strange that I > didn't need any user/pass pairs to access the db during development, but > figured I'd sort that out later. What a bonehead, eh? Now it's "later", > and I don't seem to have a way to control users or access levels. Can > anyone suggest a workaround besides just dropping my pages into an > .htaccess -protected directory? > > -- > 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 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]
Re: [PHP-DB] arrays
see www.php.net/odbc you want to use odbc_field_name() and odbc_num_fields() Siggy - Original Message - From: "Alarion" <[EMAIL PROTECTED]> To: "'phobo'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 11:46 AM Subject: RE: [PHP-DB] arrays > Right, but what I am trying to figure out, is how to get the "key" names for > the arrays. > > for example, if I have a users table: > users > - > id > name > password > > and I want to select * from users and load ALL the data into an array, for > the use in easily moving back and forth in the data set, how would I load > it? > > something like: > $Colcount = odbc_fetch_into($Result, $RowNum, $datarow); > $dataset[$RowNum] = $datarow file://dataset would be my master array that houses > all rows/data > > ? > > Sean > > -Original Message- > From: phobo [mailto:[EMAIL PROTECTED]] > Sent: Sunday, February 04, 2001 5:20 PM > To: Alarion > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] arrays > > > Like this: > > $blah = "hello"; > $miaow[$blah][5] = 3.14; > > ( is the same as doing $miaow["hello"][5] = 3.14; ) > > - Siggy > > - Original Message - > From: "Alarion" <[EMAIL PROTECTED]> > To: "'PHP-DB'" <[EMAIL PROTECTED]> > Sent: Monday, February 05, 2001 10:06 AM > Subject: [PHP-DB] arrays > > > > Hello, > > Well, I haven't used arrays in PHP too much and am wondering how I might > > go about this: > > > > I want to loop through a result set, say with ODBC, and use the > > "fetch_array" function for each row. Now, What I want is a an array of all > > the rows, so I could then access the "Name" column in Row 5 like > > $values[NAME][5]. > > How would I create an array that way? > > > > Any help would be appreciated, thanks > > > > Sean Finkel > > > > > > -- > > 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] arrays
Right, but what I am trying to figure out, is how to get the "key" names for the arrays. for example, if I have a users table: users - id name password and I want to select * from users and load ALL the data into an array, for the use in easily moving back and forth in the data set, how would I load it? something like: $Colcount = odbc_fetch_into($Result, $RowNum, $datarow); $dataset[$RowNum] = $datarow //dataset would be my master array that houses all rows/data ? Sean -Original Message- From: phobo [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 04, 2001 5:20 PM To: Alarion Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] arrays Like this: $blah = "hello"; $miaow[$blah][5] = 3.14; ( is the same as doing $miaow["hello"][5] = 3.14; ) - Siggy - Original Message - From: "Alarion" <[EMAIL PROTECTED]> To: "'PHP-DB'" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 10:06 AM Subject: [PHP-DB] arrays > Hello, > Well, I haven't used arrays in PHP too much and am wondering how I might > go about this: > > I want to loop through a result set, say with ODBC, and use the > "fetch_array" function for each row. Now, What I want is a an array of all > the rows, so I could then access the "Name" column in Row 5 like > $values[NAME][5]. > How would I create an array that way? > > Any help would be appreciated, thanks > > Sean Finkel > > > -- > 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] Migrating MySQL Table Data
In article <000401c08e92$84cf2030$0100a8c0@phobo>, phobo <[EMAIL PROTECTED]> writes >I am in the process of improving a database scheme considerably in MySQL, by >breaking tables into smaller tables and so one. I am wondering if there is a >simple SQL statement to take ALL ROWS of fields 'f1', 'f2', 'f3', and copy >them to the another table Then I can remove the fields in the original >table. Suggest you get yourself a copy of PHPMyAdmin. One of the dozens of brilliant features in it is the ability to generate from a table (or a complete database) all the SQL necessary to recreate the table from scratch (CREATE TABLE ... INSERT ...). John -- 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] arrays
Like this: $blah = "hello"; $miaow[$blah][5] = 3.14; ( is the same as doing $miaow["hello"][5] = 3.14; ) - Siggy - Original Message - From: "Alarion" <[EMAIL PROTECTED]> To: "'PHP-DB'" <[EMAIL PROTECTED]> Sent: Monday, February 05, 2001 10:06 AM Subject: [PHP-DB] arrays > Hello, > Well, I haven't used arrays in PHP too much and am wondering how I might > go about this: > > I want to loop through a result set, say with ODBC, and use the > "fetch_array" function for each row. Now, What I want is a an array of all > the rows, so I could then access the "Name" column in Row 5 like > $values[NAME][5]. > How would I create an array that way? > > Any help would be appreciated, thanks > > Sean Finkel > > > -- > 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] arrays
Hello, Well, I haven't used arrays in PHP too much and am wondering how I might go about this: I want to loop through a result set, say with ODBC, and use the "fetch_array" function for each row. Now, What I want is a an array of all the rows, so I could then access the "Name" column in Row 5 like $values[NAME][5]. How would I create an array that way? Any help would be appreciated, thanks Sean Finkel -- 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] Connectivity to AS/400
There's been a lot of talk about this recently. Check the archives for the last 2 months, and PHPBuilder.com Last I heard, you needed DRDA(DB2 Connect) installed, as well as the runtime client. Also on the client - DB2 Application Development package. Use this to compile PHP --with-ibm-db2=. Make sure you run the CATALOG commands on the client so that it can find the AS400 database. 'Luck! -Szii At 10:41 AM 2/4/2001 -0800, Pete Lancashire wrote: >I'm going to be trying to connect to the native DB2 database in a AS/400 >So far thats all I know about the IBM side. > >Can someone give me a short update on what options I have ? > >TIA !!! > >-pete > >-- >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] Connectivity to AS/400
> I'm going to be trying to connect to the native DB2 database in a AS/400 > So far thats all I know about the IBM side. > > Can someone give me a short update on what options I have ? - JDBC - exec an external program. - unixODBC ...etc. - PHP with native ibm db2 support I have successfully connected built a front end application to a AS/400 using the 3rd option. So can help there. marios moutzouris -- 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] Connectivity to AS/400
I'm going to be trying to connect to the native DB2 database in a AS/400 So far thats all I know about the IBM side. Can someone give me a short update on what options I have ? TIA !!! -pete -- 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] db paging with MS Sql
Has anyone seen a good lession or code example on paging records from MS Sql 7? Say I have 300 records and want to break them down to 10 per page using [previous | next ] and a list of page numbers at the bottom. tia -Scott -- 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] logs
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Marc Bragg) wrote: > Does php log its activity anywere? especially for debugging purposes? > Some of my scripts don't show any browser window areas, but also don't > show any results int he browser, i.e., a blank screen, and yet aren't > working. thanx. You can change PHP's logging behavior in the php.ini file. As for results not showing up in the browser, try doing View Source. Remember that there can be a difference between "stuff sent to browser" and "stuff interpreted as HTML and therefore presented in the standard browser window"... -- 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]
[PHP-DB] logs
Does php log its activity anywere? especially for debugging purposes? Some of my scripts don't show any browser window areas, but also don't show any results int he browser, i.e., a blank screen, and yet aren't working. thanx. -- 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] No security on mySql database - help!
Not trying to write an ad here, but Hostpro is a company that rents server space and lets me serve multiple domains out of my space. I went with them to save money, and because they offer tons of goodies, SSI, CGI, PERL, PHP, mySql, shell & CRON access, unlimited email accounts with aliases and virtmaps, it's a pretty fun place. I assume that however they had to implement mySql across their user base didn't allow them to support access control. I've emailed technical support about it, but I'm sure they won't be any help. I'd point you to the database pages so you could see how open it is, but it's registration information for children in a youth baseball league. All a person has to do for full access is to point a web browser to the right url. No passwords are requested of the user and all my db code looks like: $query = "select * from Teams"; $result = mysql("dbname","$query"); Pretty scary... jaskirat singh wrote: > Hey .. its MySQL that will ask for a password .. as far as I can figure > out > you are > doing some thing odd .. > Hostpro is it a web server? > > At 09:46 AM 2/4/01 -0600, you wrote: > >After spending the last two weeks feverishly learning and coding php & > >mySql, I'm ready to go live and have discovered that my Hostpro Virtual > >Server (Used to be Vservers? never mind...) "doesn't support > >password-protecting individual databases". I thought it strange that I > >didn't need any user/pass pairs to access the db during development, > but > >figured I'd sort that out later. What a bonehead, eh? Now it's "later", > >and I don't seem to have a way to control users or access levels. Can > >anyone suggest a workaround besides just dropping my pages into an > >.htaccess -protected directory? > > > > > >-- > >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] Migrating MySQL Table Data
Hi, You can use "insert into newTable(field1,field2,field3) select red,green,blue from oldTable" HTH Jaski At 10:11 PM 2/4/01 +1300, phobo wrote: >I am in the process of improving a database scheme considerably in MySQL, by >breaking tables into smaller tables and so one. I am wondering if there is a >simple SQL statement to take ALL ROWS of fields 'f1', 'f2', 'f3', and copy >them to the another table Then I can remove the fields in the original >table. > >eg something like >INSERT INTO BetterSmallerTable SET (PrimKey,Red,Green,Blue) VALUES (SELECT >PrimKey,Red,Green,Blue FROM BigClumsyTable) ?? > >Thanks, >Siggy > > > >-- >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] Processing using a single PHP file
Yes .. you can do it like this. Have two functions 1)generateForm(); 2)processData(); In the generateForm function use a hidden form field called say "action" with a value say "process" Then put a code like this. if ($action == "process") { processData(); } else { generateForm(); } HTH Jaski At 12:08 PM 2/4/01 +, Sridhar Ranganathan wrote: >Hi Netlanders > >Traditionally, we have two files in our apps. A HTML page that has a form >and a PHP file that processes the form info. I have a web-based front end >that is used to added data to a table. Can I do this with one PHP file >alone? > >Regards >Sridhar Ranganathan >_ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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] RE: parsing error
Try this: Error " . mysql_errno() . ": " . mysql_error() . ""; elseif (mysql_num_rows($result) == 0) echo "Query executed successfully!"; ?> Best regards, Joseph H. http://BlueChillies.com Your Freeware and Shareware Download Destination >Another strange error, parsing: > >if ($result == 0); >echo ("Error " . mysql_errno() . ": " . mysql_error() . ""); >elseif (mysql_num_rows($result) == 0); >echo("Query executed successfully!"); >else: >?> > >on the 'elseif' statement. > >suggestions? is there a parse checker, that identifies errors? > -- 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] No security on mySql database - help!
After spending the last two weeks feverishly learning and coding php & mySql, I'm ready to go live and have discovered that my Hostpro Virtual Server (Used to be Vservers? never mind...) "doesn't support password-protecting individual databases". I thought it strange that I didn't need any user/pass pairs to access the db during development, but figured I'd sort that out later. What a bonehead, eh? Now it's "later", and I don't seem to have a way to control users or access levels. Can anyone suggest a workaround besides just dropping my pages into an .htaccess -protected directory? -- 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] Migrating MySQL Table Data
The CREATE TABLE .. FROM ... SQL will do what you require, but I don't think this is included in MySQL (one to check)...however if performance is becoming an issue, ,then you may want to consider migrating to a different DBMS (mySQL is not so good at handling large record sets, and has a much cut-down set of SQL sytanx). Sticking with mysql however, if it was a once off move that needed to take place (which is what it sounds like) then it wouldn't be hard to write a simple agent .. somethi like 1. select all records in the original table 2. Loop through all the records (rows) 2.1. extract the fields from the currently selected row 2.2. INSERT this into your new table 2.3 go onto the next row 3. Once all are done, drop the unwanted columns from your old table Inelegant ,yes, but it will work! If you want more help, contact me OL Tom On Sun, 4 Feb 2001, phobo wrote: > I am in the process of improving a database scheme considerably in MySQL, by > breaking tables into smaller tables and so one. I am wondering if there is a > simple SQL statement to take ALL ROWS of fields 'f1', 'f2', 'f3', and copy > them to the another table Then I can remove the fields in the original > table. > > eg something like > INSERT INTO BetterSmallerTable SET (PrimKey,Red,Green,Blue) VALUES (SELECT > PrimKey,Red,Green,Blue FROM BigClumsyTable) ?? > > Thanks, > Siggy > > > > -- > 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] PHP4 & MySql
Hi.. i'm using MySql version 3.22.32 and I installed the Apache Compile Kit containing the following: Apache 1.3.14 php3 3.0.16 php4 4.0.3pl1 I have the following problem while using PHP4.. Wheneven I write to the database, I see the following warning on the resultant page on the browser : "Warning: MySQL: Unable to save result set in /home/httpd/php/tests/datatest.php on line 19 ". While executing the same code over PHP3, it executes very smoothly! I need to know where I go wrong! Please help me on this matter.. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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] Inserting/Selecting BLOB in MSSQL 7.0
I tried to do this using mssql7 php extension, and it didnt work. However Unified ODBC functions worked well.. whats the problem? Extension, Server, or may be i'm doing wrong queries? for inserting image: $result = mssql_query("insert into image_table values ($id, '$image_data')"); - not works at all, claiming i have an unclosed quotation doubling single quotes didnt help as well for selecting image: $result = mssql_query("select image from image_table where id = $id"); - select works well but then... $data = mssql_fetch_row($result); i get an access violation in php.exe here :( p.s. yes, yes.. i know that storing images in database is slow, and stuff, but that was just an example p.p.s. php4.0.4pl1, OS - NT server 4.0 sp6, php runs as cgi (anybody made it work as apache module?) -- Best regards, Giaour mailto:[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] parsing error // functions
Thanx, will try. Curious: using the Professional PHP Programming book, and got the other code which didn't work. How is one to know how to move these things around? Just practice and error? Can you help with this also, can't get the Generate . . . functions to respond, such as: test"); } ?> is there part missing? or, is this some run-time compile issue, something that should have been installed when php was installed? -- 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] Processing using a single PHP file
Hi Netlanders Traditionally, we have two files in our apps. A HTML page that has a form and a PHP file that processes the form info. I have a web-based front end that is used to added data to a table. Can I do this with one PHP file alone? Regards Sridhar Ranganathan _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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] Migrating MySQL Table Data
I am in the process of improving a database scheme considerably in MySQL, by breaking tables into smaller tables and so one. I am wondering if there is a simple SQL statement to take ALL ROWS of fields 'f1', 'f2', 'f3', and copy them to the another table Then I can remove the fields in the original table. eg something like INSERT INTO BetterSmallerTable SET (PrimKey,Red,Green,Blue) VALUES (SELECT PrimKey,Red,Green,Blue FROM BigClumsyTable) ?? Thanks, Siggy -- 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]