RE: [PHP-DB] Search engine

2006-09-28 Thread Shaun A Riches
Title: RE: [PHP-DB] Search engine






What about the MySQL LIKE command? Research it.

This is assuming your data is stored properly without redundant data and in a MySQL database.

___
Shaun Riches
Computer Science Student



-Original Message-
From: Ron Piggott (PHP) [mailto:[EMAIL PROTECTED]]
Sent: Thu 28/09/2006 03:44
To: PHP DB
Subject: [PHP-DB] Search engine



___
Shaun Riches
Computer Science Student



-Original Message-
From: Ron Piggott (PHP) [mailto:[EMAIL PROTECTED]]
Sent: Thu 28/09/2006 03:44
To: PHP DB
Subject: [PHP-DB] Search engine

Has anyone wrote a search engine for the web site? I am wondering if
someone has the time to help me walk through doing this. Ron






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

Re: [PHP-DB] Search engine

2006-09-28 Thread Niel Archer
Hi

 What about the MySQL LIKE command? Research it.

An excellent start for searching a db, but did you miss the point of the
question.  He wanted to know if anyone had experience with this to save
him building from the ground up.

I haven't, l so didn't reply

If no other help is forthcoming, you might start by looking at the
Service_Google package on PEAR. At the very least, it should allow you
to have Google search your pages for you.

Niel

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



RE: [PHP-DB] Search engine

2006-09-28 Thread Ron Piggott (PHP)

What I haven't figured out is how to crawl my site.  If I knew how to
crawl my site I could write a basic search engine and develop it over
time.  This is the crucial issue I need help with.  

I have a really basic search engine I wrote last year.  I told my web
site what pages the user could search ... as in I keyed in the URL's 

I am giving my site a face lift and making some serious changes to
it ... I have my database out of date ... I would like to crawl my site
once a day to update what changes I made during the past 24 hours and
delete HTML files which no longer exist.  

If someone knew how to retrieve various a href= then I could start
with something and build on it over time ... 

Ron

