[PHP-DB] Re: Re

[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

[jstarritt]

 
Oliver,
 
Gah -- thank you.
 
James
 
-Original Message-
From: Olivier Desmares olivier.d@orange.fr
Sent: Saturday, June 16, 2012 10:58am
To: jstarr...@selagodesign.com jstarr...@selagodesign.com, 
php-db@lists.php.net 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 pMAIN: $authkv/p;
 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

[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

[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]
?php
print pre;
print POST:br /;
print_r($_POST);
print hr /;
print GET:br /;
print_r($_GET);
print /pre;
[/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]

[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

[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: [PHP-DB] pg_escape_bytea missing despite Postgre v.7.4.14

[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

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

[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: [PHP-DB] re: small question php/postgreSQL (basic question, not small)

[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-5d7207d94d45mkt=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 : RE: [PHP-DB] re: small question php/postgreSQL (basic question, not small)

[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
 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-5d7207d94d45mkt=en-ca




-- 
Des Coughlan 
  [EMAIL PROTECTED]

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

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

[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...


-
 Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son 
interface révolutionnaire.

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

[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

[Desmond Coughlan]

X-No-Archive:
  
Curious.  I put this in a file... 
   
  ?php
  echo 'pHello World/p'
  ?

  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 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: [PHP-DB] re: small question php/postgreSQL (basic question, not small)

[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.
 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.

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

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

[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:
 
   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

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

[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://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 

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

[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

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

[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: Sending filing attachments using PHP

[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

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

[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

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

[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: Storing Credit Cards, Passwords, Securely, two-wayencryption

[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

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

[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: November 2, 2004

[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: November 2, 2004

[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

[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

[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

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

[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: [PHP-DB] How use select for update

[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

[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: $_Session vs $_Cookie

[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 :I thought 4 didn't equal 456456456%20%20OR%2012

[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%2012


 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 12

 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%2012


 
 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

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

[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
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 

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

[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 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.

 

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

[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

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

[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 Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php


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

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

[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.
   
 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?

 

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

[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:

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