[PHP] It Worked! Re: agh - what am I doing wrong - regular expressions

[sgibbs]

Dear Martin, it worked!! Thank you SO much! - Shawna

-Original Message-
From: Martin Towell
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Sent: 1/20/02 10:25 PM
Subject: RE: [PHP] agh - what am I doing wrong - regular expressions

try this... 
I changed 
  1. the double quotes in "$pattern = ..." to single quotes 
  2. escaped the "?" 
  3. used ereg_replace to do everything, dropping the while loop 

 
$content = " http://www.globalhealth.org/text.php3?id=151
  
adjfladjfajdfkladfjl;kadjf 
jlkadjflkajdflkj jadklfjalkdjfl;df jalkdfj;ldafj"; 

$pattern = ' http://(  [\/~_\.0-9A-Za-z#&=-\?]+)'; 

$content = ereg_replace($pattern, "\\1", $content); 

print $content; 
 

-Original Message- 
From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED]
 ] 
Sent: Monday, January 21, 2002 2:46 AM 
To: [EMAIL PROTECTED] 
Subject: [PHP] agh - what am I doing wrong - regular expressions 


Good morning everyone, 

I'm trying to adapt existing php code that uses a while loop to scan
content 
for a url pattern, take the matches and add link tags () around them
so 
the url with be made into "hot links. Simple enough right? Nevertheless,
I 
seem to be having trouble with urls that have question marks in them. 

Here is the existing code that works - except with question marks: 

 

$content = " http://www.globalhealth.org/text.php3?id=151
  
adjfladjfajdfkladfjl;kadjf 
jlkadjflkajdflkj jadklfjalkdjfl;df jalkdfj;ldafj"; 

$pattern = " http://(  [\/~_\.0-9A-Za-z#&=-]+)"; 

while(ereg($pattern, $content, $match)){ 
$http_old = $match[0];  
$http = "dubdubdub" . $match[1] . $match[2]; 
$url = "$http";

$content = ereg_replace($http_old, $url, $content); 
}; 

$content = ereg_replace("dubdubdub", " http://  ", $content); 

print $content; 

** 

Here's the same code with the question mark in the pattern variable.
When I 
add the question mark and test the page, my browsers just "hang".
Escaping 
the question mark doesn't seem to help (and I also read that escapes
aren't 
necessary between square brackets]: 

$content = " http://www.globalhealth.org/text.php3?id=151
  
adjfladjfajdfkladfjl;kadjf 
jlkadjflkajdflkj jadklfjalkdjfl;df jalkdfj;ldafj"; 

$pattern = " http://(  [\/~_\.0-9A-Za-z#&=?-]+)"; 

while(ereg($pattern, $content, $match)){ 
$http_old = $match[0];  
$http = "dubdubdub" . $match[1] . $match[2]; 
$url = "$http";

$content = ereg_replace($http_old, $url, $content); 
}; 

$content = ereg_replace("dubdubdub", " http://  ", $content); 

print $content; 


* 

In an attempt to find the problem, I did a test with the following code
and 
received the result I want - which leads me to believe the problem is 
possibly with the while loop or the ereg_replace?? 

$content = " http://www.globalhealth.org/text.php3?id=151
  
adjfladjfajdfkladfjl;kadjf 
jlkadjflkajdflkj jadklfjalkdjfl;df jalkdfj;ldafj"; 

$pattern = " http://(  [/~_.0-9A-Za-z#&=?-]+)"; 

ereg($pattern, $content, $match); 

print "$match[0]"; 

** 

I'm completely confused. I have a feeling there is any easy answer and
if I 
wasn't so frustrated I'd be embarrassed to say that I've spent hours on 
this... 

Thanks in advance for your help, Shawna 

-- 
PHP General 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 General 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] agh - what am I doing wrong - regular expressions

[sgibbs]

Good morning everyone,

I'm trying to adapt existing php code that uses a while loop to scan content
for a url pattern, take the matches and add link tags () around them so
the url with be made into "hot links. Simple enough right? Nevertheless, I
seem to be having trouble with urls that have question marks in them.

Here is the existing code that works - except with question marks:



$content = "http://www.globalhealth.org/text.php3?id=151
adjfladjfajdfkladfjl;kadjf
jlkadjflkajdflkj jadklfjalkdjfl;df jalkdfj;ldafj";

$pattern = "http://([\/~_\.0-9A-Za-z#&=-]+)";

while(ereg($pattern, $content, $match)){
$http_old = $match[0];  
$http = "dubdubdub" . $match[1] . $match[2];
$url = "$http"; 
$content = ereg_replace($http_old, $url, $content); 
};

$content = ereg_replace("dubdubdub", "http://";, $content);

print $content;

**

