Re: [PHP-DB] mysqlimport

Just incase anyone else is looking for the answer, the problem was solved thus: exec("/usr/local/mysql/bin/mysqlimport --replace --fields-terminated-by=\| - -user=testuser --password=testpassword testdb /home/testdomain/www/Admin/test_mysqltable.txt"); It just needed a path to the mysqlimport co

[PHP-DB] Repost: postgresql / groups and users

for my application in php I connect with a postgresql database. In this database I have made users and groups, where 1 user can be the member of many groups (n on m relation) That works, but how do I let php find out if a user is a member of a certain group? I tried to get the relation out of the

[PHP-DB] ODBC DataBase Paging Solution

Hi ! Do somebody has a paging solution for ODBC connection ? Thanks. Regards, Veniamin

Re: [PHP-DB] Trouble connecting to MSSQL 2k DB

Try put the php dlls on %systemroot%/system. I have IIS 5.0 + PhP 4.0.6 + MSSQL on a W2k server working perfectly. Later, Jorge Giménez - Original Message - From: "Sean Swehla" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 13, 2001 8:10 PM Subject: [

[PHP-DB] Not so relative but important...

Hello everyone... This is not a very relative question to DB and php but would mean a lot if someone helped me out.. It involves html headers... What i want to do is when i have a pdf or doc file ... using a special header, when clicking the file the page to download the file and not opening it

[PHP-DB] Sybase CT with/without Sybase ASE

Dear All, In the past I had installed an Apache server with PHP 4.0.6 and Sybase CT extension on Mandrake Linux 8, all ok. On the Mandrake machine, I had installed Sybase ASE 11.9.2, that was only used for test; most of the time the php code used sybase ct lib to refer to another database server (

[PHP-DB] oracle 8 database error 12154 using apache server on windows NT

Hi, I'm trying to connect to an oracle 8 database using php 4.0.6 In my php.ini file I deleted the ";" in front of extension php_oci8.dll. I've set the format of tnsnames.ora and sqlnet.ora to the unix format. In the beginning of my php code I type: putenv('ORACLE_HOME = c:\oracle\ora81'); putenv(

Re: [PHP-DB] eregi and ereg??

Hi, You cannot put multiple variables in ereg(). This is taken from http://www.php.net/manual/en/function.ereg.php i think it will explain it better If matches are found for parenthesized substrings of pattern and the function is called with the third argument regs, the matches will be stored in

Re: [PHP-DB] moving uploaded files

Hi, PHP has its own filesystem functions which you can use. If you want to move a file from one location to another you could use something like this The $old_file and the $new_file variables should contain the absolute path e.g. /home/user/filename.txt Check http://www.php.net/manual/en/ref.fi

Re: [PHP-DB] Not so relative but important...

Hi, try HTH Dobromir Velev -Original Message- From: Koutsogiannopoulos Karolos <[EMAIL PROTECTED]> To: 'Php-Db (E-mail) <[EMAIL PROTECTED]> Date: Friday, September 14, 2001 1:44 PM Subject: [PHP-DB] Not so relative but important... >Hello everyone... > >This is not a very relative q

RE: [PHP-DB] Problems inserting large blob

I forgot to say that php.ini file has 8Mb set as the maximum possible upload file size. Thanks for everything ... I really need some help on this! João B. -- Joao Barreto - E-Business and Security Manager Convex - Informática e Sistemas de Comunicações Portugal,

RE: [PHP-DB] eregi and ereg??

You cannot specify multiple strings. However, you CAN concatenate strings and perform ereg()/eregi(): if( eregi("x", $string1.$string2.$string3, $regs ) -Original Message- From: Jason Caldwell [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 12:14 AM To: [EMAIL PROTECTED] S

[PHP-DB] Looking for alternative to phpMyAdmin for data entry

Dear Newsgroup I am looking for an alternative to phpmyAdmin thatwill generate clumsy entry screens that allows you to select data type for each field (makes litle sence to me). Database it - table san_port Field Type Function Value san varchar(20) ASCIICHARSOUNDEXCURDATECURTIMEFROM_

[PHP-DB] Student Suspended Over Suspected Use of PHP

http://www.bbspot.com/News/2000/6/php_suspend.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Looking for alternative to phpMyAdmin for data entry II (Yellow background)

Dear Group Sorry about the missing grafics (is was so nice when I posted it). Now my friend says there was a online demo of a data entry page with YELLOW backgound color doing just this! Any ideas? Rgds Henrik "Henrik Lassen" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAI

Re: [PHP-DB] How to Replace the table data

I don;t know why it's still not working. I tried it with smaller table and it works. but when I tried with my real table, it's not working I use this : UPDATE posts SET post_text='IMG SRC=" > wrote: > > >> its not working because it's not a variable (url) >> it's a text field > >'url' is the name

Re: [PHP-DB] How to Replace the table data

FYI : POST_TXT = text field & Not null = YES --- Nagasea <[EMAIL PROTECTED]> > wrote: >I don;t know why it's still not working. >I tried it with smaller table and it works. >but when I tried with my real table, it's not working > >I use this : >UPDATE posts SET post_text='IMG SRC=" >FYI : posts_

[PHP-DB] Re: Looking for alternative to phpMyAdmin for data entry

Hello Henrik, Friday, September 14, 2001, 9:42:13 AM, you wrote: HL> Dear Newsgroup HL> I am looking for an alternative to phpmyAdmin thatwill generate clumsy entry HL> screens that allows you to select data type for each field (makes litle HL> sence to me). HL> Database it - table san_port HL

Re: [PHP-DB] Sybase CT with/without Sybase ASE

You don't need the Sybase dataserver but you still need the Sybase shared libraries that PHP is linked against. So restore all the .so's in $SYBASE/lib, and apache should start. Offhand, I'm not sure if 12.5 came with a different version of the open client libraries than 11.9.2 did, but if it

[PHP-DB] string problem

scenario: Win.nt 4.0 pach6a Workstation, IE 5.5, Apache/1.3.20, php 4.0.6 wath goes wrong: when I set a string variable containing by example : " hello "jack" " on my html page php convert it to " hello \"jack\" " and I get no errors on another machine with same configuration I get " hello "jack"

[PHP-DB] Replace into

Hi! In mySql you can do: replace into tbl_name values(value_1, value_2) does it work for Oracle aswell? Can anybody provide me with a link to a GOOD Oracle syntax reference. Oracle needs serious help with their documentation...:-( Regards /Robert -- PHP Database Mailing List (http://www.p

[PHP-DB] currency out of postgresql

I am trying to get two currency values from out of the database, add them together and print the to the screen. I am using the following code. $money = $myrow[6] + $myrow[7]; $formatted = sprintf("%01.2f", $money); printf ("%01.2f\n", $formatted); $myrow[] is the array that I load the database r

Re: [PHP-DB] currency out of postgresql

> $formatted = sprintf("%01.2f", $money); > printf ("%01.2f\n", $formatted); maybe twice, try: $formatted = sprintf("%01.2f", $money); echo "$formatted\n"; - Original Message - From: "Rick Eicher II" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 14, 2001 6:48 PM Su

RE: [PHP-DB] string problem

Don't know why you're getting problem. However, you can use stripslashes() to avoid the problem. -Original Message- From: Bruno Franx [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 10:04 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] string problem scenario: Win.nt 4.0 pach6a

RE: [PHP-DB] string problem

There's an option in php.ini: magic_quotes_gpc = On/Off; If on, any GET, POST, and Cookie data will come back with \ marks before ' and " marks. Guesing one server has it set to Off, and one set to On. Justin Buist Trident Technology, Inc. 4700 60th St. SW, Suite 102 Grand Rapids, MI 49512 Ph

[PHP-DB] Another Image prob

I'm new at this and i'm sure that this has been answered before, but anyway... I am trying to retrieve images from a MySQL database. They are stored as BLOBs with the following table format: Database metonym_metonym - table imgs Field TypeAttributes NullDefault Extra fk_proj_id

RE: [PHP-DB] Another Image prob

The consensus is that it is best if you DO NOT store the images as blobs in a database. Rather, store the images in separate files and store the names of those files in the database. Then retrieve the file names for the database, open the image files, and then send the images to the client's bro

[PHP-DB] currency out of postgresql

After I do the add $money comes out to be 0. The data comes out as $0 and $5,217.00, I need to add these two to get $5,217.00. How do you add money with the dollor sign in the data? rick -Original Message- From: Bas Jobsen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 7:24

Re: [PHP-DB] currency out of postgresql

I suppose you could just remove the $ and/or the comma with a regexp... www.php.net/eregi_replace -- David Balatero - Original Message - From: "Rick Eicher II" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 14, 2001 3:00 PM Subject: [PHP-DB] currency out of postgresql

Re: [PHP-DB] currency out of postgresql

While the proposed solution below may very well indeed work for this situation it's a far better practice to strip the variable down to "known to be good" values rather than "known to be bad" ones. Rather than strip $ and , marks from the variable it's far better to strip out anything other than

Re: [PHP-DB] How to Replace the table data

> I don;t know why it's still not working. > I tried it with smaller table and it works. > but when I tried with my real table, it's not working When you say it's not working do you mean nothing was updated? Or there was an error message? If so what was the error? Have you tried running the sam

Re: [PHP-DB] How to Replace the table data

no it's working (successed), but nothing was updated. I tried to make a fake table. when i tried to make a fake table its working. i tried to change "ABC" from the table to "XXX" but if i got data called ABCD , it didnt change to XXXD why ? --- "Jason Wong" <[EMAIL PROTECTED]> > wrote: > > >>

RE: [PHP-DB] Another Image prob

Don't think that was the answer he was looking for =]. Here's how I retrieve images stored as blobs. $query = "select File, Type from Pictures_Data where id=$id"; $result = mysql_query($query); $data = mysql_result($result, 0, "File"); $type = mysql_result($result, 0, "Typ

Re: [PHP-DB] How to Replace the table data

> no it's working (successed), but nothing was updated. > I tried to make a fake table. > when i tried to make a fake table its working. > i tried to change "ABC" from the table to "XXX" > but if i got data called ABCD , it didnt change to XXXD > why ? *Now* I know what you're trying to do. The

[PHP-DB] Persistent Links and Temporary Tables

Hi, Is anyone able to briefly explain to me how the use of temporary tables by MySQL is affected by PHPs persistent connections? From my reading of MySQL temp tables are deleted when the current connection is closed, but that might not be for quite a long time with a persistent connection...