subject:"\[PHP\-DB\] Re\: Re"

[PHP-DB] Re: Re

2016-10-18 Thread Jigme Datse Yli-Rasku

Something up here...  Probably not fixable by me.  But this is the second of 
what appear to be identical messages. 
On 2016-10-17 23:51, php-db@lists.php.net wrote:
> "Re: [PHP-DB] SQL Injection"
> JigmeRasku doc
> 
>

-- 
Jigme Datse Yli-Rasku
jigme.da...@datsemultimedia.com (Preferred address for new messages)
250-505-6117

Jigme Datse Yli-Rasku
PO Box 270
Rossland, BC V0G 1Y0
Canada

...
... This message should be electronically signed, and if the sender ...
... has your public key, may also be encrypted. ...
... If you have any questions about this, please email, or call. ...
... ...
... Note, unknown calls likely will go to voicemail. ...
... Please leave a message if you get voicemail. ...
...

signature.asc
Description: OpenPGP digital signature

[PHP-DB] RE: RE :[PHP-DB] MySQLi Help

2012-06-17 Thread jstarritt


 
Oliver,
 
Gah -- thank you.
 
James
 
-Original Message-
From: "Olivier Desmares" 
Sent: Saturday, June 16, 2012 10:58am
To: "jstarr...@selagodesign.com" , 
"php-db@lists.php.net" 
Subject: RE :[PHP-DB] MySQLi Help



Hi James,

The manual page for mysqli_stmt::execute has the following note :

When using mysqli_stmt_execute(), the  
[http://fr2.php.net/manual/en/mysqli-stmt.fetch.php] mysqli_stmt_fetch() 
function must be used to fetch the data prior to performing any additional 
queries.

So you cannot execute the inner (sub) query without first retrieving all the 
rows from the outer (main) query.

Olivier Desmares
 $stmt = mysqli_prepare($db, $sql);
 mysqli_stmt_execute($stmt);
 mysqli_stmt_bind_result($stmt, $authkv);

 while (mysqli_stmt_fetch($stmt)) {
 echo "MAIN: $authkv";
 sub($db);
} 

 mysqli_stmt_close($stmt);

This simple change results in the output.

MAIN: 7
Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt,  boolean 
given in /var/www/html/xgwebapi/mysqli.php on line 21  Warning: 
mysqli_stmt_bind_result() expects parameter 1 to be  mysqli_stmt, boolean given 
in /var/www/html/xgwebapi/mysqli.php on line  22  Warning: mysqli_stmt_fetch() 
expects parameter 1 to be mysqli_stmt,  boolean given in 
/var/www/html/xgwebapi/mysqli.php on line 24  Warning: mysqli_stmt_close() 
expects parameter 1 to be mysqli_stmt,  boolean given in 
/var/www/html/xgwebapi/mysqli.php on line 28




*
James Starritt
Selago Design, Inc.

US: (312) 239 0592
jstarr...@selagodesign.com
*

[PHP-DB] Re: RE：[PHP-DB] How do I do math with a UNION ALL

2011-04-16 Thread Ron Piggott


Thank you for the suggestion.  This is the actual query that I implemented:  
Amazing how this works.  Ron

SELECT SUM( `impressions_total` ) AS impressions_total , SUM( `usage_total` ) 
AS usage_total FROM (

(

SELECT IF ( SUM( `web_advertisements_our_clients_usage`.`impressions` ) , SUM( 
`web_advertisements_our_clients_usage`.`impressions` ) , 0 ) AS 
impressions_total, IF ( SUM( `web_advertisements_our_clients_usage`.`usage` ) , 
SUM( `web_advertisements_our_clients_usage`.`usage` ) , 0 ) AS usage_total FROM 
`web_advertisements_our_clients_usage` WHERE 
`web_advertisements_our_clients_reference` =  
$web_advertisements_our_clients_reference AND `month` = $stats_month AND `year` 
= $stats_year LIMIT 1

) UNION ALL (

SELECT `impressions` AS impressions_total, `usage` as usage_total FROM 
`web_advertisements_our_clients` WHERE `reference` = 
$web_advertisements_our_clients_reference LIMIT 1

)

) AS monthly_stats_total;

The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info

[PHP-DB] Re: RE: [PHP-WIN] Re: PHP Search DB Table

2010-12-14 Thread Sascha Meyer

Hi Oliver,

Oliver wrote:
> 
> Okay, thank you all again for your input, I have tried a number of
> suggestions to work out what is happening. Just to reiterate here is the 
> search
> form which is on a different page.
> ...

Try the following code on your search page to display GET- and POST-variables 
submitted by your form:
[CODE]
";
print "POST:";
print_r($_POST);
print "";
print "GET:";
print_r($_GET);
print "";
[/CODE]

I couldn't locate an error in your previously posted code so let's give this 
one a try.

Regards, 

Sascha
-- 
Freundliche Grüße / Kind regards,

Sascha Meyer
--
EE:  http://www.experts-exchange.com/M_761556.html
ZCE: http://www.zend.com/en/yellow-pages#show-ClientCandidateID=ZEND011290

GRATIS! Movie-FLAT mit über 300 Videos. 
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: re:[PHP-DB] looking for SQL documentation tool[solved]

2009-04-17 Thread Amit Chaudhary


Is there any tool/utility which can generate the documentation from SQL
Server 2005/2008

SQLDocSharp
An interactive tool designed to generate the SQL Server 2005/2008
documentation.
This is a free solution...!
http://www.amitchaudhary.com/ . 


mrfroasty wrote:
> 
> Thanks guys for the input...really appreciated :-)
> 
> -- 
> Extra details:
> OSS:Gentoo Linux-2.6.25-r8
> profile:x86
> Hardware:msi geforce 8600GT asus p5k-se
> location:/home/muhsin
> language(s):C/C++,VB,VHDL,bash
> Typo:40WPM
> url:http://mambo-tech.net
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/re%3Alooking-for-SQL-documentation-tool-tp22327634p23099016.html
Sent from the Php - Database mailing list archive at Nabble.com.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE : [PHP-DB] Re: RE : Re: [PHP-DB] pg_escape_bytea missing despite Postgre v.7.4.14

2007-03-07 Thread Thomas Woerly

Not at all. No version number for Postgres there.

--- Chris <[EMAIL PROTECTED]> a écrit :

> Thomas Woerly wrote:
> > Hello,
> > 
> > Thanks for you reply. Yeah, sorry for the subjet, wrong manipulation from
> me.
> > 
> > With a phpinfo(), I have pgsql section. Is it ok ? My version of PHP is
> 4.4.2,
> > so this is ok too.
> > 
> > pgsql
> > 
> > PostgreSQL Support  enabled
> > Active Persistent Links 0
> > Active Links0
> > 
> > Directive   Local Value Master Value
> > pgsql.allow_persistent On   On
> > pgsql.auto_reset_persistent Off Off
> > pgsql.ignore_noticeOff  Off
> > pgsql.log_noticeOff Off
> > pgsql.max_links   Unlimited Unlimited
> > pgsql.max_persistentUnlimited   Unlimited
> 
> That looks fine. Does it give you a postgres version number there too?
> 
> -- 
> Postgresql & php tutorials
> http://www.designmagick.com/
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 






___ 
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! 
Profitez des connaissances, des opinions et des expériences des internautes sur 
Yahoo! Questions/Réponses 
http://fr.answers.yahoo.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: RE : Re: [PHP-DB] pg_escape_bytea missing despite Postgre v.7.4.14

2007-03-06 Thread Chris


Thomas Woerly wrote:

Hello,

Thanks for you reply. Yeah, sorry for the subjet, wrong manipulation from me.

With a phpinfo(), I have pgsql section. Is it ok ? My version of PHP is 4.4.2,
so this is ok too.

pgsql

PostgreSQL Support  enabled
Active Persistent Links 0
Active Links0

Directive   Local Value Master Value
pgsql.allow_persistent On   On
pgsql.auto_reset_persistent Off Off
pgsql.ignore_noticeOff  Off
pgsql.log_noticeOff Off
pgsql.max_links   Unlimited Unlimited
pgsql.max_persistentUnlimited   Unlimited


That looks fine. Does it give you a postgres version number there too?

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE : Re: [PHP-DB] pg_escape_bytea missing despite Postgre v.7.4.14

2007-03-06 Thread Thomas Woerly

Hello,

Thanks for you reply. Yeah, sorry for the subjet, wrong manipulation from me.

With a phpinfo(), I have pgsql section. Is it ok ? My version of PHP is 4.4.2,
so this is ok too.

pgsql

PostgreSQL Support  enabled
Active Persistent Links 0
Active Links0

Directive   Local Value Master Value
pgsql.allow_persistent On   On
pgsql.auto_reset_persistent Off Off
pgsql.ignore_noticeOff  Off
pgsql.log_noticeOff Off
pgsql.max_links   Unlimited Unlimited
pgsql.max_persistentUnlimited   Unlimited



--- Chris <[EMAIL PROTECTED]> a écrit :

> 
> > Call to undefined function: pg_escape_bytea()
> > in/home/demo/phpgwapi/inc/adodb/drivers/adodb-postgres64.inc.php on line
> 407
> > 
> > When searching the Web, some say it is due a bad version of PostgreSQL,
> since
> > pg_escape_bytea() arrived at v.7.2.
> > 
> > My Webmin and pg_config --version say I have a 7.4.14 version.
> 
> Firstly please use a more appropriate subject ;) It lets people quickly 
> know if they can help or not.
> 
> Does a phpinfo() page show postgres support working (ie is there a big 
> section called "postgresql") ?
> 
> Specifically what version of php are you using? This function came in at 
> 4.2.0+
> 
> http://php.net/pg_escape_bytea
> 
> -- 
> Postgresql & php tutorials
> http://www.designmagick.com/
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 






___ 
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! 
Profitez des connaissances, des opinions et des expériences des internautes sur 
Yahoo! Questions/Réponses 
http://fr.answers.yahoo.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: RE : RE: [PHP-DB] re: small question php/postgreSQL (basic question, not small)

2006-11-07 Thread JeRRy

True, sorry! (missed that, haha wake up!)


- Original Message 
From: Chris <[EMAIL PROTECTED]>
To: JeRRy <[EMAIL PROTECTED]>
Cc: php-db@lists.php.net
Sent: Wednesday, 8 November, 2006 3:14:01 PM
Subject: Re: [PHP-DB] Re: RE : RE: [PHP-DB] re: small question php/postgreSQL 
(basic question, not small)


JeRRy wrote:
> Test:
> 
> - create a new account user
> - go into the www directive
> - create a index file
> - do phpinfo()
> - try and connect to a msql server, no query needed just a connection
> - under that delibrately try and enter a mysq server but use a wrong pass, 
> make sure you error report it with some message on screen.
> 
> if it connects and one fails your connections are fine.
> 
> However make sure you CLOSE each connection seperatley. 
> 
> What appears to be happening in your code it it's not going near the mysql 
> server, it's skipping it.  Which means the die error will not appear if it 
> skips it.
> 
> Ensure php is enabled and mysql is booted etc.
> 
> Also don't try and connect localhost to it, use the outside world.  (a 
> browser - www.whatever.com or IP-ADDRESS)

Err - the OP is having an issue with postgresql, not mysql. The subject 
even mentions this..

-- 
Postgresql & php tutorials
http://www.designmagick.com/

Re: [PHP-DB] Re: RE : RE: [PHP-DB] re: small question php/postgreSQL (basic question, not small)

2006-11-07 Thread Chris


JeRRy wrote:

Test:

- create a new account user
- go into the www directive
- create a index file
- do phpinfo()
- try and connect to a msql server, no query needed just a connection
- under that delibrately try and enter a mysq server but use a wrong pass, make 
sure you error report it with some message on screen.

