[PHP-DB] error configuring php4.2.3 --with solid embedded engine version 3.0
Hi, We're trying to configure php to work with solid but we get the following error in the output: * * Unable to locate /usr/home/solid/lib/libfex.so or /usr/home/solid/lib/libfex.a * Please correct this by creating the following links and reconfiguring: * /usr/home/solid/lib/libfex.a - /usr/home/solid/lib/libfex.a * /usr/home/solid/lib/fex.so - /usr/home/solid/lib/libfex.so * I can't find anything on this problem, has anyone seen this before or maybe have any ideas as to where i'm best off looking further?? thanks, sjef. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Passing Data between pages
As I am fairly new to web development I was looking into way to pass data between pages on a web site. I decided that using session variables was the most attractive but it seems like most sights use url parameters. I am now trying to use the apache mod-rewrite to allow the site to be indexed by search engines. Am I correct in assuming that mod-rewrite only works with url parameters and not session variables? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] apache mod-rewrite
I am now trying to use the apache mod-rewrite to allow the site to be indexed by search engines. Am I correct in assuming that mod-rewrite only works with url parameters and not session variables? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] No tuples available
Great recommendation. The @ should work great. Thanks. Ryan -Original Message- From: David T-G [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 8:03 PM To: PHP DB list Cc: Ryan Jameson (USA) Subject: Re: [PHP-DB] No tuples available Ryan -- ...and then Ryan Jameson (USA) said... % % Is there a way to tell PHP to not show just this warning? Maybe there Have you tried using @ in front of the odbc_fetch_row call? That will shut it up: PHP supports one error control operator: the at sign (@). When prepended to an expression in PHP, any error messages that might be generated by that expression will be ignored. I'd bet a twinkie that you get it when you have no more data. You should implement the PEAR FutureGaze module so that you know to stop one row earlier ;-) HTH HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Query Case In-sensitive
Is there a way to run a query so that it ignores the case, and the query is not case sensitive? The data being stored is m1234 Query Select item number from item where item_code = M1234 ; The query above should return the data above. TIA Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax : (252) 237-1592
Re: [PHP-DB] Query Case In-sensitive
In Oracle you have a couple of choices. (1) If you can ensure that the data stored is in one case you can apply a function to the keyed in data SELECT item_number FROM item WHERE item_code = lower('M1234'); (2) If you can not ensure data case then you can apply the function to both side SELECT item_number FROM item WHERE lower(item_code) = lower('M1234'); You can use triggers on your tables to do case conversions then ensure case in the table. In later versions of Oracle you can apply function-based indexes to your table to speed up these queries. Roy A. Jones US Pharma Database Administration GlaxoSmithKline Inc. US Pharma IT, Shared Services External: (919) 483-0266 Internal: 703-0266 Fax: (919) 315-6842 Office: RC2 - 2005 Email: [EMAIL PROTECTED] http://usphdba.gsk.com/ - USPHARMA Database Site Larry Sandwick [EMAIL PROTECTED] 17-Nov-2003 14:53 Please respond to [EMAIL PROTECTED] To [EMAIL PROTECTED] cc Subject [PHP-DB] Query Case In-sensitive Is there a way to run a query so that it ignores the case, and the query is not case sensitive? The data being stored is m1234 Query Select item number from item where item_code = M1234 ; The query above should return the data above. TIA Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax : (252) 237-1592
Re: [PHP-DB] Query Case In-sensitive
From: Larry Sandwick [EMAIL PROTECTED] Is there a way to run a query so that it ignores the case, and the query is not case sensitive? What's this have to do with PHP and what database are you using? ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Query Case In-sensitive
Hey! At least in Postgresql you can do something like: SELECT * FROM table where item_code ILIKE 'blabla'; But I guess it's standard, so you can use it in any DB. Larry Sandwick wrote: Is there a way to run a query so that it ignores the case, and the query is not case sensitive? The data being stored is m1234 Query Select item number from item where item_code = M1234 ; The query above should return the data above. TIA Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax : (252) 237-1592 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Read file
hi all, can anyone enlighten me on how i can use PHP to read the contents of a file from the client's machine?? for eg, the client has a CSV file in his MyDocuments directory, how can I read the contents and publish them on the web? thank you lots! Hwee Hwee
Re: [PHP-DB] Read file
On Tuesday 18 November 2003 09:29, Ng Hwee Hwee wrote: can anyone enlighten me on how i can use PHP to read the contents of a file from the client's machine?? for eg, the client has a CSV file in his MyDocuments directory, how can I read the contents and publish them on the web? You have to ask them to upload it to the server: manual Handling file uploads -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* QOTD: My life is a soap opera, but who gets the movie rights? */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Read file
the reason i don't want to read from the server is because i don't want to use up too much space and processing time on the server.. the file has 50,000 records of information.. is there another way other than uploading on the server side?? thanx! hwee - Original Message - From: Jason Wong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 9:54 AM Subject: Re: [PHP-DB] Read file On Tuesday 18 November 2003 09:29, Ng Hwee Hwee wrote: can anyone enlighten me on how i can use PHP to read the contents of a file from the client's machine?? for eg, the client has a CSV file in his MyDocuments directory, how can I read the contents and publish them on the web? You have to ask them to upload it to the server: manual Handling file uploads -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySQL join with variable table?
In a MySQL database, I have several tables, including one central table that essentially keeps track of the records in the other tables. TABLE1 +---+---+---+ | id| str | val1 | +---+---+---+ | 123456789 | TABLE2| 987654321 | +---+---+---+ TABLE2 +---+---+ | id| val2 | +---+---+ | 123456789 | j00 r0xx0r | +---+---+ Currently, I'm selecting all the records for a given entry with two SELECT statements, one to the central table which gives me the name of the second table. My question is, is there any way to do this in a single query with a join? I suspect not, but I wanted to see if anybody on this list had any ideas before I give up on the possibility entirely. -- Jason Godesky [EMAIL PROTECTED] http://www.tribaldawn.com/jason/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Read file
On Tuesday 18 November 2003 09:58, Ng Hwee Hwee wrote: the reason i don't want to read from the server is because i don't want to use up too much space and processing time on the server.. the file has 50,000 records of information.. is there another way other than uploading on the server side?? Two options: 1) You can recompile PHP with the startrek module and use startrek_transport() to instantly transfer anything (data, even physical objects) from anywhere to anywhere else. 2) You can use telepathic means to read the data stored on the client, then type it into a file and save onto the server. But technically speaking, both of the above are still variations of 'uploading' the file onto the server. So another option is: 3) Install a webserver on the client and serve the files from there instead. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* If a program actually fits in memory and has enough disk space, it is guaranteed to crash. -- Murphy's Computer Laws n5 */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Read file
what about using cookies? my problem is this: i have about 10,000 hotels records and each of them has information about its location, its hotel code, its hotel tel, its country code etc... i would like to load this into the clients computer so that when they enter a hotel code, all the information will be reflected in the form using onChange()... if 50 employees were to query the database always for these 10,000 records, i'm afraid the server can't take the traffic and die.. so i was thinking of uploading a CSV file into my client's computer and then have my scripts find the file and read the file for Javascript to process... since the information in the file changes ususally only once a year, i don't have to worry that they will have back-dated information.. i'm desperate for enlightenment! thanx!! :o) blessings, hwee - Original Message - From: Michael Scappa [EMAIL PROTECTED] To: 'Ng Hwee Hwee' [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 10:01 AM Subject: RE: [PHP-DB] Read file If you are publishing it on the web, it has to get to the server eventually, so your answer is no. There is really no way around it. If the file is often used, pump it into a DB and search it that way, it'll be much quicker. -Original Message- From: Ng Hwee Hwee [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 8:58 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Read file the reason i don't want to read from the server is because i don't want to use up too much space and processing time on the server.. the file has 50,000 records of information.. is there another way other than uploading on the server side?? thanx! hwee - Original Message - From: Jason Wong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 9:54 AM Subject: Re: [PHP-DB] Read file On Tuesday 18 November 2003 09:29, Ng Hwee Hwee wrote: can anyone enlighten me on how i can use PHP to read the contents of a file from the client's machine?? for eg, the client has a CSV file in his MyDocuments directory, how can I read the contents and publish them on the web? You have to ask them to upload it to the server: manual Handling file uploads -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- 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] Read file
Jason Wong wrote: On Tuesday 18 November 2003 09:58, Ng Hwee Hwee wrote: the reason i don't want to read from the server is because i don't want to use up too much space and processing time on the server.. the file has 50,000 records of information.. is there another way other than uploading on the server side?? Two options: 1) You can recompile PHP with the startrek module and use startrek_transport() to instantly transfer anything (data, even physical objects) from anywhere to anywhere else. This requires lib-dilithium.so.6 and it's currently only in the devel branch. (So I wouldn't run it in a production environment.) Let me know how I may be of service, =C= * Cal Evans * http://www.eicc.com * We take care of your IT, * So you can take care of your business. * * I think inside the sphere. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Read file
I've seen it done with some creative javascript. (i.e. caching to a tmp dir and accessing the txt file onChange.) But you cannot (REPEAT CANNOT) execute php on a client machine unless you load php and a web server onto that client machine. PHP is still a server side script. And 10k cookies is out of the question. I imagine it would bring down your browser. You are correct to be concerned about people bringing down 10k records each time. I suggest you re-think your database strategy so that you bring down a smaller subset. If done right, you can use Javascript and a hidden window to fetch records from the database and return them to the currently running page without refreshing the page. (It can be done. It's ugly and it's a bugger to maintain, but it can be done.) Let me know how I may be of service, =C= * Cal Evans * http://www.eicc.com * We take care of your IT, * So you can take care of your business. * * I think inside the sphere. Ng Hwee Hwee wrote: what about using cookies? my problem is this: i have about 10,000 hotels records and each of them has information about its location, its hotel code, its hotel tel, its country code etc... i would like to load this into the clients computer so that when they enter a hotel code, all the information will be reflected in the form using onChange()... if 50 employees were to query the database always for these 10,000 records, i'm afraid the server can't take the traffic and die.. so i was thinking of uploading a CSV file into my client's computer and then have my scripts find the file and read the file for Javascript to process... since the information in the file changes ususally only once a year, i don't have to worry that they will have back-dated information.. i'm desperate for enlightenment! thanx!! :o) blessings, hwee - Original Message - From: Michael Scappa [EMAIL PROTECTED] To: 'Ng Hwee Hwee' [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 10:01 AM Subject: RE: [PHP-DB] Read file If you are publishing it on the web, it has to get to the server eventually, so your answer is no. There is really no way around it. If the file is often used, pump it into a DB and search it that way, it'll be much quicker. -Original Message- From: Ng Hwee Hwee [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 8:58 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Read file the reason i don't want to read from the server is because i don't want to use up too much space and processing time on the server.. the file has 50,000 records of information.. is there another way other than uploading on the server side?? thanx! hwee - Original Message - From: Jason Wong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 9:54 AM Subject: Re: [PHP-DB] Read file On Tuesday 18 November 2003 09:29, Ng Hwee Hwee wrote: can anyone enlighten me on how i can use PHP to read the contents of a file from the client's machine?? for eg, the client has a CSV file in his MyDocuments directory, how can I read the contents and publish them on the web? You have to ask them to upload it to the server: manual Handling file uploads -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- 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] Query Case In-sensitive
Generally in DBs, data is case sensitive. Simply you can do an uppercase or lowercase conversion in both sides. Ex : Select item number from item where upper(item_code) = upper(m1234); -ramki - Original Message - From: Larry Sandwick [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 1:23 AM Subject: [PHP-DB] Query Case In-sensitive Is there a way to run a query so that it ignores the case, and the query is not case sensitive? The data being stored is m1234 Query Select item number from item where item_code = M1234 ; The query above should return the data above. TIA Larry Sandwick Sarreid, Ltd. Network/System Administrator phone: (252) 291-1414 x223 fax : (252) 237-1592 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] CSV Import Question
Hi there everyone, I have a 2 Column CSV file, and i'm trying to import it into the DB via a form, I have it importing fine with the first field (Called EMail) but I cannot get it to import the second column correctly (Called name). I know it's going to be something so obvious i'll pass out, but does anyone have any ideas? Here's the code: $row = 1; $handle = fopen ($userfile,r); while ($data = fgetcsv ($handle, 250, $delim)) { $num = count ($data); $row++; for ($c=0; $c $num; $c++) { mysql_query (INSERT INTO emaillist (EMail,name) VALUES ('$data[$c]','$data[$c]') When I import, it puts all data in the EMail field, even the name field. Any help would be appreciated beyond belief as this is annoying the crapola out of me :-) Chris
Re: [PHP-DB] CSV Import Question
On Tuesday 18 November 2003 12:34, Chris Payne wrote: I have a 2 Column CSV file, and i'm trying to import it into the DB via a form, I have it importing fine with the first field (Called EMail) but I cannot get it to import the second column correctly (Called name). I know it's going to be something so obvious i'll pass out, but does anyone have any ideas? Here's the code: $row = 1; $handle = fopen ($userfile,r); while ($data = fgetcsv ($handle, 250, $delim)) { $num = count ($data); $row++; for ($c=0; $c $num; $c++) { mysql_query (INSERT INTO emaillist (EMail,name) VALUES ('$data[$c]','$data[$c]') When I import, it puts all data in the EMail field, even the name field. What's $delim? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* Business will be either better or worse. -- Calvin Coolidge */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] CSV Import Question
Hi there, On Tuesday 18 November 2003 12:34, Chris Payne wrote: I have a 2 Column CSV file, and i'm trying to import it into the DB via a form, I have it importing fine with the first field (Called EMail) but I cannot get it to import the second column correctly (Called name). I know it's going to be something so obvious i'll pass out, but does anyone have any ideas? Here's the code: $row = 1; $handle = fopen ($userfile,r); while ($data = fgetcsv ($handle, 250, $delim)) { $num = count ($data); $row++; for ($c=0; $c $num; $c++) { mysql_query (INSERT INTO emaillist (EMail,name) VALUES ('$data[$c]','$data[$c]') When I import, it puts all data in the EMail field, even the name field. What's $delim? Sorry, delim is from the form you use to select the CSV file, as you can select the char as the seperator (I have set the default to a COMMA though). Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] CSV Import Question
On Tuesday 18 November 2003 13:07, Chris Payne wrote: any ideas? Here's the code: $row = 1; $handle = fopen ($userfile,r); while ($data = fgetcsv ($handle, 250, $delim)) { $num = count ($data); $row++; for ($c=0; $c $num; $c++) { mysql_query (INSERT INTO emaillist (EMail,name) VALUES ('$data[$c]','$data[$c]') When I import, it puts all data in the EMail field, even the name field. What exactly do you mean by puts all data in the EMail field? Does print_r($data) look OK? And you do realise that in your SQL statement you're inserting the same value for both EMail and name? What's $delim? Sorry, delim is from the form you use to select the CSV file, as you can select the char as the seperator (I have set the default to a COMMA though). By that you do mean: $delim = ','; and not $delim = COMMA; ? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* Pilfering Treasury property is paticularly dangerous: big thieves are ruthless in punishing little thieves. -- Diogenes */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] sybase_connect(): Sybase: Unable to allocate connection record problem
Dear friends, I installed sybase 12.5 develop edition, apache 2.0.48 and php 4.3.4 on the same server, the php testing is no problem. But i use function sybase_connect() in program test.php, open the file in IE, error messages : Warning: sybase_connect(): Sybase: Unable to allocate connection record in /usr/local/apache2/htdocs/test.php on line 3 I search all the internet, don't find the reason and the solution. Help, Help me. Thanks a lot. Samuel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php