[PHP-DB] Re: (preg_match ?

2001-07-27 Thread CC Zona
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] wrote: > $search = "TheName" > $data = "TheName,TheAddress,ThePhone" > > if (preg_match('"/\b'.$search.'\b/i"', $data)) > { > echo "True"; > } > else > { > echo "False"; > } > I am trying to see if the search name matches exactly a name in the

[PHP-DB] Help accessing Interbase (win) with PHP4

2001-07-27 Thread Maxim Pavlov
Hello, I have Interbase 5.5 running on NT box, and the goal is to access it from Apache/PHP on Linux box. The following code is quite trivial, but in my case it doesn't work. I found many similar posts searching Internet on that, but did not find an answer. All it gives is "Warning: InterBase

[PHP-DB] Not Really A DB Question

2001-07-27 Thread Peter J. Krawetzky
How do you loop through all the text objects in a PHP script? In otherwords, I want use logic to check the value of each textbox without specifically referencing the actual object name. Visual Basic has this type of logic.

Re: [PHP-DB] PHP and Informix installation

2001-07-27 Thread Paul Gardiner
Hi, To be honest I don't know if PHP will work with version 5.x of Informix. I think it must be 7.x. At least that's for the SE version. In case I'm wrong for On-Line you can have a go but you'll have to specify the libs manually when compiling Apache. If you run esql -libs this will list the l

[PHP-DB] Search Query

2001-07-27 Thread Steve Fitzgerald
I'm trying to build a search query that will allow users to search (via a textbox) different tables. For example, I have a table name contacts with columns ContactID, FirstName, LastName, and Active. I want to be able to search for John Smith or Smith where Active=yes (as opposed to Active=no whi

RE: [PHP-DB] Search Query

2001-07-27 Thread Cami
You'll need three pages: in the first one put submit it to the second page where you have: $sql = "select * from contacts where (FirstName like '%$contactname%' or LastName like '%$contactname%') and Active='yes' order by ID"; $result = mysql_query($sql); $numrows = mysql_num_rows(

[PHP-DB] Problems with update und delete's

2001-07-27 Thread Uli
Hallo! Maybe you can help me with my problems. I have a html form that deletes (or updates) over a php-script datas from my database like "delete from table_name where id=xy" and it works correctly. But when I have about 100 entries in my database then it takes about 50 sec. to delete an entry

Re: [PHP-DB] Problems with update und delete's

2001-07-27 Thread Peter J. Krawetzky
How many rows are in the table? Is the "id" column indexed? It looks like it's scanning through each row to find a match. How long does it take to delete just the one row? If it's 2 seconds, then that delete is acting the same way. If you have a very small table, then it sounds like the datab

RE: [PHP-DB] PATCH for 9i support (was Re: [PHP-DB] Re: Oracle 9i Support)

2001-07-27 Thread Brian Dunworth
On Thursday, July 26, 2001 at 9:48 PM, Sommai Fongnamthip said: > I have oracle 8i in Linux server. How could I > connect it with PHP (on other server)? Install the Oracle Client software (on the other server). --- Brian S. Dunworth Sr. Software Dev

Re: [PHP-DB] Problems with update und delete's