Here's the same code with the question mark in the pattern variable.  When I
add the question mark and test the page, my browsers just "hang". Escaping
the question mark doesn't seem to help (and I also read that escapes aren't
necessary between square brackets]:

$content = "http://www.globalhealth.org/text.php3?id=151
adjfladjfajdfkladfjl;kadjf
jlkadjflkajdflkj jadklfjalkdjfl;df jalkdfj;ldafj";

$pattern = "http://([\/~_\.0-9A-Za-z#&=?-]+)";

while(ereg($pattern, $content, $match)){
$http_old = $match[0];  
$http = "dubdubdub" . $match[1] . $match[2];
$url = "$http"; 
$content = ereg_replace($http_old, $url, $content); 
};

$content = ereg_replace("dubdubdub", "http://";, $content);

print $content;


*

In an attempt to find the problem, I did a test with the following code and
received the result I want - which leads me to believe the problem is
possibly with the while loop or the ereg_replace??

$content = "http://www.globalhealth.org/text.php3?id=151
adjfladjfajdfkladfjl;kadjf
jlkadjflkajdflkj jadklfjalkdjfl;df jalkdfj;ldafj";

$pattern = "http://([/~_.0-9A-Za-z#&=?-]+)";

ereg($pattern, $content, $match);

print "$match[0]";

**

I'm completely confused. I have a feeling there is any easy answer and if I
wasn't so frustrated I'd be embarrassed to say that I've spent hours on
this...

Thanks in advance for your help, Shawna

-- 
PHP General 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] QUESTION: how to validate credit card number before sent to Versign?

[sgibbs]

We collect credit card info. on our site and send it to Verisign for
processing.  We collect the credit card info. on the last page of our
registration form.  We have about 50% of the credit card numbers declined
because people use dashes in their cc number (even though our directions ask
them not to).

Is there anyway to incorporate the following function so that the dashes
would be stripped out before going directly to Verisign for processing? or
do I need to create a middle page that would validate the credit card info.
before going to Verisign? If the latter is true, then is there a way I can
run this validation "invisibly" - maybe using header(Location:)?





Thanks for your help, Shawna

-- 
PHP General 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] MySQL date and NULL problems

[sgibbs]

Hi again, 

A few days ago, I sent in an inquiry  (see below) about how to make the date
field in mysql read NULL when the corresponding form field was empty. I
tried the suggestions I received and the following if statements all seem to
still result in a default -00-00 instead of NULL.

/ this enters NULL if event_date is empty

if ($event_date == "") $event_date = '\0';

if ($event_date == "") $event_date = "\0";

if ($event_date == "") $event_date = \0;

if ($event_date == "") $event_date = NULL;

if ($event_date == "") $event_date = '\0';

// here's the insert statement
mysql_db_query("$db", "insert into $table (id, 
approved, author, title,
featured, keywords, description, content, type, category, datetime, country,
region, event_date) values(null, '$approved', $author, '$title',
date_add('$datetime', interval $featured day), '$keywords', '$description',
'$content', '$type', '$category', '$datetime', '$country', '$region',
'$event_date')");

I'd really appreciate your suggestions and help. I can work around this
result, but it's really bugging me now why I can't get the word 'NULL' in
the date field when the corresponding form field is empty.

thank you, Shawna

> --
> From: [EMAIL PROTECTED]
> Sent: Tuesday, December 4, 2001 5:31 PM
> To:   [EMAIL PROTECTED]
> Subject:  [PHP] Simple Question: PHP, MySQL, HTML Form and NULL
> 
> I have added a new column in an existing MYSQL table called "event_date"
> -
> type: DATE, Null - yes ;  default - NULL.
> 
> This database field will be filled if and when the field in the HTML form
> is
> complete.   When I added the new field to MySQL, it automatically assigned
> NULL to all the existing records - which is what I wanted it to do.
> 
> I tested the HTML form, and when someone enters a date in the HTML form,
> the
> date appears correctly in the table field.  Perfect.
> 
> Now my question: When the HTML form date field is left blank  and the form
> is submitted, instead of putting "NULL" in the MySQL event_date field, I
> found: -00-00.  Is this because the form is submitting an " " to the
> database field?
> 
> Is there some kind of if/then statement I should use so that when the
> field
> is empty,  "NULL" will be entered into that table field?
> 
> Thank  you, Shawna
> 
> -- 
> PHP General 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 General 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] http referer problems

[sgibbs]

For some reason, the following if  statement isn't working.  Maybe I haven't
had enough coffee to drink or maybe I've had too much - what am I missing?

if ($efa != "nm" || $HTTP_REFERER !=
"http://www.globalhealth.org/news/article.php3?id=1526";){
do this);
}

Thank you, Shawna

-- 
PHP General 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] forms & PHP

[sgibbs]

