Re: [PHP-DB] Need Help on subtract Time
Kelvin: If you're using MySQL - go check out: http://www.mysql.com/doc/D/a/Date_and_time_functions.html It has some great little MySQL data and time functions. I have personally found it invaluable. Good luck! :-) Russ On Wed, 14 Nov 2001 15:49:03 -0500 kelvin [EMAIL PROTECTED] wrote: Hi everyone, I have a table with those field. ---Username, Uid, and Time. Ok, I tried to select data which their time is 2 min less from the current time or so. Could anyone help me out, How to do it? This is what I got, but doesn't work. select * from tablename where time date(H:i:s,(time()-720)); Please help!!! Thanks. Kelvin -- 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] #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam www.theruss.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] Why use MySQL with PHP
Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- 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] Why use MySQL with PHP
Personally I prefer Sybase on Linux, version 11_0_3 is free for production use and easy to install. Sybase 11_0_3 is still a very powerful DBMS although a bit dated by now, Sybase just released version 12.5. Why everyone is using MySQL I don't know, could it be that mod_php is compiled with MySQL support? MySQL is free and there is a lot of support from the community since so many are using it. How would one go about making a mod_php with Sybase support also? Regards //Richard -Original Message- From: søren eriksen [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 9:34 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Why use MySQL with PHP Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- 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] Why use MySQL with PHP
My reasons: 1) Heard of Oracle, didnt know it was a database program 2) Never heard of PostgreSQL 3) MySQL is the most talked about, from what I've seen, so there's plenty of people to get help from 4) It's free. 5) It runs in Windows 5) NASA uses it, or so their site says 6) It works! So I've no need to switch to anything else 7) Most PHP webhosting services offer only MySQL. 8) Gotta love that lil dolphin! søren eriksen wrote: Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- 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] -- From PHPGalaxy.com, earn up to $10 per order selling our PHP Scripts and Software on your Site. http://www.phpgalaxy.com/aff/ Also, get a fast free POP3 email account, you @php.la at http://www.phpgalaxy.com/search/ -- 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] Why use MySQL with PHP
The main reasons are possibly later on its drawbacks - basically, its main attraction is the ease of use, as it's so simple! MySQL and PHP fit together so well and for people just learning scripting with databases, there's not much that's as easy to pick up quickly and produce basic database driven websites with. Obviously due to this, it's actually got no massive depth in terms of stored procedures (you can't), and won't be as effective or useful for running massive, complex sites that attract millions of visitors (something like SQL server would probably be better) but for most websites, it's free, it's easy, and it does the job! -Original Message- From: søren eriksen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 20:34 To: [EMAIL PROTECTED] Subject: [PHP-DB] Why use MySQL with PHP Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 -- 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] Why use MySQL with PHP
*laugh* I was reading this and thought to reply simply for the fact Søren is fellow danish guy, but refrained momentarily till I got this one... There are many alternatives to mySQL and much more commercial too... Try get your hotshot boss to belive in mySQL rather from business buzzword Oracle (by know, I think 95% know Oracle is the major db engine - especially on the ridiculus pricetag it comes with), but MSSQL, Sybase, PostgreSQL, Informix, Paradox ect ect ect. Okay, I am a bit colored by my short but exiting experience over 4 years pro. Since the zend guys came into the picture with the rewriting of php engine they worked quite close with monty and the boyz over at mySQL... The integration between these two systems is one of the closest and seemlessly I have seen to date, with experience from IPerForm/MSSQL6.5(later 7.0) - if you dont know IPerForm, be happy about it and never think of it - JSP/Servlet/Oracle and latest PHP/mySQL. It is unique, fast and never a problem needless what platform it runs on (though I advice noone to do Windowshosting with PHP/mySQL *ouch* can already feel I'm being dragged outside and beaten upon - Windows if for testing and development only, I always run on FreeBSD or Linux servers and it ruuuns smth) Hmm, about the Nasa part, I never conducted business quite like the guys at Nasa so I presume my needs is quite different - prefer to find the optimal solution... Heck, there are alot of bigshot sites out there running ASP *www* does that mean it is the optimal solution ? Wasn't it Ratschiller / Gerken (sorry if I got the names wrong) who had an entire chapter about the PHP / mySQL tieup - well, check their book out, I dont agree with it in full but it has its great parts... :) Enough storytelling, goodluck on your assignment / Lars PS. Søren, skriv hvis der er noget... Jeg har arbejdet de sidste par år med PHP / mySQL for firmaer som TDC KabelTV og lign. -Original Message- From: PHPGalaxy.com [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 20:38 To: søren eriksen Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Why use MySQL with PHP My reasons: 1) Heard of Oracle, didnt know it was a database program 2) Never heard of PostgreSQL 3) MySQL is the most talked about, from what I've seen, so there's plenty of people to get help from 4) It's free. 5) It runs in Windows 5) NASA uses it, or so their site says 6) It works! So I've no need to switch to anything else 7) Most PHP webhosting services offer only MySQL. 8) Gotta love that lil dolphin! søren eriksen wrote: Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- 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] -- From PHPGalaxy.com, earn up to $10 per order selling our PHP Scripts and Software on your Site. http://www.phpgalaxy.com/aff/ Also, get a fast free POP3 email account, you @php.la at http://www.phpgalaxy.com/search/ -- 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] Why use MySQL with PHP
Sure, the big guys run ASP, but its common knowledge to stay aay from that =) Actually, the reaosn I brought it up is cuz I'm sure they have some pretty big databases, for whatever they use it for, and wellanything that's gonna support a huge DB without crashing is a plus in my book =)I tried to host some php sites on my Win2k computer, and it worked out well..until people actually started visiting the site =) Thus, great for testing, bad for hosting. =) I do use it though to build databases. I have a number of different types of search engine spiders that index sites, and I find it easier to do it here than on my php web host. =) I just realized, I could talk about PHP and MySQL all day...or until my fingers fall off... so I'll end this here =) Lars B. Jensen wrote: *laugh* I was reading this and thought to reply simply for the fact Søren is fellow danish guy, but refrained momentarily till I got this one... There are many alternatives to mySQL and much more commercial too... Try get your hotshot boss to belive in mySQL rather from business buzzword Oracle (by know, I think 95% know Oracle is the major db engine - especially on the ridiculus pricetag it comes with), but MSSQL, Sybase, PostgreSQL, Informix, Paradox ect ect ect. Okay, I am a bit colored by my short but exiting experience over 4 years pro. Since the zend guys came into the picture with the rewriting of php engine they worked quite close with monty and the boyz over at mySQL... The integration between these two systems is one of the closest and seemlessly I have seen to date, with experience from IPerForm/MSSQL6.5(later 7.0) - if you dont know IPerForm, be happy about it and never think of it - JSP/Servlet/Oracle and latest PHP/mySQL. It is unique, fast and never a problem needless what platform it runs on (though I advice noone to do Windowshosting with PHP/mySQL *ouch* can already feel I'm being dragged outside and beaten upon - Windows if for testing and development only, I always run on FreeBSD or Linux servers and it ruuuns smth) Hmm, about the Nasa part, I never conducted business quite like the guys at Nasa so I presume my needs is quite different - prefer to find the optimal solution... Heck, there are alot of bigshot sites out there running ASP *www* does that mean it is the optimal solution ? Wasn't it Ratschiller / Gerken (sorry if I got the names wrong) who had an entire chapter about the PHP / mySQL tieup - well, check their book out, I dont agree with it in full but it has its great parts... :) Enough storytelling, goodluck on your assignment / Lars PS. Søren, skriv hvis der er noget... Jeg har arbejdet de sidste par år med PHP / mySQL for firmaer som TDC KabelTV og lign. -Original Message- From: PHPGalaxy.com [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 20:38 To: søren eriksen Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Why use MySQL with PHP My reasons: 1) Heard of Oracle, didnt know it was a database program 2) Never heard of PostgreSQL 3) MySQL is the most talked about, from what I've seen, so there's plenty of people to get help from 4) It's free. 5) It runs in Windows 5) NASA uses it, or so their site says 6) It works! So I've no need to switch to anything else 7) Most PHP webhosting services offer only MySQL. 8) Gotta love that lil dolphin! søren eriksen wrote: Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- 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] -- From PHPGalaxy.com, earn up to $10 per order selling our PHP Scripts and Software on your Site. http://www.phpgalaxy.com/aff/ Also, get a fast free POP3 email account, you @php.la at http://www.phpgalaxy.com/search/ -- 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] -- From PHPGalaxy.com, earn up to $10 per order selling our PHP Scripts and Software on your Site. http://www.phpgalaxy.com/aff/ Also, get a fast free POP3 email account, you @php.la at http://www.phpgalaxy.com/search/ -- 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
RE: [PHP-DB] Why use MySQL with PHP
Stored procedures is missing in mySQL correct but is scheduled with the exiting launch of the mySQL 4 family. mySQL has it's drawbacks, but main force is it's performance, for certain tasks also with quite large datasets (few million rows) I had mySQL outperform major players as Microsoft SQL Server 7 and Oracle8i. I sadly never had my hands on PostgreSQL yet. Again, it all comes down to make the optimal site for the job, not the hardest technological. To revert a saying, why jump the fence where it is the highest ? (thereby not saying we gotta jump where it is lowest, but where it is appropriate to the task). So, with experience and knowledge from major sites running daily thousands of sessions and millions of pageviews I know mySQL is capable of the trick, and with the mySQL 4 coming out, I for one is awaiting it with anticipation. Especially the stored procedures which totally would eliminate my need for Microsoft SQL Server. / Lars -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 20:45 To: 'søren eriksen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP The main reasons are possibly later on its drawbacks - basically, its main attraction is the ease of use, as it's so simple! MySQL and PHP fit together so well and for people just learning scripting with databases, there's not much that's as easy to pick up quickly and produce basic database driven websites with. Obviously due to this, it's actually got no massive depth in terms of stored procedures (you can't), and won't be as effective or useful for running massive, complex sites that attract millions of visitors (something like SQL server would probably be better) but for most websites, it's free, it's easy, and it does the job! -Original Message- From: søren eriksen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 20:34 To: [EMAIL PROTECTED] Subject: [PHP-DB] Why use MySQL with PHP Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 -- 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] Why use MySQL with PHP
sounds wonderful - do you know when (roughly) it's gonna be released? I thought that one of the reasons it was so fast was that the DB engine wasn't cluttered with procedures? (which is why it's so damn good for not-so-complicated sites)? i'm no expert at all, but won't mySQL 4 therefore be slower? -Original Message- From: Lars B. Jensen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 12:19 To: matt stewart Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP Stored procedures is missing in mySQL correct but is scheduled with the exiting launch of the mySQL 4 family. mySQL has it's drawbacks, but main force is it's performance, for certain tasks also with quite large datasets (few million rows) I had mySQL outperform major players as Microsoft SQL Server 7 and Oracle8i. I sadly never had my hands on PostgreSQL yet. Again, it all comes down to make the optimal site for the job, not the hardest technological. To revert a saying, why jump the fence where it is the highest ? (thereby not saying we gotta jump where it is lowest, but where it is appropriate to the task). So, with experience and knowledge from major sites running daily thousands of sessions and millions of pageviews I know mySQL is capable of the trick, and with the mySQL 4 coming out, I for one is awaiting it with anticipation. Especially the stored procedures which totally would eliminate my need for Microsoft SQL Server. / Lars -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 20:45 To: 'søren eriksen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP The main reasons are possibly later on its drawbacks - basically, its main attraction is the ease of use, as it's so simple! MySQL and PHP fit together so well and for people just learning scripting with databases, there's not much that's as easy to pick up quickly and produce basic database driven websites with. Obviously due to this, it's actually got no massive depth in terms of stored procedures (you can't), and won't be as effective or useful for running massive, complex sites that attract millions of visitors (something like SQL server would probably be better) but for most websites, it's free, it's easy, and it does the job! -Original Message- From: søren eriksen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 20:34 To: [EMAIL PROTECTED] Subject: [PHP-DB] Why use MySQL with PHP Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 -- 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 -- 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] Why use MySQL with PHP
Well, need to hook up on mysql.com to check it out... 4.0 is already out on development, but even I tend to tell my clients I am on the cutting-edge *laugh* yeah, I know - bullshit buzzword - I prefer it to be stable releases before relying even remotely on these. mySQL 4.1 will become VERY exciting with the fulltext indexing (more than a mere OR search), Stored Procedures and even they promise an performance increase... hmm, our buddies at mySQL seem to make alot of promises, lets just hope they are not like politicians and actually will put a product behind the words to back it up. Monty and co. got my confidence, I look forward playing with a new toy. Refs : http://www.mysql.com/products/mysql-4.0/index.html And : http://www.mysql.com/news/article-81.html / Lars -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 21:32 To: 'Lars B. Jensen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP sounds wonderful - do you know when (roughly) it's gonna be released? I thought that one of the reasons it was so fast was that the DB engine wasn't cluttered with procedures? (which is why it's so damn good for not-so-complicated sites)? i'm no expert at all, but won't mySQL 4 therefore be slower? -Original Message- From: Lars B. Jensen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 12:19 To: matt stewart Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP Stored procedures is missing in mySQL correct but is scheduled with the exiting launch of the mySQL 4 family. mySQL has it's drawbacks, but main force is it's performance, for certain tasks also with quite large datasets (few million rows) I had mySQL outperform major players as Microsoft SQL Server 7 and Oracle8i. I sadly never had my hands on PostgreSQL yet. Again, it all comes down to make the optimal site for the job, not the hardest technological. To revert a saying, why jump the fence where it is the highest ? (thereby not saying we gotta jump where it is lowest, but where it is appropriate to the task). So, with experience and knowledge from major sites running daily thousands of sessions and millions of pageviews I know mySQL is capable of the trick, and with the mySQL 4 coming out, I for one is awaiting it with anticipation. Especially the stored procedures which totally would eliminate my need for Microsoft SQL Server. / Lars -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 20:45 To: 'søren eriksen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP The main reasons are possibly later on its drawbacks - basically, its main attraction is the ease of use, as it's so simple! MySQL and PHP fit together so well and for people just learning scripting with databases, there's not much that's as easy to pick up quickly and produce basic database driven websites with. Obviously due to this, it's actually got no massive depth in terms of stored procedures (you can't), and won't be as effective or useful for running massive, complex sites that attract millions of visitors (something like SQL server would probably be better) but for most websites, it's free, it's easy, and it does the job! -Original Message- From: søren eriksen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 20:34 To: [EMAIL PROTECTED] Subject: [PHP-DB] Why use MySQL with PHP Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 -- 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:
[PHP-DB] Converting text fields to integer in queries with ODBC connection to an MS Access file
Hi list, I wonder if anyone can help me out here. I'm pulling some data from an MS Access file using the ODBC driver provided with Windows NT 4.0 server (Option pack, and SP6a applied), and want to limit the result set with a where clause like this one: ... WHERE (PARTNUMBER 37010) AND (PARTNUMBER 5) Now - the problem here is that the PARTNUMBER field is defined as a text field in the access file (even though it holds only numbers), and since I'm not the one maintaining the access base, I can't change that. So I tried converting the field to an INTEGER field using the CONVERT() function in my query. But this function is not supported by the ODBC driver. Does anyone know how I can convert the value of as text field to an integer type field so I can do / clauses in my query? Any help will be greatly appreciated. Brgds, Christian -- 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] Why use MySQL with PHP
I just remembered, the only bad thing I can think of about MySQL... their website locks up Netscape =) I recently installed MySQL4 dev on one of the Win2k computers and it seems to work well...I havent stress-tested it much, or do anything complex with it (I'm still a beginner anyways), but I invite anyone else to try =) 65.7.204.217 - root/no password - the computer nor MySQL gets used for anything else, so go nuts with it! I'm kinda curious anyways to see what people do to/with it. oh yeah, phpmyadmin is on there at http://65.7.204.217:81/sql/ =) Lars B. Jensen wrote: Well, need to hook up on mysql.com to check it out... 4.0 is already out on development, but even I tend to tell my clients I am on the cutting-edge *laugh* yeah, I know - bullshit buzzword - I prefer it to be stable releases before relying even remotely on these. mySQL 4.1 will become VERY exciting with the fulltext indexing (more than a mere OR search), Stored Procedures and even they promise an performance increase... hmm, our buddies at mySQL seem to make alot of promises, lets just hope they are not like politicians and actually will put a product behind the words to back it up. Monty and co. got my confidence, I look forward playing with a new toy. Refs : http://www.mysql.com/products/mysql-4.0/index.html And : http://www.mysql.com/news/article-81.html / Lars -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 21:32 To: 'Lars B. Jensen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP sounds wonderful - do you know when (roughly) it's gonna be released? I thought that one of the reasons it was so fast was that the DB engine wasn't cluttered with procedures? (which is why it's so damn good for not-so-complicated sites)? i'm no expert at all, but won't mySQL 4 therefore be slower? -Original Message- From: Lars B. Jensen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 12:19 To: matt stewart Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP Stored procedures is missing in mySQL correct but is scheduled with the exiting launch of the mySQL 4 family. mySQL has it's drawbacks, but main force is it's performance, for certain tasks also with quite large datasets (few million rows) I had mySQL outperform major players as Microsoft SQL Server 7 and Oracle8i. I sadly never had my hands on PostgreSQL yet. Again, it all comes down to make the optimal site for the job, not the hardest technological. To revert a saying, why jump the fence where it is the highest ? (thereby not saying we gotta jump where it is lowest, but where it is appropriate to the task). So, with experience and knowledge from major sites running daily thousands of sessions and millions of pageviews I know mySQL is capable of the trick, and with the mySQL 4 coming out, I for one is awaiting it with anticipation. Especially the stored procedures which totally would eliminate my need for Microsoft SQL Server. / Lars -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 20:45 To: 'søren eriksen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP The main reasons are possibly later on its drawbacks - basically, its main attraction is the ease of use, as it's so simple! MySQL and PHP fit together so well and for people just learning scripting with databases, there's not much that's as easy to pick up quickly and produce basic database driven websites with. Obviously due to this, it's actually got no massive depth in terms of stored procedures (you can't), and won't be as effective or useful for running massive, complex sites that attract millions of visitors (something like SQL server would probably be better) but for most websites, it's free, it's easy, and it does the job! -Original Message- From: søren eriksen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 20:34 To: [EMAIL PROTECTED] Subject: [PHP-DB] Why use MySQL with PHP Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 /
Re: [PHP-DB] About Berkeley DB2 Databases
Mensaje citado por: Pierre-Alain Joye [EMAIL PROTECTED]: On Wed, 14 Nov 2001 16:56:47 -0400 (VET) Ricardo Núñez [EMAIL PROTECTED] wrote: Mensaje citado por: Pierre-Alain Joye [EMAIL PROTECTED]: I just put '--with-db2'. I suppose it compiled its Berkeley db2 code. Other thing, I use PHP 4.0.6. me too ;) but php not... every others tools on my station recognizes the db,db2 and db3 support, php not. Which lib do you have ? any link ? (or email :) ldconfig -p | grep db :) pa -- 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] Saludos, Ing. Ricardo Núñez Webmaster de la DST Universidad Simón Bolívar E-Mail: [EMAIL PROTECTED] libthread_db.so.1 (libc6) = /lib/libthread_db.so.1 libthread_db.so (libc6) = /usr/lib/libthread_db.so libpwdb.so.0 (libc6) = /lib/libpwdb.so.0 libpwdb.so (libc6) = /lib/libpwdb.so libnss1_db.so.1 (libc6) = /lib/libnss1_db.so.1 libnss1_db.so (libc6) = /usr/lib/libnss1_db.so libnss_db.so.2 (libc6) = /lib/libnss_db.so.2 libnss_db.so.1 (libc6) = /lib/libnss_db.so.1 libnss_db.so (libc6) = /usr/lib/libnss_db.so libndbm.so (libc6) = /usr/lib/libndbm.so libkdb5.so.3 (libc6) = /usr/kerberos/lib/libkdb5.so.3 libkdb5.so (libc6) = /usr/kerberos/lib/libkdb5.so libgdbm.so.2 (libc6) = /usr/lib/libgdbm.so.2 libgdbm.so (libc6) = /usr/lib/libgdbm.so libdb1.so.2 (libc6) = /lib/libdb1.so.2 libdb1.so (libc6) = /usr/lib/libdb1.so libdb_tcl.so (libc6) = /usr/lib/libdb_tcl.so libdb_tcl-3.1.so (libc6) = /usr/lib/libdb_tcl-3.1.so libdb_cxx.so (libc6) = /usr/lib/libdb_cxx.so libdb_cxx-3.1.so (libc6) = /usr/lib/libdb_cxx-3.1.so libdb.so.3 (libc6) = /lib/libdb.so.3 libdb.so.2 (libc6) = /lib/libdb.so.2 libdb.so (libc6) = /usr/lib/libdb.so libdb.so (libc6) = /lib/libdb.so libdb-3.1.so (libc6) = /usr/lib/libdb-3.1.so libdb-3.1.so (libc6) = /lib/libdb-3.1.so -- 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] Converting text fields to integer in queries with ODBC connection to an MS Access file
Some of the databases I work with would support this as 'between' on two text fields that are sortable alphabetically - I'd give that a try. -Lorenzo -Original Message- From: Christian Sandfeld Sent: Thu 11/15/2001 7:55 AM To: '[EMAIL PROTECTED]' Cc: Subject: [PHP-DB] Converting text fields to integer in queries with ODBC connection to an MS Access file Hi list, I wonder if anyone can help me out here. I'm pulling some data from an MS Access file using the ODBC driver provided with Windows NT 4.0 server (Option pack, and SP6a applied), and want to limit the result set with a where clause like this one: ... WHERE (PARTNUMBER 37010) AND (PARTNUMBER 5) Now - the problem here is that the PARTNUMBER field is defined as a text field in the access file (even though it holds only numbers), and since I'm not the one maintaining the access base, I can't change that. So I tried converting the field to an INTEGER field using the CONVERT() function in my query. But this function is not supported by the ODBC driver. Does anyone know how I can convert the value of as text field to an integer type field so I can do / clauses in my query? Any help will be greatly appreciated. Brgds, Christian -- 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] Converting text fields to integer in queries with ODBC connection to an MS Access file
Lorenzo, That was a good suggestion (had forgotten about the between function) but unfortunately it still complains with the following error: Warning: SQL error: [Microsoft][ODBC Microsoft Access 97 Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect in test.php on line 6 What caused this error was this: WHERE PARTNUMBER.PARTNUMBER BETWEEN 37010 AND 5); So, any other suggestions on how I can circumvent this problem? Brgds, Christian -Original Message- From: Gonzalez, Lorenzo [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 14:57 To: Christian Sandfeld; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Converting text fields to integer in queries with ODBC connection to an MS Access file Some of the databases I work with would support this as 'between' on two text fields that are sortable alphabetically - I'd give that a try. -Lorenzo -Original Message- From: Christian Sandfeld Sent: Thu 11/15/2001 7:55 AM To: '[EMAIL PROTECTED]' Cc: Subject: [PHP-DB] Converting text fields to integer in queries with ODBC connection to an MS Access file Hi list, I wonder if anyone can help me out here. I'm pulling some data from an MS Access file using the ODBC driver provided with Windows NT 4.0 server (Option pack, and SP6a applied), and want to limit the result set with a where clause like this one: ... WHERE (PARTNUMBER 37010) AND (PARTNUMBER 5) Now - the problem here is that the PARTNUMBER field is defined as a text field in the access file (even though it holds only numbers), and since I'm not the one maintaining the access base, I can't change that. So I tried converting the field to an INTEGER field using the CONVERT() function in my query. But this function is not supported by the ODBC driver. Does anyone know how I can convert the value of as text field to an integer type field so I can do / clauses in my query? Any help will be greatly appreciated. Brgds, Christian -- 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] Converting text fields to integer in queries with ODBC connection to an MS Access file
Those aren't numbers remember, and need to be in single quotes. Even so, I'll be a bit surprised if this works against Access through ODBC... -Zo -Original Message- From: Christian Sandfeld Sent: Thu 11/15/2001 9:56 AM To: [EMAIL PROTECTED] Cc: Subject: RE: [PHP-DB] Converting text fields to integer in queries with ODBC connection to an MS Access file Lorenzo, That was a good suggestion (had forgotten about the between function) but unfortunately it still complains with the following error: Warning: SQL error: [Microsoft][ODBC Microsoft Access 97 Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect in test.php on line 6 What caused this error was this: WHERE PARTNUMBER.PARTNUMBER BETWEEN 37010 AND 5); So, any other suggestions on how I can circumvent this problem? Brgds, Christian -Original Message- From: Gonzalez, Lorenzo [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 14:57 To: Christian Sandfeld; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Converting text fields to integer in queries with ODBC connection to an MS Access file Some of the databases I work with would support this as 'between' on two text fields that are sortable alphabetically - I'd give that a try. -Lorenzo -Original Message- From: Christian Sandfeld Sent: Thu 11/15/2001 7:55 AM To: '[EMAIL PROTECTED]' Cc: Subject: [PHP-DB] Converting text fields to integer in queries with ODBC connection to an MS Access file Hi list, I wonder if anyone can help me out here. I'm pulling some data from an MS Access file using the ODBC driver provided with Windows NT 4.0 server (Option pack, and SP6a applied), and want to limit the result set with a where clause like this one: ... WHERE (PARTNUMBER 37010) AND (PARTNUMBER 5) Now - the problem here is that the PARTNUMBER field is defined as a text field in the access file (even though it holds only numbers), and since I'm not the one maintaining the access base, I can't change that. So I tried converting the field to an INTEGER field using the CONVERT() function in my query. But this function is not supported by the ODBC driver. Does anyone know how I can convert the value of as text field to an integer type field so I can do / clauses in my query? Any help will be greatly appreciated. Brgds, Christian -- 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] Converting text fields to integer in queries with ODBC connection to an MS Access file
doh! ofcourse... that actually works. Thanks a bunch :) /Christian -Original Message- From: Gonzalez, Lorenzo [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 16:11 To: Christian Sandfeld; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Converting text fields to integer in queries with ODBC connection to an MS Access file Those aren't numbers remember, and need to be in single quotes. Even so, I'll be a bit surprised if this works against Access through ODBC... -Zo -Original Message- From: Christian Sandfeld Sent: Thu 11/15/2001 9:56 AM To: [EMAIL PROTECTED] Cc: Subject: RE: [PHP-DB] Converting text fields to integer in queries with ODBC connection to an MS Access file Lorenzo, That was a good suggestion (had forgotten about the between function) but unfortunately it still complains with the following error: Warning: SQL error: [Microsoft][ODBC Microsoft Access 97 Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect in test.php on line 6 What caused this error was this: WHERE PARTNUMBER.PARTNUMBER BETWEEN 37010 AND 5); So, any other suggestions on how I can circumvent this problem? Brgds, Christian -Original Message- From: Gonzalez, Lorenzo [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 14:57 To: Christian Sandfeld; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Converting text fields to integer in queries with ODBC connection to an MS Access file Some of the databases I work with would support this as 'between' on two text fields that are sortable alphabetically - I'd give that a try. -Lorenzo -Original Message- From: Christian Sandfeld Sent: Thu 11/15/2001 7:55 AM To: '[EMAIL PROTECTED]' Cc: Subject: [PHP-DB] Converting text fields to integer in queries with ODBC connection to an MS Access file Hi list, I wonder if anyone can help me out here. I'm pulling some data from an MS Access file using the ODBC driver provided with Windows NT 4.0 server (Option pack, and SP6a applied), and want to limit the result set with a where clause like this one: ... WHERE (PARTNUMBER 37010) AND (PARTNUMBER 5) Now - the problem here is that the PARTNUMBER field is defined as a text field in the access file (even though it holds only numbers), and since I'm not the one maintaining the access base, I can't change that. So I tried converting the field to an INTEGER field using the CONVERT() function in my query. But this function is not supported by the ODBC driver. Does anyone know how I can convert the value of as text field to an integer type field so I can do / clauses in my query? Any help will be greatly appreciated. Brgds, Christian -- 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/MySQL to M$ Access
Hi, Until we completely migrate an application from M$ Access to PHP/MySQL, I need to figure out a way to temporarily query an Access DB from PHP/MySQL. I am aware of this article on PHP Builder: http://www.phpbuilder.com/columns/timuckun20001207.php3?page=1 which discusses using ODBC Socket Servers, but the article assumes the M$ Access db is on a winblows machine. In my case, the Access DB is on a Linux machine (served thru' Samba - isn't Linux great... :-) Anyways - could someone offer me some advice - all I need is some some simple SELECT queries on the Access tables. Many Thanks, Chris Email: [EMAIL PROTECTED] Web: www.oxspring.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 to M$ Access
Access has to be running on a Winders machine. At least the drivers. Another option might be to migrate the data, and use ODBC and linked tables to let Access still work temporarily, but really have the data already transitioned. Otherwise it is a weird linked ODBC bouncing off a Windows machine on the way to the data. Chris Andrew wrote: Hi, Until we completely migrate an application from M$ Access to PHP/MySQL, I need to figure out a way to temporarily query an Access DB from PHP/MySQL. I am aware of this article on PHP Builder: http://www.phpbuilder.com/columns/timuckun20001207.php3?page=1 which discusses using ODBC Socket Servers, but the article assumes the M$ Access db is on a winblows machine. In my case, the Access DB is on a Linux machine (served thru' Samba - isn't Linux great... :-) Anyways - could someone offer me some advice - all I need is some some simple SELECT queries on the Access tables. Many Thanks, Chris Email: [EMAIL PROTECTED] Web: www.oxspring.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 to M$ Access
Chris, You'll need a Windows OS to hit MS Access. OpenLink's Multi-Tier drivers can affect this connection for you if you have a Windows box, but without Windows you may be out of luck. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Chris Andrew [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 10:43 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP/MySQL to M$ Access Hi, Until we completely migrate an application from M$ Access to PHP/MySQL, I need to figure out a way to temporarily query an Access DB from PHP/MySQL. I am aware of this article on PHP Builder: http://www.phpbuilder.com/columns/timuckun20001207.php3?page=1 which discusses using ODBC Socket Servers, but the article assumes the M$ Access db is on a winblows machine. In my case, the Access DB is on a Linux machine (served thru' Samba - isn't Linux great... :-) Anyways - could someone offer me some advice - all I need is some some simple SELECT queries on the Access tables. Many Thanks, Chris Email: [EMAIL PROTECTED] Web: www.oxspring.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]
Re: [PHP-DB] Oracle via php under windows 2k
ok, that was already done, ive an Oracle server with database on a computer and on another i ve apache + php +oci8 and the oracle client installed, what to do now for this work ? Philippe Saladin [EMAIL PROTECTED] a écrit dans le message de news: [EMAIL PROTECTED] If you were using it in linux you would need at last the oracle client installed locally, I don't know in windows. Yes, the oracle 8 client has to be installed onto the server : it's the middleware between Oracle and the client. See your oracle dba. Regards, Philippe -- 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] Why use MySQL with PHP
I just remembered, the only bad thing I can think of about MySQL... their website locks up Netscape =) PHP qualifies for this too. www.php.net looks pretty messy in NS. By the way, both doesn't break NS.. Bye, B. -- 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] Need Help on DHTML and PHP
1. You can't do it without causing the screen to flicker, unless you use... Nope, that won't work. Never mind. The problem is that once the page is loaded into the browser, there is no way to change the content of the page based on server data without refreshing the page. It doesn't work. You could use a META refresh, but that would cause the flicker. Because PHP lives on the server and is not interpreted by the browser, you're stuck. 2. You failed to include a link to your page. 3. Could you change the background color in your e-mail? The bright yellow makes my eyes melt. At 11:21 AM 11/15/2001, kelvin wrote: Hi everyone, I wrote a program which retrieved Username from DB every 2 or 4 second. So, I used DHTML and PHP plus DB. Well, I have to use DHTML because the user don't want to see the screen flicker. Ok. Here is my program, but it didn't worked at all. Could any one help me out please, I'll very appreicate. Kelvin. P.S if you click on view source from browser after gen. the code, it shown username on $toOut, but nothing display. Sliante, Richard S. Crawford http://www.mossroot.com mailto:[EMAIL PROTECTED] AIM: Buffalo2K ICQ: 11646404 Y!: rscrawford It is only with the heart that we see rightly; what is essential is invisible to the eye. --Antoine de Saint Exupéry Push the button, Max! -- 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] Why use MySQL with PHP
I use PHP/MySQL for a few reasons. 1) Ease of Use - I am a Computer Science student and a Web Programmer. As such have been exposed to a wide variety of programming languages and environments. PHP/MySQL is one of the easiest to work with and learn, and is THE easiest to do Web related things with (and yes, I have used and am including ASP in that statement). 2) Availability - By this I mean not only that both PHP and MySQL are free (which is a big factor for us starving student types), but that they setup very easily on a variety of platforms. This means I can test scripts on a copy of the MySQL DB from my Linux Server on my windows box before uploading them. 3) Support - Both PHP and MySQL have very good Manuals which are very easily accessable (both online and downloadable). In addition, I have received extremely valuable help from the PHP mailling lists on both PHP and MySQL questions. In most cases I have gotten faster and better responses than I get from professors at school (who I am asking things concerning their class...not PHP =P ) who I am paying to teach me. That alone is quite a strong arguement. 4) Good Balance between Flexibility and Readability - In PERL they have a saying There's More Than One Way To Do It. I think this is a good philosophy, but PERL takes this to more of an extreme than I like (this is not to say that this extreme is not right for some people). When I read through a 50 line program in a language that I am fairly skilled at I shouldn't have to refer to the manual more than say a dozen times...right? In Perl I often find myself having to refer to manuals a dozen times for two or three lines! For example: perl -we '$_ = q ?4a75737420616e6f74686572205065726c204861636b65720as?;??; for (??;(??)x??;??) {??;s;(..)s?;qq ?print chr 0x$1 and \161 ss?;excess;??}' Any idea what that one does? Without running it? Paste it into a terminal... it should run as is (does on my Linux box with PERL 5 anyway). On the other hand, having to write in languages where you have strict types (You want to treat a variable as an int and then as a string?!?!?!?) and very structured design is just as distasteful to me. PHP strikes a very good balance between the two even when working with MySQL (I won't paste any of the kludge needed to interface with CGI and DB in other languages... but if you have some free time look some of these programs up). Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: søren eriksen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 2:34 PM Subject: [PHP-DB] Why use MySQL with PHP Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- 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] Why use MySQL with PHP
I wrote this a few month ago for the db comparaison. It's simple and you can easily add to it: http://zc8.com/zc8/ZC8news/shownews.php?articleid=571 As for PHP my reasons are: * No need to typecast which makes it easier to code. * You can have multi-dimensional multi-cast arrays which in many case can do instead of objects. * It's nothing to learn if you already know a modular language (pascal, c, java...). * It types easily within your html code and it is extremelly readable (although you can put some effort into making it hard to read). * No need to compile. * It's open source * You can compile it with Apache and with your specs. * Many interesting module available (like Ming) * It's very portable. * It's widely present on web server. * It has easy communications with databases, ftp, remote ip files, mail... * It has great support and online reference. * It is very well maintained. * Lot's of sample code on the web to look at. And I probably forget a lot On Thursday 15 November 2001 12:53 pm, Sheridan Saint-Michel wrote: I use PHP/MySQL for a few reasons. 1) Ease of Use - I am a Computer Science student and a Web Programmer. As such have been exposed to a wide variety of programming languages and environments. PHP/MySQL is one of the easiest to work with and learn, and is THE easiest to do Web related things with (and yes, I have used and am including ASP in that statement). 2) Availability - By this I mean not only that both PHP and MySQL are free (which is a big factor for us starving student types), but that they setup very easily on a variety of platforms. This means I can test scripts on a copy of the MySQL DB from my Linux Server on my windows box before uploading them. 3) Support - Both PHP and MySQL have very good Manuals which are very easily accessable (both online and downloadable). In addition, I have received extremely valuable help from the PHP mailling lists on both PHP and MySQL questions. In most cases I have gotten faster and better responses than I get from professors at school (who I am asking things concerning their class...not PHP =P ) who I am paying to teach me. That alone is quite a strong arguement. 4) Good Balance between Flexibility and Readability - In PERL they have a saying There's More Than One Way To Do It. I think this is a good philosophy, but PERL takes this to more of an extreme than I like (this is not to say that this extreme is not right for some people). When I read through a 50 line program in a language that I am fairly skilled at I shouldn't have to refer to the manual more than say a dozen times...right? In Perl I often find myself having to refer to manuals a dozen times for two or three lines! For example: perl -we '$_ = q ?4a75737420616e6f74686572205065726c204861636b65720as?;??; for (??;(??)x??;??) {??;s;(..)s?;qq ?print chr 0x$1 and \161 ss?;excess;??}' Any idea what that one does? Without running it? Paste it into a terminal... it should run as is (does on my Linux box with PERL 5 anyway). On the other hand, having to write in languages where you have strict types (You want to treat a variable as an int and then as a string?!?!?!?) and very structured design is just as distasteful to me. PHP strikes a very good balance between the two even when working with MySQL (I won't paste any of the kludge needed to interface with CGI and DB in other languages... but if you have some free time look some of these programs up). Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: søren eriksen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 2:34 PM Subject: [PHP-DB] Why use MySQL with PHP Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- 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] Why use MySQL with PHP
I mostly agree, although I prefer PostgreSQL for the transactions, better row locking, and server side cursors. It also does better with lotsa users (if the data isn't just used for the web, this is important). I have used many languages for this stuff, and the one with the best balance of functionality, extensibility, and ease of use is PHP (I have used CF, ASP, Miva/HTMLScript, PERL, C, COBOL, Shell also) BTW, COBOL on the web is weird. ASP is the worst of them all. Sheridan Saint-Michel wrote: I use PHP/MySQL for a few reasons. snip/snip On the other hand, having to write in languages where you have strict types (You want to treat a variable as an int and then as a string?!?!?!?) and very structured design is just as distasteful to me. PHP strikes a very good balance between the two even when working with MySQL (I won't paste any of the kludge needed to interface with CGI and DB in other languages... but if you have some free time look some of these programs up). Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.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, ODBC Access2k - Getting a field value from the last INSERT
I have a table that I need to update using INSERT INTO table (field1, field2) VALUES (val1, val2) The table has an AutoNumber field for a Primary Key called ID. I need to get the ID that was assigned in the INSERT. With PostgreSQL you do this with oids but as far as I know Access doesn't use them. How then can I do this? Dan Boitnott [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] Why use MySQL with PHP
Tell me about it. You ever try running php.net through http://validator.w3.org ? It's not pretty. Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: B. van Ouwerkerk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 12:28 PM Subject: Re: [PHP-DB] Why use MySQL with PHP I just remembered, the only bad thing I can think of about MySQL... their website locks up Netscape =) PHP qualifies for this too. www.php.net looks pretty messy in NS. By the way, both doesn't break NS.. Bye, B. -- 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] dlls and inis.Help.
Hi... Anyone got a clue for this piece of bad luck? I'm on win2k pro + IIS5 +php4.0.6 cgi installation. It works fine untill I try to load php_interbase.dll extension and this is how it goes: Unable to load dynamic library '...' - The specified procedure could not be found. Three points stand for: ./ (this one is by default), d:\php, d:\php\extensions, d:\winnt and d:\winnt\system32, wherever I choose to put the dll. Those folders where declared in the above fashion and with/without quotes, with slash/backslash. ( other *.ini-s, for example, to assign folders don't use quotes and use \ instead of /) - ( Of course I had Interbase server running all the time.), and I wasn't lazy to reboot the system every time... Now count the combinations... Tiresome... Does anybody know how to solve this? Zoran ps. I tried to use my database, and one example mdb, with php through ODBC - that was a laugh: 'Database name could not be found' for odbc_connect(dns,user,pswd)... (c/c++ is maybe harder to learn, but I have never had this much fuss with it.) ODBC support is supposed to be built in, or is it? -- 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 Binaries for Solaris 8
How can you download PHP binaries for Solaris 8? Can't seem to find it on php.net, and some other sites. -- 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] dlls and inis.Help.
Anyone got a clue for this piece of bad luck? I'm on win2k pro + IIS5 +php4.0.6 cgi installation. It works fine untill I try to load php_interbase.dll extension and this is how it goes: Unable to load dynamic library '...' - The specified procedure could not be found. Three points stand for: ./ (this one is by default), d:\php, d:\php\extensions, d:\winnt and d:\winnt\system32, wherever I choose to put the dll. Those folders where declared in the above fashion and with/without quotes, with slash/backslash. ( other *.ini-s, for example, to assign folders don't use quotes and use \ instead of /) - ( Of course I had Interbase server running all the time.), and I wasn't lazy to reboot the system every time... Now count the combinations... Tiresome... Does anybody know how to solve this? Hi Zoran Is it possibly an issue with PHP.INI. From mine:- - ... ; ; Paths and Directories ; ; ... ; Directory in which the loadable extensions (modules) reside. ;extension_dir = ./ extension_dir = C:/program files/php/extensions ; Whether or not to enable the dl() function. The dl() function does NOT work ; properly in multithreaded servers, such as IIS or Zeus, and is automatically ; disabled on them. enable_dl = On ... ;; ; Dynamic Extensions ; ;; ; ... ;Windows Extensions ;Note that MySQL and ODBC support is now built in, so no dll is needed for it. ; ;extension=php_bz2.dll ... ;extension=php_interbase.dll ... -- Uncomment the last (shown) line and place the .dll in the extension_dir directory. Hope it helps, =dn -- 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 via php under windows 2k
See http://www.thickbook.com/extra/php_oracle.phtml for a simple tutorial. Note that in my case, I've trouble using OCILogon with its third argument, for example '@mydb'. I have to use the complete syntax you found in the oracle file tnsnames.ora, something like mydb.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = IP address) (Port = port 1) ) (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = IP address) (Port = port 1) ) ) (CONNECT_DATA = (SID = oracle ID) ) ) Hope this helps. et bon courage ! Philippe Titanesk [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] ok, that was already done, ive an Oracle server with database on a computer and on another i ve apache + php +oci8 and the oracle client installed, what to do now for this work ? Philippe Saladin [EMAIL PROTECTED] a écrit dans le message de news: [EMAIL PROTECTED] If you were using it in linux you would need at last the oracle client installed locally, I don't know in windows. Yes, the oracle 8 client has to be installed onto the server : it's the middleware between Oracle and the client. See your oracle dba. Regards, Philippe -- 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] 5760 Melt away extra5891 pounds and inches today! 4372028
My name is Linda Gillie. I am 31 years old. A mother of three, a wife of 13 years to a wonderful man, Michael My heart told me to share my story with you, so you don't give up hope. I have found a weight loss product that really works. It gets rid of fat fast and keeps it off, FOR GOOD! The youngest of 6 children, with both sides of my family prone to be he= avy, I have battled being overweight since I was a kid. I've been on ;just about every diet program, pill, liquid, anything else you can think of. It was a never-ending cycle. Up, down, up, down, up. My weight loss and gain was a literal yo-yo! Nothing I did worked permanently! I had always gained back more than I would lose every time I got tired of a particular diet. I was disgusted with my looks, mentally and physically depressed. I just about gave up hope forever of losing my excess pounds, until I was introduced to an all-natural weight loss product, which has changed my life in every way! My dearest friend and her husband have lost a lot of weight on a product called Weigh Out. So, I decided to try it. In the first month I dropped from size 24 to 18 in 10 months I lost 78 pounds and 10 dress sizes and '85 I have kept it off for more than a year. I feel like a new person and everyone around me cannot believe the difference! I have a lot more energy and I just feel all around good. This is the easiest program I've ever been on. You just follow the instructions and the pounds and inches just fall off! No more up and down. Weigh Out has changed all that. Now it's down,down, down, and away! All of my old belts were in the first hole. You can imagine how excited I was when I used the last hole, and then had to buy a couple of new ones. It's the most incredible feeling! This is the first time in my life i have ever lost weight and KEPT it off. I am still losing a pound or two every week or so and that is fine with me My husband has lost 3 pant sizes during the same time and gets into clothes he had not worn in years! (He looks great in his tight fitting' jeans!) I know people that have lost over 80 lbs with Weigh Out. There are literally thousands of people like you and me who have WON the battle of the bulge because of Weigh Out! Thank God for Weigh Out and David Edie for helping me find it. I have the BEST life now! I thank my family for being so supportive. I do hope you will check this out. I NOW have no fear of EVER being overweight again. It doesn't matter how much weight you have to lose; 20, 40, /83 100, or 200 + lbs pounds. this will change your life forever. I encourage you to try it for 30-days. I promise you'll be calling for more soon after! Click on the link below to see the details: http://weighout.yeah.net Thank you, for allowing me the opportunity to tell my story. Good Life and God Bless Linda Gillie -- 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]