[PHP-DB] Re: Problem with dsn
Gian Michele wrote:
I have installed on my computer :
Apache 1.3
Php 4.1.2
Postgresql
the rpm of odbc and the unixODBC.
I tried to connect to my database after done all configurations; I used
the function odbc_pconnect('name_of_my_database','','') and the system
gives me this error
Warning: SQL error: [unixODBC][Driver Manager]Data source name not
found, and no default driver specified, SQL state IM002 in SQLConnect in
/var/www/html/check_avviso2.php on line 5
Does any body knows as set the DSN and the driver?
Have a look in the docs on the unixODBC web site, there are details there.
You need to create a system DSN, and use the name of that DSN in your
connect. Check that you can connect with isql before moving on to PHP.
--
Nick Gorham
Easysoft Limited
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Sessions and their function
Hi, I know this my sound stupid but here it goes.. Can sessions be used to pass variables from one page to the next to create persistent data? I have this working to a certain extent but can only pass a variable to my second page, but not from my second page onto the third. Also in my second page I cannot change the value of this variable i.e. bob = 100 on page 1, in page 2 I can display bob equalling 100 but then I want to a) alter the value of bob to 50 and b) send bob and its new value to third page. Can this be done by using sessions? Also how do you pass the session id of one page onto the next? do you pass it on the end of the page reference e.g. echo FORM METHOD=GET ACTION='msltest3.php'.SID.; Any help would be grateful even if it was to tell me that I have got the wrong idea about sessions altogehter. Thanks Mark CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the confidential use of the above named recipient. If you are not the intended recipient or person responsible for delivering it to the intended recipient, you have received this communication in error and must not distribute or copy it. Please accept the sender's apologies, notify the sender immediately by return e-mail and delete this communication. Thank you. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
AW: [PHP-DB] strange behavior
Hi, this isn't essantially DB-related It's a feature called transparent session id (activated at compile time with --enable-trans-sid). No need for ?=session_name().'='.session_id()? in most cases, as it is automatically added by PHP. And for the few times PHP can not add session information, you may use the SID define, which is automatically defined to session_name().session_id() if the user has turned off cookies. Read: http://php.net/session Thomas -Ursprüngliche Nachricht- Von: Martin Adler [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 12. September 2002 14:34 An: [EMAIL PROTECTED] Betreff: [PHP-DB] strange behavior Hi, i start a session on a entrypage with a form, and i wonder about the output to the browser. There appeared a input-field of the type hidden with the session-name as name and the session-id as value. How can I switch this PHP-behavior off? CODE td form name=focusedform action=index.php??=session_name().'='.session_id()? method=post input type=text name=auth_username size=22 maxlength=15 /td OUTPUT ... td form name=focusedform action=index.php?PHPSESSID=5ac37e23f46a3c2c1388201e3f4a951f method=postinput type=hidden name=PHPSESSID value=5ac37e23f46a3c2c1388201e3f4a951f / input type=text name=auth_username size=22 maxlength=15 /td ... greet Martin -- 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] strange behavior
Hi There, I don't know if this is the actual problem.. But in your form action it looks off. action=index.php??=session_name().'='.session_id()? Would produce something that looks like: index.php?123455667784332 What I think you WANT to do is... action=index.php?SID=?=session_name().'='.session_id()? When I need to put php code into a url (form or link) such as a $rerturn_url I usual do something like: form action=index.php?type_index=?php echo $type_index; ? method=post This would produce a url like: index.php?type_index=3 (assuming the type index selected was indeed 3) but you should understand what I mean. Don't know if this helps you at all but figured I'd take a shot. Regards, Aaron -Original Message- From: Martin Adler [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 8:34 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] strange behavior Hi, i start a session on a entrypage with a form, and i wonder about the output to the browser. There appeared a input-field of the type hidden with the session-name as name and the session-id as value. How can I switch this PHP-behavior off? CODE td form name=focusedform action=index.php??=session_name().'='.session_id()? method=post input type=text name=auth_username size=22 maxlength=15 /td OUTPUT ... td form name=focusedform action=index.php?PHPSESSID=5ac37e23f46a3c2c1388201e3f4a951f method=postinput type=hidden name=PHPSESSID value=5ac37e23f46a3c2c1388201e3f4a951f / input type=text name=auth_username size=22 maxlength=15 /td ... greet Martin -- 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] PreCaching Db into Variables Slows it down?!??
Cheers Patrick, I do keep them to a minimum, this is my 4th after the session variables. And I intend it to be my last. Andy Patrick Latour [EMAIL PROTECTED] wrote in message 001801c25a09$99e9d840$[EMAIL PROTECTED]">news:001801c25a09$99e9d840$[EMAIL PROTECTED]... Not yet a big specialist of PHP, but a rule that apply to nearly all server side scripting languages, use global variables as less as you can. They simplify your programer's life, but on a server that is serving a lot of concurent sessions, it eats all the performances and ressources. It does not explain your time problem, but it is my 2 cents before you place to much stuff in global variables. Thanks and regards, Patrick - Original Message - From: M1tch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 11, 2002 8:36 PM Subject: [PHP-DB] PreCaching Db into Variables Slows it down?!?? Grrr! Just spent ages (well, 2hours) on a precaching system for my PHP code that didn't work out! Hang on, I'll backtrack a bit... My website is using a php engine that picks at snippets of html from the database, and builds them up to form the page. A typical page may use 5 of these html snippets, each at maybe 5kb in size. I was sat thinking, looking at the debug-timer, and saw that the templates were one of the more time consuming aspects. So I said, I know, I'll save the db a bit, and at the start of the script, read all the templates that I'll need into a global variable, and call them from that. Simple, 5 db calls put into 1, and templates taken out of memory. So why, oh why, has the time taken actually increased??? Does anyone have sufficient working knowledge of PHP to give me a hint at why this has happened? Also, am I right in thinking that as the website hits increase, the db will be put under increasing pressure, so it serves off better being called only once instead of 5 times (Even though more data is taken out of it??). It's late, my eyes are blurring, and I'm annoyed. Very annoyed! Regards, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.385 / Virus Database: 217 - Release Date: 9/4/2002 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] sendmail
Hi Sorry to be off topic but I have problem with sendmail If anyone know sth about sendmail please e-mail priv. Sorry once more [EMAIL PROTECTED]
[PHP-DB] LDAP?
Hi list! Seen a lot of SQL stuff floating by, but my present, consuming interest is Openldap. Is this the right list, or should I subscribe to any other list? Best, Tony -- Tony Earnshaw Tha can allway tell a Yorkshireman, but tha canna tell 'im much. e-post: [EMAIL PROTECTED] www:http://www.billy.demon.nl gpg public key: http://www.billy.demon.nl/tonni.armor Telefoon: (+31) (0)172 530428 Mobiel: (+31) (0)6 51153356 GPG Fingerprint = 3924 6BF8 A755 DE1A 4AD6 FA2B F7D7 6051 3BE7 B981 3BE7B981 signature.asc Description: Dette er en digitalt signert meldingsdel
[PHP-DB] previous and next links with php postgresql
Hi I am trying to have previous and next links in my php script wich i make a select from a table. I am using postgresql anybody has a link for a tutorial or a sample code doing this? Ângelo Marcos Rigo Webmaster Colégio Anchieta http://www.colegioanchieta.g12.br -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] previous and next links with php postgresql
http://www.webmasterbase.com/article/662 -Original Message- From: Angelo Marcos Rigo [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 11:48 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] previous and next links with php postgresql Hi I am trying to have previous and next links in my php script wich i make a select from a table. I am using postgresql anybody has a link for a tutorial or a sample code doing this? Ângelo Marcos Rigo Webmaster Colégio Anchieta http://www.colegioanchieta.g12.br -- 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
[PHP-DB] php start-stop howto?
RedHat Linux 7.2 RPM installation included: PostgreSQL 7.1.3 PHP 4.0.6 Had no problem creating a database using pg but can't find the on/off button for php. PHP is installed in /usr/bin/php; /etc/php.ini; /usr/share/php I edited the php.ini file to specify a location for; usr_dir = The manual for PHP 4.2 (I have 4.0) suggested uncommenting extra module lines in http.conf. I don't know if that is an Apache, Linux or PHP file, but I can't find it in any of them. If I just start typing the hello world script linux wants to execute it after the first line. Put the entire script in an executable file and it doesn't like that either. What do I do next? Thanks, Warren _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php start-stop howto?
look in /etc/httpd/conf/httpd.conf when you restart apache (/etc/rc.d/init.d/httpd restart) it restarts php because php is called by apache. Adam On Thu, 12 Sep 2002, Warren Massengill wrote: RedHat Linux 7.2 RPM installation included: PostgreSQL 7.1.3 PHP 4.0.6 Had no problem creating a database using pg but can't find the on/off button for php. PHP is installed in /usr/bin/php; /etc/php.ini; /usr/share/php I edited the php.ini file to specify a location for; usr_dir = The manual for PHP 4.2 (I have 4.0) suggested uncommenting extra module lines in http.conf. I don't know if that is an Apache, Linux or PHP file, but I can't find it in any of them. If I just start typing the hello world script linux wants to execute it after the first line. Put the entire script in an executable file and it doesn't like that either. What do I do next? Thanks, Warren _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] randomizing amounts of html displayed
Hi All.. Quick question and perhaps a suggestion/solution requst to the above topic. My brain is just not working :( I have a HTML table with 5 rows of data. I would like to randomly display 3 of the 5 rows when the page is accessed. For example: Row 1 Row 2 Row 3 Row 4 Row 5 When the page is loaded only Row 1,2 and 4 are displayed. When someone else loads the page rows 2,4 and 5 are displayed. Any clues on how to make this possible?? Thanks in advance for looking. Peace. Aaron
Re: [PHP-DB] php start-stop howto?
Hay! It worked. A minor miracle... Thanks From: Adam Williams [EMAIL PROTECTED] To: Warren Massengill [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: [PHP-DB] php start-stop howto? Date: Thu, 12 Sep 2002 13:19:03 -0500 (CDT) look in /etc/httpd/conf/httpd.conf when you restart apache (/etc/rc.d/init.d/httpd restart) it restarts php because php is called by apache. Adam On Thu, 12 Sep 2002, Warren Massengill wrote: RedHat Linux 7.2 RPM installation included: PostgreSQL 7.1.3 PHP 4.0.6 Had no problem creating a database using pg but can't find the on/off button for php. PHP is installed in /usr/bin/php; /etc/php.ini; /usr/share/php I edited the php.ini file to specify a location for; usr_dir = The manual for PHP 4.2 (I have 4.0) suggested uncommenting extra module lines in http.conf. I don't know if that is an Apache, Linux or PHP file, but I can't find it in any of them. If I just start typing the hello world script linux wants to execute it after the first line. Put the entire script in an executable file and it doesn't like that either. What do I do next? Thanks, Warren _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Help with special characters in Oracle 8i
Hello All, I am running PHP 4.2 with Oracle 8.1.7. I am trying execute the following statement. insert into job_application values (NULL,'Unix','Mobile','Alabama','http://www.google.com/search?q=php+insert+oracle+special+characters\hl=en\lr=\ie=UTF-8\oe=UTF-8\start=30\sa=N','12-SEP-02'); As you can see I am trying to insert a url into the database and it keeps dying on the special characters in the url. I have tried executing the following command in SqlPlus( set escape \ ) and this sql statement works from command line. I cannot make this work from my php script. Any insight into this problem would be appreciated. Eric Seneca
Re: [PHP-DB] randomizing amounts of html displayed
? $numbers = range (0,4); srand ((float)microtime()*100); shuffle ($numbers); for($i=0; $i3; $i++) echo 'row'.$numbers[$i].\n; ? Op donderdag 12 september 2002 20:58, schreef Aaron Wolski: Hi All.. Quick question and perhaps a suggestion/solution requst to the above topic. My brain is just not working :( I have a HTML table with 5 rows of data. I would like to randomly display 3 of the 5 rows when the page is accessed. For example: Row 1 Row 2 Row 3 Row 4 Row 5 When the page is loaded only Row 1,2 and 4 are displayed. When someone else loads the page rows 2,4 and 5 are displayed. Any clues on how to make this possible?? Thanks in advance for looking. Peace. Aaron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
