[PHP-DB] PHP and table/view names with '$'

2009-04-23 Thread Mark Casson
Hi, I am trying to access some of the v$ views using php on iis, with admin privileges. However, using: $stmt = OCIParse($conn, SELECT * FROM v$sql); gives me this error: PHP Notice: undefined variable: sql . . . Is there a way around this? Thanks Mark -- PHP Database Mailing List

RE: [PHP-DB] PHP and table/view names with '$'

2009-04-23 Thread N . A . Morgan
] Sent: 23 April 2009 11:04 To: php-db@lists.php.net Subject: [PHP-DB] PHP and table/view names with '$' Hi, I am trying to access some of the v$ views using php on iis, with admin privileges. However, using: $stmt = OCIParse($conn, SELECT * FROM v$sql); gives me this error: PHP Notice

Re: [PHP-DB] PHP and table/view names with '$'

2009-04-23 Thread Yves Sucaet
What if you use back-quotes `` around the table/view name? $stmt = OCIParse($conn, SELECT * FROM `v$sql`); - Original Message - From: n.a.mor...@bton.ac.uk To: Mark Casson confu...@icube.co.uk; php-db@lists.php.net Sent: Thursday, April 23, 2009 5:25 AM Subject: RE: [PHP-DB] PHP

Re: [PHP-DB] PHP and table/view names with '$'

2009-04-23 Thread Mark Casson
* FROM `v$sql`); - Original Message - From: n.a.mor...@bton.ac.uk To: Mark Casson confu...@icube.co.uk; php-db@lists.php.net Sent: Thursday, April 23, 2009 5:25 AM Subject: RE: [PHP-DB] PHP and table/view names with '$' I find that using single quotes rather than double quotes

Re: [PHP-DB] PHP and table/view names with '$'

2009-04-23 Thread Yves Sucaet
: n.a.mor...@bton.ac.uk To: Mark Casson confu...@icube.co.uk; php-db@lists.php.net Sent: Thursday, April 23, 2009 5:25 AM Subject: RE: [PHP-DB] PHP and table/view names with '$' I find that using single quotes rather than double quotes prevents variable substitution. I don't know

[PHP-DB] php date/time zone

2009-03-18 Thread Ron
Hi All, I have a form where in a user will enter a time and choose a timezone. based on those, i need to insert to db the time as the actual time on their timezone. how can i compute that on php? is it possible? hope i'm not confusing. tnx regards Ron -- PHP Database Mailing List

Re: [PHP-DB] php date/time zone

