[PHP-DB] Interbase queries

2003-07-31 Thread Evan Morris 
Hi

I am new to using PHP with Interbase.

If I want to issue a query, I use:

$sth = ibase_query ($dbh, $sqlstmt);

I am assuming this issues the query to the database, and commits at the same
time? Do I need to release anything after having done this, or does it take
care of that by itself?

Thanks

Evan Morris
[EMAIL PROTECTED]
Tel: +27 11 792 2777
Fax: +27 11 792 2711
Cell: +27 82 926 3630



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mySQL help on win xp

2003-07-31 Thread John Ryan 
i installed php and apache fine on my pc, but mysql is giving problems. in
winmysqladmin, you cant create a adb on the databases tab. all that lets you
do is flush threads, flush processes, etc. so i had to create my database
through the mysql command line.

also, phpMyAdmin doesnt work, it returns an auth error. but i know for
definite the username and password.

whats going on?? is it something to do with win xp and users or win xps
firewall???





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] updating a column based on info from another coluimn? Desperate!

2003-07-31 Thread Aaron Wolski 
Hey hey,

Works like a charm. I have have my urls looking like The+Man+on+The+Moon

Seems weird, however, PHP automatically strips out the +'s? cause when I
echo the variable I get The Man On The Moon.

Idea's?


Also.. ANYWAY to make the +'s into -'s (hyphens)???

Thanks!!

Aaron

-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED] 
Sent: July 31, 2003 3:21 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] updating a column based on info from another
coluimn? Desperate!

Will urldecode() work for you on the PHP side or do you have to convert
everything in the database?

http://us4.php.net/manual/en/function.urldecode.php

 -Original Message-
 From: Aaron Wolski [mailto:[EMAIL PROTECTED]
 Sent: Thursday, July 31, 2003 3:14 PM
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] updating a column based on info from 
 another coluimn?
 Desperate!
 
 
 Hi All,
  
 This is OT but I am in need of serious help.
  
 I am rewriting URL's for a site and came across an issue with 
 spaces in
 URLS having %20 applied to them. I can't seem to find a solution with
 mod_rewrite to get rid of the %20 and replace with - (hyphen) so I am
 hoping someone can help me here with an MySQL solution.
  
 I have over 4000 records in a table. I've added a new column in that
 table called newUrl
  
 Is it possible with a QUERY to take from the 'designers' column and
 write into the 'newUrl' column and replace spaces with - at the same
 time?
  
 I'm probably talking out my a$$ here but I am a little desperate for a
 solutions.
  
 Thanks in advance and again my apologies for the OT message.
  
 Aaron
  
 

-- 
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] updating a column based on info from another coluimn? Desperate!

2003-07-31 Thread Hutchins, Richard 
This note from http://us4.php.net/manual/en/function.rawurldecode.php might
explain what you're seeing if you're using urldecode()

Note: rawurldecode() does not decode plus symbols ('+') into spaces.
urldecode() does. 

If you start out with $url = The+Man+On+The+Moon and you urldecode($url)
then you should, predictably, end up with The Man On The Moon.

If plus signs are a problem, you may need to implement a little bit of code
just to check the string for + then use either urldecode() or rawurldecode()
to get the output you want. Something like:

$position = stripos($urlFromDB, +);
if($position === FALSE){
rawurldecode($url);
}
else(
urldecode($url);
}