On Thu, 2006-09-28 at 11:44 +0100, Shaun A Riches wrote:

 What about the MySQL LIKE command? Research it.
 
 This is assuming your data is stored properly without redundant data
 and in a MySQL database.
 
 ___
 Shaun Riches
 Computer Science Student
 
 
 
 -Original Message-
 From: Ron Piggott (PHP) [mailto:[EMAIL PROTECTED]
 Sent: Thu 28/09/2006 03:44
 To: PHP DB
 Subject: [PHP-DB] Search engine
 
 
 
 ___
 Shaun Riches
 Computer Science Student
 
 
 
 -Original Message-
 From: Ron Piggott (PHP) [mailto:[EMAIL PROTECTED]
 Sent: Thu 28/09/2006 03:44
 To: PHP DB
 Subject: [PHP-DB] Search engine
 
 Has anyone wrote a search engine for the web site?  I am wondering if
 someone has the time to help me walk through doing this.  Ron
 
 
 
 


[PHP-DB] SQL query

2006-09-28 Thread Miguel Guirao


Hello list,

Whats wrong with my SQL query:

$query=select email from usuarios where userName = (select username from
fussv where folio = 'FUSS-130-2006');

I get an error!
I have tested the two individual sentences and they worked OK!

---
Miguel Guirao Aguilera
Logistica R8 TELCEL
Tel. (999) 960.7994


Este mensaje es exclusivamente para el uso de la persona o entidad a quien esta 
dirigido; contiene informacion estrictamente confidencial y legalmente 
protegida, cuya divulgacion es sancionada por la ley. Si el lector de este 
mensaje no es a quien esta dirigido, ni se trata del empleado o agente 
responsable de esta informacion, se le notifica por medio del presente, que su 
reproduccion y distribucion, esta estrictamente prohibida. Si Usted recibio 
este comunicado por error, favor de notificarlo inmediatamente al remitente y 
destruir el mensaje. Todas las opiniones contenidas en este mail son propias 
del autor del mensaje y no necesariamente coinciden con las de Radiomovil 
Dipsa, S.A. de C.V. o alguna de sus empresas controladas, controladoras, 
afiliadas y subsidiarias. Este mensaje intencionalmente no contiene acentos.

This message is for the sole use of the person or entity to whom it is being 
sent.  Therefore, it contains strictly confidential and legally protected 
material whose disclosure is subject to penalty by law.  If the person reading 
this message is not the one to whom it is being sent and/or is not an employee 
or the responsible agent for this information, this person is herein notified 
that any unauthorized dissemination, distribution or copying of the materials 
included in this facsimile is strictly prohibited.  If you received this 
document by mistake please notify  immediately to the subscriber and destroy 
the message. Any opinions contained in this e-mail are those of the author of 
the message and do not necessarily coincide with those of Radiomovil Dipsa, 
S.A. de C.V. or any of its control, controlled, affiliates and subsidiaries 
companies. No part of this message or attachments may be used or reproduced in 
any manner whatsoever.

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



RE: [PHP-DB] SQL query

2006-09-28 Thread Edwin Cruz
Make sure that your second query is returning only one row, if it dont
help, try this:
$query=select email from usuarios where userName in (select username
from fussv where folio = 'FUSS-130-2006')


MySQL think that you second query returns more than 1 row, that's why
mysql dont accept your query, is like trying to compare vs more than one
scalar value

Regards!

++ 
| Ing Edwin Cruz [EMAIL PROTECTED]    | ++ 
| Transportes Medel Rogero SA de CV  | |    | 
| Desk:  +52 (449) 910 30 90 x3054   | ++ 
| MX Mobile: +52 (449) 111 29 03 | 
| Aguascalientes, Mexico | 
| http://www.medel.com.mx    | 
++



 -Mensaje original-
 De: Miguel Guirao [mailto:[EMAIL PROTECTED] 
 Enviado el: Jueves, 28 de Septiembre de 2006 09:09 a.m.
 Para: php-db@lists.php.net
 Asunto: [PHP-DB] SQL query
 
 
 
 
 Hello list,
 
 Whats wrong with my SQL query:
 
 $query=select email from usuarios where userName = (select 
 username from fussv where folio = 'FUSS-130-2006');
 
 I get an error!
 I have tested the two individual sentences and they worked OK!
 
 ---
 Miguel Guirao Aguilera
 Logistica R8 TELCEL
 Tel. (999) 960.7994
 
 
 Este mensaje es exclusivamente para el uso de la persona o 
 entidad a quien esta dirigido; contiene informacion 
 estrictamente confidencial y legalmente protegida, cuya 
 divulgacion es sancionada por la ley. Si el lector de este 
 mensaje no es a quien esta dirigido, ni se trata del empleado 
 o agente responsable de esta informacion, se le notifica por 
 medio del presente, que su reproduccion y distribucion, esta 
 estrictamente prohibida. Si Usted recibio este comunicado por 
 error, favor de notificarlo inmediatamente al remitente y 
 destruir el mensaje. Todas las opiniones contenidas en este 
 mail son propias del autor del mensaje y no necesariamente 
 coinciden con las de Radiomovil Dipsa, S.A. de C.V. o alguna 
 de sus empresas controladas, controladoras, afiliadas y 
 subsidiarias. Este mensaje intencionalmente no contiene acentos.
 
 This message is for the sole use of the person or entity to 
 whom it is being sent.  Therefore, it contains strictly 
 confidential and legally protected material whose disclosure 
 is subject to penalty by law.  If the person reading this 
 message is not the one to whom it is being sent and/or is not 
 an employee or the responsible agent for this information, 
 this person is herein notified that any unauthorized 
 dissemination, distribution or copying of the materials 
 included in this facsimile is strictly prohibited.  If you 
 received this document by mistake please notify  immediately 
 to the subscriber and destroy the message. Any opinions 
 contained in this e-mail are those of the author of the 
 message and do not necessarily coincide with those of 
 Radiomovil Dipsa, S.A. de C.V. or any of its control, 
 controlled, affiliates and subsidiaries companies. No part of 
 this message or attachments may be used or reproduced in any 
 manner whatsoever.
 
 -- 
 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] Search engine

2006-09-28 Thread Jeffrey
Truth be told, Google's free slap-it-on-your-web site search tool 
(http://www.google.com/services/websearch.html) will do everything you 
want and save you a lot of coding. Assuming this is for 
actsministries.org which seems to be a useful resource of information; 
it is probably well indexed by Google and updates will be reflected 
reasonably quickly. On my most popular site, which is sort of a 
resource, Google is usually 24-48 hours behind changes.


Doing your own search coding is best when you want to allow users to 
search data in a database (rather than on web pages).


Good luck,

Jeffrey

Ron Piggott (PHP) wrote:

What I haven't figured out is how to crawl my site.  If I knew how to
crawl my site I could write a basic search engine and develop it over
time.  This is the crucial issue I need help with.  


I have a really basic search engine I wrote last year.  I told my web
site what pages the user could search ... as in I keyed in the URL's 


I am giving my site a face lift and making some serious changes to
it ... I have my database out of date ... I would like to crawl my site
once a day to update what changes I made during the past 24 hours and
delete HTML files which no longer exist.  


If someone knew how to retrieve various a href= then I could start
with something and build on it over time ... 


Ron

On Thu, 2006-09-28 at 11:44 +0100, Shaun A Riches wrote:



What about the MySQL LIKE command? Research it.

This is assuming your data is stored properly without redundant data
and in a MySQL database.

___
Shaun Riches
Computer Science Student



-Original Message-
From: Ron Piggott (PHP) [mailto:[EMAIL PROTECTED]
Sent: Thu 28/09/2006 03:44
To: PHP DB
Subject: [PHP-DB] Search engine



___
Shaun Riches
Computer Science Student



-Original Message-
From: Ron Piggott (PHP) [mailto:[EMAIL PROTECTED]
Sent: Thu 28/09/2006 03:44
To: PHP DB
Subject: [PHP-DB] Search engine

Has anyone wrote a search engine for the web site?  I am wondering if
someone has the time to help me walk through doing this.  Ron









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



RE: [PHP-DB] SQL query

2006-09-28 Thread Dwight Altman
Check your version.  Subselects were only added in MySQL Version 4.1.

Regards,
Dwight

 -Original Message-
 From: Edwin Cruz [mailto:[EMAIL PROTECTED]
 Sent: Thursday, September 28, 2006 10:53 AM
 To: 'Miguel Guirao'; php-db@lists.php.net
 Subject: RE: [PHP-DB] SQL query
 
 Make sure that your second query is returning only one row, if it dont
 help, try this:
 $query=select email from usuarios where userName in (select username
 from fussv where folio = 'FUSS-130-2006')
 
 
 MySQL think that you second query returns more than 1 row, that's why
 mysql dont accept your query, is like trying to compare vs more than one
 scalar value
 
 Regards!
 
 ++
 | Ing Edwin Cruz [EMAIL PROTECTED]    | ++
 | Transportes Medel Rogero SA de CV  | |    |
 | Desk:  +52 (449) 910 30 90 x3054   | ++
 | MX Mobile: +52 (449) 111 29 03 |
 | Aguascalientes, Mexico |
 | http://www.medel.com.mx    |
 ++
 
 
 
  -Mensaje original-
  De: Miguel Guirao [mailto:[EMAIL PROTECTED]
  Enviado el: Jueves, 28 de Septiembre de 2006 09:09 a.m.
  Para: php-db@lists.php.net
  Asunto: [PHP-DB] SQL query
 
 
 
 
  Hello list,
 
  Whats wrong with my SQL query:
 
  $query=select email from usuarios where userName = (select
  username from fussv where folio = 'FUSS-130-2006');
 
  I get an error!
  I have tested the two individual sentences and they worked OK!
 
  ---
  Miguel Guirao Aguilera
  Logistica R8 TELCEL
  Tel. (999) 960.7994
 
 
  Este mensaje es exclusivamente para el uso de la persona o
  entidad a quien esta dirigido; contiene informacion
  estrictamente confidencial y legalmente protegida, cuya
  divulgacion es sancionada por la ley. Si el lector de este
  mensaje no es a quien esta dirigido, ni se trata del empleado
  o agente responsable de esta informacion, se le notifica por
  medio del presente, que su reproduccion y distribucion, esta
  estrictamente prohibida. Si Usted recibio este comunicado por
  error, favor de notificarlo inmediatamente al remitente y
  destruir el mensaje. Todas las opiniones contenidas en este
  mail son propias del autor del mensaje y no necesariamente
  coinciden con las de Radiomovil Dipsa, S.A. de C.V. o alguna
  de sus empresas controladas, controladoras, afiliadas y
  subsidiarias. Este mensaje intencionalmente no contiene acentos.
 
  This message is for the sole use of the person or entity to
  whom it is being sent.  Therefore, it contains strictly
  confidential and legally protected material whose disclosure
  is subject to penalty by law.  If the person reading this
  message is not the one to whom it is being sent and/or is not
  an employee or the responsible agent for this information,
  this person is herein notified that any unauthorized
  dissemination, distribution or copying of the materials
  included in this facsimile is strictly prohibited.  If you
  received this document by mistake please notify  immediately
  to the subscriber and destroy the message. Any opinions
  contained in this e-mail are those of the author of the
  message and do not necessarily coincide with those of
  Radiomovil Dipsa, S.A. de C.V. or any of its control,
  controlled, affiliates and subsidiaries companies. No part of
  this message or attachments may be used or reproduced in any
  manner whatsoever.
 
  --
  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] SQL query

2006-09-28 Thread Miguel Guirao
OK, this makes my day clear!!
I have versión 3.23.49-3 of MySQL

Thanks Dwight!

-Original Message-
From: Dwight Altman [mailto:[EMAIL PROTECTED]
Sent: Jueves, 28 de Septiembre de 2006 11:32 a.m.
To: php-db@lists.php.net
Subject: RE: [PHP-DB] SQL query


Check your version.  Subselects were only added in MySQL Version 4.1.

Regards,
Dwight

 -Original Message-
 From: Edwin Cruz [mailto:[EMAIL PROTECTED]
 Sent: Thursday, September 28, 2006 10:53 AM
 To: 'Miguel Guirao'; php-db@lists.php.net
 Subject: RE: [PHP-DB] SQL query

 Make sure that your second query is returning only one row, if it dont
 help, try this:
 $query=select email from usuarios where userName in (select username
 from fussv where folio = 'FUSS-130-2006')


 MySQL think that you second query returns more than 1 row, that's why
 mysql dont accept your query, is like trying to compare vs more than one
 scalar value

 Regards!

 ++
 | Ing Edwin Cruz [EMAIL PROTECTED]    | ++
 | Transportes Medel Rogero SA de CV  | |    |
 | Desk:  +52 (449) 910 30 90 x3054   | ++
 | MX Mobile: +52 (449) 111 29 03 |
 | Aguascalientes, Mexico |
 | http://www.medel.com.mx    |
 ++



  -Mensaje original-
  De: Miguel Guirao [mailto:[EMAIL PROTECTED]
  Enviado el: Jueves, 28 de Septiembre de 2006 09:09 a.m.
  Para: php-db@lists.php.net
  Asunto: [PHP-DB] SQL query
 
 
 
 
  Hello list,
 
  Whats wrong with my SQL query:
 
  $query=select email from usuarios where userName = (select
  username from fussv where folio = 'FUSS-130-2006');
 
  I get an error!
  I have tested the two individual sentences and they worked OK!
 
  ---
  Miguel Guirao Aguilera
  Logistica R8 TELCEL
  Tel. (999) 960.7994
 
 
  Este mensaje es exclusivamente para el uso de la persona o
  entidad a quien esta dirigido; contiene informacion
  estrictamente confidencial y legalmente protegida, cuya
  divulgacion es sancionada por la ley. Si el lector de este
  mensaje no es a quien esta dirigido, ni se trata del empleado
  o agente responsable de esta informacion, se le notifica por
  medio del presente, que su reproduccion y distribucion, esta
  estrictamente prohibida. Si Usted recibio este comunicado por
  error, favor de notificarlo inmediatamente al remitente y
  destruir el mensaje. Todas las opiniones contenidas en este
  mail son propias del autor del mensaje y no necesariamente
  coinciden con las de Radiomovil Dipsa, S.A. de C.V. o alguna
  de sus empresas controladas, controladoras, afiliadas y
  subsidiarias. Este mensaje intencionalmente no contiene acentos.
 
  This message is for the sole use of the person or entity to
  whom it is being sent.  Therefore, it contains strictly
  confidential and legally protected material whose disclosure
  is subject to penalty by law.  If the person reading this
  message is not the one to whom it is being sent and/or is not
  an employee or the responsible agent for this information,
  this person is herein notified that any unauthorized
  dissemination, distribution or copying of the materials
  included in this facsimile is strictly prohibited.  If you
  received this document by mistake please notify  immediately
  to the subscriber and destroy the message. Any opinions
  contained in this e-mail are those of the author of the
  message and do not necessarily coincide with those of
  Radiomovil Dipsa, S.A. de C.V. or any of its control,
  controlled, affiliates and subsidiaries companies. No part of
  this message or attachments may be used or reproduced in any
  manner whatsoever.
 
  --
  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] Re: Search engine

2006-09-28 Thread Ron Piggott
Part of why I want to do this is for the programming experience.  This
is why I didn't implement the google solution already.  Ron

On Wed, 2006-09-27 at 22:44 -0400, Ron Piggott (PHP) wrote:

 Has anyone wrote a search engine for the web site?  I am wondering if
 someone has the time to help me walk through doing this.  Ron

-- 
[EMAIL PROTECTED]
www.actsministrieschristianevangelism.org

Acts Ministries Christian Evangelism
Where People Matter
12 Burton Street
Belleville, Ontario, Canada K8P 1E6

In Belleville Phone: (613) 967-0032
In North America Toll Free: (866) ACTS-MIN


[PHP-DB] two versions of php on same box, on has mysql support the other can't find it?

2006-09-28 Thread Eddie Peloke

I have two php versions on one server.  One of them has mysql support, the
other has mssql support and is used to run scripts via the comand line.  I
am trying now to compile in mysql support to the command line one and I keep
getting:

configure: error: Cannot find MySQL header files under yes.

checking for specified location of the MySQL UNIX socket... no
checking for MySQL UNIX socket location... no
configure: error: Cannot find MySQL header files under /usr/lib/php/modules.
Note that the MySQL client library is not bundled anymore!


I've tried a few directories.  I chose this last one because there was a
mysql.so and libmysql.so file in there.  I must have it as the other version
has support.

Thanks!!!

Here is my config:

./configure '--with-mysql=/usr' '--with-mssql=/usr/local'
'--disable-libxml' '--disable-dom' '--disable-simplexml' '--disable-xml'
'--disable-xmlreader' '--disable-xmlwriter' '--without-pear'


Here is the config from the working version yet I don't know how it works as
it says --no mysql
../configure' '--build=i386-redhat-linux' '--host=i386-redhat-linux'
'--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr'
'--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin'
'--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include'
'--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var'
'--sharedstatedir=/usr/com' '--mandir=/usr/share/man'
'--infodir=/usr/share/info' '--cache-file=../config.cache'
'--with-libdir=lib' '--with-config-file-path=/etc'
'--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic'
'--disable-rpath' '--with-bz2' '--with-curl' '--with-exec-dir=/usr/bin'
'--with-freetype-dir=/usr' '--with-png-dir=/usr' '--enable-gd-native-ttf'
'--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv'
'--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell'
'--with-expat-dir=/usr' '--with-pcre-regex=/usr' '--with-zlib'
'--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes'
'--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg'
'--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx'
'--with-pear=/usr/share/pear' '--with-kerberos' '--enable-ucd-snmp-hack'
'--with-unixODBC=shared,/usr' '--enable-memory-limit' '--enable-shmop'
'--enable-calendar' '--enable-dbx' '--enable-dio'
'--with-mime-magic=/etc/httpd/conf/magic' '--without-sqlite'
'--with-libxml-dir=/usr' '--with-xml' '--with-apxs2=/usr/sbin/apxs'
'--without-mysql' '--without-gd' '--without-odbc' '--disable-dom'
'--disable-dba'


[PHP-DB] two versions of php on same box, on has mysql support the other can't find it?

2006-09-28 Thread Peloke

I have two php versions on one server.  One of them has mysql support, the
other has mssql support and is used to run scripts via the comand line.  I
am trying now to compile in mysql support to the command line one and I keep
getting:

configure: error: Cannot find MySQL header files under yes.

checking for specified location of the MySQL UNIX socket... no
checking for MySQL UNIX socket location... no
configure: error: Cannot find MySQL header files under /usr/lib/php/modules.

Note that the MySQL client library is not bundled anymore!


I've tried a few directories.  I chose this last one because there was a
mysql.so and libmysql.so file in there.  I must have it as the other version
has support.

Thanks!!!

Here is my config:

./configure '--with-mysql=/usr' '--with-mssql=/usr/local'
'--disable-libxml' '--disable-dom' '--disable-simplexml' '--disable-xml'
'--disable-xmlreader' '--disable-xmlwriter' '--without-pear'


Here is the config from the working version yet I don't know how it works as
it says --no mysql
./configure' '--build=i386-redhat-linux' '--host=i386-redhat-linux'
'--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr'
'--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin'
'--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include'
'--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var'
'--sharedstatedir=/usr/com' '--mandir=/usr/share/man'
'--infodir=/usr/share/info' '--cache-file=../config.cache'
'--with-libdir=lib' '--with-config-file-path=/etc'
'--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic'
'--disable-rpath' '--with-bz2' '--with-curl' '--with-exec-dir=/usr/bin'
'--with-freetype-dir=/usr' '--with-png-dir=/usr' '--enable-gd-native-ttf'
'--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv'
'--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell'
'--with-expat-dir=/usr' '--with-pcre-regex=/usr' '--with-zlib'
'--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes'
'--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg'
'--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx'
'--with-pear=/usr/share/pear' '--with-kerberos' '--enable-ucd-snmp-hack'
'--with-unixODBC=shared,/usr' '--enable-memory-limit' '--enable-shmop'
'--enable-calendar' '--enable-dbx' '--enable-dio'
'--with-mime-magic=/etc/httpd/conf/magic' '--without-sqlite'
'--with-libxml-dir=/usr' '--with-xml' '--with-apxs2=/usr/sbin/apxs'
'--without-mysql' '--without-gd' '--without-odbc' '--disable-dom'
'--disable-dba'p


[PHP-DB] Searching PHP strings

2006-09-28 Thread Ron Piggott (PHP)
I have been playing tonight for a few minutes.

The following code:

?

$lineArray = file(/home/actsmin/www/home_page.html);

// make an empty variable first
$content =  ;

// concat all array element
foreach($lineArray as $eachLine) {

if ( eregi(a href= , $eachLine) == 1 ) {

#line contains a link

echo strlen(stristr($eachLine, a href=)) . \r\n;
echo trim(stristr($eachLine, a href=)) . \r\n;

}

$content .= $eachLine;
}

?

Produces me output like:

137

a 
href=http://www.actsministrieschristianevangelism.org/christianliving/quiet_time_quotations_and_reflection_topics.html;here/a.p

What I want to do now is to remove the 

a href= 

and just be left with 

http://www.actsministrieschristianevangelism.org/christianliving/quiet_time_quotations_and_reflection_topics.html

and remove all the text which follows this --- On this line it is

here/a.p

Would someone help me do this?

Ron


RE: [PHP-DB] Searching PHP strings

2006-09-28 Thread Bastien Koert

eregi_replace or str_replace can do that for you

Bastien



From: Ron Piggott (PHP) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Searching PHP strings
Date: Thu, 28 Sep 2006 21:12:18 -0400

I have been playing tonight for a few minutes.

The following code:

?

$lineArray = file(/home/actsmin/www/home_page.html);

// make an empty variable first
$content =  ;

// concat all array element
foreach($lineArray as $eachLine) {

if ( eregi(a href= , $eachLine) == 1 ) {

#line contains a link

echo strlen(stristr($eachLine, a href=)) . \r\n;
echo trim(stristr($eachLine, a href=)) . \r\n;

}

$content .= $eachLine;
}

?

Produces me output like:

137

a 
href=http://www.actsministrieschristianevangelism.org/christianliving/quiet_time_quotations_and_reflection_topics.html;here/a.p


What I want to do now is to remove the

a href=

and just be left with

http://www.actsministrieschristianevangelism.org/christianliving/quiet_time_quotations_and_reflection_topics.html

and remove all the text which follows this --- On this line it is

here/a.p

Would someone help me do this?

Ron


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



[PHP-DB] I still have a bit more of the string to get rid of ...

2006-09-28 Thread Ron Piggott (PHP)
Where '$eachLine' is a line of HTML code the following command

echo str_replace(a href=\, , trim(stristr($eachLine, a
href=))) . \r\n;

give me this result:

http://www.actsministrieschristianevangelism.org/christianliving/quiet_time_quotations_and_reflection_topics.html;here.

I want to get rid of everything including and following the  

What do I do next?


RE: [PHP-DB] I still have a bit more of the string to get rid of ...

2006-09-28 Thread Bastien Koert


same again on the back end

Bastien


From: Ron Piggott (PHP) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED]
CC: PHP DB php-db@lists.php.net
Subject: [PHP-DB] I still have a bit more of the string to get rid of ...
Date: Thu, 28 Sep 2006 22:13:59 -0400

Where '$eachLine' is a line of HTML code the following command

echo str_replace(a href=\, , trim(stristr($eachLine, a
href=))) . \r\n;

give me this result:

http://www.actsministrieschristianevangelism.org/christianliving/quiet_time_quotations_and_reflection_topics.html;here.

I want to get rid of everything including and following the 

What do I do next?


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