2009-03-18 Thread Chris
Ron wrote: Hi All, I have a form where in a user will enter a time and choose a timezone. based on those, i need to insert to db the time as the actual time on their timezone. how can i compute that on php? is it possible? You should do this the other way. Store everything in GMT, then

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread Mark Halling-Brown
Thanks for your replies. In my desperation, I declared those environment variables in as many places as I could think of. The script (Although I know I shouldnt), php.ini and also the apache httpd.conf file: SetEnv ORACLE_HOME /opt/oracle/instanceclient SetEnv DYLD_LIBRARY_PATH

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread chris smith
On Mon, Mar 16, 2009 at 6:51 PM, Mark Halling-Brown mhallingbr...@icr.ac.uk wrote: Thanks for your replies. In my desperation, I declared those environment variables in as many places as I could think of. The script (Although I know I shouldnt), php.ini and also the apache httpd.conf file:

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread Mark Halling-Brown
Did you restart apache after doing this? Yes, many times The env variables are set correctly for your user, but not apache's (which is the problem). Indeed, I have removed the putenv declarations in the php script and inserted this: echo(Using LD_LIBRARY_PATH: .

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread Grant Croker
On/El 16/03/09 09:23, chris smith wrote/escribió: On Mon, Mar 16, 2009 at 6:51 PM, Mark Halling-Brown mhallingbr...@icr.ac.uk wrote: Thanks for your replies. In my desperation, I declared those environment variables in as many places as I could think of. The script (Although I know I

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread Mark Halling-Brown
Hi Grant, Thanks to your instructions, I am making a bit of progress. I have entered the PassEnv commands into the https.conf.: SetEnv DYLD_LIBRARY_PATH /opt/oracle/instanceclient SetEnv LD_LIBRARY_PATH /opt/oracle/instanceclient PassEnv DYLD_LIBRARY_PATH PassEnv LD_LIBRARY_PATH It now seems

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread Grant Croker
Hi Mark, you are right /System/Library/LaunchDaemons/org.apache.httpd.plist will not work in your case, it's for the Mac OS X supplied Apache. In your case you can edit /usr/local/apache2/bin/apachectl adding the following: DYLD_LIBRARY_PATH=/opt/oracle/instanceclient

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread Mark Halling-Brown
Grant, thank you very much. You are a life saver. This worked perfectly. Thanks again Mark On 16 Mar 2009, at 11:53 AM, Grant Croker wrote: Hi Mark, you are right /System/Library/LaunchDaemons/org.apache.httpd.plist will not work in your case, it's for the Mac OS X supplied Apache. In

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-16 Thread Christopher Jones
Grant Croker wrote: DYLD_LIBRARY_PATH=/opt/oracle/instanceclient LD_LIBRARY_PATH=/opt/oracle/instanceclient ORACLE_BASE=/opt/oracle/instanceclient ORACLE_HOME=/opt/oracle/instanceclient export DYLD_LIBRARY_PATH LD_LIBRARY_PATH ORACLE_BASE ORACLE_HOME (note: As Chris Jones mentioned

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-15 Thread Chris
Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that LD_LIBRARY_PATH includes the directory with Oracle Instant Client libraries in/Library/WebServer/Documents/oracle.php on line 25 Oracle Connect Error

Re: [PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-15 Thread Christopher Jones
Chris wrote: Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that LD_LIBRARY_PATH includes the directory with Oracle Instant Client libraries in/Library/WebServer/Documents/oracle.php on line 25 Oracle

[PHP-DB] Php, Oracle on Mac, with strange behaviour

2009-03-13 Thread Mark Halling-Brown
Dear List, I have a puzzler, which I can't seem to fix. To summarise, I have installed PHP, apache from source and the oracle client (details below). I then construct a simple PHP script to connect to my oracle database. When I run the script from the command line, it works perfectly, and

Re: [PHP-DB] PHP Results on multiple pages

2009-02-03 Thread Tariq Ismail Dalvi
Hello Guys, Thank you for your help and suggestions the search script with pagination is working now i may add bells and rebins to it later. Thanks again to Chris you really put me on track. Best regards Tariq Dalvi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] PHP Results on multiple pages

2009-01-28 Thread Tariq Ismail Dalvi
Hello Chris, I am inserting complete script for you to have a look at and was using $s = $pages // Get the search variable from URL $var = @$_GET['q'] ; $trimmed = trim($var); //trim whitespace from the stored variable // rows to return $limit=10; // check for an empty string and display

Re: [PHP-DB] PHP Results on multiple pages

2009-01-28 Thread Chris
Tariq Ismail Dalvi wrote: Hello Chris, I am inserting complete script for you to have a look at and was using $s = $pages // Get the search variable from URL $var = @$_GET['q'] ; $trimmed = trim($var); //trim whitespace from the stored variable // rows to return $limit=10; // check for

Re: [PHP-DB] PHP Results on multiple pages

2009-01-26 Thread Chris
This script do everything fine counting total records it display's 1 to 10 records on first page with numbers but second location where i want it to display Showing results 1 to 10 it shows 17 to 26 second it displays a link to Next but not working. It takes roughly 20 secs to do a search?

[PHP-DB] PHP Results on multiple pages

2009-01-25 Thread Tariq Ismail Dalvi
Hello guys, I am having a search script which supose to take results out of my mysql database and display on a page 10 results if the results are more then 10 it should create another page or pages with Next and Prev link so anyone can move forward and backward on those results page. This

[PHP-DB] php crashes on mysql_connect

2008-12-11 Thread Peter Degen-Portnoy
Hi Folks, I've been banging against this for a while and have narrowed it down to a completely repeatable and tiny test case. The issue is that any mysql_connect call hangs and causes a segmentation fault in php5ts.dll. Here are the specifics: I am running on Windows XP, SP2, Single Athlon 64

Re: [PHP-DB] php crashes on mysql_connect

2008-12-11 Thread Chris
Peter Degen-Portnoy wrote: Hi Folks, I've been banging against this for a while and have narrowed it down to a completely repeatable and tiny test case. http://bugs.php.net/ Best place to post it and get it fixed. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database

Re: [PHP-DB] php crashes on mysql_connect

2008-12-11 Thread Peter Degen-Portnoy
Thanks, Chris. - Peter On Fri, Dec 12, 2008 at 1:10 AM, Chris dmag...@gmail.com wrote: Peter Degen-Portnoy wrote: Hi Folks, I've been banging against this for a while and have narrowed it down to a completely repeatable and tiny test case. http://bugs.php.net/ Best place to post it

[PHP-DB] php script to automate the loading of gpx/shp to postgres using ogr2ogr

2008-11-20 Thread S.Reena
Hi All, I want to automate the conversion of gpx/shp file to postgres database..as when user uploads the file to a specified folder...ogr2ogr command is activated to convert gpx to postgres Can any1 suggest some script or something for this (using php ) ...Also whether OGR/PHP extension will

Re: [PHP-DB] php script to automate the loading of gpx/shp to postgres using ogr2ogr

2008-11-20 Thread Chris
S.Reena wrote: Hi All, I want to automate the conversion of gpx/shp file to postgres database..as when user uploads the file to a specified folder...ogr2ogr command is activated to convert gpx to postgres Can any1 suggest some script or something for this (using php ) ...Also whether

[PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Micah Gersten
Which is the fastest driver for this? ADODB PDO mysqli Anything else? -- Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Chris
Micah Gersten wrote: Which is the fastest driver for this? ADODB PDO mysqli Either mysqli or pdo since they'd deal with the mysql client directly. ADODB is a php library, so it's not going to be as fast because you have php code overhead. -- Postgresql php tutorials

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread YVES SUCAET
How does the default php_mysql.dll compare to these? Is mysqli faster than mysql? tia, Yves -- Original Message -- Received: Wed, 19 Nov 2008 04:00:46 PM CST From: Chris [EMAIL PROTECTED] To: Micah Gersten [EMAIL PROTECTED]Cc: PHP DB php-db@lists.php.net Subject: Re: [PHP-DB] PHP MySQL

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Micah Gersten
Chris wrote: Micah Gersten wrote: Which is the fastest driver for this? ADODB PDO mysqli Either mysqli or pdo since they'd deal with the mysql client directly. ADODB is a php library, so it's not going to be as fast because you have php code overhead. ADODB is precompiled for PHP5.

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Chris
Micah Gersten wrote: Chris wrote: Micah Gersten wrote: Which is the fastest driver for this? ADODB PDO mysqli Either mysqli or pdo since they'd deal with the mysql client directly. ADODB is a php library, so it's not going to be as fast because you have php code overhead. ADODB is

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Chris
YVES SUCAET wrote: How does the default php_mysql.dll compare to these? Is mysqli faster than mysql? I'd call that a native driver. No idea about mysqli vs mysql. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Micah Gersten
Chris wrote: Micah Gersten wrote: Chris wrote: Micah Gersten wrote: Which is the fastest driver for this? ADODB PDO mysqli Either mysqli or pdo since they'd deal with the mysql client directly. ADODB is a php library, so it's not going to be as fast because you have php code overhead.

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread Chris
Micah Gersten wrote: Chris wrote: Micah Gersten wrote: Chris wrote: Micah Gersten wrote: Which is the fastest driver for this? ADODB PDO mysqli Either mysqli or pdo since they'd deal with the mysql client directly. ADODB is a php library, so it's not going to be as fast because you have

Re: [PHP-DB] PHP Exercises

2008-11-01 Thread Twaha Uddessy
Isaak, Thank you for your advice.Got one book. Thank you again From: Isaak Malik [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Friday, October 31, 2008 3:13:14 PM Subject: Re: [PHP-DB] PHP Exercises In my opinion the best way to learn it is by getting

Re: [PHP-DB] PHP Exercises

2008-11-01 Thread Twaha Uddessy
Yves, Thank you for the link.I will go through it. cheers From: Yves Sucaet [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Friday, October 31, 2008 3:52:06 PM Subject: Re: [PHP-DB] PHP Exercises Hi Twaha, Have a look at a short-course curriculum that we

Re: [PHP-DB] PHP Exercises

2008-11-01 Thread Isaak Malik
You're very welcome, after you get some experience it's also a very good thing to read other people's work, but I only recommend this when you already know the basics and have quite a thorough knowledge of the most used functions including: array, string and variable specific functions. There are

[PHP-DB] PHP Exercises

2008-10-31 Thread Twaha Uddessy
Hello all, Iam new here,trying hard to study PHP.Can anyone help me with a link where I can get PHP exercises and possible solution?. Thank you in advance

Re: [PHP-DB] PHP Exercises

2008-10-31 Thread Sanjay Mantoor
Twaha, I found PHP manual is best. Refer http://www.php.net/manual/en/ On Fri, Oct 31, 2008 at 1:49 PM, Twaha Uddessy [EMAIL PROTECTED] wrote: Hello all, Iam new here,trying hard to study PHP.Can anyone help me with a link where I can get PHP exercises and possible solution?. Thank you

Re: [PHP-DB] PHP Exercises

2008-10-31 Thread Twaha Uddessy
Sanjay, Thanks for your help!.I will go through it. Twaha From: Sanjay Mantoor [EMAIL PROTECTED] To: Twaha Uddessy [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Friday, October 31, 2008 11:36:20 AM Subject: Re: [PHP-DB] PHP Exercises Twaha, I found PHP

Re: [PHP-DB] PHP Exercises

2008-10-31 Thread Isaak Malik
In my opinion the best way to learn it is by getting a book from your local library as reading from the screen can get very exhausting after a while. The manual is only good to increase your knowledge when you already know the basics. -- Isaak Malik Web Developer

Re: [PHP-DB] PHP Exercises

2008-10-31 Thread Yves Sucaet
Hi Twaha, Have a look at a short-course curriculum that we developed over summer: http://lab.bcb.iastate.edu/training/webdev/nmsu/ hth, Yves - Original Message - From: Twaha Uddessy [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Friday, October 31, 2008 2:19 AM Subject: [PHP-DB

[PHP-DB] PHP Self pages

2008-08-12 Thread kitfox69
I have three PHP pages that post data to each consecutive page. I would like the second page, the one with a pull down menu of customer ids, to spawn itself onto the next page so that the person using it would not have to click back to choose the next customer id. Currently the first page

Re: [PHP-DB] PHP Self pages

2008-08-12 Thread Micah Gersten
Try this: http://xajaxproject.org/ Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com [EMAIL PROTECTED] wrote: I have three PHP pages that post data to each consecutive page. I would like the second page, the one with a pull down menu of customer ids, to

Re: [PHP-DB] PHP 5.2.6 integrating MYSQL 5.0.51b on APACHE 2.0.63 + Windows XP SP2)

2008-06-29 Thread simonclur
PHP v5.2.6 requires to the php_mysql.dll (v5.2.6) dll to connect to MySql. It appears the PHP v5.2.6 .msi installation package apparently does not copy the new php_mysql.dll into the ./ext directory as it is supposed to. Download the .zip version of php v5.2.6 and copy the php_mysql.dll file

[PHP-DB] php upload questions --move_uploaded_file

2008-06-26 Thread Liu, Hai Tao (Taylor)
Hi all: I meet a very strange problem about php upload. Usually, we use move_uploaded_file to upload, but it could not work in flex use php to upload. Same Php upload code can work in html page, and move_uploaded_file function will return 1; But it could not work in flex, and

Re: [PHP-DB] php upload questions --move_uploaded_file

2008-06-26 Thread Daniel Brown
Hai, I'm forwarding this email over to the PHP-General list, since it's not database-related. If you're not already subscribed there, please subscribe and I'm sure you'll get some responses. ORIGINAL MESSAGE FOLLOWS: On Thu, Jun 26, 2008 at 6:21 AM, Liu, Hai Tao (Taylor) [EMAIL

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-20 Thread Evert Lammerts
I should've checked the assumption. A little strange though for a scripting language. I'd say, since default behaviour of mysql_* functions is to assume the last opened link when a parameter is not passed, and since default behaviour is to evaluate null, false and 0 the same, mysql_* functions

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-19 Thread Isaak Malik
My mistake then, it's been a while that I used it that way so some things do fade away from my mind. On Thu, Jun 19, 2008 at 1:57 AM, Chris [EMAIL PROTECTED] wrote: Isaak Malik wrote: Because then the connection resource isn't stored in the $link variable and you will be able to use the

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-19 Thread bateivan
Hello Isaak, You've scored the bulleye! It works! Also, I tested by including common.php instead of database.php and it worked too. This solution is perfect for me as I can keep my code compact and tidy. I would, definetely, recommend this site to my fellow developers. Thank you very much,

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-19 Thread Isaak Malik
It's great that you got your problem solved :). On Thu, Jun 19, 2008 at 12:30 PM, bateivan [EMAIL PROTECTED] wrote: Hello Isaak, You've scored the bulleye! It works! Also, I tested by including common.php instead of database.php and it worked too. This solution is perfect for me as I can

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-19 Thread bateivan
: http://myprojects.srhost.info eric{at}myprojects{dot}srhost{dot}info - Original Message - From: bateivan [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Tuesday, June 17, 2008 11:19 PM Subject: [PHP-DB] PHP-MySQL connection

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-19 Thread Chris
[new code] if (!mysql_connect($a, $b, $c)) return; if (!mysql_select_db($dbname)) return; $res = mysql_query(SELECT * FROM manual;, $link); [/new code] Isn't going to work because $link is not defined and definitely not a resource like mysql_query expects. OR, optionally, to surpress

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread Isaak Malik
Because then the connection resource isn't stored in the $link variable and you will be able to use the mysql functions without passing that variable to each function. On Wed, Jun 18, 2008 at 1:51 AM, Chris [EMAIL PROTECTED] wrote: It means that either your mysql conenction details are not

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread bateivan
Thank you, Chris, I tried your suggestion using regular connection. Unfortunately, I got the same result. See my reply to Isaak,s reply where I am going to post portion of my code to visualize what I am talking about. Thanx again chris smith-9 wrote: It means that either your mysql

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread bateivan
Hello, To answer these qwestions: 1. I am using include in my code. 2. About the $link = mysql_connect('localhost', 'root', 'testing'); variable. I can just include this line before mysql_query function and it works even without entering into mysql_query the $link variable. (Like the connection

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread Evert Lammerts
Pastebin works lots better when you're posting code: www.pastebin.com I don't see your database.php included in both of these modules. Where do you include it? EVert On Wed, Jun 18, 2008 at 9:38 PM, bateivan [EMAIL PROTECTED] wrote: Hello, To answer these qwestions: 1. I am using include

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread Isaak Malik
To Evert: 4. I am posting some of my code to compare. Module carmade.php works v.s. login.php which does not. Also, I am posting my database.php which is establishing the connection and is included in every page through layout.php-common.php-database.php. To bateivan: I can only guess that the

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-18 Thread Chris
Isaak Malik wrote: Because then the connection resource isn't stored in the $link variable and you will be able to use the mysql functions without passing that variable to each function. RTM again. The link parameter is completely optional. If you don't specify it, it uses the last

[PHP-DB] PHP-MySQL connection for particular module

2008-06-17 Thread bateivan
Hello, First of all, please, have in mind that I am new in this business. I have a problem connecting with data base in one particular module. That's right. The rest of the modules can connect to db, update tables with new info but this one is refusing giving me message like this: Warning:

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-17 Thread Isaak Malik
If you get an error of this kind: Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\Program Files\Apache Software Foundation\Apache2.2\htdocs\login.php on line 17 Warning: mysql_query() [function.mysql-query]: A link to the server

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-17 Thread Eric
http://myprojects.srhost.info eric{at}myprojects{dot}srhost{dot}info - Original Message - From: bateivan [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Tuesday, June 17, 2008 11:19 PM Subject: [PHP-DB] PHP-MySQL connection

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-17 Thread Chris
It means that either your mysql conenction details are not correctly set or the connection resource isn't accessible for your mysql functions. I suggest you first try by replacing: $link = mysql_pconnect('localhost', 'root', 'testing'); into: mysql_pconnect('localhost', 'root',

Re: [PHP-DB] PHP-MySQL connection for particular module

2008-06-17 Thread Roberto Carlos García Luís
excuseme but, you can access by terminal? [shell] ODBC is the user? or is a ODBC database? Please answer me and i can help you. **Excuse me my english is bad. :( El 17/06/2008, a las 06:51 p.m., Chris escribió: It means that either your mysql conenction details are not correctly set or

RE: [PHP-DB] PHP to MS SQL Package

2008-06-13 Thread Wei, Alice J.
To: Wei, Alice J. Cc: Olavi ivask; php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package That error message tells you that you are getting closer. Next step would be to make sure you have a connection to that system: $ ping 192.168.10.128 Next thing I would do is see if that port is open

Re: [PHP-DB] PHP to MS SQL Package

2008-06-13 Thread Dee Ayy
http://php.he.net/manual/en/mssql.installation.php Installation The MSSQL extension is enabled by adding extension=php_mssql.dll to php.ini. To get these functions to work, you have to compile PHP with --with-mssql[=DIR], where DIR is the FreeTDS install prefix. And FreeTDS should be compiled

[PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Wei, Alice J.
Hi, I am currently using a Linux box with Fedora 9.0 and I am trying to connect PHP to a MS SQL database. All the permissions on the MS SQL database is up to date and accurate, but I consistently get errors that say PHP Fatal error: Call to undefined function mssql_connect() in

Re: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Olavi ivask
Hi, you need to install freetds before compiling php. compile php: ./configure [--with-apxs --with-mysql...] --with-sybase=/usr/local/freetds make make install Olavi Ivask On Thu, 2008-06-12 at 12:14 -0400, Wei, Alice J. wrote: Hi, I am currently using a Linux box with Fedora 9.0 and I

RE: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Wei, Alice J.
From: Olavi ivask [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 12:57 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package Hi, you need to install freetds before compiling php. compile php: ./configure [--with-apxs --with-mysql...] You actually meant

Re: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Ken Keefe
Alice, make sure the php-mssql package is installed. # yum install php-mssql You shouldn't have to compile php or freetds as there are packages available to do what you want... Ken On Thu, Jun 12, 2008 at 11:14 AM, Wei, Alice J. [EMAIL PROTECTED] wrote: Hi, I am currently using a Linux box

RE: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Wei, Alice J.
: Re: [PHP-DB] PHP to MS SQL Package Hi, you need to install freetds before compiling php. compile php: ./configure [--with-apxs --with-mysql...] --with-sybase=/usr/local/freetds make make install Olavi Ivask On Thu, 2008-06-12 at 12:14 -0400, Wei, Alice J. wrote: Hi, I am currently using

RE: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Wei, Alice J.
From: Ken Keefe [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 1:44 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package Alice, make sure the php-mssql package is installed. # yum install php-mssql You shouldn't have

RE: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Olavi ivask
of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] From: Olavi ivask [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 12:57 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package Hi, you

Re: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Ken Keefe
] wrote: From: Ken Keefe [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 1:44 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package Alice, make sure the php-mssql package is installed. # yum install php-mssql You

[PHP-DB] PHP - FreeTDS - UnixODBC - MS-SQL Am I missing something....

2008-06-12 Thread Bill Sappington
Hey there folks... OK, so I am getting to the point where I am not sure where to look... It would seem that the combination of PHP ODBC are just not happy. This is running on SLES 10 SP1, php 5.1.2 Zend Eng 2.1.0 FreeTDS is latest stable, UNIXOdbc Latest Stable I can connect just fine ie:

RE: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Wei, Alice J.
2:20 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: RE: [PHP-DB] PHP to MS SQL Package Hello, Here is a good article about ms-sql PHP on Linux (http://www.devarticles.com/index2.php?option=contenttask=viewid=667pop=1page=0hide_js=1) Olavi Ivask On Thu, 2008-06-12 at 13:43 -0400, Wei

Re: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Ken Keefe
== Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] From: Olavi ivask [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 2:20 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: RE: [PHP-DB

Re: [PHP-DB] PHP 5.2.6 integrating MYSQL 5.0.51b on APACHE 2.0.63 + Windows XP SP2)

2008-05-14 Thread Jeff88
jeff88 wrote: chris smith-9 wrote: Did you restart apache? Stupid question I know but best to check. Any errors in the apache logs? Did you edit the right php.ini file? Look at the phpinfo() page and see which file it's loading from. --- I did restart the Apache and even the pc. I

Fwd: [PHP-DB] PHP 5.2.6 integrating MYSQL 5.0.51b on APACHE 2.0.63 + Windows XP SP2)

2008-05-14 Thread Isaak Malik
-- Forwarded message -- From: Isaak Malik [EMAIL PROTECTED] Date: Wed, May 14, 2008 at 4:07 PM Subject: Re: [PHP-DB] PHP 5.2.6 integrating MYSQL 5.0.51b on APACHE 2.0.63 + Windows XP SP2) To: Jeff88 [EMAIL PROTECTED] Make sure that you have httpd.conf correctly configured to load

[PHP-DB] PHP 5.2.6 integrating MYSQL 5.0.51b on APACHE 2.0.63 + Windows XP SP2)

2008-05-13 Thread Jeff88
Hi, Good Day! I have problem in getting the PHP 5.2.6 to integrate with MYSQL 5.0.51b. I had done the following installations and configurations on Windows XP (SP2): 1. Installed APACHE 2.0.63 - running fine 2. Installed PHP 5.2.6 - running fine 3. Configured httpd.conf and php.ini - PHP and

Re: [PHP-DB] PHP 5.2.6 integrating MYSQL 5.0.51b on APACHE 2.0.63 + Windows XP SP2)

2008-05-13 Thread Chris
Jeff88 wrote: Hi, Good Day! I have problem in getting the PHP 5.2.6 to integrate with MYSQL 5.0.51b. I had done the following installations and configurations on Windows XP (SP2): 1. Installed APACHE 2.0.63 - running fine 2. Installed PHP 5.2.6 - running fine 3. Configured httpd.conf

[PHP-DB] php and mssql on seperate servers

2008-04-24 Thread Rick Taylor
I'm new to PHP and having issues. We have seperate servers for them. We can use ODBC to test the connection and it works fine. However, when we try to run the site we get a message of *** Error: Unable to Connect to Database. Please Try Again Later. *** We are using a custom app that we

[PHP-DB] php database

2008-04-18 Thread nickthegreek-
hello to everyone.. what i wanna.. is to send me the total code from the connection in the database until the end what i wanna is i have a connection in database and i wanna my page to show a dropdown menu whick shows the column name in my database select name from xxx when i select a name

Re: [PHP-DB] php database

2008-04-18 Thread Jason Pruim
On Apr 18, 2008, at 7:35 AM, nickthegreek- wrote: hello to everyone.. what i wanna.. is to send me the total code from the connection in the database until the end what i wanna is i have a connection in database and i wanna my page to show a dropdown menu whick shows the column name

Re: [PHP-DB] php + mysql + copy file

2008-04-04 Thread tacio vilela
Hi, try this, $carpeta = $_SERVER['DOCUMENT_ROOT']./subidos; // nombre de la carpeta ya creada. chmool 777 (todos los permisos) copy($_FILES['file']['tmp_name'] , $carpeta . $_FILE['file']['name']); Regards, Tacio Vilela 2008/4/2 Chris [EMAIL PROTECTED]: $carpeta = subidos; //

[PHP-DB] php + mysql + copy file

2008-04-02 Thread Emiliano Boragina
Hello I have the next code: -- archive_a_subir.php -- form action=archivo_subir.php method=post enctype=multipart/form-data input type=file name=file input type=submit value=ADJUNTAR ARCHIVO /form In archive_subir.php: ? $carpeta = subidos; // nombre de

Re: [PHP-DB] php + mysql + copy file

2008-04-02 Thread Chris
$carpeta = subidos; // nombre de la carpeta ya creada. chmool 777 (todos los permisos) copy($_FILES['file']['tmp_name'] , $carpeta . '/' . $_FILE ['file']['name']); It's $_FILES not $_FILE (an 's' on the end). It's always worth using error_reporting(E_ALL) and

Re: [PHP-DB] PHP, MySQL and Lookups

2008-02-27 Thread Daniel Brown
On Wed, Feb 27, 2008 at 9:52 AM, Tobias Franzén [EMAIL PROTECTED] wrote: Consider this, if you have not already: What if two users happen to have the same password? It is wrong to assume that no two users will never have the same password. Doing an update like that, just based on the

Re: [PHP-DB] PHP, MySQL and Lookups

2008-02-27 Thread Tobias Franzén
Daniel Brown wrote: On Tue, Feb 26, 2008 at 8:55 AM, Henry Felton [EMAIL PROTECTED] wrote: Hi everyone, I'm just getting into PHP at the moment and was wondering; what code would I need to look at a field value entered in a form, then if that value is found in my table, enter all the

[PHP-DB] PHP, MySQL and Lookups

2008-02-26 Thread Henry Felton
Hi everyone, I'm just getting into PHP at the moment and was wondering; what code would I need to look at a field value entered in a form, then if that value is found in my table, enter all the other information entered in the form, to the other fields on that record. Basically, what I'm trying

Re: [PHP-DB] PHP, MySQL and Lookups

2008-02-26 Thread Jason Pruim
On Feb 26, 2008, at 8:55 AM, Henry Felton wrote: Hi everyone, I'm just getting into PHP at the moment and was wondering; what code would I need to look at a field value entered in a form, then if that value is found in my table, enter all the other information entered in the form, to

RES: [PHP-DB] PHP, MySQL and Lookups

2008-02-26 Thread Thiago Pojda
@lists.php.net Assunto: [PHP-DB] PHP, MySQL and Lookups Hi everyone, I'm just getting into PHP at the moment and was wondering; what code would I need to look at a field value entered in a form, then if that value is found in my table, enter all the other information entered in the form, to the other fields

Re: [PHP-DB] PHP, MySQL and Lookups

2008-02-26 Thread Daniel Brown
On Tue, Feb 26, 2008 at 8:55 AM, Henry Felton [EMAIL PROTECTED] wrote: Hi everyone, I'm just getting into PHP at the moment and was wondering; what code would I need to look at a field value entered in a form, then if that value is found in my table, enter all the other information entered

[PHP-DB] PHP help question

2008-02-13 Thread Rudy sleiman
To whom it may concern I'm working on a network, i don't have internet access and the application i'm working on is not published online. Platform used: PHP with MySQL. The Database is created on PC A... I'm working on PC B... and my problem is that i am not able to connect to the PC A Database

Re: [PHP-DB] PHP help question

2008-02-13 Thread Hasse R. Hansen
Rudy sleiman wrote: To whom it may concern I'm working on a network, i don't have internet access and the application i'm working on is not published online. Platform used: PHP with MySQL. The Database is created on PC A... I'm working on PC B... and my problem is that i am not able to

RE: [PHP-DB] PHP help question

2008-02-13 Thread Miguel Guirao
- -- From: Rudy sleiman [mailto:[EMAIL PROTECTED] -- Sent: Miércoles, 13 de Febrero de 2008 09:53 a.m. -- To: php-db@lists.php.net -- Subject: [PHP-DB] PHP help question -- -- To whom it may concern -- -- I'm working on a network, i don't have internet access and the -- application i'm working

RE: [PHP-DB] PHP help question

2008-02-13 Thread Miguel Guirao
- -- From: Rudy sleiman [mailto:[EMAIL PROTECTED] -- Sent: Miércoles, 13 de Febrero de 2008 09:53 a.m. -- To: php-db@lists.php.net -- Subject: [PHP-DB] PHP help question -- -- To whom it may concern -- -- I'm working on a network, i don't have internet access and the -- application i'm working

RE: [PHP-DB] PHP help question

2008-02-13 Thread Miguel Guirao
- -- From: Rudy sleiman [mailto:[EMAIL PROTECTED] -- Sent: Miércoles, 13 de Febrero de 2008 09:53 a.m. -- To: php-db@lists.php.net -- Subject: [PHP-DB] PHP help question -- -- To whom it may concern -- -- I'm working on a network, i don't have internet access and the -- application i'm working

<    1   2   3   4   5   6   7   8   9   10   >