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
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
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
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
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
*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
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
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
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
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
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)
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
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
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
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
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
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
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
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
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
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
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,
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
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
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
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
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
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,
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
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:
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:
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 =
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!
33 matches
Mail list logo
