Re: [PHP] menu andfolder question

2008-01-05 Thread Alain Roger
this is how i solved my issue :-) On Jan 5, 2008 4:28 PM, jeffry s [EMAIL PROTECTED] wrote: On Jan 5, 2008 7:36 PM, Alain Roger [EMAIL PROTECTED] wrote: ok, maybe i did not write my question well. i already used it because i setup the DirectoryIndex to index.php, index.html my

[PHP] website tree

2008-01-05 Thread Alain Roger
Hi, let's imaging we have the following thing : www.mywebsite.com/company/index.php www.mywebsite.com/company/profile.php www.mywebsite.com/services/index.php how can i detect in which address am i ? for example how to retrieve www.mywebsite.com/services or www.mywebsite.com/company -- Alain

[PHP] best way for PHP page

2008-01-01 Thread Alain Roger
Hi, i would like to improve my coding quality when i use PHP code and for that i would request your help. in my web developer experience, i have to confess that i've never succeeded in spliting PHP code from HTML code. i mean that all my web pages consist of PHP code mixed with HTML code (for

Re: [PHP] LDAP

2007-08-22 Thread Alain Roger
Hi, Have you tried in the php.ini to setup error_reporting to E_ALL and display error messages (display_errors = On) ? I had a similar problem 2 days ago and it was due to another mistake in my PHP code. But i did not get any error message or more precisely, i did not get any WARNING message.

[PHP] LDAP

2007-08-21 Thread Alain Roger
Hi, I have a stupid issue with ldap_connect. i've reinstalled PHP, postgreSQL and restore my data (web files) after reinstalling my PC. now, when i try : $ds = ldap_connect($ldaphost, $ldapport) or die(Could not connect to $ldaphost); nothing works. i wrote before error_reporting(E_ALL); in

Re: [PHP] Re: LDAP

2007-08-21 Thread Alain Roger
I found what was the problem :-( in PHP.ini the Temp directory was not setup the same. i do not know what is the link with LDAP module, but since i updated php.ini, it works correctly. Alain On 8/21/07, Colin Guthrie [EMAIL PROTECTED] wrote: Alain Roger wrote: Hi, I have a stupid issue

Re: [PHP] very strange behavior.... incomplete query performed

2007-08-14 Thread Alain Roger
[EMAIL PROTECTED] wrote: Are you using E_ALL? Any error messages? My first suspect is you are hitting php.ini time_limit setting, or possibly the memory_limit. On Sun, August 12, 2007 7:09 am, Alain Roger wrote: Hi, I'm still working on importing CSV file content (20.000 records

Re: [PHP] php.ini of PHP 5.2.3

2007-08-14 Thread Alain Roger
the error log shows something about openssl but doesn't say what openssl is missing, and folks think it's still missing openssl itself, when it's really missing libeay. On Sat, August 11, 2007 6:02 am, Alain Roger wrote: I've discovered that when i type php -m, openssl is already loaded

Re: [PHP] convert (windows-1250) to (utf-8)

2007-08-12 Thread Alain Roger
and why not : $out = iconv('windows-1250','UTF-8', $in); ??? Alain On 8/12/07, brian [EMAIL PROTECTED] wrote: Alain Roger wrote: Hi, I import a csv file (which includes characters from windows-1250 charset) to postgreSQL database which is in UTF-8. How can i convert windows-1250

[PHP] PostgreSQL and select nextval

2007-08-12 Thread Alain Roger
Hi, I'm getting an error message when i run the following SQL request : $sql = INSERT INTO tmp_importedxls (rec_id, publisher) VALUES (SELECT nextval('tmp_importedxls_rec_id_seq'),'$pb'); Error in SQL query: ERROR: syntax error at or near SELECT LINE 2: VALUES (SELECT

Re: [PHP] convert (windows-1250) to (utf-8)

2007-08-12 Thread Alain Roger
I've tested it and it works well. i got some issue when i used ISO-8859-2. Al On 8/12/07, Tijnema [EMAIL PROTECTED] wrote: On 8/12/07, Alain Roger [EMAIL PROTECTED] wrote: and why not : $out = iconv('windows-1250','UTF-8', $in); ??? Alain Did you test if that works? I doubt

[PHP] very strange behavior.... incomplete query performed

2007-08-12 Thread Alain Roger
Hi, I'm still working on importing CSV file content (20.000 records) to database PostgreSQL. when i run the query, once i stored into my table 5218 records, another time 5231 another time 4713 and so on every time the amount of records imported to DB is different. Do you have any idea from

[PHP] php.ini of PHP 5.2.3

2007-08-11 Thread Alain Roger
Hi, I have a stupid problem. At work i installed the PHP 5.2.1 and it works fine. i uncomment extension = php_opensll and i see that extension is activated because phpinfo show me information about such extension. However, at homw i've just installed PHP 5.2.3 and i did the same as at work but

Re: [PHP] php.ini of PHP 5.2.3

2007-08-11 Thread Alain Roger
] wrote: Alain Roger wrote: I have a stupid problem. At work i installed the PHP 5.2.1 and it works fine. i uncomment extension = php_opensll and i see that extension is activated because phpinfo show me information about such extension. However, at homw i've just installed PHP 5.2.3 and i