2001-07-27 Thread Uli
Its a mySQL DB at a providers Server, so I think the memory and the cache schould be okay. Mybe this helps: The HTML File look like this: Do really want to delete this entry and the function in the admin_index.php3 looks like this function delete_entry($svid) { $connectionID

[PHP-DB] Re: Problems with update und delete's

2001-07-27 Thread Jeffery Cann
It sounds like your 'id' column does not have an index. Jeff Uli wrote: > Hallo! > > Maybe you can help me with my problems. > > I have a html form that deletes (or updates) over a php-script datas from > my database like "delete from table_name where id=xy" > > and it works correctly. > >

[PHP-DB] Re: Help accessing Interbase (win) with PHP4

2001-07-27 Thread Jeremy Bettis
Use $dbh = ibase_connect ("database", "user", "password", "ISO8859_1", 0, 1); The extra arguments are needed for any interbase < 6.0 -- Jeremy Bettis [EMAIL PROTECTED] "Maxim Pavlov" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello, > > I have Interbas

[PHP-DB] writing an Oracle blob to file system?

2001-07-27 Thread Tom Anderson
I need to pull oracle blobs out of the database and write them to the file system (Solaris). Has anyone had any success doing this? Tom -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact th

[PHP-DB] results testing

2001-07-27 Thread phpnet
I have had no success finding a thread on the subject of how to test results of a query. I know it can be positive without finding any rows. What are the ways to test. Dave -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-ma

[PHP-DB] Re: results testing

2001-07-27 Thread Jeffery Cann
Dave. Is this what you mean? In the example below, you won't fall into the while loop unless you get a row back from the statement handle ($sth). $dbh = ibase_connect( $connect, $this->login, $this->passwd ) $sth = ibase_query( $sql, $dbh ); while ( $row = ibase_fetch_row ( $sth ) ) {

RE: [PHP-DB] PHP and Informix installation

2001-07-27 Thread Muciño Zúñiga Marco Antonio
OK, I set my LIBS environment variable to my esql -libs result and the confire shell is OK now, but now I get the next error when running the make command : # make ===> src make[1]: Entering directory `/tmp/apache_1.3.20' make[2]: Entering directory `/tmp/apache_1.3.20/src' ===> src/os/unix

Re: [PHP-DB] report style printing

2001-07-27 Thread leo g. divinagracia iii
> > At 10:02 AM 7/26/01 +0700, Sommai Fongnamthip wrote: > >Hi, > > When I retrieve data to display on web with PHP, it can print out > > from web in Browser Stlye. How could we have some PHP code to retrieve > > current display data into PC and print it with some Custom Report Style? >

RE: [PHP-DB] report style printing

2001-07-27 Thread Miles Thompson
Use PHP's mail() function to send it to your customer, store in a directory from they can FTP it. Miles At 08:45 AM 7/27/01 +0700, Sommai Fongnamthip wrote: >OK. How do I operate when finished generate text file or report file in >server? Could I download it and to view / print from client r

[PHP-DB] Record Update Link

2001-07-27 Thread Steve Fitzgerald
I seem to be having difficulty creating a hypertext link between the results of a sql query, ie a a formated page with a contact record (FirstName, LastName, etc.) to a page that will allow for editing. The results page is text only and the edit/update page has text boxes. Not sure if this clear,

[PHP-DB] Tree Display

2001-07-27 Thread Sharif Islam
I am still trying to figure out how to do it. I want to display my result from the data base in tree/menu like system. So the result page will look like this: +Result1 (you click this , it will expand) -Item1 (you click this and get more info) -Item2 -Item3 +Result2

Re: [PHP-DB] Not Really A DB Question

2001-07-27 Thread Szii
This is not VB - this is better. Probably want to name all of your text fields something similar, since they'll be mixed in with the drop downs, radio buttons, etc... Check $HTTP_POST_VARS and $HTTP_GET_VARS in your form's target. -Szii - Original Message - From: "Peter J. Krawetzky"

[PHP-DB] ODBC and PHP

2001-07-27 Thread acastilh
I´m using PHP 4 with ODBC and sometimes I get a response that was unable to connect to the MSSQL database. Then I go to the ODBC configuration to test the connection and I get a response that everything is working fine, but my pages still can´t connect. Is that normal? What can I do? I´m using N

[PHP-DB] Re: Tree Display

2001-07-27 Thread Hugh Bothwell
"Sharif Islam" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > I am still trying to figure out how to do it. I want to display my result > from the data base in tree/menu like system. Could you give us your SELECT statement and one row of returned data? >

[PHP-DB] Re: Not Really A DB Question

2001-07-27 Thread Hugh Bothwell
> "Peter J. Krawetzky" <[EMAIL PROTECTED]> wrote in > message 001001c11697$fe331d40$[EMAIL PROTECTED]">news:001001c11697$fe331d40$[EMAIL PROTECTED]... > How do you loop through all the text objects in a PHP script? In otherwords, > I want use logic to check the value of each textbox without spec

[PHP-DB] Submitting a form with the Enter button

2001-07-27 Thread Ken Sommers
IF I click this submit button: then (isset($submit_key) ) is TRUE IF i press my ENTER button instead of click it then (isset($submit_key) ) is FALSE.. is this normal behavior? Ken -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For addition

[PHP-DB] function ??

2001-07-27 Thread phpnet
are INSERT INTO statements forbiden inside a function?? Dave -- 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]

Re: [PHP-DB] Retrieving Rows - Can I Change The Order?

2001-07-27 Thread Caleb Walker
> Now then, I have changed a column in the table, and the only way I found to > change a data type is to delete the offending column and then add it again. > > When I do the select now the new column, which was at $row[3] is now always > $row[39]. I don't mind this, because I know where it is, bu