Hi all,
I am writing an object-oriented program in PHP, and some of the child
objects require similar data to their parents, but from different columns of
the same table.
Is it better to retrieve the whole table up-front and store it in a session
array, or to run the queries seperately each time
Od: "signup" <[EMAIL PROTECTED]>
Temat: Re: [PHP-DB]
> However, the answer about needing to define a PK before you can use it as
a
> FK being a limitation of SQL may have been a bit misleading (sorry,
Jarek).
> It is more of a building block of relational theory rather than a
> limitation of S
What's the best or recommended way of sweeping users from MySQL on the
hour or half hour or other?
To keep things portable i was thinking about having each login sweep the
db, so every is sweeping for everyone else? But that's kinda dumb. Then i
came up with a cron job, but that will be admin dep
PHP has "built in" functions to talk to MYSQL - see www.php.net/mysql
I'd say these are the fastest, more reliable and easiest way to access a
MSSQL db.
Siggy
- Original Message -
From: "Julio Cuz, Jr." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 11:08
You could have a session variable which"
When you order/pay/whatever an image, is set to "canorder=1";
When you download an image, canorder can only==1, and is set back to
"canrdoer=0"
Something like that can be improved upon vastly, but this is my immediate
thought plan. Renaming files and stu
On Tue, 23 Jan 2001 17:13:24 -0800, Bryan wrote:
>Hey all...
>
>I have a site where people have to pay for the pictures. He is a professional
>photographer and does not want
>people stealing his work. When they download and image, they pay for it. The
>problem with that is, if
>I have image
Hey all...
I have a site where people have to pay for the pictures. He is a professional
photographer and does not want
people stealing his work. When they download and image, they pay for it. The problem
with that is, if
I have images named 001.jpg, 002.jpg, people can type that into the UR
HELP!
I need to access a database on a mssql server from a linux box, but the php
doesn't recognize any of the mssql statements. Apparently mssql support was
not included in the inital php installation (which came with Mandrake 7.2).
I know there's the option of downloading the PHP source and co
Hi--
Bottom line: What's the most used way of talking to MSSQL from PHP
4? Freetds/ODBC/Openlinks/other?
Julio Cuz, Jr.
Riverside Community College
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail
I am running PHP3.017(cgi) + Apache + MySQL on Windows98 SE.
The include() and the getenv() functions are asking for a dial-up
connection. Can somebody give me a hand ?
Jayme.
http://www.conex.com.br/jjeffman
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAI
On Tue, Jan 23, 2001 at 04:57:02PM +0800, Koala wrote:
> Here is the code:
> $arr_var = Array();
> $arr_var[] = Array("KEY"=>'rec_id', "VALUE"=>'00', "LENGTH"=>-1);\
> ..
> $stmt = OCIParse('DECLARE rec_id NUMBER(20); SELECT recNum INTO rec_id FROM
> table WHERE recNum= 2 ');
> ..
> $n
I have the following problem with php 4:
when I uncomment php_interbase.dll line in php.ini,
I get the following message:
Unable to load dynamic library 'c:php\extensions\php_interbase.dll' -
A device attached to the system is not functioning.
I get the same result when I try to use dl() function
Sorry for second mail:
I use PHP v.4.0.3 cgi version on iis4.0
Hi,
It may interested someone:
I have succesfully connected to Oracle:
use
ORACLE 6i runtime
connect to Oracle 8.1.6 from winnt4.0 workstation SP6
Code I use:
full server description:
Oracle8i Enterprise Edition Release 8.
Hi,
It may interested someone:
I have succesfully connected to Oracle:
use
ORACLE 6i runtime
connect to Oracle 8.1.6 from winnt4.0 workstation SP6
Code I use:
full server description:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - 64bit Production
PL/SQL Release 8.1.6.0.0 - Production
Hi all,
Thanks a lot for the help!! I´ve reinstalled Oracle Cliente (version
8.1.5.0.0) and PHP 4.0.4pl1 and tried Jean-Christophe suggestion, with
success:
--
");
while(OCIFetch($result)) {
$CC = OCIResult($result,1);
$CCNome = OCIResult($result,2);
echo('' . $CC . '' . $CC
Platform: HPUX 10.20
Configuration: PHP4.0.1pl2 --with-iodbc --without-mysql
--with-pdflib=/usr/local --without-gd
--with-apache=../apache_1.3.14
Using Openlink MT ODBC driver against a PROGRESS database.
Everything in the above configuration is working fine, but I have just
attempted to
I could do some MSSQL 7 testing.
signup <[EMAIL PROTECTED]> on 01/22/2001 03:38:22 PM
To: [EMAIL PROTECTED]
cc:
Subject: RE: [PHP-DB] PEAR DB testing volunteers needed
Hi Stig,
>
> Hi,
>
> This is an invitation to help testing PHP's bundled database abstraction
> layer, DB. If you ar
Hi!
I'm pretty new to PHP and now I got a problem with Date datatype and oracle.
I can recive the date as a string with osiresult($stmt, "COLUMN_NAME") in
the oracle date format (eg. '23-JAN-01') but I wold like to recive the whole
date (eg. '2001-01-23 15:21:13'), that's the first problem.
The se
On Mon, Jan 22, 2001 at 01:38:22PM -0800, signup wrote:
> Hello,
> does anyone know how to write te result of the following SQL statement (I have
>problems with rowid):
>
> select rowid, field1 from table1
rowid is an opaque datatype in php. you cannot "output" it
but only use it for fu
Why are these emails showing up now - I believe they were sent out a couple
of months ago... ?
Best regards,
Andrew
> -Original Message-
> From: signup [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 22, 2001 4:38 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] PEAR DB testing volu
Addressed to: John Starkey <[EMAIL PROTECTED]>
[EMAIL PROTECTED]
** Reply to note from John Starkey <[EMAIL PROTECTED]> Tue, 23 Jan 2001
02:02:46 -0700 (MST)
>
> I'm trying to clean up about 2000 lines of whacked out newbie code
> i've created. Is there a way to daisy chain include
-BEGIN PGP SIGNED MESSAGE-
Hi,
Well, I've solved my problem with Thies's help It turned out to be a
permissions problem:
It was a (@#$%^) permissions problem on the root oracle directory.
I have oracle installed in /home/oracle/OraHome1, and the permissions
on /home/oracle was 700. O
Od: "Anthony Martin" <[EMAIL PROTECTED]>
Temat: [PHP-DB]
> I'm having trouble figuring out this referential logic. I'm writing a
> rudimentary directory structure for dividing HTML sections from one
another.
> Right now, my tables have no referential integrity, except for ones
> pertaining out
I have some problem authentication with PHP, how can I force a user to logout
(pressing logout button) and clear credential info without displaying logon screen
again. Right now when user click logout button then Logon screen appears again. Code
(logout.php) :
Can anyone help me. Thanks in a
> Hi,
>
> This is an invitation to help testing PHP's bundled database abstraction
> layer, DB. If you are interested in helping DB to become stable on
> _your_ database platform, please reply to this message with what
> database systems you have access to.
>
> Systems in particular interest ar
> Hello, I'm trying to use the mssql_connect function to connect to the
> Microsoft SQL server with php4.0.3pl1 for window, but the return is "Fatal
> error: Call to undefined function: mssql_connect()". And another mssql
> function are also with the same result, but I have try use the mysql and
>
I was hoping someone would look at this situation first, and someone did.
However, the answer about needing to define a PK before you can use it as a
FK being a limitation of SQL may have been a bit misleading (sorry, Jarek).
It is more of a building block of relational theory rather than a
limi
It helped a lot, actually. I already implemented an artificial PK, like
your first example table. I too consider this as relational theory, and not
a limitation. And I was just hoping there was a piece of logic I was
missing, but it looks like there wasn't. Thanks for humoring me.
Anthony
-
Hi ...
My name is Dedy Wahyudi ...
I follow your instruction at webmonkey site regarding PHP/MySQL Tutorial ..
But there is some problem i'm having ... may be you can tell me
";
print " Type of Service:".$row['type']." ";
print " Company
Name:".$row['company']."";
print " Contact
Pers
Hello,
does anyone know how to write te result of the following SQL statement (I have
problems with rowid):
select rowid, field1 from table1
Thanks in advance
Benoit NOSS - ([EMAIL PROTECTED]) (Bureau 226)
IAURIF, Service MSI, 15 rue Falguiere, 75740 PARIS Cedex 15 FRANCE
Tel : (+33) 1 53 85 7
Hi Stig,
>
> Hi,
>
> This is an invitation to help testing PHP's bundled database abstraction
> layer, DB. If you are interested in helping DB to become stable on
> _your_ database platform, please reply to this message with what
> database systems you have access to.
>
> Systems in particular i
I realised I just sent my password out needless to say I am just about to
change it.
All the Best
Lisa
-Original Message-
From: Rubanowicz, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 1:54 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Newbie - 2 tables one insert
Hi all
Hi all,
Could you please help me out on this one.
I want to create a web site using two tables.
1. page_creation - Stores page_id and page_name to be shown on all
navigation bars.
2. pages - Contains pg_id, page_id, etc etc.
I want to do an insert into page_creation to create a new page and then p
Geachte relatie,
Door een fout van een van onze medewerkers is
wellicht naar u een bericht doorgestuurd dat u niet had mogen bereiken. Het
betrof een bericht dat alleen bestemd was voor privérelaties van betreffende
medewerker. Daarnaast was het bericht van een strekking die niet hoort bij
I have a single include file that I put all my require_once commands in that
are applicable to each page.
Something like
then at the top of each page I put:
require_once("myincludes.php");
is that what you are looking for?
Cal
http://www.calevans.com
-Original Message-
From: John St
Hi,
I've attempted to add RC4 encryption / decryption
facility in PHP. It's been tested on PHP4.
It handles all the XORing and conversions while
encrypting and decrypting also all urlencoding and
decoding. It's been pretty fast also.
I've written a tutorial on it, whatever it is :
http://www.de
PHP as apache module?
--
Piloteers do it on the road
--
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]
Hello, John Coonrod!
You wrote:
(I
> notice it refers to oracle_home, so I obviously need to
> install some of the
> oracle client software on my machine).
Yes, that's right. Oracle client.
--
Piloteers do it on the road
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
What EXACTLY do you want accomplished?
--
Piloteers do it on the road
--
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]
Problem, upload selected htm files to server,delete selected files from
server and create link table to these files, with desired link names.
Idea is to do uploading and deleting files in admin site as well as define
link names. And when user comes in he would see the link list.
Any ideas / exa
I'm trying to clean up about 2000 lines of whacked out newbie code i've
created. Is there a way to daisy chain includes? I have about five
includes in each header and I was thinking of making one include file and
linking to that. And furthermore :} is there a way to include within a
function if i
Here is the code:
$arr_var = Array();
$arr_var[] = Array("KEY"=>'rec_id', "VALUE"=>'00', "LENGTH"=>-1);\
..
$stmt = OCIParse('DECLARE rec_id NUMBER(20); SELECT recNum INTO rec_id FROM
table WHERE recNum= 2 ');
..
$num_rows = count($arr_var);
for ($i=0; $i<$num_rows; $i++) {
if (is
42 matches
Mail list logo