I think I'm making this harder or more confusing than it really needs to be.

I have a form that is spread out over four pages.  I want to be able to give
the user the opportunity to return to page 1 from page 3, for example, by
providing a regular link on page 3 to return to page1.  When they click on
this link, I want the info. originally entered in page 1 to still be there.

Do I need to use sessions to do this or is there another way?

Thank you, Shawna

-- 
PHP General 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] Simple Question: PHP, MySQL, HTML Form and NULL

[sgibbs]

I have added a new column in an existing MYSQL table called "event_date"  -
type: DATE, NULL default.

This database field will be filled if and when the field in the HTML form is
complete.   When I added the new field to MySQL, it automatically assigned
NULL to all the existing records - which is what I wanted it to do.

I tested the HTML form, and when someone enters a date in the HTML form, the
date appears correctly in the table field.  Perfect.

Now my question: When the HTML form date field is left blank  and the form
is submitted, instead of putting "NULL" in the MySQL event_date field, I
found: -00-00.  Is this because the form is submitting an " " to the
database field?

Is there some kind of if/then statement I should use so that when the field
is empty,  "NULL" will be entered into that table field?

Thank  you, Shawna

-- 
PHP General 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] How to work with MySQL tables WITHOUT telnet, SSH or PhpMyAdmin

[sgibbs]

Our organization has a website that uses PHP and MySQL.  In fact, at least
75% of our webpages are generated dynamically. 

I want to run reports on the current MySQL database, create new databases
and create, copy and alter existing tables.  

Our web host does not support telnet or SSH for its clients and is not
interested in working with PhpMyAdmin at the moment (I think I need their
assistance if I want to use PhpMyAdmin, right?). Is this rather typical of
web hosts?

Can I do the tasks above by designing up a php/web interface from scratch?
Any help/suggestions will be greatly appreciated.

Frustrated in Vermont - Shawna

-- 
PHP General 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] problem pattern matching a url with question mark

[sgibbs]

ah, sorry about the confusion. The url I provided is just an example of a
url containing a question mark for which I'm trying to find a pattern match
in my content text.  


-Original Message-
From: Neil Freeman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 4:16 AM
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] problem pattern matching a url with question mark


Why does your URL contain .asp?

[EMAIL PROTECTED] wrote:

> I found the following code currently used on our website to match a
url
> expression. Unfortunately, when I added a question mark, the webpage
that
> contained the url with the question mark just "hung" and would not
load into
> my browser at all. Currently, the url links only up to the question
mark.
>
> Here's the url I'm trying to get to work:
> http://www.thejakartapost.com/yesterdaydetail.asp?fileid=20011018.G07
>
> Can you look at the code below and tell me what I'm doing wrong?
>
> - Shawna
>
> ORIGINAL CODE
>
> // this will find web addresses and encapsulate each one in a standard
> anchor
>
> while(ereg("http://([\/~_\.0-9A-Za-z#&-]+)", $content, $match)){
> $http_old = $match[0];
> $http = "dubdubdub" . $match[1] . $match[2];
> $url = "$http";
> $content = ereg_replace($http_old, $url, $content);
> };
>
> $content = ereg_replace("dubdubdub", "http://";, $content);
>
> CODE WITH QUESTION MARK
>
> // this will find web addresses and encapsulate each one in a standard
> anchor
>
> while(ereg("http://([\/~_\.0-9A-Za-z#&-?]+)", $content, $match)){
> $http_old = $match[0];
> $http = "dubdubdub" . $match[1] . $match[2];
> $url = "$http";
> $content = ereg_replace($http_old, $url, $content);
> };
>
> $content = ereg_replace("dubdubdub", "http://";, $content);
>
> --
> PHP General 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]
>
> ***
>  This message was virus checked with: SAVI 3.50
>  last updated 23rd October 2001
> ***

--

 Email:  [EMAIL PROTECTED]
 [EMAIL PROTECTED]



-- 
PHP General 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] problem pattern matching a url with question mark

[sgibbs]

I found the following code currently used on our website to match a url
expression. Unfortunately, when I added a question mark, the webpage that
contained the url with the question mark just "hung" and would not load into
my browser at all. Currently, the url links only up to the question mark.

Here's the url I'm trying to get to work:
http://www.thejakartapost.com/yesterdaydetail.asp?fileid=20011018.G07

Can you look at the code below and tell me what I'm doing wrong? 

- Shawna


ORIGINAL CODE

// this will find web addresses and encapsulate each one in a standard
anchor

while(ereg("http://([\/~_\.0-9A-Za-z#&-]+)", $content, $match)){
$http_old = $match[0];  
$http = "dubdubdub" . $match[1] . $match[2];
$url = "$http"; 
$content = ereg_replace($http_old, $url, $content); 
};