if it connects and one fails your connections are fine.

However make sure you CLOSE each connection seperatley. 


What appears to be happening in your code it it's not going near the mysql 
server, it's skipping it.  Which means the die error will not appear if it 
skips it.

Ensure php is enabled and mysql is booted etc.

Also don't try and connect localhost to it, use the outside world.  (a browser 
- www.whatever.com or IP-ADDRESS)


Err - the OP is having an issue with postgresql, not mysql. The subject 
even mentions this..


--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: RE : RE: [PHP-DB] re: small question php/postgreSQL (basic question, not small)

2006-11-07 Thread JeRRy

Test:

- create a new account user
- go into the www directive
- create a index file
- do phpinfo()
- try and connect to a msql server, no query needed just a connection
- under that delibrately try and enter a mysq server but use a wrong pass, make 
sure you error report it with some message on screen.

if it connects and one fails your connections are fine.

However make sure you CLOSE each connection seperatley. 

What appears to be happening in your code it it's not going near the mysql 
server, it's skipping it.  Which means the die error will not appear if it 
skips it.

Ensure php is enabled and mysql is booted etc.

Also don't try and connect localhost to it, use the outside world.  (a browser 
- www.whatever.com or IP-ADDRESS)

J


- Original Message 
From: Desmond Coughlan <[EMAIL PROTECTED]>
To: Bastien Koert <[EMAIL PROTECTED]>; [EMAIL PROTECTED]; php-db@lists.php.net
Sent: Wednesday, 8 November, 2006 2:38:24 AM
Subject: RE : RE: [PHP-DB] re: small question php/postgreSQL (basic question, 
not small)


X-No-Archive: true
 
That doesn't work, either.  Still the blank page.  Hmm ... the file is in the 
right place../usr/local/www/data ... 'cos all of the other files (*.html one an 
d all) are served from there, and they're available to the outside world.
 
D.

Bastien Koert <[EMAIL PROTECTED]> a écrit :
The code does need to know what the fields are...I think a more likely issue 
is the query for some reason, also change the $query to result in the query 
statement

try

$result=pg_query($query) or die(pg_error()); //to see if there are any 
errors with the query

while($row=pg_fetch_array($result,NULL,PGSQL_ASSOC)) {
echo "Title: ".$row['isbn_no']."
";
echo "blah ".$row['code_livre']."
";
}else{
echo "No rows found";
}


bastien


>From: JeRRy 
>To: php-db@lists.php.net
>Subject: [PHP-DB] re: small question php/postgreSQL (basic question, not 
>small)
>Date: Tue, 7 Nov 2006 23:18:58 +1100 (EST)
>
> Date: Tue, 7 Nov 2006 10:38:18 +0100 (CET) From: "Desmond 
>Coughlan" To: "php" 
> Subject: small question php/postgreSQL
> Hi,
>
> I've been trying to get a small DB up and working with PhP. It's a
>library, and so far, I can't get past the stage of displaying a page. I
>try the 'hello world' example, and it displays. I then populate a DB
>and can access it via psql ..
>
> cdi=> SELECT * FROM stock ;
>-[ RECORD 1 ]-+---
>stock_ids | 1
>isbn_no | 10101010
>code_livre | 23455
>titre | toto goes to Hollywood
>editeur | editions toto
>collection | collection toto
>auteur_nom | smith
>auteur_prenom | john
>matiere | ang
>media_type | li
>-[ RECORD 2 ]-+---
>stock_ids | 2
>isbn_no | 10536278
>code_livre | 24874
>titre | toto comes back from Hollywood
>editeur | editions baba
>collection | collection toto
>auteur_nom | martin
>auteur_prenom | peter
>matiere | fre
>media_type | dvd
>
> OK, I then write the following script 
>
> 
> pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't
>Connect: ".pg
>_last_error());
>$query="SELECT * FROM stock";
>$query=pg_query($query);
> // start the output
> while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
>echo "Title: ".$row['isbn_no']."
";
>echo "blah ".$row['code_livre']."
";
>}
> ?>
>
> (sorry not to put that in italics or whatever...)
>
> ... and put it in the document root of my webserver, under
>php_experimental.
>
> I get a blank page. The apache weblogs look like ...
>
> 192.168.0.254 - - [07/Nov/2006:10:37:30 +0100] "GET
>/php_experimental/base.php HTTP/1.1" 200 - "-" "Mozilla/4.0 (compatible; 
>MSIE 6.0;
>Windows NT 5.0)"
>
> There's something obvious that I'm missing. Any ideas ..?
>
>Thanks.
>
>D.
>
>--
>
> re:
>
> 
> pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't
>Connect: ".pg
>_last_error());
>$query="SELECT * FROM stock";
>$query=pg_query($query);
> // start the output
> while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
>echo "Title: ".$row['isbn_no']."
";
>echo "blah ".$row['code_livre']."
";
>}
> ?>
>
> Simple, isbn_no and code_livre need to be "defined" in your code. 
>Otherwise PHP don't know what your looking for.
>
> There is PLENTY of docs online to show you how to display items in a DB. 
> Hello World is basic, too basic to use as an example and is a poor one to 
>use. If your nerw you have to go a bit more into it than Hello World code. 
> (which in my opinion gets you know-where) been there done that.
>
> Google how to display items in a DB in PHP and shoot you get some handy 
>things.
>
> I just feel this question is not required here when google has all the 
>answers like this.
>
> Jerry

_
Ready for the world's first international mobile film festival celebrating 
the creative potential of today's youth? Check out Mobile Jam Fest for your 
a chance to WIN $10,000! www.mobilejamfest.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http:/

Re: [PHP-DB] RE : RE: [PHP-DB] re: small question php/postgreSQL (basic question, not small)

2006-11-07 Thread JeRRy

phpinfo can be a little bit of info that may have a module missing.  But I 
doubt that is the issue here, but you never know.  Why don't be just change 
your query completely like you would in SQL if you were searching direct for 
certain fields?  Because if these 2 fields are the only fields you will EVER 
need in this page why be too technical.  However if your thinking of adding the 
other fields than this is trhe way to go.

I have probably missed something along the traps.  But I am happy to try and 
demonstrate another way you could do it.

Are you on your own server or sub-leased or something?

Jerry


- Original Message 
From: Bastien Koert <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; php-db@lists.php.net
Sent: Wednesday, 8 November, 2006 2:45:49 AM
Subject: RE: [PHP-DB] RE : RE: [PHP-DB] re: small question php/postgreSQL 
(basic question, not small)


is your server set to work with php files?

Bastien


>From: Desmond Coughlan <[EMAIL PROTECTED]>
>To: Bastien Koert <[EMAIL PROTECTED]>, [EMAIL PROTECTED],  
>php-db@lists.php.net
>Subject: [PHP-DB] RE : RE: [PHP-DB] re: small question php/postgreSQL 
>(basic question, not small)
>Date: Tue, 7 Nov 2006 16:38:24 +0100 (CET)
>
>X-No-Archive: true
>
>   That doesn't work, either.  Still the blank page.  Hmm ... the file is 
>in the right place../usr/local/www/data ... 'cos all of the other files 
>(*.html one an d all) are served from there, and they're available to the 
>outside world.
>
>   D.
>
>Bastien Koert <[EMAIL PROTECTED]> a écrit :
>   The code does need to know what the fields are...I think a more likely 
>issue
>is the query for some reason, also change the $query to result in the query
>statement
>
>try
>
>$result=pg_query($query) or die(pg_error()); //to see if there are any
>errors with the query
>
>while($row=pg_fetch_array($result,NULL,PGSQL_ASSOC)) {
>echo "Title: ".$row['isbn_no']."
>";
>echo "blah ".$row['code_livre']."
>";
>}else{
>echo "No rows found";
>}
>
>
>bastien
>
>
> >From: JeRRy
> >To: php-db@lists.php.net
> >Subject: [PHP-DB] re: small question php/postgreSQL (basic question, not
> >small)
> >Date: Tue, 7 Nov 2006 23:18:58 +1100 (EST)
> >
> > Date: Tue, 7 Nov 2006 10:38:18 +0100 (CET) From: "Desmond
> >Coughlan" To: "php"
>
> > Subject: small question php/postgreSQL
> > Hi,
> >
> > I've been trying to get a small DB up and working with PhP. It's a
> >library, and so far, I can't get past the stage of displaying a page. I
> >try the 'hello world' example, and it displays. I then populate a DB
> >and can access it via psql ..
> >
> > cdi=> SELECT * FROM stock ;
> >-[ RECORD 1 ]-+---
> >stock_ids | 1
> >isbn_no | 10101010
> >code_livre | 23455
> >titre | toto goes to Hollywood
> >editeur | editions toto
> >collection | collection toto
> >auteur_nom | smith
> >auteur_prenom | john
> >matiere | ang
> >media_type | li
> >-[ RECORD 2 ]-+---
> >stock_ids | 2
> >isbn_no | 10536278
> >code_livre | 24874
> >titre | toto comes back from Hollywood
> >editeur | editions baba
> >collection | collection toto
> >auteur_nom | martin
> >auteur_prenom | peter
> >matiere | fre
> >media_type | dvd
> >
> > OK, I then write the following script 
> >
> > > pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't
> >Connect: ".pg
> >_last_error());
> >$query="SELECT * FROM stock";
> >$query=pg_query($query);
> > // start the output
> > while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
> >echo "Title: ".$row['isbn_no']."
>";
> >echo "blah ".$row['code_livre']."
>";
> >}
> > ?>
> >
> > (sorry not to put that in italics or whatever...)
> >
> > ... and put it in the document root of my webserver, under
> >php_experimental.
> >
> > I get a blank page. The apache weblogs look like ...
> >
> > 192.168.0.254 - - [07/Nov/2006:10:37:30 +0100] "GET
> >/php_experimental/base.php HTTP/1.1" 200 - "-" "Mozilla/4.0 (compatible;
> >MSIE 6.0;
> >Windows NT 5.0)"
> >
> > There's something obvious that I'm missing. Any ideas ..?
> >
> >Thanks.
> >
> >D.
> >
> >--
> >
> > re:
> >
> > >

RE: [PHP-DB] RE : RE: [PHP-DB] re: small question php/postgreSQL (basic question, not small)

2006-11-07 Thread Dwight Altman