[PHP] convert (windows-1250) to (utf-8)

2007-08-11 Thread Alain Roger
Hi, I import a csv file (which includes characters from windows-1250 charset) to postgreSQL database which is in UTF-8. How can i convert windows-1250 to utf-8 charset ? thanks a lot, -- Alain Windows XP SP2 PostgreSQL 8.2.3 Apache 2.2.4 PHP 5.2.3

[PHP] multiple data to insert to database

2007-08-10 Thread Alain Roger
Hi, I would like to know what is the best way and fastest to insert into PostgreSQL around 25.000 records (extracted from CSV file). Should i use the standard pg_exec($dbconn, insert into...); for each record ? thanks a lot, -- Alain Windows XP SP2

Re: [PHP] Import XLS file with UTF-8

2007-08-10 Thread Alain Roger
, no ? Al. On 8/10/07, Stut [EMAIL PROTECTED] wrote: Alain Roger wrote: Hi, So now i know how to import the content of the CSV file to database, however, before to import to database i do a simple test. in fact, i display in my browser all content of my CSV file. unfortunately, not all

[PHP] Import XLS file with UTF-8

2007-08-10 Thread Alain Roger
Hi, So now i know how to import the content of the CSV file to database, however, before to import to database i do a simple test. in fact, i display in my browser all content of my CSV file. unfortunately, not all characters are displayed correctly. in PHP page include meta

[PHP] phpinfo does not display openssl module

2007-08-10 Thread Alain Roger
Hi i've reinstalled the complete server and i use apache module to load openSSL. However, if i uncomment in PHP.INI the extension=php_openssl.dll, it still does not appear on screen when i use phpinfo() function. i've tried also to uncomment some other extension and they also are not displayed

[PHP] import Excel file into PostgreSQL

2007-08-06 Thread Alain Roger
HI, I would like to know the best and fastest way how to import some colums contents from Excel file to PostgreSQL database. how can i do that ? I mean some columns of Excel should be imported into a particular table and some others into another table. thanks for any suggestion. -- Alain

[PHP] efficient log system

2007-06-12 Thread Alain Roger
Hi, I would like to create a log system to keep a trace of all users' actions (log-in, remove, change or update data, and so on...). What should i do or to what should i take care to not have problem ? I was thinking to create a folder on my server where log files will be stored, but what is

[PHP] losing session variable

