Hai Group,
I'am to new PHP and I'am struck with connecting to
MSSQL . I'am using PHP 4.0.6, PWS with MSSQL Server
7.0. I've followed the instructions given in the
configuration file that came with the software. I've
copied php_mssql.dll into my windows directory and it
is there in the directo
On Wed, 21 Nov 2001, Manuel Lemos wrote:
> > If we fixed these problems and more, we could talk about having
> > a unified API. Otherwise for the Oracle OCI_ASSOC, I would prefer
> > not to change it for speed, Manuel would want to provide an emulation
> > layer, i would object because it's slow
> > I wrote a program which retrieved Username from DB every 2 or 4=
> second.
Why every 2 or 4 seconds do you need to retrieve the username? The user is
still the same in the session...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For addi
On Wed, 21 Nov 2001 09:19:44 -0500 (EST), Joao Prado Maia wrote:
>If PEAR::DB is not abstracting the database what is the purpose of such a
>library ?
To ease the life of lot's of programmers.
- Martin
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECT
On Wed, 21 Nov 2001 09:19:44 -0500 (EST)
Joao Prado Maia <[EMAIL PROTECTED]> wrote:
>
> On Wed, 21 Nov 2001, Manuel Lemos wrote:
>
> > > If we fixed these problems and more, we could talk about having
> > > a unified API. Otherwise for the Oracle OCI_ASSOC, I would prefer
> > > not to change it
John Lim wrote:
Hi John,
>
> >
> > The only exit I see of the multi abstraction layers problems is trying
> > to join all those communities and start a new development from the
> > ground. The code is almost all written so only need to glue it to meet
> > the specs of the new resultant layer. T
En réponse à Joao Prado Maia <[EMAIL PROTECTED]>:
> Now for the $15,000 question: does anyone else agree with this ? If
> PEAR::DB is not abstracting the database what is the purpose of such a
> library ?
Well I strongly need thoses $15 000 $ so
What is the purpose ?
As a "average php use
Manuel Lemos wrote:
>
> Hello,
>
> John Lim wrote:
> > Each designer has a different point of view, like Tomas has
> > written a really excellent oci8 "select limit" emulation, but looking
> > at the code, it's so complicated that i decided not to incorporate it
> > in ADODB because I value simp
>Now for the $15,000 question: does anyone else agree with this ? If
>PEAR::DB is not abstracting the database what is the purpose of such a
>library ?
a) unifed API
You havn't to think about the name of the command to send a query,
connecting...
b) it offers helpful functionality
I.e. don't care
According to the docs and everything I've seen with PHP and persistent
connections, you don't have to close the connection since PHP will
simply reuse.
Joshua Hoover
> Howdy--I have a question about persistent connections and their
> behavior:
>
> Apache 1.3.2 / PHP 4.0.6 - as a module
> Win2
> Well I strongly need thoses $15 000 $ so
>
> What is the purpose ?
> As a "average php user/developper" I don_t really care about the "pure cross
> plateform/database issue" but I do care about a standard, clean, secure ("my-
> bugs-free") and easy way to use a database, and PEAR::BD + T
Hi all:
I'm wondering what you guys use as your 'standard' method of checking for repeated
inserts. (as
opposed to having to cane the database with a 'select' statement when a check needs to
be
made..)
I think I have to use mysql_affected_rows() and/or mysql_insert_id(), unfortunately I
don
En réponse à Pierre-Alain Joye <[EMAIL PROTECTED]>:
> This definition defines more a common interface to connect to a db,
> execute queries, fetch the result and eventually gives errors reports
> ;).
Somehow yes (do I still win the $15,000 ???)
> IMO, the need of a real abstraction layer is no
Hi there,
we use a wrapper class to access a mysql db with php-4.0.6 running in
Apache/Linux and mysql-3.23.40.
We ran into the following problem:
Assume the following test code (sorry - rather long):
-[ test code ]--
reader,$this->writer);
( $this->writer = mysql_co
On Wed, 21 Nov 2001, Martin Jansen wrote:
> On Wed, 21 Nov 2001 09:19:44 -0500 (EST), Joao Prado Maia wrote:
>
> >If PEAR::DB is not abstracting the database what is the purpose of such a
> >library ?
>
> To ease the life of lot's of programmers.
>
I probably used a bad choice of words. What I
On Wed, 21 Nov 2001 16:14:04 +0100 (MET)
Luc Saint-Elie <[EMAIL PROTECTED]> wrote:
> En réponse à Pierre-Alain Joye <[EMAIL PROTECTED]>:
>
>
> > This definition defines more a common interface to connect to a db,
> > execute queries, fetch the result and eventually gives errors reports
> > ;).
> I probably used a bad choice of words. What I really meant was: What is
> the objective of PEAR::DB as a database abstraction library ? To abstract
> as much as possible like Metabase already does, or to provide a unified
> API to databases and leave the implementation related to database specif
John,
in addition to the list you posted, there's
- inconsistent/incomplete metadata support. it would be nice, for example if
the MySQL extension would be more
precise about a field type than "string", etc
i tried hard and failed to describe why i'd want to start a C based DB
library, an
ok, thnx
> No, but SQL is your friend
*lol*
greez
daniel
--
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]
On Wednesday 21 November 2001 16:24, Joao Prado Maia wrote:
> On Wed, 21 Nov 2001, Martin Jansen wrote:
> > On Wed, 21 Nov 2001 09:19:44 -0500 (EST), Joao Prado Maia wrote:
> > >If PEAR::DB is not abstracting the database what is the purpose of
> > > such a library ?
> >
> > To ease the life of lo
> >Now for the $15,000 question: does anyone else agree with this ? If
> >PEAR::DB is not abstracting the database what is the purpose of such a
> >library ?
I would suggest that Alexander's list of reasons for using PEAR:DB should
be written up in some introductory section to the manual for PEAR
The error indicates that the result resource is invalid. The result
resource in your example is $rs. Either this is not the variable that you
used when sending the query or something went wrong with the query. You
should always add "or die(mysql_error) to the end of your mysql_query
statements,
On Monday 19 November 2001 20:27, Vincent Ma wrote:
> Hi everybody:
>
> I would like to ask why the error occur when retrieve current sequence
> number. Eg. "select currval('student_id_seq')" is not working, and warning
> prompt "student_id_seq.currval is not yet defined in this session".
>
> H
I am running PHP/Apache. I have installed unixODBC and inlinks tds
driver. I can succesfully connect and query an MS SQL db from the isql
command line testing tool provided with unixODBC. I recompiled php with
unixODBC support and it compiled and installed without a problem. So it
was onto wri
Dear list members,
I have login page which passes the user name to the next screen. If the
user is correct i want to direct him to the actual application. If not right
then i want to display a notlogged page. I am doing the following.
http://192.168.200.98/frame_main.htm";);
}
else
{
header("
Can someone give me the code to make the db display 10 cars per page then
make another page with the links below the car for the next page youc na see
the car db here so far
http://www.games-are-forever.com/phpadmin/cardisplay.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscri
just add "LIMIT N,R" to your SELECT statement where N is the row you want to
start with and R is the number of rows you want to fetch.
The first row is 0 so if you want to fetch 10 cars per page make R 10 and
make N a variable. Pass 0 to N on the first pass, then put links on your
page for NEXT
Hi there everyone,
This may sound like an odd question and something that I should know, but ...
I need to display results by amount - for example, for all properties which are either
or between 450,000 and 500,000 (For example) - how using PHP and MySQL do I get it to
display 450,000, 50,
should be able to do something like
SELECT whatever FROM whereever WHERE value<='50' AND value>='45'
is that what you are looking for?
// -Original Message-
// From: Chris Payne [mailto:[EMAIL PROTECTED]]
// Sent: Thursday, 22 November 2001 3:11 PM
// To: [EMAIL PROTECTED]
// Su
> This may sound like an odd question and something that I should know,
> but ...
>
> I need to display results by amount - for example, for all properties
> which are either or between 450,000 and 500,000 (For example) - how
> using PHP and MySQL do I get it to display 450,000, 50,000 and al
(PHP-DB folks, ignore this top question - unless you want to answer)
Which type of DB/Table provides table locking while a process is
altering data? I don't care for locking while using SELECTs, but I do
need locking when something's being INSERTed or UPDATEd, so I won't get
two process
Ok, I think I have the solution to your problem.
Try using nl2br() on the data in that field..
Example:
I have a message table that allows one user to send an instant message to
another user on my site. There are several fields, one of which being a TEXT
column (MySQL db). I use a simple textare
32 matches
Mail list logo