You have
while($row=pg_fetch_array($result,NULL,PGSQL_ASSOC)) {
What's with the NULL ?
row

Row number in result to fetch. Rows are numbered from 0 upwards. If
omitted, next row is fetched.
BUT you are requesting the NULL row?

Why not just use
while($row=pg_fetch_assoc($result)) {



Regards,
Dwight

> -Original Message-
> From: Desmond Coughlan [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 07, 2006 9:38 AM
> To: Bastien Koert; [EMAIL PROTECTED]; php-db@lists.php.net
> Subject: [PHP-DB] RE : RE: [PHP-DB] re: small question php/postgreSQL
> (basic question, not small)
> 
> X-No-Archive: true
> 
>   That doesn't work, either.  Still the blank page.  Hmm ... the file is
> in the right place../usr/local/www/data ... 'cos all of the other files
> (*.html one an d all) are served from there, and they're available to the
> outside world.
> 
>   D.
> 
> Bastien Koert <[EMAIL PROTECTED]> a écrit :
>   The code does need to know what the fields are...I think a more likely
> issue
> is the query for some reason, also change the $query to result in the
> query
> statement
> 
> try
> 
> $result=pg_query($query) or die(pg_error()); //to see if there are any
> errors with the query
> 
> while($row=pg_fetch_array($result,NULL,PGSQL_ASSOC)) {
> echo "Title: ".$row['isbn_no']."
> ";
> echo "blah ".$row['code_livre']."
> ";
> }else{
> echo "No rows found";
> }
> 
> 
> bastien
> 
> 
> >From: JeRRy
> >To: php-db@lists.php.net
> >Subject: [PHP-DB] re: small question php/postgreSQL (basic question, not
> >small)
> >Date: Tue, 7 Nov 2006 23:18:58 +1100 (EST)
> >
> > Date: Tue, 7 Nov 2006 10:38:18 +0100 (CET) From: "Desmond
> >Coughlan" To: "php"
> 
> > Subject: small question php/postgreSQL
> > Hi,
> >
> > I've been trying to get a small DB up and working with PhP. It's a
> >library, and so far, I can't get past the stage of displaying a page. I
> >try the 'hello world' example, and it displays. I then populate a DB
> >and can access it via psql ..
> >
> > cdi=> SELECT * FROM stock ;
> >-[ RECORD 1 ]-+---
> >stock_ids | 1
> >isbn_no | 10101010
> >code_livre | 23455
> >titre | toto goes to Hollywood
> >editeur | editions toto
> >collection | collection toto
> >auteur_nom | smith
> >auteur_prenom | john
> >matiere | ang
> >media_type | li
> >-[ RECORD 2 ]-+---
> >stock_ids | 2
> >isbn_no | 10536278
> >code_livre | 24874
> >titre | toto comes back from Hollywood
> >editeur | editions baba
> >collection | collection toto
> >auteur_nom | martin
> >auteur_prenom | peter
> >matiere | fre
> >media_type | dvd
> >
> > OK, I then write the following script 
> >
> > > pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't
> >Connect: ".pg
> >_last_error());
> >$query="SELECT * FROM stock";
> >$query=pg_query($query);
> > // start the output
> > while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
> >echo "Title: ".$row['isbn_no']."
> ";
> >echo "blah ".$row['code_livre']."
> ";
> >}
> > ?>
> >
> > (sorry not to put that in italics or whatever...)
> >
> > ... and put it in the document root of my webserver, under
> >php_experimental.
> >
> > I get a blank page. The apache weblogs look like ...
> >
> > 192.168.0.254 - - [07/Nov/2006:10:37:30 +0100] "GET
> >/php_experimental/base.php HTTP/1.1" 200 - "-" "Mozilla/4.0 (compatible;
> >MSIE 6.0;
> >Windows NT 5.0)"
> >
> > There's something obvious that I'm missing. Any ideas ..?
> >
> >Thanks.
> >
> >D.
> >
> >--
> >
> > re:
> >
> > > pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't
> >Connect: ".pg
> >_last_error());
> >$query="SELECT * FROM stock";
> >$query=pg_query($query);
> > // start the output
> > while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
> >echo "Title: ".$row['isbn_no']."
> ";
> >echo "blah ".$row['code_livre']."
> ";
> >}
> > ?>
> >
> > Simple, isbn_no and code_livre need to be "defined" in your code.
&g

[PHP-DB] RE : Re: [PHP-DB]: small question php/postgreSQL

2006-11-07 Thread Desmond Coughlan

X-No-Archive:
  
Curious.  I put this in a file... 
   
  Hello World'
  ?>

  Bingo.  
   
  I then take the *same* file, I don't rename it, I just open it in vi.  I copy 
a single occurrence of 'pg_connect' etc... 
   
  And the 'hello world' disappears.  
   
  D.
  

Tony Grimes <[EMAIL PROTECTED]> a écrit :
  Is your server configured to display errors? Try adding this at the top of
your script:

ini_set('display_errors',true);

It won't catch syntax errors, but it should help. Also, try adding this to
the top of your script:

echo 'test';

If you still get a blank page, then it's probably not a problem with your
actual script. Maybe your configuration.

Tony


On 11/7/06 8:38 AM, "Desmond Coughlan" wrote:

> X-No-Archive: true
> 
> That doesn't work, either. Still the blank page. Hmm ... the file is in the
> right place../usr/local/www/data ... 'cos all of the other files (*.html one
> an d all) are served from there, and they're available to the outside world.
> 
> D.
> 
> Bastien Koert a écrit :
> The code does need to know what the fields are...I think a more likely issue
> is the query for some reason, also change the $query to result in the query
> statement
> 
> try
> 
> $result=pg_query($query) or die(pg_error()); //to see if there are any
> errors with the query
> 
> while($row=pg_fetch_array($result,NULL,PGSQL_ASSOC)) {
> echo "Title: ".$row['isbn_no']."
> ";
> echo "blah ".$row['code_livre']."
> ";
> }else{
> echo "No rows found";
> }
> 
> 
> bastien
> 
> 
>> From: JeRRy 
>> To: php-db@lists.php.net
>> Subject: [PHP-DB] re: small question php/postgreSQL (basic question, not
>> small)
>> Date: Tue, 7 Nov 2006 23:18:58 +1100 (EST)
>> 
>> Date: Tue, 7 Nov 2006 10:38:18 +0100 (CET) From: "Desmond
>> Coughlan" To: "php"
> 
>> Subject: small question php/postgreSQL
>> Hi,
>> 
>> I've been trying to get a small DB up and working with PhP. It's a
>> library, and so far, I can't get past the stage of displaying a page. I
>> try the 'hello world' example, and it displays. I then populate a DB
>> and can access it via psql ..
>> 
>> cdi=> SELECT * FROM stock ;
>> -[ RECORD 1 ]-+---
>> stock_ids | 1
>> isbn_no | 10101010
>> code_livre | 23455
>> titre | toto goes to Hollywood
>> editeur | editions toto
>> collection | collection toto
>> auteur_nom | smith
>> auteur_prenom | john
>> matiere | ang
>> media_type | li
>> -[ RECORD 2 ]-+---
>> stock_ids | 2
>> isbn_no | 10536278
>> code_livre | 24874
>> titre | toto comes back from Hollywood
>> editeur | editions baba
>> collection | collection toto
>> auteur_nom | martin
>> auteur_prenom | peter
>> matiere | fre
>> media_type | dvd
>> 
>> OK, I then write the following script 
>> 
>>> pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't
>> Connect: ".pg
>> _last_error());
>> $query="SELECT * FROM stock";
>> $query=pg_query($query);
>> // start the output
>> while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
>> echo "Title: ".$row['isbn_no']."
> ";
>> echo "blah ".$row['code_livre']."
> ";
>> }
>> ?>
>> 
>> (sorry not to put that in italics or whatever...)
>> 
>> ... and put it in the document root of my webserver, under
>> php_experimental.
>> 
>> I get a blank page. The apache weblogs look like ...
>> 
>> 192.168.0.254 - - [07/Nov/2006:10:37:30 +0100] "GET
>> /php_experimental/base.php HTTP/1.1" 200 - "-" "Mozilla/4.0 (compatible;
>> MSIE 6.0;
>> Windows NT 5.0)"
>> 
>> There's something obvious that I'm missing. Any ideas ..?
>> 
>> Thanks.
>> 
>> D.
>> 
>> --
>> 
>> re:
>> 
>>> pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't
>> Connect: ".pg
>> _last_error());
>> $query="SELECT * FROM stock";
>> $query=pg_query($query);
>> // start the output
>> while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
>> echo "Title: ".$row['isbn_no']."
> ";
>> echo "blah ".$row['code_livre']."
> ";
>> }
>> ?>
>> 
>> Simple, isbn_no and code_livre need to be "defined" in your code.
>> Otherwise PHP don't know what your looking for.
>> 
>> There is PLENTY of docs online to show you how to display items in a DB.
>> Hello World is basic, too basic to use as an example and is a poor one to
>> use. If your nerw you have to go a bit more into it than Hello World code.
>> (which in my opinion gets you know-where) been there done that.
>> 
>> Google how to display items in a DB in PHP and shoot you get some handy
>> things.
>> 
>> I just feel this question is not required here when google has all the
>> answers like this.
>> 
>> Jerry
> 
> _
> Ready for the world's first international mobile film festival celebrating
> the creative potential of today's youth? Check out Mobile Jam Fest for your
> a chance to WIN $10,000! www.mobilejamfest.com

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




-
 Découvrez une nouvelle

Re: [PHP-DB] RE : Re: [PHP-DB]: small question php/postgreSQL

2006-11-07 Thread Tony Grimes

Alright, now try commenting out all the script except for the ini_set and
echo 'test' at the top. There still might be a syntax error in the code.

Essentially, you want to do whatever you can to get the page to display a
simple message. Then, work backwards until you get the error/blank page.

If you can't get a message to display, try copying the script from hello.php
to right into your new script. That should give you enough to troubleshoot.

Tony

On 11/7/06 9:00 AM, "Desmond Coughlan" <[EMAIL PROTECTED]> wrote:

> X-No-Archive: true
>  
> OK, that gives a blank page, too... which is puzzling, 'cos I tried
> 'hello.php' before getting into the db 'thang', and I saw the text on the
> screen.
>  
> Well .. back to the drawing board...
>  
> D.
> 
> Tony Grimes <[EMAIL PROTECTED]> a écrit :
> Is your server configured to display errors? Try adding this at the top of
> your script:
> 
> ini_set('display_errors',true);
> 
> It won't catch syntax errors, but it should help. Also, try adding this to
> the top of your script:
> 
> echo 'test';
> 
> If you still get a blank page, then it's probably not a problem with your
> actual script. Maybe your configuration.
> 
> Tony
> 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE : Re: [PHP-DB]: small question php/postgreSQL

2006-11-07 Thread Desmond Coughlan

X-No-Archive: true
   
  OK, that gives a blank page, too... which is puzzling, 'cos I tried 
'hello.php' before getting into the db 'thang', and I saw the text on the 
screen.
   
  Well .. back to the drawing board... 
   
  D.

Tony Grimes <[EMAIL PROTECTED]> a écrit :
  Is your server configured to display errors? Try adding this at the top of
your script:

ini_set('display_errors',true);

It won't catch syntax errors, but it should help. Also, try adding this to
the top of your script:

echo 'test';

If you still get a blank page, then it's probably not a problem with your
actual script. Maybe your configuration.

Tony


On 11/7/06 8:38 AM, "Desmond Coughlan" wrote:

> X-No-Archive: true
> 
> That doesn't work, either. Still the blank page. Hmm ... the file is in the
> right place../usr/local/www/data ... 'cos all of the other files (*.html one
> an d all) are served from there, and they're available to the outside world.
> 
> D.
> 
> Bastien Koert a écrit :
> The code does need to know what the fields are...I think a more likely issue
> is the query for some reason, also change the $query to result in the query
> statement
> 
> try
> 
> $result=pg_query($query) or die(pg_error()); //to see if there are any
> errors with the query
> 
> while($row=pg_fetch_array($result,NULL,PGSQL_ASSOC)) {
> echo "Title: ".$row['isbn_no']."
> ";
> echo "blah ".$row['code_livre']."
> ";
> }else{
> echo "No rows found";
> }
> 
> 
> bastien
> 
> 
>> From: JeRRy 
>> To: php-db@lists.php.net
>> Subject: [PHP-DB] re: small question php/postgreSQL (basic question, not
>> small)
>> Date: Tue, 7 Nov 2006 23:18:58 +1100 (EST)
>> 
>> Date: Tue, 7 Nov 2006 10:38:18 +0100 (CET) From: "Desmond
>> Coughlan" To: "php"
> 
>> Subject: small question php/postgreSQL
>> Hi,
>> 
>> I've been trying to get a small DB up and working with PhP. It's a
>> library, and so far, I can't get past the stage of displaying a page. I
>> try the 'hello world' example, and it displays. I then populate a DB
>> and can access it via psql ..
>> 
>> cdi=> SELECT * FROM stock ;
>> -[ RECORD 1 ]-+---
>> stock_ids | 1
>> isbn_no | 10101010
>> code_livre | 23455
>> titre | toto goes to Hollywood
>> editeur | editions toto
>> collection | collection toto
>> auteur_nom | smith
>> auteur_prenom | john
>> matiere | ang
>> media_type | li
>> -[ RECORD 2 ]-+---
>> stock_ids | 2
>> isbn_no | 10536278
>> code_livre | 24874
>> titre | toto comes back from Hollywood
>> editeur | editions baba
>> collection | collection toto
>> auteur_nom | martin
>> auteur_prenom | peter
>> matiere | fre
>> media_type | dvd
>> 
>> OK, I then write the following script 
>> 
>>> pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't
>> Connect: ".pg
>> _last_error());
>> $query="SELECT * FROM stock";
>> $query=pg_query($query);
>> // start the output
>> while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
>> echo "Title: ".$row['isbn_no']."
> ";
>> echo "blah ".$row['code_livre']."
> ";
>> }
>> ?>
>> 
>> (sorry not to put that in italics or whatever...)
>> 
>> ... and put it in the document root of my webserver, under
>> php_experimental.
>> 
>> I get a blank page. The apache weblogs look like ...
>> 
>> 192.168.0.254 - - [07/Nov/2006:10:37:30 +0100] "GET
>> /php_experimental/base.php HTTP/1.1" 200 - "-" "Mozilla/4.0 (compatible;
>> MSIE 6.0;
>> Windows NT 5.0)"
>> 
>> There's something obvious that I'm missing. Any ideas ..?
>> 
>> Thanks.
>> 
>> D.
>> 
>> --
>> 
>> re:
>> 
>>> pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't
>> Connect: ".pg
>> _last_error());
>> $query="SELECT * FROM stock";
>> $query=pg_query($query);
>> // start the output
>> while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
>> echo "Title: ".$row['isbn_no']."
> ";
>> echo "blah ".$row['code_livre']."
> ";
>> }
>> ?>
>> 
>> Simple, isbn_no and code_livre need to be "defined" in your code.
>> Otherwise PHP don't know what your looking for.
>> 
>> There is PLENTY of docs online to show you how to display items in a DB.
>> Hello World is basic, too basic to use as an example and is a poor one to
>> use. If your nerw you have to go a bit more into it than Hello World code.
>> (which in my opinion gets you know-where) been there done that.
>> 
>> Google how to display items in a DB in PHP and shoot you get some handy
>> things.
>> 
>> I just feel this question is not required here when google has all the
>> answers like this.
>> 
>> Jerry
> 
> _
> Ready for the world's first international mobile film festival celebrating
> the creative potential of today's youth? Check out Mobile Jam Fest for your
> a chance to WIN $10,000! www.mobilejamfest.com

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




-- 
Des Coughlan 
  [EMAIL PROTECTED]

  "Un client de plus, c'est un relou de plus..."

[PHP-DB] RE : RE: [PHP-DB] RE : RE: [PHP-DB] re: small question php/postgreSQL (basic question, not small)

2006-11-07 Thread Desmond Coughlan

X-No-Archive: true
   
  Yep.  The famous phpinfo file works like a charm.
  
D.
   
  
Bastien Koert <[EMAIL PROTECTED]> a écrit :
  is your server set to work with php files?

Bastien


>From: Desmond Coughlan 
>To: Bastien Koert , [EMAIL PROTECTED], 
>php-db@lists.php.net
>Subject: [PHP-DB] RE : RE: [PHP-DB] re: small question php/postgreSQL 
>(basic question, not small)
>Date: Tue, 7 Nov 2006 16:38:24 +0100 (CET)
>
>X-No-Archive: true
>
> That doesn't work, either. Still the blank page. Hmm ... the file is 
>in the right place../usr/local/www/data ... 'cos all of the other files 
>(*.html one an d all) are served from there, and they're available to the 
>outside world.
>
> D.
>
>Bastien Koert a écrit :
> The code does need to know what the fields are...I think a more likely 
>issue
>is the query for some reason, also change the $query to result in the query
>statement
>
>try
>
>$result=pg_query($query) or die(pg_error()); //to see if there are any
>errors with the query
>
>while($row=pg_fetch_array($result,NULL,PGSQL_ASSOC)) {
>echo "Title: ".$row['isbn_no']."
>";
>echo "blah ".$row['code_livre']."
>";
>}else{
>echo "No rows found";
>}
>
>
>bastien
>
>
> >From: JeRRy
> >To: php-db@lists.php.net
> >Subject: [PHP-DB] re: small question php/postgreSQL (basic question, not
> >small)
> >Date: Tue, 7 Nov 2006 23:18:58 +1100 (EST)
> >
> > Date: Tue, 7 Nov 2006 10:38:18 +0100 (CET) From: "Desmond
> >Coughlan" To: "php"
>
> > Subject: small question php/postgreSQL
> > Hi,
> >
> > I've been trying to get a small DB up and working with PhP. It's a
> >library, and so far, I can't get past the stage of displaying a page. I
> >try the 'hello world' example, and it displays. I then populate a DB
> >and can access it via psql ..
> >
> > cdi=> SELECT * FROM stock ;
> >-[ RECORD 1 ]-+---
> >stock_ids | 1
> >isbn_no | 10101010
> >code_livre | 23455
> >titre | toto goes to Hollywood
> >editeur | editions toto
> >collection | collection toto
> >auteur_nom | smith
> >auteur_prenom | john
> >matiere | ang
> >media_type | li
> >-[ RECORD 2 ]-+---
> >stock_ids | 2
> >isbn_no | 10536278
> >code_livre | 24874
> >titre | toto comes back from Hollywood
> >editeur | editions baba
> >collection | collection toto
> >auteur_nom | martin
> >auteur_prenom | peter
> >matiere | fre
> >media_type | dvd
> >
> > OK, I then write the following script 
> >
> > > pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't
> >Connect: ".pg
> >_last_error());
> >$query="SELECT * FROM stock";
> >$query=pg_query($query);
> > // start the output
> > while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
> >echo "Title: ".$row['isbn_no']."
>";
> >echo "blah ".$row['code_livre']."
>";
> >}
> > ?>
> >
> > (sorry not to put that in italics or whatever...)
> >
> > ... and put it in the document root of my webserver, under
> >php_experimental.
> >
> > I get a blank page. The apache weblogs look like ...
> >
> > 192.168.0.254 - - [07/Nov/2006:10:37:30 +0100] "GET
> >/php_experimental/base.php HTTP/1.1" 200 - "-" "Mozilla/4.0 (compatible;
> >MSIE 6.0;
> >Windows NT 5.0)"
> >
> > There's something obvious that I'm missing. Any ideas ..?
> >
> >Thanks.
> >
> >D.
> >
> >--
> >
> > re:
> >
> > > pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't
> >Connect: ".pg
> >_last_error());
> >$query="SELECT * FROM stock";
> >$query=pg_query($query);
> > // start the output
> > while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
> >echo "Title: ".$row['isbn_no']."
>";
> >echo "blah ".$row['code_livre']."
>";
> >}
> > ?>
> >
> > Simple, isbn_no and code_livre need to be "defined" in your code.
> >Otherwise PHP don't know what your looking for.
> >
> > There is PLENTY of docs online to show you how to display items in a DB.
> > Hello World is basic, too basic to use as an example and is a poor one 
>to
> >us

RE: [PHP-DB] RE : RE: [PHP-DB] re: small question php/postgreSQL (basic question, not small)

2006-11-07 Thread Bastien Koert


is your server set to work with php files?

Bastien



From: Desmond Coughlan <[EMAIL PROTECTED]>
To: Bastien Koert <[EMAIL PROTECTED]>, [EMAIL PROTECTED],  
php-db@lists.php.net
Subject: [PHP-DB] RE : RE: [PHP-DB] re: small question php/postgreSQL 
(basic question, not small)

Date: Tue, 7 Nov 2006 16:38:24 +0100 (CET)

X-No-Archive: true

  That doesn't work, either.  Still the blank page.  Hmm ... the file is 
in the right place../usr/local/www/data ... 'cos all of the other files 
(*.html one an d all) are served from there, and they're available to the 
outside world.


  D.

Bastien Koert <[EMAIL PROTECTED]> a écrit :
  The code does need to know what the fields are...I think a more likely 
issue

is the query for some reason, also change the $query to result in the query
statement

try

$result=pg_query($query) or die(pg_error()); //to see if there are any
errors with the query

while($row=pg_fetch_array($result,NULL,PGSQL_ASSOC)) {
echo "Title: ".$row['isbn_no']."
";
echo "blah ".$row['code_livre']."
";
}else{
echo "No rows found";
}


bastien


>From: JeRRy
>To: php-db@lists.php.net
>Subject: [PHP-DB] re: small question php/postgreSQL (basic question, not
>small)
>Date: Tue, 7 Nov 2006 23:18:58 +1100 (EST)
>
> Date: Tue, 7 Nov 2006 10:38:18 +0100 (CET) From: "Desmond
>Coughlan" To: "php"

> Subject: small question php/postgreSQL
> Hi,
>
> I've been trying to get a small DB up and working with PhP. It's a
>library, and so far, I can't get past the stage of displaying a page. I
>try the 'hello world' example, and it displays. I then populate a DB
>and can access it via psql ..
>
> cdi=> SELECT * FROM stock ;
>-[ RECORD 1 ]-+---
>stock_ids | 1
>isbn_no | 10101010
>code_livre | 23455
>titre | toto goes to Hollywood
>editeur | editions toto
>collection | collection toto
>auteur_nom | smith
>auteur_prenom | john
>matiere | ang
>media_type | li
>-[ RECORD 2 ]-+---
>stock_ids | 2
>isbn_no | 10536278
>code_livre | 24874
>titre | toto comes back from Hollywood
>editeur | editions baba
>collection | collection toto
>auteur_nom | martin
>auteur_prenom | peter
>matiere | fre
>media_type | dvd
>
> OK, I then write the following script 
>
> > pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't
>Connect: ".pg
>_last_error());
>$query="SELECT * FROM stock";
>$query=pg_query($query);
> // start the output
> while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
>echo "Title: ".$row['isbn_no']."
";
>echo "blah ".$row['code_livre']."
";
>}
> ?>
>
> (sorry not to put that in italics or whatever...)
>
> ... and put it in the document root of my webserver, under
>php_experimental.
>
> I get a blank page. The apache weblogs look like ...
>
> 192.168.0.254 - - [07/Nov/2006:10:37:30 +0100] "GET
>/php_experimental/base.php HTTP/1.1" 200 - "-" "Mozilla/4.0 (compatible;
>MSIE 6.0;
>Windows NT 5.0)"
>
> There's something obvious that I'm missing. Any ideas ..?
>
>Thanks.
>
>D.
>
>--
>
> re:
>
> > pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't
>Connect: ".pg
>_last_error());
>$query="SELECT * FROM stock";
>$query=pg_query($query);
> // start the output
> while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
>echo "Title: ".$row['isbn_no']."
";
>echo "blah ".$row['code_livre']."
";
>}
> ?>
>
> Simple, isbn_no and code_livre need to be "defined" in your code.
>Otherwise PHP don't know what your looking for.
>
> There is PLENTY of docs online to show you how to display items in a DB.
> Hello World is basic, too basic to use as an example and is a poor one 
to
>use. If your nerw you have to go a bit more into it than Hello World 
code.

> (which in my opinion gets you know-where) been there done that.
>
> Google how to display items in a DB in PHP and shoot you get some handy
>things.
>
> I just feel this question is not required here when google has all the
>answers like this.
>
> Jerry

_
Ready for the world's first international mobile film festival celebrating
the creative potential of today's youth? Check out Mobile Jam Fest for your
a chance to WIN $10,000! www.mobilejamfest.com

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