$content = ereg_replace("dubdubdub", "http://";, $content);


CODE WITH QUESTION MARK

// this will find web addresses and encapsulate each one in a standard
anchor

while(ereg("http://([\/~_\.0-9A-Za-z#&-?]+)", $content, $match)){
$http_old = $match[0];  
$http = "dubdubdub" . $match[1] . $match[2];
$url = "$http"; 
$content = ereg_replace($http_old, $url, $content); 
};

$content = ereg_replace("dubdubdub", "http://";, $content);

-- 
PHP General 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] Upgrade problems php3 - php4

[sgibbs]

Our ISP is trying to upgrade php and mysql versions on our website.  The
current site works fine using MySQL 3.22.20a and PHP3.

We are able to upload, modify and create new database records with no
problem using webforms to enter test and html.


Now that we are trying to upgrade to MySQL 3.23.36 and PHP4, the uploads,
modifying and creating of new records with text and html no longer works.

Originally, the ISP thought apostrophes were the cause of the new problem
-they tried to adjust for that but it hasn't helped.

Are there any obvious changes in versions that would cause a problem?  I'm
not sure I've provided enough info to help you help me - I can provide some
of the code if there isn't an obvious change that I just don't know about.

Thank you!

Shawna

-- 
PHP General 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] html files with ext .php3 and upgrade to php4

[sgibbs]

We just upgraded to php4 but many of our html files end with the extension
.php3 - will this be a problem?

-- 
PHP General 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] query string - count for records with keywords

[sgibbs]

I'm trying to get a count of the number of records in a database that have
the keyword "cat", for example. Below is the original code; I added the
query with count at the bottom of this code but it doesn't seem to be
working.  I just get a return of "4" which doesn't correspond correctly with
the true number of records (also, I get the same return of "4" regardless of
the keyword I want to search).

All I want to do is put the record number in parantheses next to the
category so that people visiting the site will be able to tell if new
submissions have been added since they last visited.

Am I missing something really obvious? 

Thanks for your help, Shawna



-- 
PHP General 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] change info in database not successful

[sgibbs]

Good day everyone,

I'm writing because the username/password database table we had written for
us does not seem to be accepting  changes to a password.  When I make a
change, not only does the new password not take effect but it disables the
entire account making it useless)

Below is the code from the change.php3 file.  I think the problem is
possibly being caused with the unset() function but I'm not sure

Any ideas?  

Thanks again for your help.  Shawna




-- 
PHP General 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] show number of search results

[sgibbs]

Good day, 

I'm trying to figure out how I can show the following on my search results
page:

SEARCH RESULTS 1 - 10 of 14 total results for books 

Currently, I have a limit of 10 results printing on a page using "offset".
I figured out how to program the pages to know what page of the results its
viewing (eg: you are on page 4 or 10 pages of results) so programming the
above statement shouldn't be difficult because the two statements seem quite
similar.  Nevertheless, I can't figure it out - I have a feeling I'm making
it harder than it really is.  Any suggestions or leads would be greatly
appreciated!

Thank you, Shawna

-- 
PHP General 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] while loop with if statement - here's the code

[sgibbs]

 Thanks Steve! :)  Here's the code:

$title$description\n
\n
";
};

if($results <= 0)
{
print "
NO
RESULTS\n
\n
";

}

?>


-- 
PHP General 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] while loop with if statement - here's the attachment

[sgibbs]

Here's the attachment - I hate it when I do that! :)



-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/20/01 10:25 AM
Subject: [PHP] while loop with if statement

I can't figure out why the if statement isn't working.  The page
displays
the same with or without the if statement. Any idea what I'm doing
wrong?

I attached the code in a word document.

Thank you, Shawna


-- 
PHP General 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 General 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] while loop with if statement

[sgibbs]

I can't figure out why the if statement isn't working.  The page displays
the same with or without the if statement. Any idea what I'm doing wrong?

I attached the code in a word document.

Thank you, Shawna


-- 
PHP General 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] function that will print the url for embedded links

[sgibbs]

I'm looking for a way to have a url for a link "explode" into the actual url
address.  So for example, on a dynamically created webpage, I have a link
called: Contact.  

When someone chooses to view the "printer friendly" version of this page, I
want the link on the the printer-friendly page to change to the following:
"Contact (http://www.web.com/contact.html)".

Any ideas of how to automate this process? 

Thank you, Shawna 

  

-- 
PHP General 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] how to strip just the tag from html file?

[sgibbs]

I've created a "printer-friendly" version of a page (PHP/MySQL) and want to
have just the  tags automatically removed.  I thought about using
strip_tags() but I'm not able to predict what html tags to include as the
exceptions so that they would not be removed too.  How can I do this?  Thank
you!

- Shawna



-- 
PHP General 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]