[PHP-DB] Interbase queries
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
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
[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
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
RE: [PHP-DB] updating a column based on info from another coluimn ? Desperate!
Or rawurldecode()? http://us4.php.net/manual/en/function.rawurldecode.php > -Original Message- > From: Hutchins, Richard [mailto:[EMAIL PROTECTED] > Sent: Thursday, 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!
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!
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!
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
Hello, how can i search for a data in Mysql database calling a PHP function in field propeties ?? example: 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
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