-
 Découvrez une nouvelle façon d'obtenir des réponses à toutes vos 
questions ! Profitez des connaissances, des opinions et des expériences des 
internautes sur Yahoo! Questions/Réponses.


_
Not only does Windows Live OneCare provide all-in-one PC care to keep your 
computer protected and well-maintained, but it also makes creating backup 
files a breeze. Try it today! 
http://ideas.live.com/programpage.aspx?versionid=b2456790-90e6-4d28-9219-5d7207d94d45&mkt=en-ca


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE : RE: [PHP-DB] re: small question php/postgreSQL (basic question, not small)

2006-11-07 Thread Desmond Coughlan

X-No-Archive: true
   
  That doesn't work, either.  Still the blank page.  Hmm ... the file is in the 
right place../usr/local/www/data ... 'cos all of the other files (*.html one an 
d all) are served from there, and they're available to the outside world.
   
  D.

Bastien Koert <[EMAIL PROTECTED]> a écrit :
  The code does need to know what the fields are...I think a more likely issue 
is the query for some reason, also change the $query to result in the query 
statement

try

$result=pg_query($query) or die(pg_error()); //to see if there are any 
errors with the query

while($row=pg_fetch_array($result,NULL,PGSQL_ASSOC)) {
echo "Title: ".$row['isbn_no']."
";
echo "blah ".$row['code_livre']."
";
}else{
echo "No rows found";
}


bastien


>From: JeRRy 
>To: php-db@lists.php.net
>Subject: [PHP-DB] re: small question php/postgreSQL (basic question, not 
>small)
>Date: Tue, 7 Nov 2006 23:18:58 +1100 (EST)
>
> Date: Tue, 7 Nov 2006 10:38:18 +0100 (CET) From: "Desmond 
>Coughlan" To: "php" 

> Subject: small question php/postgreSQL
> Hi,
>
> I've been trying to get a small DB up and working with PhP. It's a
>library, and so far, I can't get past the stage of displaying a page. I
>try the 'hello world' example, and it displays. I then populate a DB
>and can access it via psql ..
>
> cdi=> SELECT * FROM stock ;
>-[ RECORD 1 ]-+---
>stock_ids | 1
>isbn_no | 10101010
>code_livre | 23455
>titre | toto goes to Hollywood
>editeur | editions toto
>collection | collection toto
>auteur_nom | smith
>auteur_prenom | john
>matiere | ang
>media_type | li
>-[ RECORD 2 ]-+---
>stock_ids | 2
>isbn_no | 10536278
>code_livre | 24874
>titre | toto comes back from Hollywood
>editeur | editions baba
>collection | collection toto
>auteur_nom | martin
>auteur_prenom | peter
>matiere | fre
>media_type | dvd
>
> OK, I then write the following script 
>
> > pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't
>Connect: ".pg
>_last_error());
>$query="SELECT * FROM stock";
>$query=pg_query($query);
> // start the output
> while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
>echo "Title: ".$row['isbn_no']."
";
>echo "blah ".$row['code_livre']."
";
>}
> ?>
>
> (sorry not to put that in italics or whatever...)
>
> ... and put it in the document root of my webserver, under
>php_experimental.
>
> I get a blank page. The apache weblogs look like ...
>
> 192.168.0.254 - - [07/Nov/2006:10:37:30 +0100] "GET
>/php_experimental/base.php HTTP/1.1" 200 - "-" "Mozilla/4.0 (compatible; 
>MSIE 6.0;
>Windows NT 5.0)"
>
> There's something obvious that I'm missing. Any ideas ..?
>
>Thanks.
>
>D.
>
>--
>
> re:
>
> > pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't
>Connect: ".pg
>_last_error());
>$query="SELECT * FROM stock";
>$query=pg_query($query);
> // start the output
> while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
>echo "Title: ".$row['isbn_no']."
";
>echo "blah ".$row['code_livre']."
";
>}
> ?>
>
> Simple, isbn_no and code_livre need to be "defined" in your code. 
>Otherwise PHP don't know what your looking for.
>
> There is PLENTY of docs online to show you how to display items in a DB. 
> Hello World is basic, too basic to use as an example and is a poor one to 
>use. If your nerw you have to go a bit more into it than Hello World code. 
> (which in my opinion gets you know-where) been there done that.
>
> Google how to display items in a DB in PHP and shoot you get some handy 
>things.
>
> I just feel this question is not required here when google has all the 
>answers like this.
>
> Jerry

_
Ready for the world's first international mobile film festival celebrating 
the creative potential of today's youth? Check out Mobile Jam Fest for your 
a chance to WIN $10,000! www.mobilejamfest.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




-
 Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! 
Profitez des connaissances, des opinions et des expériences des internautes sur 
Yahoo! Questions/Réponses.

Re: [PHP-DB] Re: Re: Sending filing attachments using PHP

2006-05-16 Thread Julien Bonastre

Just wanted to ^bump^ this ridiculously prolonged flame-like thread 
which will surely be annulled in the chronicles of PHP history




;-)




Michelle Konzack wrote:


Am 2006-05-12 11:58:37, schrieb JupiterHost.Net:



I was referring to building PHP/Apache in general *



What do you talking about?  --  I have compiled Apache and
php5 the standard way and ABSOLUTLY NOTHING was missing.


Great, I'm talking about managing multiple servers with multi needs. 
Generally its a cludge. If you have to build it only one a hadnfull of 
servers only when updates come upt, super.


listen on a port lower than 1024, which is true for all tools since 
it's a platform limitation.


* I'm speaking in generalitites of working with PHP not specifics 
components of the technology.



???


Generally: PHP is more prone to have the "true for all tools" 
probelms.


Yeah, you're definitely smoking somethin'. The PEAR package 
Mail_Mime is another example of a pure-php class. It certainly does 
not use anything perl related at all. I'd really like to know what 
makes you think it does.


I never said PEAR or any specific package used Perl, I'd simply 
offered a better solution that happend to be done in Perl.



No, it is NOT a better solution, because if I use perl I
have to maintain TWO scripting languages and install I do
not know how many modules from CPAN...  maybe 100-200?


I install about 10 generally. I think you're starting to get into a 
"my dad can beat up your dad" thing which is pointless.



Good day to all, sorry if I was to ambiguouse or I've offended.



Good by!


Seriously, chill, I wasn't getting personal. Reckon I touched a nerve.

Its too bad if you don't want to consider another idea. your loss not 
mine :)


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.1.392 / Virus Database: 268.5.6/340 - Release Date: 
15/05/2006






--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.392 / Virus Database: 268.5.6/340 - Release Date: 15/05/2006

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Re: Sending filing attachments using PHP

2006-05-15 Thread JupiterHost.Net




Michelle Konzack wrote:


Am 2006-05-12 11:58:37, schrieb JupiterHost.Net:



I was referring to building PHP/Apache in general *



What do you talking about?  --  I have compiled Apache and
php5 the standard way and ABSOLUTLY NOTHING was missing.


Great, I'm talking about managing multiple servers with multi needs. 
Generally its a cludge. If you have to build it only one a hadnfull of 
servers only when updates come upt, super.


listen on a port lower than 1024, which is true for all tools since it's 
a platform limitation.


* I'm speaking in generalitites of working with PHP not specifics 
components of the technology.



???


Generally: PHP is more prone to have the "true for all tools" probelms.

Yeah, you're definitely smoking somethin'. The PEAR package Mail_Mime is 
another example of a pure-php class. It certainly does not use anything 
perl related at all. I'd really like to know what makes you think it does.


I never said PEAR or any specific package used Perl, I'd simply offered 
a better solution that happend to be done in Perl.



No, it is NOT a better solution, because if I use perl I
have to maintain TWO scripting languages and install I do
not know how many modules from CPAN...  maybe 100-200?


I install about 10 generally. I think you're starting to get into a "my 
dad can beat up your dad" thing which is pointless.



Good day to all, sorry if I was to ambiguouse or I've offended.



Good by!


Seriously, chill, I wasn't getting personal. Reckon I touched a nerve.

Its too bad if you don't want to consider another idea. your loss not 
mine :)


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Re: Sending filing attachments using PHP

2006-05-15 Thread Michelle Konzack

Am 2006-05-12 11:58:37, schrieb JupiterHost.Net:

> I was referring to building PHP/Apache in general *

What do you talking about?  --  I have compiled Apache and
php5 the standard way and ABSOLUTLY NOTHING was missing.

> >listen on a port lower than 1024, which is true for all tools since it's 
> >a platform limitation.
> 
> * I'm speaking in generalitites of working with PHP not specifics 
> components of the technology.

???

> >Yeah, you're definitely smoking somethin'. The PEAR package Mail_Mime is 
> >another example of a pure-php class. It certainly does not use anything 
> >perl related at all. I'd really like to know what makes you think it does.
> 
> I never said PEAR or any specific package used Perl, I'd simply offered 
> a better solution that happend to be done in Perl.

No, it is NOT a better solution, because if I use perl I
have to maintain TWO scripting languages and install I do
not know how many modules from CPAN...  maybe 100-200?

> Good day to all, sorry if I was to ambiguouse or I've offended.

Good by!



-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/
# Debian GNU/Linux Consultant #
Michelle Konzack   Apt. 917  ICQ #328449886
   50, rue de Soultz MSM LinuxMichi
0033/6/6192519367100 Strasbourg/France   IRC #Debian (irc.icq.com)

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Re: Storing Credit Cards, Passwords, Securely, two-wayencryption

2006-01-09 Thread Dan Baker