or something along those lines. I'm just shooting from the hip here.
stripos() returns a boolean false so be careful there. Not sure if my if()
statement is right.

 -Original Message-
 From: Aaron Wolski [mailto:[EMAIL PROTECTED]
 Sent: Thursday, July 31, 2003 3:49 PM
 To: 'Hutchins, Richard'; [EMAIL PROTECTED]
 Subject: RE: [PHP-DB] updating a column based on info from another
 coluimn? Desperate!
 
 
 Hey hey,
 
 Works like a charm. I have have my urls looking like 
 The+Man+on+The+Moon
 
 Seems weird, however, PHP automatically strips out the +'s? 
 cause when I
 echo the variable I get The Man On The Moon.
 
 Idea's?
 
 
 Also.. ANYWAY to make the +'s into -'s (hyphens)???
 
 Thanks!!
 
 Aaron
 
 -Original Message-
 From: Hutchins, Richard [mailto:[EMAIL PROTECTED] 
 Sent: July 31, 2003 3:21 PM
 To: [EMAIL PROTECTED]
 Subject: RE: [PHP-DB] updating a column based on info from another
 coluimn? Desperate!
 
 Will urldecode() work for you on the PHP side or do you have 
 to convert
 everything in the database?
 
 http://us4.php.net/manual/en/function.urldecode.php
 
  -Original Message-
  From: Aaron Wolski [mailto:[EMAIL PROTECTED]
  Sent: Thursday, July 31, 2003 3:14 PM
  To: [EMAIL PROTECTED]
  Subject: [PHP-DB] updating a column based on info from 
  another coluimn?
  Desperate!
  
  
  Hi All,
   
  This is OT but I am in need of serious help.
   
  I am rewriting URL's for a site and came across an issue with 
  spaces in
  URLS having %20 applied to them. I can't seem to find a 
 solution with
  mod_rewrite to get rid of the %20 and replace with - 
 (hyphen) so I am
  hoping someone can help me here with an MySQL solution.
   
  I have over 4000 records in a table. I've added a new column in that
  table called newUrl
   
  Is it possible with a QUERY to take from the 'designers' column and
  write into the 'newUrl' column and replace spaces with - at the same
  time?
   
  I'm probably talking out my a$$ here but I am a little 
 desperate for a
  solutions.
   
  Thanks in advance and again my apologies for the OT message.
   
  Aaron
   
  
 
 -- 
 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] updating a column based on info from another coluimn ? Desperate!

2003-07-31 Thread Hutchins, Richard 
Sorry, I'm only reading half posts today. :)

If you want to turn your + into - you'll probably have to go through one
more step and do a preg_replace(). Like

$new_url = preg_replace(+,-,$url);

I think that'll work. Again, shooting from the hip and not testing. Yeah,
baby, livin' on the wild side!

Anyway, check out this page for additional info if you need it:
http://us4.php.net/manual/en/function.preg-replace.php

 -Original Message-
 From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
 Sent: Thursday, July 31, 2003 4:03 PM
 To: 'Aaron Wolski'; [EMAIL PROTECTED]
 Subject: RE: [PHP-DB] updating a column based on info from another
 coluimn ? Desperate!
 
 
 This note from 
 http://us4.php.net/manual/en/function.rawurldecode.php might
 explain what you're seeing if you're using urldecode()
 
 Note: rawurldecode() does not decode plus symbols ('+') into spaces.
 urldecode() does. 
 
 If you start out with $url = The+Man+On+The+Moon and you 
 urldecode($url)
 then you should, predictably, end up with The Man On The Moon.
 
 If plus signs are a problem, you may need to implement a 
 little bit of code
 just to check the string for + then use either urldecode() or 
 rawurldecode()
 to get the output you want. Something like:
 
 $position = stripos($urlFromDB, +);
 if($position === FALSE){
   rawurldecode($url);
 }
 else(
   urldecode($url);
 }
 
 or something along those lines. I'm just shooting from the hip here.
 stripos() returns a boolean false so be careful there. Not 
 sure if my if()
 statement is right.
 
  -Original Message-
  From: Aaron Wolski [mailto:[EMAIL PROTECTED]
  Sent: Thursday, July 31, 2003 3:49 PM
  To: 'Hutchins, Richard'; [EMAIL PROTECTED]
  Subject: RE: [PHP-DB] updating a column based on info from another
  coluimn? Desperate!
  
  
  Hey hey,
  
  Works like a charm. I have have my urls looking like 
  The+Man+on+The+Moon
  
  Seems weird, however, PHP automatically strips out the +'s? 
  cause when I
  echo the variable I get The Man On The Moon.
  
  Idea's?
  
  
  Also.. ANYWAY to make the +'s into -'s (hyphens)???
  
  Thanks!!
  
  Aaron
  
  -Original Message-
  From: Hutchins, Richard [mailto:[EMAIL PROTECTED] 
  Sent: July 31, 2003 3:21 PM
  To: [EMAIL PROTECTED]
  Subject: RE: [PHP-DB] updating a column based on info from another
  coluimn? Desperate!
  
  Will urldecode() work for you on the PHP side or do you have 
  to convert
  everything in the database?
  
  http://us4.php.net/manual/en/function.urldecode.php
  
   -Original Message-
   From: Aaron Wolski [mailto:[EMAIL PROTECTED]
   Sent: Thursday, July 31, 2003 3:14 PM
   To: [EMAIL PROTECTED]
   Subject: [PHP-DB] updating a column based on info from 
   another coluimn?
   Desperate!
   
   
   Hi All,

   This is OT but I am in need of serious help.

   I am rewriting URL's for a site and came across an issue with 
   spaces in
   URLS having %20 applied to them. I can't seem to find a 
  solution with
   mod_rewrite to get rid of the %20 and replace with - 
  (hyphen) so I am
   hoping someone can help me here with an MySQL solution.

   I have over 4000 records in a table. I've added a new 
 column in that
   table called newUrl

   Is it possible with a QUERY to take from the 'designers' 
 column and
   write into the 'newUrl' column and replace spaces with - 
 at the same
   time?

   I'm probably talking out my a$$ here but I am a little 
  desperate for a
   solutions.

   Thanks in advance and again my apologies for the OT message.

   Aaron

   
  
  -- 
  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 Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Seach for data calling function in field

2003-07-31 Thread Roberto Dragva Filho 
Hello,

how can i search for a data in Mysql database calling a PHP function  in
field propeties ??
example:

?php echoinput type='text' name='ID' size='20' onBlur=SEARCH_ID(); ;?

is this valid ??

thanks
roberto



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mySQL help on win xp

2003-07-31 Thread Larry R. Sieting 
At 07:44 PM 7/31/2003 +0100, John Ryan wrote:
i installed php and apache fine on my pc, but mysql is giving problems. in
winmysqladmin, you cant create a adb on the databases tab. all that lets you
do is flush threads, flush processes, etc. so i had to create my database
through the mysql command line.
Personally, I am running Win XP with Apache 1.3.27 and Php 4.3.2 and MySql 
4.0.13.

I couldn't get WinMySqlAdmin to work either.

I got rid of the winMySQLAdmin.. found it worthless... cant do half of what 
is says it is supposed to.. and I checked out SQLyog.  I will be buying it 
when I can (as a front end maintenance app)  But that is my opninion.


also, phpMyAdmin doesnt work, it returns an auth error. but i know for
definite the username and password.
Can't help here... haven't used/played with it enough yet.


whats going on?? is it something to do with win xp and users or win xps
firewall???
Larry R. Sieting

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php