2007-05-06 Thread Alain Roger
Hi, I have the following code : session_start(); $_SESSION['username']=$myusername; $_SESSION['Localization'] = $lang; header(Location: https://.$_SERVER['SERVER_NAME'].$path_adm_files./modules/welcome/welcome.php); if i check before header command what is the value of

[PHP] resize image and store it to DB

2007-05-01 Thread Alain Roger
Hi, I allow web application users to insert their own picture into database. but i defined a max size limit 130 px width by 160px height. so for that i determine the max ratio in case of picture does not have this size. after that i resize it and would like to store it to DB, however i have

[PHP] magic.mime

2007-05-01 Thread Alain Roger
Hi, I know that magic.mime is depreciated but i would like to test a simple thing. However, i have some issues with it it does not work :-( basically, my php.ini file points as following : mime_magic.magicfile = x:\PHP511\extras\magic.mime I also enabled the dll via :

[PHP] mime_magic support empty ?

2007-05-01 Thread Alain Roger
Hi, I previously wrote a post about mime_magic issue. i would like to add some details about result from phpinfo() function. when i check it i can see that mime_magic support is empty. not set to enabled or disabled... only empty cell. I also tried the standard magic.mime file delivered with

[PHP] postgreSQL and bytea / image

2007-04-30 Thread Alain Roger
Hi, In my PHP page i upload pictures into database. For that i wrote a simple function which control which user is logged and will upload his picture. here is the function : CREATE OR REPLACE FUNCTION sp_a_006(login character varying, photo bytea) RETURNS boolean AS $BODY$ DECLARE

[PHP] small picture into thumbnail

2007-04-29 Thread Alain Roger
Hi, I would like to know how i can display small sized picture in my web application ? I mean in my database, picture can have max. 500 Kb, however as on 1 PHP page i will display 20 pictures at once, i do not want to force end users to download all 20 pictures (10Mb around) to have an overview.

[PHP] how to detect type of image

2007-04-21 Thread Alain Roger
Hi, In my web application, end user is able to load images (png, jpeg, gif,..) into database. I would like to know how can i detect automatically the type of image (pnd, jpeg,...) ? i do not want to check the extension because this is easily faked... just by renaming it. Does it exist a

Re: [PHP] secure login

2007-04-15 Thread Alain Roger
Hi Ross, I previously worked on this theme and the general feeling / feedback from the mailing list was the following one : - access to your login window, via HTTPS (SSL) - hash you password (inspired by : http://phpsec.org/articles/2005/password-hashing.html) - when user is authenticated, you

[PHP] warning message to hide

2007-04-14 Thread Alain Roger
Hi, Today i discovered that when my host webserver has some issue with PostgreSQL database, my code displays the following error message : *Warning*: pg_connect() [function.pg-connecthttp://www.immense.sk/function.pg-connect]: Unable to connect to PostgreSQL server: could not connect to server:

[PHP] dynamic web interface and size

2007-04-03 Thread Alain Roger
Hi, My question is not so much about PHP language but more about concept and PHP result. Basically i'm currently working on web application to administrate the web content of a website. My customer would like to have a nice web application interface, so it means a lot of images, and so on.

Re: [PHP] close session when browser is closed

2007-03-24 Thread Alain Roger
set the session timeout to 0, then it dies when the browser is quit. On Wed, March 21, 2007 12:37 pm, Alain Roger wrote: Hi, I would like to know what is the best solution for my problem. When a user is connected to a https page and a session is open, if user close his browser, the session ID

[PHP] how to control if it is a date

2007-03-24 Thread Alain Roger
Hi, user can enter a string with following format dd.mm.. Application should transform it to postgresql timestamp date. however, i would like to be sure that what user typed is a real and valid date. how can i do that ? i was thinking to use date(string format,

Re: [PHP] how to control if it is a date

2007-03-24 Thread Alain Roger
thanks i did not know it. On 3/24/07, Brice [EMAIL PROTECTED] wrote: On 3/24/07, Alain Roger [EMAIL PROTECTED] wrote: Hi, user can enter a string with following format dd.mm.. Application should transform it to postgresql timestamp date. however, i would like to be sure that what

[PHP] close session when browser is closed

2007-03-21 Thread Alain Roger
Hi, I would like to know what is the best solution for my problem. When a user is connected to a https page and a session is open, if user close his browser, the session ID is still active in the browser history. It means that next time when user will start his browser, the browser will re-use

Re: [PHP] close session when browser is closed

2007-03-21 Thread Alain Roger
Hi Brad, yes this is one possibility, but since i use https, i should not be afraid by storing data in $_SESSION variables. So i see that solution as a heavy one. Is there another possibility ? thanks, Al. On 3/21/07, Brad Bonkoski [EMAIL PROTECTED] wrote: Alain Roger wrote: Hi, I would

[PHP] image digit to check password

2007-03-20 Thread Alain Roger
Hi, There is a trend on internet that when you want to change your password, you need to type : 1. the former password. 2. the new one 3. a 2nd time the new one to confirm that no mistake has been done on step 2. however, several website also propose an additional security to avoid

[PHP] time or date picker ?

2007-03-19 Thread Alain Roger
Hi, I've already seen some webpages which include a time or date picker (like a calendar) written in PHP and on which user could type the year and after, select the month and date (using month). I'm looking for something like that. Where can i find one for free ? thanks -- Alain

Re: [PHP] Class and subclass

2007-03-13 Thread Alain Roger
anything about the not working part... var_dump $this-myotherclass and see what's in it. On Wed, March 7, 2007 8:45 am, Alain Roger wrote: Yes, for sure. On 3/7/07, Tijnema ! [EMAIL PROTECTED] wrote: On 3/7/07, Alain Roger [EMAIL PROTECTED] wrote: A() or B() mean constructors of th class

[PHP] Back to security

2007-03-10 Thread Alain Roger
Hi, I'm continuing to work on securing my administration part of the website. based on previous posts and reading materials, I was thinking to use the following process : 1. user has to logon through a standard http://; web page 2. login and encrypted password are compared with what is stored

[PHP] Javascript and PHP interaction

2007-03-08 Thread Alain Roger
Hi, I would like to know if there is a way how PHP code can extract from ElementID some property values. for example, i have the following PHP page : ?php print div class='maindiv' id='id_maindiv'my main div/div; $new_Width = somefunction(); print div class='childdiv' id='id_childdiv'

[PHP] namespace equivalent in PHP

2007-03-07 Thread Alain Roger
Hi, Coming from C++ world, i would like to know what in PHP, is the equivalent of namespace in C++ ? I have several class which should work together, or Class B which is used to create a private property of class A. How can i do that without including the class B into the class A definition ?

[PHP] Class and subclass

2007-03-07 Thread Alain Roger
Hi, i have a class A with some properties. i have a class B with several public functions (i.e : Render()) i would like to do something like that : class B() { B() { } public function Render() { ... } } class A { private $myotherclass; A() { $this-myotherclass = new classB(); } public

Re: [PHP] Class and subclass

2007-03-07 Thread Alain Roger
A() or B() mean constructors of th class A and B respectively. Al. On 3/7/07, Robert Cummings [EMAIL PROTECTED] wrote: On Wed, 2007-03-07 at 14:23 +0100, Alain Roger wrote: Hi, i have a class A with some properties. i have a class B with several public functions (i.e : Render()) i would

Re: [PHP] Class and subclass

2007-03-07 Thread Alain Roger
Yes, for sure. On 3/7/07, Tijnema ! [EMAIL PROTECTED] wrote: On 3/7/07, Alain Roger [EMAIL PROTECTED] wrote: A() or B() mean constructors of th class A and B respectively. Al. Yes but they are functions. On 3/7/07, Robert Cummings [EMAIL PROTECTED] wrote: On Wed, 2007-03-07 at 14

[PHP] change Style Sheet by programming

2007-03-06 Thread Alain Roger
Hi, I'm creating a Class which should allow user to setup the default theme CSS file he would like to use to render a class object. therefore i have a simple function : public function SetTheme(string $ThemeName) { $this-m_ThemeUsed = $ThemeName; } which set the theme (CSS

Re: [PHP] file open dialog box

2007-03-05 Thread Alain Roger
Thanks for your answer Chris, but i already used this example yesterday as base for my request. Alain On 3/5/07, Chris [EMAIL PROTECTED] wrote: Alain Roger wrote: Hi, I would like to have an Open file dialog box in my PHP page like it exist on Microsoft Windows. This dialog box should

Re: [PHP] module and access rights

2007-03-05 Thread Alain Roger
); and check that each time the user does an action. Tijnema - Now to the PHP list On 3/4/07, Alain Roger [EMAIL PROTECTED] wrote: Ok, but i would be very glad to know how can i REALLY authenticate the user. for example, user is logged, so i have in the cookie his login name. how can i

Re: [PHP] module and access rights

2007-03-05 Thread Alain Roger
a bank, is anyone really going to bother? -Stut On 3/4/07, Alain Roger [EMAIL PROTECTED] wrote: Ok, but i would be very glad to know how can i REALLY authenticate the user. for example, user is logged, so i have in the cookie his login name. how can i be sure that it's the same user

[PHP] session question

2007-03-05 Thread Alain Roger
Hi, I have an index.php page which does not user session_start(); command. However in this index.php page, there are some $_SESSION['...']; variables stored. How is it possible that $_SESSION['...']; works even if no session has been created before ? moreover, if i use a print Session ID :

Re: [PHP] session question

2007-03-05 Thread Alain Roger
the index.php page is the first page where user should logon. it consists of 3 flags (english, french and slovak). when use click on 1 flags, it reload the index.php page and changes the login and password words by their relative translation into the flag country selected. if user click on LOGON

[PHP] file open dialog box

2007-03-04 Thread Alain Roger
Hi, I would like to have an Open file dialog box in my PHP page like it exist on Microsoft Windows. This dialog box should allow user to select a file from his computer. Is there something like that in PHP ? thx. -- Alain Windows XP SP2 PostgreSQL 8.1.4

[PHP] upload file

2007-03-04 Thread Alain Roger
Hi, I would like in fact to make more precise my previous post. I would like in fact to restrict the file extension (and therefore the user possibility). My user should be able only to upload files with extension JPEG, BMP, GIF. How can i set those parameter ? thx. -- Alain

[PHP] TabPage like in Java or Windows

2007-03-04 Thread Alain Roger
Hi, I would like to know if it exist a class with allow to have a windowed form tabbed like under Firefox (each web page is included into a tabbed page control) I attached a screenshot to this post in order to illustrate what i'm looking for. thanks a lot for your comment. -- Alain

[PHP] module and access rights

2007-03-04 Thread Alain Roger
Hi, I would like to implement a module access rights in my web application. Basically after authentication and authorization. Logged user has a particular profile which allow him to have access to some part of the web application. after reading the security guide from *php*sec.org webpage, i'm

Re: [PHP] module and access rights

2007-03-04 Thread Alain Roger
Hi, do not worry, i will not store a password in a cookie. it is stored encrypted into database. Al. On 3/4/07, Stut [EMAIL PROTECTED] wrote: Alain Roger wrote: I would like to implement a module access rights in my web application. Basically after authentication and authorization. Logged

Re: [PHP] module and access rights

2007-03-04 Thread Alain Roger
should be stored ? because i can store in DB the sessionID, and check it to every DB request user does...but a sessionID can be easily fake. So what should I do ? Al. On 3/4/07, Tijnema ! [EMAIL PROTECTED] wrote: On 3/4/07, Stut [EMAIL PROTECTED] wrote: Alain Roger wrote: I would like

[PHP] pictures stored in PostgreSQL DB

2007-03-03 Thread Alain Roger
Hi, It's amazing that my previous post has raised so much consideration about the fact to store or not pictures into DB. However, none of those posts answered to my question... How can i retrieve and display those pictures to my PHP pages ? Basically, on my PHP page I have some texts and I

Re: [PHP] pictures stored in PostgreSQL DB

2007-03-03 Thread Alain Roger
make a page that does nothing but returns an image. Something like getimage.php?image=whatever you are using in your db and call it with img src=getimage.php?image=xxx /. Hope that helps. - Original Message From: Alain Roger [EMAIL PROTECTED] To: PHP General List php-general

Re: [PHP] pictures stored in PostgreSQL DB

2007-03-03 Thread Alain Roger
Hi Rob, thanks for information. As you told me i use 2 files to do what i need. 1 for displaying th thumbnail and the other just to display the picture. That's works great. However, how can i resize the picture (in my thumbnail) if my pictures are stored to DB ? i mean that my picture is stored

[PHP] Pager_Wrapper_MDB2 and PHP

2007-03-03 Thread Alain Roger
Hi, How to get the number of items stored in the Pager_Wrapper_MDB2 object ? thx. -- Alain Windows XP SP2 PostgreSQL 8.1.4 Apache 2.0.58 PHP 5

[PHP] Store and retrieve photo from PostgreSQL

2007-02-25 Thread Alain Roger
Hi, I would like to store and retrieve photo from my DB (PostgreSQL). However, i do not know how to do it. Where can i find some example ? thanks a lot, -- Alain Windows XP SP2 PostgreSQL 8.1.4 Apache 2.0.58 PHP 5

[PHP] how to display images stored in DB

2007-02-25 Thread Alain Roger
Hi, i stored all my pictures in my PostgreSQL DB as bytea type. Now i would like to know how can i display them in my PHP pages ? where can i find some example ? thanks a lot, -- Alain Windows XP SP2 PostgreSQL 8.1.4 Apache 2.0.58 PHP 5

[PHP] how to retrieve pictures from postgreSQL DB

2007-02-25 Thread Alain Roger
Hi, I previously sent email about process how to retrieve and save pictures in postgreSQL DB. Now i know how to save them in DB, however i would like to know how can i retrieve the pictures and display them without knowing the picture extension ? i mean that in my DB i have GIFs, JPGs pictures.

[PHP] How to be sure to use SSL

2006-12-02 Thread Alain Roger
Hi, I would like to know how can i be sure to make customer use the SSL all the time. all the time in my PHP code, i write links as relative links, so without HTTPS. I was thinking to check everything if the port is the SSL port (default : 443), but it does not mean that protocol is HTTPS. So,

[PHP] Security and methods

2006-12-02 Thread Alain Roger
Hi, After reading the documentation about security from phpsec.org, i see that 2 schools exist (dispatch method or include method). I do not see any huge difference between them. I would like to know what is the most suitable method to centralize security in 1 single file. thx. Alain

[PHP] alternative method

2006-12-02 Thread Alain Roger
Hi, Based on phpsec.org documentation it is written (between lines) that GET and POST methods are still used but they are not the most secured (except if we take care for that). So, i would like to know which other methods are more secured that those 2. thx. Alain

[PHP] security and .htaccess

2006-12-02 Thread Alain Roger
Hi, I'm working on .htaccess file for improving security. Based on documentation from PHPSEC.org, we should be able to store DB_USER login and DB_PASS password in some secret-stuff (for example) file, which should be located outside root of web document root. (for example in some /path_to_secret

Re: [PHP] How to be sure to use SSL

2006-12-02 Thread Alain Roger
: On Sat, December 2, 2006 2:17 am, Alain Roger wrote: I would like to know how can i be sure to make customer use the SSL all the time. all the time in my PHP code, i write links as relative links, so without HTTPS. I was thinking to check everything if the port is the SSL port (default

Re: [PHP] Security and methods

2006-12-02 Thread Alain Roger
for me. Alain On 12/2/06, Richard Lynch [EMAIL PROTECTED] wrote: On Sat, December 2, 2006 9:47 am, Alain Roger wrote: After reading the documentation about security from phpsec.org, i see that 2 schools exist (dispatch method or include method). I do not see any huge difference between them

Re: [PHP] LDAP password question

2006-11-30 Thread Alain Roger
Hi Ray, the question is for which reason you need to know something about the pwd ? to log on ? if yes, it's not needed. I personally did like that : 1. with login + pwd given by user, i try to bind. 2. if bind works, it means that user login+pwd are equal to AD login+pwd. 3. if error during

[PHP] security question

2006-11-22 Thread Alain Roger
Hi, Now that i finished the client side of the web application i would like to improve the security of my administration side of this web application. My web hoster support a shared SSL protocol, however i would like to do more than simply use the SSL... I've heard that cookies and sessions can

[PHP] MDB2 : never ending story

2006-11-13 Thread Alain Roger
Dear all, i still got the same error when i run this code : == Call to a member function fetchRow() on a non-object on line while (( so it seems that package MDB2_Driver_pgsql is not loaded or something is wrong... i'm really lost...4 days that i work on it without any solution...

Re: [PHP] MDB2 : never ending story

2006-11-13 Thread Alain Roger
And therefore how do you want to get the result set ? nothing is solved now... i still need a fetchrow or fetchOne On 11/13/06, Paul Scott [EMAIL PROTECTED] wrote: On Mon, 2006-11-13 at 17:49 +0100, Alain Roger wrote: Dear all, i still got the same error when i run this code : == Call

[PHP] Scrolling text

2006-11-13 Thread Alain Roger
Hi, I would like to have a scrolling text (as banner) on our website. I tried Marquee which work very well but since i use a table and allocate 100% to marquee, if the content of a row (tr content) is greater than 100% or the table width, internet explorer automatically write the message on

Re: [PHP] PEAR and MDB2

2006-11-12 Thread Alain Roger
so when i have this code : $options = array('debug' = 2, 'portability' = MDB2_PORTABILITY_ALL, ); $query = 'SELECT * from sp_u_001(\'all\')'; $db2 = new MDB2_Driver_pgsql(); $db2-connect($dsn);

[PHP] PEAR::MDB2 andquery

2006-11-12 Thread Alain Roger
Hi, I'm still wondering how are linked MDB2 class and MDB2_Driver_pgsql class. when i analyze the code of DB.php and pgsql.php, it's clear that DB.phpcheck a class based on phptype and therefore include the pgsql.php file. But i did not find something similar in MDB2.php. i would like to

Fwd: [PHP] PEAR and MDB2

2006-11-12 Thread Alain Roger
but the problem is before: $mdb2 = MDB2::connect($dsn); if (PEAR::isError($mdb2)) { die($mdb2-getMessage().brbr.$db2-getUserinfo()); } generate a : MDB2 Error: not found connect: [Error message: extension pgsql is not compiled

Re: [PHP] PEAR and MDB2

2006-11-12 Thread Alain Roger
it does not matter, query or exec produce the same error message : Error connection : MDB2 Error: not found connect: [Error message: extension pgsql is not compiled into PHP] :-( On 11/12/06, Roman Neuhauser [EMAIL PROTECTED] wrote: # [EMAIL PROTECTED] / 2006-11-12 09:46:34 +0100: so

[PHP] Re: PEAR::MDB2 andquery

2006-11-12 Thread Alain Roger
is that i can use pgsql without PEAR on my web pages without problem. So i will investigate more, the PEAR::loadExtension($this-phptype) function because there is the mistake. Alain On 11/12/06, Alain Roger [EMAIL PROTECTED] wrote: Hi, I'm still wondering how are linked MDB2 class

[PHP] PEAR and MDB2

2006-11-11 Thread Alain Roger
Hi, As i'm new to PEAR world, i try to understand how does it work. for that i took the MDB2 and try to use it with PostgreSQL. here is a basic sample extract from PEAR help file and only modified. require_once 'Pear/MDB2.php'; $dsn = 'pgsql://login:[EMAIL PROTECTED]'; $mdb2 =

[PHP] Re: MDB2 simple test

2006-11-11 Thread Alain Roger
that everything is correct. Al. On 11/11/06, Mark Wiesemann [EMAIL PROTECTED] wrote: Alain Roger wrote: I have a main_includes.php which include_once/require_once all needed things like MDB2.php or setpath for /pear folder Okay, but remember that the PEAR dir needs to in the include_path. Otherwise

[PHP] Fwd: MDB2 simple test

2006-11-11 Thread Alain Roger
-- Forwarded message -- From: Alain Roger [EMAIL PROTECTED] Date: Nov 11, 2006 12:26 PM Subject: Re: MDB2 simple test To: Mark Wiesemann [EMAIL PROTECTED] I have a main_includes.php which include_once/require_once all needed things like MDB2.php or setpath for /pear folder

[PHP] Re: MDB2 simple test

2006-11-11 Thread Alain Roger
on his server. in folder : F:\My documents\Development\Website\Immense\Pear, i have all standard PEAR folder installation files... e.g. PEAR.PHP, MDB2.PHP, and relative subfolders. Al. On 11/11/06, Alain Roger [EMAIL PROTECTED] wrote: Mark, this is my main_includes.php file : ?php $path

[PHP] MDB2 and PostgreSQL

2006-11-11 Thread Alain Roger
Hi, I'm still working on the issue with MDB2. i've checked the $mdb2 object and i discover that method doQuery does not exist when i write $mdb2- So it seems that MDB2.php does not pickup the datasource package pgsql.php. Therefore i would like to know if the following folder struture is

[PHP] convert postgres date to PHP

2006-11-11 Thread Alain Roger
Hi, in my database PosgreSQL i have stored some date in the following format : -MM-DD HH:MM:SS this is a real TimeStamp without time zone field format. Under PHP i would like to display this field as text with the following format DD.MM. How can i do that ? i was thinking to do :

[PHP] Re: convert postgres date to PHP

2006-11-11 Thread Alain Roger
. strtotime() http://www.php.net/manual/en/function.strtotime.php - tul P.S. RTFM! Alain Roger wrote: Hi, in my database PosgreSQL i have stored some date in the following format : -MM-DD HH:MM:SS this is a real TimeStamp without time zone field format. Under PHP i would like

[PHP] PEAR, MDB2 and MDB2_Driver_pgsql

2006-11-11 Thread Alain Roger
Hi, So i solved my problem with Pager, MDB2...therefore thanks a lot to everybody for your support. I have nevertheless still 1 question to which i need help. I would like to understand how MDB2_Driver_pgsql and MDB2 class are linked to each other ? i was thinking that the first one is derived

[PHP] path

2006-11-10 Thread Alain Roger
Hi, How can i get the path in which a PHP file is running ? for example, user clicking on a link opened page action.php file. this php file is located as C:\webserver\mywebsite\php\test\action.php how can i get this path (C:\webserver\mywebsite\php\test\)? thx. Al.

[PHP] Zend

2006-11-09 Thread Alain Roger
Hi, For my work, i bought Zend studio 5.2 and for sure when i installed it, it modified the path for the PHP.INI file to its local version. after checking the content of the php.ini file from Zend distribution, it seems to be a different version than the one from official PHP. I would like to

[PHP] php.ini

2006-11-09 Thread Alain Roger
Hi, everytime i install PHP, my php.ini must be installed in C:\windows\ folder. How can i do to force system to read php.ini file from C:\PHP\ folder only ? thanks. Alain

[PHP] access to DB and security

2006-11-08 Thread Alain Roger
Hi, My web hoster gave me a login and password with which i can connect to DB, perform some actions as DB owner / superuser just for my DB. If i use this login + password to connect and perform some actions from my web pages, everybody can hack my DB and do what they want. My web hoster will

Re: [PHP] access to DB and security

2006-11-08 Thread Alain Roger
is return to your PHP files (accessible on web). did i understood well ? Al. On 11/8/06, Satyam [EMAIL PROTECTED] wrote: - Original Message - From: Alain Roger [EMAIL PROTECTED] Hi, My web hoster gave me a login and password with which i can connect to DB, perform some actions

[PHP] Authentification and LDAP (SSO / Single Sign-On)

2006-11-07 Thread Alain Roger
Hi, I'm currently developing a PHP application as intranet tool for our company. I would like to make users connect to this tool with an authentification window where they can enter their domain login and password. via LDAP and Apache module mod_auth_ldap, i would like to check this user login

[PHP] OpenLDAP

2006-11-07 Thread Alain Roger
Hi, where can i find OpenLDAPftp://ftp.openldap.org/pub/OpenLDAP/openldap-stable/files already compiled ? i've downloaded the tar file, but i do not have a compiler with me... :-*( thx, Alain

[PHP] OpenLDAP

2006-11-07 Thread Alain Roger
Hi, I want to authenticate user by checking with our LDAP their login and password. For that, i need before to : 1- download LDAP client librairies OpenLDAP or Bind9 2- compile those librairies 3- Compile PHP with option == --with-ldap 4- Setup php.ini by removing semi-colon in front of ==

[PHP] postgreSQl and images

2006-11-04 Thread Alain Roger
Hi, I create a table with some large object (ref: OID) to store some images. When my PHP will display some data, it will also display the images stored as OID. However, i've read that before i must restore the image by exporting them to local (on server) file. isn't it easier in this case, to

[PHP] Pear

2006-11-04 Thread Alain Roger
Hi, I would like to know if a lot of people use the PEAR system (packages + core) to their web sites ? One of my colleague uses it for company internal usage, but i wonder if my web hoster will allow me to use and install it...because i have only a webftp access to my business web site...

[PHP] phpPgAdmin

2006-11-04 Thread Alain Roger
Hi, Is there a way via PhpPgAdmin to export/import the whole database info (structure, schema, tables, index, sequences, data...) ? Because i developed my database on local server and now i want to import to my web hoster server... and i do not want to recreate everything manually :-( thx,

[PHP] Issue when inserting Slovak characters in database via PHP code

2006-11-04 Thread Alain Roger
Hi, Sorry to cross post this mail but i'm not able to know from where comes my issue. I have a postgreSQL database in UNICODE (UTF-8 in v8.1.4 and UNICODE in v8.0.1). Via my web application i type a sentence in Slovak language and it is stored into DB without any slovak characters. Instead of

<    1   2   3   >