> On 1/9/06, Dan Baker <[EMAIL PROTECTED]> wrote: And last of all, I 
> know of a pretty large company that uses a service
> similar to VeriSign.  This other service (can't remember the name) didn't
> provide the "PNRef" scenario, so the company stores credit card numbers in 
> their database (encrypted of course), and they just run the numbers every
> month for their service.  Seems to be working ok for them.  I don't know 
> who
> wrote their software, what encryption they are using, where the data is 
> stored, how it is backed up -- I guess I don't know anything except they 
> are
> storing credit card numbers and are currently doing a good business. DanB

> This confuses me, I thought storing the CSC was illegal?
> Don't you need that to run the card?
>
> Charles Morris
> [EMAIL PROTECTED]

The CSC (Card Security Code) or CVV (Card Verification Value) is NOT needed 
to run any credit cards.  It is simply a method to increase the likelihood 
that the human at the other end of the transaction actually has the phyiscal 
card.  Storing CSC/CVV's is illegal.  I believe that even places like 
VeriSign do not store the CSC.  Really, the only information you need to run 
a credit card is the number and expiration date (although you will pay a 
higher %).

DanB

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Re: Storing Credit Cards, Passwords, Securely, two-wayencryption

2006-01-09 Thread Dan Baker

"Peter Beckman" <[EMAIL PROTECTED]> wrote in message 
news:[EMAIL PROTECTED]
> On Fri, 6 Jan 2006, Dan Baker wrote:
>
>> "Peter Beckman" <[EMAIL PROTECTED]> wrote in message
>> news:[EMAIL PROTECTED]
>>> So I'm thinking about how to save credit card numbers in the DB, for
>>> re-charging cards for subscriptions, new orders, etc.
>>>
>>> I'm also thinking about how to save passwords in the DB, not plaintext,
>>> but
>>> not one-way encrypted either.
>>>
>>> Any suggestions?  How would I secure the database?  I'm thinking some
>>> abstract process in code, or something -- security through obscurity.
>>
>> [Summary: Call Verisign, pay THEM to store credit cards for you]
>
>  What, exactly, does VeriSign do, that makes you so sure that they have
>  secured the credit card information any better than I could, using a
>  well-thought-out system?  Do you even know?  You just hear "VeriSign" and
>  believe they have smart people that have more resources available to them
>  to do a better job securing the data?
>
>  Maybe this makes sense if you are doing a few hundred or a few thousand
>  dollars of business a month, but if you are planning on doing $5,000 to
>  $10,000 a day, it is a lot of added expense to have someone else do it,
>  when I could have it done internally.  It is the how.
>
>  Please, no more replies saying don't do it.

VeriSign (and other similar organizations) have pro's and con's.  Obviously, 
the con's are usually tied to the big $.
VeriSign costs $70/month (for the first 1000 transactions per month).  My 
company is in the 1000 transaction per month range, but I think each 
transaction after that is $0.10.  BTW, VeriSign was just bought by PayPal.

You have to pay every credit card company you do business with, no mater 
what solution to select.  Usually a % of the total charges.  If you do 
enough business per card, your % drops.  Also, if you don't include enough 
information with each transaction, your % will be increased.  The most 
important information you need to include is: billing address and billing 
zip code -- most credit card company's won't increase your % if you provide 
these two pieces of information per transaction. CSC's (CVV2) are usually 
not tied to your % payment, and it is illegal to store them.

You ask: "What exactly does VeriSign do?"  I don't know.  I pay them $70 
each month, and they process my credit cards.  I know they have been in the 
business a long time, and experience means a lot (to me).  Some how, I can 
re-run a charge on an already-run credit card, and they magically know all 
the information for that credit card (including the CSC).  We sell a service 
that people pay monthly for, and we make up the $70 to VeriSign in reduced 
%.

You mentioned that it "makes sense if you are doing a few hundred dollars a 
month".  This seems backward to me.  It is too expensive if you only doing a 
few hundred dollars a month.  The $70 a month disappears as you do *more* 
business.  If you are doing $10,000 a day, you need to call each credit card 
company you do business with (Amex, Discover) and ask for a "Rate Review". 
They will surely drop their % if you are doing that kind of volume.  We just 
had a rate review with Amex, and our rate dropped significantly.

Oh --- You also need to check on your merchant account.  They usually hit 
you per transaction.  This is were the $ can start to add up!  Your merchant 
account may also be handing your Visa/MC transactions, and taking a % of 
those -- so ask for a rate review from them also.

And last of all, I know of a pretty large company that uses a service 
similar to VeriSign.  This other service (can't remember the name) didn't 
provide the "PNRef" scenario, so the company stores credit card numbers in 
their database (encrypted of course), and they just run the numbers every 
month for their service.  Seems to be working ok for them.  I don't know who 
wrote their software, what encryption they are using, where the data is 
stored, how it is backed up -- I guess I don't know anything except they are 
storing credit card numbers and are currently doing a good business.  Funny, 
they are still paying for a similar service to VeriSign.

DanB

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Re: November 2, 2004

2004-11-02 Thread rik onckelinx

Would you please stop bombing me with those unrelevant e-mails on a php 
mailinglist. It doesn't matter if I care about the US elections or not. 

I prefer to read your brilliant php code instead of politics.

With me many others on the list.

Rik

Op dinsdag 2 november 2004 10:25, schreef Michelle Konzack:
> Am 2004-11-02 03:06:35, schrieb GH:
> > and by the way the main reason we have problems  in America
> >
> >   * People with out health insurance
>
> This is every countries own problem...
> In Europe ALL People has a "health insurance".
>
> >   * No affordable housing
>
> Is this my problem ?
>
> >   * and a huge debt
>
> Do not play WAR with innocents.
>
> >   * amongst others
>
> Who ?
>
> > is because we give aid to almost any country who asks for it and
>
> Who ask for you ?  -  NOBODY.
>
> Americans are egoists and they are afraid they must play alone like
> a little children... America is fare from Europe and much more from
> Near East.
>
> > allow them to take the American's jobs...
>
> Rassist ?
>
> > Just a thought
>
> Greetings
> Michelle

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Re: November 2, 2004

2004-11-02 Thread Michelle Konzack

Am 2004-11-02 03:06:35, schrieb GH:
> and by the way the main reason we have problems  in America 
> 
>   * People with out health insurance

This is every countries own problem...
In Europe ALL People has a "health insurance". 

>   * No affordable housing

Is this my problem ?

>   * and a huge debt  

Do not play WAR with innocents.

>   * amongst others

Who ?

> is because we give aid to almost any country who asks for it and

Who ask for you ?  -  NOBODY. 

Americans are egoists and they are afraid they must play alone like
a little children... America is fare from Europe and much more from
Near East.

> allow them to take the American's jobs...

Rassist ?

> Just a thought

Greetings
Michelle

-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/ 
Michelle Konzack   Apt. 917  ICQ #328449886
   50, rue de Soultz MSM LinuxMichi
0033/3/8845235667100 Strasbourg/France   IRC #Debian (irc.icq.com)


signature.pgp
Description: Digital signature

[PHP-DB] Re: Re: November 2, 2004

2004-11-02 Thread Michelle Konzack

Am 2004-11-02 03:04:10, schrieb GH:
> However, when other countries are in trouble or need something... who
> do they turn to? America

Are you sure ?
Its only you American(s) which think so.

> Therefore everyone in the world has an interest in what happens in the
> american body politic just as Americans have an interest in what
> happens to the British Prime Minister and in parts of the British body
> politic.

But in FR/DE we p***s on you americans...

We do not like to play WARGAMES for Petrol and Profit !!!

Greetings
Michelle

-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/ 
Michelle Konzack   Apt. 917  ICQ #328449886
   50, rue de Soultz MSM LinuxMichi
0033/3/8845235667100 Strasbourg/France   IRC #Debian (irc.icq.com)


signature.pgp
Description: Digital signature

[PHP-DB] Re: Re: November 2, 2004

2004-11-02 Thread Michelle Konzack

Am 2004-11-01 19:30:50, schrieb Joseph Crawford:
> > Do we care? Realy? Unlikely. Maybe you should send your 'useful' info on
> >   a national mailinglist only.
> 
> i am sorry but i do care, if you do not care about voting you dont
> care if the war comes to the US.

Maybe, but I am in France !!!

It is enough if I see every day in TV how many Iraqis-Children
(around 17.000 curently) are killed by American Commandos. 

Political stuff has nothing to do on this list !!!

Greetings
Michelle

-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/ 
Michelle Konzack   Apt. 917  ICQ #328449886
   50, rue de Soultz MSM LinuxMichi
0033/3/8845235667100 Strasbourg/France   IRC #Debian (irc.icq.com)


signature.pgp
Description: Digital signature

[PHP-DB] Re: Re: November 2, 2004

2004-11-02 Thread Michelle Konzack

Am 2004-11-02 07:22:13, schrieb Lester Caine:

> There are many more of us who do not have the right to vote in the US, 
> just as we do not have the right to claim our 3.5% guaranteed mortgage. 
> Americans need to start thinking about OTHER countries rather than 
> assuming that they can just bombard every list with 'relevant' 
> information that is totally irrelevant to the rest of the world.
> 
> THAT is one of the major reasons the rest of the world gets p*d of 
> Americans ;)

Agreed.

Greetings
Michelle

-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/ 
Michelle Konzack   Apt. 917  ICQ #328449886
   50, rue de Soultz MSM LinuxMichi
0033/3/8845235667100 Strasbourg/France   IRC #Debian (irc.icq.com)


signature.pgp
Description: Digital signature

[PHP-DB] Re :Re: [PHP-DB] How use select for update

2004-09-16 Thread Chris

Escuse me i forgot the "t"

> Is row-level locking happening?
> I think that the lock doesn t work
>
> When are you checking the locks?
> I am checking the lock with an SQLPLUS session
>
> If i lock my table with SQLPLUS, PHP can make an select for update
> But if i try to lock with PHP i can make an other select for update
with
> sqlplus
> So my lock doesn t work
>

If i lock my table with SQLPLUS, PHP can T make an select for update


I have the same code
   $query = 'select * from emp for update nowait';
   $stid = OCIParse($conn, $query);
   $r = OCIExecute($stid, OCI_DEFAULT);

But my problem, it s that i can t lock my table with PHP
I haven t problem with SQLPLUS

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Re: $_Session vs $_Cookie

2004-05-31 Thread Torsten Roehr

"Alexey Kupershtokh" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi.
>
> > Is your server running on Windows? Have you tried using a database as
your
> > session container?
>
> Hmm... that's something new for me :) How to implement it ? Manually ? Or
it
> is available in php config file?
> Or another question: where I can read about this ? :)

Hi Alexey,

it's pretty simple. I'm using PEAR's HTTP_Session in combination with
PEAR::DB:
http://pear.php.net/package/DB
http://pear.php.net/package/HTTP_Session

Just set those two packages up, create a session table (see
HTTP_Session/Container/DB.php for the schema) and set this HTTP_Session
option:
HTTP_Session::setContainer('DB', array('dsn' => $dsn, 'table' => 'sessions',
'autooptimize' => true));

...and off you go.

Storing session data in a database has some advances over the standard file
based solution, mainly data security und comfort. For example, if you want
to get the number of the active sessions just do a simple select count(*)
from sessions.

Bets regards, Torsten

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Re: $_Session vs $_Cookie

2004-05-31 Thread Alexey Kupershtokh

Hi.

> Is your server running on Windows? Have you tried using a database as your
> session container?

Hmm... that's something new for me :) How to implement it ? Manually ? Or it
is available in php config file?
Or another question: where I can read about this ? :)

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: RE :I thought "4" didn't equal "456456456%20%20OR%201<>2"

2004-05-10 Thread Dan Bowkley

DING!  That's the sound of a little lightbulb turning on...

Thanks so much for that tidbit...I could certainly see myself getting
screwed by not using such a thing.

Dan
- Original Message - 
From: "Neil Smith [MVP, Digital media]" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, May 10, 2004 11:21 AM
Subject: RE :I thought "4" didn't equal "456456456%20%20OR%201<>2"


> It doesn't. What you're seeing is an SQL injection attack. If you *trust*
> the SQL code you allow from POST or GET requests, your SQL server will be
> own3d in due course.
>
> That URL actually translates to 456456456  OR 1<>2
>
> Which is always true. So If you use this verbatim, you'll get a true
result
> (if you were using it as part of a login process, the user would be in
> without providing a login and password :-p )
>
> I always, *always* apply $result=(integer) $_GET["uid"] to these strings :
> That way you are guaranteed it's a number not a string.
>
> Cheers - Neil
>
>
> >Message-ID: <[EMAIL PROTECTED]>
> >From: "Dan Bowkley" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Date: Sun, 9 May 2004 15:17:19 -0700
> >MIME-Version: 1.0
> >Content-Type: text/plain;
> > charset="iso-8859-1"
> >Content-Transfer-Encoding: 7bit
> >Subject: Re: [PHP-DB] supernoob strikes again
> >
> >I thought "4" didn't equal "456456456%20%20OR%201<>2"
>
>
> 
> CaptionKit http://www.captionkit.com : Production tools
> for accessible subtitled internet media, transcripts
> and searchable video. Supports Real Player, Quicktime
> and Windows Media Player.
>
> VideoChat with friends online, get Freshly Toasted every
> day at http://www.fresh-toast.net : NetMeeting solutions
> for a connected world.
>
>
>
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Re: Re: SQL Server Query Failed

2004-03-20 Thread JeRRy

Might be an idea to delete the response deeper then
the recently replied.  As all this is archieved there
is no use re-posting it.  Sure keep the latest reply
but keeping anything more makes these emails quite
legnthy.  Just a suggestion for you all.

Cheers!

J

Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Re: Re: SQL Server Query Failed

2004-03-20 Thread Robert Twitty

OK, let me know if you needed any assistance. BTW, are you using
mssql_init() to call stored procedures?

-- bob

On Sat, 20 Mar 2004, david wrote:

> Bob:
>
> I shall experiment with option #3 (replacing php_mssql.dll with
> php_odbtp_mssql.dll). This will take a couple of days (I want to test it all
> out...sigh...testing...) and then slip it into production. I will report
> back on the results.
>
> On the Single Sign On... I am happy to talk about (and would LIKE to) but I
> don't know that this is the proper newsgroup for it? I am open for
> suggestions? I brought the SSO question up in comp.lang.php awhile ago, and
> although there was some discussion, mostly it petered out rather quickly.
>
> PHP for me was a requirement (part of the intranet is some PHP modules which
> are used on LAMP platforms); that is why we went PHP/Apache. (.NET was never
> in the picture, although in hindsight, I wish we had put up IIS/PHP.)
> However, it is a stable platform, and with just two exceptions (one being
> the above!) and the SSO issue that has recently surfaced, the platform has
> not experienced a single glitch. Personally, I do not favor the SSO
> solution, but I understand the business drive for it. Security and
> convenience are often strange bedfellows, and don't always get along.
> You are correct in the IIS supports SSO.
> david
>
>
> "Robert Twitty" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > Hi David
> >
> > Based on the amount of users accessing the site, there is a possibitity
> > that php_mssql.dll not being thread safe could be the problem.  The only
> > way to verify this is to use PHP as a CGI, run Apache as a multi-process
> > server, or replace php_mssql.dll with php_odbtp_mssql.dll.
> >
> > As much as I like PHP and dislike Microsoft, I personally would not have
> > used Apache/PHP on a Win32 platform to connect to SQL Server.  The proper
> > choice should be IIS/ASP.NET.  I believe that IIS supports the single
> > sign-on feature for intranet purposes.  You may have to decide which of
> > the solutions I have mentioned is the most feasible.
> >
> > -- bob
> >
> > On Fri, 19 Mar 2004, david wrote:
> >
> > > Thank you, Bob, for your continuing comments.
> > >
> > > The intranet site is used by approximately 100 people, and sees a good
> > > amount of traffic every day. I don't really have an exact number of
> daily
> > > queries that are executed, but it has to be a pretty sizable number,
> since
> > > the site handles much of the business issues.
> > >
> > > The query in question fails randomly (as far as I can tell: I have been
> > > watching for patterns for some time now.) If it always failed, that
> would
> > > really help. Sigh. Random. Naturally. Worse, the query is 100% dynamic,
> and
> > > built by the users (but of course they do not know they are building a
> > > query. They are just selecting things to report on, which is the way it
> > > should be, in my opinion). So, I don't have a query I can show as always
> > > fails, or sometimes fails.
> > >
> > > The only common thread in all of this is the tables in question. There
> are
> > > only a couple of tables, and they are used in the datawarehouse for
> > > reporting. Oddly, though (and I cannot prove this as much as I would
> like
> > > to) I think that some of the failures happen when no one else is using
> that
> > > table. All the other intranet tables perform as expected (and there are
> a
> > > LOT of those).
> > >
> > > I will look at the Apache 2/multi-process question. It is a great
> thought.
> > >
> > > I have another problem (this one is more of a how in the world do I do
> that,
> > > and relates to digging out the user signed onto the workstation for a
> single
> > > sign on solution: we won't go into the "is that a good idea" question,
> > > because it is moot, and I came out on the losing end); apparently I
> can't do
> > > this with Apache 2 and Windows, and so, long story short, perhaps I
> should
> > > consider other web server options.
> > >
> > > Thanks, Bob!
> > > david
> > >
> > > "Robert Twitty" <[EMAIL PROTECTED]> wrote in message
> > > news:[EMAIL PROTECTED]
> > > > Hi David
> > > >
> > > > Do these few queries ALWAYS fail, or just occasinally fail? Is this
> > > > intranet site used by many people?  If the same query always fails,
> you
> > > > can determine if it may be a thread-safe issue by running that query
> > > > outside of Apache as follows:
> > > >
> > > > c:\php\php thequery.php
> > > >
> > > > If the above fails, then it is probably not due to the fact that the
> mssql
> > > > extension is not thread safe.  If it does work then it could be the
> > > > problem.  I am not familiar with Apache 2.0, but I do believe it is a
> > > > multi-threaded server, which is not good for extensions that are not
> > > > thread-safe. If Apache 2.0 cannot be configured to run as a
> multi-process
> > > > server, you should consider using Apache 1.3.
> > > >
> > > > -- bob
> > > >
> > > > On Fr

[PHP-DB] Re: Re: Re: SQL Server Query Failed

2004-03-20 Thread david

Bob:

I shall experiment with option #3 (replacing php_mssql.dll with
php_odbtp_mssql.dll). This will take a couple of days (I want to test it all
out...sigh...testing...) and then slip it into production. I will report
back on the results.

On the Single Sign On... I am happy to talk about (and would LIKE to) but I
don't know that this is the proper newsgroup for it? I am open for
suggestions? I brought the SSO question up in comp.lang.php awhile ago, and
although there was some discussion, mostly it petered out rather quickly.

PHP for me was a requirement (part of the intranet is some PHP modules which
are used on LAMP platforms); that is why we went PHP/Apache. (.NET was never
in the picture, although in hindsight, I wish we had put up IIS/PHP.)
However, it is a stable platform, and with just two exceptions (one being
the above!) and the SSO issue that has recently surfaced, the platform has
not experienced a single glitch. Personally, I do not favor the SSO
solution, but I understand the business drive for it. Security and
convenience are often strange bedfellows, and don't always get along.
You are correct in the IIS supports SSO.
david


"Robert Twitty" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi David
>
> Based on the amount of users accessing the site, there is a possibitity
> that php_mssql.dll not being thread safe could be the problem.  The only
> way to verify this is to use PHP as a CGI, run Apache as a multi-process
> server, or replace php_mssql.dll with php_odbtp_mssql.dll.
>
> As much as I like PHP and dislike Microsoft, I personally would not have
> used Apache/PHP on a Win32 platform to connect to SQL Server.  The proper
> choice should be IIS/ASP.NET.  I believe that IIS supports the single
> sign-on feature for intranet purposes.  You may have to decide which of
> the solutions I have mentioned is the most feasible.
>
> -- bob
>
> On Fri, 19 Mar 2004, david wrote:
>
> > Thank you, Bob, for your continuing comments.
> >
> > The intranet site is used by approximately 100 people, and sees a good
> > amount of traffic every day. I don't really have an exact number of
daily
> > queries that are executed, but it has to be a pretty sizable number,
since
> > the site handles much of the business issues.
> >
> > The query in question fails randomly (as far as I can tell: I have been
> > watching for patterns for some time now.) If it always failed, that
would
> > really help. Sigh. Random. Naturally. Worse, the query is 100% dynamic,
and
> > built by the users (but of course they do not know they are building a
> > query. They are just selecting things to report on, which is the way it
> > should be, in my opinion). So, I don't have a query I can show as always
> > fails, or sometimes fails.
> >
> > The only common thread in all of this is the tables in question. There
are
> > only a couple of tables, and they are used in the datawarehouse for
> > reporting. Oddly, though (and I cannot prove this as much as I would
like
> > to) I think that some of the failures happen when no one else is using
that
> > table. All the other intranet tables perform as expected (and there are
a
> > LOT of those).
> >
> > I will look at the Apache 2/multi-process question. It is a great
thought.
> >
> > I have another problem (this one is more of a how in the world do I do
that,
> > and relates to digging out the user signed onto the workstation for a
single
> > sign on solution: we won't go into the "is that a good idea" question,
> > because it is moot, and I came out on the losing end); apparently I
can't do
> > this with Apache 2 and Windows, and so, long story short, perhaps I
should
> > consider other web server options.
> >
> > Thanks, Bob!
> > david
> >
> > "Robert Twitty" <[EMAIL PROTECTED]> wrote in message
> > news:[EMAIL PROTECTED]
> > > Hi David
> > >
> > > Do these few queries ALWAYS fail, or just occasinally fail? Is this
> > > intranet site used by many people?  If the same query always fails,
you
> > > can determine if it may be a thread-safe issue by running that query
> > > outside of Apache as follows:
> > >
> > > c:\php\php thequery.php
> > >
> > > If the above fails, then it is probably not due to the fact that the
mssql
> > > extension is not thread safe.  If it does work then it could be the
> > > problem.  I am not familiar with Apache 2.0, but I do believe it is a
> > > multi-threaded server, which is not good for extensions that are not
> > > thread-safe. If Apache 2.0 cannot be configured to run as a
multi-process
> > > server, you should consider using Apache 1.3.
> > >
> > > -- bob
> > >
> > > On Fri, 19 Mar 2004, david wrote:
> > >
> > > > Ahthread safe.
> > > >
> > > > THAT is an interesting thought. Especially because I somehow suspect
> > that my
> > > > problem is related to the database and/or table being locked just
when I
> > am
> > > > trying to read it.
> > > >
> > > > However, I have to profess some ignorance about FastCGI. I looked at
the
> > web
>

Re: [PHP-DB] Re: Re: SQL Server Query Failed

2004-03-19 Thread Robert Twitty

Hi David

Based on the amount of users accessing the site, there is a possibitity
that php_mssql.dll not being thread safe could be the problem.  The only
way to verify this is to use PHP as a CGI, run Apache as a multi-process
server, or replace php_mssql.dll with php_odbtp_mssql.dll.

As much as I like PHP and dislike Microsoft, I personally would not have
used Apache/PHP on a Win32 platform to connect to SQL Server.  The proper
choice should be IIS/ASP.NET.  I believe that IIS supports the single
sign-on feature for intranet purposes.  You may have to decide which of
the solutions I have mentioned is the most feasible.

-- bob

On Fri, 19 Mar 2004, david wrote:

> Thank you, Bob, for your continuing comments.
>
> The intranet site is used by approximately 100 people, and sees a good
> amount of traffic every day. I don't really have an exact number of daily
> queries that are executed, but it has to be a pretty sizable number, since
> the site handles much of the business issues.
>
> The query in question fails randomly (as far as I can tell: I have been
> watching for patterns for some time now.) If it always failed, that would
> really help. Sigh. Random. Naturally. Worse, the query is 100% dynamic, and
> built by the users (but of course they do not know they are building a
> query. They are just selecting things to report on, which is the way it
> should be, in my opinion). So, I don't have a query I can show as always
> fails, or sometimes fails.
>
> The only common thread in all of this is the tables in question. There are
> only a couple of tables, and they are used in the datawarehouse for
> reporting. Oddly, though (and I cannot prove this as much as I would like
> to) I think that some of the failures happen when no one else is using that
> table. All the other intranet tables perform as expected (and there are a
> LOT of those).
>
> I will look at the Apache 2/multi-process question. It is a great thought.
>
> I have another problem (this one is more of a how in the world do I do that,
> and relates to digging out the user signed onto the workstation for a single
> sign on solution: we won't go into the "is that a good idea" question,
> because it is moot, and I came out on the losing end); apparently I can't do
> this with Apache 2 and Windows, and so, long story short, perhaps I should
> consider other web server options.
>
> Thanks, Bob!
> david
>
> "Robert Twitty" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > Hi David
> >
> > Do these few queries ALWAYS fail, or just occasinally fail? Is this
> > intranet site used by many people?  If the same query always fails, you
> > can determine if it may be a thread-safe issue by running that query
> > outside of Apache as follows:
> >
> > c:\php\php thequery.php
> >
> > If the above fails, then it is probably not due to the fact that the mssql
> > extension is not thread safe.  If it does work then it could be the
> > problem.  I am not familiar with Apache 2.0, but I do believe it is a
> > multi-threaded server, which is not good for extensions that are not
> > thread-safe. If Apache 2.0 cannot be configured to run as a multi-process
> > server, you should consider using Apache 1.3.
> >
> > -- bob
> >
> > On Fri, 19 Mar 2004, david wrote:
> >
> > > Ahthread safe.
> > >
> > > THAT is an interesting thought. Especially because I somehow suspect
> that my
> > > problem is related to the database and/or table being locked just when I
> am
> > > trying to read it.
> > >
> > > However, I have to profess some ignorance about FastCGI. I looked at the
> web
> > > site for it, but I am not sure if by installing it I am now magically
> > > thread-safe? Or, once installed, do I need to make some code changes?
> > >
> > > My environment is an established intranet (Windows based; Windows 2000
> > > server, Apache 2.0; connecting over the network to MS SQL Server, also
> > > running on Windows 2000). What is odd is that there are only a couple of
> > > queries that fail, and when they do, they ONLY fail against certain
> tables
> > > used for reporting from a data warehouse, and then only now and then
> > > (perhaps once a day; maybe less). The queries are dynamic in nature, and
> can
> > > pull data of integer, char, or varchar. All other queries (and there are
> a
> > > rather lot of them) for doing the mundane intranet stuff work perfectly,
> and
> > > have NEVER failed. It is a real puzzle.
> > >
> > > Thanks!
> > > david
> > >
> > > "Frank M. Kromann" <[EMAIL PROTECTED]> wrote in message
> > > news:[EMAIL PROTECTED]
> > > > Hi David,
> > > >
> > > > You problem might be a thread safty issue. the MSSQL extension is not
> > > > thread safe (caused by the Microsoft Library used to create the
> > > > extension). Use CGI or FastCGI to avoid this problem.
> > > >
> > > > - Frank
> > > >
> > > > P.S. I don't have the full thread of this discussion so I might miss
> some
> > > > important information about your setup.
> > > >
> > > > > Brun

[PHP-DB] Re: Re: SQL Server Query Failed

2004-03-19 Thread david

Thank you, Bob, for your continuing comments.

The intranet site is used by approximately 100 people, and sees a good
amount of traffic every day. I don't really have an exact number of daily
queries that are executed, but it has to be a pretty sizable number, since
the site handles much of the business issues.

The query in question fails randomly (as far as I can tell: I have been
watching for patterns for some time now.) If it always failed, that would
really help. Sigh. Random. Naturally. Worse, the query is 100% dynamic, and
built by the users (but of course they do not know they are building a
query. They are just selecting things to report on, which is the way it
should be, in my opinion). So, I don't have a query I can show as always
fails, or sometimes fails.

The only common thread in all of this is the tables in question. There are
only a couple of tables, and they are used in the datawarehouse for
reporting. Oddly, though (and I cannot prove this as much as I would like
to) I think that some of the failures happen when no one else is using that
table. All the other intranet tables perform as expected (and there are a
LOT of those).

I will look at the Apache 2/multi-process question. It is a great thought.

I have another problem (this one is more of a how in the world do I do that,
and relates to digging out the user signed onto the workstation for a single
sign on solution: we won't go into the "is that a good idea" question,
because it is moot, and I came out on the losing end); apparently I can't do
this with Apache 2 and Windows, and so, long story short, perhaps I should
consider other web server options.

Thanks, Bob!
david

"Robert Twitty" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi David
>
> Do these few queries ALWAYS fail, or just occasinally fail? Is this
> intranet site used by many people?  If the same query always fails, you
> can determine if it may be a thread-safe issue by running that query
> outside of Apache as follows:
>
> c:\php\php thequery.php
>
> If the above fails, then it is probably not due to the fact that the mssql
> extension is not thread safe.  If it does work then it could be the
> problem.  I am not familiar with Apache 2.0, but I do believe it is a
> multi-threaded server, which is not good for extensions that are not
> thread-safe. If Apache 2.0 cannot be configured to run as a multi-process
> server, you should consider using Apache 1.3.
>
> -- bob
>
> On Fri, 19 Mar 2004, david wrote:
>
> > Ahthread safe.
> >
> > THAT is an interesting thought. Especially because I somehow suspect
that my
> > problem is related to the database and/or table being locked just when I
am
> > trying to read it.
> >
> > However, I have to profess some ignorance about FastCGI. I looked at the
web
> > site for it, but I am not sure if by installing it I am now magically
> > thread-safe? Or, once installed, do I need to make some code changes?
> >
> > My environment is an established intranet (Windows based; Windows 2000
> > server, Apache 2.0; connecting over the network to MS SQL Server, also
> > running on Windows 2000). What is odd is that there are only a couple of
> > queries that fail, and when they do, they ONLY fail against certain
tables
> > used for reporting from a data warehouse, and then only now and then
> > (perhaps once a day; maybe less). The queries are dynamic in nature, and
can
> > pull data of integer, char, or varchar. All other queries (and there are
a
> > rather lot of them) for doing the mundane intranet stuff work perfectly,
and
> > have NEVER failed. It is a real puzzle.
> >
> > Thanks!
> > david
> >
> > "Frank M. Kromann" <[EMAIL PROTECTED]> wrote in message
> > news:[EMAIL PROTECTED]
> > > Hi David,
> > >
> > > You problem might be a thread safty issue. the MSSQL extension is not
> > > thread safe (caused by the Microsoft Library used to create the
> > > extension). Use CGI or FastCGI to avoid this problem.
> > >
> > > - Frank
> > >
> > > P.S. I don't have the full thread of this discussion so I might miss
some
> > > important information about your setup.
> > >
> > > > Bruno:
> > > >
> > > > I did that. I had to wait a bit until it failed again, whcih it did
a
> > > few
> > > > moments ago. Alas, there is not one thing out of the ordinary in the
> > > log.
> > > >
> > > > Any other suggestions?
> > > >
> > > > THANK YOU!
> > > > david
> > > >
> > > > "Bruno Ferreira" <[EMAIL PROTECTED]> wrote in message
> > > > news:[EMAIL PROTECTED]
> > > > > david wrote:
> > > > >
> > > > > >Hello there!
> > > > > >
> > > > > >I have just about driven myself crazy with an odd intermittent
> > > problem.
> > > > > >[snip]
> > > > > >
> > > > > >
> > > > >
> > > > > I'd first start by turning on all logging I could in the SQL
> > > server
> > > > > so that I could see what's happening straight from the horse's
> > > mouth...
> > > > >
> > > > > Bruno Ferreira
> > > > > ---
> > > > > [This E-mail scanned for viruses by Declude Virus]
>

[PHP-DB] Re: Re:[2] [PHP-DB] database absraction layer

2002-05-06 Thread Andrey Hristov


You can use PEAR nevertheless they don't have it in the config. PEAR is
userspace, so you can get it from everywhere put it everywhere in you home
dir or in subdirs, and just refer to it with require and include. But be
aware that there can be relative include/require in the PEAR that have to be
satisfied
It's like getting a script from hotscripts.com or a class from
phpclasses.org and using it.

Andrey

- Original Message -
From: "adi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 07, 2002 5:02 AM
Subject: Re:[2] [PHP-DB] database absraction layer


> thanks,
> but what I want is, they don't have to --enable-dbx or enable pear in
their php
> configuration to be able to use this class.
>
>
> "Andrey Hristov" <[EMAIL PROTECTED]> wrote on 5/7/02 9:29:24 AM:
> >
> >Look at PEAR repository for userspace abstraction layer.
> >Look at the dbx extension for compiled abstraction layer.
> >
> >Andrey
> >
> >- Original Message -
> >From: "adi" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Sent: Tuesday, May 07, 2002 4:08 AM
> >Subject: [PHP-DB] database absraction layer
> >
> >
> >> dear all,
> >>
> >> I'm writing  database abstraction layer class (like adoDB but much
> >simpler).
> >> What I want to do that it will provide single access function for
> >different
> >> type of database. Currently, it will only support mySQL and
PostgreSQL..
> >but I
> >> just don't know how to do this with better approach.
> >>
> >> code snippet..
> >>
> >> ..
> >> function connect(){
> >> if($this->type == "mysql"){
> >> $this->conid = mysql_connect($this->host,$this->user,$this->pass);
> >> }
> >> elseif($this->type == "pgsql")){
> >> $this->conid = pg_connect($this->host $this->port $this->db $this->user
> >> $this->pass); }
> >> else {
> >> echo ("database type $this->type not supported");
> >> }
> >> }
> >> ..
> >>
> >> any idea of doing such of function alias/wrapper?
> >> any help appreciated
> >> thanks
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: RE: that book:

2001-10-30 Thread Russ Michell


Don't quote me on this but the ./configure command when compiling/re-compiling php 
should be run 
one level up from the dir you wish to make the action occur in. (One above 
/path/to/php4.0.6/bin 
so: ./bin/configure with --this with --that

I have cc'd this to the php-db list to make sure this is right (and I'm not even 
convinced myselfanyone??)
Cheers

Russ

On Mon, 29 Oct 2001 15:26:58 - [EMAIL PROTECTED] wrote:

> Russ:
> 
> see below for the question I posted and the reply I got. I hope it makes
> some sense.
> 
> My Question was:
> I have a RedHat 7.2 server which I configured using the automatic
> configuration GUI. It is running apache 1.3.20, mysql 3.23.41,and php 4.0.6.
> Apache and php are working fine but I created the phpinof.php page and it is
> missing any reference to mysql. I am real new to linux but someone I know
> who is helping me suggested I need to recompile php to integrate mysql and
> apxs. I searched the forum and a while back found this but I need to know is
> this right and if could some one interpret it for me! 
> 
> "./configure --with-axps --with-mysql" 
> "make" 
> "make install" 
> 
> The response was:
> I don't think you're going to need to recompile. For one, Redhat's
> "automatic configuaration GUI" doesn't use source files uses RPM's
> (basically pre-compiled binaries). Thus, you probably don't have the source
> readily available and would need to download it. That's not a big problem
> though:) 
> 
> More to the point, AFAIK, the RPM's are compiled using apxs and the
> --with-mysql option is default (you have to manually specify that you
> *don't* want MySQL support). Your best and easiest bet is to add one or more
> RPM ftp servers into the sources list of the PRM Manager (don't ask me
> how I don't use Redhat) and run a search for php-mysql. It'll turn up a
> bunch of hits (probably on the installation cd's as well) for the php-mysql
> rpm, just select it and install it. 
> 
> In answer to your other question, the make options you've given in your post
> are valid and won't cause the make to barf and die (assuming you've got
> MySQL and APXS installed on your box). Personally I find it's useful to
> place the "make clean" command before the ./configure options. It ensures
> you're running a fresh install and not using an old cached config script. 
> 
> ---
> 
> Just one more question. Do you understand the './configure' command? does it
> have to be run from a particular directory to be affective? If so how might
> you find out?
> 
> Thanks very much for your help today. It is much appreciated - I'm off to
> amazon now to get the book!
> 
> James.
> 
> -Original Message-
> From: Russ Michell [mailto:[EMAIL PROTECTED]]
> Sent: 29 October 2001 15:00
> To: [EMAIL PROTECTED]
> Subject: that book:
> 
> 
> James:
> 
> The book is called:
> 
> * "Fast and Easy Web Development using PHP"
> * By Julie C Meloni
> 
> Paste this URL into your browser:
> http://www.amazon.com/exec/obidos/ASIN/076153055X/qid=1004367638/sr=1-6/ref=
> sr_1_15_6/104-6954028-5527930
> 
> and check out also: www.thickbook.com (support website for the book)
> Good luck!
> 
> Russ
> 
> #---#
>   
>   "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
>   
> #---#

#---#

  "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]

40 matches

Mail list logo